About
An ETL Developer and Database administrator with a comprehensive experience in data analytics, database administration, report development, and production support of multiple databases on a Windows, Windows Server Cluster Environments and Cloud\Azure Services. Efficiently designed, tested, and implemented new and existing ETL Solutions. Excellent problem-solving skills and managed multiple complex projects in an agile environment performing development activities across all phases of Project Development Life Cycle.
Looking for Full-Time, Part-Time, TemporaryPortfolio
House Price Attributes an ETL and Data Warehouse Solution
Housing prices were up and down throughout years and the Real Estate industry has remained unpredict... ... More
Employment History
-
SQL/ETL Developer
Colaberry Inc
November 2019 - Present
• Designed, debugged, tested functionality, and deployed several SSIS packages that extract data from multiformat sources (CSV, EXCEL, OLEDB, XML, FTP, JSON files) and loaded them into a single point of ETL Solution.
• Implemented incremental loading into a previously existing ETL solution and maintained historical changes as required by SLA.
• Developed and tuned stored procedures, triggers, views, and modified tables at different levels of Data Warehouse implementation stages (Staging, ODS, Data Warehouse).
• Reviewed and maintained pipelines created on an Azure Data Factory and Documented the process.
• Developed reports and dashboards that entailed graphs, indicators, matrices, charts, and gauges using SSRS
Migrated Legacy databases from premises to Azure environments. And Involved in an In-place SQL server upgrade from 2008 to SQL server 2012.
• Efficiently worked with cross functional groups and constantly supported reporting team in developing queries. -
SQL Server DBA
Premera BlueCross
May 2017 - October 2019
• Virtualized Servers and Configured SQL Server environments spanning over 50 Instances and 1500 database on different SQL Server versions (2008r2, 2012, 2014, 2016) on windows and Clustered virtual machines.
• Efficiently Implemented, configured, and monitored High Availability and Disaster Recovery (HADR) solutions. Configured and supported transactional replication from production to reporting server.
• Executed AlwaysON availability groups on one of Critical production databases.
• Ensured operational readiness (security, Health, and performance) of multiple instances.
• Solved several performance Bottlenecks caused by complex queries using Performance Monitor (Perfmon), SQL Profiler, Activity Monitor to resolve dead locks, Long Running Queries.