Power Bi Sql Server

Manjeet Kumar

Mobile: +91-808*******

E-mail: *******.*******@*****.*** Github LinkedIn NovyPro Address: B-301, Ganesh Heights Near Laxmi Nivas, Narol, Ahmedabad, Gujarat - 382405 Summary

Experienced Software Developer with over 13+ years of overall experience, including 9+ years as a SQL Developer/Business Support Engineer and 3+ years in software design and development. Skilled in database development, data integration, report generation (Analytical, Sales, KPI, etc.), and automation using tools such as MS SQL Server, Power BI, SSIS, SSRS, SSAS, Power Automate, and Excel. Proficient in developing web and client-server applications using C#, ASP.NET, ADO.NET, LINQ, MVC-5, Web API, and front-end technologies like HTML, CSS, and JavaScript. Known for strong analytical abilities, quick learning of new technologies, and excellent communication skills. CERTIFICATION

Data Analyst Business Intelligence: Python, BI, Tableau,SQL

Codebasics Challenge #6: Provide Insights to the Marketing Team in Food

Codebasics Challenge #9: Analyse Promotions and Provide Tangible Insights to Sales Director

Codebasics Challenge #10: Analyse historical IPL data and provide insights on IPL 2024 for a sports magazine

Technical skills:

ETL Tool: - SSIS, SSAS

Languages: knowledge of Python, .NET, C#

Visualization Tool: Power Bi, SSRS, MS Excel, Tableau Databases: SQL Server 2022,SQL Server 2019, SQL Server 2012, SQL Server 2008 Development Tools: Visual Studio.NET 2005/2008/2010/2017/2019 Work Experience

PreEminence Technology Nov 2024 to Present

Project: - Infucare Rx Health(USA-based healthcare platform) Role: - Sr.Consultant (SQL and Power bi)

o Collaborate on projects that streamline infusion therapy by enabling seamless coordination between patients, prescribers, payors, and partners. o Design, optimize, and maintain complex SQL queries, scripts, and stored procedures; perform in-depth database analysis, troubleshoot performance issues, and support data integrity. o Develop automated workflows using Power Automate to export SQL and Power BI reports

(pipe-delimited format) to SFTP servers, with automated email delivery to stakeholders. o Work cross-functionally with product, sales, operations, and business teams to gather requirements and deliver actionable insights via reports (Analytical, Operational, Sales, KPI, Monthly/Quarterly, and Project reports) using MS SQL Server, Power BI, Power Automate, SSIS, and Excel.

Kanix InfoTech Pvt. Ltd. Sept 2023 to 28 Oct 2024

Project: - Highrise ERP (Construction industry)

Role: - Sr.SQL Developer

o Create and optimize complex SQL queries, scripts, and stored procedures; analyze databases to identify and resolve performance issues and ensure data accuracy. o Collaborate directly with clients to gather reporting requirements, analyze data sources, and transform raw data into actionable insights by building analytical, operational, sales, product, internal, project-based, periodic (monthly/quarterly), and KPI reports using MS SQL Server, Excel, Power BI, SSIS, SSRS, SSAS, and Data Warehouse solutions. o Perform SQL performance monitoring, query tuning, and implement enhancements to improve system efficiency and report reliability.

o Support and document approved changes in SQL logic for reporting and assist support teams by maintaining consistency, accuracy, and traceability in reporting processes. Briskstar Technologies, Ahmadabad Oct 2019 to Aug 2023 Project: - Vehicle Insurance project

Role: - Sr.SQL Developer and Business Support Engineer o Working for Tameeni.com, which is Saudi Arabia and UAE based Insurance Aggregator platform, where I am involved in Vehicle and Vehicle Lease Insurance projects. o My work mostly involves create & optimize SQL queries-scripts-store procedures, analyze database, research, troubleshoot and resolve issues in SQL as well as generate reports based on various requirements.

o Coordinate with other teams to understand requirements then analyze database and convert raw data into actionable insights by generating reports such as Analytical, Sales, Operational, Product, Internal, Project, Periodic reports like monthly/quarterly reports and KPI reports using MS SQL, Excel and Power BI,,SSIS, SSRS,SSAS,Data warehouse and Excel. o Performance monitoring, query tuning, improving efficiency and enhancements. o Supporting and documenting the implementation of approved changes in SQL queries, used for various reports and developer/aggregator teams. Techno Brain I.T Solution Pvt Ltd, Ahmadabad Feb 2019 to 16 Oct 2019 Project: - Healthcare project

Role: - Sr. Software Developer

Technical Environment: SQL Server 2012, SSRS, Swagger, .net Core Responsibilities: -

Create SSRS Report and configure with project

Create API with Swagger and Asp.net core for account projects Projects Undertaken:

MCOP Healthcare Project: Create Reports in SSRS for Payer and Provider side and configure reports with project

New Horizon Account Project : Create API for (Account and customer master and admin Portal) using swagger and Asp.net core

Jin core soft, Mumbai. Jan 2014 to Feb 2019

Project: - Marketplace

Role: - Sr.Net Developer

Technical Environment: ASP.Net, HTML5, CSS3, SQL Server 2008, Web Services, C# Description: -

Responsibilities: -

Involved in Requirement gathering and design document.

Developed web forms in ASP.NET using C# as the code-behind language. And ADO.NET as the SQL data consumer.

Used ADO.NET objects such as Data Adapter, Data Reader, Datasets and Data List for reading/updating records in the database.

Developed accordion control with Data List controls.

Developed master pages.

Involved in creation of stored procedures in MS SQL Server 2012. Projects Undertaken –

www.printurgent.com, www.expandurbusiness.com, www.jincoresoft.com, www.expandurbusiness.com, www.designurgent.com, www.infoeyeshost.com, www.shintrewadi.com, completesolutions.co.in, www.findlocalprinter.com, Inventory Management System

Various Companies, Mumbai. July 2010 to Dec 2013

Companies: WOW Retail VSOFT Services Info eyes Solutions Legal Media Group Designation: - Web Developer

Platform – MSSQL/ Asp.net/C#/Joomla/SSRS

Responsibilities:

Developed and Maintain different Websites.

Worked in Front-end Technologies: Asp.net/C#/Joomla/SSRS

Back-End Technologies: Involved in creation of stored procedures SQL (Structured Query Language), T-SQL (Transact-SQL), Database Development, Database Design, Stored Procedures, Triggers, Views,Indexes,Performance Tuning, Query Optimization, Data Modeling, Relational Database Management Systems (RDBMS) in MS SQL Server 2008.

Educational Qualifications

B.E. (Computer Engg.), from Laxmi Devi Institute of Engg. & Tech., Alwar, Rajasthan University with 64.64% in 2009.

12th (PCM) from Rajasthan Board with 56.62% in 2005.

10th from Rajasthan Board with 68.83% in 2003.

DATE: (Manjeet kumar)

Contact this candidate