SUMMARY

• Abinitio/ETL Sr. developer with 10+ years of experience in building end - end data solutions
• Good knowledge on AWS, S3, EC2, Snowflake
• Expertise in ETL Designing, developing, testing ETL jobs using Ab initio & Informatica
• Expertise in implementing complex business rules by creating robustGraphs, plans using Ab initio and Mappings, Mapplets, Sessions and Workflows using Informatica Power Center
• Experience in working with major Abinitio components, parallelism, multifile etc.
• Experience in widely using the M Commands and AIR commands
• Experience in resolving on-going maintenance issues and bug fixes, monitoring as well as performance tuning of the Graphs
• Extensively used Express>IT, Control center for Abinitio code migration and job monitoring
• Has been involved in different phases of Data Warehouse life cycle ranging from study, design, development, and testing and support activities
• Experience in using EME, code versioning, check-in, check-out, save file creation
• Proficient in the processing and Integration of various data sources including relational, Flat files, EBCDIC files
• Experience inperformance tuningofboth Informatica mappingsandAb Initio Graphsto improve performance of the large volume projects
• Experienced inData Cleansing, Data profiling andData Analysis
• Experience in preparing documentation such asHigh-level design,System requirement document, Mapping documents andTechnical Specification documentetc.
• Worked with cross-functional teams such asQA,DBAandInfrastructureteams to deploy code fromdevelopmenttoQA andProduction
• Worked on both the Waterfall and Agile delivery models
• Excellent analytical, problem-solving skills with strong technical background and interpersonal skills
• Experience in using Automation Scheduling tools like TWS and Control-M
• Skilled in Estimation, planning, coordination, and execution of system applications and reverse engineering projects

TECHNICAL SKILLS

Cloud: AWS Cloud Technologies

Domain Expertise: BFS, General insurance, Life Insurance

Databases: Hadoop, Teradata, Oracle 11g, Snow Flake

ETL tools: Ab initio 2x/3x, Informatica 6x/7x/8xScheduling tools Control-M, Tivoli, Express>IT, Control>Center

Incident & Change management: ServiceNow, JIRA

Others: Shell Scripting, SQL

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

RESPONSIBILITIES:

• Understand each of the application’s functionality and the design to quickly respond on the failures or data issues. Need to be thorough with the process and source systems to debug the jobs and perform the root cause analysis.
• Should participate in the platform maintenance and create an approach on how to handle the maintenance or server switch overs during the disaster recovery trials. Report the issues and defect fixes to the application teams and L4 teams to avoid any design defects to be implemented in the future solutions. Perform code/design fixes to mitigate the failures if the issues are repetitive and might occur in future.
• Build the ETL solutions for Hadoop ingestion, CDC and load the data into the ER
• Continuous monitoring, improvements and addressing the production defects, enhancements and performance tuning of the ETL code etc.
• Manage the Project deliverables, maintain customer relationship and manage resources, should maintain onsite and offshore resource handling, task delegation and monitoring, status reporting, client interaction and offshore-onsite coordination

Confidential, Plano, TX

RESPONSIBILITIES:

• Understand the source data and identifying impacted downstream applications and processes
• Work on the ETL solution and approach and acquiring the Engineering & architecture approval
• Participate in the business JAD to extract the requirements from all the impacted applications and the business user reports
• Support the data modeling and go thru the company’s data architecture approval process
• Build the high level and low-level design documents and convert the requirements and designs into the ETL code using Abinitio as the ETL tool
• Code reviews to make sure following the best practices and standards
• Build the ETL solutions for Hadoop ingestion, CDC and load the data into the ER
• Support the system integration & user testing process and take the final code base into Production region
• Continuous monitoring, improvements and addressing the production defects, enhancements and performance tuning of the ETL code etc.
• Deployment of the code in IST and change management and implementation in UT and Prod using ITSM
• Manage the Project deliverables, maintain customer relationship and manage resources, should maintain onsite and offshore resource handling, task delegation and monitoring, status reporting, client interaction and offshore-onsite coordination

