SUMMARY

• A Skilled professional with rich around 8 years of experience in information technology industry with a strong background in System Analysis, Design and Development in the fields of AbInitio, UNIX Shell Scripting, Oracle(SQL/PLSQL),DB2,Teradata,Hadoop and Data Warehousing.
• Expertise in multiple industries such as Banking &Financial and insurance Sectors. Experience as a team player with proven ability to interact with various disciplines and work with different levels of management, in order to deliver excellent quality of work.
• Involved in effort estimation, design, development, review, implementation and maintenance of AbInitio graphs.
• Created AbInitio graphs to read and write to HDFS,Conduct IT, Continuous flows,utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process
• Understand and contribute towards Projects’ Technical Design as well, along with the requirement specifications. Involved in preparing HLD and LLD
• Worked on Agile methodology.
• Have worked on Autosys and control - m scheduling tools
• Have played crucial lead role in handling production support L3issues which requires good analytical skill and quick response.
• Sound Skills in structured query language (Oracle SQL).Experience with all phases of SDLC including design, development review and maintenance.
• Worked on waterfall and Agile methodologies.
• Good Knowledge on Dimensional Modeling like Star schema and Snowflake schema.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Good interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies

TECHNICAL SKILLS

ETL Tools: Abinitio/ 1.13/1.15/ 3.1.47/3.1.5.3 co-op:3.2.4.3

Open Source Technologies/ Framework: HADOOP, control Frame work

Programming Languages: C,C++,Java, SQL, PL/SQL, UNIX Shell Script

BI Reporting & Analytical Tools: Micro strategy

Databases: Oracle, DB2,Teradata

Data Modeling: Erwin 4.1/3.5, MS Visio

OS: Windows, UNIX (Red Hat Linux, AIX, Solaris, ).

Tools: MS Office, service now,TOAD for Oracle, SQL developer, Autosys,control-m, JIRA, ITSM

PROFESSIONAL EXPERIENCE

Confidential, Delaware

Team Lead

Responsibilities:

• As a part of the CCB data ecosystem, Chase Data Services (CDS) is a suite of applications, a set of reusable engines and services that will be deployed to allow for automation, data processing, Big Data component and platform
• Integration, self-service data provisioning and data workflow orchestration.
• Understanding the existing Informatica ETL code and converting to Ab Initio Applications.
• Met with business/user groups to understand the business process and to gather requirements for the projecton provision data from Hadoop Reservoir
• Created AbInitio graphs to read and write to HDFS, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process
• Performed requirements gathering from end users and prepared design documents for SOR
• Designed the ETL Framework for logic from existing Informatica design.
• Performed data requirements analysis and flow of data in existing system
• Served as a Subject Matter Expert on assigned projects.
• Assisted in technical specifications and other deliverable documents.

Environment: Abinitio ETL tool, informatica, UNIX, Oracle,DB2, Teradata, Austosys,Hadoop

Confidential, NY

Team Lead

Responsibilities:

• Creation of AbInitio development work products that conform to the stated business requirements and high level design documents.
• Created AbInitio graphs, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process
• Understand and contribute towards Projects’ Technical Design as well, along with the requirement specifications.
• Close participation in all stages of SDLC creation of AbInitio development work products that conform to the stated business requirements and high level design documents.
• Responsible for designing and developing various applications in the project. Analyzing the requirement and development of graphs and scripts to get appropriate results.
• Testing of the graphs and application.
• Involved in Amendments of Graphs.
• Develop test strategy based on design/architectural documents, requirements, specifications and other documented sources
• Develop test cases and test scripts based on documented sources
• Close participation in all stages of SDLC creation using Agile methodology
• Organizing events & conducting Presentations, Trainings, Effective Meetings, Project Status Reporting to Senior Management.
• Coordinates with other team members to ensure that all work products integrate together as a complete solution and adopts a supporting role to any other team member to resolve issues, or to complete tasks sooner

Environment: Abinitio ETL tool, UNIX, Oracle,Autosys

Confidential, NY

Team lead

Responsibilities:

