Resume

PROFESSIONAL SUMMARY

  • Over 10 years of experience leveraging in-depth technical knowledge with sharp analytical skills to analyze complex business problems and develop, deploy Information Technology solutions that enhance efficiency and productivity in a corporate environment
  • 10+ years of strong experience in the area of MS SQL Server, Business Intelligence, Data Visualization/Analytics, ETL and Data Warehousing
  • Full System Development Life Cycle (SDLC) experience including Requirements gathering, Analysis, Design, Development, Testing and Implementation of various medium and large-scale client/server applications in a structured development environment
  • Extensive experience in data migration between homogenous and heterogeneous system using Data Integration tools on various RDMS environments such as SQL Server 2016/2012/2008, Informix and MS Access
  • Skilled in implementing Data Warehousing and Business Intelligence solutions
  • Extensive experience in creating complex SSIS packages for ETL purposes using various transformations in SSIS 2019/2016/2012/2008/2005, also transformed data from various data sources to SQL
  • Experience in designing, creating, processing of cubes using SQL Server Analysis Services (SSAS)
  • Extensive experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Drill through, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports
  • Extensive experience in Performance Tuning and Optimization of queries and stored procedures
  • Demonstrate professionalism, attention to details, collaborative nature, results oriented, flexible and a quick learner
  • Strong communicator exhibited by working closely with users to identify and resolve problems, in addition to working well individually.

TECHNICAL SKILLS

  • Azure: Azure SQL Database, SQL Datawarehouse, Azure Data Factory, Spark, Databricks, Azure API Management, Azure Service Bus, Azure Event Hub, App Services, Azure Functiuon, Data Lake, Blob Storage, KeyVault
  • Databases: Azure SQL Database, SQL Server 2019,2016, 2012, 2008 R2, 2005 and 2000, IBM-Informix, MS Access
  • Data Visualization: PowerBI, Telerik, DevExpress
  • Operating Systems: Various Windows and UNIX environments
  • Version Control: Apache Subversion (SVN), TFS, DevOPS
  • IDE & BI Tools: SQL Server BI Development Studio (BIDS), SQL Server Management Studio (SSMS), MS Visual Studio 2019/2017/2015/2012/2010/2008, SQL Profiler
  • Data Modeling Tools: MS Visio,ERStudio,Lucid
  • Development Methodology: Agile, SRUM
  • Reporting Tools: SQL Server Reporting Services (SSRS) 2019/2016/2012/2012/2008 R2/2008
  • ETL Tools: SQL Server Integration Services (SSIS) 2019/2016/2012/2008 R2
  • OLAP Tools: SQL Server Analysis Services (SSAS) 2016/2008 R2
  • Job Scheduler: SQL Server Agent, UC4

AmerisourceBergen

April 2017 to Present

Enterprise Solution Architect
  • Train, support and manage .net and SQL development Teams
  • Design and Implementation of Microservice Cluster
  • Design and Implementation data marts and ETL Processes
  • Design, Built and implementation of QRDA engine – Windows and WCF to generate complex xml files got Government reporting
  • Design and development of AmerisourceBergen Rebate System and Data marts
  • Design and development of custom subscription-based report mailer to distribute reports
  • Design and Implementation of Data Factory Automation (dynamic ETL processes)
  • Design and implementation of metadata driven Databricks ETL Process into spark and sql server.
  • Design and implementation of metadata driven Data Factory ETL Process into spark and sql server.
  • Develop and fine-tune SQL scripts, Stored Procedures, Triggers and functions for reporting requirements
  • Troubleshoot data related issues and provide solutions to the business
  • Design, Development and maintenance of multiple Web (MVC5, Blazor),Windows Services, Azure functions, Microservices
  • Environment: SAP, Vistex, Databricks, Azure Data Factory, Azure App services, Event Hub, Message Bus, Azure AD, Microsoft SQL Server 2019/2016/2012, SSIS, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), TFS, SCRUM, Visual Studio 2019/2017/2015/2012, Azure Data Factory, Data Lake, Azure SQL Server, .net Core 2.2,.net Core 3

LHP Hospital Group

May 2013 to March 2017

Business Intelligence Manager / Data Architect
  • Train, support and manage Decision Support Team
  • Design and Implementation of Data Warehouse and data marts
  • Development, support, and maintenance of 500+ SSRS reports from OLTP and OLAP/DW databases
  • Worked with users and business analysts to design and develop tabular, matrix, gauges, chart, drill-down reports as well as interactive reports according to business requirements
  • Design and development of custom subscription-based report mailer to distribute reports hourly, daily weekly monthly.
  • Design and development of all ETL processes for data loading and extraction using SSIS and custom software solutions
  • Design and develop processes to ensure data integrity
  • Develop and fine-tune SQL scripts, Stored Procedures, Triggers and functions for reporting requirements
  • Troubleshoot data related issues and provide solutions to the business
  • Design, Development and maintenance of multiple Web (MVC4, MVC5),Windows Services, Console and Desktop (Windows Forms) applications,
  • Environment: Microsoft SQL Server 2016/2012/2008R2 Enterprise Edition, SSRS, SSIS, SSAS, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SVN, AGILE, Visual Studio 2012/2010,SolarWinds

Arkansas Heart Hospital

Aug 2011 to May 2013

Senior BI Developer
  • Developed, supported and maintained multiple cubes and ETL processes for the Operational Deliveries and data marts
  • development on existing data warehouse and implementation of data marts
  • Worked closely with the business to understand requirements to develop data warehouse and Business Intelligence solutions
  • Performed Data Analysis to resolve data discrepancies
  • development, maintenance and support of multiple Web, console and Desktop applications
  • Environment: Microsoft SQL Server 2008 R2/2005 Enterprise Edition, SSRS, SSIS, SSAS, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS),Monarch, SQL Server Data Tools (SSDT), SVN, Visual Studio 2010/2008

...more upon request