Experience

DAVID Corporation

• United States
• Information Technology & Services
• 1 - 100 Employee

• Software Support Developer

  • Nov 2014 - Present



Hewlett Packard Enterprise

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Developer III

  • May 2012 - Oct 2014

  BIRT Report Development – Team Leader • Develop BIRT reports for government client. All facets including: creating data sources, JDBC connections, datasets, extracts, and deploying to iServer. • Create SQL queries to use as datasets using complex SQL techniques including cubes, crosstab queries, correlated subqueries, Common Table Expressions, Analytical/Window functions, my own user defined functions and stored procedures. • Extended reports/reporting tool capabilities using Javascript and XML. • Mentored / trained employees on Accela database, BIRT reporting tool, SQL querying techniques/tips and SSRS as well onboarding/welcoming new employees (reporting team). • Develop SSRS reports. • Ran weekly team meeting. • Participated in technical interviews, phone and face to face. • Sourced resumes to help build team (programmers/report developers/testers). • Created Interview questions/ feedback document which I later helped transform into a sharepoint app. IPTS Conversion Project – Team member • Worked on a conversion team to convert over 100 million records from mainframe system to SQL Server for government client. • Responsible for creating SQL Server procedure/wrapper to import data from Adabas extracts to SQL server staging tables • Developed stored procedures for each individual import table. • Assisted data engineer with data mining and mapping of Adabas extracts to staging tables • Created SSIS package to move data from staging database to destination Show less



General Motors

• United States
• Motor Vehicle Manufacturing
• 700 & Above Employee

• QA Test Manager / Analyst

  • Nov 2011 - May 2012



Arrow Strategies

• United States
• Staffing and Recruiting
• 100 - 200 Employee

• Database Administrator / Database Analyst

  • Aug 2010 - Nov 2011

  Created vehicle tracking system in SQL Server with Access front-end integrated with Outlook using VBA, SQL, & Excel. Designed user-friendly web interface for Management and Sales executives to use complete with custom Excel macros that generated reports with the push of a button. Managed administrative support / IT staff. Created payroll system using MS Access and Oracle 9i. Worked on-site with Daimler-Chrysler and various suppliers as a plant liaison. Created Parts Tracking System. Show less



Blue Cross Blue Shield of Michigan

• United States
• Insurance
• 700 & Above Employee

• Sr. Application Developer / Data Analyst

  • Aug 2010 - Nov 2011

  Created databases, schemas, tables, views and indexes in SQL Server 2005 / 2008 R2. Created user-defined functions, stored procedures, SQL job agents, and jobs in SQL Server 2005 / 2008 R2. Created various two - tier Microsoft Access applications with SQL Server back-ends. Created custom ETL / screen capturing application using Extra Attachmate, MS Access / VBA, pass through queries, a stored procedure to call a job agent to run an SSIS package, and an SSRS report - complete with charting and a summary sheet. Used Visual Basic 2005 to create a custom data driven application to assist end users in logging and placing Medicare inquiries. This tool was an integral component of a multi - million dollar recovery effort. Created UI designs, VB forms, Querying / Reporting tools and interfaces for end users. Planned, designed, programmed, debugged, tested, and deployed various VBA applications in both Excel and Access, including advanced techniques such as programming Excel add-ins with UI customizations, Automated spreadsheets, Scheduled refreshes, Outlook alerts, MS Access front ends to manipulate complex SQL Server operations including SSIS packages and stored procedures. Show less



McLaren Health Plan

• Data Specialist

  • Jan 2010 - Aug 2010

  Process EDI transfers of Claims Data (837 & 835) using F.A.C.T.S. AIX. Prepare various reports on a fixed schedule: Daily, Weekly and Monthly. Create VBA programs to automate daily processes. Create and manipulate Monarch Pro models to extrapolate data feeds into Access databases. Generate and document new processes and edited existing documentation. Process EDI transfers of Claims Data (837 & 835) using F.A.C.T.S. AIX. Prepare various reports on a fixed schedule: Daily, Weekly and Monthly. Create VBA programs to automate daily processes. Create and manipulate Monarch Pro models to extrapolate data feeds into Access databases. Generate and document new processes and edited existing documentation.



R.L. Polk and Co

• Data Analyst

  • Mar 2009 - Dec 2009

  Created various VBA programs for processing Price and Specification data. Responsible for three Price & Spec metrics and corresponding monthly / weekly reports. Automated several manually intensive processes, in some cases cutting man-hours by 500%. Responsible for creation of code to generate and distribute reports and summaries - Including SQL querying of the backend Oracle database, VBA code to manipulate and present the data retrieved in Excel format, and automation of Outlook to distribute the final reports. Show less



TekSystems / Hewlitt-Packard

