Main responsibilities include: creating and updating packages for loading and deleting data into Epic Caboodle Data Warehouse from internal and external data sources. Developed solutions to import and extract data from the data warehouse using SSIS, SSAS and SSRS. • Developed standards for SSIS, SSAS and SSRS creation and version control using Team Foundation Services (TFS). • Created and maintained the organization metrics used to improve performance and reimbursement dollars. • Analyze and document user requests and define functional specifications. • Analyze source system data structures. • Determine data extraction and transformation required to support reporting requirements. • Design data structures for warehousing data using data modeling tools. • Program the extraction and transformation procedures using Extract Transformation Load (ETL) tools or other required stored procedures.• Implement processes and document support requirements. • Ensure quality of data by implementing quality analysis procedures. • Research and stay current with data warehousing technologies and trends. • Support data warehousing system operationally. • Stay informed in the ways ProHealth Care uses data. • Relying on experience, judgment, and creativity, recommends changes to warehousing practices for efficiency or quality improvement. • Work with vendors to support problem resolution. • Prepare documentation for operations staff and end users relative to new or changed programs. • Maintain a positive work atmosphere by communicating in a manner to facilitate collaboration with customers, co-workers and management.

Senior Business Analyst (Reports Development, Epic) Responsible for daily SSIS ETL processes to provide EPIC data to internal and external destinations.Developed SSIS extracts and reports for Business Intelligence end users. Integrated Crystal Reports into Epic system.

Data Analysis for Loan, Deposit and General Ledger data using 18 Hyperion Essbase cubes to report information to Executive Management on a weekly and monthly basis. •Created reports to compare profitability of notes based on fund transfer pricing, spread rates and risk ratings for loans. Provided profitability measures for loan portfolios.•Extracted, transformed and loaded data to Essbase cubes using Microsoft Access and Business Objects for Business Line reporting based on management and end user needs.•Extracted, transformed and loaded Budget and Actual balance sheet and income statement data to PeopleSoft for data modeling. Assisted business unit planning and evaluation.•Developed, upgraded over 300 reports and automated report processing using Business Objects, Schedule Wizard and batch files for Business Intelligence Reporting. Reports delivered more efficiently and punctually. •Developed and maintained documentation, procedures and training for reporting processes. Used Screen shots and directions easily understood by peers.•Researched, evaluated, tested and recommended software upgrades and new programs to increase productivity.

Developed and maintained Business Intelligence using Management Studio and Reporting Services on a SQL database for external insurance clients to minimize claim dollars. •Analyzed property insurance claims to find leakage dollars and trends for customers. Reduced the claim expenditures at least 8% for quarterly reporting.•Migrated Access databases to SQL Server databases. Improved productivity and processing time.•Programmed 95 queries to SQL script. Facilitated group discussions to incorporate best practices for entire group. •Maintained and enhanced Web reporting tool. Customizing reports for customer.

Provided IT and database functions for more than 200 computers at 4 locations for a social services company. •Developed and maintained Business Intelligence using Crystal Reports on a SQL database for internal management and external funding sources.•Planned, designed, configured, tested and data modeled the functionality of databases and software. Presented feedback to make software decisions.•Installed, customized and upgraded database programs and document templates.•Troubleshoot / repair and upgrade network, servers and computers for security, data integrity, inventory and data recovery. •Promoted from Intern to Data Analyst in 2001.