* Consulted with users to define processes and information systems for supporting those processes for the North Carolina Medicaid Claims data warehouse.* Applied administrative changes to the SAS based reporting application for new and existing users* Trained new users on the SAS based reporting application for building adhoc queries against the Medicaid Claims data warehouse to answer business questions.* Performed troubleshooting to resolve database access issues, query design issues, and data quality issues.* Performed Quality Analysis on test data for enhancements to the Medicaid Claims data warehouse according to Customer Service Requests.

Attended SQL Server training at SetFocus. During this 3-month training I performed and completed the following:* Consolidated existing data from diverse data sources into a uniform SQL Server 2005 database using ETL capabilities of SSIS. * Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways. Created MDX queries according to business requirements.* Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS. * Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services. * Created score cards using MS Office Performance Point Server 2007 Dashboard Designer extracting data from SQL Server 2005 OLAP data source and deployed to SharePoint sites.* Utilized key product areas including data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.* Worked with data-handling scenarios such as multiple hierarchies and data-driven KPI goals.

* Supported the Reimbursement Policy Unit by producing summarized reports of claims experience for use in decision-making process regarding policy changes. * Reviewed the business requirements of the report requests to ensure accuracy of request details and to reduce rework.* Developed mainframe SAS programs to produce results based on the selection criteria and special processing instructions documented in the standard request forms and formatted final output in Excel or Access for distribution to requestors.* Enhanced the existing request form to minimize the amount of work to complete which contributed to improved productivity and turn-around time. * In the first year of service, increased productivity by 300% and reduced turn-around time by 75% over the previous year due to enhanced processes.

* Support team member for a 20+ TB database, considered the 5th largest healthcare information database in the world, housing healthcare statistical, financial, and pharmacy claim information as well as information for policyholders, subscribers and their dependents, and providers.* Developed and documented the team processes for performing performance reviews on end user queries, tracking helpdesk tickets, and for team participation in area-wide projects and initiatives.* Participated in area-wide projects and initiatives to ensure that the database model upgrades support business access and reporting needs.* Gathered end user reporting requirements for ensuring that the design for database enhancements supported new and existing business functions.* Coordinated customer acceptance testing for area-wide projects and initiatives.* Reviewed end user reporting jobs consisting of queries and post-query processing for design and performance efficiency and provided recommendations to improve performance and results integrity.* Provided level 2 support for helpdesk tickets regarding query design issues, degraded query performance, and post-query program design issues.* Designed and developed the Sagent Information Studio training manual for end-users.* Worked directly with Sagent support to redesign administrative metadata repository update programs.* Considered lead analyst.

* Provided level 2 support for end user access and usage of IDS (Intelligent Decision Server - a query and reporting tool).* Worked with the software company lab for trouble shooting and problem resolution.* Installed IDS upgrades and fixed packs as needed.* Provided general maintenance of the hardware and software.* Communicated system status to management and the End User Support team.* Tested Sagent Information Studio software for the purpose of selecting a replacement tool for IDS.* Resolved major performance issue with Sagent queries run in a UDBEEE environment. Reduced the overall run time of the test query from 20 hours to 2 hours.

* Team Lead for the development of the Clinical Profile System using the System development Life Cycle method.* Performed on-going maintenance post implementation.* Responded to and resolved production batch errors and data integrity issues.* Provided back-up support to the IDS (Intelligence Decision Server) product manager.* Proactively learned the administrative responsibilities for supporting the IDS query and reporting tool.* Went above and beyond required duties to assist with coordinating the PC hardware upgrades for the department (i.e. ordering new equipment and cascading existing equipment).