Mitchell Patterson Email & Phone Number

Southfield, Mi, Us

Wakefield, Ma, Us

Houston, Texas, Us

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

Detroit, Michigan, Us

Royal Oak, Michigan, Us

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.

Detroit, Michigan, Us

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.

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.

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.

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.

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.

Hanover, Md, Us

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 productionResponsible for monthly updating and analysis of client data. First, in a test environment and oversaw each move to productionImported, 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 databasesAssisted with implementation of new client databases / accounts

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 productionResponsible for monthly updating and analysis of client data. First, in a test environment and oversaw each move to productionImported, 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 databasesAssisted with implementation of new client databases / accounts

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.

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

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)

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.

Certificate

Education record

Cimmunications, Cis