SUMMARY

• A database and business intelligence development professional
• Specializations include ETL design and development, stored procedure and query development, report development, performance and tuning, database design and architecture, benchmarking and capacity planning
• Experienced in Data Warehouse concepts including dimension tables, fact tables and slowly changing dimensions
• Proficient with a variety of hardware platforms, operating systems and programming languages

TECHNICAL SKILLS

Operating Systems: Windows 10/8/7, Windows Server 2012/2008, RHEL, Ubuntu, Microsoft Azure

DBMS: Microsoft SQL Server 2016/2014/2012/2008/2005 , Sybase Adaptive Server 15.x, DB2 9.x, Oracle, Netezza, Hadoop, Teradata 14

Software: SQL Server Integration Services (SSIS) 2005/2008/2012/2014/2016 , Maestro/Tivoli Workload Scheduler, Microsoft TFS 2012/2016, SSRS 2008/2014, Ctrl - M Workload Scheduler, Autosys Workload Scheduler, Erwin, Model-Mart, SQL Backtrack, Tortoise SVN, Jira

Languages: SQL, Shell, AWK, C#, Python, Perl, Java, C++, VB, HTML5

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Migration Lead

Responsibilities:

• Sybase to SQL Server migration lead responsible for migration assessment, developing migration plan of objects and data and leading the effort
• Used SQL Server Sybase Migration Assistant tool for assessment as well as to migrate database objects
• Performed database analysis determining optimal filegroup configuration, made hardware recommendations
• Modified and migrated very large number of views and stored procedures (more than 500) handling issues such as ANSI compliance, replacement of Sybase proprietary language constructs and functions
• Used BIML to generate SSIS packages to migrate data for small to medium size databases and tables, used SQL Agent to automate package execution
• For larger tables designed and developed Sybase views for use with bcp to migrate the data, used SSIS to run many bcp tasks in parallel
• Conducted performance assessment in test environment to identify and remediate batch and reporting performance problems
• Modified legacy batch scripts written in shell and Perl/DBI
• Implemented Column Store Indexes on large tables in financial data mart
• Replaced Sybase replication with series of triggers, shadow tables and SSIS packages

Environment: Windows Server 2012 R2 Enterprise, SQL Server 2016/2017, SSIS 2016, Windows 10, TWS/Maestro

Confidential

Sr. SQL Server/ETL Developer

Responsibilities:

• Sr. SQL Server database developer assigned to Enterprise Data Warehouse which uses traditional Kimball DW methodology
• Designed and developed Market Planning Tool (MPT) data mart and ETL for loading the data mart
• Performed proof of concept of Tivoli Workload Scheduler as replacement for SQL Server Agent
• Developed validation process for several data marts post load to identify issues during load using SSIS
• Microsoft TFS 2016 was used for source control and deployment using project deployment model

Environment: Windows Server 2012 R2 Enterprise, SQL Server 2016, SSIS 2016, Windows 10, TWS/Maestro, TFS 2016

Confidential

Database Lead/ETL Developer

Responsibilities:

• Lead SQL Server database developer for GADS data warehouse which was more than 30TB in size including eligibility data comprising more than 12TB.
• Responsible for overall performance and health of database server. Worked closely with support groups to identify and resolve performance and production problems
• Development lead assigned to hardware and software upgrade project, upgrading to SQL Server 2014, SSIS 2014 and Windows Server 2012 from Windows Server 2008 R2/SQL Server 2008 R2/SSIS 2008
• Implemented Column Store indexes on several tables in Eligibility database which was greater than 10TB
• Lead ETL analyst/developer assigned to Billing and Remittance Outreach project (Policy Retention) which used analytic modelling to drive policy renewals. Used SSIS to consolidate data from SSPS models. Used SSIS to enrich data from global reference data stored in Hadoop.
• Lead ETL analyst/developer assigned to Billing and Remittance Reporting. SSIS used to transfer data from legacy DB2 database to SQL Server. Developed metadata driven package generator using BIML to generate 350+ packages to move 600GB of data on weekly basis
• Assisted Qlikview team performance tuning their queries to extract data from the Billing and Remittance database to maintain Qlikview repository
• Lead ETL/Database developer assigned to Sales Reporting project responsible for development of SSIS packages, stored procedures and queries. Worked closely with business users and analysts to ensure business requirements were met. Extracted data from disparate sources Oracle, DB2, Excel and Access
• Developed and deployed multiple reports for Sales Reporting using SSRS 2008 including Table, Matrix, Drill Down, Parameterized, Cascaded and Sub-reports
• Lead ETL analyst/developer assigned to Customer Centricity project utilized metadata (survey profiles) (metadata) to load data from many survey providers into data mart. Metadata was organized in combination of vertical and horizontal structures. Developed a number of packages which received incoming survey files from vendors via FTP and loaded these to CC data mart.
• Lead ETL analyst/developer assigned to Unified Information System performance and re-engineering project. Run time was reduced by orders of magnitude through increased parallelism. This was a very large database 10TB+, largest table was 3TB in size. Performed analysis and designed partitions for the largest tables, worked closely with administrators to on its implementation.
• Lead ETL analyst/developer assigned to Broker Opportunity Project which helped brokers identify new business opportunities
• Monitor performance using DMVs and Perf-mon. Identified SAN as cause of slowness causing frequent missed SLAs. Worked closely with SAN administrators to relocate databases within the SAN to improve performance
• Tuned existing stored procedures and queries. Mentor and assist other developers

