SUMMARY:

• SQL Server DBA, UAT SQL Manager, Integration Specialist, ETL/ Business Intelligence Analyst and Problem Solver with solid knowledge of T - SQL Development and coding, QA/Tech Support, Change Management, Agile principles, BI Engineering, user interaction, leading and hiring other database specialists, Change Management and Documentation.
• Total years in IT: 18 years of MIS experience in all major aspects of Database Administration, SQL Development, Systems Analysis, Integration, hands-on programming, deployment and technical support of information systems of varying size and complexity.
• Project Management (9 months); off-shore team coordination.
• Have been described as a Software Engineer with excellent communication, software integration, documentation, performance optimization, crisis solutions, disaster recovery (DR), technology research, end-user management interaction, and team networking skills.

TECHNICAL SKILLS:

SERVER OS: UNIX, Linux, Windows Server 2003/2008 R2/2012.

DATABASES: Microsoft SQL Server 6.0/6.5/7.0/2000/2005/2008/ R 2/2012/2014/2016 ; IBM DB2; Oracle 8.x/10; Sybase;

DBA emphasis: MS SQL Server.

LANGUAGES: SQL, TRANSACT-SQL (T-SQL), PL/SQL, VISUAL BASIC 3.0/4.0/5.0/6.0/. NET, JavaScript, HTML, XML, VBScript, Java; .NET/C#

SOFTWARE/TOOLS: Red-Gate SQL Compare/Data Compare, Toad (Oracle), SQL Server Reporting Services (SSRS), SSAS, BI, Cristal Reports (Business Objects), MS Office (incl. Automation), SQLDBManager Plus (ManageEngine), IGNITE (currently SolarWinds), Red Gate software tools, Oracle (Toad, SQL Developer)DBArtisan 5.1, Desktop DBA 4.1, SQL-Programmer 8/9, SQL-Optimizer, AQUA Data Studio, and custom tools developed by self (SQL Agent Jobs Management Utility; BLT - Block and Lock Tracing)

WEB DEV: IIS/ASP, VBScript, JavaScript, ActiveX, HTML, XML, ColdFusion, .NET Business Intelligence (BI)/Reporting: Crystal Reports (4.5/6.0/7.0/8.0/11.0 )/Business Objects, SSRS (SQL Server Reporting Services), SSIS (starting with DTS), Data Mining, Data Warehouse (DW) Architecture and Implementation, Administration, and Development, Analysis Services (SSAS). Other ETL and Cubes: Informatica, Talend, Cognos.

EXPERIENCE:

Confidential, Conshohocken, PA

SQL Server DBA

Responsibilities:

