Profileimage by Ravi Kumar MSBI, SQL Server and Power BI Developer from Bangalore

Ravi Kumar

available

Last update: 06.09.2022

MSBI, SQL Server and Power BI Developer

Graduation: MCA
Hourly-/Daily rates: show
Languages: English (Full Professional)

Attachments

Ravi_Resume.docx

Skills

I have 8 years of experiance in DW-BI using Microsoft stack (SQL, SSIS, SSRS, SSAS) and visualization tool using Power BI.

Proficiant  in SSIS: More than 6 years of exp
Proficiant  in SSRS: Having 5 years of exp
Proficiant  in SQL and T-SQL : Having 5 years of Exp
Moderate in SSAS and Power BI : Having 3 years of Exp

Exp in Development, Migration, Creation Agent jobs, Production deployment and support, Big fixing, Data Analysis

Project history

06/2016 - 10/2018
Analytics Advisory Specialist
Accenture


12/2015 - 06/2016
Senior Software Engineer
Viteos

Project #3: ASTTRA

Description: A combination modules ASTTRA is the premier lifecycle management tool that is
seamlessly integrated with Advent Geneva. Built on Microsoft technology, ASTTRA comprises modules
such as a customizable scheduler, a fully integrated ETL engine, and a web based reporting
dashboard. ASTTRA development puts technologists to be at the forefront of delivery.

Roles & Responsibilities:
* As a senior ETL developer in the application team to build ETL, SQL and Report design and
support.
* Created multiple SSIS packages to load daily basis Geneva and ASTTRA data.
* Created complex Stored Procedures, Triggers and cursors to support ASTTRA Applications.
* Created multiple SSRS reports and deployed to SharePoint server and calling from ASTTRA
application

06/2012 - 12/2015
Software Engineer
XLHealth

Project #4: CMS EOB Load and Extract

Description: CMS Explanation of Benefit (EOB) file extract will be produced using a compilation of
data coming from four sources namely CIP on Facets, Optum Behavioral Health, Avesis, and Optum Rx.
The production of the file extract will be done and provided to UPC on a monthly basis and in
automated fashion using SQL Job.

Roles & Responsibilities:
* Single point of contact for all EOB(Extraction of benefits) related data loads/extractions and
issues.
* Mainly involved in Creation of SSIS packages, SQL DB design and T-SQL development.
* Created the Packages in new versions like Package and Project deployment models and used
Integration catalogs for monitoring and scheduling.
* Involved in Deployment Activities, created jobs and scheduling the ETL packages at desired
frequencies using SQL Server agent jobs.
* Used multiple Transformations and various control flow tasks in SSIS to meet the Business
Requirements.
* Hands on experience in implementing Event Handlers, Logging, Checkpoints, Transactions and
package configurations.
* Created technical specifications, DLP (Desktop level process), HLD, LLD, Review& design
documents.
* Involved in review and unit testing and created review documents.
* Creating SQL objects like Tables, Stored Procedures, Views and Indexes.
* Altering and created indexes on necessary table columns as per the requirement.

Project #5: OptumBH (Optum Behavioral Health)

Description: This project is to assure that the eligibility file will include all members with 2010
eligibility onwards. For members active in 2010 with an effective date of earlier than 2010, this
earlier effective date should not be altered. This may be updated in the future to use a shortened
time frame of past eligibility spans with added fields particularly for OptumBH.

Roles & Responsibilities:
* Creation of SSIS packages, SQL DB design and T-SQL development.
* Created the Packages in new versions like Package and Project deployment models and used
Integration catalogs for monitoring and scheduling.
* Involved in Deployment Activities, created jobs and scheduling the ETL packages at desired
frequencies using SQL Server agent jobs.
* Used various Transformations and tasks in SSIS to meet the Business Requirements.
* Hands on experience in implementing Event Handlers, Logging, Checkpoints, Transactions and
package configurations.

Project #6: MOOP Automation

Phase 1: Optum Rx MOOP Claim load

Description: With the change CIP's of pharmacy vendor in 2014 from ESI to OptumRx (ORxPD) we must
load the daily claims Out of Pocket (OOP) data to Transactional Data Management (TDM). This will
enable monitoring whether a member has reached the plan's maximum out of pocket (MOOP) limit.
Phase 2: Optum Rx MOOP Claims extract toFacets

Description: OptumRx Part D sends a daily file to CIP containing Out of Pocket (OOP) claim
information. This is loaded to CIP's Transactional Data Management environment through automated
process Load_OrxMoopClaims. This data must be transformed into a file format that Trizetto can
accept and loaded to Facets OOP accumulators.

Phase 3: OptumRx MOOP Members extract to OptumRx PartD

Description: OptumRx Part D sends a daily file to CIP containing Out of Pocket (OOP) claim
information. This information is transferred to Trizetto daily where the OOP data is loaded to
Facets accumulators during the nightly scheduled batch. This accumulator data must be queried daily
for members who have met their maximum out of pocket limit (MOOP) and OptumRx must be informed of
members who have reached their MOOP.

Roles & Responsibilities:
* Involved in all three phases of development and created packages for Data load/Extracts using
SSIS.
* Mainly involved in Creation of SSIS packages, SQL DB design and T-SQL development.
* Created SSRS reports for end user as per requirements.
* Created complex logics to handle multiple areas in backend database.
* Hands on experience in implementing Event Handlers, Logging, Checkpoints, Transactions and
package configurations.
* Created technical specifications, DLP (Desktop level process), User test cases.

PROJECT 8#: Web Interface

Description: Web Interface (Exception Report) provides facilities to indicate minimum, maximum, Data
through date, Missing values on Load table columns. By using this Business user or process owner can
check the values in different table and related columns in metadata tables and also provides
information regarding the expected values for the related columns and by using this interface we can
track the related report for metadata load tables.

Roles & Responsibilities:
* Web interface application is use to track the Metadata of master tables information.
* Created SSRS reports to show the error occurrence and master table missing data.

Local Availability

Only available in these countries: India
Profileimage by Ravi Kumar MSBI, SQL Server and Power BI Developer from Bangalore MSBI, SQL Server and Power BI Developer
Register