Assigned to Aetna Medicaid Finance. Development/maintenance of the Finance and Finance Data Mart systems. Previously, developed transformations between the QNXT system, and the HEDIS Data Mart. Also developed transformations between the QNXT system and the Actuarial Database (ASDB). Developed reconciliation processes to verify all data was moved successfully.Tools utilized: SQL2008R2, TSQL, SSIS, and Subversion.

Assigned to Aetna Medicaid. Developed transformations between the QNXT system, and the HEDIS datamart. Also developed transformations between the QNXT system and the Actuarial Database (ASDB). Developed reconciliation processes to verify all data was moved successfully. Tools utilized: SQL2008R2, TSQL, SSIS, and IBM ClearCase.

Assigned to CVS Caremark. Developed/maintained SSIS packages and all related SQL code for their Medicare Part D division. These packages were primarily data feeds and validation, along with data extracts. Took part in migration from VSS to SVN. Tools utilized: SQL2008 R2, Visual Studio 2010, SSIS, SSRS, VSS and SVN.

Developed/maintained interfaces between client data (Sony/Paramount/Panasonic) and custom co-op advertising systems using SSIS, DTS and T-SQL. Developed/maintained SQL back ends to custom systems using SQL Server 2000/2005/2008. Created extracts for report analysts. Developed business logic modules for web developers in T-SQL. Redeveloped/maintained SSRS reports. Supported/maintained Paragon MS Access legacy system for older smaller clients.

Developed interfaces between MSI/InStream and CareRadius/MedMC using SSIS/DTS/T-SQL and Oracle. Developed data extracts for Emdeon, InStream and MSI. Reviewed current systems and interfaces for speed and efficiency. Made changes/re-writes and enhancements where necessary. Created extracts for web developers and report analysts. Modified/maintained SSRS reports.

Assigned to Wells Fargo Technology Operations Group. Act as liaison between client area and technical organization by assisting in the research and analysis of the technology systems of record for the purpose of improving data quality and accuracy in the Remedy Asset Management SOR. Perform advanced data analysis and reporting. Develop tools to assist bulk importing into Remedy. Tools: SQL Server 2008 R2/SSIS/T-SQL/Access/Excel 2010/Office Automation.

Assigned to Dell Corporation to provide data analysis skills for their asset management contract with Honeywell in Tempe, Arizona. Was responsible for understanding complex asset management business rules and how they interface with procurement, field service, service desk, asset recovery services, and lease returns. Performed advanced data analysis and reporting. Extracted data from numerous SOR sources into a single database for QA analysis using SSIS. Tools: SQL Server 2008 R2/SSIS/MS Access 2007/MS Excel 2007.

Researched, designed and championed technology solutions for City departments. Utilized advanced knowledge of business process analysis, hardware and software requirements, project management and large-scale applications implementation. Facilitated customer training, technology sharing and skills growth. Applied expertise in relational database design to department database work tasks, increasing data integrity and productivity.Participated in high level planning for the two-year budget cycle, strategic long range technology planning, and preparing technical Capitol Improvement Plans (CIPs) and RFPs.Skilled in data analysis, integration, migration, extraction, ETL and SQL development. Participated in numerous integration and migration projects utilizing tools such as SSIS and others.Coordinated installation, data migration and administered Maximus M4 Fleet Management System with an Oracle backend.Developed a Cab Connection System for City of Scottsdale Transportation using MS MapPoint objects to verify distances reported. Application imported cab vendor invoice data, reconciled it with application records and generated an invoice for A/P. Recovered $3M in lost/deleted records using tools used in creating the system.Developed a barcode based IS Inventory System (ISIS) that tracked all City technology equipment (and historical data) including PCs and peripherals, network/infrastructure, and Police/Fire radios. Enabled IS technicians, Purchasing and Accounting personnel to enter/edit their accessible information. Exported data to Finance using SSIS.Developed a hand held data entry application for Pocket PC Symbol scanning devices. Enabled technicians to scan all equipment barcodes and enter user/location/event data for one or multiple barcodes at a time, then sync the data with ISIS using MS ActiveSync at their work station. Reduced annual inventory time 50%.Tools: SQL Server/SSIS/SSRS/Oracle/VB.Net/.Net Compact Framework/SQL CE/MS Access..

Developed, implemented and maintained PLI Infosys using Access 97/VB6 and SQL 2000. System tracked company products, customers, sales orders, work orders, inventory, purchase orders, shipping, invoicing and receivables. Managed all computer-related issues including hardware installation, setup and repair. Assisted Quality Testing Department using data acquisition software and hardware.

Database application design and support. Designed, installed and maintained networks, hardware and software for various clients. Performed PC and server assembly, installation and maintenance. Setup various communications and Internet applications.

Designed and implemented a Prospect Tracking System for Marketing and Sales. Worked with the Sales Operations Manager to create a user manual for the Sales Operations and Executive staff. Managed hardware/systems technicians.Designed the specifications and managed the deployment project for a $420K Mitel corporate wide phone system. This system connects all locations enabling users to connect to one voice mail system and call accounting system; resulting in point to point interoffice communications corporate wide.Designed specifications for and implemented a club wide POS system and accounting system using Abacus 21. Implemented PC hardware policies and PC assembly/maintenance programs with significant Data Management cost savings, reducing PC costs and eliminating hardware support contracts. Also significantly reduced down time due to parts on hand and in house repairs.