TECHNICAL SKILLS

• SQL Server 2008/2012 Data Modeling & Design
• SQL Reporting Services Erwin MS Access
• SSIS/SSAS Query Optimization VBA
• Transact - SQLPerformance Tuning MS Excel

PROFESSIONAL EXPERIENCE

Confidential, virginia beach, VA

DBA/Senior Database Developer

Responsibilities:

• Perform DBA tasks such as backup and restore, clustering of large databases.
• Manage security including users and permissions.
• Monitor and troubleshoot performance issues on server.
• Write deployment scripts for database migrations from SQL to Oracle.
• Responsible for moving and upgrading large databases.
• Design SSIS packages for transferring and converting data.

Confidential, Miami, FL

Senior ETL/Data Warehouse Developer

Responsibilities:

• Provided analysis of complex health care data
• Responsible for on boarding of new customer data by creating appropriate data structures and ETL processes.
• Developed T-SQL procedures for analysis and reporting
• Rewrote code for calculated fields, to comply with changes in government regulations.

Confidential, Philadelphia, PA

SQL Developer

Responsibilities:

• Redesigned queries with pivot function for cross tab reporting.
• Designed SSIS packages to handle processing of XML data.
• Wrote T-SQL stored procedures for web based purchase order system.
• Designed queries to pull orders and converted to XML data.
• Created vb.net scripts in SSIS for importing and exporting data from files.

Confidential, Philadelphia, PA

DBA/Senior Data Analyst

Responsibilities:

• SQL DBA for company wide windows XP migration project.
• Integrated information from Active Directory and web based survey into SQL 2008 database.
• Analyzed existing data structure and processes to pinpoint errors.
• Performed troubleshooting and performance tuning on server and database issues.
• Implemented changes to data structure to ensure greater accuracy and efficiency.
• Created and modified SSRS reports based on t-SQL to track progress of upgrades.

Confidential, Wilmington, DE

SQL Developer/DBA

Responsibilities:

• Lead Developer for large home loans initiative.
• Created new data model in SQL 2008 for Short Sales qualification survey web application.
• Analyzed existing databases and redesigned for normalization and greater efficiency.
• Successfully tailored model and rolled database out to three additional lines of business.
• Performed troubleshooting of SQL server, identified and solved performance issues.
• Designed SSIS packages for transfer and processing of data between SQL, Excel and AS400.
• Created automated JAMS and SQL Agent jobs to run SSIS packages and stored procedures.
• Wrote stored procedures in T-SQL.
• Created data definitions for dictionary for data warehouse.
• Mentored junior developers in SQL best practices and coding.
• Developed new dashboard reports with SSRS 2008.

Confidential, Philadelphia, PA

SQL SSRS Developer

Responsibilities:

• Designed model for SQL Server database for renewable fuels, to ensure compliance with EPA regulations.
• Maintained model during revisions to new application version that was developed over months.
• Oversaw changes in accordance with SOX compliance regulations and procedures.
• Created new reports with SQL Reporting Services, including drill-down, multi-select parameters and cascading parameters.
• Wrote Transact-SQL to track transactions and aggregate sales data for reporting.
• Performed analysis of complex queries used for quarterly audit reporting, to find errors.
• Wrote queries and designed reports in Access to verify transactions between two databases.

Confidential

Teacher of Database Management

Responsibilities:

• Taught database concepts such as table and index design, relationships, queries and reporting.
• Supervised student computer lab exercises and mentored students in effective data management.
• T-SQL, SSRS/SSIS and SSAS. Managed projects with MS Project, including creation of timelines, writing specs, creating tasks, and allocation of resources. Projects included data design, stored procedure development with T-SQL, creating reports using SQL Reporting Services, converting reports from legacy systems to SSRS, coding stored procedures for reports from SSAS dimensional tables for current and previous year reporting, data conversion from different sources via SSIS, and VBA coding with Access and Excel.

Confidential, Wilmington, DE

Responsibilities:

• Responsible for integration of companywide large (100+ tables) database
• Wrote queries in Transact-SQL for populating normalized SQL database
• Designed complex queries in Access for validating imported data
• Exported data from SQL 2005 to SAP system using SSIS package

Confidential, Mt. Laurel, NJ

Responsibilities:

• Created SQL Server 2005 database to hold capacity planning data
• Designed reports on utilization data with SQLReporting Services
• Extracted data from Excel using VBA, imported into SQL via SSIS
• Created Access front end for managing and editing input data

Confidential, Philadelphia, PA

Responsibilities:

• Designed relational SQL Server database for managing fleet of equipment
• Coded queries in Transact-SQL, to track service schedules and availability of equipment
• Wrote VBA code to send complex data sets about services and car type usage to Excel for analysis
• Wrote Excel VBA code to create custom reports and calculations
• Developed database applications for several business and non-profit clients, using Microsoft SQL Server, Microsoft Access, and Microsoft Excel. Roles included database design in both Access and SQL server, writing SQL queries using T-SQL for data retrieval and manipulation, extensive VB and VBA coding. Industries included financial planning and life insurance, event management, real estate brokerage, and human services.