Environment: Windows Server 2008/2012 R2 Enterprise, SQL Server 2008 R2, 2012, 2014, SSIS 2008/2014, SSRS 2008/2014, Windows 7, TWS/Maestro, Informatica 9.6.1, Hadoop, Hive, Linux, Perl

Confidential

SQL Server Database Developer/Administrator

Responsibilities:

• Split role as database developer and administrator
• Designed and developed new stored procedures and queries. Reviewed and modified stored procedures, queries and triggers made changes to improve performance
• Designed and implemented SSIS packages loading performance data mart. TFS was used for source control and SSIS project deployment
• Implemented automated tasks using Active Batch scheduler to perform database maintenance, database restores, point in time database restores, performance, utilization and health monitoring
• Implemented database mirroring for all production servers
• Implemented table driven automated data pruning task
• Provided 24 by 7 production support
• Perform DR review and testing

Environment: Windows Server 2008/2012 R2 Enterprise, SSIS 2008/2012, SSRS 2008, Windows 7, Spotlight. Active Batch Job Scheduler, Lite Speed, TFS 2012

Confidential

SQL Server Database Architect/Developer

Responsibilities:

• Lead SQL Server database architect assigned to short term performance and tuning project
• Reviewed stored procedures, queries and triggers making changes improving performance by orders of magnitude in some cases.
• Reviewed SSIS packages and improved loading performance improvement through increased parallelism, bulk loading and replaced standard drivers with drivers from vendors.
• Reviewed table and index design and overall architecture enhanced and added indexes where required.
• Performance changes have reduced run time of overnight batch processes by over 2 hours

Environment: Windows Server 2003 Enterprise, SQL Server 2008 R2, SSIS 2008, Teradata v14, Windows 7

Confidential

SQL Server Database Architect/Developer

Responsibilities:

• Database lead for short term assessment and review of Tier-1 application. Reviewed database design and make suggestions for improvement
• Performance tuning of most heavily used and most resource intensive queries, stored procedures and triggers
• Identify performance bottlenecks and make suggestions for their remediation
• Conducted hardware review and SQL Server configuration, maintenance and monitoring tasks
• Review hardware configuration, utilization and performance
• Conducted interviews with key application development and support personnel

Environment: Windows Server 2003 Enterprise SP2, Windows Clustering 2003, SQL Server 2008 R2 SP2 failover clustering and database mirroring

Confidential

SQL Server Core Consultant

Responsibilities:

• SQL Server core consultant specializing in SQL Server BI stack, database design, stored procedure design and development and SSIS package design, development and deployment
• Member of Azure community investigated and tested the product for internal collaboration shared
• SQL Server lead for large financial services client working on customized Dynamics CRM implementation. Developed stored procedures and queries, SQL Server and stored procedure/query performance and tuning. Made recommendations for database design improvements. Conducted full text search proof of concept
• Redesigned and rewrote Partnership Tax System for large multinational professional services firm to improve its performance based on SSIS. Performance tuned stored procedures and SSIS packages
• Conducted POC for leading provider of property, mortgage and consumer information and analytics using Windows Cluster, SQL Server Failover Cluster, SQL Server Availability Group and SQL Server Replication
• Conducted POC using SCOM for large multinational provider of data storage, information security, virtualization, analytics and cloud computing.
• Designed and implemented high availability solution for mission critical databases using Windows Server Failover Cluster with shared disk and SQL Server Failover Clustering for large managed care company.
• Performed database, architectural and performance review of Tier-1 application of large financial, property and consumer information, analytics and services company
• Implemented Always On POC for large hospitalist, inpatient care management services provider
• Designed and developed several stored procedures and SSIS Packages for Meaningful Use data warehouse for large hospital chain. Solution consolidated data from a number of satellite hospitals and clinics

