Siva Krishna

Mobile: 832-***-****

Email: ad4ntq@r.postjobfree.com

Professional Summary

Experienced in spanning various domains such as Sales, Healthcare, Real Estate, Wholesale, and Retail. My expertise lies in developing, enhancing, maintaining, and administering systems utilizing a range of technologies, including Azure Data Factory (ADF), Microsoft Power BI, MSBI Tools (SSIS, SSAS, and SSRS), Microsoft SQL Server Database, and Oracle technology tools.

SOFTWARE CERTIFICATIONS

●Microsoft Certified: Azure Data Engineer (DP-203).

●Microsoft Certified: Power BI Data Analyst (PL-300).

Core Competencies

●MSBI, Power BI, ADF

●SSIS, SSRS, SSAS

●Tableau, ETL, Crystal reports, Git

●MS Azure, Azure Data Warehouse

●SQL Server 2008 R2, 2012, 2014, 2019

●T-SQL, DAX, MDX, VB Script

●MS Excel, MS Word, CRM

●Query Analyzer, Report Builder

Functional and Technical Skills

Languages

SQL, T-SQL, DAX, VB Script.

ETL Tools

SSIS, Azure Data Factory (ADF).

Reporting Tools

SSRS, Power BI, Tableau

Databases

SQL Server 2008 R2, 2012,2014,2019.

Cloud Technologies

Azure Data factory (ADF) & Azure SQL SERVER Database, Azure Synapse, Blob Storage

Tools

SSIS, SSRS, SSAS & Power BI

Professional Experience

Microsoft, June 2023 to current, Washington, USA.

Role: Sr. Business Intelligence Analyst

Project: Pricing Strategy & Industry solution Growth

Key roles/responsibilities:

●Experienced in navigating the Microsoft Azure ecosystem, including working with Blob storage, Data Factory, Azure Key Vault, and Azure SQL Server.

●Experienced in building, publishing, and scheduling SQL Server Reporting Services Power BI reports as per the business requirements.

●Build the pipelines using ADF to migrate the data from On-premises database to Azure SQL server database.

●Creating Charts, Straight Tables, Pivot Tables, KPI’s, Set Analysis and Aggregations based on the report requirements.

●Experienced in leveraging Excel's formula capabilities to extract, transform, and visualize data, facilitating comprehensive analysis and reporting.

●Wrote Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.

●Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS).

●Created jobs in SSIS and was responsible for ETL jobs scheduled to run daily. Solved the issues associated with ETL Data Warehouse failure.

●Extensive experience in designing and optimizing database views to encapsulate complex logic and facilitate data retrieval for reporting and analysis purposes.

●Extensively worked on Dimensional modeling, Data Cleansing, and Data Staging of operational sources using ETL process.

●Developed and Deployed SSIS packages, configuration files, and schedules a job to run the packages to generate data in CSV files.

●Configured security filters in Power BI to restrict data access at the row level, enhancing data privacy and confidentiality.

●Created DAX measures and calculated columns to perform advanced calculations such as year-over-year growth, cumulative totals, and trend analysis.

●Worked on Indexing strategies and query optimization techniques to optimize stored procedures and long running queries.

Key Projects:

●Analyzed market trends, competitor pricing, and customer segments to develop pricing strategies.

●Monitor and adjust pricing strategies based on market dynamics and business goals.

●Collaborated with the pricing team to ensure pricing strategies align with marketing efforts and sales targets.

●Developed dashboards and reports to track key performance indicators (KPIs) related to pricing and industry solution growth.

Environment: MSBI Suite (SSIS, SSAS), Microsoft SQL Server, Excel, Power BI & Azure Environment.

LTIMindtree, from Aug 2022 till Apr 2023

Microsoft: Cross channel(sales)

Role: Senior Data Analyst

Key client facing roles/responsibilities:

●Created Linked Services for multiple source systems (i.e.: Azure SQL Server, on-premises, BLOB Storage).

●Extensively used Azure Data Factory activities such as Lookups, Stored procedures, if condition, for each, Set Variable, Append Variable, Get Metadata, Filter, and Wait.

●Experienced in creating and managing various database objects including stored procedures, user-defined functions, views, and indexes to optimize database performance and functionality.

●Proficiently generate comprehensive reports by extracting data from SQL tables and Azure SQL databases.

●Utilized Synapse Analytics to efficiently transfer large volumes of data to dedicated pools, ensuring high performance and scalability.

●Utilized DAX expressions and formulas extensively to design and enhance Power BI reports, enabling advanced data analysis and visualization.

