Santosh R Email and Phone Number

Developing, and managing advanced reporting, and client-facing Power BI dashboards.Connect Snowflake to Power BI and imported related tables, developed data model in Power BI.Automating Legacy processes using Advance Excel functions, creating pipelines and visuals usingPower BI.Creating Snow pipes, and tasks in the Snowflake to load incremental data into Snowflake tables.Integrate Power BI reports into other applications using embedded analytics like Power BI service(SaaS), or by API automation.Create new complex Power BI custom UI visualizations according to specifications.Working on dimensional modeling and maintained dimensions related to insurance claims andpayouts as a part of Snowflake schema and loading the data in the member fact tables.Performing and documenting data analysis, data validation, and data mapping/design.Translating business requirements into dashboards importing data from databases.

Analyzing and formatting data deliverables (e.g., reports, spreadsheets, etc.) to provide users with meaningful and interpretable informationAssisting with the development of design documents (e.g., program design, etc.) to define project scope and identify stakeholdersAssisting with the distribution of design documents to stakeholders (e.g., service center, Marketing, etc.) to obtain sign-off, agreement on project costs, and needed resourcesAssisting with the development of project plans (i.e., detailed plan, milestones, work breakdown structures) and to ensure that the project will be completed on time and according to specificationsGathering, compiling, and analyzing relevant research data to support senior management presentations.Experienced in translating the business requirements into dashboards importing the data from databasesExperience in writing Complex SQL Queries involving multiple tables with joins, view and stored procedures for operational and ad hoc reportingModifying the existing reports to include Experience in tuning the reports by modifying required T-SQL and MDX queries, also explored query folding and performance analysis feature in Power BI DesktopMaintaining Power BI Service reports for the users and modifying the reports according to user needs. Maintaining Power BI user policy from new users and adding them to respective teamsHands on Experience in scripting using R language for weekly reports and reading/modifying existing scripts using R-StudioManually refreshing the weekly, monthly reports for the leadership team and maintaining themImplemented several DAX functions for various fact calculations for efficient data visualization in Power BIWorking closely with the DBA team to monitor missing data, maintaining the data logBuilding SSIS packages to create new tables and maintaining them in the changing fast environment

Involved in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications for Business Reports Liaison between stakeholders and management for communication and elicitation of business requirementsCreate and develop reports, identify trends using SQL queries to forecast the business needs.Collaborated with different teams to understand products and solutions to provide cost-effective decisions that are data driven.Developed business requirements into technical workflow diagrams and collaborated with IT teams to ensure successful execution. Coordinated with Product Owner for analysis of the requirements and creating user stories and user acceptance criteria.Working with clients to better understand their needs and present solutions using structured SDLC approach.Maintaining project backlog. Conducted GAP analysis sessions and documents and created user stories based on the analysis.Created Requirement Traceability Matrix to list all the requirements and make sure all the required documents like Use Cases, Test Cases, are written and compiled.Work with the technical team to develop Functional Requirement Documents (FRD), and to determine their needs and expectations for future systems.Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Extensively used MS Project for project managementWorking with clients to better understand their needs and present solutions using structured SDLC approach.

Develop initiatives for continuous business process improvements.Developing and implementing data analysis, data collection systems and other strategies that optimize statistical efficiency and quality.Preparation of reports and gathering statistical data, usage of MS Visio to create workflows.Working with the team to understand hardware, products, and solutions and provide cost and performance analysis, recommendations for purchases, management of the purchasing process, and maintain inventory.Communicate business requirements to the technical development staff to design system solutions.Be proactive, identify trends and report root causes of issues as appropriate. Developing innovative solutions for parallelizing and optimizing analytical algorithms.

Providing prompt and efficient service to Amazon vendors and merchants including the appropriate escalation of Seller Issues. Building Platform and business knowledge to better serve sellers and vendors.Actively seeking solutions through logical reasoning and data interpretation skills and identifying trends to appropriate channel including improvement suggestions.Demonstrating ownership of every seller interaction to achieve successful first-time resolution on all contacts.Demonstrating excellent time-management skills and the ability to work independently knowledge while using departmental resources, policies, and procedures.Maintaining a positive and professional demeanor always portraying the company in a positive light and effectively managing sensitive issues.