• Created AbInitio graphs Conduct IT, Continuous flows and utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process.
• Preparation of the Business Requirements Document, Functional Specifications Document, UI Specifications, Use cases.
• Understand and contribute towards Projects’ Technical Design as well, along with the requirement specifications.
• Have worked on PDL and Meta Programming
• Testing the solution to validate project objectives.
• Managing the application end-to-end delivery, Ownership of the quarterly application release development and ensure a smooth User Acceptance Testing, issues resolution
• Preparation and review of Test Plans/Scenarios/Test Cases at development, IST, UAT, prod stages.
• Close participation in all stages of SDLC creation of AbInitio development work products that conform to the stated business requirements and high level design documents.
• Done appropriate unit-level testing of work products and the management of the review process for the AbInitio deliverables.
• Tracks and reports on issues and risks, escalating as needed
• Expertly handles last minute requests and stressful situations
• Develop test strategy based on design/architectural documents, requirements, specifications and other documented sources
• Develop test cases and test scripts based on documented sources
• Close participation in all stages of SDLC creation using Agile methodology
• Organizing events & conducting Presentations, Trainings, Effective Meetings, Project Status Reporting to Senior Management.
• Coordinates with other team members to ensure that all work products integrate together as a complete solution and adopts a supporting role to any other team member to resolve issues, or to complete tasks sooner

Environment: AbInitio ETL Tool, oracle, Teradata, UNIX and Autosys

Confidential

Sr. Developer

Responsibilities:

• Creation of AbInitio development work products that conform to the stated business requirements and high level design documents.
• Created AbInitio graphs, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process
• Coordinates with other team members to ensure that all work products integrate together as a complete solution and adopts a supporting role to any other team member to resolve issues, or to complete tasks sooner
• Have worked in UAT and L1 and L2 Production support
• Worked on service now and peregrine tickets
• Monitoring daily, weekly and monthly jobs
• Promoted code to production environment from lower environment
• Handled Database and ETL issues
• Addressed end user queries in timely fashion
• Engaging different teams when load job in failed state.
• Tracks on issues and risks, and Escalations as needed
• Done appropriate unit-level testing of work products and the management of the review process for the AbInitio deliverables.
• Involved in preparing HLD, LLDs. Extensively involved in EME concepts. Preparing the test data to test the developed components
• Designed and developed graphs by using AbInitio
• Developed complex generic and conditionalised AbInitio graphs with emphasis on optimizing performance

Environment: AbInitio ETL Tool, DB2, and UNIX, Control-M

Confidential

Sr.Developer

Responsibilities:

• Created Abinitio graphs, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process
• Coordinates with other team members to ensure that all work products integrate together as a complete solution and adopts a supporting role to any other team member to resolve issues, or to complete tasks sooner
• Involved in preparing HLD, LLDs. Extensively involved in EME concepts. Preparing the test data to test the developed components
• Designed and developed graphs by using AbInitio.
• Developed complex generic and conditionalised AbInitio graphs with emphasis on optimizing performance
• Done appropriate unit-level testing of work products and the management of the review process for the AbInitio deliverables.
• Tracks and reports on issues and risks, escalating as needed
• Expertly handles last minute requests and stressful situations

Environment: AbInitio ETL Tool, Oracle 9i, Unix

Confidential

Sr.Developer

Responsibilities:

• Responsible for designing and developing various applications in the project. Analyzing the requirement and development of graphs and scripts to get appropriate results.
• Testing of the graphs and application.
• Involved in Amendments of Graphs.
• Done appropriate unit-level testing of work products and the management of the review process for the AbInitio deliverables.
• Tracks and reports on issues and risks, escalating as needed
• Expertly handles last minute requests and stressful situations

Environment: AbInitio ETL Tool, Oracle 9i, UNIX

Confidential

Sr.Developer

Responsibilities:

• Creation of AbInitio development work products that conform to the stated business requirements and high level design documents.
• Created AbInitio graphs, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process
• Coordinates with other team members to ensure that all work products integrate together as a complete solution and adopts a supporting role to any other team member to resolve issues, or to complete tasks sooner
• Done appropriate unit-level testing of work products and the management of the review process for the AbInitio deliverables.

Environment: AbInitio ETL Tool, Oracle 9i, UNIX