SUMMARY

• Around 1 year of design and development experience in Informatica Power Center V6 and V7, C and C++
• Worked extensively on ETL tool Ab - Initio (GDE Versions 1.10, 1.11, 1.14, 3.0.2, 3.1.7, 3.2.6) (CO>OP Versions 2.10, 2.11, 2.14, 3.0, 3.1.7, 3.2.7)
• Strong relational database development skills using PL/SQL, Oracle 11g
• Knowledge in EME check - in, check - outs and sandbox creation
• Worked on TRMC tool for maintaining EME repository, code promotion, creating tags and save files
• Worked on Continuous flows, Conduct>It, XML processing and Web Services
• Extensively involved in critical production support project with time bound SLAs
• In depth experience in doing business system analysis and RCA, helped business users by identifying gaps in business rules implemented in AbInitio flows of various applications
• Strong experience with batch job automation tools like ESP scheduler and Control M
• Experience in data modeling concepts like STAR schema and snow flake schema
• Experience in object oriented design/analysis
• Provided Ab Initio best practices to different clients
• Worked extensively in implementing data warehouse applications and business intelligent applications
• Extensive Knowledge in Retail, Health Care, Telecommunications and Finance Projects

TECHNICAL SKILLS

Platform: Sun Sparc, x86, IBM Compatible PC family.

OS: UNIX, Solaris 2.6, MS-DOS, Windows-95/98 and Windows NT.Languages C/C++, Java, Perl.

SQL & RDBMS: DB2, Oracle 9i/11g, PL/SQL.

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

Tools: Abinitio, TRMC, Informatica, Toad, Pl/Sql Developer, Putty, Telnet, WinScp, SFTP, SFD, VSS, CVS, Visio2000, RTC, SNOW, MFT, ALIS.

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Senior Ab Initio Developer/Lead/Analyst

Responsibilities:

• Conduct meetings with business users and analysts to understand the project scope and requirements.
• Analyze the database model that needs to be setup for PIMS application.
• Analyze the database tables and different types of constraints as per the PIMS application.
• Analyze the currently operational sources for Business Entity, Provider, Practitioner and other relevant information, understand their E-R models and significance of primary fields.
• Create high-level design to migrate & transform the information from existing sources to the database of new application PIMS.
• Develop graphs in Ab Initio & Pl/Sql to transform & migrate the information related to Business Entities, Providers, Practitioners, their locations, specialties, affiliations & networks.
• Develop wrapper script in Unix to execute graphs designed in Ab Initio & Pl/Sql from the backend in QA, Pstage & production regions, region specific parameters are evaluated and passed on to the graphs by the wrapper script.
• Perform unit testing of graphs & wrapper script and resolve any errors encountered.
• Analyze the performance of the developed processes and make improvements where required.
• Work with the QA team to build exhaustive test cases and co-ordinate with them during the entire testing process.
• Create jobs and work on the plan to create an automated schedule in production.

Confidential, Durham, NC

Senior Ab Initio Developer/Team Lead

Responsibilities:

• Conduct meetings with business users and different project groups to understand the project scope and requirements.
• Understand the E-R data model for all different interacting applications.
• Understand the canonical format as defined by EIM for all different applications.
• Conduct meetings with different application groups to understand the VDXF and CDXF formats along with the significance of various attributes for various applications.
• Create high level design of ETL adapters for various interfacing application systems
• Design continuous flows to process the data in real time.
• Design plans in Conduct>IT to perform conditional run of Ab Initio processes and conditional integration of different processes.
• Pass on all the requirements and knowledge gathered to offshore team.
• Work with Offshore team to create low level design and develop Ab Initio processes.
• Provide technical direction to all team members and ensure on-time deliveries at various stages of project life cycle.
• Work with the QA team to build exhaustive test cases and co-ordinate with them during the entire testing process.
• Provide guidance to the developers in implementing some complicate business rules in the Abinito codes.
• Co-ordinate with BCBS team to get all required accesses for the team members to design/develop/test/deploy the project codes/deliverables.

Confidential, Deerfield, IL

Senior Ab Initio Developer/Team Lead

Responsibilities:

