SRIHARSHA

Client: KPMG

Description: My responsibility is to build scalable and interactive Business Intelligence solutions that will serve the client in driving Business Insights. The role involves working independently in an agile approach while collaborating with counterparts across workstreams to develop automated analytics business solutions.

Responsibilities:

• Involved in Data Analysis, Data Mapping and Data Modelling and Performed data integrity, Data Portability testing by executing SQL statements.
• Worked on BI projects at all stages, including requirements gathering, logical design, physical design, implementation testing, and deployment, as well as maintenance and support.
• Involved in designing and developing packages for Data Warehousing and Data Migration projects using Integration Services (SSIS) on different Data Sources.
• Developed models, reports and dashboards using Microsoft Power BI stack (Power Pivot, Power View, and Power query).
• Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).
• Designed, built, and automated insightful business intelligence dashboards using Tableau to help stakeholders and clients plan future sales and marketing strategies.
• Created sophisticated T SQL / P SQL queries for SSRS Report join conditions, unions, aggregates, and expressions. Created KPI, Partitions, Perspectives, and Calculated Measures, used DAXqueries, Roles.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Created Calculated Columns and Measures in Power BI and Exceldepending on the requirement using DAXqueries.
• Worked in Logical modeling using the Dimensional Modelling techniques such as Star Schema and Snow Flake Schema.
• Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business.
• Used Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Used SQL, Python, and PySpark, worked Data bricks notebooks were generated, and automated notebooks were made using tasks.
• Developed a method for importing and exporting data into a Hadoop system using Sqoop. Created and loaded data into both partitioned and non-partitioned Hivetables.
• A Python script was created to process big data sets and to extract data from various files.
• Worked on track record of modifying Jira projects with a wide range of schemes, complex processes, flows, authorization schemes, and notification schemes.
• Actively applied Agile Methodology practices for development of the Microsoft reporting environment.

Environment: Power BI, Star schema, Snow flake, Excel, ADF, Azure, Python, SQl, Pyspark, Hadoop, Sqoop, Jira, DAX,

KPI, T SQL, P SQL, ETL, Power BI, Power Pivot, Power View, Power Query, ETL, Tableau, Agile, SSIS, SSRS.

Client: Verizon

Description: Our project goal is to gather data from various sources, dump it into a data warehouse whenever the necessary conditions are met, then create dashboards in PowerBI Desktop and share them with the Azure cloud using Data Management Gateway.

Responsibilities:

• Created and executed acceptance tests and documented results while assisting the entire organization throughout the software development lifecycle (SDLC).
• Analyzed, retrieved, and aggregated data from multiple clients to perform data mapping to precisely append incorrectly mapped or missing data.
• Provided the thought leadership for a framework of a front-end interactive visualizationdashboard that delivers user-driven business intelligence using Tableau for end users.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Developed Sub Reports, Matrix Reports, Charts, and Drill-down reports, using SQL Server Reporting Services (SSRS).
• Utilized Power Query in Power BI to Pivotand Un-pivot the data model for data cleansing and data massaging. Designed Star schema (identification of facts, measures, and dimensions) and Snowflake.
• Develop operational, analytical dashboards and data visualization reports using Power BI.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
• Transformed complex business logic into Database design and maintaining it by using SQLobjects like stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• An SSISprogram was developed to build and maintain a central data warehouse, and records were added daily from other data sources like Excel, Access, flat files, Oracle, and XML.
• Created and review SSAS tabular cubes for consuming as a data source for reports, Dashboards, Pivot table.
• Developed and implemented SSIS and SSRS application solutions for various business units across the organization.
• Created interactive dashboards for on-demand storytelling on the Tableau desktop, thus, launching solutions that improved the customer experience.
• Implemented row-level security to restrict the data to a set of users in Power BI.
• Strong knowledge of Power BI using SQL Server 2014/2018/2019.
• Created Spark programs for personalized data collecting, transformation, and validation. The Hadoop ecosystem in Pysparkwas developed in collaboration with Amazon EMR and Data bricks.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Used Jira, epics, user stories, and tasks were created for each need while adhering to the sprint planning.

Environment: Power BI, SSRS, SSIS, SSAS, KPI, ETL, SQL, Excel, Access, Tableau, Spark, Pyspark, PL SQL, Shell Scripts, power Query, Star Schema, Snowflake, RLS, Azure.

Client: Vodafone

Description: The project major goal was to maintain and enhance the ETL process, which moves data from clients and internal departments into the data warehouse of transactions involving renewable energy.

Responsibilities:

• Created data mapping document to map customer data from different systems to Enterprise customer data mart.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Created interactive reports using Excel and Power BI to visually analyze data. GIT repository was also made so that the source code could be controlled locally.
• Implemented complex DAX expressions, embedded queries, measures, and appropriate relationships to control the filtration of screens from user input as per the requirement.
• Several tabular reports, matrix reports, chart and graph reports, and ad-hoc reports were all produced using MS SQL Reporting Services (SSRS).
• Worked to import the data from on-premises to Azure Data, work was done on the Data Factory tool. Used stored procedures to load the data into data warehouse, Configuration, Logging and Auditing. Queries to transform the data.
• Utilized SQL and Hive to create Data Quality Scripts to verify the quality of the data and the success of the data load.
• Used one-time data migration of multistate level data from SQL Server to Snowflake was implemented using Python and Snow SQL.
• Produced a variety of data visualizations with Tableau and Python.
• Worked on Jira tickets for new features, improvements, and issues with bugs or defects.
• Used short-term releases and specifically Agile and Scrummethodology to work on the project.
• UNIX and Linux platforms are well-known, and efforts have been made to compile the code and fix issues.

Environment: Power BI, Desktop, SSIS, SSRS, Excel, DAX, MS SQL, Azure Data SQL, Snowflake, Python, Snow SQL, Tableau, Jira, Agile, Scrum, UNIX, Linux, T SQL.