Ramya Rachuri

E-mail: ad2qpp@r.postjobfree.com

Mobile : +1-507-***-****

PROFESSIONAL SUMMARY

Around 6 years of IT Professional experience in the software industry with Data Analysis, MDM (Master data Management) tools like Veeva MDM, Veeva CRM and good working knowledge on Development and Implementation of End-to-End BI Solutions in the areas of Business Intelligence & Data Analytics, Data Visualization.

Expertise in creating reports with data analysis, data profiling, data optimization, data cleansing, documentation, and testing.

Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint

Took the lead in working on development and administration of Power BI Reports and environment for multiple landscapes like HR, Talent Management, Inventory and Logistics, Medical manufacturing, Credit Analytics, Marketing and sales.

Worked extensively on BI Solutions using Power BI, Power BI Service, Power Automate, M-Query, DAX and SQL.

Worked collaboratively in SAFe Agile environment with continuous user interaction. Part of SCRUM meetings and handled a minor phase of a projects using JIIRA, Confluence.

Worked on Performing Data Analysis by analyzing data from multiple systems, creating Technical documentation for the project.

Experience in Data Modelling and creating data models in Power BI Desktop.

Proficient in data modelling and data transformation using Power Query (M-Language).

Responsible for maintaining BI Environment which includes Power BI Administration, Access Management, Security and Controls, Self Service BI Solutions.

Experience in Performance tuning and Optimization, using tools like Vertipaq Analyzer, DAX Studio. Experience on query folding which plays major role in fast retrieval of data or refreshes.

Experience creating Power Automate flows to automate certain activities within the project purview.

Strong Problem Solving and analytical skills. Attention to detail in Data visualization, consistently meets deadlines and targets while delivering high quality work.

Identify project issues/risks and present alternatives to alleviate or resolve them.

Provided analytical support on business metadata to ensure it is accessible and meaningful to data users.

Skills Snapshot:

Technical Skills

Power BI Desktop, Power BI Service, Power Automate, Data Visualization, DAX Studio, Vertipaq Analyzer, Power Automate, VEEVA MDM, VEEVA CRM, VSM

Databases/ Data Sources

SQL Server, AWS Redshift, Snowflake, Data Modelling, Data Analysis, Oracle, API’s

Programming Skills

DAX, SQL

Program Management

JIRA

PROFESSIONAL EXPERIENCE:

VAVERA LLC: (Jan 2021 to Dec 2023)

Role: Module Lead – Power BI

Have been part of multiple Projects with the below clients on various areas along the HR, Sales & Marketing, Logistics & Inventory, Finance, Credit Analytics.

1.Emirates Global Aluminium (EGA) is the world’s largest ‘premium aluminum’ producer and the biggest industrial company in the United Arab Emirates outside oil and gas.

2.Dole plc is an Irish agricultural multinational corporation headquartered in Dublin, Ireland. The company is among the world's largest producers of fruit and vegetables.

3.Smith & Nephew plc, also known as Smith Nephew, is a British multinational medical equipment manufacturing company headquartered in Watford, England.

Currently working on creating BI Reports for Multiple Work Streams: HR Analytics, Inventory & Logistics, Financial Sheets (Profits, Loss, Actuals Vs Budget variances KPI’s), Risk Management.

Responsible for working on Business Logic/Scenarios, Technical Documentation/Implementation and Data Modelling.

Developed Centralized Datasets, which acts as a single point of Data Source for all the reporting needs.

Designed a BI Solution for the E-Tendering & Procurement team to Identify the top three Quotes from the applied tenders for logistics & Procurement.

Developed and maintained Power BI dashboards for Talent Acquisition, HR Operations, Talent Management, Finance, E-Tendering Logistics Procurement, Marketing & Sales.

Gathered data requirements from stakeholders and translated them into effective data visualizations.

Performed data modelling and transformation using Power Query to ensure data accuracy and consistency.

Collaborated with Business Teams to identify key metrics and performance indicators for dashboards.

Created automated processes for data extraction, transformation, and loading into Power BI.

Conducted data analysis to identify trends, patterns, and insights for informed decision-making.

Provided ongoing support and troubleshooting for existing dashboards.

Organization: Cognizant Technology Solutions India Private Ltd. April 2016 to October 2019

Role: Data Analyst

Project: Biogen MDM

Tools/Software: Veeva MDM, Veeva CRM, MS Excel, MYSQL, VSM.

Description: Collaborate with business partners / client stakeholders to establish standards, maintain high-quality data making it consistent and fit for business consumption through application of appropriate techniques, tools and strategies.

Help customers manage their data in the MDM systems and related downstream applications while identifying effective and efficient data management practices.

Provide consultation, leadership, and expertise on process and Operationalize data management /data stewardship processes.

Act as SME, Leads data review, including query management, data analysis, listing review checks, data integration specifications, data uploads external data reconciliation.

Objectives:

Performing daily data queries and preparing reports on daily, weekly, monthly and quarterly.

Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis

Used advanced Microsoft Excel and the XLOOKUP function to efficiently create pivot tables and pivot reporting.

Provided annual forecasting support, evaluating investment effectiveness based on expected results.

Built and maintained optimization model to inform quarterly budget allocation, ensuring investments achieves the greatest possible value.

Run experimentation initiatives; design test plans, obtain cross-functional alignment, complete robust analysis, and deliver practical insights.

Providing SQL support to front end users

Creating and executing SQL statements in both production and development Environment.

Data cleansing, De duplication, and Data analysis with validation from data sources

Generating a report to keep a track of all the changes/updates made in the database.

Prepared SOPs for various activities.

DDL/DML queries are used to create/update the records.

Handling and resolving VSM Tickets created by the HCPs.

Ensuring that the data in veeva MDM matches the data in salesforce CRM.

Organization: ITC Infotech July 2015 to April 2016

Designation: Programmer Analyst

Worked for Ferrari World Abu Dhabi, which is a theme park located on Yas Island in Abu Dhabi, United Arab Emirates. It is the world’s first Ferrari-themed park and features Formula Rossa, the world's fastest roller coaster.

Assisted in data analysis and reporting for HR processes, Guest, revenue, sales of Merchandises and maintenance activities.

Collaborated with teams to gather and organize data for reporting purposes.

Created insights and dashboard, which shows the analytical data to the client as per the requirement.

Developed analysis reports and visualizations using DAX functions.

Designed Row Level Security to show only relevant data to the users.

Embedded Power BI reports into a web application built on .net and managed the access of reports to the individual users using roles.

Identified Performance bottlenecks and provided optimized solution for increasing the performance of BI Solutions and Report.

Contact this candidate