Ramya Muraharishetti
Boston,MA
Summary
Having 6+ years of experience in driving end-to-end analytics projects through Problem Solving, Case Analysis, Story Telling, Dashboard Visualization Design and Development in the field of Database, Data Warehouse, Data Modeling and implementation for BI applications.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Analyst
CVS Health
Boston
09.2020 - Current
- Prepared data requirements, data models and transformation rules for new data warehouse structures, including summary information optimized for analytics
- Worked with technical teams to identify data sources
- Provided support to build new personas and trend Parts Planning KPIs for Client
- Identified areas to increase efficiency and automation of data-related processes
- Worked on analyzing client data using SQL, established project direction and presented visualized data analysis to client
- Identified deficiencies in existing data structure, and devised a comprehensive solution to better manage client data
- Day to day reviewed the existing data with the SMEs, determining what needs to be standardized, and going through each spreadsheet to standardize that particular element.
Business intelligence SQL Developer
Golden Touch Imports
New York
03.2018 - 09.2020
- Worked closely with BI team to develop data infrastructure to provide access to information and expand reporting capabilities
- Worked with Business Intelligence tools such as Tableau to develop reports and provide data to users
- Created and leverage analytical approaches to perform analysis of domain specific source data to provide accurate statements and conclusions
- Worked with senior management team and operation-level managers to design and maintain sales and operations based metrics
- Reviewed and evaluated the existing data sources and analyzed the conversion steps required
- Designed, developed and maintained SQL scripts, code, and queries for data translation, conversion and reporting
- Experience in designing data models, schemas, dimensional models, complex reports and dashboards
- Planned along with senior management new ways to increase revenue and minimize errors
- Developed and maintained/automated monthly campaign performance reports and helped in increasing the reporting efficiency by 60%
- Providing technical assistance to users and monitor performance of BI systems.
Business intelligence Analyst
VENTOIS Inc
Boston
05.2017 - 03.2018
- Involved in creating database objects like tables, views, procedures and functions using SQL to provide definition, structure and to maintain data efficiently
- Tested, Cleaned, and Standardized Data to meet the business standards using SQL task
- Created Tableau Dashboards and reports with interactive views, report scheduling using Tableau server
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
- Developed Tableau visualizations and dashboards using Tableau Desktop
- Restricted data for particular users using Row level security and User filters
- Developed Tableau workbooks from multiple data sources using Data Blending
- Published Workbooks by creating user filters so that only appropriate teams can view it
- Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports
- Created Procedures for in the Report Scheduler according to the monthly, weekly or daily
- Interacted with the existing database developers and DBA to understand the existing schema.
SQL developer
Serenus Information Systems
Hyderabad
10.2014 - 01.2016
- Monitored and tuned database resources and activities for SQL Server databases
- Performed and automated SQL Server version upgrades and patch installs
- Designed, developed and maintained relational databases
- Developed, implemented and maintained enterprise business information systems
- Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
- Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator
- Gathered business requirements and converted it into SQL stored procedures for database specific projects
- Maintained data integrity and database structure including tables, views, and triggers
- Worked with the application developers and provide necessary SQL Scripts using T-SQL.
Jr Data Analyst
WINIT Software Role
Hyderabad
05.2013 - 10.2014
- Contributed in ensuring all implementations consistent with Software Development Lifecycle (SDLC) standards
- Involved in understanding of data extraction, which involves Online Transfer Processing (OLTP) system and centralized database server
- Captured and documented business requirements for Data Warehouse System
- Involved in creating process flow diagrams for overall business specification
- Worked in conjunction with development team and senior management in preparation of data mapping reports, validation reports, and business reports
- Collaborated with data architect, business users, and developer team with validation issues and defects.
Education
MS - Information Systems
Wilmington University
Bachelor of Engineering - Electronics
Kakatiya University
Skills
- Professional Skills
- Methodologies:
- SDLC, Agile, Scrum, Waterfall
- Databases: SQL, MS Access, SQL server 2008
- BI Tools:
- Power BI, Tableau, Sequel Viewpoint, Micro strategy
- Domain Knowledge: Finance & Banking, Retail & Managed Services
- Utilities: MS Office Suite, MS Project, MS Visio, Share point, Advanced Excel
Certification
R PROGRAMING Introduction Certificate: UC-OFNB6JSU
MASTER COURSE IN TABLEAU 10 Certificate: UC-YRY0M9F8
Timeline
Data Analyst
CVS Health
09.2020 - Current
Business intelligence SQL Developer
Golden Touch Imports
03.2018 - 09.2020
Business intelligence Analyst
VENTOIS Inc
05.2017 - 03.2018
SQL developer
Serenus Information Systems
10.2014 - 01.2016
Jr Data Analyst
WINIT Software Role
05.2013 - 10.2014
MS - Information Systems
Wilmington University
Bachelor of Engineering - Electronics
Kakatiya University
Similar Profiles
Tanishia RatcliffeTanishia Ratcliffe
Shift Supervisor at CVS HealthShift Supervisor at CVS Health
Mohamed Elattar, PharmD, MSITMohamed Elattar, PharmD, MSIT
Pharmacy Manager at CVS HealthPharmacy Manager at CVS Health
Stephenie BornStephenie Born
Senior Service Advocate at CVS HealthSenior Service Advocate at CVS Health
Brianna BrewerBrianna Brewer
INVENTORY SPECIALIST at CVS HealthINVENTORY SPECIALIST at CVS Health
Gabriel G. FaheyGabriel G. Fahey
Head of North America Talent Acquisition at Straumann GroupHead of North America Talent Acquisition at Straumann Group