PROFESSIONAL SUMMARY:

Confidential has extensive experience in large, mission - critical environments with a proven ability to design high-availability solutions, integrate systems, manage projects, manage resources, and solve problems. He interfaces with customers extremely well and is always willing to go the extra mile to help.

TECHNICAL EXPERIENCE:

Microsoft Windows Servers

Microsoft Windows Desktops

VMWare

Microsoft Windows Virtual PC

Microsoft SQL Server (6.5,7,2000 - 2014)

Novell Netware

Unix (Red Hat Linux / Ubuntu)

Windows Software Update Services (WSUS)

Symantec NetBackup

Autosys

Symantec AntiVirus Corporate Edition

Microsoft Access

MS SQL Server SSIS / SSRS / SSAS

Microsoft Visual Studio (.Net 2002 - 2012)

SQL Server monitoring - Spotlight, Foglight

VBA/VBS Visual basic Applications / Scripting

Familiar with NoSQL Databases (MongoDB, HBase, Cassandra, CouchDB) / Hadoop MR.

Microsoft Active Directory

Microsoft Windows Powershell Scripting

NT Shell Scripting

Microsoft Cluster Services (MSCS)

.Net (VB / C#)

Microsoft Internet Information Server (IIS)

Microsoft POWERPIVOT

Microsoft Office

Microsoft (DNS)

Microsoft (DHCP)

Javascript, JSON

Star Team, Team Foundation Server

Proclarity, Tableau, Qlikview

LiteSpeed for SQL Server

WMI Windows Management Instrumentation

Python

MS T-SQL; ORACLE PL/SQL

CAREER SUMMARY:

Confidential

Database Consultant/Architect/Tableau Developer

Responsibilities:

• Re-Engineer their monthly financial dashboard.
• Moving data from many financial models in excel and other sources to SQL Server.
• MS Excel Data cleansing and transformation using macros (VBA) to prepare migration to SQL Server
• ETL and Data Migration using SSIS & TSQL routines.
• Power Query for fetching SQL server data to excel as feeds for Tableau.
• Use of Tableau to develop dashboards and create forecasting, prescriptive models.
• Document process and train personnel.

Confidential

Database Consultant/Architect/Modeler/Reporting Development

Responsibilities:

• EnterpriseData Modelingon OLTP for Migrated Claim Management System from Previa/Encore to HSP (Health Solutions Plus).
• Report development using Crystal Reports and SSRS.
• SQL Tools developed for reverse engineering report data elements, for no data migration is provided nor ERDs.
• Architect report subscriptions via SSRS/Email, deployment via SQL Jobs/MS Excel. Develop VBA Macros for MS Excel automation and using SQL Query from Excel.
• Analyze consistency of Data Model data types so to enforce the use of UDT (User defined data types).

Confidential

Database Consultant/DBA/Architect/Modeler

Responsibilities:

• EnterpriseData Modelingusing ERWINr 9.5to Reverse/Forwardengineer - EDW Enterprise Data Warehouse DB2 to MS SQL Server Migration.
• Automation of script creation (Bulk), parsing table layout and metadata lookup.
• ETL coding for large Data Marts that will merge into the EDW. Mentoring BI Lead with best deployment process from OLTP to OLAP. (KIMBALL).
• Server Upgrade and data migration from MS SQL (2008/2012) to MS SQL 2014 automated through TSQL.
• (Data/Jobs/Alerts/Assemblies/Operators etc.).Unattended installs through POWERSHELL.
• Folders, Users, Permissions and Shares mirrored on new box.
• Worked with WAA (Web Application Architecture) for implementing best security practices using Windows Authentication of AD (Active Directory) groups as Logins that map to a local database user which is assigned to specific database role(s) for granting access in a tight security environment.
• Transparent Data Encryption (TDE) and Column level encryption.
• File Table/File Stream implementation for reading table layouts as part of the ETL process.
• Debug SSIS migrated packages to new platforms as part of Server Migration/Upgrade.

Confidential

Database Consultant/DBA/Architect/Modeler

Responsibilities:

• EnterpriseData Modelingusing ERWINr 9.5to Reverse/Forwardengineer the core Databases with 950+ tables. Layout ER diagrams PK-FKs.
• Conceptual, Logical & Physical design.
• PTOPerformance tuning & Optimization(Queries, Tables-indexes, Server-settings, Database Stored procedures, Views, Triggers etc.).
• Removal of duplicate and redundant indexes.
• DDL Trigger development for preventing table creation in wrong file groups and creating duplicate indexes.
• MS SQL Server 2012 Always On,DBA - Configure AO - Rewrite Jobs for Always On.
• On call coverage for troubleshooting failed jobs / processes.
• Standardization of user defined data types for highly used columns.
• FTP / SFTP files to/from Customers via SSIS/TSQL wrapped jobs.

Confidential

Database Process & Reporting Consultant

Responsibilities:

• Re-engineer procedures for PTO (Performance Tuning and Optimization) and streamlining maintenance MS SQL Server 2008 .
• Improve performance and redesign of SSRS Reports Microsoft Visual Studio 2012 .
• Automation of MS Excel reports through VBA macros. MS Excel 2013 .
• Recommend and document best practices for DBA effectiveness.

Confidential

Database Consultant/DBA

Responsibilities:

• Enterprise Environment databases running over 35TB size. Cardlytics project.
• Managed over 100 Servers in different lanes. (Development, Staging, QA, Production )
• EMCData Domaindeduplication backup storage/SAN.HADR.
• Server installation/ Table Partition /Server Monitoring /Tuning/ Troubleshooting.
• LOG Shipping/Mirroring/Replication/Clustering.
• Document Run Book server configurations, DB Users, Disk Space, Log ins.
• LiteSpeed and Symantec NetBackup for compressed data backups.

Confidential

Windows server ADMN SQL DBA / Web Development Generalist

Responsibilities:

• PTO (Performance Tuning and Optimization) for speeding data fetch.
• WMI/VBS utilities for accessing local/remote server information.
• Microsoft .Net ASPx /AJAX for maintaining Web Application.
• SQL server tuning/Ad hoc troubleshooting.

Confidential

Senior BI Architect/Consultant

Responsibilities:

• PTO (Performance Tuning and Optimization) for speeding up reports (SSRS).
• Developed C# API to plug in Data Visualization PivotViewer to MS SQL Database.
• Evaluating products such as Tableau, ProClarity and MS Silverlight PIVOTVIEWER for slicing data dynamically for data visualization.
• Designed project plan for Conformed Dimensional Model detailing every iterative step from initial dimension usage matrix, to logical data map, surrogate keys and index strategy.
• SCD Slow changing dimensions (1/2), Snowflake dimensions required.
• ETL streamlining. CUBE deployment SSAS/ MS SQL Server 2008R2 with tables with over 6 billion Rows.
• Improved reporting SSRS (datasets/design). Troubleshoot existing report inventory.
• Detailed step by step documentation of entire process.

Confidential

Senior EDW ETL Database Developer/Administrator/Release Manager

Responsibilities:

• As Enterprise Data Warehouse Extract Transformation & Load engineer, developed a Meta Data based flexible Delta Transfer code for MERGE-ing changes or incremental table data loads and not entire loads.
• Troubleshoot AUTOSYS (Intra Platform ETL & Job Control System) and SSIS packages as part of the EDW (TERADATA/ORACLE/INFORMATICA).
• PTO Performance Tuning and Optimization by hacking EEP (Estimated Execution Plans) index tuning. Improved performance 90% by using proper INCLUDE indexes.
• Fine tune queries by matching data types in predicates.

Confidential

Senior Database Administrator - Application Engineer

Responsibilities:

• DBA PROD 20% and DBA Developer 80%. (MS SQL Server 2005/2008).
• ETL & Data scrubbing (TSQL) corrections for Conversion of Mainframe VSAM files to MS SQL Server.
• Troubleshoot server loads and performance monitoring, and query/index tuning.
• Multiple file groups for performance gains in operational administration.

Confidential

Senior Database Developer/Administrator

Responsibilities:

• Work with QA, DBA, and systems support personnel in automating successful code to production.
• DTS migration to SSIS. Code maintenance on ETL for operational Data Warehouse.
• Develop T-SQL SPROCS to meet business/reporting SSRS requirements.
• Data warehouse improvement redesign of DTS processes from 1 or 2 breaks per month to zero.
• Very fast paced code development and ETL restructure for PDS (Predictive Dialer System).
• Successful deployment of Pharmacy Claims project handling over 80 databases, some distributed over remote servers. CLR (VB/C# .Net) assemblies.
• Performance Query/Index optimization.
• Maintenance Cubes/Reporting SSRS and documentation of operational Data Warehouse ETL.
• High Availability (Clustering/Mirroring), Disaster Recovery (Log Shipping/Replication).
• Provide on call 24/7 DBA support to production systems.
• Integrity Checks, Short Disk Space, Merge replication, CL, DMV, DMF, CTE.
• Query improvement through CTE, PIVOT/UNPIVOT, RANK(),DENSE RANK(), NTILE().

Confidential

Senior EDW ETL Database Developer/Administrator/Release Manager

Responsibilities:

• DBA Production 50% and DBA Developer 50%. (MS SQL Server 2005).
• Monitor/tune queries, slowdowns, Deadlocks using T-SQL and 3rd party tools SPOTLIGHT/IDERA .
• PTO Performance and index tuning.
• Multiple file groups Database redesign for improvement on operational performance.
• Re-engineering of their billing process to reduce processing time from 25 + hours to just minutes and recover a total of over $17000 year for late arriving revenues.
• Variable configurable SSIS wrapper package to flexibly run this script.
• CLR (VB/C# .Net) assemblies for extending functionality in SQL2005.
• Log shipping for stand by DBs on warm servers - Transactional replication implemented for a heavy transaction (OLTP) environment with large tables with over 950 million rows.
• XML extract records generated with .NET C#. Wrapper SSIS for automated extraction.
• Automation of Reports/Excel books using VBA and COM.

Confidential

Senior Front end Developer

Responsibilities:

• Health related application maintenance in VB.net/MS SQL Server.
• Code extension (inheritance/interfaces)/Crystal Reports reporting tools.
• T SQL scripts and stored procedures in SQL Server, Data Dictionary and schemas maintenance.
• Coding in a shared environment using Borland's Star Team.

Confidential

Senior Front end Developer

Responsibilities:

• Bus architecture Data Warehouse Data modeling. Star Schema - Kimball.
• Views improved with TVF (table value functions) for improving data access to inter database entities of over 3 Terabytes. Performance and query/index tuning.
• Project manager coordinating two additional IT professionals in SQL scripting and modeling (T-SQL) and documentation areas (VISIO).
• Troubleshoot Oracle PL-SQL procedures.

Confidential

Senior Front end Developer

Responsibilities:

• Trading System Portfolio/Money Market conversion from MS Access to MS SQL Server.
• Data modeling (VISIO) of more than 17 independent MS Access databases to a unified MS SQL server database.
• All business functionality in Access’ VBA script translated to DTS Active X and T-SQL.
• DTS/ETL developed for replacing VBSCRIPT loading routines from various sources (CSV, MS Excel, SDF).
• Crystal reports front end for report generation.

Confidential

Senior Developer - Migration specialist

Responsibilities:

• Conversion from Visual FoxPro to Client Server SQL-PASS-THRU with MS SQL Server as back end.

Confidential

Senior Developer - Migration specialist

Responsibilities:

• Maintenance on legacy application by translating business needs into code.