SUMMARY

• I have around 7 years of hands - on experience on Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume of data processing applications.
• Experience in full life cycle of software design process (SDLC) including requirement gathering, design, development, documentation, implementation and Testing of various ETL-based applications implemented on both Waterfall and Agile Methodologies.
• Hands on experience on various Ab Initio components (Data set, Transform, PDL, XML and MQ) and worked on serial file system & multi file system.
• Implemented various Unix shell scripts like pre-validation and post-validation for Batch jobs.
• Worked on Schedulers for jobs automation processes Using Control - M and Autosys.
• Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues on time to meet the SLA’s.
• Interaction with Client to discuss critical issues and taking the acknowledgement and providing the resolution and provide Daily/weekly status report to Customer.
• Having good knowledge on Data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables.
• Having good knowledge on Informatica PowerCenter 9.6.1 (transformations, mapplets, mappings, reusable sessions, worklets and workflows).
• Good understanding/knowledge ofHadoopArchitecture and various components such as HDFS, Big data Eco Systems in storage, querying, Name Node, Data Node and Secondary Name node concepts and processing and analysis of Big Data.
• Proven abilities at Guiding, Leading, Mentoring, and Training ETL Trainees inside the team and across.
• Quick learner and highly motivated individual with ability to handle challenges as a individual (or) team contributor. Good in analysis and debugging skills.

TECHNICAL SKILLS

ETL Tools: Ab-Initio (2.13,2.14, 3.0.3), Informatica 9.6.1

Database: DB2 UDB 9.1, ORACLE 11.0

Version Control: EME, RationalClearCase

Scheduling Tools: Control -M, Autosys

Scripting: UNIX Shell Scripting, Pig

Other: Toad, Service now, BMC Remedy, DOORS 9.6 and SAP Business Objects

Testing Tool: HP Quality center, HP Application Lifecycle Management

Domain Experience: Banking and Financial Services (BFS) and Mortgage

PROFESSIONAL EXPERIENCE

Confidential - Columbus, Ohio

Module lead/ Senior Programmer

Technologies used: AbInitio, UNIX, Autosys, Oracle, Toad, IBM Rational ClearCase, HP ALM

Responsibilities:

• Closely working with Client & Business Analyst teams in gathering, analyzing and understanding the requirements and created various documents.
• Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
• Maintaining effective relationships with various administrations and development teams.
• Participating in periodic meetings, maintaining all applications for production, and planning appropriate strategies.
• Contributed and Involved in all phases in end-to-end project deliveries.
• Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues.
• Created Job Information Language(JIL) and capabilities to recommend suggestions that will comply with internal standards and best practices.
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Created high performance Sql scripts to reduce the time taken for producing ongoing Adhoc reports monthly and weekly.
• Analyzing/Supporting all vendor applications and providing operational support and performing reviews.
• Proposing and implementing the fixes required for the broken functionality.

Confidential - Phoenix, Arizona

Subject Matter Expert/Application Owner/ Senior Programmer

Technologies used: AbInitio, UNIX, Control-M, DB2, Toad

Responsibilities:

• Deliver technical solutions to problems identified and architectural recommendations along with process conference for incident, problem, change management and compliance.
• Provides proactive monitoring/oversight of key critical applications to mitigate potential incidents before they impact the customer
• Use debugging/analytical tools to quickly determine root cause and performance bottlenecks with system/application
• Automating, optimizing, and executing process improvements on existing processes. Assists in the development and deployment of preventative maintenance procedures
• Interacts with development team to ensure quality standards are adhered to during development and implementation.
• Interacts with the product engineering teams via Retrospectives/Post-Implementation Reviews to ensure quality standards are adhered to during development and implementation
• Monitor and manage change quality, and identify proactive/preventative opportunities with a strong focus on high availability and system resiliency.
• Ensure root cause analysis is done and that proactive/preventative measures are taken to avoid a reoccurrence
• Monitor the resolution of defects by development teams within the warranty period.
• Regularly communicates requirements for preventative solutions and resolutions to the Service Delivery Senior Performance Analyst and/or Service Delivery Manager/Director.

Confidential - Phoenix, Arizona

Module lead/ Senior Programmer

Technologies used: AbInitio, UNIX, Control-M, DB2, Toad, HP Quality Center

Responsibilities:

• Performing Impact analysis to identify the modules impacted by the Business Need Request initiated by the client and estimation of effort required for completing the activity.
• Responsible in building the graph design based on requirements and closely working with team to convert them into build.
• Implemented various performance tuning techniques while creating/enhancing graph.
• Responsible in reviews of all work and sharing the status to stake holders.
• Involved in understanding and analyzing the SIT, UAT issues reported by business users and helping to fix them to closure.
• Documenting all production applications, creating run book, resolving all application issues, and answering all requests.

Confidential

Senior Programmer

Technologies used:AbInitio, UNIX, Control-M, DB2, Toad, HP

Responsibilities:

• Analysis of the Specification provided by the client and creating the required documents like Mapping Documents, Design Documents.
• Used AbInitio components like Reformat, Input file, Output file, Join, Sort, Partition By key, Normalize, Input Table, Output Table, Update Table, Gather Logs and Run Sql for developing graphs.
• Used AbInitio as ETL tool to extract data from source systems, cleanse Transform, and Load data into databases.
• Responsible for creating AbInitio graphs for landing the validated source data received from various source systems and creating Lookups for cross reference.
• Modified the AB INITIO components parameters, utilize data parallelism and thereby improve the overall performance to fine tune the execution times.
• Involved in Unit Testing, Documented Test Cases for each graph.

Confidential

Programmer

Technologies used: AbInitio, DB2, UNIX, Control-M, HP

Responsibilities:

• Preparation of various documents like design and testing documents to ensure that the technical logic implemented in various graphs is clearly understood by everyone.
• Create and maintained Ab Initio Graphs using various components like Transform, Partition, De-partition, Dataset, Database, Validate, FTP, Miscellaneous components.
• Creating Graph level and Project level parameters according to the requirements
• Worked on improving the performance of Ab Initio graphs by using Lookups, In-Memory Joins and parallelism techniques.
• Debugging AbInitio graphs using File Watchers.
• Post implementation support & prepared thorough documentation for the code and test strategies.

Confidential

Programmer

Technologies used: AbInitio, DB2, UNIX, Control-M, HP

Responsibilities:

• Creating Graph level and Project level parameters according to the requirements
• Worked on improving the performance of Ab Initio graphs by using Lookups, In-Memory Joins and parallelism techniques.
• Post implementation support & prepared thorough documentation for the code and test strategies.