SUMMARY

• Nine years of programming experience in the IT industry in data warehousing (ETL) and software application development experience using Ab Initio & UNIX.
• Ab Initio Developer (using GDE 1.15/2.15 - 3.3.1/3.3.2 ) with extensive experience in Data Modeling, Design & Development in Data warehousing and strong knowledge of data warehousing, including Extract, Transform, and Load Processes.
• Good experience in written and vocal communication towards business stake holders.
• Hands-on experience spanning solution architecture, System Design (HLD and LLD), Software development &, Enhancement, Maintenance, Testing and Support.
• Good Project Management skills- Estimation, Planning, Execution, Control and Delivery (SDLC). Took responsibility for the deliverables and provided cost-effective solutions, managing the life cycle of the work assignments (Project Estimation, Project Initiation and Allocation through closure)
• Experience in OLTP/OLAP System Study, Analysis E-R modeling and in Dimensional Data Modeling like star schema, snow flake schema, Fact and Dimension tables.
• Good experience with Unix shell scripting and job scheduling using CA7 scheduler
• Experience in developing complex graphs from the variety of components in Ab Initio and to develop generic code enabling re-uses.
• Database experience using Oracle 10g/9i, SQL Server, DB2 and knowledge in creating and managing Conceptual, Logical and Physical Data Models for DB2 for z/OS and DB2 EEE for UNIX.
• Experience in Ab Initio Performance tuning and Database Performance tuning
• Worked on the multiple projects involving the cross-platform development and testing (Mainframe, Unix/Linux, Ab Initio, SQL, windows)
• Effective in communicating technical concepts, finding the simplicity in complex business structures and integrating end user needs into system requirements.
• Work on Go Live activities per Implementation plan, manage issues related to functionalities, user interface, performance, etc. that may arise.

TECHNICAL SKILLS

ETL Tools: Ab Initio GDE 1.15/2.15, 3.1.5.3, 3.2.2, 3.3.1.

Languages: SQL, Shell Scripting.

Operating System: UNIX, Linux, Windows

Databases: Oracle 9i/10g, DB2 v8/10, DB2 EEE v8, MS-SQL

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Perform impact analysis, Debugging and troubleshooting technical issues within the applications
• Taking responsibility to make sure the batches are completed and the results are delivered on schedule.
• Playing a major role in communicating the status on a timely manner to the stakeholders via Status reports and meetings as required.
• Raising early red flags to the stake holders in case of any forecasted problems to minimize the risk, work on the resolution plan.
• Coordination between numerous teams- development teams, testing team, admin teams, business stake holders, scheduling team, to bring an issue to closure.
• Created processes to facilitate easy transfer of data, embedded SQL queries to optimize the processes. Proposing Query Tuning methods and ETL Mapping tuning to increase performance.
• Acknowledge end users concerns and keep them posted on the approach and progress of the resolution.
• Conduct analysis of the issues, identify and evaluate different solution alternatives, implement the most optimal solution,
• Support other team members on issue resolution in areas of expertise as required, manage stakeholder communication and close the issues to ensure support availability as per the SLAs.
• Knowledge Transfer to new players and bring them upto speed for numerous applications.

Confidential

Senior Ab Initio Developer and Team Lead

Responsibilities:

• Understanding of the business requirements, conducting various JAD sessions, bringing different stake holders into single place to vet out the requirements.
• Recognizethe application architectural and structural changes to satisfy the requirements.
• Engage all the required teams for the High level design and strategy - data modelers, solution architects, developers and testing teams.
• Performimpact analysis/data analysis to get the new design in line with the downstream consuming applications.
• Connecting with the Business team and analysts for the design review to get their consent.
• Encourage the team to come up with the detailed level design, review it and get the necessary approvals for the implementation.
• Estimate the work effort, resources and align the release calendar accordingly.
• Co-ordinate with the data modelers, architects and analyst for the various cycles of the implementation.
• Development of the code, creation of new objects depending on the solution design. Perform code review and peer review to identify issues/bugs within the process.
• Testing of the ETL code (Unit testing, Functional & System integration testing, Client acceptance testing). Involving the business analysts and stake holders to validate the results.
• Work on the issues/defects, identify the cause. Assign the defects to the respective teams depending on the nature of the defect - technical, business or process related.
• Migration/Implementation of the Code between environments to maintain code versions and promotion of the correct code.
• Participate in knowledge transfer sessions; document the understanding, take away action items, optimizations identified.

Confidential

Senior Ab Initio Developer and Team Lead

Responsibilities:

• Analysis of business requirements, recognizethe application level modifications/corrections. Take inputs from the business team to understand the overall architecture and the output deliverable expected.
• Performimpact analysis and data analysis on the current code to make sure the new design is in line with the downstream consuming applications.
• Work on the detailed level design, review it and get the necessary approvals for the implementation.
• Development of the code either from the existing repository or creation of new artifacts depending on the solution design.
• Perform code review and peer review to identify any issues/bugs within the system.
• Work on the issues/defects, identify the cause and resolve them at early stage of the cycle there by saving the effort and time of the project.
• Work on the implementation activities, KT sessions, document the questions, take on Shadow Support.
• Extend warranty support to the Production Support team.

Confidential

Technology Analyst and Team Lead

Responsibilities:

• Leading the team in driving the ingestion of data into the lake.
• Analysis of data present in different systems to bring out the various relationships/hierarchy required.
• Analyze business requirements to identify business rules and develop technical solutions.
• Work on the design and the Loading of data into the lake.
• Establishing connection between the different systems to Hadoop cluster.
• Estimating the effort for the project including and excluding Initio.
• Data quality checks, standardization and recommendations.
• Coordination, design, reviews of the reports and enhancements.

