SUMMARY:

• Experienced professional with proven ability to assess, evaluate, and solve a wide variety of business problems.
• Analyzes user processes and designs; creates and maintains database systems, including integration, ETL, and reporting.
• Highly experienced in conveying ideas, concepts, and necessary information to others in written and presentation forms.
• Able to converse and teach technical material.
• Twenty years experience in designing, developing, and maintaining database systems.
• Programmer/analyst with highly - developed problem-solving, application design, and re-engineering skills.
• Ten years experience of creating engineering systems in Confidential and aerospace fields. Six years of increasing work as a DBA.

TECHNICAL SKILLS:

Databases: MS SQL Server 6.5 - 2014, Oracle 7 - 11, Access 95 - 2007, MySQL 4 - 5, InterBase 4 - 5, Paradox.

Tools: MS Visual Studio, Confidential, SSMS, SSRS, SSIS, Crystal Reports, SQL Developer (Oracle), Splunk, Toad (Oracle, SQL Server, DB2), Navicat (MySQL), TOP (PHP), Apache, MS IIS Server.

Languages: SQL (ANSI, T-SQL, PL/SQL), VB.Net, ASP, ADO, ADO.NET, HTML, JavaScript, PHP 4, VB, VBA, VB Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, King of Prussia, PA

Data Analyst, Senior Database Developer

Responsibilities:

• Restructuring implementation of nightly processes to reduce elapsed time from 4 hours to 30 minutes.
• Successful implementation of new error-handling process to eliminate process failures due to deadlock conditions in several systems.
• Implementation of new inter-systems connections technique, again eliminating contention side-effects.
• Introduction of new techniques for data cleansing and task synchronisation, improving the reliability of the ETL processes.
• Extensive ETL work using SSIS, automating data import flows.
• Re-design of data validation subsystems to improve reliability and speed.
• Control of software release process to eliminate flawed releases.
• Overall control of software message handling and forwarding system servicing several clients with differing communications requirements.
• On-going maintenance and enhancement of systems for processing patient data, including identification and amelioration of problems such as time-outs and deadlocks in systems with constrained resources and multiple users.

Confidential, Philadelphia, PA

Business Analyst, Data Analyst

Responsibilities:

• Analysis of large volumes (multi-GB/day) of real-time metadata regarding email and voicemail traffic.
• Translation of client requests into report and dashboard design.
• Development of client dashboards and of documentation on dashboard development in Splunk.
• Provided assistance transitioning Confidential clients to new bulk mail system.

Confidential, Philadelphia, PA

Business Analyst, Database Developer, DBA

Responsibilities:

• Business and data analysis translating client requests into report and dashboard design.
• Design and development of SSRS reporting packages for customer-facing applications.
• Creation of product dashboards for sales and management use.
• Development of SSIS/SSRS systems supporting Sales Monitoring, Collections, and Call Center functions.
• Development of SSIS ETL packages for automation of data flows within the company.
• Implementation of packages for automation of DBA functions (backup, restore, external data retrieval) using SSIS, Python, and commercial software.
• Migration of systems from SQL Server 2008 to 2012.
• Instruction of colleagues in use of SSIS, SSRS, and SQL (teaching internal courses).
• Business analysis and data analysis and design of initial-phase BI systems.
• Maintenance and enhancement of accounting support systems for internal use and for external auditing.
• Maintenance and improvement of T-SQL and SSIS code.
• Creation of documentation of automated processes.

Confidential, Yardley, PA

Data Analyst, Database and Report Developer

Responsibilities:

• Created SSIS packages for inter-server data transfer to support reporting processes.
• Designed and created reports using SSRS to improve monitoring and financial reporting for field sales teams.
• Conducted ongoing analyses and provided recommendations on improvements to data structures and overall data quality control.
• Created business documentation of existing and proposed reporting, of work processes, and of procedures.

Confidential, Yardley, PA

Data Analyst, Database Developer

Responsibilities:

• Created SSIS packages for data transfer for billing control.
• Created a database, with user front-end written in PHP, to support creation and maintenance of customer satisfaction surveys presented over the phone.
• Devised and implemented processes for providing financial data for billing requirements.
• Updated, repaired, and maintained a ColdFusion-based phone response support system, including adding new database modules to accommodate new sources of data and re-creating some lost ETL areas.

Confidential, Basking Ridge, NJ

Data Analyst, Database Developer

