ZAHID AHMED
Brooklyn,NY
Summary
Dynamic ETL Developer practiced in helping companies with diverse transitioning, including sensitive telecom data, finance data and massive data warehouse batch processing. Promotes extensive simulation and testing to provide smooth ETL execution. Known for providing quick, effective tools to automate and optimize database management tasks.
Expert in using various ETL tools IBM InfoSphere Data Stage, Informatica, MS SQL server Management Studio(SSIS packages), Talend, Pentaho.
Overview
11
11
years of professional experience
4
4
years of post-secondary education
Work History
ETL Consultant
Guest Worldwide Sysco
05.2023 - Current
- Worked on automation of Financial data of UPS and GPO clients using Visual Studio, Microsoft SQL Server Management Studio and phocas to provide L2 support.
- Performing daily batch operations of financial data of Sysco using Microsoft SQL Server Management Studio from PeopleSoft and other files.
- Perform end -to-end financial data loading to meet operational SLAs.
- Design, development, automation, and support of complex applications to extract, transform, and load data.
- Ensured data quality of the warehouse and data marts.
- Plans and conducts ETL unit and development tests.
- Monitored result and takes corrective action.
- Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds.
ETL Consultant
Omega FinTech
11.2022 - 04.2023
- Worked for client Johnson and Johnson to fetch financial data from SAP using PeopleSoft then apply machine learning techniques
- Used Microsoft Access to provide finance information from source databases to the presentation layer for business teams
- Build, maintain, and enhance all objects packages/functions in PL/SQL to support the application process
- Translates transformation and movement requirements into functional requirements and mapping designs
- Designs automation processes to control data access, transformation, and movement
- Ensures source data availability and update accessibility, data integrity, restart ability, and error handling
- Participates in the overall development process via architecture guidance, design and code reviews, and estimation and planning assistance
- Performs other related duties as required Knowledge, Skills, And Abilities
- Documents and troubleshoot problems and effectively communicate with business and technical team members at all levels.
ETL Consultant
Kyndryl
10.2021 - 10.2022
- Proficiency in data warehousing techniques for Slowly Changing Dimensions, Surrogate key assignment and Change Capture
- Used Data Stage Manager to import/export data Stage projects and jobs to define table definition in repository
- Expertise in Data Migration and Upgrading
- Proven track record in troubleshooting of DataStage Jobs and addressing production issues
- Performed migration of ETL projects from IBM servers to Kyndryl environment using IBM InfoSphere DataStage 11.7
- Development of ETL streams in existing DWH complex batches
- Provided L2 support for IBM InfoSphere DataStage servers with the support team
- Reduced ETL data loading time by modifying architecture of DWH batch in InfoSphere DataStage 11.7 designer client.
ETL Consultant
IBM
09.2019 - 09.2021
- Expert Level experience in DataStage Client components – DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator plus L2 support
- Extensively made use of all stages Aggregator, Sort, Merge, Join, Change Capture, Peek stages in Parallel Extender job
- Developed ETL jobs using IBM InfoSphere DataStage 9.1 to serve as a data source for Cognos reports from heterogeneous sources
- Performed monthly loading of CHIP and SODA projects to facilitate cross teams to observe region wise revenue of IBM from various projects
- Migration of various ETL projects from IBM InfoSphere DataStage 9.1 to IBM InfoSphere DataStage 11.7
- Documented ETLs data flow logic and performed automation of the CDH batches.
ETL Pentaho Developer
Stella Technology, Inc.
09.2017 - 06.2019
- Developed web application using Couchbase and ETL tools (Talend, Pentaho) to provide health care revenue figures to the business team at the presentation layer in JSON format
- Worked on ETL pipelines using Pentaho Data Integration components including jobs, transformations, filters, error logs and rejected streams and transferred data in PostgreSQL database
- Developed complex mappings from varied transformation logic and used various components like tMap, tDie, tUnique, tParallelize, tSendmail, tFlowToIterate, tSort, tFilterRow in designing jobs in Talend Open Studio
- Extensive experience in developing strategies for Extraction, Transformation, loading (ETL) data from various sources into data warehouses.
Software Engineer II
S&P Global Market Intelligence (Fortune 500)
06.2016 - 04.2017
- Worked with the USA insurance clients processing automation and fixed bugs in ETL systems using Informatica, Microsoft SQL server management studio and documentation of ETL batches as well
- Migration of MSSQL databases from legacy to upgraded environment which included data validation and reconciliation of data
- Migration of Informatica projects from legacy to new repository
- Development of a data dictionary for the clients (insurance companies) which included formulas to calculate measures in the fact table in each stage of ETL
- Batch operations of revenue and claims of insurance client's data using Informatica Power Center.
Executive Data Warehouse Operations
Warid Telecom
05.2014 - 06.2016
- Excellent experience in Relational Database (RDBMS), Oracle 11g, Microsoft SQL Server, Netezza, IBMDB2, SQL, PL/SQL, TOAD to provide L2 support of the whole DWH architecture
- Expertise in operating UNIX shell scripts and hands on experience with scheduling of shell scripts using IBM Infosphere DataStage
- Used Datastage Director to debug, validate, schedule, run and monitor jobs
- Converted complex job designs to different job segments and executed through job sequencers for better performance and easy maintenance
- Developed and monitored ETL batches for IBM Cognos reporting tool to customize cubes of analysis area of data warehouse as per business users and UNICA campaign management system requirements.
Officer Data Warehouse Operations
Warid Telecom
05.2013 - 05.2014
- Strong knowledge of data warehouse architecture in designing Star Schema, Snowflake Schema, FACT and Dimensional Tables and involved in performance tuning of ETL programs
- Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts
- Key responsibilities were to reconcile data loaded in Netezza database (development phase data warehouse) with oracle database (legacy system) in Microsoft Excel on a daily basis to match revenue generated by the organization
- Data reconciliation of data warehouse with legacy system to ensure ongoing automated system has been performing better than old one.
Education
Bachelor of Information Technology -
National University of Sciences & Technology (NUST-SEECS)
NUST-SEECS 2007.09 - 2011.08
Skills
- SQL Programming
- Data Warehousing Management
- Database Design
- Performance Tuning
- Data Cleansing
- Change Management
- Data Validation
- Data Transformation
- Data Integration
- Project Management
- Data Extraction
- Data Loading
Timeline
ETL Consultant
Guest Worldwide Sysco
05.2023 - Current
ETL Consultant
Omega FinTech
11.2022 - 04.2023
ETL Consultant
Kyndryl
10.2021 - 10.2022
ETL Consultant
IBM
09.2019 - 09.2021
ETL Pentaho Developer
Stella Technology, Inc.
09.2017 - 06.2019
Software Engineer II
S&P Global Market Intelligence (Fortune 500)
06.2016 - 04.2017
Executive Data Warehouse Operations
Warid Telecom
05.2014 - 06.2016
Officer Data Warehouse Operations
Warid Telecom
05.2013 - 05.2014
Bachelor of Information Technology -
National University of Sciences & Technology (NUST-SEECS)
2007.09 - 2011.08
Similar Profiles
Tyree NicholasTyree Nicholas
Inventory Analyst at Sysco Guest SupplyInventory Analyst at Sysco Guest Supply
Timothy RossTimothy Ross
Sales Consultant at Sysco Guest SupplySales Consultant at Sysco Guest Supply
Kendley JeanKendley Jean
Forklift Operator at Sysco Guest SupplyForklift Operator at Sysco Guest Supply