SUMMARY:

• IMS/SHA Data Mining, Data Analysis, Data Modeling, Application Development, Accounting, Financial Reporting, Variance Analysis, General Ledger Analysis, Account Analysis, Data Flow Enhancements
• Requirements Gathering, Documentation, Executive and Stakeholder Collaboration, Project Management, Report Automation, Teradata, SDLC.

TECHNICAL SKILLS:

• SQL Server Visual Studio
• Tableau 8.2/9.2, Oracle SQL Developer
• SQL Server Management Studio
• SSRS, SSIS, InfoPath 2010, MS Office 2010,Viso
• Oracle 8i, SQL*Plus, TOAD
• Oracle 10g, Oracle Reports6i, Oracle Forms6i, MS Query
• SQL, PL/SQL, JDE, DB2
• Oracle Designer6i, Windows NT, Windows XP, Oracle Discoverer
• Oracle11i, MS Access, Excel
• VB, Word, SAP, Hyperion Pillar, Microstrategy8
• Oracle Financial Analyzer11i
• Hyperion Intelligence (Brio Query)
• SAP Business Objects 6.5 and XI.

PROFESSIONAL EXPERIENCE:

Confidential, Redwood City, CA

Commercial IT Analyst/Database Developer

Responsibilities:

• Project Management: Managed IMS migration from SHA data. This included working with cross functional teams on all data integration, SQL Server development, and Tableau development.
• Tableau Development 8.2 /9.2: I developed advanced Executive, Regional Director, and Sales Rep Tableau/Dashboard reports.
• This included complex measures, data blending, actions, interactive charts, hierarchies, filters, and server filters, control charts and IPad applications for the Sales Reps using Veeva Salesforce data, Symphony prescriber data, IMS prescriber data, and Managed Market data.
• Tableau Admin 8.2/9.2: I developed and maintained sites for Sales Reps and Regional Directors. This included adding users and deleting users. I also created schedules and monitored server users and user activity for performance and utilization.
• Documentation and Requirements: Developed process documents and requirement documents for business processes and Tableau reporting.
• SQL/T - SQL Development for Tableau Reporting Tables: Developed SQL/T-SQL in Management Studio for merging Veeva call data and IMS/SHA prescriber data at the HCP level. This included CASE Expressions, T-SQL, Sub-Queries, In Line Views, Multiple Joins, and Functions.
• SSIS Process Reporting: Developed and maintained SSIS for weekly, monthly, and quarterly data. This included Sunshine Act data, Customer Master View, and FDA reporting. Files were developed and transferred using FTP server.

Environment: Tableau 8.2/9.2, SQL, T-SQL, SQL Server 2012, IMS/SHA Data, Symphony Data, Veeva Salesforce.

Confidential, San Jose, CA

Sr. Data Analyst/Database Developer

Responsibilities:

• Business Objects/Excel Development: I developed advanced User BO/Excel reports for business users. This included complex measures, merging data, charts, sections, pivot tables, VBA for automation, and hyperlinks.
• SQL and Application Development: Developed in MS Access 2010/Excel, and Management Studio. MS Access was used as an ETL for importing data into SQL Server and SSMS was used for developing Tables, Views, SP, SQL, and Triggers. I also developed Data Models/ER diagrams for table generation.

Environment: Business Objects, SQL, T-SQL, SQL Server 2014, MS Access 2010, Excel

Confidential, Sunnyvale, CA

Sr. Data Analyst/Database Developer

Responsibilities:

• Development: Developed in MS Access 2007, InfoPath 2010 and Management Studio. InfoPath was stored on SharePoint and users inputted data in SQL Server 2008 by accessing the form.
• MS Access was used as an ETL for importing data into SQL Server and SSMS was used for developing Tables, Views, SP, SQL, and Triggers. I also developed Data Models/ER diagrams for table generation.
• SharePoint Development: Developed SharePoint sites for performance reviews. This included developing web pages, web parts, and permission models for each manager and the managers.
• Documentation and Requirements: Develop documentation and Visio Diagrams for business processes and technical processes based on business rules. Set up meetings with business users to gather requirements for documentation. This included all levels of management.
• SQL/T-SQL Development for Data Mining: Developed SQL/T-SQL in Management Studio for Ad-Hoc projects and reporting based on business user requirements. This included CASE Expressions, T-SQL, Sub-Queries, In Line Views, Multiple Joins, and Functions. The data was extracted to Excel 2010 or other applications and analyzed before sending to the business user.

Environment: Business Objects, SQL, T-SQL, SQL Server 2008, MS Access 2007, InfoPath 2010, SharePoint, Excel

Confidential, Palo Alto, CA

Sr. Data Analyst

Responsibilities:

• SSIS Development: Developed SSIS Packages to move data from Oracle DB, Flat File Source(Text, CSV, XML…), Excel Source to SQL Server Reporting Box.
• T-SQL/PLSQL Development: Developed Stored Procedures in Oracle and SQL Server to improve Data Flow. This included moving data to Staging Tables for SSIS to pickup and Ad-Hoc reporting.
• Process Improvement Development: Develop new processes for current reporting. This included creating Stored Procedures in Oracle and SQL Server. The procedures cut data processing time from 1-2 days to 1-2 hours.
• Ad-Hoc Reporting: This included gathering requirements from Internal and External Stakeholders and developing SQL in Oracle and SQL Server to pull the data. The data was analyzed by me and usually sent in Excel format using Pivot Tables.

