SUMMARY

• Have 12+ years of varied IT experience implementing Data Management, Data Warehousing, Analytics, Database and BI Reporting solutions at an Enterprise level.
• Have experience leading initiative on Data Governance, Stewardship within group & developed structure, Business/Data Rules, processes and workflows using MDM softwares
• Have experience in setting up new Processes, SOP’s, Quality and performance metrics initiatives
• Expert in data analysis, migration, modeling, integration and data warehousing concepts and application. Experienced in researching, evaluating, analyzing and fusing large amounts of qualitative and quantitative data.
• Strong understanding of the principles ofDatawarehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling including support for Advanced SQL Queries, DDL, DML structures.
• Have Conceptual and LogicalDataModeling skills with experience in designing for both transactional databases and dimensionaldatamodeling using Erwin Data Modeler, ER/Studio, Visio Enterprise Architect
• Designed and Developed source to target mappings and supported database design for modeling base tables and data mart tables. Have good project documentation skills with experience documenting Functional requirements, Process Workflows, Architecture, Technical Design, Data Mapping, Test Plan, UAT, Deployment...etc.
• Have very good knowledge of using SAS Software such as SAS BASE, SQL, STAT, SAS Macros, and Procedures, SAS Enterprise Guide, SAS Dataflux.
• Experience interacting and presenting to C level executives as well as multiple functions across levels

TECHNICAL SKILLS

MDM Tools: SAS DataFlux Data Management Studio 2.2, OneData MDM

Data Profiling Tools: IBM Information Analyzer, TOAD Data Profiler

Databases: Oracle 8/9/11, SQL Server 2005/2008 (SSAS, SSIS, SSRS ), Access

Database Tools: TOAD Professional, TOAD for Data Analysts, RedGate SQL Developer, PL/SQL Developer, ERWIN Data Modeler 7/8/9, Erwin Model Mart 9.0, Microsoft TFS, Oracle SQL Developer

Other Tools: MS - Office, SharePoint, Microsoft Visio, Microsoft Project, Version One

BI Tools: SAP Business Objects, Crystal Reports, SAS BI Suite, TIBCO Spotfire

Operating Systems: Windows 9.x/NT/2k/XP/7, Ms-DOS, UNIX

SAS Software: Base, STAT, CONNECT, SQL, Enterprise Guide, E-Miner

Data Virtualization: Composite Studio

Methodologies: TOGAF, Zachman, Kimball, Inmon, AGILE, SCRUM

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Data Architect - Consultant

Responsibilities:

• Data gaps and impact. Perform Source System Data Profiling
• Legacy System Data Migration and Decommissioning (Composite Software)
• Risks associated with the deficiencies and limitations of the current state technology / architecture
• Participate in Data Architecture View of the recommended future state. This view would include low level design of architecturally significant components.
• Develop Target Subject Areas and Dimensions from business entities and models

Applications Used: Composite Studio, IBM DataStage, Information Analyzer, Erwin Data Modeler, SQL Server, Oracle, TOAD Professional, Visio, Systems Architect, Project, REMEDY, TIBCO Spotfire, LOWIS, WPH, WellView, D7i, Energy Components, ESRI ArcGIS Tools

Confidential

Manager - Data Analytics

Responsibilities:

• Responsible for the management, data architecture, data integration and the design, development and implementation of the enterprise data warehouse platform and BI Reporting environment.
• Provided technical leadership and solutions architecture for Commercial Analytics business unit
• Capture, define, document, and maintain clear, accurate, and correctly detailed BPMN based process models and allied process documentation which includes, business requirements, and use case documentation.
• Technical Requirements, Analysis, Design, Data Modeling, Database Development, and Database documentation of the Operational Data Marts (ODS) of the data warehouse.
• Reverse- Engineered data models using ERWIN Data Modeler from source systems.
• Create Functional and Nonfunctional Requirements, Data Flows, Use Cases, Data Mapping Specifications, Functional Test Plan, Traceability Matrix.
• Generated Logical/Physical data models using Erwin Data Modeler software and create DDL/DML Scripts.
• Performed data profiling, data quality reviews and presented to project sponsors
• Managed Data Stewardship operations on a day-to-day basis and provided leadership, guidance, coordination and coaching to Data Stewards.
• Helped Data Stewards adhere to scope, direction and ensured that business requests and issues are addressed/resolved in a timely manner.
• Lead process in identifying/managing changes to business rules, policies and processes.
• Responsible for management of Customer Master content and business rules.
• Serve on a Change Management Board designed to prioritize requested changes and improve the change request process.
• Ensure all required process documentation is accurate, correctly detailed, and kept up-to-date and organized in the appropriate repository.

Confidential

Lead Data Analyst

Responsibilities:

• Development of technical project documentation such as Requirements Gathering Questionnaire, User Requirements (URD), Functional Requirements (FRD), Database Design Spec, Traceability Matrix, Functional Test Plan, UAT, Data Mapping Specification.
• Reverse Engineered existing databases using Erwin Data Modeler and Red Gate software to generate database metadata structures.
• Architecture, development and implementation of SAS DataFlux jobs to integrate and cleanse Physician/Accounts data from multiple source systems that include SalesForce.com, SAP, SQL Server, CEGEDIM, files from SharePoint sites.
• Created SAS jobs to standardize, validate and de-duplicate data warehouse Addresses, Names, Phone numbers, NPI Numbers for healthcare providers, physicians, practitioners

Confidential

Lead Data Analyst

Responsibilities:

• Quarterly Business Review / Weekly Business Review Report generation
• Developed Segmentation and Targeting Analysis / Incentive Compensation Analysis reports

