Now you can Instantly Chat with AJAY!
About Me
10 Years of diversified Data Warehousing IT application development experience. Successful End to End implementation of four ETL Development Projects as a Project Lead. Extensive experience in SCD1, SCD2, SCD4 & SCD6 DataWarehosuing, DataMart Concept...as a Project Lead. Extensive experience in SCD1, SCD2, SCD4 & SCD6 DataWarehosuing, DataMart Conceptual and Logical DB and ETL design. Extensive client facing experience for Requirements gathering and analysis. Exposure to Data Modeling in creating Conceptual and Logical models using Erwin Tool. Experience in High-Low level designing, developing and implementing transformation processes to develop SCD1, SCD2, SCD4 & SCD6 data marts and data warehouses using the ETL Tool Informatica PowerCenter. Rich hands on experience with Informatica PowerCenter, UNIX Shell Scripting, and SQL. Have good understanding of SDLC Models – Waterfall and AGILE-SCRUM Team player, quick learner and leadership qualities with strong communication, analytical and problem solving skills. Ability to work in both independent and team environments. One Year UK Onsite work experience.
Show MoreSkills
-
-
-
-
-
-
-
-
-
-
-
-
- 1 Years
Intermediate
-
- 10 Years
Expert
-
-
- 4 Years
Intermediate
-
-
-
-
- 1 Years
Intermediate
-
-
-
- 1 Years
Beginner
-
-
- 10 Years
Expert
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 10 Years
Intermediate
-
-
-
-
-
-
-
- 10 Years
Expert
-
- 10 Years
Advanced
-
-
- 10 Years
Expert
-
- 5 Years
Intermediate
-
-
- 10 Years
Advanced
-
- 4 Years
Intermediate
-
-
-
- 4 Years
Advanced
-
- 1 Years
Beginner
-
- 10 Years
Advanced
-
-
- 10 Years
Advanced
-
- 4 Years
Intermediate
-
-
-
- 1 Years
Intermediate
-
-
-
-
-
- 4 Years
Intermediate
-
- 10 Years
Expert
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Portfolio Projects
Description
As a Lead, I am responsible for managing a team of analysts, developers, L3 and drive delivery of the project. I am responsible for technical track of the project.
- Participating with BA in the requirements gathering from the User/Client.
- Supporting BA in understanding the BRD and for FSD preparation.
- Conducting the daily stand-up call, tracking the status and impediments of all the ongoing activities in scope JIRAs of in scope feeds.
- Having Weekly status call with Client Stakeholders.
- Guiding team through Development, coding standards and addressing their day to day issues.
- Reviewing code and Release confluence page before migrating it into the UAT and PROD environments.
- Representing JIRAs in Architecture Review Board (ARB) and PTG call before GO LIVE
Show More Show LessDescription
As a Lead, I am responsible for managing a team of analysts, developers, testers or engineers and drive delivery of the project. I am responsible for functional/technical track of the project.
- Participating with BA in the requirements gathering from the Client.
- Supporting BA in understanding the BRD and for FSD preparation.
- Conducting the daily stand-up call, updated the status and impediments of all the ongoing activities of respective reconciliations (Projects) in the Recs Task Tracker.
- Preparing Technical Specification Document (High-Low Level Design Doc), ETL specifications, Unit Test Plan Document and Migration (runbook) Documents.
- Presenting the Technical Specification Document in the Credit Suisse DRB (Design Review Board) meetings and getting the Sign Off from DRB Team.
- Developing Informatica Code like mappings, mapplets, sessions, workflows, parameter files, Lookups and doing Unit testing.
- Developing ReconDP Code for different ReconDP tables and doing Unit Testing. - Developing Intellimatch code and doing Unit testing.
- Developing Stored Procedures and doing Unit testing.
- Developing Control M Job definitions.
- Guiding team through Development, coding standards and SDLC.
- Reviewing code before emigrating it into the higher environments.
- Sharing release details, implementations plan and runbook documents with Release Management Team to raise RFCs (Change Requests) for code migrations SIT, UAT and PROD environments and coordinating with the respective implementations teams for its implementation.
- Providing defect resolution to SIT (BA) and UAT (Business User) teams.
- Preparing Project Handover documents for support team. - Providing warranty support to Production Support team.
Achievements
- Before time delivery of all the BOWs/Projects/deliverables.
- Received multiple appreciations from the client.
RESPONSIBILITIES (ACCOUNT & UNIT LEVEL):
Conducting Informatica PowerCenter trainings.
Conducting Interviews as a Level 1 and Level 2 Technical panelist to hire Developers and Sr. Developers for Skillset Informatica PowerCenter, UNIX, Data Warehousing and SQL.
Mentoring new joiners.
Show More Show LessDescription
As a Lead, I am responsible for managing a team of analysts, developers, testers or engineers and drive delivery of the project. I am responsible for functional/technical track of the project.
- Participating with BA in the requirements gathering from the Client.
- Supporting BA in understanding the BRD and for FSD preparation.
- Conducting the daily stand-up call, updated the status and impediments of all the ongoing activities of respective reconciliations (Projects) in the Recs Task Tracker.
- Preparing Technical Specification Document (High-Low Level Design Doc), ETL specifications, Unit Test Plan Document and Migration (runbook) Documents.
- Presenting the Technical Specification Document in the Credit Suisse DRB (Design Review Board) meetings and getting the Sign Off from DRB Team.
- Developing Informatica Code like mappings, mapplets, sessions, workflows, parameter files, Lookups and doing Unit testing.
- Developing ReconDP Code for different ReconDP tables and doing Unit Testing.
- Developing Intellimatch code and doing Unit testing.
- Developing Stored Procedures and doing Unit testing.
- Developing Control M Job definitions.
- Guiding team through Development, coding standards and SDLC.
- Reviewing code before emigrating it into the higher environments.
- Sharing release details, implementations plan and runbook documents with Release Management Team to raise RFCs (Change Requests) for code migrations SIT, UAT and PROD environments and coordinating with the respective implementations teams for its implementation.
- Providing defect resolution to SIT (BA) and UAT (Business User) teams.
- Preparing Project Handover documents for support team.
- Providing warranty support to Production Support team.
Show More Show LessDescription
- Participated with BA in the requirements gathering from the Client.
- Supported BA in understanding the BRD and for FSD preparation.
- Prepared Technical Specification Document, ETL specifications, Unit Test Plan Document and Migration (runbook) Documents.
- Developed Informatica Mappings with required business rules.
- Guided team through Informatica Development, coding standards and SDLC.
- Reviewed code before emigrating it into the higher environments.
- Raised CRs (Change Requests) for code migrations and environment set up in SIT, UAT and PROD environments and coordinated with the respective teams for its implementation.
- Provided defect resolution to SIT and UAT teams.
- Prepared Project Handover documents for support team.
- Created Job Scheduling sheet. - Provided warranty support to Production Support team.
- Created and Updated JIRA stories for the respective deliverable
Show More Show LessDescription
JConnect has been operating within the Information Technology, Engineering & High Technology sector dealing with companies in Financial Services, Aerospace, Retail , HealthCare, Hi- Tech and Automotive Sectors. As a Lead, I am responsible for managing a team of analysts, developers, testers or engineers and drive delivery of the project. I am responsible for functional/technical track of the project. Participating with BA in the requirements gathering from the Client. Supporting BA in understanding the BRD and for FSD preparation. Conducting the daily stand-up call, updated the status and impediments of all the ongoing activities of respective reconciliations (Projects) in the Recs Task Tracker. Preparing Technical Specification Document (High-Low Level Design Doc), ETL specifications, Unit Test Plan Document and Migration (runbook) Documents. Presenting the Technical Specification Document in the Credit Suisse DRB (Design Review Board) meetings and getting the Sign Off from DRB Team. Developing Informatica Code like mappings, mapplets, sessions, workflows, parameter files, Lookups and doing Unit testing. Developing ReconDP Code for different ReconDP tables and doing Unit Testing. Developing Intellimatch code and doing Unit testing. Developing Stored Procedures and doing Unit testing. Developing Control M Job definitions. Guiding team through Development, coding standards and SDLC. Reviewing code before emigrating it into the higher environments. Sharing release details, implementations plan and runbook documents with Release Management Team to raise RFCs (Change Requests) for code migrations SIT, UAT and PROD environments and coordinating with the respective implementations teams for its implementation. Providing defect resolution to SIT (BA) and UAT (Business User) teams. Preparing Project Handover documents for support team. Providing warranty support to Production Support team.
Show More Show LessDescription
Fidelity National Information Services Inc., better known by the abbreviation FIS, is an international provider of financial services technology and outsourcing services. Headquartered in Jacksonville, Florida. Participated with BA in the requirements gathering from the Client. Supported BA in understanding the BRD and for FSD preparation. Prepared Technical Specification Document, ETL specifications, Unit Test Plan Document and Migration (runbook) Documents. Developed Informatica Mappings with required business rules. Guided team through Informatica Development, coding standards and SDLC. Reviewed code before emigrating it into the higher environments. Raised CRs (Change Requests) for code migrations and environment set up in SIT, UAT and PROD environments and coordinated with the respective teams for its implementation. Provided defect resolution to SIT and UAT teams. Prepared Project Handover documents for support team. Created Job Scheduling sheet. Provided warranty support to Production Support team. Created and Updated JIRA stories for the respective deliverable.
Show More Show LessDescription
Participated with BA in the requirements gathering from the Client. Supported BA in understanding the BRD and for FSD preparation. Prepared Technical Specification Document, ETL specifications, Unit Test Plan Document and Migration (runbook) Documents. Developed Informatica Mappings with required business rules. Guided team through Informatica Development, coding standards and SDLC. Reviewed code before emigrating it into the higher environments. Raised CRs (Change Requests) for code migrations and environment set up in SIT, UAT and PROD environments and coordinated with the respective teams for its implementation. Provided defect resolution to SIT and UAT teams. Prepared Project Handover documents for support team. Created Job Scheduling sheet. Provided warranty support to Production Support team.
Show More Show LessDescription
Participated with BA in the requirements gathering from the Client. Supported BA in understanding the BRD and for FSD preparation. Prepared Technical Specification Document, ETL specifications, Unit Test Plan Document and Migration (runbook) Documents. Developed Informatica Mappings with required business rules. Guided team through Informatica Development, coding standards and SDLC. Reviewed code before emigrating it into the higher environments. Raised CRs (Change Requests) for code migrations and environment set up in SIT, UAT and PROD environments and coordinated with the respective teams for its implementation. Provided defect resolution to SIT and UAT teams. Prepared Project Handover documents for support team. Created Job Scheduling sheet. Provided warranty support to Production Support team.
Show More Show LessDescription
Infosys Ltd (formerly Infosys Technologies Limited) is an Indian multinational corporation that provides business consulting, information technology, software engineering and outsourcing services. It is headquartered in Bangalore, Karnataka. Westpac is an Australian bank and financial-services provider headquartered in Sydney. It is one of Australias big four banks and is also the second-largest bank in New Zealand. Designing the ETL process using Informatica PowerCenter to Load data from Source to Target schemas. Preparing Design Document, ETL specifications, Unit Test Cases and Migration Documents. Developing Informatica Mappings with required business rules. Designed Complex Mapping using Aggregator, Joiner, Router, Normalizer, Lookup, Sorter, Sequence Generator based on the Business Rules. Raising CRs for code migrations and environment set up in higher environments and coordinating with teams for its implementation. Providing defect resolution to test team.
Show More Show LessDescription
UBS AG is a Swiss global financial services company with its headquarters in Basel and Zürich, Switzerland. The company provides investment banking, asset management, and wealth management services for private, corporate, and institutional clients worldwide, and for retail clients in Switzerland as well. Interacting with client for requirements gathering. Preparing Design Document, ETL specifications, Unit Test Plan Document and Migration Documents. Raising CRs for code migrations and environment set up in higher environments and coordinating with teams for its implementation. Developing Informatica Mappings with required business rules. Creating job scheduling documents of project for different environments. Designed Complex Mapping using Aggregator, Joiner, Router, Normalizer, Lookup, Sorter, Sequence Generator based on the Business Rules. Providing defect resolution to test team.
Show More Show LessDescription
Atradius is one of the world´s largest credit insurers. It also provides affiliated credit management services such as recoveries and collections. Understanding logical data model and creating physical data model using Erwin Data Modeler. Suggesting required changes in logical data model based on the logical mapping specifications received for different source systems. Understanding and reviewing logical mapping specifications created by Client SMEs/Analysts and creating physical mapping specifications for ETL development. Preparing issue tracker for logical mapping specification discrepancies and having daily discussion with Client SMEs/Analysts for resolving the same. Developing Mappings to load dimensions and fact tables. Preparing Design Document, ETL specifications, Unit Test Cases and Migration Documents. Designed & Developed Complex Mapping using Aggregater, Joiner, Router, Normalizer, Lookup, Sorter, Sequence Generator based on the Business Rules. Providing defect resolution to test team.
Show More Show LessDescription
Anthem Inc., previously known as WellPoint, is the largest for-profit managed health care company in the Blue Cross and Blue Shield Association. Designed & Developed Complex Mapping using Aggregator, Joiner, Router, Normalizer, Lookup, Sorter, Sequence Generator based on the Business Rules. Creating Unit Test Cases and Migration Documents.
Show More Show Less37020 USD / Year (Expecting)
-
Start Date / Notice Period end date: 2020-05-01