Power Bi Sql Server

Bablu kumar jha

Phone No: +91-970*******

E-Mail ID: ******************@*****.***

Objective: Seeking a challenging role in SQL development, Business Intelligence (BI), and support, where I can leverage my expertise in MS SQL Server, T-SQL programming, database optimization, and ETL development using SSIS. Skilled in multiple SSIS transformations such as Derived Column, Character Map, Copy Column, Merge, Merge Join, Export/Import Column, Audit, and Sampling, including data export to CSV. Eager to further enhance my skills in data modeling, reporting, and Power BI to support data-driven decision-making in a dynamic enthronement. PROFILE SUMMARY:

• Having around 5 years of IT industry experience in MS SQL Server, T-SQL development, reporting, enhancements, and application support, along with 1 year of experience in SSIS (ETL development) and Power BI reporting.

• Strong expertise in SQL programming, including writing complex queries, stored procedures, triggers, functions, sub queries, and performance tuning for database optimization.

• Experienced in database design, normalization, indexing strategies, constraints, and creating views and joins to improve query performance and maintain data integrity.

• Skilled in analyzing and debugging SQL procedures to enhance performance and support business- critical reports and applications.

• Hands-on experience in SSIS package design and development for data extraction, transformation, and loading (ETL) from multiple data sources.

• Worked with several SSIS transformations, including Derived Column, Copy Column, Character Map, Percentage Sampling, Row Sampling, Audit, Export Column, Import Column, Merge, and Merge Join, and data export to CSV.

• Proficient in Power BI report and dashboard creation, including bar, line, area, matrix, and table visuals, following best practices for visualization and performance.

• Experienced in creating and managing Power BI workspaces, publishing reports, building dashboards, and assigning access roles to users.

• Adept at analyzing business requirements, delivering optimized SQL-based solutions, and supporting data- driven decision-making across business units.

ACADEMICS:

MCA from vasavi college of engineering affiliated from O.U Hyderabad in the year 2016 with 52%

TECHNICAL SKILLS:

• BI and Reporting Tools : POWER BI.Logi studio (12.7.367-SP7),Visual Studio(2017), SQL Server Management Studio, Power BI Desktop

• Databases: SQL Server, T-SQL (Joins, Subqueries, Stored Procedures, Views, Indexes, Performance Tuning, Transactions)

• ETL Tool : SSIS (Data Extraction, Transformation, Loading, Derived Column, Copy Column, Character Map, Percentage Sampling, Row Sampling, Audit, Export Column, Import Column, Merge, Merge Join.) PROFESSIONAL EXPERIENCE:

. Worked as a senior Product Developer for Culinary Digital Pvt Ltd Pune from may 2025 to August 2025

. Website: https://culinarydigital.com/

• Worked as a Software Engineer at Priyasharma Software Pvt. Ltd. from November 2020 to May 2025.

• Website: http://www.piltd.com/

PROJECTS:

Project 1:Project - Culinarysuite(Menu&RecipeManagementSystem) Role: Senior Product Developer

Duration: May 2025 to august 2025

Technology:-Ms sql server Database

Project Description:-A comprehensive application designed for dietitians and menu planners to efficiently manage recipes, create and adjust menus, and generate nutritional and cost analysis reports. The system helps automate complex calculations, reduce manual work, and ensure accurate and consistent reporting across different business units

Roles & Responsibility:

Developed and optimized stored procedures for key reports (e.g., Nutritional Analysis, Cost Analysis, Week at a Glance).

Collaborated closely with QA and product teams to validate calculations and resolve data-level issues.

Developed and debugged SQL scripts and stored procedures for efficient data extraction, transformation, and error handling.

Analyzed SQL performance bottlenecks and applied indexing strategies to improve execution speed.

Assisted in Power BI report data integration and troubleshooting SQL datasets used in dashboards. Project 2:Project - NavRisk claims (David Corp -US) Client: ventive Technology

https://www.ventivtech.com/

Role: Software Engineer

Duration: November 2023 – April 2025

Technology: Windows 10, Power BI, SQL Server as a Database. Project Description:NAVRISK is afull-service riskmanagement and insurance software solution currently in production with various Insured Organizations, and Risk Pools. NAVRISK has helped clients dramatically reduce their cost per claim, cut administrative costs in half and recognize six- figure operational savings through automated workflow, a sophisticated business rules engine and integrated core systems. NAVRISK is a which integrates claims, policy and reporting to help organizations improve operations, reduce expenses, increase productivity and enhance agent and customer satisfaction. Roles & Responsibility:

• Extensively used Table Type and Object types for General Insurance Portal Developments.

• Analysis, design, develop, coding and documentation for the requirements.

• Developed Server-side T-SQL (Stored Procedures) for implementing complex business logic.

• Attended Client and QA meetings.

3.Project - CRM (Customer Relationship Management ) Client name - https://crm.psplhyd.com

Environment: SQL Server 2019,

Project Description: The CRM Solution project involves developing and maintaining a Customer Relationship Management system to enhance the management of customer interactions and data throughout the customer . The project aims to improve business relationships, assist in customer and drive sales growth by automating and integrating customer-related processes.

Roles & Responsibility:

• Design, development, and implementation of database structures to support CRM activities

• Working on ETL processes using SSIS to extract, transform, and load data from multiple sources into the system

• Created and optimized T-SQL scripts for data manipulation and reporting

• Developed complex queries, stored procedures, and views to support analytical and operational reporting.

• Collaborated with business users and developers to understand requirements and deliver database solutions aligned with business needs

4.) Project - CINC System

Client Name -https://cincsystems.com/

The objective of the project is Requirement Analysis, Design, Development, Design Report. Tools Used: Logi Studio 12.7.367-SP 7, SSMS 2016

Project description:

CINCwas built as an association management solution and is designed to solve the biggest challenges faced by growth-oriented association management companies. CINC aims to increase financial transparency to boards so they can make more informed, timely decisions. Plus, It enables direct access to association information like the status of violations or A/R, streamlines communication, and leads to more satisfied homeowners Roles & Responsibility:

Requirement Gathering and understanding Business and support the Application.

• Analysis, design, develop, coding and documentation for the requirements.

• Develop the reports and dashboard help of Bi. Delivered the reconciliation files after every migration.

• Involved in preparation of Technical Design documents based on functional specification, making of technical unit testing and source code review.

Contact this candidate