SUMMARY:

Senior Database Developer with over 10 years of experience in Database Development, Data Architecture, Database Administration, Data Integration, Data Warehousing and Business Intelligence.

SPECIFIC SKILLS AND EXPERIENCES INCLUDE:

• Disaster Recovery (DR) and High Availability solutions
• Database system architecture and capacity planning
• ETL development using SSIS
• Complex stored procedures, user defined functions, and triggers
• SQL Server Reporting Services (SSRS) and Excel report development
• SQL Server Analysis Services (SSAS) cube development
• Performance tuning and query optimization
• Strong problem solving and analytical skills
• Database design for OLAP and OLTP systems

EXPERIENCE:

Confidential, Exton, PA

SR. SQL DBA/Developer

Responsibilities:

• Writing, analyzing, and optimizing stored procedures, functions, and views.
• Trouble shooting and rewriting poorly running SSIS Packages.
• Rewriting poorly processing SSAS Cubes.
• Mentor/Train Junior DBAs and Developers.

Confidential, Souderton, PA

SQL Developer (Consultant)

Responsibilities:

• Writing, analyzing, and optimizing stored procedures, functions, and views.
• Creating dashboards and dynamic reports using Microsoft Power BI.
• Writing new SSRS Reports and rewriting existing poor performing reports.
• Writing new ETL process using SSIS for Data warehouse.
• Designing new Datamarts in SSAS for Reporting.
• Data integration from multiple systems to Salesforce using dataloader and SOQL.

Confidential, Wayne, PA

SQL Developer (Consultant)

Responsibilities:

• Writing, analyzing, and optimizing stored procedures, functions, and views.
• Rewriting / Troubleshooting / documenting existing SSIS Packages.
• Writing new SSIS Packages.
• Assist in migrating databases from SQL 2008 R2 to SQL 2012/2014.
• Writing new SSRS Reports and rewriting existing poor performing reports.
• Create new Datamart with Dimensions and Cubes in SSAS for reporting.
• Re - Architecture of existing Data warehouse to support new cubes and future expansion to Power BI.

Confidential, Conshohocken, PA

Senior DBA/ Senior Systems Engineer

Responsibilities:

• Responsible for Development, QA and Production Environments.
• Lead and mentored software engineers on database development and best practices.
• Writing, analyzing, and optimizing stored procedures, functions, and views.
• Multiple Upgrades R2, 2008 R2 to 2012 and 2014.
• Lead Architect of Company's multisite Failover using Always On Clustering and Virtual Servers.
• Set up Read-only replicas for performance enhancements.
• Implemented and developed multiple SSIS packages for data movement between production systems and corporate systems (Microsoft CRM and Great Plains).
• Created Multi-Dimensional Data Model for Data warehousing process.
• Implemented and developed SSIS packages for data warehousing of production systems.
• Responsible for Ad hoc reports using TSQL.
• Wrote SSRS packages to replace end of life Business Objects Crystal Reports.
• Create automated scripted solutions to perform various administration and monitoring tasks.
• Experience with SQL Sentry, and Idera’s SQLDM monitoring tools.
• Created Data Model for Custom billing application to integrate with Great Plains.
• Created Web pages using c#.net for basic administration of custom billing application for accounting department.
• Maintained, and Upgraded Microsoft CRM.
• Maintained and Upgraded Microsoft Great Plains 8.0, 10 and 2013 R2.
• Created SSIS package pulling data from 3cx phone system running Postgres SQL to Microsoft SQL Server for custom reporting.
• Working knowledge of multiple SAN technologies including HP, Netapp, EMC and PureStorage.

Confidential, Wyncote, PA

Database Administrator

Responsibilities:

• Analyzed and Optimized poor running Stored Procedures.
• Made recommendations and implemented new indexes.
• Identified and repaired data related bugs.
• Monitor database growth and server resources to ensure optimum performance and availability.

Confidential, Horsham, PA

Senior Database Administrator / Systems Engineer

Responsibilities:

• Maintenance and support of all SQL Server 7.0/2000 based applications.
• Responsible for running reports and designing Crystal Reports.
• Responsible for logical and physical design of databases for improved performance and integrity.
• Direct all aspects of enterprise-level database administration encompassing writing stored procedures, triggers, functions and E-R Modeling.
• Set up, monitor and maintain replication.
• Performance Tuning
• Data loads using Data Transformation Services.
• Completed search engine redesign, resulting in improved performance and production of results using real-time data.
• Support and provide technical guidance to Development Staff and end users regarding effective design, integration and use of database functions and tools.
• Research, development and implementation of tools and procedures to enhance effectiveness and efficiency of database administration.

Confidential, Horsham, PA

Senior Support Specialist

Responsibilities:

• Team Leader of Support and Operations Specialists Group (SOS).
• Provide training and technical assistance to all junior support specialists.
• Troubleshooting, debugging and repair of all internal and external internet applications utilizing ASP, VB.NET, Visual Basic, XML, Cold Fusion, VBScript, SQL Server 7.0, SQL 2000, IIS 4.0, IIS 5.0, Site Server 3.0, Windows NT 4.0 Server, and Windows 2000 Server.
• Support Development Web Engineering, and Database Administrators and provide recommendations for improvements to enhance effectiveness and efficiency within these departments.
• Member of Change Management Committee.

Confidential, Horsham, PA

Network Administrator

Responsibilities:

• Management, maintenance and design of network infrastructure supporting over 50 employees.
• Support of Microsoft Exchange server 5.5 with Outlook clients.
• Support of Microsoft Windows 2000 WINS and DNS servers.
• Support of Raptor EC VPN Server for remote workers.
• Research, recommendation and introduction of new software products and processes to enhance efficiency, communication and workflow.
• Assessment, recommendation and order placement for all IT purchases including servers, employee workstations and peripherals.
• Setup and support of end user machines.
• Support of all telephone, voicemail and videoconference equipment.
• Support of alarm system programming and access control.

Confidential, Horsham, PA

Network Administrator

Responsibilities:

• Management, maintenance and design of network infrastructure supporting over 100 employees.
• Support of Microsoft Exchange server 5.5 with Outlook clients.
• Support of Microsoft SQL server 6.5 and 7.0 for accounting software (Solomon ).
• Support of Microsoft IIS 4.0 server for company Internet and intranet websites.
• Support of Microsoft NT 4.0 DNS servers.
• Support of Raptor Firewall 6.02 with VPN connectivity to branch office in Boise, Idaho.
• Support of Remote access server for offsite employees.
• Support of all telephone, voicemail and videoconference equipment.
• Strategic planning and resolution of all network-related issues (security, access, etc.) for clients pertaining to installation of Confidential software.
• Research, recommendation and introduction of new software products and processes to enhance efficiency, communication and workflow.
• Knowledge of website production processes and tools.