Summary
Overview
Work History
Skills
Timeline
Generic

NETRAVATI TELKAR

Summary

  • IT professional with 6+ years of experience in SQL, TSQL, SSRS, SSIS, and Power BI.
  • Proficient in CRUD operations and writing SQL queries.
  • Skilled in developing SSIS packages for ETL processes, including tasks such as aggregate, conditional split, merge, fuzzy lookup, data conversion, and derived columns transformations.
  • Strong background in creating reports using SSRS and Microsoft Power BI Report Builder, including paginated, ad-hoc, and matrix reports.
  • Experienced in designing Power BI reports and dashboards using the Power BI platform.
  • Adaptable in modifying SQL scripts to meet the requirements of Power BI and SSRS reports.
  • Proficient in Power BI visualization, Power BI data modeling, and DAX.
  • Collaborated with clients to understand business requirements and provided solutions.
  • Extensive database programming experience in writing SQL & TSQL, User Defined Functions, Stored Procedures, Triggers, Views, CTE, constraints, and Indexes.
  • Advance level Experience to develop Paginated Report in SSRS & Power BI Report Builder.
  • Actively contributed to MS SQL Server back-end database technology.

Overview

9
9
years of professional experience

Work History

Business Intelligence Developer

ESPIRE INFOLAB PVT.LTD
Gurgaon, Delhi (Remote)
08.2022 - Current

Domain - Logistics

Project Responsibilities:

  • Extensively worked on SSIS tool suites, designed & created mappings using various SSIS transformation like OLE-DB command,Conditional Split, Lookup, Aggregate, Multicast, Data Conversion & Derived Column transformations.
  • Hands on Experience on SSIS ETL experience to develop data interfaces for extracting, transforming and loading data into data warehouse/SQL Server destination using SQL Server procedures to read data from Multi formatted Flat files, Excel etc.
  • Developed & deployed SSRS reports into the SSRS Reporting Server.
  • Experience in modifying the SQL Scripts & stored Procedures as per SSRS, SSIS and created single & multi-value parameters.
  • Designed and developed Power BI reports & dashboards in various formats like Charts, Tables, and Matrixes using Power BI Platforms.
  • Maintained comprehensive documentation of development work, facilitating knowledge sharing among team members.
  • Developed and published Power BI Reports into Power BI Services & Share point.

DWH/BI Developer

SURVIK SOFTWARE PVT. LTD
Pune, Maharashtra
05.2021 - 07.2022

Domain - Telecom

Project Responsibilities:

  • Developed (AD-hoc/ Parameterized) reports using SSRS as per Business requirements.
  • Developed & deployed SSRS reports into the SSRS Reporting Server
  • Experience in modifying the SQL Scripts & stored Procedures as per SSRS and created single & multi-value parameters
  • Designed and developed Power BI reports & dashboards in various formats like Charts, Tables, and Matrixes using Power BI Platforms
  • Developed (Paginated/Ad-hoc/Matrix) Reports using Power Bi & SSRS as per the requirement on Oracle & OLEDB server
  • Developed & Published Power Bi Reports into Power Bi Services
  • Experienced in modifying the SQL Script as per Power BI, and SSRS reports & also Created a multi-value parameterized, Matrix, Drill -down & Drill Through reports as per business requirements.
  • Holding Good experience in Power BI reporting, SSRS & Performance tuning.

IT Support Analyst

TATA CONSULTANCY SERVICES
Pune, MAHARASHTRA
03.2018 - 02.2021

Domain - Finance

Project Responsibilities:

  • Involved in creating tables with indexes sequences, views & performing join operations on multiple tables and performed CRUD operations.
  • Taken the initiative of updating the tracker report & fetching fresh reports by running SQL queries so the team gets to know which tickets are still in pending status & tries to fix it them on per priority basis
  • Work on Data marts and develop the data marts as per the requirements
  • Ensuring that client and end-user requirements were met for various projects
  • Work as part of a development team and establish close working relationships with stakeholders, quality assurance, architects, as well as management
  • Modifying existing reports using MS SQL Server Reporting Services (SSRS) 2017 and Report Builder
  • Participate in code reviews and documentation reviews
  • Develop mapping specifications and Source to target mappings
  • Attended daily status calls and took an active role in weekly service alert calls & problem-resolution meetings.

IT Support Analyst

TATA CONSULTANCY SERVICES
Pune, Maharashtra
09.2015 - 03.2018

Domain - Banking

Project Responsibilities:

  • Tracking Production data issues/Requests in the CallOneIt, ITIL tool
  • Identifying the Production issue, Analyzing and resolving with minimal client impact, and closing the raised tickets as per the SLA and correct standards.
  • Escalating issues within time to the vendors/partners to achieve proper solutions.
  • Worked as a quality checker, MIS.
  • Helped the team to achieve the quality target by doing an internal review.
  • Give process-related training for new joiners
  • Meeting daily targets and maintaining 100% quality at work.
  • Worked on various reports
  • (MIS, Attendance Tracker, Productivity/quality report)

Skills

Tools:

  • Microsoft Power BI Desktop
  • Microsoft Power BI Reporting
  • SSMS (Version 2017, 2018)
  • SSRS
  • SSIS (ETL)
  • Visual Studio 2019
  • JIRA
  • CallOneIT
  • ITIL
  • Jenkins
  • Git

Databases:

  • MS SQL Server 2017
  • PhpMyAdmin
  • Oracle SQL Developer

Languages:

  • SQL
  • T-SQL
  • PLSQL

Other IT Skills:

  • Data warehouse

Highest Education:

  • 2015 - Bachelor of commerce (Corporate Secretaryship) Karnataka University 77%

Achievements:

  • On Spot Award in Espire Infolab Pvt Ltd

Timeline

Business Intelligence Developer

ESPIRE INFOLAB PVT.LTD
08.2022 - Current

DWH/BI Developer

SURVIK SOFTWARE PVT. LTD
05.2021 - 07.2022

IT Support Analyst

TATA CONSULTANCY SERVICES
03.2018 - 02.2021

IT Support Analyst

TATA CONSULTANCY SERVICES
09.2015 - 03.2018
NETRAVATI TELKAR