Environment: Windows Server 2012 with clustering, SQL Server 2008/2008 R2/2012/2014, SSIS 2008/2012, Windows 8.1

Confidential

Database Architect/Developer/Database Administrator

Responsibilities:

• Technical lead for Sybase upgrade for Tier-1 application
• Led small team of offshore resources which was tasked with pre-upgrade performance and functionality testing and code fixes
• Remediated any poorly performing queries and stored procedures in preparation for upgrade
• Worked with DBA group to build new Sybase servers for development, UAT and production environments

Environment: RHEL 2.6, Sybase ASE 12.5.4/ASE 15.5, EMC SAN, Shell and Perl

Confidential

Database Architect/Developer/Database Administrator

Responsibilities:

• Database lead for database and architecture review and assessment of Tier 1 application
• Conducted database design review and made suggestions for performance improvement
• Performed benchmark comparing Sybase v12.5.4 performance to Sybase 15.5, employed methodical incremental configuration changes to determine optimal configuration
• Optimized poorly tuned stored procedures, improvement ranged in tens of percent to orders of magnitude against very large database - more than 1 TB
• Enhanced routine database maintenance for very large database reducing run time and enhancing overall database performance

Environment: RHEL 2.6, Sybase ASE 12.5.4/ASE 15.5, Sybase Replication Server 12.6 using EMC SAN Technology, Shell and Perl

Confidential

Database Developer/Architect/Administrator

Responsibilities:

• Primary development DBA and SME assigned to middle office brokerage application (Topaz)
• Responsible for Sybase 12.5.4 to 15.3 upgrade performed pre and post upgrade performance and functionality testing implementing necessary changes
• Developed stored procedures and queries to support new functionality, repair defects, addressed performance problems
• Responsible for data model enhancements and maintenance
• Migrated application to new client reference data model rewriting a large number of stored procedures
• Implemented bi-temporal data model changes replacing expensive versioning reducing space utilization
• Developed and maintained daily batch processes running in CA-Unicenter/Autosys, using Perl and Shell
• Developed ETL stored procedures which maintained denormalized versions of key application database structures, automated this process using CA-Unicenter/Autosys

Environment: Sun Solaris 8, Sybase ASE 12.5.4/ASE 15.0.3, Sybase Replication Server 12.6 using EMC SAN Technology, Windows 7/2008 and SQL Server 2008. Scripts were written in Shell and Perl.

Confidential

Database Developer/Administrator

Responsibilities:

• Data modeler and developer assigned to the Regulatory-CSE Data Warehouse
• Responsible for enhancements to data model
• Optimized poorly tuned queries and stored procedures
• Developed stored procedures for data movement and reporting
• Rewrote key data warehouse loading procedures to improve performance and implement data range versus data point maintenance
• Worked closely with DBA group on server configurations, installs and maintenance tasks
• Mentor and assist other developers
• Responsible for QA and production releases.
• Provide production support
• Implemented index rebuild and update statistics weekly maintenance jobs

Environment: Linux and Sybase ASE 12.5.3 using EMC SAN Technology. Scripts were written in Shell and Perl.

Confidential

Database Administrator/Developer

Responsibilities:

• Senior database administrator assigned to production support group
• Assisted developers with troubleshooting, debugging, SQL and stored procedure development and performance and tuning
• Developed scripts for database maintenance including backup and restore, database consistency checking and index recreation.
• Primary development DBA assigned to Flow of Funds Data Mart which used star schema data model
• Responsible for stored procedure and query performance and tuning
• Responsible for development and enhancement of report queries
• Developed ETL scripts written in Unix shell

Environment: Sun Solaris 2.8, Sybase ASE 12.0.8, UDB 7.2.9, Sybase Replication Server 12.5 and EMC SAN Technology, Shell and Perl, batch programs were written in DB-Lib and C