Data Services Consulting

Data Services Consulting Data Services Consulting Data Services Consulting

Data Services Consulting

Data Services Consulting Data Services Consulting Data Services Consulting
  • Home
  • Past Projects
  • More
    • Home
    • Past Projects

  • Home
  • Past Projects

Welcome

I have worked as a full-time regular employee, full-time contractor employee, full-time consultant and part-time consultant. I have been a manager of a team of DBA's and developers, a DBA and as a Developer. I have worked in various types of Industries like Banks. Insurance, Retail, HealthCare etc. I worked in several time zones across teams around the world. I leveraged all these  experiences  to be a consultant and offer my services.


I primarily worked in SQL Server database management systems and had heavy hands-on exposure to Oracle, MySQL, DB2 as well. I did a lot of AWS, Azure implementation. 

I chose Microsoft Fabric as the main Cloud Technology to work on now and going forward. I use PySpark a lot and a little R. I have working knowledge of Apache Spark in Ubuntu. I am in training for AI and ML and will become proficient in it shortly.


I have a BTech Engineering degree from one of the best universities in the world, I hold diplomas in Computer Applications, in RDBMS and in Java.

PROJECTS


Rock Hopper TECH, Atlanta, Georgia, SENIOR Database Consultant

Jan 2025 till date

Requirements and Role

Maintaining RockHopper's SQL Servers in Cloud.

Working for the RockHopper's Clients as needed.

Working as a contractor.  

Work Done

Evaluate and Implement Microsoft Fabric.

Migrated Databases, Scripts, SSIS, jobs to One Lake using pipelines, PySpark etc.. Setup Medallion Architecture.

Documentation, Training.

On Call Support 24/7/365.


Bank of America, Atlanta, Georgia, SENIOR Database Consultant

May 2023 till Dec 2024

Requirements and Role

IBM Integrated Analytics System DB2 SailFish performed poorly and needed to be migrated to SQL Server.

Worked as a contractor. 

Project completed successfully, 

Work Done

Designed and Implemented, Project to migrate\upgrade\consolidate IBM Integrated Analytics System DB2 SailFish to SQL Servers.

Worked with various Teams at various levels and migrated 7 complete applications from DB2 to SQL Server.

Implemented Trino Views and Feeds to SQL Server using Autosys to schedule them.

Converted complex stored procs, views, triggers from DB2 to SQL Server. Used Jira and CI CD to deploy them.

Did Query and Index Tuning, converted complex views to use CTE.

Trained Juniors.


Rock Hopper TECH, Atlanta, Georgia, SENIOR DATABASE CONSULTANT

Nov 2017 till May 2023

Requirements and Role

Migrate, Upgrade and Consolidate all SQL Servers to RackSpace for AON Everest client.

Evaluate and Migrate RockHopper's On-Prem SQL Servers to Cloud.

Provide DBA support for Corporate Payroll Services.

Provide DBA support for Fiber Instrument Sales Inc.

Worked as a contractor. 

Project completed successfully, 

Work Done

Designed and Implemented, Project to migrate\upgrade\consolidate SQL Servers for Aon Data Center to RackSpace Data Center. 

Built DR used SAN Replication Data Mirroring and Log Shipping.

Designed and Implemented SOX, wrote scripts to sync users, application security from Prod to Dev, QA, UAT, Training, Sandbox.

Evaluated Cloud solutions(AWS and Azure Cloud. S3, EC2, Data Lakes, Redshift) and help migrate RockHopper On-Prem SQL Servers to AWS cloud.

Conifigured and tuned RockHopper's Server at Windows and SQL Server level. 

SQL Error Analysis and Fixes. Modified existing User Jobs to refresh QA. Troubleshooted Legacy MS Access issues for Fiber.


WestRock, Atlanta, Georgia, Senior Database Architect

Apr 2012 – Oct 2017

Requirements and Role

Migrate all of On-Prem SQL Servers to VMWare in 2 Data Centers (Atlanta and St Louis for DR).

Worked as a full-time employee.

Project completed successfully, Got better offer.


Work Done

Designed Virtualization and Upgrade Process of Legacy SQL Servers to VMWare Datacenter.

Worked with Business Heads, Mill Managers, IT, Developers, Vendors to coordinate virtualization.

Virtualized 30+ of the biggest and mission critical SQL Servers to VM Ware.

Built 50+ SQL Servers (2016,2014,2012,2008). Rebuilt12+ SQL Servers (2005,2000) during migration with DR. Tested RPO/RTO.

Scheduled jobs in Control-M, SQL Agent, Windows Scheduler. Optimized SSAS cubes and SSIS packages. Wrote BAU reports.

Tuned complex stored procs, views, functions UDF, Cursors, Embedded Query, Dynamic SQL, CTE and triggers. Index stats and Tuning,

Introduced CDC. Fixed security for SOX compliance. Removed Vulnerabilities.

Implemented SCOM for IT. 

Introduced Database Compression and Compressed 80% of all large databases in the enterprise.

Rebuilt the On-Call Email Server and set the standards for folders and email rules. 

Did the mission critical AX Database optimization.

Mentored Junior DBAs, offshore DBAs. 


AON BENFIELD, Atlanta, Georgia, DBA

Mar 2011 –Mar 2012

Requirements and Role

Migrate Oracle databases to SQL Server, DBA for release.

Worked as a contractor.

Project completed successfully, 

Budget cut was notified months ahead.

Work Done

Interacted with Executives, Managers, Architects, Functional Leads across platforms and countries. 

Designed and Implemented, Prod to Dev, QA, UAT, Training, Sandbox. Did Standard DBA task to plan, set, create, maintain, tune, size, backup, recover databases 

Wrote Materialized Views in Oracle with requirements fr

Planned flagship product backend conversion optimization from Oracle to SQL Server using SSMA, tuned rewrote PL SQL code. 

Tuned critical reports in SSRS, 

Created Power Pivot reports.


Home Depot, Atlanta, Georgia, DBA

June 2010 – Feb 2011

Requirements and Role

The Datamart being fed by 14 Distribution Centers failed every night and there was nightly DBA’s 8-hour babysitting in turns, that had to be rewritten completely. DBA team needed short term contractor DBA.

Worked as a contractor.

Project completed successfully.

Work Done

Interacted with Project Managers, Architects, Functional Leads across platforms and centers.

Setup HA. Setup Log Shipping, Set up 8 Clusters.

Consolidated 285 SSIS packages to 5 new common SSIS packages and stopped nightly DBA’s 8-hour babysitting in turns.

Tuned Ad hoc reports and Canned reports working with the users. Used Profiler, Perfmon, DMV to troubleshoot issues, and worked with Partitions

Automated Reports from SQL Server to BI Team in SSRS

Refreshed QA and Production Environme


CSI Labs, Atlanta, Georgia, DBA

Oct 2009 – Mar 2010

Requirements and Role

DBA role, Analytics, Reports, Optimization.

Worked as a full-time employee.

Moved on to better offer.



Work Done

Did Standard DBA task to plan, set, create, maintain, tune, size, backup, recover and clone databases.

Created Project Plans, Presentations, Ad hoc Reports and Counts for  Account Managers and Clients.

Cleaned up Billing systems and built Data Warehouse for Finance, HIPPA compliant.

Coded complex SSIS packages which had Billing analysis, decision, sampling, and statistics.

Tuned LIMS. Combined Legacy data with LIMS and provided Pivot Reports.

Copyright © 2026 Data Services Consulting- All Rights Reserved.


This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept