Post Job Free

Resume

Sign in

Data Power

Location:
Kansas City, MO
Posted:
March 30, 2020

Contact this candidate

Resume:

Ravi Kumar

Batta

Business Intelligence

Professional

Personal Info

Address

***** ***** ******, ******** ****,

KS, 66213

Phone

505-***-****

E-mail

adci4d@r.postjobfree.com

Date of birth

****-**-*0

LinkedIn

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