Confidential, Newtown Square, PA

Responsibilities:

• Worked closely with DBA and senior management to develop data definitions and ensure data integrity.
• Designed database in SQL Server, integrating data from multiple sources
• Created multiple input screens with Access, to hold hundreds of fields of product information
• Wrote VBA/ADO code for accessing database, VBA code for financial analysis of product data

Confidential, Plainsboro, NJ

Responsibilities:

• Worked with VP of marketing to create definitions of database for integration with SQL database from Documentum system.
• Designed Access front end used by marketing Reps for editing data
• Wrote VBA and ADO code for processing data.

Confidential, Moorestown, NJ

Responsibilities:

• Redesigned Contact Management System for marketing dept., for rollout to several hundred users
• Created SQL server database for business client and contact history data
• Wrote stored Transact-SQL procedures for all data access and queries
• Designed Access forms and wrote VBA code for processing contact tracking
• Rewrote all VBA code contained in the application, utilizing ADO.
• Performed testing according to test plan scripts and documented results

Confidential, Bala Cynwyd, PA

Lead SQL Database Developer

Responsibilities:

• Designed SQL Server databases for web sites
• Wrote Transact-SQL stored procedures for data access and processing.
• Used Erwin and Embarcadero to create models for large databases.
• Wrote T-SQL routine to determine geographic proximity via zip code, for use by multiple client sites.
• Supervised development of SQL procedures by offshore team
• Imported and converted data files from various databases and text formats via DTS
• Mentored junior developers in efficient table, index, and query design
• Performed analysis and troubleshooting of queries

Senior Web Developer

Responsibilities:

• Developed business web sites using ASP, VB, Cold Fusion and SQL Server
• Met with external clients to gather requirements
• Served as team lead, overseeing junior developers and graphics designers
• Wrote ASP based web apps in Visual Interdev, VB/COM, using ADO, VBScript, and JavaScript.
• Designed HTML user input forms with front end JavaScript validation.
• Developed eCommerce apps in Cold Fusion, with online product catalogs, shopping cart, SSL.
• Wrote XML component for transferring data via http.
• Responsible for full project cycle, from gathering requirements from clients, writing specs, analysis, data design, coding, testing, through installation and support.

Confidential, Philadelphia, PA

VB/SQL Developer

Responsibilities:

• Worked with Erwin to maintain database structures and insert modifications.
• Developed VB class modules for handling file I/O between project files and SQL database.
• Wrote stored procedures to replace existing Visual Basic code, resulting in significant performance benefits to application
• Wrote ad hoc transact SQL queries for analyzing project budgets for management on an ongoing basis.
• Created Access queries for maintenance, moving data and developing standard reports
• Extracted data from research documents, wrote VBA code for tracking data from clinical trials
• Wrote VBA code and designed templates for tracking clinical trial information

Confidential, Philadelphia, PA

VB/SQL Developer

Responsibilities:

• Maintained database model with Erwin
• Provided analysis and support for Visual Basic application used by legal dept. for case management.
• Made recommendations for redesign of application including migration to VB 5, integrating data from multiple servers, upgrading to SQL Server 6.5, and evaluation for year 2000 compliance.
• Wrote Transact SQL stored procedures to transfer financial data between legal and billing depts.

Confidential, Wilmington, DE

Responsibilities:

• Developed Access application using VBA code to manage department work requests.
• Responsible for full life cycle development, including gathering requirements, completing project plans, creating prototypes, data design, coding, and testing.
• Wrote Access queries to monitor percentage of mainframe solicitation file usage.
• Designed VB5 application to query Oracle tables, total responses from marketing campaigns.

Confidential, Philadelphia, PA

Senior Programmer/Analyst

Responsibilities:

• Developed financial applications for Rating and Underwriting Division.
• Designed new accounts receivable system in Microsoft Access.
• Converted several existing financial dbf database programs to VB, Excel, Access, and VBA.
• Wrote new application with complex formulas to automate calculation of account settlements, using OLE automation between Access and Excel.
• Member of team responsible for converting rating process from numerous PC applications into consolidated client server Oracle based system, using Access and Excel as front ends.
• Provided training and support to end users and management.

Confidential, Philadelphia, PA

Programmer/Analyst

Responsibilities:

• Wrote Clipper applications for DOS and Novell Networks.
• Responsible for maintaining and revising large accounting and budgeting apps for advertising dept.
• Supported accounting applications for entire Control Division.
• Wrote program for managing shipping of merchandise between 17 stores.
• Designed medical provider database for handling worker's compensation claims.
• Performed extensive troubleshooting of PC, Network and program problems.