OBJECTIVE:

Looking a challenging position as a Software engineer in a reputable company to enhance my ability and to develop my skills.

SUMMARY:

• Around 8+ years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various technologies like Ab initio, ETL, Big data (Hadoop), EDI, SAP, Data Warehousing Applications.
• Gained Solid experience in the Analysis, Design, Development and Testing of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.
• Sound technical knowledge of Autosys.
• In - depth Knowledge of promotion and deployment tool as Jenkins, Anthill pro, IBM Urban Code Deploy(udeploy).
• In-depth knowledge of UNIX shell scripting.
• In-depth knowledge of Meta Programming and PDL functions.
• In-depth knowledge of Control center and Express-IT
• Prepared complex SQL queries and worked on various database like DB2, Oracle SQL Developer . knowledge of Hadoop Architecture and various components like MapReduce concepts, Sqoop, Hue and Hive tables to store data into HDFS and processed data using Hive.
• Programming knowledge of JAVA.
• Extensively Testing knowledge in SAP CRM, ECC, Net Weaver, SD module with hands on experience.
• Expert in EDI testing and validating various EDI inbound and outbound documents EDI Maps for various EDI ANSI X12 standard documents in Health care.
• Expertise in working Agile mythology such as SCRUM using Rally, Dev-ops environment and Waterfall mythology.
• Experience in analyzing business specification documents, developing Test Plans, Test Strategy, Test Scope and defining Test Cases and Automating Test Scripts.
• Extensively worked on both Manual and Automated Testing. Performed Smoke, Unit Test, Functional, System and Integration, UAT, Performance and Regression Testing.
• Sound knowledge of test management tool CA Agile Center (Rally), HP ALM, Rational Clear Quest & Jira tools.
• Involved in complete life Cycle Implementation experience in SDLC & STLC : gap analysis, data mapping, writing specifications, design, development, testing, quality adherence, implementation, troubleshooting and customer support.
• Having good domain skills in Banking, Payment domain & Health care services.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Languages: SQL, Unix shell scripting, Java

Databases: Oracle 11g, DB2

ETL Tools: Ab Initio (GDE > 3.3.2) (Co-op system > V3-3-4)

Scheduler: Autosys

Deployment Tools: Jenkins, Anthill pro, IBM Urban Code Deploy(udeploy)

Open source: HDFS, PIG, HIVE, Sqoop.

ERP: SAP ECC 6.0, SAP CRM Portal, SAP NetWeaver

Mapping tools: GXS - Application Integrator (AI)

EDI Standards: ANSI X12, Various Prop formats and SAP Idoc

Test Management Tools and Defect Tracking Tool: CA Agile Center (Rally), HP ALM , HP Quality Center , Rational Clear Quest & Jira.

Other Tools & Utilities: Oracle SQL Developer, Eclipse, Citrix, Edit Plus TOAD, Hue.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Abinitio Developer

Responsibilities:

• Requirement Gathering, Effort Estimation and Analysis impact.
• Developed and Implemented extraction, transformation and loading the data using Ab Initio.
• Work with the team of analysts, developers, testers and drive delivery of ETL Solutions.
• Developed and enhance various Abinitio graphs, Pset, Abinitio plan using Graphical Development Environment (GDE) with various Ab Initio components.
• Gained good Knowledge of Meta Programming and developed several PDL functions.
• Created Source, target and feed in Express-It.
• Developed various Unix shell scripts to perform various functions and data loading.
• Monitor various Jobs in Prod and Pre-Prod environment control center.
• Developed highly generic graphs to serve the instant requests from the business.
• Worked on Express-IT, Acquire-IT and Created Source, target and feed in Express-It
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Promote and deploy code using Jenkins, Anthill pro, IBM Urban Code Deploy(udeploy).
• Query and validate database using SQL and having in-depth knowledge of SQL queries.
• Responsible for creating CR and monitoring the PROD deployment.
• Used Parallelism techniques to partition and process large data simultaneously.
• Reviewing the code developed and checking END-TO-END functionality of code by considering the performance and o/p relevance with the requirements.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs.
• Driving Project deliverables to completion from a Technical/Functional perspective.
• Created database objects like Tables, Synonyms, indexes and Views.
• Data modeling and Technical Design.
• Development and Unit Testing.
• UAT (User Analysis Testing) Support.
• Co-ordinate with the support teams for roll-out, create necessary document for the production migration.
• Support of bug fixes and issues reported.
• Validate the data movement and transformations are done correctly as per the requirement.

Confidential

Abinitio developer

Platform: Abinitio, UNIX, SQL, Hadoop, SAP, EDI

Responsibilities:

• Gained good domain experience on Banking and financial services.
• Developed highly generic graphs to serve the instant requests from the business.
• Worked on applications such as Confidential checkout and apple pay.
• Extensively involved in Ab Initio Graph Design, development and Performance tuning.
• Developed several Abinitio graphs for Confidential checkout application involves customer and merchant data.
• Working in Agile development environment.
• Post production support and ticket resolution within the warranty period.
• Gained good Knowledge of Meta Programming and developed several PDL functions.
• Worked with Infrastructure team to write some custom shell scripts to serve the daily needs like collecting logs and cleaning up data.
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Promote and deploy code using Jenkins, Anthill pro, IBM Urban Code Deploy(udeploy).
• Query and validate database using SQL and having in-depth knowledge of SQL queries.
• Responsible for creating CR and monitoring the PROD deployment.
• Migrated scripts from DEV to SIT and UAT environment to test & validate data.
• Post production support and ticket resolution within the warranty period.
• Experience in writing customized UDF's in java to extend Hive and Pig Latin functionality.
• Created Partitions and Buckets in Hive for both Managed and External tables for optimizing performance.
• Experience in Importing and Exporting the Data using SQOOP from HDFS to Relational Database systems.
• Involved in creating Hive tables, loading with data and writing hive queries.
• Worked on SAP CRM, ECC, Net Weaver, SD module with hands on experience.
• Developed various EDI inbound and outbound documents EDI Maps for various EDI ANSI X12 standard documents in Health care.

Confidential, Herndon, VA

ETL Engineer

Platform: Abinitio, UNIX, SQL

Responsibilities:

• Developed Abinitio graphs using Graphical Development Environment (GDE) with various Ab Initio components.
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Promote and deploy code using Jenkins, Anthill pro, IBM Urban Code Deploy(udeploy).
• Query and validate database using SQL and having in-depth knowledge of SQL queries.
• Responsible for creating CR and monitoring the PROD deployment.
• Migrated scripts from DEV to SIT and UAT environment to test & validate data.
• Developed highly generic graphs to serve the instant requests from the business.
• Deployed and tested several Abinitio graphs in production environment.
• Wrote Unix Shell scripts and PDL functions.

Confidential, Foster City, CA

ETL Engineer

Platform: Abinitio, UNIX, SQL, Hadoop

Responsibilities:

• Developed Abinitio graphs using Graphical Development Environment (GDE) with various Ab Initio components.
• Extensively involved in Ab Initio Graph Design, development and Performance tuning.
• Worked on continuous service graph.
• Gained good Knowledge of Meta Programming and developed several PDL functions.
• Wrote several Unix Shell scripts and PDL functions.
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Promote and deploy code using Jenkins, Anthill pro, IBM Urban Code Deploy(udeploy).
• Query and validate database using SQL and having in-depth knowledge of SQL queries.
• Responsible for creating CR and monitoring the PROD deployment.
• Reviewing the code developed and checking END-TO-END functionality of code by considering the performance and o/p relevance with the requirements.
• Conducting Functional, regression and Integration testing to ensure defect free release.