• Participation in all the stages of agile project development life cycle.
• Development of high performing, easily maintainable Abinitio graphs and shell scripts.
• Held meetings with business users and gathered business requirements along with other senior members of the team.
• Co-ordinated with the front end application teams to understand the type of data business users could process through web apps and structure the Ab initio implementation accordingly.
• Carried out risk analysis to identify risk areas for the given project.
• Created high level and low level design document for processing each feed and documented the various implementations done during the course of the Project.
• Created reusable transformations to implement specific business rules in Ab Initio codes.
• Generated ASCII metadata from the COBOL copybooks and validated those against the sample data sets.
• Providing technical direction to all team members, and ensuring on-time delivery of all projects
• Provided guidance to the developers in implementing some complicate business rules in the Abinito codes.
• Involved in code reviews and performance tuning the Ab initio codes.
• Helped the QA team in creating exhaustive list of various test scenarios.
• Managing and supervising technical team of 12 developers and other roles; managed development, maintenance and production support services to meet clients' business needs and deadlines.
• Interfaces with L1 & L2 support teams to define operational processes and procedures.
• Created work orders for the project based on the project plans discussed with WAG managers and got them approved.

Confidential, Deerfield, IL

Senior Ab Initio Developer/Team Lead

Responsibilities:

• Conducted meetings with WAG managers and business users to understand project scope, budget and delivery timelines.
• Carried out risk analysis to identify risk areas for the given project.
• Created work orders for the project based on the project plans discussed with WAG managers and got them approved.
• Held meetings with business users and gathered business requirements along with other senior members of the team.
• Created high level and low level design document for processing each feed and documented the various implementations done during the course of the Project.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope of the project.
• Providing technical direction to all team members, and ensuring on-time delivery of all projects
• Provided guidance to the developers in implementing some complicate business rules in the Abinito codes.
• Involved in code reviews and performance tuning the Ab initio codes.
• Helped the QA team in creating exhaustive list of various test scenarios.
• Managed and supervised technical team of 14 developers and other roles; managed development, maintenance and production support services to meet clients' business needs and deadlines.
• Tracking team member performance against schedule and targets, providing feedback, resolving issues, and coordinating changes to enhance project performance.
• Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.

Confidential, Deerfield, IL

Senior Ab Initio Developer/Team Lead

Responsibilities:

• Participated in Software Requirements Specifications (SRS) meetings with various downstream application teams and stake holder business groups.
• Assessed risks and hazards to the success of the project and took appropriate measures for avoidance.
• Managed and supervised technical team of 12 developers and other roles; managed development, maintenance and production support services to meet clients' business needs and deadlines.
• Coordinating directly and indirectly with project staff to ensure successful completion of the project - directed, supervised, supported and coordinated the project team members/staff.
• Involved in developing high level and low level design document for processing each feed and documented the various implementations done during the course of the Project.
• Developed number of Ab Initio generic graphs and reusable transforms based on different business requirements.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.
• Providing technical direction to all team members, and ensuring on-time delivery of all projects
• Provided guidance to the developers in implementing some complicate business rules in the Abinito codes.
• Traced, analyzed and resolved various issues related to project constraints that came up during the course of the project, also held meetings with clients for same.
• Involved in code reviews and performance tuning the Ab initio codes.
• Reporting on project progress and communicated relevant information to superiors and company management.
• Involved in UAT along with development/QA team and WAG business users.
• Supervised the migration and deployment of codes to the production environment.
• Post deployment followed up with clients to verify satisfaction.
• Coordinating the lessons learned process.

Confidential, Deerfield, IL

Senior Ab Initio Developer/Analyst Programmer

Responsibilities:

• Managed and supervised technical team of 11 developers; managed development, maintenance and production support services to meet clients' business needs and deadlines.
• Interacting with customer as well as team for requirement gathering, risk assessment, finalization of technical specifications.
• Coordinated directly and indirectly with project staff to ensure smooth execution of the project - directed, supervised, supported and coordinated the project team members/staff.
• Responsible for identifying cross-project issues and work with R&D management to identify and implement solutions.
• Ensure project compliance with company Software Quality processes.
• Responsible for software design reviews, peer code reviews and software acceptance test activities on a regular basis.
• Involved in developing high level and low level design document for processing each feed and documented the various implementations done during the course of the Project.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.
• Providing technical direction to all team members, and ensuring on-time delivery of all projects
• Provided guidance to the developers in implementing some complicate business rules in the Abinito codes.
• Extensively worked on fixing the performance issues and gaps between business rules and designs implemented throughAbinitio Graphs.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.
• Involved in UAT along with development/QA team and WAG business users.
• Supervised smooth implementation of the project and extended post-implementation, application maintenance and technical support.

