PAVAN KUMAR

+1-937-***-**** adxu6r@r.postjobfree.com linkedin.com/in/pavankumar1697/

PROFESSIONAL SUMMARY

• Proficient with strong analytical skills seeking Data Analyst role to contribute to data-driven decision making. Additionally, I have excellent analytical and problem-solving skills and am able to work col- laboratively with business users to understand their requirements and deliver solutions that meet their needs.

SKILLS

• Programming Languages: Python, MATLAB, SQL, SAP ABAP Netweaver 7.5, Java, C++

• Databases: Oracle Database, Microsoft SQL

• Data Warehousing: SAP BW 3.5

• Project Management: Confluence, JIRA

• Microsoft Office Suite: Word, PowerPoint, Excel, Outlook, Visio

• Data Visualization Tools: Microsoft Power BI, Tableau

• Soft Skills: Highly organised, Collaborative, Initiative-driven WORK EXPERIENCE

cbs Corporate Business Solutions America Inc. Devon, Pennsylvania, United States Consultant Aug 2022 - April 2023

• Gathered and analyzed 500000 rows of data to identify a 25 percent increase in sales in Q3 compared to Q2 and presented findings in a visual format using Tableau.

• Collaborated with the QA/QC team to document 20 processes and establish 10 KPIs that were aligned with the company’s global directives.

• Developed actionable roadmaps for optimizing the supply chain process that resulted in a 30 percent reduction in lead time and a 20 percent increase in productivity.

• Utilized technical expertise in SQL Server, Tableau, SSRS, and SSIS to design, developed, and main- tained a data model and database that analyzed customer behavior, resulting in a 15 percent increase in customer retention.

• Conducted a data quality analysis that identified inconsistencies in customer data and implemented best practices for data management, resulting in a 90 percent increase in data accuracy.

• Collaborated with cross-functional teams to provide feedback on new product features and enhancements, resulting in a 30 percent increase in user adoption.

• Documented best practices for data visualization and kept the internal Wiki up to date, resulting in a 50 percent increase in knowledge sharing across the organization.

• Environment: Python, SQL, NoSQL, NumPy, Pandas, Power BI, Tableau, Problem-Solving, Statistical Analysis, PostgreSQL, MS SQL Server

Accenture Solutions Pvt Limited Bengaluru, India

Associate Software Engineer June 2019 - Jan 2021

• 1.6 years of SAP BW/BI experience, which includes Data-Modelling, Data Extraction, Data Loading, Scheduling, Monitoring, and Reporting.

• Involved in Analysis, design, development of info cubes and ODS objects.

• Developed generic extractor based on view, ODS, transfer rules, communication structure, update rules, info packages, info cube, multiprovider and flat file data source.

• Automated data load processes, maintained BW statistics, did the roll up of BW aggregates using process chain.

• Analyzed and activate relevant business content and setup R/3, flat file and BW as source system.

• Reconciliation of data from various sources system.

• Uploaded master data and transaction data from files and SAP R/3 system.

• Using Business explorer (BEx) created custom queries based on the detailed query and business require- ment.

• Worked extensively on Data Warehouse workbench and customized Info objects, Info cubes, DSOs, Data Sources, Transformations, and Multi-Providers

• Set up periodic data loads from flat files

• Involved in extracting the data from external source systems like Banking (PB0)

• Installing and creating BI objects like Info-Objects, DSOs, and InfoCubes

• Creating and managing data flows using Direct Transfer Process (DTPs)

• Designed scalable data pipelines to extract OLTP data into the data warehouse for OLAP reporting.

• Creation of batch process and scheduling load jobs in parallel, process chain maintenance

• Monitored data loads from the source system to the BI system module

• Schedules DTP for loading transactional data (OLTP) from PSA to Info provider using process chains

• Support production system on data load performance and issues.

• Utilized Agile methodologies to develop high-quality software solutions for clients

• Skilled in data visualization tools such as Tableau and Power BI

• Involved in frequent client meetings to discuss project status

• Environment: BW 3.5, ECC 6.0, ABAP/4, Query Designer, BEx Analyzer

•

EDUCATION

Master’s in Computer Science Jan 2021 - May 2022

University of Dayton, Ohio, United States CGPA : 3.77/4 B.Tech. in Electrical and Electronics Engineering Aug 2015 - May 2019 Manipal Institute of Technology, Manipal, India CGPA: 7/10 PROJECTS

Sales Analytics 360: Exploring Online Sales Trends with Power BI Devon, United States

(2023)

• Skills Used: Microsoft Power BI, DAX Queries, Microsoft Excel, Data Management

• Created a interactive dashboard to track and analyze online sales data

• Used complex parameters to drill down in worksheet and customization using filters and slicers

• Created connections, join new tables, calculations to manipulate data and enable user driven parameters for visualizations

• Used different types of customized visualizations (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicers etc) IoT based smart environmental system Manipal, India

(2019)

• Skills Used: C/C++, ThingSpeak Cloud, IoT, Electronics, Application Development

• The Arduino-based microcontroller communicates with a variety of threshold sensor modules to effi- ciently manage light and aeration inside an environmental chamber by activating a cooling fan, water irrigation pump, and LED lights in response to the needed plant growth conditions.

• The live data is saved in the cloud and can be accessed via the user’s smartphone. Marycrest Dining Management System using SQL Oracle Express Ohio, United States

(2021)

• Skills Used: MySQL, Oracle Application Express, Application Development

• Used concepts of entities, attributes, cardinality ratios and representing the same in Entity-Relationship diagrams and relational schemas

• Mastered at creating tables, inserting data, and executing SQL (Structured Query Language) queries for our database using Oracle Application Express.

• Knowledge of database management systems such as Microsoft SQL Server, Oracle, and MySQL

• Design and development of application interface for Marycrest dining services using MIT App Inventor CERTIFICATIONS

• SAP Certified Development Associate - ABAP with SAP NetWeaver 7.50

• Microsoft Learning: Microsoft Office PowerPoint and Microsoft Office Word

• LinkedIn Learning - Essentials of SQL, PowerBI Essentials

• Sololearn: Python Programming

• Coursera: Excel Skills for Data Analysis

Contact this candidate