Muhammad Jamal
Columbia,MD
Summary
Results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Devops Analyst
Tokia carbon CB Ltd.
03.2019 - 05.2021
- Formulate the project design based on the requirements received from the analysts in SEC
- Implemented ETL Informatica mappings and processes for loading data from the sources to the target
- Played a key role in day to day production support of the Informatica batch runs
- Handled the capacity of team and assigned the task based on priorities
- Deployed ETL components code into multiple environments as per the approval received
- Followed the required client security policies and required approvals to move the code from one environment to another.
ETL Informatica Consultant
GM Financial
05.2018 - 08.2020
- Communicate with business owner on a frequent basis for requirement gathering and analysis
- Formulate the project design based on the requirements gathered
- Worked closely with Business and Analytics team to gather the requirements
- Developed source to target mapping documents to support ETL process
- Developed ETL processes using Informatica PowerCenter to upsert data in snowflake database from Exadata
- Created views joining the multiple tables to support the business requirement
- Created Informatica mappings to load the data from oracle into Snowflake application
- Hands on experience in querying Snowflake database using snow SQL queries
- Created data dictionary for all the columns to support the analytics team
- Created JIL Scripts to schedule jobs on Autosys
- Responsible for production support activities includes but not limited to monitoring the jobs
- Provide rotation on-call support of the nightly processing
- Interacting with Business Analysts to understand the requirements
- Analyzing the requirements and preparing design
- Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
Education
Bachelor's - Computer Science
University Of Maryland
Skills
- ETL Tools Informatica Power Center 91/8611/712/62/61/51, Power Mart 50/47, Dataware House Builder, Abintio
- Operating Systems Windows XP/2000/NT/98/95, Windows 2003 server, Unix, MSDOS
- Data Modeling Erwin 414/352
- Data Base Tools SQL Loader, Toad 403, MS Visio, MS Access
- Reporting Tools Business Objects XI/6x/5x, OBIEE 10x/9x; Power play and Transformer
- Web Technology HTML, Java script
- Connectors AWS, workday
- Utilities: TOAD, SQL Developer
Certification
AWS Certified Solutions Architect - Professional, 02/2022, 02/2024
Timeline
Devops Analyst
Tokia carbon CB Ltd.
03.2019 - 05.2021
ETL Informatica Consultant
GM Financial
05.2018 - 08.2020
Bachelor's - Computer Science
University Of Maryland