SUMMARY

• An astute professional with 6 years of IT experience in Development, Implementation and Support in different projects including data warehouse.
• Presently associated with Confidential as ‘Analyst Programmer’ and working on the in - house projects for One-Africa Segment.
• Good experience in Developing, deployment, delivery activities & Supporting Ab Initio ((GDE Versions 1.15, 3.0.2) (Co>OP Versions2.15, 3.0)) ETL applications & used most of the GDE components in Ab Initio and well versed with the Data Warehousing concepts.
• Experienced in ETL process using Informatica Power Centre (9.5). Strong in building data mapping from Source to Target and Creation of various mappings by using different transformations in informatica.
• Good knowledge in Creating graphs using various components like Input, Output (Table/File), Filter by expression, Rollup, Scan, Sort, Dedup sort, Reformat and Join in Ab Initio.
• Extensive knowledge and working experience in version controlling and managing Metadata using Ab Initio EME
• Good experience on OAT testing and SIT testing and pre-production activities.
• Develop data integration standards according to the organization's information services policies as well as best practices
• Having knowledge in data warehouse concepts and Strong Dimensional modelling skills.
• Extensive experience with analysis, design, development and implementation ofDataWarehouse and BI applications.
• Good knowledge on Teradata Architecture and Teradata Objects for developing application.
• Creating the tables and writing queries as per the requirements in Teradata.
• Hands on experience in creation of small UNIX scripts, having experience in creation, maintenance and monitoring of Tivoli Schedules.
• Good knowledge in multi file system and partition and De-Partition components, worked on the enhancements of the design without affecting the Existing Code
• Having good Knowledge in tools like Service manager-7 and Service Now.
• Possess strong communication, relationship management, coordination and delegation, analytical and problem-solving skills.
• ITIL Foundation Certified from Mar-2014

TECHNICAL SKILLS

Platform: Sun Sparc, x86, IBM Compatible PC family

Operating Systems: LINUX, UNIX, Solaris 2.6, MS-DOS, and Windows NT, XP, 2003

Languages: C/C++, .Net, SQL

SQL & RDBMS: Oracle 9i/11g, Teradata

Tools: Ab Initio, Informatica, TRMC

Scheduling Tool: Tivoli, CA, Control M scheduler

Other: UNIX Shell Scripting, Vi, MS Office, MS Excel, Power Point, MS Word

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Ab Initio Developer

Responsibilities:

• Involved in design and technical discussions.
• Creation of Technical design documents, like LLD and HLD, and development of Ab-Initio graphs & psets as per requirement by using GDE.
• Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business.
• Involved in Connectivity establishment between UKDC and SADC servers.
• Creating reusable graph and Script that can be used in the project and also can be used across different other projects.
• Creating the tables and views as per the requirements in Teradata.
• Involved writing the scripts using Teradata SQL as per requirements and creation of Teradata tables & views as per Design specifications
• Raising request for code movement from one environment to another environment.
• Done appropriate Unit-Level testing of work products by creating Unit Testing Plan and document and test execution steps as per requirement for the Ab Initio deliverables.
• Maintaining the Test the results, defects logs and Raising QC request as required, Implementation of negative testing.
• Creation of Unix scripts to run the psets and creation of Scripts to automate the manual work on daily basis.
• Involved in designing and preparing Test scenarios, Test plans, Test cases and Test data. Throughout the project conducted system testing, integration testing, unit testing, functional testing and negative testing.
• Used Application lifecycle Management for Test Plans, Test Lab and Test run to prepare test cases and execute test cases.
• Modification of Standard Unix scripts as per project requirement.
• Creation of SQL quires to validate the data which has been loaded through Ab Initio and creation of required Tables in test environment.
• Creation of Technical design documents, development of Informatica Mappings.
• Creation of Concurrent workflows for different countries.
• Importing source / target tables from the respective database and created reusable transformations, mapplets and mappings using Designer.
• Developed Lookups and Stored Procedure transformations.
• Raising Change Request for TWS schedule, Database creation etc.
• Creation of Test case for SIT, & creation of SIT Testing execution plan.
• Modifying the Frame work mappings and scripts according to project requirement.

Confidential

Ab Inito Developer

Responsibilities:

• Getting the requirement from the client and regular interaction with the client and the team.
• Involved in Creation of Technical design documents and Creation of EME Structure as per Confidential standards
• Creation of DML’s for all files.
• Creation of UNIX Scripts to transfer the reports to corresponding country wise directories.
• Used the Standard Unix Scripts where it requires, and modification of the scripts as per project requirement.
• Development of Ab-Initio graphs, Unit Testing Plan/Document and Unit Test Execution steps as per the requirement .Peer review of the deliverables.
• Provide Guidance in SIT testing to SIT tester and creation of UNIT test cases.
• All the code Migrations from Development to SIT, UAT, OAT and Production and checkout of the project in SIT, UAT, OAT and production.
• Understanding the high level scope of the project
• Preparing the test case document and plan
• Creating reusable graph and Script that can be used in the project and also can be used across different other projects.
• Support for OAT and Production for 2 months.
• Creation of Support Document and involved in hand over of application to support team.

Confidential

Ab Inito Developer

Responsibilities:

• Involved in writing the test cases and Tested of created graphs.
• Running the graphs in SIT Environment.
• Maintaining the Source files record count data on daily basis.
• Raising QC request as required.
• Raising the required request for code movements.
• Involved in migrating the code from Development Environment to UAT Environment.
• Done appropriate unit-level testing of work products and the management of the review process for the Ab Initio deliverables.
• Used conman and composer scheduling commands to test scheduling definitions and scheduling status.
• Used Web Eme to see the Graph status and Latest Tags.
• Used Oracle SQL to test whether the data has loaded properly or not.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Support for OAT and Production for 2 months.
• Creation of Support Document and involved in hand over of application to support team.