SUMMARY:

• Enterprise and IT Architect with 15 years of leadership experience in designing innovative business solutions for Confidential Science clients.
• Skilled in information management, application development, and virtualization.
• Demonstrated mastery in evaluating requirements for business application integration and service activation.
• Proven mentor and training with expertise in communicating across organizational levels and with cross - functional teams to drive shared vision and foster culture of excellence.
• Xavier has 15 years of experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center, Data stage, Oracle, and Teradata.
• 7+ years of experience in using Informatica Powercenter 8.1,8.2 & 9.1
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Strong with relational database design & data modeling concepts.
• Strong business understanding of Life science vertical like Sales & marketing and Clinical. Xavier has valuable experience working with top 2 Confidential clients
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills
• Strong expertise in technical domain like RDBMS, ETL, Data Virtualization tools, Hadoop.
• Also he has expertise to work on appliance Teradata 15.1

MANAGEMENT SKILLS:

• Effective communication skills and record for coordination between onsite and offshore teams.
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Managed big onshore team.

TECHNICAL SKILLS:

Operating Systems: Windows XP/7UnixLinux

Languages: SQL, PL/SQL, JAVA

Databases: Oracle 9i,10g,11gTeradata

Big data Technologies: Hadoop

ETL: Informatica 9.1DataStage 7.5Informatica Cloud

Reporting: SAS 9.3

Cloud Computing: Informatica Cloud

PROFESSIONAL EXPERIENCE:

Confidential

ETL Technical Lead & Solution Architect

Tools: Informatica 9.1,Unix, Oracle 10g, SAS 9.3

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Participate and provide insights in data modeling of warehouse
• Design decision and providing architecture framework to client architecture, ETL team members
• Preparation of High level Solution design and presenting to client architecture & business team
• Design, develop and test ETL, PL/SQL, JAVA code artifcats
• Support and resolve issues during System Integration testing and User Acceptance testing
• Conduct demo session to showcase functioning of integration & receive periodic feedback from business.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Drive handover of solution implementation between development & Maintenance Support Operations team.
• Coordination among multiple teams at onshore.

Confidential

Technical Lead & Solution Architect

Tools: Unix, Oracle 10g

Responsibilities:

• Design ETL & Oracle PL/SQL code units
• Preparation of High level Design document
• Development in Informatica 9.1 for extraction, transformation and loading
• Developed Oracle code units like SQL Scripts,Package,Procedure,Function with ETL/business logic
• Development of integration to provide extract files to external vendor
• Support and resolve issues during System Integration testing and User Acceptance testing
• Schedule and drive business UAT discussion & meetings
• Conduct demo of working of module with client architecture & business on periodic basis.

Confidential

ETL& Oracle Data warehouse Technical & Solution Lead

Tools: Informatica 9.1,Oracle 11g, SAS 9.3

Operating System: Windows & Unix

Responsibilities:

• Gathering & Analyzing Business and Functional requirement
• Design ETL & Oracle PL/SQL code units
• Preparation of High level Design document
• Development in Informatica 9.1 for extraction, transformation and loading
• Developed Oracle code units like SQL Scripts,Package,Procedure,Function with ETL/business logic
• Development of integration to provide extract files to external vendor
• Support and resolve issues during System Integration testing and User Acceptance testing
• Schedule and drive business UAT discussion & meetings
• Conduct demo of working of module with client architecture & business on periodic basis.

Confidential

PPM Technical Lead & Solution Architect

Tools: Oracle PL/SQL, HP PPM

Operating System: Windows & Unix

Responsibilities:

• Gather Requirement from customers.
• Coding (involves policy rule coding, sequence flow, status flow, dictionary entries).
• Managing team members and project deliverables
• Responsible for conducting end user trainings on the different Confidential people.
• Responsible for the year end performance appraisal of the Cognizant Confidential automation project team members
• Managing Cognizant team dynamics - specially between offshore and onsite and between team members
• Performance testing of the jobs
• Coordination among multiple teams at onshore.

Confidential

Oracle Technical Lead

Tools: Oracle PL/SQL, Oracle Forms 6i, Maestro

Operating System: Windows & Unix

Responsibilities:

• Participating in requirement gathering and analysis
• Define Logical Data model
• Preparation of High level Design document
• Development in Oracle 10g in form of PL/SQL
• Also as part of responsibilities he interacted with the business on validations to be implemented to ensure data quality is maintained on reporting side for Adverse Event experience for end business users.
• Rigorous and performance testing of the jobs
• Coordination between Onsite and Offshore teams

Confidential

Oracle Technical Lead

Tools: Oracle PL/SQL, Oracle Forms 6i

Operating System: Windows

Responsibilities:

• Participating in requirement gathering and analysis
• Define Logical Data model
• Preparation of High level Design document
• Development in Oracle 10g in form of PL/SQL
• Also as part of responsibilities he interacted with the business on validations to be implemented to ensure data quality is maintained on reporting side for Adverse Event experience for end business users.
• Rigorous and performance testing of the jobs
• Coordination between Onsite and Offshore teams

Confidential

Team Lead

POC Specific Skills: Oracle PL/SQL, Oracle Forms 6i

Operating Systems: Windows & Unix

Database: Oracle

Responsibilities:

• Participating in requirement gathering,data profiling, data modeling for IMS Plantrak and Product Dimension
• Development of PL/SQL Code
• Unit testing of code
• Preparation of High Level Design document
• As a Team lead Xavier was responsible for
• Scheduling and coordinating UAT meeting with business