Data Power
Resume:
Ravi Kumar
Batta
Business Intelligence
Professional
Personal Info
Address
***** ***** ******, ******** ****,
KS, 66213
Phone
**********@*****.***
Date of birth
https://www.linkedin.com/in/ravi-
kumar-batta-024707125/
Skills
Business Intelligence (BI)
Extract, transform, load (ETL)
Power BI
Tableau
SSIS/SSRS/SSAS
Microsoft Azure
Data Visualization
Data Analytics
Data Modeling
Data Analysis/Architecture
Dashboard
Azure SSAS
Azure Data Factory
Over the last 5+ years, developed multiple high-level Power BI, Tableau models & report deliverable to upper-level business groups & the firms largest clients. Ability to demonstrate great communication & product knowledge skills. Proven leadership gained the creation of SME role working directly along side clients as product & data liaison to expand the business.
•
Around 10+ years of IT experience in the SDLC which includes Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, UNIX & OLAP using Agile Scrum/Kanban Methodologies.
•
Collaborate with Project Managers, Data Analysts & Developers for a wide range of projects to clearly define specific business needs, expectations, timelines & execution methods, which are clearly communicated to specific business groups
•
Understanding of Business Model development using different functionalities like Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Function using Business Intelligence tools.
•
Experience in designing Star, Snowflakes schemas and database modeling in OLTP/OLAP environment and Data Warehouse.
•
Extensive experience in SQL Server Analysis Services Tabular model Cubes, and Data Mining on MS SQL Server 2016/2014/2012/2008 R2
•
Performed Database optimization, debugging and refining using the Query Analyzer, SQL Profiler and SQL Server Debugger.
•
Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, Power BI, Tableau, AAS, Azure Data Lake and Azure Data Factory
•
Designed and developed matrix, tabular, Chart, Graph, Linked, Cascade, drill down, drill through reports using SSRS.
•
6+ years experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
•
Expert in Data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and IBM data stage.
•
Applied technical skills using Power BI, Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner
•
Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis
•
Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files using SSIS.
•
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production. Experience
2018-01 -
present
Senior BI Consultant
Smithfield Foods, Kansas City, MO
Gathered report requirements and determined the best optimal solutions to provide timely results via Power BI reports and Dashboards.
•
Configure Business Intelligence and reporting system effectively by implementing security filters and roles at the corporate, department and individual levels of the organization in Power BI.
•
Led the data discovery sessions by interviewing source system owners, analyzing and investigating source data.
•
Installed and configured Power BI Desktop, Power BI service, Data gateways, apps, workspaces. Created different workspaces for Dev, QA and PROD environments for reports/dashboards and published them into the apps.
•
Created conditional columns, custom columns using M query and calculated columns, measures using DAX functions.
•
Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, merge queries, append queries,
•
Azure Data Lake
SQL
Cross Functional team work
Coping with deadlines pressure
Client Relationships
Query Writing
Data Mining
Data Management
Multi Tasking
Developing complex multi data source
queries
Data Warehouse
Problem Solving
Agile Methodologies
Data Integration
DAX
Microsoft Excel
Oracle
Analytical Skills
Microsoft Office
JIRA
Data Preparation
Service Now
Anaplan
replace values, split column, group by, Date & Time Column, etc. Develop and Implement SQL Server Reporting Services Reports (SSRS) Develop and maintain cubes, dimensions and measures using Analysis Services (SSAS).
•
Developing and maintaining ETL (SSIS) packages for the importing and organization of the BI data.
•
Created detail Technical documentation of various reports/dashboards for future reference and guidance. Created report analysis using Vertipaq Analyzer.
•
• Worked on a POC for AAS, Azure Data Lake and Data Factory 2016-05 -
2017-12
Sr. BI/ETL Consultant
USDA, Kansas City, MO
Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2014, and Flat files.
•
• Involved in the migration of SSIS packages from 2008 to 2014 server. Created Power BI reports and dashboards in Power BI Desktop and published to Power BI service.
•
Worked on cleansing and data ingestion in Power BI Desktop and created effective data model.
•
Deploying the reports and dashboards in multiple environments and setting up the gateway for the data sources in Power BI service.
•
Created parameters, calculated columns and measures. Used DAX extensively in creating measures.
•
Created security on the data by creating roles in the datasets and assigning them with their level of access to data.
•
Involved in creating deployment plans and moving the SSIS packages from DEV to CERT and PROD environments.
•
Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
•
Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
•
Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
•
Involved in Normalization and De-Normalization of existing tables for faster query retrieval and created indexes to the tables.
•
2015-10 -
2016-05
BI Developer
Mission Hospitals, Ashville, NC
• Involved in gathering the requirements and analyzing the requirements. Responsible for Preparing the Report Design specifications based on the User’s requirement.
•
Involved in Data modeling. Extracted data from various sources and performed data blending.
•
Creating Workbooks by Importing data, Defining Relationships. Developing, Designing and supporting interactive Tableau Dashboard reports.
•
Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps. Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
•
Connecting multiple data source with Data Blending technique. Providing the Security while Publishing to the Tableau Server.
•
Applied various types filters like Data source filters, Quick filters and Context Filters. Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
•
Executed and tested required queries and reports before publishing. Validate the data for each report and review the reports.4
•
Created tabular model cubes in SSAS. Used DAX for creating measures and calculated columns.
•
SAP BW
SAP HANA
EPIC
Communication
Technical Documentation
Report Development
Interpersonal Skills
Troubleshooting
Decision-Making
2014-09 -
2015-09
BI/ETL Lead
Mediware Information Systems, Kansas City, KS
Designed high level ETL/SSIS architecture for overall data transfer from the OLTP, files to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
•
Migrating Databases from SQL Server 2008 to SQL Server 2012 and documenting Up-gradation, Procedures from SQL Server 2008 to SQL Server 2012.
•
Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
•
Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
•
Designed and developed different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
•
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
•
2013-05 -
2014-08
Sr. Reporting Analyst
Stanford Health Care, Palo Alto, CA
As a Report Writer, I was responsible for defining Report Requirements, Design, Develop, Test and validate the new report requests from users.
•
Developed reports using SSRS and crystal reports and used table control, matrix control for cross tab reports. Validated all Clinical Reports and Decommissioned which are not in use.
•
As part of my job, built different reports using tools like Epic Hyperspace for understanding the requirement, Data Models – to understand where the chronicles data is stored in clarity tables, Data Dictionary - to understand the definitions of the tables, Crystal Reports – for building the report as per the requirement, & SQL Server – writing SQL queries, Views & Stored Procedures.
•
Have a very good overall exposure to clarity reporting Inpatient, Ambulatory, ADT Reports.
•
Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS. Developed an automated report subscription process using SSRS.
•
Created Lab test results reports. Developed yearly, quarterly, monthly test reports and volume reports
•
2011-08 -
2013-05
BI Analyst
University of Houston, Clear Lake
2009-06 -
2011-07
Test Engineer
Alam Infotech
Education
2011-08 -
2013-05
University of Houston - Clear Lake, Houston, TX. Masters in Software Engineering
Certificates
2018-10 Analyzing and Visualizing Data with Power BI 2017-11 Certified Tester Foundation Level (CTFL)
2017-02 Salesforce Certified Administrator
2016-07 Salesforce Certified Platform Developer I
Contact this candidate