OBJECTIVE:

• To work in a challenging environment that provides opportunity to learn key technology areas, be an effective team player in developing projects and to be an asset for the organization by delivering to the best of my capabilities.

SUMMARY:

• 7+ years of experience in work with Confidential Technology Solutions India Pvt, Ltd. ( http://www. Confidential .com/)
• Having around 7+ years of experience in Datastage and Informatica development, Oracle, Sybase, SQL & Db2, development, performance tuning, ETL & mentoring.
• Well versed in Analysis, Planning, Design and Development, Testing, Debugging, Implementation, Maintenance and support phases of software project life cycle
• Possess good Communication and interpersonal skills coupled with a spirit of teamwork
• Skilled at handling multiple tasks and projects simultaneously under tight schedules
• Exposure to Manlog, Life Sciences and Health Care domain
• Exposure to Control M Job and Tivoli scheduling tool
• Capable of being a good leader and also gained appreciations for having taken up work with responsibility and helped moving the project at better pace to make the schedule go smoother
• Was involved in the activities for the freshers to the project
• Support and like to participate in more of Knowledge sharing sessions which helps us work efficiently and avoid wastage of time and also to improving Business knowledge
• Adaptable to any sort of work assignments and can endure stressful environment
• Involved in the core development activities in the projects and played a key role in problem solving in case of critical issues
• Participated in many Knowledge sharing sessions which helped the team to work efficiently, avoid wastage of time and improved Business knowledge
• Adaptable to any sort of work assignments and can endure stressful environment
• Received regular client exposure through status review meetings with clients
• Worked with Business team during Business Requirement phase and being Subject Matter Expert in projects.
• Supported other Technical team to understand projects and coordinated between Business teams & Technology teams
• Involved Performance improvement of Db2, Sybase, Datastage jobs and automated processes to reduce manual efforts
• Involved in Environment set up & configurations
• Lead & coordinate both Development & QA teams in project life cycle
• Involved & lead responsibility of Development & QA execution till the Prod release
• Maintaining quality deliverable and also involved in all the reviews of the deliverables to the client
• Involved in Developing Value adds to the projects and coordinated with Business team validations to ensure quality data loads in Production
• Successfully executed & accomplished projects with qualitative deliverables as Project Lead
• Involved project development activities with multiple technologies (ETL, Oracle, Unix, SQL Server, Business Objects XIR2, Mainframes)
• Participated in giving the testing approaches, Test plans and Business teams for taking control of complete testing and represented the Confidential testing team
• Built excellent Confidential offshore testing team by providing KT in less time span
• Worked with Business teams to prepare the expected results and proposed automated approaches for deriving expected results
• Built very good working relationship with the Business and Technology teams
• Become a trusted partner for Business teams & become SME in application
• Excellent project functional knowledge and versatile & compatible with Technologies
• Involved & provided code changes to improve processes performance

TECHNICAL SKILLS:

Technologies: Data Warehousing

Data Warehousing Tools: Data stage 7.5.2, 8.5 Parallel Edition and Data Stage 7.5.1 Server Edition, Informatica 8.6

Operating Systems: DOS, UNIX, Windows NT/ 2000/XP

Databases: Oracle 8i/9i/10g, DB2, Teradata V2R5, SQL Server, Sybase

Other applications &Utilities: Business Objects X1 R2 and Performance Management Dash Boards, Control M, Tivoli Scheduling Tools

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• The scope of the work is to replace the current provider XPF transformational process to a newer architecture based on DataStage without changing the input (PIMS Database) and output (XPF Provider keyword file generated for Facets). The DataStage interface will extract pertinent data from the PIMS Database, supplement that data as required from the PIMS database, and in corporate identified translation - rules to complete the transformation to generate XP/F file that can be imported into Facets for further processing.

Confidential

Team Lead

Responsibilities:

• Involved in designing and developing of ETL jobs

Confidential

Team Member

Responsibilities:

• Involved in designing and developing of ETL jobs

Confidential

Team Member

Responsibilities:

• Involved in Requirements gathering through discussions with Business users of IC Team.
• Involved in designing and developing of ETL jobs for all the Four releases.
• Involved in the testing of the ETL jobs.
• Involved in report development and Dash board creation.
• Involved in the testing of the reports .

Confidential

Team Member

Responsibilities:

• Involved in analysis of the IBIS Downstream jobs.
• Involved in designing and developing RAMS,BPM,SIM,E-Forecaster, Reflect -1 and Reflect-2 jobs.
• Involved in the testing of the ETL jobs.

Confidential

Team Member

Responsibilities:

• Involved in Designing and Development of ETL jobs.
• Involved in Unit testing of ETL jobs.
• Ensured quality deliverable with process compliance.