SUMMARY:

• To seek a position to utilise my skills and abilities in the services sector that offers professional growth while being resourceful, innovative and flexible.
• Willing to work as a key player and leader in challenging and creative environment.
• 10+ Years of experience in Software Development and Support
• 8+ Years of experience in Sales and Marketing domain in Pharmaceutical vertical.
• 6+ Years of experience in MDM Solution Designing and Delivery
• Expertise in Informatica MDM Tool
• Expertise in Informatica Designer Tool
• Good data and analytical skills
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into design.
• Great communications skills and client handling.
• Ability to lead a team and achieve desired results.
• Awarded external collaboration award by client for delivering robust solution.
• Complete project cycle experience from Requirement Analysis and Development to Testing.

• 10+ years of professional Software development experience.
• 10+ years of experience as Software Engineer and Technology Analyst and Informatica lead.
• 5+ years of experirnce as Informatica MDM Architect/Lead.
• Demonstrated expertise utilizing MDM 9.7.1/9.5.1 (Match and Merge Rules, Trust setup, MRM configurations, Load process,Hierarchy Manager, IDD ).
• Worked in the capacity of a Team lead, Systems Engineer, Technology Analyst, Onsite coordinator, Designer and Lead Developer in different Datawarehouse/ETL/MDM Projects using Informatica, MDM MRM
• Expertise in ETL/Datawarehousing Project Implementation & support for Pharma industry.
• Expertise in MDM Project Implementation & support for Pharma industry.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise in utilizing Informatica Transformations and Performance Optimization techniques to provide robust solution.
• Self - motivated with excellent Consulting Skills not limiting to Analytical, Communication, Interpersonal, Presentation, Leadership Skills & proven ability in Competitive environment.
• Worked in CMMI Level 5 company.
• Experience in projects that have a mix of offshore and onshore teams.

COMPETENCY:

• MDM 9.7.1/9.5.1
• Informatica ETL/Datawarehouse design/development
• Workload Automation
• Data analysis
• Cost/Effort/Resource Management
• Database - Oracle
• Tools- Putty and SSH secure shell.
• Creating work breakdown structures
• Effective Impact Analysis
• Effective Work Progress Tracking
• Manage and lead teams
• Microsoft Word / Excel / PowerPoint
• Worked in Onsite-offshore model
• SDLC Methodology

PROFESSIONAL EXPERIENCE:

Confidential

MDM Architect/Lead

Responsibilties:

• Co-ordination with system owners/ custodians/users of multiple upstream / downstream applications spread across multiple affiliate countries and their support groups to ensure smooth integration and minimum business impact from the changes to existing system
• Designing the Solution. Creating ER Diagrams.
• Finalizing the table structures based on discussion with the various stake holders.
• Finalizing the Match Rules and Trust settings based on discussions with data stewards and data analysis.
• Application development and enhancements in Informatica MDM hub and ETL, PL/SQL, korn shell.
• Development of MDM Match and Merge processes
• Development of MDM Trust settings at MRM.
• Development of MDM Landing to Staging to Base batch jobs.
• Configuring IDD
• Revamp of the whole publish process to the ODS using MDM JMS Message Triggers.
• Identifying risks, business critical issues, performance issues and fixing them.
• Technical/gateway approvals and sign off on following documents:
• Requirement Document
• Design Document
• Mapping Document
• Verifying and Validating the application
• Code Migration to Production and production load monitoring.

Environment:

• Informatica 9.1
• MDM 9.7.1
• LINUX
• HP Quality Center
• Oracle 11

MDM Architect/Lead

Confidential

Responsibilties:

• Co-ordination with system owners/ custodians/users of multiple upstream / downstream applications spread across multiple affiliate countries and their support groups to ensure smooth integration and minimum business impact from the changes to existing system
• Designing the Solution. Creating ER Diagrams.
• Finalizing the table structures based on discussion with the various stake holders.
• Finalizing the Match Rules and Trust settings based on discussions with data stewards and data analysis.
• Finalizing the hierarchies to be built based on business needs.
• Application development and enhancements in Informatica MDM hub and ETL, PL/SQL, korn shell.
• Development of MDM Match and Merge processes
• Development of MDM Trust settings at MRM.
• Development of MDM Landing to Staging to Base batch jobs.
• Creating Product Hierarchies
• Configuring IDD
• Revamp of the whole publish process to the ODS.
• Creating scheduling jobs using CA Workload Automation tool.
• Identifying risks, business critical issues, performance issues and fixing them.
• Technical/gateway approvals and sign off on following documents:
• Requirement Document
• Design Document
• Mapping Document
• Verifying and Validating the application
• Code Migration to Production and production load monitoring.
• Post delivery communication to up/down-stream applications/Support teams and Business

Environment:

• Informatica 9.1
• MRM 9.5.1
• LINUX
• HP Quality Center
• Oracle 11

Confidential

Project Lead

Responsiblities:

• Gathering the requirements from the client by direct interaction.
• Designing the data model based on the requirements.
• Reviewing of Informatica mapping, sessions, sequence of the workflows
• Performance Tuning Informatica code to provide optimized solutions
• Data Analysis
• Work with data stewards to understand data needs.
• Prioritization of tasks/changes
• Onsite co-ordination
• Task distribution to offshore
• Capacity planning
• Deployment planning
• Verifying and Validating the application
• Tracking Project Status on Prochain

Environment:

• Informatica 8.6
• Informatica On Demand
• Linux
• Oracle 11
• Mercury Quality Center.
• Prochain
• Toad

Confidential

Project/Technical Lead

Responsibilties:

• Lead a team of 16 associates who worked to support the system.
• Appraisal of the team members and cater to their future aspirations.
• Create plan of action for new changes.
• Interact with the business integrators and clients on a regular basis in order to understand the new requirements and develop detailed specifications for development of new system features.
• Prioritization of tasks/changes and check capacity utilization.
• Identifying risks, business critical issues, performance issues and fixing them.
• Performing regular code walk-throughs to capture logical defects and to ascertain impact of changing requirements on existing code components.
• Verifying and Validating the application
• Solving user queries and fixings defects.

Environment:

• Informatica Powercenter 8.1 (ETL Tool)
• Oracle
• Linux
• CA Workload Automation tool (Scheduling)
• HP Quality Center.
• Toad

Confidential

Onsite Project Lead

Responsiblities:

• Gathering the requirements from the client by direct interaction
• Designing and development of the data loads for .NET Application
• Prioritization of tasks/changes and check capacity utilization.
• Data analysis for specific needs of .NET Aplication
• Onsite co-ordination.
• Verifying and Validating the application

Environment:

• LINUX
• Informatica 8.1
• Oracle 11
• CA Workload Automation
• HP Quality Center.
• Toad
• Prochain
• SQL Server 2007

Confidential

Developer/Senior Developer

Responsibilties:

• Responsible for gathering all the requirements for the new changes.
• Creating Informatica Mappings/Sessions/Workflows to load the data
• Create schedules in WA
• Compiled business and technical requirements, prepared impact analysis, unit and integration test plans.
• Coordinating with different vendors for issue resolution.
• Responsible for accepting, tracking and reporting Trouble Tickets (TT) and Change Requests (CR) using change management tool called Remedy.
• Performed Unit and System testing.
• Managing, coordinating, planning and executing change request management from functional perspective
• Co-ordination with onsite team

Environment:

• Informatica 8.1
• LINUX
• HP Quality Center
• Oracle 11