~ data Integration & Expert ~

Highly skilled, forward-thinking, and accomplished Project Manager, with a proven ability to conceptualize, develop, and successfully implement winning IT strategies that align perfectly with business and financial goals and objectives. Harbors a prestigious reputation of seamless functionality, unparalleled work ethic and dedication, winning projects, and team collaboration. Pursues goals aggressively, utilizes all known resources and seeks out additional pertinent tools, excels under pressure, enthusiastically manages new projects and ideas, and is a leader in the industry. Partners cross-departmentally, motivates personnel, and strategically designs optimal products, as well as is superb at developing, coding, testing, debugging, and documenting data and the processes.

Demonstrated ability to manage multiple assignments simultaneously and deliver projects on time and within budget constraints. A top-performing and versatile leader, credited with combining leadership skills and extensive technical background to lead teams through data integration, program development implementation, and data modeling and warehousing. A proven track record of conceptualizing and executing systems that improve productivity, efficiency and company revenue.

Areas of Expertise

Project Management New Process Implementation Data Integration Data-Cleansing

Quality Analysis and Control Data Analysis and Interpretation Data-Modeling Data Warehouse Management Scheduling Processes Design Processes Technological Sales

Budgeting Vendor Management

Professional Experience

MOLINA HEALTHCARE, Long Beach, California

Data & Process Quality Assurance Analyst, 2015-Present

Developed methodology to implement the data quality in DVR, QNTX, ERR, ODS, POD, Data Mart systems, to avoid in appropriate data to be released to Business.

Spearheaded various projects improving productivity, efficiency and data control.

System Study and Business Requirements Analysis and Documentation

oDesigned ETL process flow diagrams.

oUtilized Microsoft SQL Server Integration (SSIS) and Microsoft Visual Studio to develop packages.

oOversaw SSIS packages and session-tuning for better performance and work-flow development, according to process dependencies.

oProvided production support for daily, weekly, and monthly data delta loads, using analytical functions in extensive sql queries and solution provider to critical issues.

Environment:

oWindows, SQL server Business Intelligence Development Studio, Microsoft visual studio 2010, SQL Server 2008 R2, Packages, ERA, IR, Microsoft SharePoint 2010, FTP, MS Office.

ALLERGAN, INC., Irvine, California

Manager, Programming and Data Integration, 2014-2015

Developed interim solutions for MedDRA and WHOD coding for the paper and EDC studies.

Integrated data from different sources to feed protocol deviation repository for statistical analysis and integrated data from SAS data sets on study basis and provided to Oracle Clinical database.

Spearheaded various projects improving productivity, efficiency and data control.

Led unit testing, created and executed quality control scripts and documentation, and deployed developed item in production.

Followed standard operating procedures and work instructions for optimal efficiency.

Conceptualized and created study protocol deviation repository process, and streamlined and enhanced process in order to plug in to ongoing studies.

Led a development team of 10+ members onshore and offshore

System Study and Business Requirements Analysis and Documentation.

oDesigned ETL process flow diagrams.

oUtilized Informatica designer and workflow manager to develop Informatica mappings, sessions and work flows.

oOversaw Informatica mappings and session tuning for better performance and workflow development, according to process dependencies.

oProvided production support for weekly study data delta loads, using Informatica and solution provider to critical issues.

oDelivered developed product to end-user, ensuring quality and content remained appropriate, according to requirements.

Environment:

oWindows, UNIX, Informatica Power Center 9.1.0, SAS, TOAD, Oracle 11g, PL and SQL, Business Objects, ERA, IR, SharePoint, First Doc, FTP, Ultra Edit, MS Office (Power Point, Spot Fire, etc.)

Principal Data Integration Programmer, 2009-2014

Conceptualized, developed and delivered products to end-users, ensuring quality and content remained appropriate and fitted all necessary requirements.

Provided exceptional production support for weekly study data delta loads, using ETL and SAS.

Developed and implemented interim solutions for medical dictionary for regulatory activities and WHOD coding for paper and EDC studies.

Integrated data from different sources to feed protocol deviation repository for statistical analysis.

Conducted Informatica mappings and session-tunings for better performance and workflow development, according to process dependencies.

Spearheaded system studies, business requirements analysis and all applicable documentation.

Received Awards for Excellence in 2010 (two times) and 2013.

Integrated data from SAS data sets on study basis and provided to Oracle Clinical database.

