Experience

Renew Financial

• United States
• Financial Services
• 100 - 200 Employee

• Sr, BI Data Engineer & DBA

  • Mar 2018 - Present

  • Designed logical data warehouse from scratch using DataVirtuality (DV) which combines data from various data sources (MSSQL, PostgreSQL, S3, GSheets, Google Analytics, FTP, Raw files etc.) and enable end users to fetch data from a single platform. • Developed fact and dimension tables in DV writing very complex SQL scripts. • Wrote very complex SQL scripts (stored procedures, functions, CTEs) as part of data conversion to handle JSON and XML source data. • Converted CloverETL graphs into DV to replace existing ETL and sunset the CloverETL for significant cost cutting for the company. • Developed and integrated Python scripts into DV for data manipulation & testing using Jupyter Notebook & PyCharm IDE. • Wrote custom database administration SQL scripts to audit and monitor data warehouse activities. • Created partitioned tables, materialized views, indexes in order to database modeling and achieve optimum performance. • Wore multiple hats of database developer, administrator, ETL developer time to time to support business needs. • Designed data pipelines using AWS Glue, Python with SQL integration and S3 buckets. • Developed and published reports using Tableau Desktop. Provided dev support in Tableau as well. • Administered Tableau reports to monitor extract refresh, user access and server-side administration. • Administer databases in PostgreSQL, MSSQL and Redshift with AWS RDS, EC2 instances in 5+ environments with multi-TB production databases. • Designed automated scrubbed database backup and restore process from production to non-production environments using bash scripts. Show less



Inform, Inc

• United States
• Advertising Services
• 1 - 100 Employee

• Sr.Database Developer & Administrator

  • Feb 2016 - Feb 2018

  • Developed complex SQL scripts (MSSQL, Redshift) in form of stored procedures, functions to integrate with BI solutions. • Created database tables, views , indexes by following agile methodology and Kimball technique. • Wrote custom SQL scripts to monitor server usage, database usage and query monitoring and audit to achieve optimum performance. Integrate these scripts in Chartio reports to visualize and troubleshoot. • Designed automated backup/restore strategy in production from EC2 instances to S3 buckets and restoration from S3 buckets to EC2 instances using SQL maintenance plans and PowerShell. • Created SQL Server transactional replication from scratch. Maintained the replication by setting up alerts and latency tracker using Chartio. • Designed custom and attractive SSRS & Chartio dashboards, scorecards and KPIs that used on daily, weekly, monthly, or on-demand basis. • Created SQL jobs and alerts to trace the deadlocks, disk space, database locks etc. Configure SQL Server monitoring utilities to minimize false alarms. • Worked closely with application developers in OLTP and OLAP systems for performance tuning of MSSQL and Redshift scripts. • Achieved 300%-500% query performance enhancement in ~16 TB AWS Redshift cluster & MSSQL databases by implementing table compressions, indexing and storage monitoring. Also, achieved ~50% cost savings by database cleanup and archive strategies. Show less



AutoOpt Networks

• Greater Atlanta Area

• Sr. Database Developer

  • Mar 2012 - Feb 2016

  • Worked on the nationwide LTE (4G Evolution) and VoLTE rollout implementation project. • Highly responsible for all phases of data life cycle (from data analysis to data loading (ETL)). • Designed, deployed, automated, and administered SSIS packages to extract data from OLTP systems and other heterogenous datasources and load data into OLAP systems. • Created database objects like tables, views, triggers, stored procedures, functions, indexes etc. • Configured SSRS from scratch on dev, qa and production server by using SQL Server Reporting Services Configuration Manager. • Created ad-hoc reports, drill-down reports, drill-through reports, sub reports, matrix reports, charts, maps, dashboards, score cards using SSRS. • Created parameterized geo-spatial reports using linked servers and open query by taking Oracle (PL/SQL) as a data source. • Designed Alteryx modules and workflows as part of ETL to combine geo-spatial data from various data sources for run time analysis and generated ad-hoc spatial reports. • Analysis on the geo-spatial data and generate reports using MapInfo Professional. • Optimized long running queries and achieved optimum performance tuning using various MS SQL tools such as SQL profiler, SQL Database Engine Tuning Advisor (DETA), execution plans etc. Show less



Otis Educational Systems, Inc.

• United States
• Software Development
• 1 - 100 Employee

• SQL Developer

  • May 2011 - Mar 2012

  • Developed complex SQL scripts as stored procedures, functions, triggers, cursors. • Created database tables, views, indexes after gathering business requirements. • Developed dashboards, scorecards, tabular reports, sub reports, matrix reports, drill down and drill through reports and charts using SSRS. • Created reports which can controlled by cascaded parameters, multivalued parameters by using custom build SQL functions. • Convert existing SSRS reports driven by queries into driven by stored procedures to achieve the goal of reusability as a part of project goal. • Optimized queries and implement performance tuning using various MSSQL server tools such as SQL profiler, SQL performance monitor, execution plans and database engine tuning advisor (DETA). Show less



Hegemony Technologies

• Ahmedabad Area, India

• SQL Developer

  • Apr 2007 - Jan 2008



Cybervox Solutions, Ahmedabad

• Ahmedabad Area, India

• SQL Developer

  • Jan 2003 - Oct 2003