SUMMARY:

• A database and business intelligence development professional
• Specializations include stored procedure and query development, ETL design and 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

SKILL:

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

DBMS: Confidential 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, Confidential TFS 2012/2016, SSRS 2008/2014, Ctrl - M Workload Scheduler, Autosys Workload Scheduler, Erwin, Model-Mart, SQL Backtrack, Tortoise SVN

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

PROFESSIONAL EXPERIENCE:

Confidential

Sybase to 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 to Sybase Migration Assistant tool for assessment as well as to migrate database objects
• Used BIML to generate SSIS packages to migrate data for small to medium size databases and tables and used SQL Agent to automate this migration
• For larger tables designed and developer Sybase views for use with bcp to migrate the data
• Conducted performance assessment in test environment to identify and remediate batch and reporting performance problems
• Modified batch scripts written in shell and Perl/DBI
• 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
• Replaced Sybase replication with series of triggers, shadow tables and SSIS packages

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

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 maintaining MPT Data Mart
• Performed proof of concept of Tivoli Workload Scheduler as replacement for SQL Server Agent
• Designed and developed validation process for several data marts post load to identify issues during load
• Confidential TFS 2016 was used for source control and software deployment

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

Confidential

Database Lead/ETL Developer

Responsibilities:

• Sr. SQL Server database developer assigned to GADS data warehouse utilizing Kimball methodology and star schema design
• Responsible for overall performance and health of database server. Worked closely with support groups to identify and resolve performance and production problems
• Primary developer assigned to hardware and software upgrade project. Upgrading to SQL Server 2014, SSIS 2014 and Windows Server 2012
• Primary ETL analyst/developer assigned to Billing and Remittance Reporting project which used SSIS to transfer data from legacy DB2 database to SQL Server on a weekly basis, keeping these databases in sync. Designed and developed metadata based package generator using BIML to generate 350+ packages to move 450GB of data
• Primary 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. Data was extracted from many disparate sources including Oracle, DB2, Excel, Access and flat file.
• Developed and deployed multiple reports for Sales Reporting using SSRS 2008 including Table, Matrix, Drill Down, Parameterized, Cascaded and Sub-reports
• Extracted data from internal data warehouse system to SSRS for reports within the organization. Created ad-hoc reports
• Modified stored procedures and formulated basic coding and scripting to be utilized for reports within the organization
• ETL analyst/developer assigned to Customer Centricity project which 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.
• Primary ETL analyst/developer assigned to Unified Information System performance and re-engineering project. Run time was reduced by orders of magnitude through increased parallelism and reduced data movement between database and packages. This was a very large database 10TB with largest table 3TB in size. This project also included partitioning several of the largest tables which ranged from 1TB to 3TB in size. Provided analysis and guidance in devising partitioning key and worked closely with administrators to design and implement partitioning scheme and data distribution. I reworked a number of packages increasing parallelism and other inefficiencies in the packages.
• Primary ETL analyst/developer assigned to Billing and Remittance Outreach project which used analytic modelling to drive policy renewals. Developed a number of packages which accepted flat file input from SSPS models and loaded to tables to be used by Policy Retention Outreach team. Transferred data from SQL Server using combination of SSIS, Informatica, Shell and Perl scripts.
• Primary 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
• Implemented SQL Server agent tasks 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:

• SQL Server architect and developer assigned to short term performance and tuning project to improve over night batch performance for Tier-1 broker desktop application due to frequent missed SLAs.
• 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 Database Developer

Responsibilities:

• Member of Azure community our purpose was to investigate and test the product and share information with other internal consultants. Conducted performance tests focused on IO speed using various disk configurations
• SQL Server core lead for large financial services client assisting with 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. Implemented changes to SSIS packages to increase parallelism, rewrote and modified indexes to improved stored procedure performance. Reviewed configuration and performance of SSIS and SQL Server hosts including memory, CPU and SAN utilization
• SQL Server Core Consultant specializations include performance and tuning, architectural reviews, database design, high availability and disaster recovery, replication, SQL Server Integration Services
• Conducted proof of concept 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 proof of concept for large multinational provider of data storage, information security, virtualization, analytics and cloud computing. Configured, installed and created several customizations for Systems Center Operations Manager. POC involved SCOM for SQL Server using SQL Server Management Pack.
• 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. Helped client develop an upgrade and migration plan to this new environment.
• Performed database and architectural review of Tier-1 application for a large financial, property and consumer information, analytics and services company. Identified performance bottlenecks and made suggestions for their remediation
• Implemented high availability proof of concept based solution using SQL Server Availability Group for large hospitalist and inpatient care management services provider
• Designed and developed a number of stored procedures for Meaningful Use data warehouse for large hospital chain. Developed SSIS packages, which extracted data from multiple sources into SQL Server database.

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 short term project which was tasked with review and assessment of Tier 1 application and database
• Performed benchmark which compared performance of Sybase v12.5.4 and Sybase 15.5 and incremental configuration changes as precursor to Sybase upgrade
• Optimized poorly tuned stored procedures, improvement ranged in tens of percent to orders of magnitude against very large database - more than 1 TB
• Conducted database design review and made suggestions for performance improvement
• Reviewed current database server and replication server configurations and made suggestions for performance improvements
• Created update statistics script for very large database cut time required to perform update statistics by average of 1-2 hours
• Conducted interviews with key application and support personnel

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 assigned to middle office brokerage application
• Database subject matter expert, mentored other developers, trained off shore personnel
• Responsible for upgrade to Sybase 15.3 from 12.5.4 conducting pre and post upgrade performance and functionality testing making changes where required
• Developed stored procedures and queries to support new functionality, repair defects
• Made data model enhancements to support new functionality or improve performance for major asset classes as equities, listed options
• Migrated application from legacy client database rewriting a large number of stored procedures
• Implemented bi-temporal data model changes to key history tables replacing more expensive versioning reducing space utilization
• Optimized most frequently executed and poorly tuned stored procedures, improvement ranged in tens of percent to orders of magnitude against very large database
• Developed and responsible for batch processes running in CA-Unicenter/Autosys and using Perl and Shell
• Developed ETL stored procedures which maintained denormalized versions of key application database structures, automated this process using CA-Unicenter/Autosys
• Migrated application from legacy client database rewriting a large number of stored procedures
• Devised and implemented permissions scheme which was SOX compliant
• Supported production and UAT releases

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
• Provide on call 24 by 7 production support
• Identify and remediate poorly tuned stored procedures and queries
• Developed scripts for database maintenance including backup and restore, database consistency checking and index recreation.
• Developed procedures and standards for installation and configuration of servers on new Sun hardware.
• Assisted development groups with database design
• Responsible for upgrades to Sybase software.
• Troubleshoot ASE and Replication Server problems
• Optimize poorly tuned queries and stored procedures

DB2 Database Developer/Development DBA

Confidential

Responsibilities:

• 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

Sybase Database Developer/Administrator

Confidential

Responsibilities:

• Primary Sybase developer/administrator assigned to Common Services group
• Responsible for stored procedure and query performance and tuning
• Responsible for stored procedure and query development
• Developed scripts for database maintenance, data extraction
• Developed batch processes using shell scripts, C and DB-Lib, ftp and Autosys
• Mentor and assist other developers

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

Confidential

SQL Server Database Administrator/Developer

Responsibilities:

• Migrated SRMS and SCAM, Sybase 11.9.2 based applications to Confidential SQL Server 2000 environment
• Primary DBA assigned to SRMS (a workflow system supporting an internal service desk) and SCAM (an outage tracking system which maintains the status of outages and notifies interested parties)
• Ported several cron based tasks written in Perl and Shell to MS SQL DTS tasks using various components including Active X scripts.
• Developed maintenance plans for the above applications

Sybase/SQL Server Database Administrator/Developer

Confidential

Responsibilities:

• Primary DBA assigned to Performance measurement group
• Responsible for maintaining star schema data model for Performance data mart
• Developed many scripts, which perform such routine tasks as database backups and consistency checks and performance and resource utilization monitoring.
• Responsible for maintenance and troubleshooting of various production-related database and replication related problems including conflict resolution, open transactions and phantom updates.
• Responsible for troubleshooting, development and debugging of stored procedures and queries for multiple applications including data mart as well as transactional type systems.
• Assist developers with their efforts in development, debugging and performance enhancements.
• Developed DR procedure, which restored central environment including database servers and replication servers at a replicate site. This procedure restored all user databases and the AIX environment from tape.
• Developed procedure to recover corrupt user databases, which were being replicated in bi-directional Replication Server configuration.
• Implemented automated task, which recorded query plans of active threads within ASE. These plans were used to identify poorly tuned queries and stored procedures.
• Assisted in migration of core applications and their databases to web based Oracle environment.

Environment: AIX, Sybase ASE 11.9.2 and Replication Server 11.5.

Confidential

SQL Server Developer/Development DBA

Responsibilities:

• Primary development DBA assigned to Performance Data Services application.
• Responsible for performance and tuning and enhancements of the Performance Data Services application’s queries and stored procedures
• Performed baseline benchmark to determine maximum user load capabilities and bottlenecks.
• Enhanced performance of many stored procedures through more efficient SQL coding practices as well structural modifications to the database.
• Implemented configuration changes to Sybase server to improve performance of PDS.
• Implemented resource limits to minimize impact of PDS on existing server used to support Moodys.com web site.
• Assisted middleware and GUI developers
• Conducted proof of concept using Indexed Views on Confidential SQL Server 2000

Confidential

Sybase Database Administrator/Developer

Responsibilities:

• Designed and implemented daily and weekly maintenance tasks and performance and utilization monitoring for Adaptive and Replication Server.
• Developed performance monitoring utilities and reports used to recommend code, configuration and hardware modifications.
• Configured and implemented replication system for transfer of data from mainframe to client server environment including replication definitions, function strings and error strings.
• Developed a multi-threaded direct server to server data transfer application using Sybase’s parallel BCP library to migrate a data warehouse to new hardware
• Assisted and mentored developers with stored procedure and query development, trouble shooting, performance and debugging

Environment: Sybase ASE 11.5, Replication Server 11.5 and AIX, Oracle 8i