Ankit K.

Ankit K.

A productive professional with 7.5 years of proven expertise in MSBI and Visualization Development

Bengaluru , India

Experience: 7 Years

Ankit

Bengaluru , India

A productive professional with 7.5 years of proven expertise in MSBI and Visualization Development

121513 USD / Year

  • Notice Period: 90 Days

7 Years

Now you can Instantly Chat with Ankit!

About Me

A productive and creative professional with 6+ years of proven expertise in MSBI and adept Visualization Development

Team player with strong analytical problem-solving capability. Quick learning ability combined with excellent technical, c...

Involved in the Analysis, Design, and Coding; Unit Testing and preparing Unit test cases; bug fixing and production support

Interacting and dealing with clients as part of EY's R&A CoE team as well as communicating effectively with customers as part of the Cognizant's MSBI CoE Team

Training new joiners thoroughly on SQL, SSIS, SpotFire and Power BI

Show More

Portfolio Projects

EDS – DGA

Company

EDS – DGA

Description

This project is responsible for applying business logic to perform cleansing, standardizing and removing redundant data according to the client requirement. The transformed data is loaded into database and is used to generate valuable and intelligent reports. This process is done by using SSIS, SQL Server and Power BI, Spotfire. Duration: July 2018 till date Tools: SQL Server 2012/2017, Visual Studio 2015, ETL Tool – SSIS, Visualization Tools – SpotFire, Power BI Roles and Responsibilities: • Developed SSIS Packages for migration, data pull from multiple sources and complex transformation, cleaning and analyzing data and bulk data load. • Experience in performing profiling over data, data quality checks using Data Insight and Address cleansing transforms. • Primary role was to ensure the preparedness of data before go-live (Country / Company code wise) by running data governance checks as part of Full Dress Rehearsals. • Performed checks on production data and co-ordinate with respective teams to highlight the data anomalies • Worked on POCs for Postal code format checks, name standardization and phonetic checks. • Worked on end-to-end implementation of dashboards which includes analysis, design, development and presentation as per client requirements • Developed multiple SpotFire dashboards for deriving business insights and to provide predictive analytics capabilities • Developed multiple Power BI dashboards to create interactive visualizations for analysis of data from multiple sources to provide trends and predictive analysis. Provide story telling feature to understand data transformation over a period of time. • Involved in writing stored procedures triggers and views. • Worked on deployment of SSIS Packages to a third party scheduler – Control

Show More Show Less

Tools

SQLite

PHM, RCM

Company

PHM, RCM

Description

PHM’s main goal is to gather, normalize and analyze clinical data across a patient’s many care settings that can reveal opportunities to improve patient’s health and provider’s financial outcomes. RCM unifies the business and clinical sides of healthcare by coupling administrative data, such as a patient's name, insurance provider and other personal information, with the treatment a patient receives and their healthcare data. The objective is to support data aggregation, data governance and data analytics along with providing reporting capabilities necessary for compliance and provider incentives.

Show More Show Less

Tools

SQLite

ILM (Identity Lifecycle Mgmt.):

Company

ILM (Identity Lifecycle Mgmt.):

Description

An Internal project in development for provisioning, de-provisioning and maintaining identities and their entitlements across the systems. This HR system handles the life cycle of an employee from the date of on boarding to off boarding in an organization. This process involves three main modules like Provisioning, Secondary provisioning and De-provisioning. Duration: Nov 2015 to December 2016 Tools: SQL Server 2008R2, Visual Studio 2008, MSBI Tools (SSIS, SSRS). Roles and Responsibilities: • Involved in analysis, design, coding, and maintenance. • Developed SSIS ETL Packages, SSRS Reports. • Involved in Database Design of the Application and Writing Stored Procedures, Triggers, Views • Involved in Unit Testing and preparing Unit test cases.

Show More Show Less

Tools

SQLite