●Designed and managed database views to provide simplified and secure access to data for reporting and analysis purposes.

●Implemented row-level security (RLS) in SQL Server to restrict data access based on user roles and permissions, ensuring data confidentiality and compliance in Power BI reports.

●Designed and developed robust ETL pipelines using Azure Data Factory, SSIS (SQL Server Integration Services), or similar platforms to facilitate efficient data movement and processing.

●Developed optimized SQL queries to retrieve data from SQL Server databases, ensuring efficient data extraction for Power BI reporting.

●Involved in Designing data models from Different Sources (SSAS Tabular Cubs, Excel, and SQL Server).

●Successfully deployed completed development projects to User Acceptance Testing (UAT) environments and subsequently to production (Prod) environments using Continuous Integration/Continuous Deployment (CI/CD) methodologies.

●Implemented data transformations and aggregations within modeling views to ensure that the presented data aligns with reporting requirements and enhances visualization in Power BI.

Key Projects:

●Cross channel: Integrate sales data from different channels and sources into a centralized database or data warehouse for analysis.

●Ensure data integrity by verifying accuracy, completeness, and consistency of the collected data.

●Merge datasets based on common identifiers such as customer IDs, product SKUs, or transaction IDs to create a unified view of sales activities.

●Use tools like Excel and Power BI to generate interactive visualizations that allow stakeholders to explore sales data intuitively.

Environment: SQL Server 2012, SSIS and Power BI.

Infosys Apr 2019 till Aug 2022

Metropolitan life Insurance Aug 2020 to Aug 2022

Role: Power BI Developer

Project: LSM MetLife

Key client facing responsibilities included:

●Utilized ETL (Extract, Transform, Load) processes to import data from various sources into BI platforms, such as Power BI or Tableau, facilitating comprehensive data integration.

●Developed paginated reports within Power BI Report Server, leveraging its capabilities to produce pixel-perfect, printable reports tailored for specific requirements.

●Documented data integration and transformation processes comprehensively, including data mappings, transformation rules, and metadata, to facilitate transparency, reproducibility, and knowledge transfer.

●Utilized Report Builder or SQL Server Data Tools to design and author paginated reports, incorporating features such as tables, matrices, charts, and images to present data effectively.

●Published reports to designated platforms Power BI Service, Power BI Report Server, and other reporting portals, ensuring accessibility to stakeholders as per business requirements.

●Constructed interactive dashboards using reports published in Power BI Service, consolidating key insights and KPIs from multiple reports into a single, visually compelling interface.

●Created other visualizations scatter plots, histograms, and heatmaps as needed, employing suitable visualization types to convey specific insights or relationships within the data.

Key Projects:

●For a large Life Insurance provider: My role is to support their Business Intelligence (BI) platform for daily, weekly, and month-end reporting, as well as ensuring compliance with Sarbanes-Oxley (SOX) regulations and maintaining the stability and reliability of the BI platform, troubleshooting technical issues, and optimizing performance to meet the organization's reporting requirements.

Project: DFSS MetLife

Key client facing responsibilities included:

●As per Business Requirement we Extract and transform integrate police information, Billing details and other related information from different source systems and load into Data Warehouse

●Experience in Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task, Send Email Task, and Data Flow Task in designing packages.

●Worked on Performance related issues regarding SQL Queries and SSIS Packages

●Have used data flow transformations like Derive Column, Conditional Split, Aggregate, Lookup, Sort, Merge and Merge Join to implement Business rules.

●We are also responsible for creating and delivering reports as per business requirements for performance analysis.

●Loading data from source to destination In between monitoring Jobs and SSIS Packages we inform to customers After Completion of Trails

●Performance Tuning and Debugging of existing ETL processes.

●Experience on preparing Root cause analysis documents on issues in the production environment.

●Working on Change requests for changes in production

●Involving Scrum Daily meetings and discussing daily activities and issues

Key Projects:

●For a large Life Insurance provider: Supported their BI platform for daily/weekly and month-end reporting as well as SOX compliance processes. The system leveraged a combination of legacy code and technologies.

Client: Microsoft. April 2019 –Aug 2020

Role: Data Engineer

Project: Microsoft SI Insights

Key client facing responsibilities included:

●Created various types of charts like Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.

●Building Dashboards based on Reports.

●Expert on Microsoft Power BI and Tableau reports, dashboards, and publishing to the end users for executive level Business Decision.

●Involved in Designing data models from Different Sources (SSAS Tabular Cubs, Excel, and SQL Server).

●Using power Query Editor window creating Dim and fact tables for Excel Sources.

●Worked on DAX expressions/formulas to design a Power BI report.

