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.