• As a part of the CMS Government Engineering group within Confidential (formerly Connolly Healthcare) and as a Business Intelligence and Performance DBA, Production DBA in the specific business areas, and BI Analyst with strong knowledge of T-SQL and Data Analysis -- investigated, setup troubleshooting routines, and proposed solutions to production issues that cause slowdown of major overnight ETL processes.
• Via fine-tuning SQL Server configuration options, indexing, and re-writing essential blocks of T-SQL, I have achieved performance gain that can be quantified not only by seeing reduced I/O on the server but also via run-time (reduced from 15 to 8 hours overall duration of the overnight report building process.
• Setup, Tuned, and tested the first SSRS environment in the company, and supervised and developed and the first suite of SSRS reports in the company (using certain prototypes of reports formerly developed in MS Access and Excel yet scalability requirements called for a different, more robust environment like SSRS and/or Business Objects.
• Analyzed and maintained data models using Aqua Data Studio, Erwin, and SQL Developer tool for Oracle.
• Creating data models for data-marts branching off the primary data warehouses.
• Working with both Star and Snowflake schemas, OLTP, and OLAP data structures.

Confidential, Dover, DE

SQL Server DBA; BI/ETL Manager

Responsibilities:

• As Business Intelligence DBA, Reporting Manager, BI Analyst, and Data Modeler provided day to day input into maintaining both Production and Development servers (SQL Server 2008, 2012, and 2014), as well as actively participated in SSIS, SSRS, and SSAS solutions. Day to day standard DBA operations as well as restoring QA servers to a point in time, refreshing Development server data from Prod, and troubleshooting production issues.
• Closely worked together with network engineering, Share Point administrators, and product development and delivery teams. Performance analysis and optimization (including custom performance base-line data collection), DR (Disaster Recovery) and High-Availability solutions, big data management, and supervising and supporting ETL/SSIS developers and ETL processes. Database architecture and change management. T-SQL code refactoring and testing. DR Documentation and Report Portal Analysis. Using SSRS and SharePoint; SSIS as an ETL tool. Consolidated (nightly) data from e-School application (from each school district)
• Communicated with Data Analysts, User Management, SharePoint Admins, and Network Engineers to define and the requirements for database/DW needs more precisely.
• Tested the DE Department of Education web portal, Web Service, and the pertaining ASP.net application.
• Created a number of DataMarts and corresponding ETL processes (SSIS) to cater to specific identifiable report groups and DashBoard portal through which the said reports are accessible.

Confidential, Wilmington, DE

Database Consultant

Responsibilities:

• As DBA, Performance Investigator, and SQL Developer/BI Developer closely collaborate with both Infrastructure and Development groups to identify and remediate major Database Server performance issues, particularly focusing on optimization and tuning of T-SQL within Stored Procedures and Functions that house the main business logic for the company’s most essential software products, primarily high-concurrency and high-volume web-based .NET and .Java applications, .NET Web Services, Windows Services, and Databases (multi-terabyte SQL Server and Oracle databases).
• Create highly customized SQL Server Performance Data Warehouse reports as well as SSRS Reports on custom Base-Lining Data Collection repository (developed by self for daily performance-related data collection) and reports on global company-wide Defect Lifecycle History (VersionOne Scrum system), as well as Oracle PL/SQL.
• Designed a light-weight Historical Performance data collection baseline solution for Production.

Confidential, Richboro, PA

SQL Server Manager

Responsibilities:

• Worked for a number of clients, both remotely and on-site. Specializing in T-SQL Development and code reviews, Data Architecture, ETL Solutions, DR (Disaster Recovery) solutions, BI/OLAP/Reporting, Performance Analysis and Optimization. Setting up Clusters, Programming in T-SQL, Complex Stored Procedures, SSIS, using all the latest features of SQL Server 2008 along with 2005 and 2000 versions. Providing data migration (cross-version) architecture. SSIS. SSRS
• Supervised teams and installed numerous SQL Servers and setup SQL Server Solutions for DR and Performance Enhancements purposes.
• Thoroughly documented the DR procedures and tested timed recovery scenarios following hardware, databases, and applications failures.
• Hired/Interviewed other SQL Server specialists especially in SQL Development and DBA areas.
• Extensively communicated with the clients, gathered, analyzed, documented and ratified user requirements.
• Provided monitoring tools (both 3-rd party and written by self) for production SQL Servers.
• Ensured performance/uptime.
• Enterprise-wide application Architecture, Analysis, Addressing critical areas and suggesting best solutions as well as implementing them, including hands-on coding in Transact-SQL, PL/SQL, .Net.

Confidential, Wayne, PA

SQL Server DBA

Responsibilities:

• Project Coordination/Management, User Requirements analysis, SQL Server Developer and DBA duties. Data Warehousing/BI, Reporting, SSIS, Database Design and Redesign.
• Production and development support and DBA functions, including SQL Server 2000, 2005, and 2008 installations, backups, DR (Disaster Recovery) Plans, migrating databases from SQL Server and Oracle.
• Database Performance analysis and enhancement.
• Systems redesign, and QA of redesigned solutions. Data Mining and BI Solutions Architecture and Optimization. T-SQL, PL/SQL, and OOP Development. More than 50% of work was done in a remote/telecommuting setting in an extended team.
• QA TESTING and hands-on code enhancements and bug fixing throughout the entire project lifecycle with focus on reporting layer.
• Resolved numerous issues with end-user and customers, both technical and business. Networked with a small team (2 to 4 developers) in joint efforts to implement a Legal Case Management report engine (MSSQL, Oracle, Java, SQL, HQL). Conducted the full process of data mapping and data migration (MS SQL Server, Oracle, XML, Reporting system redesign and enhancements).

Confidential, Plymouth Meeting, PA

SQL Server DBA

Responsibilities:

• As a part of the DBA team, performed production support and core DBA functions, such as Performance Analysis and Query Optimization, installations of SQL Server 2000 and 2005, creating standards and practices documentation, managing database users and security, data modeling and database design, as well as overall environment monitoring and fulfilling data migration requests of various business segments within the company.
• Coordinated an offshore DBA team with local teams, conducted QA testing, and reported results to management.
• Supporting production databases, periodically migrating production data to QA and DEV servers.

Confidential, Princeton, NJ

Development DBA

Responsibilities:

• Business Intelligence (BI) solutions for Financial Reporting and Auditing. OLAP/Data Analysis. Cognos 7.
• Designed, coded, monitored, enhanced, and supported Risk Control Tracking System (RCTS), including DataMart (MS SQL Server 2000), a cumulative system containing daily information from six major segments of Tyco for SOx (Sarbanes-Oxley law) assessments/auditing and corporate headquarters’ financial reporting purposes.
• Utilized efficient combination of business analysis and systems architecture and programming (T-SQL, VB, ASP, .NET). Redesigned and improved a multi-faceted DataMart loading process (ETL tool: DTS).

Confidential, Princeton, NJ

Database Specialist

Responsibilities:

• SQL Server DBA and Developer duties. .NET Programming.
• Evaluated overall performance of the AutoADDDNIS system, originally designed to test new international call placement provider lines and area codes.
• Estimated projected systems re-design efforts and technical steps. Proposed and documented the new architecture.
• Pursuant to time and resource estimate, prototyped and coded the new software using Transact-SQL (primarily stored procedures programming), ASP.NET/C# middle tier and presentation layer, and the existing Confidential proprietary subsystems.
• Closely networked with Project Management, DBA, and Development staff. Implemented and documented stored procedures of varying size/complexity.
• Coding in Sybase and MS SQL.
• Data Modeling and Database documentation. Manual and Automated Q/A testing and change management.

Confidential, Marlton, NJ

Senior Integration Specialist

Responsibilities:

• As Database Analyst, Integrator, and DBA Supported over 50 SQL Servers located worldwide. As an Integrator and Developer participated in full life cycle of software development.
• Data Architecture, Performance Analysis, Transact-SQL and PL/SQL Programming and DBA (50%), .NET/VB/C#/ASP Programming and Project Lead (25%), integration/PM (25%)
• Efficient problem solver for 100+ customer sites providing IDE data supply to SAP systems Hands-on coding and Lead Developer level analysis of client requirements and documentation. Multi-system, cross-platform back-end and front-end data movement based on the company’s main products ‘Datapass’, ‘DP Exchange’, and ‘DataLink’ (Object-oriented structures, Web Services/SOAP, Transact-SQL)
• Conducted Performace Analysis of Production Databases; Wrote and enhanced custom tools for this and the related purposes: BTR and BLT (Block and Lock Tracing) utilities (SQL Stored Procedures, C#/.NET).
• The solution is designed to safely collect information in production run-time, save and transform data and metadata for further analysis. Coded SQL Task Manager utility (VB 6), which allows client managers to monitor SQL Agent Jobs and DTS Packages, scheduled for recurrent execution. Wrote a utility application that provided DBAs and Project Management Personnel with fast database comparison functionality (faster than RedGate software tools and most of other tools available on the market).

Confidential, Jenkintown, PA

Programmer-Analyst (Data Analyst)

Responsibilities:

• Internet Marketing and E-Commerce, Financial and Billing programs and SQL Server 2000 RDBMS (programming, design, data modeling, and Application DBA)
• Auto Responder Email business objects. Implemented System Architecture. Involved in planning, and hands-on development.
• ASP, VB 6, SQL Server 2000, COM, SOAP, COM+, XML, and VB.NET.
• Responsible for overall system and project documentation and production turnover.
• Analyzed development environment. Conducted application integration research, which resulted in creating a generic cross-server Error Handling and Exception Processing solution, using VB/COM, XML, ADO.

Confidential, Ridley Park, PA

Database Consultant

Responsibilities:

• Database Analysis and Transact-SQL development (Sybase 11 on Sun Solaris UNIX and Red Hat Linux).
• Application analysis and development: Development environment: ColdFusion, ASP, VB 6, JavaScript, XML.
• Exposed Econometric Forecasting data from a large database to Confidential customers located in more than 70 countries and accessing data through web interfaces and desktop applications. T-SQL Development in Sybase.
• Designed and coded the XPAT software used internally for extracting multi-spreadsheet Excel data (building in-memory hierarchies into XML DOM and displaying the dynamic tree in a GUI treeview and saving it to XML files upon user verification). XDLoader application: Wrote stored procedures processing hierarchical structures of user permissions. Supported and fine-tuned the solution in Production.

Confidential, Blue Bell, PA

Systems Developer

Responsibilities:

• Automated the main business processes within the KPI ScoreCard system for marketing and accounting division of a Pharmaceutical Firm and its Prescription Managed Care Provider.
• RDBMS: Sybase SQL Server 11.0. Performed all required Developer responsibilities along with the assigned applications analysis, coding, and maintenance.
• GUI: Application was originally created in VB 6.0, and later converted to the Intranet Web Interface.
• Reporting: Power Point, Excel, Crystal Reports 6.0/7.0
• Development: Performed 50% of development on the server side using SQL, Transact-SQL, 25% of development using VB 6.0 and other development using HTML, JavaScript and VBScript for creating Web Interfaces interacting with SQL Server databases. Optimized query performance. Enhanced ActiveX components used as the ScoreCard’s business rules processing tier.