Responsibilities:

• Created SSIS packages for sales support, including centralized production of email alerts.
• Interfaced SSIS and Web Services in order to trigger web service processes from data conditions.
• Set up Subversion SCCS to support database development.
• Created interactive SSRS reporting as user interfaces for remote users.

Confidential

Data Analyst, Database Developer

Responsibilities:

• Used Access as a control module for coordinating checks on card data validity (patterns and occurrences indicative of invalidity, missing data, etc.)
• Wrote queries against DB2, SQL Server, and Teradata database systems.
• Created SharePoint forms and defined supporting logic.

Confidential, Charleston, SC

Software Developer (SQL Server 2008R2, SSRS, Confidential )

Responsibilities:

• Used SSRS to create and update reports from the Confidential data warehouse.
• Created product features using XML specs for tables, stored procedures, etc.

Confidential, Philadelphia, PA

Database Developer / DBA

Responsibilities:

• Used SSIS to import scanned network data from Oracle and client data from flat files into SQL Server.
• Created TSQL functions and stored procedures on SQL Server to manipulate large data-sets (up to 40 million records). Cleansed and normalized the data according to rules and constraints provided by the client.
• Designed and built processes for extracting reportable information from data.
• Used SSRS, Access, and Excel to produce both ad hoc and predefined reports for client.
• Carried out DBA duties - database design, creation, maintenance, backups and restores. Evaluated and solved performance problems associated with large data-sets.
• Mentored colleagues on the project and on some aspects of SQL Server, including use of SSIS for ETL.

Confidential, Bridgeport, NJ

Database / DBA Consultant

Responsibilities:

• Documented systems and implemented repairs and upgrades in T-SQL stored procedures and Access VBA.
• Assisted staff in running daily operations, recreating procedures from records of previous data and results.
• Implemented new and improved the existing ETL processes and generally improved data QA within the operation, transferring code from Access to T-SQL stored procedures.
• Supported other programs written in-house in use in the department, including distributed tasks using MSMQ from VB.NET.
• Acted as company DBA, performing SQL Server backups, restores, and query improvements.

Confidential, MD

Instructor (Oracle 10 / 11)

Responsibilities:

• Provided successful tutoring, mentoring, and one-on-one instruction for disabled Confidential employees studying for Oracle PL/SQL programming certifications.

Confidential, Somerville, NJ

ETL Specialist

Responsibilities:

• Developed T-SQL software (stored procedures, functions) and ETL packages (SSIS) for data migration from a legacy Paradox system into SQL Server systems.
• Performed data mining, analysis, and reconstruction in order to retrieve information from migrated legacy data.
• Worked with client staff to produce an understanding of the content and extent of the legacy data.

Confidential, Marlton, NJ

Programmer / Analyst / DBA

Responsibilities:

• Developed T-SQL software and Confidential packages for Confidential between Confidential and clients to import and clean data, locate and report on problems, and import data into production systems.
• Wrote interface software to the (Access-based) GUI layer. Debugged SSIS and Confidential packages.
• Created and maintained internal and client reports in Access and Excel, using VBA and VBScript. Started development of reporting using SSRS.
• In DBA role, responsible for release control production software systems, including creating database release and recovery scripts, and overseeing releases.
• As DBA, worked to improve sub-system performance, achieving improvements of between 10% and 80% in database performance. Worked to develop Disaster Recovery functions.

Confidential, Fort Washington, PA

Programmer / Analyst

Responsibilities:

• Provided development and conversion support for UHG-Ovations (government health plans) in an effort to pull departmentally-developed Access-based databases into a common framework.
• Provided technical oversight for a new project for registration of Texas Medicare patients.
• Performed conversion of Access database system to MS SQL Server, with some 1,500 users.
• Automated data migration across databases with structural differences, using VB.NET and SQL Server
• Assisted UHG DBA staff with DBA functions.

Confidential, Philadelphia, PA

Programmer / Analyst / DBA

Responsibilities:

• Analyzed data usage, work requirements, and work-flow patterns for a procurement agency.
• Filled the role of DBA for the company, designed and implemented the physical database and the data architecture. Set up backup and restore schedules, etc. Installed database updates and patches.
• Created the software application, using VB.NET and T-SQL (functions, stored procedures).
• Achieved reductions in data processing time up to 80%.
• Wrote business requirements and software design. Wrote all documentation, manuals, and test case scripts.