Experience

Database Manager

Confidential

• Environment: SQL Server, SSIS, Sharepoint, PC SAS, Crystal Reports 2008, MS Access 2010, MS Access 2003, MS Excel 2010, Adobe Acrobat Pro
• Extract over 3 million records from SQL Server using SQL scripting and load into several different Access databases depending on Static/Dynamic data and specific ID's
• Manage SQL scripting in the SSIS processes for Metric changes
• Access Database Development building SQL Queries for Data Manipulation and Reporting
• Build queries in SAS extracting data from SQL Server and exporting into Excel spreadsheets with Formulas
• Automate connections from SAS extracts into Excel spreadsheets
• Analyze Data comparing prior Data existing on the Reports
• Develop Crystal Reports with Data Connections to queries built in MS Access and export into combined PDF files
• Update all new reports into Sharepoint for over 1500 viewers and update Shared Drives for manager and co-worker's access to the new data
• Managing multiple reporting projects and prioritizing according to time management

Systems Administrative Analyst

Confidential

• Environment: SQL Server, MS Access 2007, MS Excel 2007, Sharepoint
• Extracting data from SQL Server
• Importing and Exporting Data from Access Database and building SQL Queries for data manipulation Reporting in Access and Vlookups in Excel
• Changes in design in Sharepoint for data types and added Metrics
• Importing and Exporting Reports from Sharepoint and Access
• Append Queries from Access into Sharepoint Reports
• Build and Analyze reports to setup all the new software packages to be validated for approval
• Validation of all software packages in the GPR Web Module

Sr. Data Analyst / Reporter

Confidential

• Environment: SQL Server, Crystal Reports VI, MySql, Business Objects Enterprise BOE , DbVisualizer, VPN Client, HTML, PHP programming
• Created and updated over 200 Crystal Reports to client specifications using SQL scripting tested in DbVisualizer
• Scheduled the Crystal Reports for distribution to Service Delivery Managers using Business Objects Enterprise
• SQL scripting to extract data using JDBC, ODBC, PostgreSQL, and Ingres connectivity
• Developed a database in MySql to manipulate data with monthly updates and created reports in Crystal Reports
• Built a huge web-based application to extract data from remote SQL databases using PHP programming to create forms for criteria input and output into HTML reporting charts that I created for reporting automation

Visual Basic Programmer

Confidential

• Environment: Finance/Accounting, MS Access 2003, Excel 2003, ODBC, ADO, Monarch, VBA, SQL Server
• Heavy Programming in Visual Basic for Applications VBA
• Extracted data from SQL Server to pull into Access for data manipulation
• New Application Development in Access Tables, Reports, Forms, Queries and VBA scripting within Modules
• Full Software Development Life Cycle SDLC with detailed Documentation
• Converting extracted data from Excel into Access tables
• Enhanced existing applications to run faster / modifications for end-user simplicity
• Link tables in Access using ODBC/ADO connectivity
• Monarch Reporting
• Excellent trouble-shooting skills with above-average computer knowledge
• Being new to UPS, they were going through a major conversion. I was asked to look at the problems they were having so I brought in the new views using the ODBC connectivity for all the databases to function properly and matched the metrics for the queries to accept the newly named fields. I developed several programs including one to stop duplicate checks from being entered into a check authorization program. I also developed an AIMS reporting service with email capabilities that they said was long needed and since completed has now gone live. This worked so well that they had me create a similar application for another department to report on the staled checks. I managed multiple projects with priorities where needed and worked with many supervisors to develop new applications for end-user production and modified many existing databases.

Sr. SQL Data Reporting Analyst

Confidential

• Environment: SQL Server, Query Analyzer, MS Excel, Enterprise Manager, Management Reporting Tool MRT , VPN Client, FTP
• SQL scripting in Query Analyzer to create .tab files and .csv files for Excel reports
• Created SQL queries/reports to pull metrics from SQL Server needed for executive management team
• Created IDs and Passwords and set client access in Mgmt Reporting Tool
• Remote access to SQL Db on remote servers using VPN Client on an administrative level
• Detailed verification of job extracts and loads ETL with SQL queries created to verify records Extracted and loaded data ETL from Enterprise Manager
• Corrected vendor data before uploading to the Mgmt Reporting Tool

Sr. Data Analyst

Confidential

• Environment: AS/400, MS Excel, MS Access 2000, MS Word
• Lead Coordinator of the data to a Team of Analysts
• Extracted data from Access to Excel and Analyzed database for dup/missing data while maintaining data integrity
• Created SQL queried lists in Access from Charter Communications database over 600K records to manage data
• Recorded macros daily in AS/400 Rumba for updating selective data
• Completed MDU Certification Reports in MS Word for audits

IT High Honors Graduate Student

Confidential

• Environment: Visual Studio.Net, MS Access, Visual Basic.Net SQL, datasets, schema, relationships, ADO.net, ASP.net, IIS, C , VB
• Developed multiple Access databases and manipulated data using SQL scripts
• Developed multiple Object-Oriented Applications within Visual Studio.NET Performed database programming using Visual Basic for Applications and C coding
• Projects always successful also leader in helping others with their programming techniques