Usman Shariff Mohamed
Houston,TX
Summary
- Results-oriented Data Professional with 8 years of IT experience in Systems Analysis, Application Design, and ETL processes. Proficient in SQL, Python, and cloud technologies, with extensive expertise in Informatica PowerCenter and various database systems including Oracle, DB2, and Teradata. Demonstrated ability to design, develop, and optimize scalable data architectures and pipelines, ensuring data integrity and supporting informed decision-making. Strong collaborator with proven track record in managing projects and delivering reliable solutions in dynamic environments.
Overview
9
9
years of professional experience
Work History
Data Engineer / ETL Developer / Cloud Migration Specialist
Conoco Philips
03.2023 - Current
- Achieved 40% improved query performance through SQL Server to Snowflake migration.
- Orchestrated ETL workflows in Informatica IICS, integrating diverse data sources effectively.
- Automated data ingestion and transformation using Apache Airflow pipelines.
- Reduced operational overhead by migrating legacy systems to cloud architecture.
- Optimized Snowflake performance through clustering, caching, and query profiling tools.
- Developed reusable IICS components for scalable data integration across business units.
Sr. ETL Developer
University Of Maryland
11.2021 - 12.2022
- Gathered and implemented business user requirements in collaboration with offshore teams.
- Established referential integrity by interpreting data models for business users.
- Enhanced existing data warehouse solutions using Informatica and Snowflake efficiently.
- Designed ETL processes in IICS to load data into Snowflake cloud database.
- Integrated on-premise and cloud databases using Informatica Cloud Services effectively.
- Executed data migration and clean-up processes for multiple sources into data warehouse.
Sr. ETL Developer
Nabors oil an gas
01.2019 - 10.2021
- Enhanced data warehouse by translating business needs into technical specifications.
- Boosted project collaboration by engaging technical, functional, and business stakeholders.
- Optimized backend processes using SQL scripts for robust data integrity verification.
- Developed dynamic reports and dashboards using advanced MicroStrategy reporting tools.
- Improved data transformation efficiency across traditional and cloud-based databases.
- Streamlined AWS S3 data loads using Informatica Cloud integrations.
- Created comprehensive integration designs for Workday using IICS.
- Designed sophisticated ETL mappings to extract and transform data from diverse sources.
- Facilitated seamless file transfers from legacy systems to ETL servers.
- Migrated Data Stage mappings to ETL, improving system efficiency.
- Automated workflow tasks and scheduling to enhance process management.
- Enhanced data flow analysis using debugging for optimized source-target interactions.
- Tuned SQL queries to reduce disk I/O and optimize database performance.
- Validated sales force data integrity within the force.com application.
INFORMATICA DEVELOPER/ADMINISTRATOR
Mutual of Omaha
02.2018 - 01.2019
- Designed Informatica applications based on thorough understanding of business requirements.
- Developed mappings in Power Center to extract data from AS400 to Oracle.
- Created IICS jobs for SFDC, Oracle files, and Workday XML targets.
- Configured mapping tasks in IICS for seamless data integration into SFDC.
- Streamlined ETL coding from high-level design specs to mapping standards.
- Utilized various transformations to load data into target Data Mart efficiently.
Informatica Developer/Administrator
BRITISH PETROLEUM(Lubricants)
02.2017 - 01.2018
- Streamlined BP Lubricants data migration to SAP ECC for enhanced efficiency.
- Collaborated with analysts to gather business requirements for enterprise data warehouse.
- Facilitated communication among technical and business stakeholders throughout project lifecycle.
- Created Teradata SET and MULTI SET tables for optimized data storage.
- Implemented UPI and SUPI in Teradata to establish unique data identities.
- Enhanced Teradata performance by restricting dashboard queries for faster retrieval.
- Utilized HASHAMP() to monitor AMPS usage in Teradata environment.
- Employed FALLBACK in Teradata table creation to prevent AMP failures.
- Migrated customer data from MySQL to Hadoop via SQOOP component.
- Established connections for SFDC, Oracle EBS, and S3 in IICS.
- Developed various Hadoop Framework layers, including HDFS, Pig, and Hive.
- Executed extensive SQL programming for backend functions and data integrity checks.
- Authored PL/SQL scripts for stored procedures, triggers, and security implementations.
- Optimized data transformation processes in Hadoop and Big Data environments.
- Designed complex INFORMATICA mappings incorporating diverse transformations and data sources.
- Created workflows with various tasks to automate data processing and management.
Education
Brain Bench Certified - Data warehousing Concepts
Bachelor of Technology - undefined
Certified - Data Warehousing Concepts
High School Diploma -
Alameen College of Pharmacy
Bangalore India07-1995
Skills
- Data Modeling: ERwin 72/41/43/52, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimension Tables, IICS
- Data Warehousing: Informatica PowerCenter 102/101/91/861/86/85/81/811/7x, TIDAL, Control M, Maestro, Golden Gate CDC, Informatica PowerExchange CDC
- Databases: Oracle 12c/11g/10g/9i, SSIS, MS SQL Server 2000, IBM DB2, MS Access 70, Teradata V2R4/V2R5/V2R6/V12R12, Netezza
- Programming: SQL, Transact SQL, PL/SQL, T-SQL, Unix Shell Scripting, JAVA
- Environment: Informaticapower Center (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplets, Transformations, workflow Manager, workflow Monitor) informatica Intelligent Cloud Services (IICS) Oracle 10g, snowflake, SQL, Windows and SQL Server
- ETL development
- Data warehousing
- Data modeling
- Data migration
- Big data processing
- Scripting languages
- Performance tuning
- SQL expertise
- Machine learning
- Data governance
- Real-time analytics
- NoSQL databases
- Data security
- Data quality assurance
- Data curating
- Data integration
- Data pipeline control
- SQL and databases
- SQL programming
- Data analysis
- Database design
- Relational databases
- SQL transactional replications
- Data analytics
- Problem-solving
- Teamwork and collaboration
- Interpersonal communication
- Excellent communication
- Organizational skills
- Relationship building
- Data acquisitions
- Written communication
- Attention to detail
- Teamwork
- Problem-solving abilities
- Team collaboration
- Self motivation
- Data-driven decision making
- Interpersonal skills
- Goal setting
- Professionalism
- Project management
- Agile methodologies
- Cloud computing
- Pattern recognition
Profile
- 8 years of total IT experience
- 8 years of strong ETL experience
- 6 years of Dimension Data Modeling experience
- 4 years of experience using Oracle
- 2 years of experience using Teradata
- 5 years of experience using Snowflake
- 4 years of experience using IICS
Timeline
Data Engineer / ETL Developer / Cloud Migration Specialist
Conoco Philips
03.2023 - Current
Sr. ETL Developer
University Of Maryland
11.2021 - 12.2022
Sr. ETL Developer
Nabors oil an gas
01.2019 - 10.2021
INFORMATICA DEVELOPER/ADMINISTRATOR
Mutual of Omaha
02.2018 - 01.2019
Informatica Developer/Administrator
BRITISH PETROLEUM(Lubricants)
02.2017 - 01.2018
Bachelor of Technology - undefined
Certified - Data Warehousing Concepts
Brain Bench Certified - Data warehousing Concepts
High School Diploma -
Alameen College of Pharmacy