Sql Server Developer, Reports Developer
Resume:
ROBERT E. POVSE
Marietta, GA 30062
*******@*****.***
Qualifications:
Over 25 years of development experience with a focus on Microsoft SQL Server technologies. Specific experience with data analysis including SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS); as well as experience developing Tableau reports. Experience with data modelling and analyzing queries for inefficiencies.
Education:
B.B.A The University of Iowa-Iowa City, IA
Technical Experience
Database/Data Integration:
Microsoft SQL Server 4.2-2012; Oracle 8, 8i, SSIS; Access 2.0-2013
Report Generators:
Tableau, SSRS 2008; Crystal Reports 3.0-9.0
Networking:
ActiveDirectory
Languages
Visual Basic 3.0-6.0; PowerBuilder 4.0; Access Basic (VBA); ASP.net;C#.
Internet
ASP, HTML, IIS
Other:
Excelerator, System Architect, ERWin (CASE Tools), Microsoft Office
Experience:
Synergis, Inc. (Consultant) - Atlanta, GA. July 2015 – May 2016
Alexander Proudfoot – Atlanta, GA. Developed solution to replace manually created Tableau reports for business metrics. This involved gathering requirements and creating the front end for data collection (Developed in MS Access and SQL server), as well as testing and implementing the solution. Duplicating Excel reports in Tableau, and verifying the duplicated reports matched the original Excel reports. Also created and conducted a high level user training to help familiarize C-Level users with Tableau, and verified reports with C-Level users. Developed additional reports in Tableau.
Hunter Technical Resources, Inc. (Consultant) - Atlanta, GA. November 2011 – July 2015
Airtran Airways/Southwest Airlines – College Park, GA. Worked as a data analyst/report developer utilizing SSRS 2008. Successfully shut down Airtran specific reports after verifying they were no longer needed, Developed and implemented Southwest specific reports after meeting with users to gather and verify requirements. Also developed SQL specific Watchlist application utilizing SSIS 2008 that imported raw data provided by TSA and transformed the data into a usable format that is utilized as a backup to the TSA Watchlist program. This involved meeting with users to gather requirements; translating requirements into SSIS package, and verifying results of the package, and implementing the solution. Successfully integrated Airtran Airways databases and database applications into Southwest Airlines. Part of a team that successfully decommissioned remaining Airtran Airways databases and applications after determining they were no longer needed. Also worked on data mapping and data transformations for a new Southwest Airlines project that maps flight data from one reservation system to another.
Pyramid Consulting, Inc. (Consultant) - Atlanta, GA. May 2007 – October 2011
UPS – Roswell, GA. Worked as a SQL developer / 3rd level support utilizing SQL Server 2000/2005/2008. Creating
T-SQL Stored Procedures, Jobs, and DTS/SSIS packages. Creating/Supporting solutions for multiple clients to report shipping statistics to clients using standard ANSI /X12 EDI formats (210, 214, 240, etc) as well as standard raw data formats CSV, XLS, TXT. This included translating requirements from business users, creating/supporting DTS/SSIS packages to ingest data and stored procedures to massage the data to report shipping statistics. Also utilizing MS SQL Reporting Services to create reporting solutions for clients. Also supporting MS Access solutions using VBA, and converting Access solutions to SQL Server.
Management Decision, Inc (Consultant). - Atlanta, GA. February 2005 - April 2007
Coca-Cola, Inc. Atlanta, GA. Worked on a stock option application written in Visual Basic 6.0 and Oracle 9i. Modified the application based on given specifications. Made all modifications in a timely manner and met required go-live deadline. Used Visual Basic 6.0 and Oracle to modify the application based on Merill Lynch stock option system specifications. Wrote PL/SQL queries to modify and retrieve information in Oracle tables
Worked on a CIF project tracking system utilizing MS Access and SQL Server. Made required modifications in Access Forms and code, including modifying and creating SQL tables. Increased the efficiency of application by 25% utilizing
T-SQL Stored Procedures. Increased the efficiency of development by utilizing DTS packages to transfer data from production to test server.
Worked on a quick turnaround MS Access based system to modify/report on SAP authorizations. Worked with the users to gather requirements to create final screens. Also created the database design and the back end processing to report Authorizations per user.
Air Quality Sciences, Inc., September 2003 – October 2004
Developed a lab reporting application using Visual Basic 6.0, Microsoft Access, and SQL Server. Used Microsoft Word and Excel to create automated reports. Met with users to gather requirements and developed application according to specifications. Developed Access database to fit in with existing database structure. Used Crystal Reports 9.0 to create automated reports for other lab related systems, including setting up and installing Crystal Enterprise. Also supported a lab management system using Foxpro, as well as other applications written in Visual Basic. Developed a utility to update data in lab management systems database from Siebel database. Support user PC’s, Siebel, Great Plains, and perform basic network administration as necessary.
Worldspan, Atlanta, GA. March 2000 – September 2003
Developed internet business travel booking site. Enhanced the application through new development utilizing Visual Basic 6.0, ASP.net, C#, HTML, XML and Oracle. Performed as a liason between the database group and the development group. Writing PLSQL queries to update the database, implementing stored procedures as well as recommending any structure changes. Maintained the product using Visual Basic 6.0, ASP.net, and C#. Also participated in 3rd party reporting application utilizing SQL Server 2000 and DTS packages. Also Assisted in set up and maintenance of web servers, QA testing, project building, etc.
Interactive Business Systems.(Staff Consultant) – Atlanta, GA December 1997 – February 2000
Updated branch website utilizing HTML. Also added job search section utilizing ASP. January 2000 – February 2000
The Home Depot Atlanta, GA. Updated system written for HDTV. Increasing functionality/adding new functionality to accommodate a growing business unit. Also Created a method for inputting products/features into product database from flat files received from manufacturer. Visual Basic 5.0, Access 97, Crystal Reports 6.0. September 1999 – January 2000
United Parcel Service Atlanta, GA. Created a Management Conference tracking system using Visual Basic 6.0, Access 97 and Crystal Reports 6.0. Met with users to gather requirements for the system, Created ER diagrams and database model (Logical & physical). Wrote Visual Basic code and created all reports using Crystal Reports 6.0.
Also Created a Project tracking and budgeting system using Visual Basic 6.0, SQL Server 7.0, and Crystal Reports 6.0. Functioned as DBA/Programmer. Created the database design to maximize efficiency of the system. Created T-SQL Stored Procedures, Triggers, and Reports, as well as writing code for the system. November 1998-August 1999.
The Home Depot Atlanta, GA. Updated a Catalog Staging system used for sending Kitchen/Bath design catalogs to the stores using Visual Basic 4.0. Used DB2 tables to get current stores and markets for sending catalogs to. Met with users to determine enhanced functionality of the system, as well as any trouble shooting issues in the current system.
Also Wrote a project tracking system for HDTV, tracking all HDTV projects, using Visual Basic 5.0, Access 97, and Crystal Reports 6.0. Met with users to determine requirements for the system. Designed the database, wrote all code and created all reports using Crystal Reports 6.0. December 1997 – November 1998
References: Available upon request
Availability: Negotiable
Contact this candidate