Senion BI Consultant

• May 2023 - Present

Team Lead

• Apr 2021 - Aug 2023

o Leading the DataStage, Data Governance team and coordinating with other downstream and upstream teams for data ingestion and integration. o Responsible for managing the installation & configuration, upgrades and ETL pipelines. o Responsible for managing integration of Datastage with MDM, Google API, AVI and USAC services. o Responsible for exposing tables to rest API using ETL jobs by leveraging Data quality features. o Responsible for fetching data from various source systems like flat files, IBM DB2, Oracle, SQL Server. o Responsible for creating rule and executing Data rule in Information Analyzer. o Responsible for updating the report catalogue in IGC using rest functionality. o Responsible for creating Audit Balance Control (ABC) framework for ETL jobs o Responsible for creating the plan of redesigning ETL jobs for migrating in new environment. o Have working knowledge of shell scripting, Data quality and technical integration. o Requirement gathering, creating mapping and implementation using agile development cycle. o Responsible for analysing the low performing jobs and make the required changes. o Driving the sprint planning, backlog grooming and retrospective meetings. o Responsible for code review of ETL jobs created by team members. o Implementing the best practices as per IBM best practices for Datastage team. o Having knowledge of Admin activities, presentation, and communication skills. Show less

Project Manager and Datastage Developer/Trainer

• Dec 2016 - Jan 2021

o Responsible Analysing performance and capacity issues of the highest complexity with systems / applications software and/or application components. o Responsible for data warehouse re-design and Data Modelling, High level, and detailed designs. o Responsible for requirement gathering and driving client meetings and discussions. o Responsible for creating\reviewing ETL jobs, mentoring and training to junior staff. o Expert in unit testing, system integration testing, implementation, and maintenance of databases jobs. o Converted complex job designs to different job segments and executed through job sequencers for better performance and easy maintenance. o Maintained Data Warehouse by loading dimensions & facts and created shell script to run datastage jobs from Unix. o Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed. o Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis. Show less

Datastage developer/Incident Manager

• May 2012 - Dec 2016

o Responsible for handling all the queries related to Sales and Marketing area o Part of the migration team for migrating the applications from Datastage 8.5 to 9.1 and 9.1 to 11.3. o Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into staging tables. o Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages. o Created and modified batch scripts to ftp files from different server to data stage server. o Monitoring the ETL jobs, take required action during failure and handling the Incident Management. o Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager. o Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures. o Part of Chrysler’s innovation team suggested many process improvement ideas. o Responsible for making ETL changes/Enhancements mentioned in the BRD. Show less

Process Associate

• Nov 2010 - May 2012