Rajeev Kumar

Rajeev Kumar Email Id: - Contact No: (- LinkedIn: https://www.linkedin.com/in/rajeev-k-219401b8/ Objective A detail-oriented Business Intelligence Developer with 2 Years of experience seeks the opportunity to join your company and work cross-functionally to design, develop and deploy strategies for your business intelligence environment Professional Summary With 1 Year 11 Months of Experience in design, analysis, development and implementation of various applications in environment using Tools like Power BI , Microsoft Azure ,Pentaho , Kettle, MSBI(SSIS,SSAS,SSRS) . Strong knowledge of SQL Database(SQL Server, MySQL ) , Data Modeling, Data warehouse(concepts like Star schema, Dimensions and Fact tables), OLAP Cube , Data Visualization and DAX(Data analysis Expression) etc. Have created the Various Report and Dashboard by Using Power BI and SSRS and also implement the techniques Like Scheduling , Managing the report , Role based Access . Experience in delivering Business Intelligence and data warehouse solution in various tools. Professional Experience Worked at Analyticsquad4 Pvt. Ltd , Whitefield , Bangalore(August- 2018 May 2019). Currently Working in Acuvate Software Pvt. Ltd (Sept 2019 – present) Project Experience Project #1: Client & Location:ERX-India Project Name:AyurEHR–Healthcare Environment:PDI for ETL, PRD for Reports and CDE for dashboard Duration:AUG 2018 – DEC 2019 Description: Erx-India is one of the Healthcare company in Bangalore. This project is mainly consist for Reporting and dashboard part. Made various reports and dashboards .AyurEHR is a Cloud-based hospital management software for Ayurveda. Digitize each patient's healthcare experience using Ayurveda Software that is specifically designed for Ayurveda Clinics and hospital. Roles and responsibility Extracted the data using Pentaho Data Integration Designer from the flat files, creating dashboards in Pentaho BI Server and other RDBMS databases like MySQL DB into staging area and populated onto Data warehouse. Collaborated with Database Administrators, Developers, and Analysts on all aspects of data management. Monitor all aspects of organizational business engagements, both internal as well external, to ensure that the interfaces are developed and delivered to meet ETL standards and best practices Loaded monthly, weekly, daily data, to track issues and resolve them based on the priority. verifying the code in mappings sheet and also verify the naming conventions in ETL transformations/Jobs. Writing SQL queries to develop the ET .Collect, store, and retrieve business data for analysis and reporting. Designed multiple reports through Pentaho Report Designer Implementation of ETL using Pentaho Data integration. Define the scope, use, and requirements of business data warehousing and Monitor and troubleshoot jobs and also create jobs as per client requirement. Project #2: Client & Location:Land foundry Project Name:Profit-Run Environment:PDI for ETL, MySql Database Duration:January 2019- April 2019 Description:This project has three layer architecture and totally stock based project. The application takes the data from source and automatic process the data on hourly , daily And weekely basis. Processing of data is happening through predefined procedure and functions and data shows it on the dashboard. Roles and responsibility Extracted the data using Pentaho Data Integration Designer Kettle from the flat files and other RDBMS databases like MySQL and PostgreSQL into staging area and populated onto Data warehouse. Collaborated with Database Administrators, Developers, and Analysts on all aspects of data management. Define the scope, use, and requirements of business data warehousing and Monitor and troubleshoot jobs and also create jobs as per client requirement. Monitor all aspects of organizational business engagements, both internal as well external, to ensure that the interfaces are developed and delivered to meet ETL standards and best practices Loaded monthly, weekly, daily data, to track issues and resolve them based on the priority. Solve technical problems related to data and guide team members and Collaborated with business users, understood and delivered their reporting needs. Project #3: Client & Location:Seadrill Project Name:HSE Daily Status Report. Environment:SSRS ,MSSQL database, Duration:Sep 2019 – Jan 2020 Description: This project is Related to Health Safety and Environment (HSE) , where data is coming on daily basis for different region , it has multiple database from where data was coming .Created the SSRS on top of that for the daily Status of the Health Safety and Environment. Roles and responsibility Extracted the data from Multiple Source and combined it and created the SSRS Report on top of that . Define the scope, use, and requirements and Monitoring and management of the report and also create jobs as per client requirement. Managing and Scheduling of Report and Created different user group and different roles for the user. Provide the E-MAIL data rendered Report to the User . Project #4: Client & Location:NYC Project Name:HR Data Mart , Reporting and Dashboard. Environment:Azure Cloud Data Bricks , Power BI, Azure Analysis Services, Duration:Feb 2020 – July 2020 Roles and responsibility Used Azure data bricks for ETL . Did Data Modeling for creating Facts and Dimensions. Created SSAS Tabular Model and made Relation between Facts and Dimensions Used Azure Analysis service for deploying Cube . Created Reports and Dash Board using Power BI. Description: This project is related to HR data where we took data from various sources like flat files, Excel, CRM etc. as Sources .We converted csv file to parquet file and did data modeling for creating fact and dimensions . We stored all the data in data warehouse and made Tabular SSAS Cube and created relation between thee tables .and deployed to the Azure analysis services .After that we used analysis services as source for power BI and created Reports and Dashboard on top of that. All the report are User friendly and also simple visually so that any one can used that reports. Project #5: Client & Location:ABInBev Project Name:CMD(Customer Management Dashboard ) . Environment:Sharepoint , PowerBI, DAX Expression Duration:Aug 2020 Roles and responsibility Pulled data from Share point Folder as a source for Power BI Have done the Data Modeling for creating Facts and Dimensions. Created Reports and Dash Board using Power BI publish on Power BI Services. Created the RLS for the different user Group and Scheduled the report . Description: This project is related to the Customer Management System, where customer Request is created in SAP and generated the Audit log for the report generation .I have used Power BI for Visualizing the Data and created the dashboard for daily tacking of Customer for the request. Academic Background. Degree Discipline Institute Academic Year/Period Percentage B.Tech Computer Science Engineering Government College of Engineering and Technology, Bikaner- Senior Secondary (XII) Science Stream (PCM) Bihar School Examination Board - High School(X) General Stream Central Board of Secondary Education-CGPA DECLARATION: I hereby declare that all the information I have provided is correct to best of my knowledge and I Bear the responsibility of the correctness of above mentioned particulars. Place:- Bangalore (Signature)