Sai Tanuj

• The major requirement of the project is to migrate from legacy systems to SQL server due to the growth of the company and increased requirements
• The project also required monitoring the billing services by creating reports and report models using SQL server reporting services.

Responsibilities:

• Used Power BI, Power Pivot, and Power View to construct data analysis prototypes and used Power Map and Power View to illustrate results.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel.
• Restricted access to users by creating security roles to access reports in Power BI using row level security. Configured and maintained MySQL database for certain components of the data analytics and reporting solution.
• Imported Data from various sources such as SQL Server, SQL DB, SQL Server Analysis services, Excel etc.
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
• Developed interactive dashboards and reports, focusing on user experience, that clearly outline business KPIs through various visualizations using SSRS and Power BI visualization tools.
• Experience in Logical modeling using the Dimensional Modelling techniques such as Star Schema and Snow Flake Schema
• Worked on new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Created database objects using stored procedures, views, joins, system functions, indexes, and merge statements to run insert, update or delete operations using T-SQL.
• Developed interactive and user-friendly visualizations in Power BI Desktop, Service and Azure Synapse for various reports and dashboards based on business requirements document.
• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
• Generating periodic reports based on the statistical analysis of the data from various time frames and divisions using SQL Server Reporting Services (SSRS).
• Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.
• Collaborated with key internal and external stakeholders to gather and analyze needs and requirements to design and implement robust analytic solutions to support the identified needs.
• Developed MapReduce/Spark Python modules for machine learning & predictive analytics in Hadoop on AWS. Implemented a Python-based distributed random forest via Python streaming.
• Worked on track record of modifying Jira projects with a wide range of schemes, complex processes, flows, authorization schemes, and notification schemes.
• Participated in daily scrum sessions and has experience with the agile approach with backlogs and story points.

Environment: Power BI, Power Pivot, Power Query, KPI, ETL, SSRS, Star Schema, Snowflake, ETL, SSIs, T SQL, Power BI Desktop, Azure Synapse, Azure Data Factory, SSRS, Tableau, Map Reduce, Spark, Python, Hadoop, AWS, Jira, Agile, Scrum, Excel, Power View, Power Map.

• The project's objectives include extracting and processing a sizable amount of data, running it through several decision-making tools, validating the outcomes, and creating MRA (Material require attention) reports
• These reports help automate the extraction and transformation process and ensure compliance with federal regulations.
• Responsibilities:
• Participating in Daily stand up Agile/Scrum meetings to discuss the sprint distribution, work status and enhancements to be made for the existing system.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace.
• Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
• Used SQL Server Integration Services (SSIS) as an ETL Tool, the data has been Extracted, Transformed, and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Used multi-dimensional models like Star Schemas and Snowflake Schemas for Cube development, involved in designing and constructing Data Warehouses, Data Marts, and Business Intelligence.
• Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Developed automated reports and scheduled updates using Tableau's publishing and scheduling features, providing stakeholders with up-to-date insights.
• Implemented version control using Git for ETL processes, data mapping, analytics scripts, dashboard development, and report templates, ensuring collaboration and tracking changes.
• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
• Implemented report integration among Power BI, Tableau, SSRS and Python reports.
• Utilized Jira for project task management, requirement tracking, and collaboration among team members, ensuring timely delivery and effective communication.
• Familiarity with Unix/Linux operating systems, including file systems, process management, and system utilities.

Environment: Power BI, Agile, Scrum, Excel, ETL, MS SQL, Star Snow Flake, SQL, Tableau, GIT, Azure Data Factory, Tableau, SSRS, Python, Jira, Unix, Linux, DAX, Power desktop, Power Pivot, Azure.