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.

-------------------------------------------------------------------------------------------------------------------------------

SKILLS

---------------------------------------------------------------------------------------------------------------------

• 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

-------------------------------------------------------------------------------------------------------------------------------

PROJECT EXECUTION

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

SOFTWARE DEVELOPMENT

• 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.
• Attended Cognizant Academy trainings in Informatica, Teradata and OBIEE.
• Conducted various training sessions in Abinitio for team members.

-------------------------------------------------------------------------------------------------------------------------------

PROJECTS EXECUTED

-------------------------------------------------------------------------------------------------------------------------------

Confidential

• 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

• 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

• Single handedly built new process and standards for delivering custom deliverables for new product. This project followed agile methodology.
• 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

• Lead a team of 10 to enhance an existing application to bring in Unicode data.
• Was responsible for project management activities, code reviews, training 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

• 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

-------------------------------------------------------------------------------------------------------------------------------