Name – Sarita Saini Contact - 669-***-****

Fremont CA 94538

ad3hi9@r.postjobfree.com

A quality-driven IT professional with a 10 years of experience in the seamless design, planning, and development of jobs for extracting, transforming, and loading (ETL) data from diverse sources to target systems for Healthcare and Banking domain.

Throughout my career, I have consistently demonstrated expertise in all project phases, encompassing Requirement Analysis, Design, Coding, Testing, Support, and Documentation. I am well-versed in agile project deployment models and leverage tools like Jira for meticulous tracking. Active participation in agile discussions and scrum meetings underscores my commitment to collaborative project management. Notably, I possess strong written, oral, and interpersonal communication skills, fostering effective team dynamics.

Synopsis –

•Extensive ETL tool experience using IBM Info sphere DataStage from diverse sources to target systems and managing end-to-end data integration projects.

•Proficient in Designing, planning and developing jobs to perform extract, transform and load (ETL) data between heterogeneous data sources when working with large data sets.

•Experience in ETL development within a Data Warehouse.

•Experienced in Data warehousing and complete Understanding of DW principles-Fact Tables,Dimension Tables, Dimensional Modeling-Star Schema and Snowflake Schema, OLTP, OLAP and Data warehousing concepts.

•Worked on Requirement review and Data Mapping Documents.

•Good knowledge of Unix scripting and SQL.

•Strong expertise in SQL and relational databases like DB2, Oracle,SQL Server and experience in writing PL/SQl procedures.

•Have high level knowledge of Azure and Kafka.

•Knowledge on Azure Data factory and Azure databricks.

•Prepare HLD (High level documents), LLD (Low level documents) and build documents for requirements.

•Worked on production issues and did production support as well.

•Worked with cross-functional teams located across geographies.

•Good exposure of data analysis, determining the data flow, designing and debugging.

•Ability to multitask, prioritizes tasks, and quickly adjusts in a rapidly changing environment.

•Proficient in optimizing and fine tuning Datastage jobs to enhance performance, improve data quality and streamline data integration processes.

•Sheltered Harbor--Sheltered harbor was the industry driven initiative to address the cyber security challenges faced by the financial industry. As the proactive measure of safeguarding critical data files through the air-gapped data vault concept, we developed jobs to generate the critical business data files on regular basis.

•Newton Project--As a part of this BOA has partnered with Defi solutions and Lucid motors to provide the Lease and Loan for a new electric car product from lucid motors. We created the solutions to onboard their data and make the lease/loan process seamless.

•Youth Banking--We developed a solution for youth clients that introduce them to the concepts of earning, spending, saving and investing while giving parents visibility and control and seamlessly graduate them into young adult clients. The aim of this project was to start the banking for youth customers.

•Alaska Airlines--As a part of this project, we built jobs to start a 10% relationship bonus offer for Alaska Airlines customers who also have an active deposit account.

•Mainframe to ETL migration--Migrated 40+ mainframe jobs to ETL and decommission the MF jobs for cost saving.

•B.Tech [Bachelor of Technology] from Guru Gobind Singh Indraprastha University in year 2008-2012.

Tools and Technologies –

Primary Skill : IBM WebSphere DataStage

Database - : DB2, Oracle, SQL Server

Scheduling Tools - : Tivoli Workload Scheduler (TWS), Autosys

OS - : Unix, Linux, Windows

Scripting Language - : Linux Shell Scripting, Python

Domain Knowledge - : Healthcare, Banking

DevOps Tools - : Git

Cloud : Azure,AWS

Tools : Toad, WinSCP, Putty

Professional Training Undergone –

Big Data Analytics

Azure Cloud

DataStage

Achievements & Awards –

I was awarded three times with Gold awards for my innovative idea of- WebService framework, for cost saving by decommission of Mainframe jobs and for handling multiple projects together with successful delivery for same release in Bank of America.

I was awarded with multiple Silver Awards for the successful and quality deliverables in Bank of America.

I was awarded with Bronze award for providing the 5-days Datastage Training for beginners in Bank of America.

I was awarded with Star Award for the performance tuning of the job in United Health Group(Optum).

I was awarded with Star Award for automation of the scripts to run the macros for the reports in United Health Group(Optum).

BA Continuum India Pvt. Ltd.(subsidiary of Bank of America) :

Duration

June 2017-till April 2023

Role

Software Engineer II A (ETL Technical Lead)

Technologies

ETL-Datastage, UNIX,SQL

Responsibilities

Design, plan, and develop jobs to perform extract, transform and load (ETL) data between heterogeneous data sources when working with large data sets (TBs+ range)

Analyze complex data flows and understand existing jobs for development and production support.

Prepare the HLD and LLD for the requirements.

Solely responsible in complete ETL life cycle implementation from requirement gatherings to production implementation.

Involve in Unit testing and performance testing of the jobs.

Test and debug code, troubleshoot support and development issues.

Developed Shared containers for object reusability and to eliminate redundancy.

Demonstrate a strong understanding of the Software Development Lifecycle.

Create and maintain documentation, training materials, and knowledge sharing and Conduct training sessions with team members.

Worked on the agile model of project .

Optum Global Solutions(India) Pvt Ltd:

Duration

March 2013- May 2017

Role

Software Engineer- Datastage

Technologies

ETL-Datastage, UNIX,SQL

Responsibilities

Designing and building ETL Solutions and perform calculations and transformations and load the data into Datawarehouseand data marts.

Experience in configuring and organizing the stages within the job sequence to meet specified business requirements.

Experience in fixing the datastage Job Failures.

Monitor daily ETL processing and ensure the SLAs are met. Notify LOB/tea, on any delays etc.

Working knowledge of production Environment.

Created the dashboard using business objects.

Created Datastage jobs using different stages like Aggregator, Sort, Join, Merge, Lookup, Data

Experienced in writing SQL Queries, Views, Joins, Constraints, DDL, and DML.

Have done automation in reporting using Macros.

Personal Info –

Name : Sarita Saini

Father’s Name : Satbir Singh Saini

Marital Status : Married

Languages Known : English, Hindi

Hobbies : Dancing, Drawing, playing Badminton

I hereby declare that all the above information given is true to the best of my knowledge and belief.

Thank You .

Dated: Dec,2023 (Sarita Saini)

Professional Summary –

Highlights of Major Project worked

Academic –

Work Experience –

Contact this candidate