SUMMARY

• me has over twenty - five years of experience in the IT Industry.
• Business Analyst wif around seven years of experience, worked in the environment of Oracle, Teradata, sql, Microsoft Access, MS Excel, MS FoxPro 2.6 - Visual FoxPro 6.0, SAS 9.1, Cognos Mass Confidential Data Warehouse, MS SQL Server 2000.
• me've helped build database solutions using Microsoft Access, Excel and Visual FoxPro technology for Public and Private Sector Business.
• Technical experience in the development and application of software applications in Massachusetts state government.
• Extensive experience as a database programmer wif focus in the area of development, implementation, coding, conversion, testing and report generation in MS Office 95 - 2003 (Access, Excel and Word), Cognos Query and Query Studio, SAS 9.1.
• Developed exclusively, the Managing for results Initiative (MRI) MS Access database, which was used for statewide agency querying and reporting.
• The MRI database is a collection of ODBC linked tables to an Oracle data warehouse, managed by the Massachusetts Information Technology Division (ITD).
• Created various SQL queries and an array of complex ad hoc reports for A&F and the Governor’s Office.
• Created custom SQL Views in MS SQL 2000 for state agency budget personnel to access A&F, Fiscal Affairs budget data.
• Worked wif Fiscal Affairs Division, an office wifin the Executive Office for Administration and Finance dat develops, oversees and manages the Commonwealth’s operating budget.
• Developed and executed SQL test scripts using Teradata SQL Assistant to extract and reconcile financial data from the Data Warehouse.
• Review and verify critical Basel II Data elements to the General Ledger Accounts to ensure accuracy of Credit Risk information for Regulatory Reporting and Basel II Compliance.

TECHNICAL SKILLS

Hardware: Confidential PC and compatible computers, Apple Power Macintosh.

OS: DOS, Win NT/98/2000/XP/Windows 7.

Languages: Teradata SQL, Microsoft Access, MS Excel, MS FoxPro 2.6 - Visual FoxPro 6.0SAS Institute Programming me Essentials and Querying and Reporting using the Enterprise Guide 9.1, MS SQL Server 2000, Visual Basic 4.0, Oracle 7-8, Lotus Approach, DBase IV.

RDBMS: Teradata SQL, MS SQL Server 2000, MS Access, MS Visual

FoxPro, Oracle 7: 8, Sybase, Visual Basic 4.0, Lotus Approach, DBase IV

Tools: Teradata SQL Assistant, Microsoft Access, MS Excel, MS FoxPro 2.6 - Visual FoxPro 6.0, iRise,Visualization software, SAS 9.1, data warehouse, Cognos, MS SQL Server 2000.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Create Business Analysis documents according to National grids Solution Delivery process.
• Work wif all aspects of project development including third party vendors to establish pricing and service delivery.
• Developing prototype electrical energy systems.
• Write Investment Proposals and Total Cost of Ownership models for public sanctioning.
• Working wif Project Mangers and Procurement on a number of critical Research and Development projects.

Confidential

Data Analyst

Responsibilities:

