• Analyzed the Data quality, Data validating, Data Mapping to migrate data from Oracle, Azure to GCP-BQ, SAP S4 HANA, and Involved on the development and enhancement Assess and rationalize the current reporting being provided, providing recommendations for reports that should stop / start / continue. • Experience in optimizing Microsoft Power BI dashboards, Power BI SME, Power BI apps with a focus on usability. Performance, flexibility, testability, and standardization.• Responsible for the development, automating and compiling the departmental budget, capacity planning, cost controls, cost benefit analysis, loading them into different environments, and performing ETL.• Implemented third party implementation tool integrated with in the SSIS to Encrypt and Decrypt client files dynamically.• Created data bricks notebooks using Python (PySpark), Scala and Spark SQL for transforming the data that is stored in Azure Data Lake stored Gen2 from Unstructured data Raw to Stage and Structured data Curated zones.• Expertise in Developing and Extending MS SQL Server Analysis Services 2017 (SSAS) Tabular/Multidimensional Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.• Developed and reviewed simultaneous SQL queries in Tableau/Power BI Desktop to validate both static and dynamic data for data validation.• Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations, and finance teams.• Proficient in using PBRS, a reporting automation tool for Power BI, to schedule and distribute reports to stakeholders at predefined intervals.• Implemented a daily report distribution system using PBRS, which automatically generated and emailed sales performance reports•

• Data Analysis: Analyzed the data and developed a set of dashboards using Power BI for the Supply Chain Marketing team that was consumed by SC Executives.• Reporting: Used different data sources like SQL, Analysis Services, Excel to develop visuals. Performed data transformations, data cleaning on the data sets to generate meaningful reports. Provided story-based insights using Power BI reports and dashboards. Data aggregation using Excel, Pivot tables, SQL.• Analyse business, functional requirements and create technical design documentation.• Collaborated with partner teams to plan on enhancements, dependencies, risks, and release planning.• Collaborated with key stakeholders across verticals, suggested and developed insightful data visualizations• Designed and developed SQL databases, queries, and Power Automate workflows factoring in reliability aspects and row-level security aspects.• Participated in Legacy Sprint and T-Mobile Lease data integration and validation. Also migrated existing Tableau reports to Power BI• Designed and built scalable data models, cleaning and transforming data using Power BI• Developed Power BI reports used Power Apps to enable interactive self-service reports.• Involved in migration of Cognos ReportNet to Cognos• Existing Reports were migrated to Power BI from Cognos, MicroStrategy by reverse engineering and• Identified and implemented service/process improvements through automations like Tableau report refresh monitoring, shift updates, access management, UAT, report templates, etc., resulting in streamlined processes, improved data availability & accuracy, delivery, and 96% CSS.• Implemented Power Automate workflows to monitor and perform PBI report data validation, report refreshes, and more.• Performed data analysis, validation/governance during consolidation, and migration to Azure data warehouse – to ensure data is a single source of truth for reporting needs.

• Involved in gathering Business requirements from users, analyzing and transforming them into business intelligence reporting specifications. • Participated in discussions with customers to understand project goals and requirements to quickly develop the design and code, Focused on finding data sources, data extractions, creating data sets and using them as the source to create applications, dashboards and reports using data visualization and business intelligence tools to report the data for business decisions and other needs.• Report refresh and publish are auto scheduled in Power BI SME report server.• Experience in creating complex Alteryx workflows to extract the data from Teradata and other departmental sandboxes. Transformed the data in Alteryx and loaded them back into sandbox for departmental reporting needs• Developed interactive Tableau, Power BI and ShinyApp dashboards using languages like R, CSS and HTML. Published theses dashboards on department’s site for enterprise level use.• Providing day to day data needs, migrating the objects that has been developed, and managing production objects (dashboards in shiny, Cognos and Alteryx workflows)• Developing and maintaining dashboards using data visualization tool Tableau.• Scheduling and distributing daily reporting objects that are created in Alteryx and Table• Writing, tuning and deploying complex SQL queries and creating data sets based on data visualization needs.• Applied efficient data validation techniques on data sources in comparison with maintenance applications like SAP.• Managing and providing user access to SharePoint sites, dashboards and workflows• Experience in creating data source connections in Tableau, Power BI, Cognos and Alteryx using ODBC and JDBC.• Embedded Power BI reports on the front-end portals and also managed access of reports and data for individual users using roles

• Analyzed the data and developed a set of dashboards using Power BI for the Consumer Marketing team that was consumed by Executives to make valuable business decisions.• Worked on preparing for the development estimation time and technical design documents and setting up different environments.• Worked with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing, and Implementation.• Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions. • Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports. • Analyzed the KPI insights provided by the client using the POWER BI DESKTOP.• Developed a business solution for financial reports like Sales opportunity, lead, forecast, etc. Design and implement a financial dashboard to track performance against measured KPI’s.• Design Power BI data sets, linking data sources and building data models to give insights of data to stakeholders to take the financial decisions.• Creating critical measures like MOM, YOY and QOQ using DAX and R Script which helped the Finance key holders to understand the spent across key portfolios.• Created complex SQL views to support the business and operations for reporting.• Involved in building complex views for reporting using SQL, PLSQL (Procedures and Triggers).• Design data visualizations model for complex business requirements.• Excellent experience in designing and developing Power BI report scorecards and dashboards.• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.

• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.• Created Pentaho, SSIS, ETL job infrastructures, dashboard reports and Data visualizations.• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.• Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports,• Involved in extracting the data using SSIS from OLTP to OLAP.• Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development• Created T-SQL scripts, which generated tables, relationships, based on the finalized ER-diagram• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008R2• Physical Implementation of database into SQL Server 2012 using T-SQL.• Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.• Created different chart reports helped in analyzing perform counters using SSRS.• • Implemented Triggers for checking complex business conditions, providing security for the tables.