Michael Vick Email & Phone Number

Columbia, Md, Us

307 Intl Circle , Ste 200, Hunt Valley, Nd 21030

Linthcum, Md

Using Data Integrater Pevasive, Oracle Discoverer with Oracle as the back end.Using VBA to automate the Build of Formatted Reports using Excel with the backend Oracle - Building Stored Procedure using parameters : In Varchar2 , OUT table cursor

Washington D.C. Metro Area

Working on Pervasive Software to build ETL's for company's that deal with Collection Agencies.

Data modeling, Building ETL processes, Learn, modify, create,build functionality within a tera database for THE new Tax System (SAP COTS) (MITS).

- Created Data Transformation Services (DTS) Package to build extracts, Put the files into sftp/ftp, along with an email notification to speedup problem solving.- Created / Sproc / DTS to build client extract to speed up deliver- Used SQL Profiler to analyze the performance of Views / Query for reporting needs.- Built Sproc’s to speed up performances for View/ Query’s and benefited the client do to the speed savings. - Designed Extract-Transform-Load (ETL) processes to process web data to get the data to the OLAP DB for reporting website activities using Technologies such as Pervasive, SQL Server 2005, T-SQL, isql, BCP, Batch files, and send mail functionality.- Designed / Built Shell script for extraction of data, Build Log, and Build Email Notification to automate the jobs to keep the maintenance and manual work down ultimately to save money.- Designed sproc to move data / do complex manipulation of the data for purposes of emailing categories of consumers for personalized Emails.- Design email campaigns to do dynamically build emails to specific consumer groups.- Build Crystal Reports using complex queries to solve business needs regarding time entry to better understand what is being billed.- Build Dynamic Crystal Reports for product services to find out where the improvements can be. - Build awk functionality to build in error control to add better subject line wording to speed up verification.

Transfered Access 97 database to Access Data Project. Did not use the upsize wizard (To Complicated). Manual transfered all SQL to T-SQL. Convertions are my strengths. Mid to Upper level SQL Server Programmer using UDF, Stored Procedures, Building DTS packages, Performance Tuning, Etc. This Project enhanced my skills in sending tables,numbers, and strings around using Store Procedures and UDF functions. If you have an Access/SQL Server Problem and need a solution, I am your man.

Building C# Programs to Monitor processes.Develop Process to create Stats for performance tuning.Evalute Whole System and Build flow diagrams using Visio/VBA.

SQL DBA / SQL DEV SQL Design / Dev - Developed UI for SQL Server nec for DML's Used reusable Stored Procedures to speed up the sql Cursors, unless no other options were available. Triggers – Before & after data chgs ISQL – Built Unix Script to run iSQL automating job & BCP ‘fmt’ for imp/ exp for data. Analysis Services - Built Data warehouses and Data Cube Data warehousing (13M records per month) Built Web Based appl with ASP for forms & reports to start the flow of data Built ASP Pages using MS InterDev for VB & Java script, HTML, CDONTAccess 97 Developer MS Access Front End - Mgs the data from the web site, Product reports for mgt. Designed/Built Qtrly and Mthly rep. w/ Dyn’c SQL statements util. Crystal Reps Created Pass-through Query that would interface with other database. Used Access 97 as a UI to automate the data flow & clean up. Controlled and built all objects in Sql Server using isql.

Bs

Education record