• Data Analyst

  • Oct 2008 - Feb 2009

  Responsible for gathering Database Instance information from a variety of sources. Created and maintained Access database for tracking Server Audit data. Populated Access databases with DB Instance data and Server Audit data. Created and distributed various daily and weekly reports. Performed statistical data analysis and trend reporting. Maintained and updated Master Billing list for Delphi Account. Discovered and reported hundreds of missing/unbilled servers, resulting in hundreds of thousands in recovered revenue. Show less



TEKsystems Contracted to

• Database Administrator / Analyst

  • Sep 2008 - Jan 2009

  Responsible for gathering Database Instance information from a variety of sources. Designed, created and maintained Access databases for tracking Server Audit data. Populated Access databases with DB Instance data and Server Audit data. Created and distributed various daily and weekly reports. Performed statistical data analysis and trend reporting. Maintained and updated Master Billing list for Delphi Account. Discovered and reported hundreds of missing/unbilled servers, resulting in hundreds of thousands in recovered revenue. Show less



TEKsystems

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data Management Consultant

  • May 2008 - Oct 2008

  Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.. Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and SQL Server 2005. Design and develop store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance. Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes. Created system for capturing, reporting, and correcting error data. Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production Responsible for monthly updating and analysis of client data. First, in a test environment and oversaw each move to production Imported, analyzed, error-checked and converted raw data. Created DataStage jobs to convert raw data. Performed conversion assessment and quality checking of converted data using ETL tools such as DataStage and proprietary software tools. Documented all assessments and anomalies and performed necessary actions including notifying client and / or retrieving new data from data suppliers. Converted MS Access test databases into SQL Server production databases Assisted with implementation of new client databases / accounts Show less



TEKsystems Contracted to Thomson-Reuters Corp

• Database Management Consultant

  • Jan 2008 - Jul 2008

  Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and SQL Server 2005. Design and develop stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance. Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes. Created system for capturing, reporting, and correcting error data. Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production Responsible for monthly updating and analysis of client data. First, in a test environment and oversaw each move to production Imported, analyzed, error-checked and converted raw data. Created DataStage jobs to convert raw data. Performed conversion assessment and quality checking of converted data using ETL tools such as DataStage and proprietary software tools. Documented all assessments and anomalies and performed necessary actions including notifying client and / or retrieving new data from data suppliers. Converted MS Access test databases into SQL Server production databases Assisted with implementation of new client databases / accounts Show less



Aerotek / Argus Corporation

• Database Administrator

  • Jan 2005 - Jan 2008

  Created vehicle tracking system in SQL Server with Access front-end integrated with Outlook using VBA, SQL, & Excel. Designed user-friendly web interface for Management and Sales executives to use complete with custom Excel macros that generated reports with the push of a button. Managed administrative support / IT staff. Created payroll system using MS Access. Worked on-site with Daimler-Chrysler and various suppliers as a plant liaison. Created Parts Tracking System. Created vehicle tracking system in SQL Server with Access front-end integrated with Outlook using VBA, SQL, & Excel. Designed user-friendly web interface for Management and Sales executives to use complete with custom Excel macros that generated reports with the push of a button. Managed administrative support / IT staff. Created payroll system using MS Access. Worked on-site with Daimler-Chrysler and various suppliers as a plant liaison. Created Parts Tracking System.



Elite Global Communications 2003 - 2005

• Sales Manager

  • Jan 2003 - May 2005

  Acquired new customers for Comcast cable by means of door-to-door canvass. Facilitated entire process of installation. Commission based salary. Promoted from Sales Rep to Sales Manager in first year of Acquired new customers for Comcast cable by means of door-to-door canvass. Facilitated entire process of installation. Commission based salary. Promoted from Sales Rep to Sales Manager in first year of



MSX International / Ford Motor Company

• Data Analyst

  • Jan 1999 - Jan 2003

  Responsible for population of PTAI Benchmarking database.Created input templates using Excel macros for use in uploading data by customers.Integral member of core benchmarking team, common database structure team. Assisted with logical and physical design of Oracle 8 Database schema. Created user-friendly interfaces for web-based input utility using Perl and Java Server Pages. Served as Administrator of Oracle Database (Backend of Benchmarking Database)

• Database Administrator / Analyst

  • Jan 1999 - Jan 2003

  Responsible for population of PTAI Benchmarking database.Created input templates using Excel macros for use in uploading data by customers.Integral member of core benchmarking team, common database structure team. Assisted with logical and physical design of Oracle 8 Database schema. Created user-friendly interfaces for web-based input utility using Perl and Java Server Pages. Served as Administrator of Oracle Database (Backend of Benchmarking Database)Interacted with drivers, dispatchers and suppliers via phone and in person. Show less