SAGYA ARUL XAVIER RAJA MINOR

Email id:aczskf@r.postjobfree.com

Cell:+1-847-***-****

Enterprise and IT Architect with 15 years of leadership experience in designing innovative business solutions for Pharma Life 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.

SUMMARY:

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 US Pharma 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/7,

Unix,

Linux

Languages

SQL, PL/SQL, JAVA

Databases

Oracle 9i,10g,11g,

Teradata

Big data Technologies

Hadoop

ETL

Informatica 9.1,

DataStage 7.5,

Informatica Cloud

Reporting

SAS 9.3

Cloud Computing

Informatica Cloud

EDUCATION

EDUCATION

St. Joseph’s College, Trichy, India

VISA

VISA

Green Card

EXPERIENCE

Cognizant Technology solutions, USA – May 2006-Till Date

Cognizant Technology India Pvt India –Jan 2004- Apr 2006

Kumaran Systems India Pvt India –Aug 2003- Dec 2003

Accel ICIM India Pvt India – Jun 2001- Jul 2003

PROJECT DETAILS

Project

Flex Alignment (Jan2015-Till Date)

Role

ETL Technical Lead & Solution Architect

Tools

Informatica 9.1,Unix, Oracle 10g, SAS 9.3

Operating System

Windows & Unix

PROJECT DESCRIPTION:

The ability of the U.S. Market to optimally drive the revenue is limited by customer’s current capabilities. The “Flex” Initiative is focused on removing organizational constraints that are limiting Customer’s ability to evolve.

Involved with customer in building a new data mart called Alignment Master Plus (AM+) to store all Customer’s Sales field alignment data which will be derived from the 3rd party tool, Javelin to which all master data marts are integrated. Developed inbound ETL integration & Oracle PL/SQL to extract, load and transform data in AM+. Around 30 ETL jobs ranging from medium to complex developed to support. Also around 10 Oracle packages and stored procedure also developed.

In addition involved in developing integration to provide data extract from master data mart to external partner as part of outbound integration. Total 72 ETL integration with each integration consisting of medium to complex jobs developed to provide extract in range of 150 million records on daily basis to external vendor.

The purpose of the Flex Alignment is to load sales reps org hierarchy information and sales rep assignment details from AM plus instead of AODS. This AM plus load eventually replaces sub systems AODS, FSMS, SIMON, PRIDE. AM plus is a new repository for organizational data. These RDT structural changes have to be implemented in SOLAR, EPBU, PSI, Telerx and PALI systems. SAM HQ system is required to comply with various regulatory needs, to maintain a common and consistent source of data to support safety data maintenance and reporting business processes. The main purpose of this project is to maintain the sales rep org hierarchy and assignment historical and current data for various business needs. SAM HQ system using this data to generate reports for FDA, reports for site manages and reports for indication managers. SAM is using different sets of reporting tools to generate the reports from sales rep assignment data.

RESPONSIBILITES

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.

PROJECT DETAILS

Project

Sample Operational Data Store

Role

Technical Lead & Solution Architect

Tools

Unix, Oracle 10g

Operating System

Windows & Unix

PROJECT DESCRIPTION:

The purpose of the Sample Operational Data Store project is to maintain the history of sample eligibility check for the customer who used to receive controlled substance products. It is being developed in oracle using agile methodology. SODS consume customer information form customer master, schedule number and product information form global product master. Customer address equivalency is verified with Telerx system. Integration of SAM with the contents of the SODS to validate transactions with controlled substances. Remediation of SAM to consume DEA Number / CDS license-compliant transactions from Veeva. Cancellation of any DTP orders that violate applicable DEA and state rules. Enhancing Physician Audit Letters functionality to handle controlled substances. The physician audit letter shows DEA Number and CDS License Number on image of the sample signature screen. Inclusion of the DEA Number and CDS License Number on the image when the sample receipt is printed upon request. Provide ability to record HCP-initiated returns in SAM against the HCP but not against a rep and send these transactions to PSI. Integration of a controlled substance sample offer service with MedManage. Creation of CDS history and DEA history. SAM will identify all reasons that a DEA address is controlled substance invalid. This is for compliance reporting purposes.

RESPONSIBILITES

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.

PROJECT DETAILS

Project

Sample Accountability Management (Oct 2011-Till date)

Role

ETL& Oracle Data warehouse Technical & Solution Lead

Tools

Informatica 9.1,Oracle 11g, SAS 9.3

Operating System

Windows & Unix

PROJECT DESCRIPTION:

Merck & Co., Inc. Provides various health solutions through its prescription medicines, vaccines, biologic therapies, animal health, and consumer care products. The company's Pharmaceutical segment provides human health pharmaceutical products. The sample account management team is part of global human health solutions delivery group. SAM used to facilitate the management of all sample activity from a sample accountability perspective and also contains components used to facilitate the shipping of samples to the field sales force. Samples online used by HQ to allocate samples, by the field to order samples. Physician audit letters used to print the letters, BRC cards and images for the transactions that are identified as part of the sam disbursement audit process. Paragon imaging loads the scanned image files from the sc414 and sc340 forms into a SQL server database. Field Reporting Reports that are delivered to the field sales force. Headquarters reporting reports that are delivered to the Samples headquarters staff. Electronic sample exception tracking system used to log all exceptions in the insight mobile to SAM process.

