SUMMARY:

• Received several commendations for consistently surpassing Service Level Agreement targets, including delivery, application availability, and support call turnaround time
• In the year 2010 performance tuned a critical Walgreen forecasting batch application to reduce its run time by 10 hrs compared to the way it was designed in 2003, this was counted as one of the biggest performance improvements in Walgreen inventory portfolio
• More than 10 years of experience in requirement analysis, software development, design, testing, implementation and supporting applications in Ab initio, UNIX, Perl, Pl/Sql and Windows environments
• 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 Versions1.10, 1.11, 1.14, 3.0.2, 3.1.7) (CO>OP Versions 2.10, 2.11, 2.14, 3.0, 3.1.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 and XML processing.
• Extensively involved in critical production support project with time bound SLAs
• Excellent in doing business system analysis and RCA, helped business users in resolving lots of errors in the business process flows implemented in various applications
• Strong experience with batch job automation tool ESP scheduler
• Extensive experience of designing and deploying runsheets
• 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 Financial 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.

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Senior Ab Initio Developer/Computer Programmer Analyst

• 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.

Environment: Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Pl/Sql

RDBMS: ORACLE 11g

Special Software: Ab Initio (GDE: 3.1.7, CO>OP: V3.1.7), Putty, Control-M, Pl/Sql Developer, Share Point, Quality Center, WINSCP, HP Open View Service Center, Teradata.

Confidential, Durham, NC

Senior Ab Initio Developer/Team Lead

• 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.

Environment: Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Pl/Sql

RDBMS: ORACLE 11g

Special Software: Ab Initio (GDE: 3.1.6, CO>OP: V3.1.5), Putty, Control-M, Pl/Sql Developer, Share Point, Quality Center, WINSCP, Teradata.

Confidential, Deerfield, IL

Senior Ab Initio Developer/Team Lead

• 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.

Environment: Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 11g

Special Software: Ab Initio (GDE: 3.0.2, CO>OP: V3.0), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VM Ware, Remedy, Share Point, JIRA, TRMC, SFTP, WINSCP.

Confidential, Deerfield, IL

Senior Ab Initio Developer/Team Lead

• 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.

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 11g

Special Software: Ab Initio (GDE: 3.0.2, CO>OP: V2-14), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VM Ware, Remedy, Share Point, JIRA, TRMC, SFTP, WINSCP.

Confidential, Deerfield, IL

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.

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 9i

Special Software: AbInitio(GDE: 1.14, CO>OP: V2-14), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VM Ware, Remedy, Share Point, JIRA.

Confidential, Deerfield, IL

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.

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 9i

Special Software: AbInitio(GDE: 1.14, CO>OP: V2-14), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VM Ware, Remedy, Share Point, JIRA.

Confidential, Deerfield, IL

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.

Environment: Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 9i

Special Software: AbInitio(GDE: 1.14, CO>OP: V2-14), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VM Ware, Remedy, Share Point, JIRA.

Confidential, Lincolnshire, IL

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.

Environment: Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 9i

Special Software: Ab Initio, Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS

Confidential, Lincolnshire, IL

Senior Ab Initio Developer/Analyst Programmer

• 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

Environment: Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 9i

Special Software: Ab Initio, Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS

Confidential

Ab Initio Developer/Assistant Systems Engineer

• 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

Environment: WindowsNT, Toad, UNIX, Oracle9i, WindowsNT, Visio2000, AbInitio(1.10, 1.11), VSS, IMS, CVS, ESP, Putty, Pl/Sql Developer

Confidential

Ab Initio Developer/Assistant Systems Engineer

• Analyzed functional requirements and converted them to technical requirements and design
• Responsible for Source System Analysis, Process and Database Design, Development and Testing of all process and code components
• Wide usage of lookup files while getting data from multiple sources and size of the data is limited
• Created Ab-Initio multi file systems (MFS) to take advantage of partition parallelism
• Implemented a 36 way multi file system that was composed of the individual files on different nodes that were partitioned and stored in distributed directories
• Uncompressed the source data coming from external servers using the GUNZIP component and translate the data from EBCDIC to ASCII
• Created summary tables using ROLLUP and SCAN components and verified graph accuracy based on business logic
• Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions and tested various graphs for their functionalities
• Responsible for making sure that data is clean, consistent, and synchronized across platforms
• Identified ways to speed up current Ab-Initio graphs to maximize performance
• Automated both monthly and weekly refresh (data load) using the ESP scheduler
• Created ESP jobs to run the different application at a time

Environment: UNIX, Oracle9i, WindowsNT, Visio2000, AbInitio(1.10, 1.11), VSS, IMS, CVS, ESP, Putty.

Confidential

Ab Initio Developer/Assistant Systems Engineer

Responsibilities:

• This project was tested and implemented successfully. My duties and responsibilities as a team of five included active participation in analysis, design, development and testing of the system using Ab initio, Unix, perl and Pl/Sql
• Analyzed functional requirements, mapped documents and assisted in problem solving and trouble shooting
• Worked with different application groups and delivered effective solutions
• Extensively involved in testing of interface issues
• Database integrity testing by executing SQL statements
• Performed Regression testing to verify the previously identified defects fix
• Documented bugs and reported them to the respective personnel
• Participated in Walkthrough and Defect report meetings periodically
• Extensively involved in Manual Testing and Regression testing
• Involved in code promotion and job creation on ESP

Environment: HP UNIX, Solaris 2.6, Oracle 9i, Windows 95/NT, AbInitio(1.10, 1.11), VSS, IMS, CVS, ESP, Putty.