Confidential

Senior Ab Initio Developer and Team Lead

Responsibilities:

• Analyzed business requirements to identify business rules and develop technical specifications
• Collaborated with the business analysts to develop and implement technology solutions
• Designed and developed complicated ETL mappings using Ab Initio GDE 3.1.5.3
• Worked on Data Validation to ensure bad or unreadable data is highlighted to business involving correction procedures.
• Added Data Quality to impose uniform semantic and standard usage across all the data marts in the Enterprise-wide Data Warehouse.
• Conducted code reviews, performance testing and tuning of the ETL code for optimization.
• Developed reusable ETL code - graphs, plans, and transformations.
• Detecting the nature of the defects/bugs in question, isolating the cause of the failure through root cause analysis. Resolving of the issues in timely manner without affecting the delivery schedules.
• Value add by communicating with the Business Systems analysts regularly to ensure that changes made to the code were applied in a manner consistent with the needs of the business.
• Monitored performance reports from database and ETL tools server logs to further consider process enhancements and tunings.
• Project life cycles: Initiation to Closure and implemented SDLC phases for all the work efforts and document phase-associated deliverables.
• Interaction with multiple project and team members involving the cross-platform development and testing (Salesforce, abinitio, unix, Replication Junction (sql server), oracle)
• Document and share own learning from multiple modules of the project, seek information and leverage knowledge from other projects in order to drive better re-use and higher effort productivity.
• Third Party Relationship Oversight (bridge between team, Client and third party vendors) and External Network Connectivity (for data transfer)

Confidential

Senior Ab Initio Developer and Team Lead

Responsibilities:

• Analyze the requirements specifications for the intended changes from the business point of view.
• Understandapplication architecture document and seek inputs from the architecture / design team to understand the overall architecture in order to provide deliverables that are in line with architectural requirements
• Perform data analysis to provide technical solutions in order to achieve the business requirements for the existing process.
• Create a high level design for the better understanding of the solution by the business. Redesigned the existing graphs and document all the new and enhancement requests.
• Work on the detailed level design, review it and get the necessary approvals for the implementation.
• Work on the impact analysis process to make sure the new design is in line with the downstream consuming applications.
• Development of the code either from the existing repository or creation of new artifacts depending on the solution design.
• Testing of the ETL code (Unit testing, Functional & System integration testing, Client acceptance testing). Involving the business requirements requestor during the testing process to validate the results.
• Perform code review and peer review to identify any issues/bugs within the system.
• Work on the issues/defects, identify the cause and resolve them at early stage of the cycle there by saving the effort and time of the project.
• Co-ordinate migration and Implementation of the Code between environments to maintain code versions and promotion of the correct code.
• Participate in and preparecontent for KT sessions, document the understanding, take on Shadow Support.
• Provide warranty support to the Production Support team which involves co-ordination between various teams -the business, server administrators, testing teams.
• Share regular updates to the team and management to keep everyone posted on the progress, discuss concerns amongst team members, obtaining feedbacks/suggestions for the betterment of the project.

Confidential

Senior Ab Initio Developer

Responsibilities:

• Understanding the specifications for the ETL Processes and interacting with the business analysts and end users to understand system requirements
• Working closely with Business Analysts to interpret the Business rules to bring out the appropriate mapping requirement.
• Created High Level and Technical Design based on system requirements.
• Prepared the Detailed Design Document for the all the modules required for development
• Design ETL application and develop Data warehouse applications based on the technical / functional specifications.
• Participated in business, detail design and technical documentation for ETL standards, procedures and naming standards.
• Developed number of Ab Initio Generic Graphsbasedon business requirements. Generic Plans were also developed.
• Developed shell scripts, used them for execution, testing, and data validation.
• Perform testing in the standard approach by creating test plans and test cases for unit testing, executing the code and then capturing the results.
• Provided support to the Testing Team. Coordinating for loading the Data into Test Environment. Worked closely with the Enterprise testing team to develop the test cases and then execute them.
• Review the code, enhance efficiency of complicated processes, analyzed the issues/defects and provide fixes before finalizing the code.
• Scheduling of the Ab Initio jobs considering the source and the target requirements.
• Involved in preparing project documentation outlining the whole process and project reports.
• Involvement in the business meetings to provide information and updates on the team’s progress regularly and also acting as a team lead..

Confidential

Systems Engineer

Responsibilities:

• Analyzing and Debugging any technical issues while implementing the applications
• Was liable for production monitoring and fixing abends.
• Taking responsibility of the code execution, making sure the batches are completed and the results are delivered on schedule.
• Playing a major role in communicating the progress on a timely manner to the stakeholders. Status reports preparation, arranging status meetings as required.
• Code walk-through on all proposed changes, conference with users concerning all modifications and impact analysis.
• Handle any escalations from the application teams/end users, respond to the concerns and keep them posted on the approach and progress of the resolution.
• Respond to the issues assigned, conduct analysis of the issues, identify and evaluate different workarounds/ solution alternatives, implement the most optimal solution, support other team members on issue resolution in areas of expertise as required, manage stakeholder communication and close the issues to ensure support availability as per the SLAs.
• Knowledge Transfer to new players and bring them upto speed for numerous applications.
• Documentation for the applications, maintain repository and keep track of the versions.
• Taken the challenge of leading the track (dedicated for Reveleus Application related activities) of about 3 people successfully when the project demanded it