SUMMARY:

• 8 Years experience in SDLC from requirements gathering to delivery for complex data warehouse applications.
• Expert in ETL methodologies and data warehousing concepts with excellent troubleshooting skills.
• Excellent leadership skills in leading teams to develop customized applications.
• Proficient in converting business requirements into technical specifications.
• Superior analytical, time management, collaboration and communication skills.
• Cheerful personality, positive attitude and team player.
• Experienced in managing a team of 10 associates.
• Coordinate with project managers, business analysts and clients for requirement gathering and finalization of technical specifications.
• Proactive communication with clients and senior management on project status and issues.
• Maintained high quality standards through reviews and methodical QC process.
• Started a club in current account to enhance communication and presentation skills of peers.
• Handled various technical aspects like project documentation, system design and development, unit testing, coordinate system testing and Implementation.
• Experienced in development, migration and application maintenance projects.
• Experience in Redesign, develop and implement of existing application from Abinitio to DM Express.
• Expedited large volume testing for QA team by building automation testing modules using Abinitio.

SKILL:

ETL tools: Ab Initio (Version 3.13), SSIS, DM Express

Programming Languages: UNIX Shell Scripting (K - shell) and Oracle PL/SQL

Platform: Windows XP and UNIX

Database: Oracle 11g, SQL Server 2008

Tools: Toad

Schedulers: ESP Workstation

Domain/Functional Area: Life Sciences

PROFESSIONAL EXPERIENCE:

Confidential, Plymouth Meeting, PA

Responsibilities:

• As SME of the Longitudinal Rx (LRx) system played an integral role in the smooth execution of this highly critical project. Identify problem areas and provide innovative, cost effective solutions to complete the deliverables within the targeted timelines.
• Redesign, develop and implement an existing Application from Abinitio to DM Express.
• Used Abinitio to perform Data Investigations to identify and resolve any data concerns.
• Received multiple appreciations from management for complete ownership of this highly critical project and dedication to deliver the project within the tight deadlines.

Technologies used: UNIX, Oracle, Pl/SQL, Abinitio, ESP Workstation

Confidential, Plymouth Meeting, PA

Responsibilities:

• Built new data warehouse and subsidiary data marts to source data from a new ODS system.
• Managed and coordinated an offshore team of 7 associates with various modules in parallel development.
• Expedited large volume testing for QA team by automation using Abinitio.

Technologies used: UNIX, Oracle, Pl/SQL, SQL Server, Abinitio, ESP Workstation

Confidential, Plymouth Meeting, PA

Responsibilities:

• Built custom SSIS jobs and developed reusable code which could be used for different deliverables improving the efficiency and reducing time required for building each deliverable.
• Developed into SME of the system and provided data mining solutions to client service team.
• Maintained high standards of quality in deliverables and was received multiple appreciations from clients.
• Automated various processes to expedite the client delivery and maintain quality standards.

Technologies used: SSIS, T-Sql, SQL Server Database, Mainframe, Microsoft Visual SourceSafe

Confidential

Responsibilities:

• Lead a team of 10 to enhance an existing application to bring in Unicode data.
• Was responsible for project management activities, code reviews, in addition to developing and supporting QA testing.
• Solving technical difficulties in handling Unicode data in Abinitio.

Technologies used: Abinitio, UNIX, Oracle, Cybermation, Microsoft Visual SourceSafe

Confidential

Responsibilities:

• Designing, coding and unit testing the entire modules in Abinitio and UNIX.
• Understanding requirements and coordinating with onsite for effective project execution.
• Worked in UNIX and Oracle Migration Projects.
• Unit testing and Documentation

Technologies used: Abinitio, UNIX, PL/SQL, Cybermation, VSS