SUMMARY:

• Over 20 years of experience transforming large amounts of transactional, non - operational and Meta data into strategically driven and actionable analysis.
• Proven ability to work with cross-functional teams such as Marketing, Sales, Finance, R&D, Inventory, Procurement, Philanthropy, Customer Service, AR/AP, Business Operations, Health Services, CRO, I.T. and consultants in defining meaningful metrics to meet business and strategic objectives.
• Employed in various industries such as PeopleSoft ERP Software Services, Health Care Services, Biologics, Pharmaceutical, Medical & Diagnostic devices, County and Federal Government.
• 4 years of experience implementing ERP software globally for the Food and Beverage, Consumer Goods, Telecommunications and Electronic industries Engaged in decision support positions such as Senior Programmer Analyst, (Risk Evaluation and Mitigation Strategy) REMS Data Analyst, Business Intelligence Analyst, Crystal Report Writer, Data Manager, Data Validation and Investigation, PeopleSoft ERP consultant.
• Extensive familiarity and experience in gathering customer requirements, gap analysis performance, questionnaire form design and creation, data warehousing design, BI security access design and maintenance, database connectivity, data transmissions (I/O), multi-source data integration, data modeling/architecture design, data management, data validation/quality, data aggregation, data mining (statistical analysis), report creation/enhancement and publishing and reports development life cycle (RDLC).
• Exhibited excellent organizational, pattern-recognition, analytical research, leadership, documentation, BI user training, presentation, mentoring, project management, time management, communication (writing and oral) skills, problem solving and interpersonal skills. Can find a needle in a haystack .
• 15 years of global consulting and contracting experience.
• 8 years of group leadership and management experience.

TECHNICAL COMPETENCY:

Data Collection: Oracle Inform 4.5, DataFax, PeopleSoft 6-7, Siebel Financials 7, IDX Flow Cast & Image Cast, McKesson Plus, Amysis Managed Care, SalesForce

Data Access/ Data transport: MS SQL Server (SSIS, SSMS), MS Access, Excel, Oracle, Sybase, Toad, SQL (DDL, DML), RDBMS, ODBC, EDI, FTP, TCPIP, ETL

Data Warehousing/Decision Support: OLAP, Metadata modeling, Star Schema, Cognos v6 - 8 (Report Net, Query, Analysis Studio, Metric Studio, Framework Manager and Security Administration), SAS Enterprise Guide (Data Import, SAS dataset conversion, Process Flow, Query Builder, Graphs, Summary Statistics, Distribution Analysis, Listings, Frequency), MS Access (Table Designer, Query Designer, Form Build), MS Excel (Pivot tables/Charts, Graphs, VLookup, HLookup, Import/Export Data, Conditional Formatting, Functions and Record Macros for automation)

Analysis Performed: Exploratory (measures of location and variation, fractiles, Pearsonian coefficient of skewness) for continuous and categorical data, Frequency distribution (two-way tables, stem-and-leaf plots), Linear Regression, time series

Reporting and Publishing: Crystal Report Writer, Cognos Report Studio, Cognos Connection, BASE SAS, SAS Enterprise Guide Report Builder, MS Access (Reports Designer and Macros for Automation), MS Word, Visio, PowerPoint, SDLC, MS Report Builder 3

RELEVANT EMPLOYMENT HISTORY:

Senior B.I. Analyst

Confidential

Responsibilities:

• Data warehouse design, building and integration of different sources of clinical data and partner source data.
• Automation and Dashboard building in support of clinician patient access. DB/Software tools/Scrips: SQL server 2008 & 2014,SSIS, SSMS, SQL,MS Access, Excel (macro, pivot tables)

Global Marketing/Sales Data Analyst

Confidential, San Jose, CA

Responsibilities:

• Provided analytic support to Sales Account Managers located North and South America, Australia, East Asia and Pacific regions.
• Provided data feed to web-based dashboards such as SAS Visual Analytics and Tableau.
• Integrate data from various sources using MS Access to provide real-time customer insight in identifying adoption challenges, renewal risks and uncover new marketing opportunities.
• Designed data flow modeling for sales data support
• Performed data quality checks and validations process.

DB/Software tools/Scripts: MS Access, Excel, SAS Enterprise Guide 7.1, SalesForce, SQL

Product Performance Data Analyst

Confidential, Fremont, CA

Responsibilities:

• Extracted large amount of data from SalesForce using SalesForce BI tools
• Developed automated data cleaning algorithms using MSAccess
• Evaluated data collection process from clinical partners and analyzed raw data in relation to product performance.
• Developed product performance KPI reports & graphs used as Dashboards for department heads in R&D engineering, Manufacturing, Finance, Sales, Marketing, QA and Clinical and delivered these report using PowerPoint Statistical Analysis performed
• Time Series analysis, multi-Variate Analysis, descriptive Statistics, Frequency analysis

DB/Software tools/Scripts: Excel (Pivot Tables & Graphs), MSAccess, PowerPoint, SalesForce, SQL

Reports Business Analyst Lead

Confidential, San Ramon, CA

Responsibilities:

• Led the requirement and design sessions for reports development across all functional areas and created a listing of reports inventory in preparation for software implementation.
• Worked with business owners to prioritized reports development

DB/Software tools/Scripts: Excel

Confidential, Mnt. View, CA

Responsibilities:

• Managed a group of CDM and data entry personnel responsible for processing patient lab visits for several therapeutic areas such as respiratory, inflammation, autoimmunity and oncology for pre-clinical and clinical studies.

DB/Software tools/Scripts: MS Access, Laboratory Information Management System (LIMS) Labware, Excel, SQL

Risk Evaluation Data Analyst

Confidential, South SF, CA

Responsibilities:

• Audited shipping records of partner companies in compliance with Confidential ’s REMS (Risk Evaluation and Mitigation Strategy) programs.
• Automated QA Excel reports resulting in cutting the run time by 60%.

Software tools: Siebel, Excel, EDI concept

Senior Clinical Programmer Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Developed Cognos reports from clinical electronic data capture software (EDC) supporting clinical research data management activities in the clinical research department.
• Provided SQL programming support for clinical data managers, safety group, project managers and senior directors for phase IV clinical trial.
• Conducted Cognos Query Studio Training to data managers.

DB/Software tools/Scripts: Oracle, Toad, Oracle Phase Forward Inform, Cognos (Query, Reporting and Analysis Studio), MS Access, MS Excel, SQL and SDLC

Business Intelligence Analyst

Confidential, Redwood City, CA

Responsibilities:

• Facilitated and self-managed cross-functional projects to support key business initiatives such as budgeting, planning, sales, customer management and finance reporting.
• Provided analytical support through data mining, analysis and reporting.
• BI implementation project manager and vendor management.

DB/Software tools/Scripts: MS SQL Server, Cognos (Query, Reporting, Analysis, Metrics studios, Cognos Connection Framework Manager and Security administrator), MS Excel, SDLC