TECHNICAL SKILLS:

Database: MS SQL 2008R SSRS, SSIS and SSAS

Programming: VBA / ASP.NET/ VB.NET / MDX and Visual studio Pro.

Reporting: Crystal Reports 11.5/ 2008 MS SQL Server 2008/12/14 Reporting Services.

Data architect: Complex Stored Procedure, SSIS Packages, Schema, Triggers and Indexes

PROFESSIONAL EXPERIENCE:

Confidential

EDW Developer

Responsibilities:

• Developed meaningful use clinic using data mart methodology using Microsoft SSIS 2008 and IBM Cognos 10 Framework manager & reporting to generate reports for attestation and analysis. data source was Allscripts EEHR for 3rd year strait
• Developed EEHR data store based on Allscripts database for the operational reports that uses on a daily basis for the entire Scripps Medical Foundations which include 15 different projects.
• Provides experience and knowledge to the development and support of Scripps business intelligence/data warehouse, database administration, and software development environments

Confidential

Senior Database Developer / Analyst / Reporting

Responsibilities:

• Worked wif end users to gather business requirements and develop dashboard reports using KPIs and other reporting elements for a high - volume database. dis allowed application analysts to track projects by time line, and gave management an overview of department bottle necks
• Gathered business requirements, designed, and developed a “downtime” solution that provided doctors wif patient chart and scheduling information when the central systems were down for maintenance or otherwise unavailable - using ASP.NET VB and SQL Server 2008. dis included critical information such as 90 day history wif pharmacy and insurance information, and patient health information. dis saved $1,000,000 a day.
• Converted data from MySQL into MS SQL when doing data migration from several medical departments from one hospital enterprise system to another.
• Using MS Visual studio 20010 NET 4.0 platform, SQL Server 2008 R2, and SSRS, developed a CMS web application that combined helpdesk issue tracking and messaging
• Created a large website to hold SSRS and dashboard reports for managing staff activities
• Designed reporting services infrastructure using database mirroring and snapshot technology.
• Supported a complex database environment which included 14 different databases, using SSRS to develop reports to monitor status, and provided 3rd tier support for a support team of 250 users to help solve problems.
• To avoid non-connectivity issues, created ETL tools that pulled needed datasets to a redundant another server. dis saved the company a significant amount of money by avoiding SLA penalties.
• Developed small tools/utilities to automate processes using complex stored procedures, views, UDF, ETL and ASP.NET VB.NET.
• Created Prenatal report and Lab Order requisition inside Allscripts EEHR
• Report to the Vice President of Confidential organization

Bluepoint Solutions

Integration Consultant

Vista, CA

• Worked wif the accounting, marketing, and sales departments to gather requirements, design, develop, and maintain reports for three major systems: Microsoft Dynamics SL 7.0, Business Portal 3.0 and CRM 4.0 utilizing Crystal Reports, SharePoint Designer 2007 and Microsoft SSRS 2005.
• Applied business rules in developing reporting solutions
• Created management reports for sales department by using ASP.NET/VB.NET and Reporting Services.
• Developed a dashboard report for three business units to centralize management information into one page which included charts, tables, and links to other relevant reports.
• Developed a corporate extranet for a web order management system which pushed data into Dynamics SL, which saved the company time and effort entering transactions by hand due to high volume transactions.

Confidential

Senior Report Developer

Responsibilities:

• Maintained reports using Crystal 8.5, SQL Server 2005, and used SQL Stored Procedures, views and user defined functions. Created a variety of reports such as Cross-Tab, OLAP, Sub-Reports, Charts and Matrices.
• Migrated reports to Crystal Reports XI, and shifted to a .Net platform wif a migration of all reports into SQL Server 2005 Reporting Services.
• Designed database relationship, schema, indexes, views, triggers, stored procedures and UDF to maintain business logic and used Best Practice Analysis and other third party tools for the new platform.

Confidential, San Diego, CA

Database Analyst

Responsibilities:

• Gathered business requirements, designed, and developed corporate dashboard reports using KPI and other statistics calculations (moving Avg. Trend etc.) Used DTS to combine different data sources for the reports.
• Developed more than 50 work in progress (WIP) reports wif Crystal Reports 10, and MS SQL Server 2000 views.
• Developed progress reports using SQL Server Reporting Services embedded into ASPX pages.
• Developed Excel pivot tables for payroll analysis wif weekly update routines.
• Migrated the legacy database from Platinum into MS Solomon 6.0. Created complex database queries for accounting (A/P & A/R transactions), inventory, customers, vendor job costs, and project migration.
• Designed and developed B2B and B2C E Catalog using ASP.NET, VB.NET and SQL Server 2005
• Modified MS Solomon forms based on user requests and added new custom features to the forms to accommodate business criteria. Modified existing Solomon reports & documented the process and all reports wif MS Visio 2003.

Confidential

Database Analyst

Responsibilities:

• Gathered business requirements, designed, and developed a KPI measurement and customer satisfaction reporting system.
• Designed and developed Ad hoc reports wif MS Access VBA & Excel as templates for embedding into a report automation system for the corporate executive intranet. Reports included TAT (time average travel), service volume and customer satisfaction data analysis.

Confidential

Business Analyst

Responsibilities:

• Developed an E-commerce solution for the company's online Yahoo store using the following steps:
• Implemented a new customer service ordering system software that downloads all the orders directly into a MS Access database using VBA to control data flow
• Implemented a new FedEx Enterprise shipment system for order process via ODBC
• Implemented an inventory control system and integrated it using an order processing system via MS MSDE
• Generated reports using MS OLAP services, and developed a Decision Support Object system for sales analysis
• Documented the existing business process into UML (Visio flow charts).

Confidential

Database Administrator

Responsibilities:

• Designed, developed and implemented a large quality control database for a global manufacturing company to envelop the production, inspection and repair process of dozens of home products.
• me created daily, weekly, and monthly reports for defects and repair for each department in the factory.
• me built databases including database schema, tables, views, stored procedures, and triggers using industry best practices.

Confidential

Database Administrator / Developer

Responsibilities:

• Developed a new, concise reporting system for the entire Confidential Campaign.
• Developed a new CRM application for CFC (Combined Federal Campaign) that integrates all aspects from data entry level (pledges), deposits, designations and distribution plans, along wif a report for each module.
• Led a class to teach end users how to work wif Ad-hoc reports