Happy Tiwari

Profile Summary Good in Developing and Creating queries to use in automation as per requirement Crafting stored procedure, function, sub queries, index, temp table Creating stored procedures to support frontend live reports, ensuring data retrieval is efficient and real-time. Responsible for data analysis with Python and developing reporting specs, developing reports, and developing dashboards and writing complex SQL queries. Updating records in database according to business domain and lettering optimized T-SQL queries. Analyses requirements, perform impact analysis, design modules, build and unit test the code. Performing data analysis by connecting Python with SQL databases, enabling advanced analytics and data-driven insights. SQL querying, performance tuning, creation/updating/disabling SQL Server Agent jobs. Requirements. Explore data in a Variety of ways and across multiple visualizations using Power BI. Experience in Debugging, Optimizing the power BI Dashboards/ Reports and Performance Tuning of Dashboards / Reports. Resolving critical company revenue impacting issues raised by clients, providing technical support and solutions. Analyzing both revenue and non-revenue impacting issues, conducting root cause analysis, and implementing corrective measures to enhance performance and customer satisfaction.

Project 1 :-

Technology: Python , PostgreSQL

⦁ Import necessary libraries: import requests for making API requests , pandas as pd for working with DataFrames and import psycopg2 for working with PostgreSQL

⦁ Make an API request to fetch data from the API site. Define the API URL and headers.Use requests.get() to retrieve the data.Create a DataFrame (data) from the API response.

⦁ Establish a connection to a PostgreSQL database Define the database parameters (host, database name, user, password).Use psycopg2.connect() to connect to the database.Create a cursor for executing SQL commands.Create a table in the PostgreSQL database:Define the SQL statement for table creation (create_table_sql).Execute the SQL statement to create the table.Convert the DataFrame into a list of tuples for insertion.Insert data into the table:Define the SQL statement for data insertion (insert_sql).Use cursor.executemany() to insert the data into the table.Commit the transaction to save changes to the database.Close the database connection.

Project 2 :-

Technology: Power BI , SQL

⦁ Created stored procedure, function, sub queries, index, temp table

⦁ Excellent understanding of temp Table, Table Variable, UDF, CTE, Sub query and Index Microsoft SQL Server .

⦁ Analyses requirements, perform impact analysis, design modules, build and unit test the code.

⦁ SQL querying, performance tuning, creation/updating/disabling SQL Server Agent jobs. Requirements.

⦁ Responsible for the preparation, Report out and maintenance Daily, Weekly, Monthly and Ad hoc reports using Power BI.

⦁ Worked on development of Power BI Reports using SharePoint Online as a Data Source.

⦁ Worked on the Power Bi reports & dashboards with Tabular sources. Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations. Worked on Custom Visualizations like multi slicer and Hierarchy slicer.

⦁ Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc. Created New Calculated Column and Measure using DAX Expression. Created action filters, parameters.

⦁ Developed Power BI Reports to perform year over year, YTD, and MTD, GROWTH type of analysis.