Open to opportunities

Rajesh kumar

@rajeshkumar5

Message

Experienced data consultant specializing in Microsoft Business Intelligence tools.

India

Message

What I'm looking for

I am seeking a role that offers opportunities for growth and innovation in data analytics.

With over 14 years of extensive experience in Microsoft Business Intelligence tools, I have honed my skills in SSRS, SSIS, SSAS, T-SQL, and Power BI. My proficiency in developing intricate ETL packages and crafting SSIS packages has enabled me to deliver high-performance solutions that meet complex business needs. I have a strong track record in creating operational reports, including Drill-through and Drill-down reports, and I excel in performance tuning and scheduling.

Throughout my career, I have demonstrated expertise in T-SQL development, creating complex queries, stored procedures, and triggers. My experience extends to optimizing databases through index creation and query optimization, ensuring data integrity and performance. I am also skilled in utilizing Power BI for crafting dashboards and reports, implementing custom visualizations, and leveraging DAX for data analysis. My commitment to excellence and continuous improvement drives my passion for data analytics and business intelligence.

Experience

Work history, roles, and key accomplishments

Current

Associate Consultant

Current

Wipro Technologies

Aug 2015 - Present (9 years 10 months)

Currently working as an Associate Consultant, focusing on database performance enhancement, creating stored procedures, and transferring transformed data. Skilled in utilizing dynamic variables for SQL statement generation and managing data flow tasks.

SQL Server SSIS T SQL ETL

Current

Data Consultant

Current

UHG

May 2023 - Present (2 years 1 month)

Responsible for creating stored procedures and enhancing database performance through indexing techniques. Focused on transferring transformed data and utilizing dynamic variables for SQL statement generation.

SQL Server T SQL ETL Stored Procedures

Associate Consultant

PF Changs

May 2019 - May 2023 (4 years)

Crafted SSIS packages for data transformation and employed various control flow tasks. Developed Type 2 packages and designed dynamic SSIS packages for ticket creation.

SSIS ETL SQL Server

Associate Consultant

ABB

Apr 2018 - May 2019 (1 year 1 month)

Generated bookmark reports and dashboards in Power BI, utilizing various visualizations and slicers. Established connections between tabular models and Excel.

Power BI Data Visualization Dashboards Excel Reporting

Associate Consultant

Bio-Rad Laboratories

Oct 2017 - Apr 2018 (6 months)

Developed KPI indicators and custom visualizations in Power BI. Designed dashboards and reports, including bookmark and toggle reports.

Power BI KPIs Dashboards Data Visualization Reporting

Associate Consultant

Effort Tracking System

Mar 2017 - Oct 2017 (7 months)

Generated Tablix reports and established scheduling for them. Designed drill-down reports and implemented various transformations for data extraction.

Tablix Reports Scheduling Reporting

Associate Consultant

Trade Compliance

Jun 2016 - Mar 2017 (9 months)

Produced Word and form-type reports, developed sub-reports, and executed the migration process from MS Access to SSRS.

Data Migration SQL Reporting

Associate Consultant

AJG

Dec 2015 - Jun 2016 (6 months)

Utilized SSIS to craft packages and transferred data post-transformation. Developed Type 2 packages and implemented dynamic variables for SQL statements.

SSIS SQL ETL Reporting

Associate Consultant

DICGC

Aug 2015 - Dec 2015 (4 months)

Consolidated data from various source systems and created ETL mappings for data transportation to the Operational Data Store.

ETL SQL Server Data Consolidation SSIS Data Mapping

Software Engineer (Analytics)

Skill Next Pvt Ltd

Feb 2011 - Jul 2015 (4 years 5 months)

Worked as a Software Engineer focusing on analytics, implementing various transformations in SSIS, and developing reports in SSRS tailored to end-user requirements. Engaged in performance tuning and query optimization.

SSIS T SQL Data Warehouse Performance Tuning

Software Engineer

FedBI

Jun 2011 - Sep 2013 (2 years 3 months)

Designed SSIS packages for data extraction and transformation. Analyzed business requirements and implemented tailored solutions using SQL Server Integration Services.

SSIS Data Extraction SQL Server ETL Business Analysis

Education

Degrees, certifications, and relevant coursework

Jawaharlal Nehru Technological University

Bachelor of Technology, Computer Science Engineering

2006 - 2010

Completed a Bachelor of Technology in Computer Science Engineering, gaining a solid foundation in computer science principles, programming, and software development.