Created quality control scripts and documentation to deploy developed product in production.

Followed SOP and work instructions.

Created, mainlined and enhanced Study Protocol Deviation Repository process, and plugged in to all ongoing studies, using ETL.

System Study and Business Requirements Analysis and Documentation

oDesigned ETL process flow diagrams.

oUsed Informatica Designer and Workflow Manager to develop Informatica mappings, sessions and work flows.

oHandled Informatica mappings and session tuning for better performance and workflow development, according to process dependencies.

Provided production support for weekly study data delta loads, using Informatica and solution provider to critical issues.

oDelivered developed product to end-user, ensuring quality and content remained appropriate.

Environment:

oWindows, Unix, Informatica Power Center 8.6.1, SAS, TOAD, Oracle 11g, PL and SQL, Business Objects, ERA, IR, SharePoint, FirstDoc, FTP, Ultra Edit, MS Office (Power Point, Spot Fire, etc.)

INSIGHT IMAGING, Lake Forest, California

Senior Data Warehouse Analyst, 2008-2009

JOHNSON & JOHNSON, Irvine, California

Senior Programmer Analyst, 2008

DELOITTE/CALIFORNIA COURT MANAGEMENT SYSTEM, Santa Ana, California

Data Modeler cum Data Analyst, 2008

PROFLOWERS, San Diego, California

ETL, Developer and Data Analyst, 2007-2008

TOYOTA, Torrance, California

Data Warehouse Design and Technical Analyst, 2006-2007

AMERIQUEST MORTGAGE, Orange, California

Loan Servicing, Data Warehouse Technical Analyst, 2004-2006

Technology & Special Skills

Data Warehousing Informatica Power Center 9.1.0/8.6.1/8.6.0/8.1.2/7.2.1/6.2/5.1.1/1.75, Power Mart 6.2/4.7/5.0 (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Informatica Power Center 4.7/5.0 (Repository Server Manager, Console Configuration), Oracle 11g, ETI, ETL, Business Objects, Metadata, SSIS (SQL Server Integration Services), SSAR (Reporting services), DTS, Data Mining, Data Mart, OLAP, OLTP, SQL*Plus, SQL*Loader, Data Quality, and B2B All Embedded Tools, Data Stage, Netezza 17.0.1 (trained)

Data-Modeling Tools Erwin 4.x (All Fusion Modeling Suite), Rational Rose, and Unified Modeling Language (UML)

Databases Oracle 11g/10g/9i/8i/8.0/7.0, Oracle Clinical, Teradata, Sybase SQL Server 11.x/12.0, MS SQL Server 2008 R/2005, MS Access 2000/’97/7.0

Reporting Tools Business Objects XIR2/6.0/5.1(Administrator and Developer), Cognos 8.x, Cognos Now, Data Reports, Seagate Crystal Enterprise, Spot Fire, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports, Brio-Hyperion (Administrator and Developer)

Programming SAS, Visual Basic 6.0/5.0, C, PERL, UNIX Shell Scripting, Korn Shell, Java, XML, SQL, SQL-Plus, PL and SQL, ANSI SQL, Transact SQL

Web Technologies ASP 3.0/2.0, VBScript, JavaScript, HTML 4.0, DHTML, CSS, JCL

Middleware Web Logic, WebSphere, COM, DCOM, COM+, Active-X, ATL COM, IIS 4.0, MTS 2.0, Socket Programming

Web Servers Java Web Server 1.1, MMC, Microsoft Personal Web Server

Environment Sun Solaris 2.6/2.7, HP-UX, IBM AIX 4.2/4.3, MS-DOS 6.22, Novell NetWare, Win 3.x/95/98, Win NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, SCO UNIX, HP 9000, RS 6000

Other Tools MS PowerPoint, Visio, MS Office, MS Project, First Doc, EDC, PVCS

Education & Certifications

M.S., Computer Applications: BHARATHIAR UNIVERSITY, Coimbatore, Tamil Nadu-India

M.Sc., Technology, Geophysics & B.S., Physics: ANDHRA UNIVERSITY, Visakhapatnam, Andhra Pradesh-India

Project Management Professional (PMP) / Informatica Certified Professional / Oracle Certified Programmer

Java Certified Professional / Certified in Data Warehousing Concepts, ANSI SQL, and PL and SQL

Contact this candidate