SUMMARY

• Analytical and a collaborative solution implementation consultant with breadth and depth of experience guiding full BI Stack including SQL Server, T - SQL, SSIS, SSAS, SSRS, Power BI and Azure Cloud Data Service.
• Involved in entire Software Development Life Cycle (SDLC) from inception including requirement gathering and analysis until completion in design development.
• Hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experienced in designing, creating, processing of cubes using SSAS.
• Experienced in using Power BI tool for developing dashboards, interactive reports, and compelling visualizations.
• Rich Experience in working with Microsoft Azure data cloud environment such as Azure Data Factory, Azure Data Lake, Storage, Azure SQL, Data Migration etc.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service-oriented attitude.

TECHNICAL SKILLS

Database: SQL Server 2017, 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: Erwin, MS Visio

Database Programming: T-SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, Cubes, Tabular Models

Reporting Tools: SSRS, Power BI, Tableau

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage

Snowflake: SnowSQL, Snowpipe, Zero-copy Cloning, Time travel, Stages, RM

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

Environment: Erwin, SQL, T-SQL, SQL Server, SQL Profiler, ETL, SSIS, SSAS, Tableau, PowerBI, C#, Azure SQL Database, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, Azure Data Bricks

Responsibilities:

• Used Scrum Methodology as a project development and management tool as per company policy.
• Interacted with users to gather business requirements to translate them into BI application design and solutions.
• Worked with stakeholders including the Executive, Product owner, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
• Performed data analysis in the form of Tableau dashboards from existing data warehouse and Azure SQL database and changed internal schema for performance.
• Used C# to bring in the data from API into Azure SQL database.
• Created Azure Data Factory pipeline to bring in the data from Azure Data Explorer to Azure Synapse Analytics.
• Created Stored Procedures, Common Table Expressions, User Defined functions to implement transformations on the data to address different needs of data related issues such as data cleaning, fix structural errors, filter unwanted outliers and handle missing data.
• Optimized the performance of slow running T-SQL queries by analyzing execution plans, as well resolving issues related to stored procedures.
• Worked on all activities related to the development, implementation, administration, and support of ETL processes for large-scale data warehouses using SSIS and Azure Data Factory pipelines.
• Improved the performance of reports by optimizing data sets, making use of report caching and snapshots along with taking into consideration networking aspects.
• Created various reports with attractive visuals using Power BI with import, direct query and live connection data access modes for dashboards.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.

Confidential, Fort Wayne, Indiana

Azure Data Engineer

Environment: Erwin, SQL, T-SQL, SQL Server, SQL Profiler, ETL, SSIS, SSAS, Power BI, DAX, Azure SQL Database, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, Azure Data Bricks

Responsibilities:

• Used Scrum Methodology as a project development and management tool as per company policy.
• Communicated effectively with team members to make sure the product development process in alignment with Proof of Concept of the company to meets the corporate goals
• Worked with stakeholders including the Executive, Product owner, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
• Built required infrastructure for optimal extraction, transformation and loading of data from various data sources to Azure Synapse Analytics and Azure Data Lake
• Created Azure Data Factory pipelines for daily inflow of the unprocessed files and historic load of the unprocessed files from on premises to Azure Data Lake for file storage as the source of truth for raw files
• Created Azure Data Factory pipelines for daily movement of the processed data and historic load of processed data from on premise Databases to Azure Synapse Analytics
• Implemented Azure Synapse Analytics modelling by Executing Fact and Dimension table scripts on SQL Server Management Studio (SSMS) to create Fact and Dimension tables for Azure Synapse Analytics
• Created a Data Mapping Document (DMD) or ETL Mapping Documents that will have appropriate mapping from the source tables from the OLTP to destination tables in OLAP.
• Implemented Data Transformation to raw data using Python in Azure Data Bricks that would involve mapping, filtering, enrichment, changing the structure of the data, deformalizing and aggregating the raw data
• Developed complex programs in T-SQL, wrote stored procedures, triggers, views and queries with best execution plan.
• Used SQL Profiler for troubleshooting, monitoring and optimization of SQL Server components for debugging Azure Data Factory pipelines.
• Deployed the Data changes made to Azure Synapse Analytics and Azure Data Lake as per business requirement into development, stage and production environments by creating pull requests and releases in Azure Devops
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs

Confidential, Scottsdale, AZ

MS BI Developer / Analyst

Environment: Erwin, SQL, T-SQL, SQL Server, SQL Profiler, ETL, SSIS, SSAS, Power BI, DAX, Azure, Azure SQL Database, Azure Analysis Service, Azure Data Factory, Azure SQL Data Warehouse

Responsibilities:

• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created databases & schema objects including tables, indexes, stored procedures & functions as a part of the data migration initiative.
• Led performance tuning of database by rewriting SQL Scripts, created indexes & partitions and changed locking strategies.
• Utilized T-SQL stored procedures to transfer data from OLTP databases to staging area, then into data mart.
• Optimized SQL queries using indexes and execution plans for maximum efficiency and performance.
• Designed complex stored procedures for performing data profiling and validation in the pre-staging database.
• Implemented robust error handling in SSIS utilizing event handlers, precedence constraints at control flow level and error data pipelines at data flow level.
• Worked on calculating measures, mathematical formulas and user-defined functions (DAX) in Power BI reports.
• Utilized recently introduced Power BI to create self-service BI capabilities and used tabular models.
• Deployed dashboards, reports and data sources using the Power BI service.
• Deployed Power BI reports to the reporting server and assisted in troubleshooting deployment problems.
• Designed a DataMart for specific business process on Azure cloud and implemented Data migration from Data Warehouse on premises system to the Azure cloud environment.
• Experienced in using ADF (Azure Data Factory) for incremental load and implementing ELT operation performing different transformation to apply business logic.
• Recreated existing application logic and functionality in the Azure Synapse Analytics, Azure Data Factory, SQL Database and SQL data warehouse environment.
• Implemented Azure Data Factory operations and deployed into Azure for moving data from on-premises into cloud.
• Recreated existing application logic and functionality in the Azure Analysis services, Data Factory, SQL Database and SQL data warehouse environment.

Confidential, Wayne, PA

BI SQL Developer / Analyst

Environment: SQL Server 2016, T-SQL, SSIS, SSAS, SSMS, Power BI, DAX

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Participated in all phases of SDLC methodologies throughout the project life cycle.
• Wrote complex stored procedures, functions, and SQL constructs to implement business logics in the OLTP database.
• Developed database objects such as tables, views, indexes, stored procedures, and constraints with T-SQL.
• Evaluated execution plan for T-SQL queries and stored procedures to improve performance based on which created indexing/partitioning strategy with re-structuring of SQL logics.
• Wrote dynamic SQL scripts with table variables and temporary tables to improve the code reuse factor as a part of application.
• Utilized various SSIS transformations such as lookup, fuzzy lookup, fuzzy grouping, conditional split, data conversion, derived column etc. as a part of business requirements.
• Created reports in Power BI Desktop and published to portal utilizing the SSAS tabular via analysis connector.
• Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Installed and configured Power BI gateways to keep the dashboards and reports refresh automatically.
• Developed interactive visuals, KPI scoreboards using Power BI Desktop application.
• Determined calculations to generate new fields in Power BI reports with Data Analysis Expressions (DAX) formulas.
• Developed and maintained multiple Power BI dashboards in Power BI mobile and Power BI web.

Confidential, Worcester, MA

SQL Reports (Power BI) Developer

Environment: SQL Server, SQL, T-SQL, Erwin, SSIS, SSAS, Power BI, DAX, Power BI Apps, Power BI Gateway.

Responsibilities:

• Consolidated business requirements and specifications for project through JRD sessions.
• Transformed business requirements into working logical and physical data models. ed performance tuning of database by rewriting SQL Scripts, created indexes & partitions and changed locking strategies.
• Performed root cause analysis on failures and resolved performance tuning related issues on queries with SQL profiler and DTA.
• Utilized T-SQL stored procedures to transfer data from OLTP databases to staging area, then into data mart.
• Led performance tuning of SQL queries using show plans and execution plans for better performance.
• Optimized SQL queries using indexes and execution plans for maximum efficiency and performance.
• Optimized indexes to improve SQL queries and analyzed database performance with SQL Profiler
• Created stored procedures to transform the data and worked extensively in T-SQL for different needs of the transformations while loading the data as part of the SSIS packages.
• Created Power BI Apps using REST API and integrated with Power BI reports & dashboards.
• Involved in development of Power BI Apps to share reports, dashboards and dataset within the organization and also for required calculation in Power BI reports.
• Automated the data refresh of Power BI datasets using Power BI gateway by implementing DAX functions.
• Published Power BI reports to the Power BI self-service and troubleshoot deployment and performance issues.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.

Confidential, Springfield, MA

Data Warehouse Developer

Environment: SQL, SQL Server, T-SQL, Erwin, ETL, SSIS, SSAS and Agile methodology

Responsibilities:

• Interacted with users to gather business requirements and analyzing, designing and developing the data feed and reporting systems.
• Created data warehouses with the help of Snowflake Schema and Star Schema in accordance with the business requirements.
• Presented automation test result analysis during daily Agile stand-up meetings.
• Performed data analysis for existing data warehouse and changed the internal schema for performance
• Developed key performance metrics and dashboards to help drive key business decisions through data modeling, reporting and automation.
• Wrote and execute positive and negative test cases to ensure the data originating from the data warehouse is accurate through to the SQL in the applications
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing Enterprise Data Warehouse.
• Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.
• Automated the ETL process with SSIS package execution schedules utilizing jobs.
• Developed SSAS cubes with KPIs and aggregation for the front-end analysis team.

Confidential, Boston, MA

SQL Developer

Environment: SQL, SQL Profiler, SQL Server, T-SQL, Erwin, Agile, Power BI, Power BI Desktop.

Responsibilities:

• Translated business requirements into BI application designs and solutions.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Followed the Software Development Life Cycle throughout project and used Agile methodology.
• Generated dashboard reports for internal users using SQL Server Reporting Services.
• Developed complex programs in T-SQL, wrote stored procedures, triggers, views and queries with best execution plan.
• Used SQL Profiler for troubleshooting, monitoring and optimization of SQL Server components.
• Created report and page level filter in Power BI desktop to visualize data according to requirement for different analysis.