●Used Power Query Editor Window to Transform data and loading into power bi desktop.

●Involved in Scrum Daily meetings and discussing daily activities and Upcoming Activates.

Key Projects:

●Microsoft SI Insights: The meticulous calculation of billing hours for project managers, project architects, and other employees. This involved a comprehensive understanding of project timelines, tasks, and resource allocations. These reports were instrumental in offering a clear, concise overview of project progress, resource utilization, and budget allocations. Leveraging my expertise in Power BI, SQL Server Analysis Services (SSAS), SQL Server, and Data Analysis Expressions (DAX). The core of my contribution lay in developing sophisticated Power BI reports that provided actionable insights to business stakeholders.

Zensar Technologies Aug 2015 – Apr 2019

Client Name: Johnson controls, USA Jan 2018 – Apr 2019

Role: BI Engineer

Project: SFGR SALES

Key client facing responsibilities included:

●Created Power BI visualization of Dashboards & Scorecards (KPI) for Finance Department

●Designed and implemented a Monthly Resource Allocations system using Excel Power Query & Power Pivots to be included in dashboard reporting.

●Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.

●Assisted Supply chain analysts with automating reporting functionality using Power BI tools Power BI reporting, Dashboards & Scorecards (KPI) and MySQL & Data warehouse data sources.

●Used Power Query Editor Window to be Transforming data and loading into power bi desktop

●Provided security(access) and created subscriptions for the reports.

●Build Dashboards based on reports published in power bi service.

●Involved in advanced level calculating using DAX.

●Created a paginated report in power bi report server.

●Used power Query Editor window creating Dim and fact tables for Excel Sources

Key Projects:

●SFGR Sales: At Johnson Controls, I played a key role in utilizing Business Intelligence (BI) tools and Extract, Transform, Load (ETL) processes to analyze sales data and support decision-making. My primary focus was on creating interactive reports that provided valuable insights for the business. My contribution involved optimizing stored procedures and views within our established ETL process. This optimization was aimed at improving performance and efficiency.

Client Name: Brand smart, USA. June 2016 –Dec 2017

Role: ETL Developer

Project: Sales Enhancement System

Key client facing responsibilities included:

●Used ETL tool SSIS for extraction, Transformation and loading data into data warehouse.

●Used various Transformation Like Expression, Filter, Joins and Lookup to migrate clean and maintain data.

●Created test scripts and involved in deployment activities.

●Worked in Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task, Send Email Task, and Data Flow Task in designing packages.

●Have used data flow transformations like Derive Column, Conditional Split, Aggregate, Lookup, Sort, Merge and Merge Join to implement Business rules.

●Performance Tuning and Debugging of existing ETL processes.

●Successfully Implemented Slowly Changing Dimensions. Used Type 1 for Incremental Loading.

●Generated Table, Matrix, Sub reports, Drilldown reports, Drill through reports, parameterized reports and linked reports from queries in SSRS as per the Client Requirements.

Key Projects:

●Sales Enhancement System: I spearheaded the design and implementation of Extract, Transform, Load (ETL) processes utilizing SQL Server Integration Services (SSIS) to streamline the cleansing, transformation, and loading of data.

●Using SSIS, I crafted robust ETL packages that efficiently extracted data from various sources, transformed it according to predefined business rules and requirements, and loaded it into the target database or data warehouse.

Client Name: Toyota, CA Aug 2015 –June 2016

Role: Software engineer

Project: Data Warehousing for Toyota Motors

Key client facing responsibilities included:

●Used ETL tool SSIS for extraction, Transformation and loading data into data warehouse.

●Used various Transformation Like Expression, Filter, Joins and Lookup to migrate clean and maintain data.

●Created test scripts and involved in deployment activities.

●Worked in Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task, Send Email Task, and Data Flow Task in designing packages.

●Have used data flow transformations like Derive Column, Conditional Split, Aggregate, Lookup, Sort, Merge and Merge Join to implement Business rules.

●Performance Tuning and Debugging of existing ETL processes.

●Successfully Implemented Slowly Changing Dimensions. Used Type 1 for Incremental Loading.

●Generated Table, Matrix, Sub reports, Drilldown reports, Drill through reports, parameterized reports and linked reports from queries in SSRS as per the Client Requirements.

Key Projects:

●Data Warehousing: My role in this project was to Optimize data warehouse performance through indexing, partitioning, and query optimization techniques to provide fast and reliable access to data.

Education

●Bachelor of Technology in Electronics & Communication Engineering from JNTU, HYDERABAD in June-2014.

Contact this candidate