Confidential, Plano, TX

RESPONSIBILITIES:

• Understand the Loan applications data, downstream impacts and the reporting system needs and design the Origination Shared semantic mart right from the SOR data landing to the final Physical Teradata layer
• Participate in the business JAD to extract the requirements from all the impacted applications and the business user analytics
• Perform the data modeling and go thru the enterprise architecture approval process for the shared semantic mart
• Build the ETL solutions to load the data into the Shared semantic mart for the better performance and simpler operational maintenance.
• Build the high level and low-level design documents and convert the requirements and designs into the ETL code using Abinitio as the ETL tool
• Code reviews to make sure following the best practices and standards
• Support the system integration & user testing process and take the final code base into Production region.
• Continuous monitoring, improvements and addressing the production defects, enhancements and performance tuning of the ETL code etc.
• Manage the Project deliverables, maintain customer relationship, should maintain onsite and offshore resource handling, task delegation and monitoring, status reporting, client interaction and communication and offshore-onsite coordination.

Confidential - Lewisville, TX

RESPONSIBILITIES:

• Understand the current system and redesign the new system. Perform the consumption analysis the data usage and create the single source view of data based on subject area to stage based on consumption
• Design and develop ab initio graphs, test and implement the code into production environment
• Identify the unwanted and unused tables and reports and conclude the decommissioning scope
• Performance tuning of the graphs and processes to generate the reports within the SLA
• Build and schedule the control-M jobs to run the ab initio graphs in the production environment and implement them
• Create the documentation deliverables like Design documents, Impact analysis, consumption analysis and production support play books for the better future maintenance of the application
• Manage the Project deliverables, maintain customer relationship and manage resources, should maintain onsite and offshore resource handling, task delegation and monitoring, status reporting, client interaction and communication and offshore-onsite coordination

Confidential, Lewisville, TX

RESPONSIBILITIES:

• Understand Treasury requirements and Directives as part of the MHA program. Analyze, Design and Implement changes for supplemental directives from Treasury
• Participate in Business Requirement analysis, Systems Analysis, Data analysis, Data Mapping and Design Oracle Based ETL Processes, will be working on Project Effort sizing, estimation and project planning, interact with Business Users, Validate Process flow and suggest solutions for process control and Data Quality
• Design the reverse engineering process from legacy PL/SQL to Ab Initio and convert the Legacy business/Reporting requirements into functional & technical specifications. Develop and maintain requirement, functional and technical specification documents as necessary. Develop and implement the new ETL design using Hadoop, Oracle, SQL, Ab initio and UNIX and design Automated & performance effective approach for Oracle & UNIX based ETL processes & Reports.
• Validate Data based on Business Rules Defined by Treasury and suggest the solutions. Analyze and reconcile data from various data sources like Oracle databases, MS Excel and Flat Files and perform data attestation. Developing Data reconciliation reports to compare data between Source and Target tables, execute Change Management process maintaining the quality standards and prepare relevant SDLC documents and also review and Validate Change management process, documents and ETL code being migrated
• Manage the Project deliverables, maintain customer relationship and manage resources, should maintain onsite and offshore resource handling, task delegation and monitoring, status reporting, client interaction and communication and offshore-onsite coordination

Confidential, Columbus, OH

RESPONSIBILITIES:

• Responsible for analyzing the existing system, which was built on Ab initio, and come up with suitable design, which will improve the efficiency of PnL process in the new ICDW initiative.
• Responsible for Designing and building enhancements using Ab initio.
• Maintenance, support, break fixes and Code Deployment
• Developing the code using Informatica as an ETL tool and do unit testing, System testing and parallel testing.
• Working closely with the business to gather the requirements of new business functionalities, which needs to be incorporated in the new project, and supporting the users in validating the data in the User acceptance testing.
• Coordinating with the team for providing them the required information on the requirements and knowledge transition on the existing system.
• Would be involved in the deployment of new code into production system and providing the operational documents and knowledge transition to the production support team for smooth execution of the project.
• Built Performance, coding checklists for the development team and did code reviews