Manager Projects
Resume:
SAGYA ARUL XAVIER RAJA MINOR
Email id:******.****@*****.***
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