Confidential, Deerfield, IL

Senior Ab Initio Developer/Analyst Programmer

Responsibilities:

• Managed and supervised technical team of 11 developers; managed development, maintenance and production support services to meet clients' business needs and deadlines
• Interacting with customer as well as team for requirement gathering, risk assessment, finalization of technical specifications.
• Handle the tasks of tracking progress of projects against goals, objectives, timelines, and budgets. Generatedstatus reports
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Extensively involved in various iterations for designing and developing the code.
• Extensively used Ab Initio (GDE Ver 1.13.27 and GDE 1.14.31) and EME for ETL processing.Created dynamic DMLs and complex XFRs wherever required.
• Involved in developing high level and low level design document for processing each feed and documented the various implementations done during the course of the Project.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.
• Providing technical direction to all team members, and ensuring on-time delivery of all projects
• Provided guidance to the developers in implementing some complicate business rules in the Abinito codes.
• Extensively worked on fixing the performance issues and gaps between business rules and designs implemented throughAbinitio Graphs.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.
• Involved in UAT along with development/QA team and WAG business users.
• Supervised smooth implementation of the project and extended post-implementation, application maintenance and technical support.

Confidential, Lincolnshire, IL

Senior Ab Initio Developer/Analyst Programmer

Responsibilities:

• Co-ordinated between teams of different modules PSO, Interfaces and SDF for smooth execution of the project.
• Managed and supervised technical team of 11 developers; managed development, maintenance and production support services to meet clients' business needs and deadlines.
• Handle the tasks of tracking progress of projects against goals, objectives, timelines, and budgets. Generatedstatus reports
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Extensively involved in various iterations for designing and developing the code.
• Extensively used Ab Initio (GDE Ver 1.13.27 and GDE 1.14.31) and EME for ETL processing. Created dynamic DMLs and complex XFRs wherever required.
• Involved in developing high level and low level design document for processing each feed and documented the various implementations done during the course of the Project.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.
• Providing technical direction to all team members, and ensuring on-time delivery of all projects
• Provided guidance to the developers in implementing some complicate business rules in the Abinito codes.
• Extensively worked on fixing the performance issues and gaps between business rules and designs implemented throughAbinitio Graphs.
• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.
• Involved in UAT along with development/QA team and WAG business users.
• Supervised smooth implementation of the project and extended post-implementation, application maintenance and technical support.

Confidential, Lincolnshire, IL

Senior Ab Initio Developer/Analyst Programmer

Responsibilities:

• Developed high level and low level design document for processing each feed and documenting the various implementation done during the course of the Project
• Created the mini specs for different applications
• I was involved in Source System Analysis, Process and Database Design, Development and was involved in source to target mapping discussions
• Involved in review the data Analysis, best practices
• Written several unix control scripts, specific to application in order to pass the environment variables
• Involved in code reviews, performance tuning strategies at abinitio and Database level
• Writing the .dbc and .cfg files for the Development, Testing and Production Environments
• Testing of all process and code components
• Involved in different types of testing including system testing, integration testing, regression testing, parallel Testing, Whit Box testing and Black box testing
• Involved in project promotion from development to UAT and UAT to promotion
• Involved in Production implementation best practices
• Involved in migration of code from DEV to QA and also from QA to PROD by using CMAT tool
• Wrote UNIX shells scripts (K Shell) to generate test data, extracts test data, and load data to Oracle database
• Extensively worked with PL/SQL, SQL in Oracle database
• Used ESP for Scheduling the Jobs and setting up the Jobs for execution

Confidential

Ab Initio Developer/Assistant Systems Engineer

Responsibilities:

• Adhered to local development guidelines, standards, best practices and procedures as well as SDLC
• Created, maintained and supported data warehousing applications and processes
• Developed shell scripts for many purposes and automation of environment setup and wrapper
• Participated in various data cleanse and data quality exercises
• Involved in Production implementation best practices
• Interfaced with multiple groups and prepared document results.
• Involved in migration of code from DEV to QA and also from QA to PROD
• Involved in different types of testing including system testing, integration testing, regression testing, parallel Testing, Whit Box testing and Black box testing
• Developed test cases and planned to complete the unit testing, SIT and UAT
• Development of SQL queries to check the data retrieval from database using Toad6.3