Business Systems AnalystÂ Resume

SUMMARY:

TECHNICAL SKILLS:

BI: Hyperion Intelligence, Business Objects, SSAS, Cognos, Tableau

ERP/CRM: SAP, Oracle, Man Man, i2, Netsuite, MFG Pro, Dynamics AX, SalesForce, Right Now

Applications: MS Office, MS Visio, MS Project, Dream Weaver, Brio, Toad, ER Studio, Erwin, Benthic

Databases/ETL: MS SQL Server 2000 - 14, Oracle 9-11, Access, MySQL, SQL Server DTS - SSIS

Languages: SQL, TSQL, PL/SQL, VBA, Visual Basic (VB), HTML, PHP, UML, Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential

Business Systems Analyst

Responsibilities:

Developed multi-tenant Tableau data mart and ETL routines which integrate data from 60 discrete databases to track financial metrics for Confidential 's Auto Casualty book of business
Created database program to assess financial credits for Confidential 's Decision Point product.
Program handles in excess of $100M annually in transactions.
Design database routines to project monthly revenue totals for the Finance Department.
Authored custom SQL programs to manage SLAs for Confidential ’s Nurse Review Team.
Built audit program to randomly sample data entry quality for manually entered medical bills.

Confidential

Business Systems Analyst

Responsibilities:

Translated business requirements into technical design specifications for data management.
Designed and implemented ETL programs for custom client data transmission processes.
Created and maintained configuration control for data and process flows, analytical reports, decision support structures, as well as business rules.
Created and maintained project plans including task identification, prioritization, and sequencing.
Monitored QC, QA and UAT for new ETL programs. Executed training plans for implemented projects.

Confidential

Consultant

Responsibilities:

Developed SalesForce, SAP and Oracle ERP data management strategies. (data acquisition, analysis, data integrity management, metrics management and reporting)
Created functional specifications, data mapping and flow documentation for the migration of multiple ERP’s to single solution. Helped created architecture for ERP and SFDC integration.
Gathered requirements and design specifications for SAP Master Data Management implementation.
Created data warehouse architecture, to support reporting through third party tools. (BO, Cognos)

Confidential

Business Objects Administrator/ SQL Server Database Administrator

Responsibilities:

Reengineered corporate data mart and data load process. (DTS/SSIS)
Developed data mart architecture, as well as reporting platforms. (SQL Server 2000)
Created and maintain Business Objects Universes.
Authored and executed test scripts to ensure data integrity and consistency.

Confidential

Senior Systems Analyst

Responsibilities:

Worked with stakeholders to create, review and signoff on functional specs, review technical design specs, develop and deliver BI solutions for the Media Sales Groups.
Co-designed and implemented Business Objects Data Mart to measure efficacy of media sales.
Designed load programs and PL/SQL procedures to create data integration solutions.

Confidential, Santa Clara, California

IT Project Manager

Responsibilities:

Developed and implemented SQL and Terminal Server platforms that significantly enhanced operations and led to a 40% labor cost reduction and “Employee of the Quarter” honors.
Received $500,000 additional budget to expand the platform, enabling high-speed data connectivity for corporate headquarters and the global development center in India.
Partnered in the design and implementation of a Product Installed Base database, a mission-critical application for Applied Materials Spares Inventory Planning Algorithm.
Created a data mart that was expected to grow to 2 terabytes within the following year; authored functional and technical specifications and procured the hardware infrastructure.
Designed ETL process utilizing DTS (SSIS), TSQL and PL/SQL procedures.

Confidential

Business Analytics Manager

Responsibilities:

Resolved operational issues and streamlined processes by overseeing Hyperion Data Mart implementation to monitor and control $50M in product inventory.
Tracked $20M in excess inventory and negotiated with eight distinct departments to secure funding for balance sheet write-offs.
Implemented a customized n-tier global inventory management tool; wrote functional specifications and PL/SQL and TSQL test scripts to sync data between the application and SAP.