Applications Used: SQL Server, QlikView, Business Objects, Erwin Data Modeler, Microsoft CRM, Siebel, Salesforce.com, SAP BEX Query, SAS Tools.

Confidential

Manager, Clinical Database and Statistical Programming

Responsibilities:

• Technical Project Management of clinical studies utilizing various Clinical systems and SAS
• Managed and Lead Clinical Database Programming teams working on various clinical database systems such as Oracle Clinical, Clintrial, RAVE, Inform, DataLabs and SAS.
• Provided inputs to RFP/RFI, Project Costing, Change in Scope and contractual issues.
• Assisted in defining gaps in process, developing SOPs, Process Maps with QM department.
• Identified metrics and drive initiatives to improve the quality of project deliverable.
• Line management of 12 staff that includes Programmer Analyst, Clinical Programmer Analyst, Senior Clinical Programmer Analyst working on SAS Programming and Clinical Databases.
• Participated and Initiated Client Meetings, Project team meetings, Project Kick-Off and Close Out meetings, Project Transitions, Lessons Learnt, Organizational Process Initiatives.
• Perform technical staff recruitments, technical trainings, Technical QC of SAS programs…etc.
• Involved in recruiting, mentoring and training new programmers within the group in SAS programming and Clinical database systems such as Oracle Clinical and Clintrial.
• Lead projects as a Technical Lead and liaise with project teams, clients and vendors.

Confidential

Technical Architect

Responsibilities:

• Converted eDC Setup Objects from various source clinical database systems such Oracle Clinical, Clintrial, DataLabs, RAVE, Inform to CDASH standards library using SAS software interfaces.
• Used SAS DataFlux MDM solution to integrate, cleanse and consolidate Master data from multiple sources and systems to the data warehouse.
• Defined and implemented the organizational Data Standards initiative utilizing MDM methodologies and processes using SAS DataFlux Data Management Studio solution.
• Provided Logical Data Model (Entity-Relationship Model) using ER Studio that captures the business data requirements and Data Definition and Relationship Definition to design databases.
• Technical program delivery of over 75 Phase I/II/III Clinical Studies.
• Full range of Clinical Data Management Activities include the following: Technical Kick-Off meetings, Project Documentation Review, CRF/eCRF Annotations, Database Specifications, Database Design in multiple systems including Oracle/SQL Server, Validation Checks Programming, SAS Data Extracts from eClinical Systems, SAS Data Exports in Client/SDTM standards, Biostatistics Submissions, Database Audit and QC, Database Archival.
• Generated various Study data submissions as per Client/FDA requirements which include CDISC formats (SDTM, CDASH, ADaM). Assist is creating data mappings from multiple clinical database sources and third party labs to client specific/CDISC formats.
• Conducted Technical User Group Meetings to facilitate knowledge sharing between worldwide programming groups, Participated and Initiated Client Meetings, Project Kick-Off and Close Out meetings, Project Transitions, Organizational wide Process Initiatives.
• Developed Oracle 9i PL/SQL Packages containing multiple functions and procedures to be called internally in Oracle Clinical and Clintrial database management systems..
• Set up standard repository/Global library (GLIB) for Clinical Databases and standardization of existing SAS programs to extract data into SAS from Oracle Databases.
• Spectre/Trawl Program: SAS Program Macro library developed to verify all SAS Transport files (XPT files) across multiple (I-IV) clinical studies for consistency, errors, data structure, and a set of pre-determined list of checks for each SAS dataset and generate compliance reports.
• SAS Macro Programs for generating SAS Datasets and Formats Catalog from Oracle Clinical and Clintrial.
• Sas Automated Programs To Check All Sdtm Data Submissions For Accuracy, Integrity Check As Per Client Customized Sdtm Standard.
• PharmacoVigilance Tracking/Reporting Databases
• Quality, Process, Training Initiatives and Resource Productivity Initiatives.
• Resource Forecasting Tool
• Proprimo/Bestt - Project Costing Algorithm Updates.
• Productivity, Quality Metrics Tracker, and Dashboard.

Applications Used: Oracle Clinical, Oracle AERS, Clintrial, Medidata RAVE, DataLabs, Oracle 8/9, SQL Server, Business Objects, SAS BASE, STAT procedures, SAS Enterprise Guide, Project, Visio, Lotus Notes, REMEDY, OpenCDISC SDTM Validator, OneData MDM Tool.

Confidential

Data Analyst

Responsibilities:

• Used statistical forecasting models and modeling techniques using SAS Enterprise Guide and SAS Enterprise Miner for Sales Forecasts, Customer segmentation and targeting.
• Automated reports and provided consistent forecasting for Inventory & Forecasting team in AOL Audience. This resulted in realizing over $250 million in online Ad revenues over a 6 month period.

Confidential

Clinical Database Programmer

Responsibilities:

• Experience in Clinical CRF design, CRF Annotation, database setup in Oracle Clinical, Coding dictionary and Coding application setup, CSV Plan, Data Transfer, Lab load and other DM activities.
• Developed Global metrics database and created centralized dashboard for management use
• Created SQL*Loader Scripts to load MEDDRA, WHODRUG, ICD9, COSTART coding dictionary delimited flat files to Oracle Schema used to store coding dictionaries.
• Created Oracle PL/SQL global library of packages and procedures/functions to aid programming for Oracle Clinical and Clintrial based databases.
• Generate various Oracle PL/SQL scripts for validation checks programming within the database.
• Developed SAS Programs to generate validation listings and reports in PDF/RTF/XLS formats, Generate SAS Datasets and Exports, SAS Macro programs to check SAS datasets for compliance issues and errors.

Confidential

Technical Associate

Responsibilities:

• Prepare MIS reports and supported issue monitoring, reporting and resource utilization forecasts.