RESPONSIBILITES

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.

PROJECT DETAILS

Project

MetLife ITG Support (Jun 2006-Sep 2011)

Role

PPM Technical Lead & Solution Architect

Tools

Oracle PL/SQL, HP PPM

Operating System

Windows & Unix

PROJECT DESCRIPTION:

MetLife ITG support team is responsible for respond and rectify any production issues whether they are system or customer based and modify the PPM application in response to new business requirements or organizational changes. In MetLife, ITG is primarily used by various EI applications groups for Resource and Project Portfolio Management.

HR- Interface with ITG - Interface with Peoplesoft /HR to get Resource information. Data correction in ITG Database and to create Exception Reports to list out the discrepancy and manually/automatically correct the data. Designing Portlets to provide visibility into the service requests / PFM Projects through different portlets and reports. Configuration Management - Digitize the workflow of the acquisition process through Demand Management Module.

RESPONSIBILITES

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 MetLife people.

Responsible for the year end performance appraisal of the Cognizant Sample Operational Data Store 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.

PROJECT DETAILS

Project

Doc Prep Inter Leaf Replacement (Jan-2004-May 2006)

Role

Oracle Technical Lead

Tools

Oracle PL/SQL, Oracle Forms 6i, Maestro

Operating System

Windows & Unix

PROJECT DESCRIPTION:

To create a paperless environment and make the images accessible on the system for various users simultaneously. To increase the efficiency of various business processes. The users will get dual monitors, where they can view Trinity application on one monitor and the document image (invoked from Trinity) on the other. All the existing files for old loans were shipped from Sioux Falls to the scan central in May 2005. This is referred to as back file conversion in the project. This involves 70,000 insurance packets with an average of 300 pages per loan packet totaling up to a 21 million pieces of paper. Any new policies that are closed after imaging project is implemented are referred to as new loans. A new loan packet will be shipped to scan central to image by the originations. A basic workflow is designed for the project wherein the users will be alerted on scanning of a particular document for an app or account. This is accomplished by defining rules of alert for different doc types. Example – When a document type of brokerage statement is scanned, the loan processor and the loan officer for that app will be alerted. The alerts will show up on the screen called ‘User Home Page’.

RESPONSIBILITIES

As Technical Lead Xavier was responsible for

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

PROJECT DETAILS

Project

Kumaran Systems SRMT (Aug-2003 to Dec-2003)

Role

Oracle Technical Lead

Tools

Oracle PL/SQL, Oracle Forms 6i

Operating System

Windows

PROJECT DESCRIPTION:

SRMT (Sri Ramadas Motor Transports) Automation was developed for SRMT, Kakinada Andrapradesh.

This system has three modules Marketing, PPC and inventory with Forms 6I and reports 6i as front end and oracle 8i as backend. I was involved in the development of Marketing module. The Marketing module includes the functions like production slip, order registration, order allotment, pack note generation, Invoice, receipts, indents, credit notes and debit notes etc., Application security was provided in three levels - module level, screen Level and operation level.

RESPONSIBILITIES

As Technical Lead Xavier was responsible for

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

PROJECT DETAILS

Project

Accel ICIM UMIS (May 2002– Jul 2003)

Role

Team Lead

POC Specific Skills

Oracle PL/SQL, Oracle Forms 6i

Operating Systems

Windows & Unix

Database

Oracle

PROJECT DESCRIPTION:

UMIS (University Management information System) was developed for Pondicherry University to automate all the functional areas of the university operations like Examinations, Administration, Financial and Academic operations, Purchase & Stores and Library. I was involved in Analysis, Design and Development of Finance And Examination Modules. Developed Payroll process, GPF/CPF, MCA/HBA, Medical Reimbursement, Income Tax and Hostel and Mess Account in Finance Module.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

As a Technical Lead Xavier was responsible for

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

PROJECT DETAILS

Project

Accel ICIM CIPET (Jun 2001 –Apr 2002)

Role

Team Member

POC Specific Skills

Oracle PL/SQL, Oracle Forms 6i

Operating Systems

Windows

Database

Oracle

PROJECT DESCRIPTION:

CIPET (Central Institute of Plastics Engineering and Technology) Automation was developed to automate processes of the Institute, which includes Personnel, Payroll, Finance, Design, Inventory, Purchase, Sales and Production, Purchase & Stores and Process.

The Work Order module systemizes the work orders raised. It also takes care of the tests to be worked out, its duration and issues Test Certificates for the tests done at Testing Laboratory. I was involved in Analysis, Design and Development of Finance And Examination Modules. Developed Payroll process, GPF/CPF, MCA/HBA, Medical Reimbursement, Income Tax and Hostel and Mess Account in Finance Module. The Training Centre module takes care of all the information of students, both academic and personal, in order to get complete information about the students studying in the CIPET Training Institute.

RESPONSIBILITIES

Requirement Analysis

Coding (involves coding of subpops, matrix-splits, class splits, dictionary entries, mapping of flows).

Unit Testing.

System Testing

UAT

Contact this candidate