• Analysis of American International Group ( Confidential ) and Springleaf (American General Finance) Client Carrier file data and reconciliation of error reports using MS Excel and Access.
• Management of client data using proprietary Confidential Benefits Workstation.
• Correspondence wif vendors to improve the delivery of client data (United Confidential Care, Aetna Medical & Dental, Hartford Insurance, Careington, National Vision Association etc.
• Preparation and delivery of Client Carrier file data on weekly basis through FTP protocol.
• Query data warehouse using SAP/Sybase Infomaker query tool.

Environment: Finance, SAP/Sybase Infomaker, MS Access, MS Excel.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Conceptualized and developed numerous MS Access databases for reconciliation of Confidential customer account data maintained by LPL Financial services for all 770 Confidential branch locations.
• Developed functions using MS Excel and Access to parse and validate LPL Financial customer data sets wif numerous other financial services and insurance company source data:
• Confidential, Mass Financial Services, Openheimer funds, Harford Insurance, Met Life, New York Life, Pacific Life, Sun Life and Jackson Financial.

Environment: Finance, MS Access, MS Excel.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Provided analysis of Agency and Agent license data for reconciliation wif the Office of Corporate Compliance license data.
• Analyzed large data sets extracted from Liberty Mutual data repository by the Office of Corporate Compliance to validate license data wif outside vendors.
• Developed functions using Excel and MS Access to parse and validate license data.

Environment: Finance, MS Access, MS Excel.

Confidential

Business Analyst

Responsibilities:

• Provide System of Record (SOR) analysis of various bank databases using MS Excel 2003 and 2007.
• Performed regression testing and defect resolution of key Basel II data elements on a monthly basis.
• Developed and executed SQL test scripts using Teradata SQL Assistant to extract and reconcile financial data from the Data Warehouse.
• Review and verify critical Basel II Data elements to the General Ledger Accounts to ensure accuracy of Credit Risk information for Regulatory Reporting and Basel II Compliance.
• Reported and tracked anomalies and defects in Mercury Quality Center.
• Participated in Joint Application Development (JAD) meetings to resolve data irregularities.

Environment: Finance, MS Excel, Basel II, SQL, Test scripts, Reports.

Confidential

Business Analyst

Responsibilities:

• Enterprise Compliance Technology Oversight and Reporting (includes Auditing, Ethics, Registration and Licensing, legal, Anti-Money Laundering and technology).
• Veritude contractor providing database and reporting services to Vice President for Risk Oversight.
• Developed MS Access 2003 database for Project Management reporting and database management wif MS Excel 2003 interface. Project involved converting massive MS Excel file used by vice president to track regulatory and non-regulatory project lifecycles.
• Provide ad hoc querying and reporting of over 100 projects in various lifecycle stages, from conception through production and development.

Environment: Finance, MS Access, MS Excel, Reports, Ad hoc.

Confidential

Business /Data Analyst

Responsibilities:

• Contributed to the development of the annual RFA contract between the State Office of Medicaid and all the participating (~68) Massachusetts Acute Care Hospitals. Developed the RFA annual Acute Care Outpatient Hospital Reimbursement Rates for Medicaid recipients. This included the implementation of the acute outpatient reimbursement methodology, Payment Amount per Episode (PAPE) and fiscal analysis and modeling of Acute Outpatient Hospital Reimbursement Rates to conform to the Medicaid Budget proscribed annually by the State Legislature. This required the negotiation and in corporation of policy and financial requirements from the following key stake holders: The Governor of Massachusetts, State Legislature, Medicaid Director, Legal and Office of Purchasing Strategy; and The Massachusetts Hospital Association.
• Conceptualized and developed MS Access databases for a wide range of applications in the analysis of various MassHealth Acute Hospital Outpatient payments (Based upon HCFA Ub92 Medical Claim Form and HCFA-1500 (CMS 1500)).
• Conceptualized and developed standard and ad hoc Cognos queries using Cognos Query studio for analysis of the Acute Care Hospital program.
• Conceptualized and developed MS Access and Excel reports for Executive management analysis of the Ambulatory Patient Grouping (APG) payment methodology period. The APG payment period was implemented by MassHealth for the period: 10/ /2003.
• Conceptualized and developed ad hoc MS Access databases for acute care hospitals data reconciliation of outpatient patient claims wif hospital patient account data, including separate supplemental Mass Confidential hospital payments, for APG Episodes covering a six (6) year period: 10/ /2003. The MS Access databases included queries and corresponding summary reports and Episode claims detail level, which included Revenue and CPT code (Current Procedural Terminology).
• Conceptualized and developed reports in Excel and MS Access as part of the development of the annual acute care hospital outpatient PAPE rates (Payment Amount per Episode payment methodology).
• Conceptualized and developed VBA Macros in Excel to collect Masshealth fee-for-service patient information in MS Access, in order to study the cost of providing outpatient services at various hospital sites wifin a large hospital campus.
• Conceptualized and developed MS Access and MS FoxPro programs consisting of custom Procedures and Functions to analyze extremely large data sets (10 Gigabytes and larger). Used for loops wif variable file names to summarize 40+ million records for various projects.
• Solely responsible as the data analyst in representing MassHealth against a lawsuit brought by acute care hospital industry for underpayments made by the acute outpatient APG payment methodology period. Provided detailed and summary analysis in both Excel reporting and MS Access reports to MassHealth Executive staff and Massachusetts Attorney Generals Office.

Confidential

Sr. Programmer / Analyst

Responsibilities:

• Developed exclusively, the Managing for Results Initiative (MRI) MS Access database, which was used for statewide agency querying and reporting. The MRI database is a collection of ODBC linked tables to an Oracle data warehouse, managed by the Massachusetts Information Technology Division (ITD). Created various SQL queries and an array of complex ad hoc reports for A&F and the Governor’s Office. For my efforts, me shared in the 2002 Governor's Special as part of the Database Team for the Managing for Results Initiative (MRI).
• Created custom SQL Views in MS SQL 2000 for state agency budget personnel to access A&F, Fiscal Affairs budget data.
• Provided analysis of actual spending activity by state agencies and Fiscal Affairs Analysts forecasted / projected expenditures. This kind of data synthesis enabled state agency budget personnel and A&F, to keep apprised of their appropriations and allocate funds accordingly.
• Developed and maintained applications using (VBA) Visual Basic for Applications to convert Excel files to database files and database files to Excel files. Developed, modified/maintained existing VBA code to execute programs to combine multiple data sets for import/export to various data types. Often, this required a combinations of steps, beginning wif querying the data warehouse (say the Statewide Appropriations Table), creating an MS Access of FoxPro program to do data manipulation in order to combine data sets, then output to DBF IV/SQL/Excel automated by VBA Macro for further analysis by Fiscal Affairs Budget Analysts.
• Wrote complex SQL queries and created complex MS Access and FoxPro reports. Often developed queries and data manipulation including, Custom Procedures and Functions to analyze Spending and Revenue actual/projections from the Information Technology Division (ITD) data warehouse.
• Developed and maintained Menu driven report selection for A&F Budget Analysts for all cycles of the Budget Process: House 1 (the Governors proposed budget); the House proposed Budget (House Floor and Final); the Senate proposed budget (Senate Floor and Final); Conference Budget (the Lower of the house and Senate proposed appropriations) and the Governor’s Veto process; and finally the Legislative Overrides producing the state of Massachusetts annual budget.

Environment: MS Excel, SQL, MS Access.

Confidential

Sr. Systems Analyst

Responsibilities:

• Conceptualized and developed Lotus Approach Statewide Shelter Tracking System.
• Created tracking reports on homeless families placed in the state shelter system prior to their placement into housing.
• Provided statistical analysis of statewide homeless population for executive staff.
• Managed data entry staff.
• Coordinated the input of data into the Statewide Shelter Tracking System.
• Provided technical and assistance to co-workers.