SUMMARY:

• Experienced Information Systems professional with over 20 years of experience with demonstrated expertise working in a wide variety of industries such as Financial, Health Care, Insurance, Government etc.
• Skill set includes but not limited to Business Intelligence, Data Extraction, Database Analysis, Design, Development, Data Architecture, Data Modeling, Data Migration, Database Administration, Integration and Implementation
• In depth knowledge and experience with all versions of Microsoft SQL Server ( ), including but not limited to architecture, design, development and administration experience
• Experienced with migrating to and using Azure SQL Databases.
• Expert at automation using Powershell
• In depth knowledge about advanced SQL technologies such as Encryption, Compression, Masking, Partitioning etc.
• Experienced with using Integration Services (SSIS) and Reporting (SSRS) for ETL projects
• Expert at managing large enterprise wide systems and migrations for various editions and versions of MS SQL Server
• Expert at Agile Software Development methodologies and practices

TECHNICAL SKILLS:

Database expertise includes: Microsoft SQL Server 2000, 2005, 2008 and 2008 R2, 2012, 2014, 2016 (architecture, design, development and administration), T - SQL, Business Intelligence (SSRS, SSIS, SSAS)

Web Technologies includes: Active Server Pages, JavaScript, VB Script and IIS

Tools: includes but not limited to: ER Studio, ER Repository, ERWIN, MS Visio, Crystal Reports, Tableau, SpotLight, SQL Diagnostic Manager, LiteSpeed, Toad, WISE, Jira, Confluence, SVN, GIT.

PROFESSIONAL EXPERIENCE:

Confidential, Greater New York

Migration DBA

Responsibilities:

• Part of the Migration team which is responsible for migrating over 600 servers that are used by investment professionals while working in small team emphasizing agile and mission driven work
• Executing database migrations from MS SQL 2008/2005 OS Win 2003 to MS SQL 2014 OS Win 2013
• Planning for capacity, capability and growth while balancing speed of execution with maintainability
• Improving the quality and consistency of service delivered through automation and process improvement
• Also started to design and implement IaaS and PaaS services used by technologists and investment professionals

Confidential, Charlestown, MA

Senior SQL Architect/Developer/DBA

Responsibilities:

• Working as Lead Database Developer for PCU (Provider Compliance Unit) which is an application that is designed to identify improperly paid claims as well as suspected provider fraud and abuse in the MassHealth system. Architected, developed and implemented the database along with the various processes from scratch.
• Worked on designing and developing high performance BI solutions by extracting data from a number of different sources (Oracle, Flat files etc.) using Integration Services (SSIS).
• Implemented the process to capture digital signatures for letters that the system generated.
• Worked on designing a number of Reports including dashboards and sub-reports for Management using Tableau.
• Acting as a go-to database resource and provide technical leadership for many projects within the group.
• Diagnosed and addressed multiple database performance issues for other projects within the group.
• Define, document and govern technology standards in a complex SQL Server environment.
• Migrated the application database from SQL 2012 to SQL 2014 after doing thorough analysis for the upgrade. Also provided consultation for the migration to other teams within the group.
• Maintaining the various database environments as well as ensure that the database changes are promoted without error through the development, test and production environments.

Granite, Quincy, MA

Senior SQL Developer/DBA

Responsibilities:

• Developed and implemented a role based Security application, which is used by all the applications of the company. The framework relied on the policies and the access that can be granted to all the employees. Stored procedures and functions were developed to grant all possible combinations of access across applications.
• Worked on the backend for Order Management application, which automates the PON creation process. This included understanding the schema, populating the data along with the rules for the carriers. Was involved in the code review of some of the salient processes within the system.
• Supported databases for a number of other applications such as CKE enhancements, GRT process.
• Designed and developed SSIS packages to consolidate data for a number of applications.

Confidential, San Francisco, CA

Senior SQL Developer/DBA

Responsibilities:

• As a member of the database team, some responsibilities included code reviews, analyzing and making recommendations for database performance improvements, query tuning, implementing appropriate indexes, developing and maintaining naming, deployment and implementation standards, developing and maintaining physical and logical models of current and future systems using ERWIN/VISIO.
• Administered and supported database servers.
• Researched and implemented new database strategies, platforms, tools and solutions.
• Monitored and supported the production database server for any potential performance bottlenecks and resolved issues in a timely manner so as not to affect the website.

Confidential, Novato, CA

SQL 2008 ETL Migration Lead

Responsibilities:

• Led ETL migration project, which involved converting around two hundred legacy DTS packages to SSIS. All these packages formed a very complex system since some of these were interdependent upon each other and had to be executed in a sequence, while others could be run in parallel.
• Careful planning was involved where the dependencies were laid out and a handful of master packages were designed. These master packages had child packages within, some of which ran in parallel and others in a defined sequence. The parallel execution of multiple components in SSIS enabled to achieve performance gains.

Confidential, San Francisco, CA

Senior SQL DBA/Developer

Responsibilities:

• As part of the DBA team, responsible for supporting and maintaining around 60 Servers, which included Database, Reporting Services, Integration Services and Analysis Services Servers.
• This included designing the Disaster Recovery procedures and processes for the salient production systems using Log Shipping, Replication and Mirroring, designing and creating databases, managing security, backups and restores, performance tuning, capacity planning as well as proactively managing the database and server alerts. Also responsible for reviewing stored procedures and recommending best practices to the development group.
• Assisted with the migration efforts for SQL 2000 and Oracle 10g to SQL 2008 which involved working on planning, testing, executing, controlling and implementing the Migration Project within tight timelines and resources.
• Tasked with the conversion of Sagent Plans (ETL) to SSIS. This involved studying the existing processes and planning, designing and implementing the processes in SSIS. Also worked on Reports using SSRS.
• Initiated the data modeling efforts for the Data Management team where the models were generated for the existing as well as the new databases using ER Studio.

Confidential, San Francisco, CA

Senior SQL DBA/Architect/Developer

Responsibilities:

• Led the SQL 2008 and SQL 2005 Migration projects for various applications. This involved detailed key planning and deployment considerations for upgrading as well as sufficient testing particularly for ETL components. Different components of SQL Server were analyzed for the upgrade, these being security, databases, T-SQL code, metadata, OLAP, DTS and Reporting Services. Careful planning was done for the upgrade for each of these in a phased manner amidst effective collaboration with the Business Users, Management and Systems Groups.
• Other DBA responsibilities included managing the Production, Development, UAT and QA Servers along with Process Control and Change Management across all environments, capacity planning, implementing security, defining database standards as well as designing and implementing disaster recovery procedures as well as making changes to the existing configurations in order to achieve optimal response Also maintained and managed SSAS, SSRS and SSIS Servers.
• Responsibilities also included maintaining and improving Integrated Enterprise System Application Model by creating and maintaining Data Models, Data Dictionaries, identifying data consumers as well as defining the data maintenance processes. Master Data was identified and extracted from a variety of sources such as Oracle, DB2, MS Access and Flat Files and maintained at one central location.