SUMMARY

• Over 9 years of experience in software analysis, design and development for various software applications with focused domain expertise involving Banking and Financial portfolio.
• Hands - on knowledge in the Analysis, Design and Development of Data warehousing solutions.
• Developing strategies for ETL mechanism by applying Abinitio knowledge of full life cycle development required to build data warehouse.
• Expertise in all components in the GDE of Abinitio for creating, executing, testing and maintaining graphs in Abinitio.
• Expertise in Root cause analysis, Error handling and debugging the issues encountered.
• Project deliverables and milestone reviews and updates on a regular basis.
• Abilities in software testing including creation of shell scripts / SQL query and execution of functional tests
• An effective communicator with excellent interpersonal, analytical and client servicing abilities.
• Experience in working with multiple vendors and geographically distributed teams

TECHNICAL SKILLS

Tools and IDE: Abinitio

Database: DB2, SQL Server, Salesforce

Scripting language: UNIX shell scripting

Scheduling tools: CA7 and Autosys

File System: Hadoop

PROFESSIONAL EXPERIENCE

Confidential

Datalake Developer

Responsibilities:

• Development and Unit Testing using AbInitio, Creation Low level design documents which includes class and sequence diagram using Rational Rose and RSA.
• Participated in code and design reviews and also used check style tool for code quality improvements.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project
• Understanding the business requirements, functional and non-functional requirements by going through the specifications and inputs from Business Analysts
• Performing thorough impact analysis based on requirements
• Code Development
• Participate in and prepare content for KT sessions and document the understanding.
• Code Walkthrough- Conducting code reviews within the team to ensure that all standards and best practices are followed
• Preparing High level design documents, technical design documents
• Working with other ETL teams, testing teams, DBA’s, tech architects and ca7 job scheduling teams.
• Responsible for on-time delivery of high quality code
• QA Phase Lead - driving the QA testing phase by tracking issues, scheduling the fixes, thus enabling QA phase to be successful
• Troubleshooting production critical issues under tight deadlines
• Performing testing activities (Integration Testing, System Testing, Acceptance Testing) based on the plans and in line with defined processes
• Schedule and task tracking
• Production implementation
• Warranty support

Confidential

Segment lead

Responsibilities:

• Development and Unit Testing using AbInitio
• Analyzing and understanding the functional and non-functional requirements
• Preparing necessary design documents (Physical Design Document, Technical Design document, Metadata document, Playbook, etc.)
• Coding - Designing complex Ab Initio graphs and plans using ETL tool Ab Initio
• Testing of the ETL Code (Unit Testing, Functional and System Integration Testing, Client Acceptance Testing) and creating test case documents
• Documenting the artifacts and ensuring that the output is as per the given business specifications and SLA
• JCL creation and migration of Code to higher and improved environment
• Direct client interaction for different modules and involved in the end to end SDLC (Software development Life Cycle) processes of software development.
• Working on “Go Live” activities as per implementation plan to enable successful production implementation of the application.
• Responding to production issues as per SLA
• Responding to issues assigned, conducting impact analysis, suggesting and implementing workarounds, communicating to all stakeholders and closing issues as per agreed timelines in order to ensure support availability as per agreed SLA’s Warranty support

Confidential

Offshore Lead

Responsibilities:

• Analyzing and understanding the business requirements
• Preparing necessary design documents (Physical Design Document, Technical Design document)
• Coding - Developing Graphs and plans to extract data from various sources using ETL tool Ab Initio
• Gathering data files from external vendors, cleansing the data for any invalid data, applying business rules and transformation to publish the data for downstream applications along with loading data into DB2 tables
• Testing of the ETL Code (Unit Testing, Functional and System Integration Testing, Client Acceptance Testing)
• JCL creation and migration of code to a higher environment
• Implementation of the project in production along with post implementation support and KT to PSO

Confidential

Abinitio Developer

Responsibilities:

• Analyzing and understanding the functional and non-functional requirements
• Preparing necessary design documents (Physical Design Document, Technical Design document, Metadata document, Playbook, etc.)
• Coding - Designing complex Ab Initio graphs and plans using ETL tool Ab Initio
• Testing of the ETL Code (Unit Testing, Functional and System Integration Testing, Client Acceptance Testing) and creating test case documents
• Documenting the artifacts and ensuring that the output is as per the given business specifications and SLA
• JCL creation and migration of Code to higher and improved environment
• Direct client interaction for different modules and involved in the end to end SDLC (Software development Life Cycle) processes of software development.
• Working on “Go Live” activities as per implementation plan to enable successful production implementation of the application.
• Responding to production issues as per SLA
• Responding to issues assigned, conducting impact analysis, suggesting and implementing workarounds, communicating to all stakeholders and closing issues as per agreed timelines in order to ensure support availability as per agreed SLA’s

Confidential

Abinitio Developer

Responsibilities:

• Analyzing and understanding the business requirements
• Preparing necessary design documents (Physical Design Document, Technical Design document)
• Coding - Developing Graphs and plans to extract data from various sources using ETL tool Ab Initio
• Gathering data files from external vendors, cleansing the data for any invalid data, applying business rules and transformation to publish the data for downstream applications along with loading data into DB2 tables
• Testing of the ETL Code (Unit Testing, Functional and System Integration Testing, Client Acceptance Testing)
• JCL creation and migration of code to a higher environment
• Implementation of the project in production along with post implementation support and KT to PSO

Confidential

Abinitio Developer

Responsibilities:

• Involved in Ims Translation
• Perform Transformation and Validation Process.
• Developing generic Abinitio graphs.
• Involved in Unit Testing, Documented Test Cases for every individual graph.
• Well versed in components like Partition by Key, Partition by round robin, reformat, rollup, normalize, join, scan, gather, replicate, merge etc.
• Worked on improving the performance of Ab Initio graphs by using Lookups, In-Memory Joins and parallelism techniques