• Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping necessary to support advanced analytics initiatives within M & SC (Manufacturing and Supply Chain), including the interfaces between applications, databases and platforms.• Created a Datawarehouse and Integrated different systems data into the Wearhouse (Salesforce and SAP). Worked with multiple teams for combining the different Databases to a single Universe.• Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, and drill through filters also created custom visualizations using R-Programming Language.• Used Machine learning using Python-Programming Language for converting different language text to English for analysis.• Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data• Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, maintained the apps and workbooks.• Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.

• Participated in daily scrum meeting with team to discuss on the challenges and development of the project• Involved in requirement gathering from business users and IT teams to understand and express business process and business logic• Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.• Extracted data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building• Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.• Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.• Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions• Published Tableau workbook on Tableau Server and set report refresh• Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.• Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

• Worked with different team’s client, analytics, data sources, QA and visualization.• Worked in agile process having expertise in life cycle of a project from start to end.• Created data warehouse and data marts from scratch based on data structures and reporting needs.• Worked on writing ad hoc SQL scripts which are required for reporting purposes. Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.• Worked on user management for power bi. Sharing the dashboard access for power bi online.• Worked on Power BI dash boards and ad hoc DAX queries for power bi.• Extensive back-end support for many various reports on Tableau and Power BI.• Created store procedures, functions, triggers, indexes, views based on data processing and data cleansing.• Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.• Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.• Hands on experience in working with Applications Migration and App Development in AZURE.• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.• Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.• Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic

• Proficient involvement in design of Data migration project in end-to-end Development of Projects covering all phases of Software Development Life Cycle including Requirement Analysis, Designing, Build/Construction, Unit/Assembly Testing and Deployment.• Following agile pattern, and communicating with functional and technical team on the requirements for migrating data from legacy heirloom systems to Hybris• Creating staging DB, move all the business scope data to the staging database and migrate to Hybris using SSIS• Developed interfaces to process the SAP Sales Orders, SAP Accounts, Shipping acknowledgements and ASN confirmation.• Worked on dimensional modeling and maintained dimensions like Product, Customer, and Region as a part of Snowflake schema and loaded the data in the member fact tables.• Involved in building and maintaining SSIS Packages to import and export the data from various data sources based on design data models.• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, for loop and For Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.• Involved in Functional testing, cut over plans to discuss on the technical status of the launches• Performed End-End testing includes various phases like SIT (System Integrations) Soft Launch, Preproduction Launch, Going live and phased migrations.• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the SSAS Tabular Models.• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.