Environment: SQL, Oracle, SQL Server 2005, Excel

Confidential. San Jose, CA

Sr. Business Analyst/Data Analyst

Responsibilities:

• Pricing Metrics: Developed Pricing Metrics for Category Pricing. Extracted data from Teradata using SAP Business Objects/SQL and developed metrics in Excel and Access.
• This included Non-Standard Discounting, Pricing Variability, Non-Standard Booking Distribution, Bell Curve Distribution, and Non-Standard Cycle Time metrics.
• BI Development: Developed and distributed SAP Business Objects reports. This included metrics and project based reporting such as Headcount and Expenses.
• Cross Functional Reporting Lead: Work with and coordinate data needs with Cross Functional teams. This included Legal, WW Channels, Finance, Sales, Pricing Solutions and Analytics, and Distribution. I gathered Business Requirements and developed reports to support Category Pricing.

Environment: MS Access, SQL, Business Objects, SQL Server 2008, Excel

Confidential, San Francisco, CA

Data Analyst/Sr. Business Analyst

Responsibilities:

• Development: Developed and enhanced current reports in SSRS/SSIS using Visual Studio and Management Studio. This included Custom Subscriptions based on dependencies, T-SQL enhancements, T-SQL development, and Design View development and enhancement.
• Documentation and Requirements: Develop documentation on business processes and technical processes based on business rules. Set up meetings with business users to gather requirements for documentation. This included all levels of management.
• SQL/T-SQL Development for Data Mining: Developed SQL/T-SQL in Management Studio for Ad-Hoc projects and reporting based on business user requirements.
• This included CASE Expressions, T-SQL, Sub-Queries, In Line Views, Multiple Joins, and Functions. The data was extracted to Excel or other applications and analyzed before sending to the business user.

Environment: MS Access, SQL, SSRS, SSIS, T-SQL, SQL Server 2005

Confidential, San Jose, CA

Project Manager/Sr. Business Analyst

Responsibilities:

• Pricing List Project: Project was developed to change worldwide discounts to our distributors. I was responsible for managing and extracting Booking and Revenue data out of the data warehouse (Teradata) using Business Objects.
• I performed data analysis in Excel and MS Access to ensure that our distributors received price protections. Report Enablement Project: Project was developed to automate current Excel POS and Business Object POS reporting.
• Managed and developed new ideas to automate reports by acting as a liaison and keeping the communications open between IT and Finance. Gathered requirements from key people from each theater of operation and converted the requirements to logic for report development.
• I performed analysis on SQL and Business Object reports to streamline the data extractions to save time for all World Wide Theaters.
• Data Quality Project: Analyzed data structures in the data warehouse and designed solutions to improve upstream reporting. This improved data quality downstream by eliminating data mapping in Excel.

Environment: MS Access, SQL, Business Objects

Confidential, South San Francisco, CA

Senior Data Analyst

Responsibilities:

• Data Validation: Validated monthly and weekly data in the data warehouse using Hyperion Intelligence (Brio) and TOAD. This process consisted of writing SQL against different Oracle databases to ensure accuracy of data before it was used for reporting.
• Weekly and Monthly Reporting: Developed and enhanced reports and processes for weekly and monthly reporting for SalesOps and external partners.
• Gathered reporting requirements by interviewing key people on the business side and converted the requirements to logic and business rules. This improved data flow to key decision stakeholders.

Environment: MS Access, SQL, BRIO, Oracle DB, PL/SQL

Confidential, South San Francisco, CA

Sr. Financial Systems Analyst

Responsibilities:

• GPO Weekly Data Reporting Project: Project was developed to provide data for Business Development. Extracted data from Oracle databases using Access, TOAD, and Microstrategy8 Desktop. Developed SQL using these tools based on the data requirements. This included designing business models based on Warehouse Acquisition Cost, Chargeback Price, Chargeback Quantity, and Rebate Tiers on specific manufactures, National Drug Code Numbers, and Contract Numbers.
• Market Compliance Project: Project was developed to provide stats to OTN's Group Provider Organization. I extracted data using Microstegy8 and Crystal Reports from Oracle and then exported the data to Excel. Built business models in Excel based on the data which included stats such as Customer Loyalty and Contract Customer Compliance.
• IMS Compliance Project: Project was developed to establish total market compliance on certain product families. Imported IMS data in to Access and developed SQL to map customer sites based on D6 clinical. Then developed business models to establish our market compliance based on IMS Mean data.
• Hyperion Pillar Admin: Maintained dimensions and imported asset, revenue, expense, and liability data from Oracle. Then tie back to the GL and prepared slides in Power Point for presentation to the Board of Directors.

Environment: MS Access, SQL, Microstrategy8 Desktop, Oracle DB, PL/SQL