rajat sachdeva

I am looking for a job for Ab Initio Developer

Jan 2021 – till date  Associate Manager  AllState Solution Private Limited, Pune(India)

Project Name -: Allbridge Metrics .

Roles && Responsibilities - 

•         Business Requirements Analysis, build HLD & LLD to implement the solutions using 

           Ab Initio, Apache Kafka.

•         Designed and implemented solutions for complex business requirements, frameworks 

          are designed keeping in mind the future scope and scalability

•         Responsible for managing the project end-to-end, partner with Ab Initio Corp

          ,application design/architecture, business requirement analysis, general  engineering 

          of ETL applications.integration with Ab Initio.

•         Review QA/UAT test results to assist business teams to accept the completed features.

•          Conduct Code reviews to ensure efficient solution is being implemented, coding 

           standards and best practices are being followed.

•         Managing 2 teams ; comprising of 20 members .

Mar 2019 – Jan 2021  Senior Lead Consultant  Allstate Northern Ireland, Belfast(UK)

Project Name -:Agency Pay Compensation.

Roles && Responsibilities -

• Giving training to the Belfast team on Ab Initio.
• Understanding the business requirement from Onshore and converting that to functional one for Offshore to work on it. 
• Mentored team members to lead sub modules in the project and to deliver the highest code standards.
• Responsible for driving the project end-to-end through SDLC till operations.
• Conduct Code reviews to ensure efficient solution is being implemented, coding standards and best practices are being followed.
• Developing complex graphs for the project involving JSON and Webservices . 

Apr 2017 – Mar 2019  Senior Lead Consultant    Allstate Solution Pvt Ltd,Pune

Project Name -:  Agency Pay Compensation.

Roles && Responsibilities -:

• Managing a team of 8 persons. 
• Guiding the team on technical issues and making the process more effective.
• Built generic graphs for Extraction from different platform.
• Building generic wrapper scripts to call Ab Initio graphs/psets.
• Work on converting Shell interpretation to PDL to eliminate the DA issues.
• Work on fine-tuning the overall process to reduce daily cycle completion time.
• To support SIT and move the code to QA.
• Reviewing offshore’ s delivery and then migrate it to higher environment.
• Responsible for smooth handshaking between Onshore and Offshore.
• Impact analysis of any CR raised. 

Team Size         : 8 

Jan 2015 –Mar’2017  Sr.Consultant    Allstate Solution Pvt Ltd,Pune

Project Name -:  Enterprise Producer Commission System Integration.

Roles && Responsibilities -:

• ETL code migration projects from Solaris server to Linux for two applications.
• Deliver ELT packages end-to-end.
• Develop generic graphs for duplicate checks and data comparisons.
• Work on the break fix, L3 support and continuous development and review and inspect the production changes. 
• Responsible for Requirements gathering, Development, Testing, Code Review, Code migration, Supporting System testing, Job scheduling, Offshore co-ordination.
• Developed test plans and test cases as part of Unit testing.                                   
• Create several Korn shell scripts to reduce the support work.
• Test the proposed solutions before delivering to Onshore and obtaining signoff.
• Work with the various other groups – Upstream and downstream system, DBAs, Server Engineer team.

Technology Used: Ab-Initio GDE V3.1, Linux X86_64 Oracle 10g.

Team Size        : 7 

Aug 2013 – Dec 2014    Data Specialist       IBM India Pvt.Ltd.,Pune

Client Name -: SunTrust Bank.

Project Name -: HCMS Workday DIME Integration.

Roles && Responsibilities -:

• Requirement gathering and Analysis  .
• Development of mappings with the implementation of Encryption and Decryption of data.
• Deliver ELT packages end-to-end.
• Will be communicating team on each updates and changes happening in the application.
• Optimizing the code for better performance.
• Work on the break fix and continuous development and review and inspect the production                          changes.                                     
• Simulate the environment to perform dummy production run.
• Test the proposed solutions before delivering to client and obtain signoff.
• Work with the various other groups – DBAs, Server Engineer Team, Middleware Group, Citrix         Group, Network Group.etc to resolve the performance related/integration related issues.
• Spend time on debugging the issues logged on a daily basis as part of the warranty support and issues logged by users.

Technology Used: Ab-Initio GDE V3.1, Oracle 10g, Unix, IBM Z/OS 1.3 Mainframe Team

Team Size        : 3

Jul 2012 –Jul '13         Data Specialist         IBM India Pvt.Ltd.,Pune

Client Name  :-   SunTrust Bank.

Project Name:-   Enterprise Forecast and Planning.

Roles && Responsibilities-:

• Gather and analyze the requirements.
• Provide most appropriate technical design and solutions.
• Work assignment and tracking to completion of activities and different phases of development.
• Support the End users by providing the faster solution to their request.
• Work on the break fix and continuous development and review and inspection for the production.   
• If required, simulate the solution and explain the same to customer before actual implementation.       
• Co-ordinate with customer to ensure the issues is resolved at the earliest.
• Ensure that development is performed as per requirements.
• Develop implementation and test plans, build software acceptance criteria, coordinate and work 

            with clients to oversee the acceptance and dissemination process.                     

Technology Used :   Ab-Initio GDE V3.1, DB2 8.x, Unix ,IBM Z/OS 1.3 Mainframe Team

Team Size          :  6

Sep 2011– Jun '12    Sr. Software Engineer     HTC Holdings Pvt.Ltd, Mumbai

Client Name   :-  JP MorganChase Bank

Project Name:-   CREDE,SVDM

Roles && Responsibilities-:

• Building and Enhancement of graphs.
• Written many Shell Scripts to reduce the support work.
• Supporting the Application.
• Perform bug fixes and adding additional functionality wherever required.
• Developed generic script to connect to the data base.
• De-commissioning of job streams pointing to Oracle database.

 Technology Used: Ab-Initio GDE V3.1, Teradata, Unix, IBM Z/OS 1.3 Mainframe Team

 Team Size         : 4

Sep 2008–Sep'11 System Engineer Tata Consultancy Services(TCS), Kolkata

Client Name   :-    Kaiser Permanente

Project Name  :-  ABC Metric system,Onelink,GERS.FCI,CIWRS .

Roles && Responsibilities-:

• Key project implementations as team member.
• Maintenance and support of legacy systems.
• Developed graphs and wrapper scripts for ACB metric system.
• Intimate the client about the build of the Application.
• Worked on data cleansing and housekeeping scripts, so as to pass through good data.
• Provided technical and investigative support for functional users on interfaces, defects.
• Debugging issues, testing, service pack upgrades and adhoc report requirements.
• Continued support for production issues as third level production support specialist.
• Investigated causes of SLA non-conformance with De-bugger.

Technology Used :  Ab-Initio GDE V2.15, Oracle, Unix

Team Size          : 5