Data Analyst Sap

ZUHAIB ALI RAJA

*************@*****.*****.*** 662-***-****

Authorized to work for any employer (STEM OPT)

SUMMARY

Data Analyst with 6+ years’ experience with a solid understanding of Business Analytics and Engineering in the Banking, Retail, Supply Chain, and E-commerce industry by implementing To-Be systems

Possess ability to execute change by implementing modern analytical techniques with using supervised, unsupervised and reinforcement learning algorithms in machine learning with statistical modeling.

Possess complex knowledge of business analytics, SDLC approach and data management technologies including R, SQL, Excel and SAP modules (WM, FI, HCM, MM, SD, PP) and other IT tools.

Sophisticated knowledge in Machine Learning techniques (Decision Trees, Linear Regressions, Random Forest, K- Nearest Neighbors) and Statistical Modeling in Forecasting/ Predictive Analytics, Regression, ARIMA, Time Series based models.

Extensive working experience with R and Python packages including ggplot2, lattice, forcast, dplyr, rpart, ipred, caTools, numpy, panda, matplotlib, scikit-learn, random forest for manipulating, handling data and developing machine-learning and statistical models.

Experience in Software Development Life Cycle (SDLC) using Agile Methodology

Proven expertise in creating Test plans, Test Scenarios, Testing Approach Documents, and Test Cases.

Strong knowledge of designing database by using MS SQL server.

Analytical skills, technological acumen, and management/leadership capabilities with data analysis tools

Good understanding of the AS-IS and TO-BE business process modeling and experience in converting these requirements into technical specifications for preparing test plans.

Skilled in business process analysis and improvement.

Hands on experience on SQL, R, Python, C#, VB, SPSS, SSRS, Tableau, SAP Predictive Analytics, SAP Lumira, SAP HANA, SAP ERP (WM, MM, HCM, SD) modules, SAP ARIBA, Excel, SharePoint, Trello, JIRA and MS Project

Experience in designing visualizations using SSRS and SAP Lumira software and Storyline on web and desktop platforms, publishing and presenting dashboards

Proficiency in advanced MS Excel techniques including conditional filters, formulas, statistical tools, macros and pivots.

Skilled in transforming complex and abstract ideas into meaningful words to candidly articulate business assumptions.

Good at developing motivated, high performing staff who are eager collaborate on challenges contributing to a unified organizational vision

CORE COMPETENCIES

SQL

Machine Learning &

Reinforcement

Learning

SharePoint

Episys-Symitar

Calyx

Baker Hill NexGen

MS SQL server &

Oracle 11g

Waterfall & Agile

Methodologies

SDLC

R (Programming &

Data Visualization)

SAP (ERP,

Predictive Analytics,

Lumira, HANA, SAP

WEBI)

Tableau & Power BI

SSRS

Ariba Spend Management

Visual Basic

SPSS

Microsoft Visio

Microsoft PowerPoint

Microsoft Excel

Conflict Resolution

EDUCATION

TEXAS A&M INTERNATIONAL UNIVERSITY Laredo, TX

Master of Science in Information Science (CGPA: 3.82) August 2018 DELTA STATE UNIVERSITY Cleveland, MS

Master of Business Administration (CGPA: 4.0) August 2017

Specialization: Information Systems Management

PROFESSIONAL EXPERIENCES

HOPE Enterprise Corporation/Credit Union Jackson, MS Data Analyst II March 2019 – Present

Automate Portfolio Investment Models assist Portfolio Managers in retrieving data from various sources of record

Working on design and implementation of the Baker Hill NextGen new system project to leverage the commercial department operations for loan origination, business intelligence and portfolio risk management.

Facilitate meetings with SMEs and IT group to review project statuses and any potential impacts on other system applications

Collaborate with diverse cross-functional teams comprising of internal employees and contractors working on database, Data Integration/ETL, report and analytic development and support

Acquire data from primary or secondary data sources and maintain databases/data systems

Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems

Minimize database downtime and manage parameters to provide fast query responses

Work on providing analytical & management reporting, dashboards, data discovery and advanced analytics support for monthly, quarterly and annually surveys/reports (AIRES, NWA Lyft, FHLB and NCUA Call report) for various departments ( Consumer, Mortgage, Commercial)

Using high level SQL queries to filtering and extracting the data from MS SQL Server Management Studio

Perform data analysis on daily basis to create various Ad-hoc reports by using SSRS and excel tools

Design and publish customized interactive reports to an end users information needs on SSRS reporting server Texas A&M International University Laredo, TX

Tutor (University Learning Center) September 2017 – August 2018

Tutored students in multiple settings (individually, in groups, and individual contracts) for various courses (e.g., R, Data Mining, Algebra, Development Math, Stats, Economic, SAP, MIS)

Led course review session and SI sessions

Evaluated applicants through role play

Delta State University Cleveland, MS

Graduate Assistant/SAP Specialist (College of Business) August 2016 – August 2017

Assisted undergraduate students with various SAP modules and courses

Conducted and utilized research, as necessary

Facilitated workshops for students and faculty

Monitored and supervised computer labs

Provided technical assistance and troubleshooting to faculty NickieNina (Pret Wear & Bridal Couture) Lahore, PAKISTAN Business Analyst (Marketing) June 2013 – May 2016

The project focused to implement the candela software for stock and order management and e-commerce for sales enhancement

Research and analyze the business processes; identify and bridge gaps between Business product needs and existing functions, and collaborate with stakeholders to ensure a resource-effective product delivery

Gathered requirements for the integration of warehouse management system with the supply chain system

Documented requirements, user stories, use cases, activity diagram, preconditions, test cases, priorities, and dependencies for automating workflows, data flows and automation processes.

Conducted weekly meetings to provide the status for problem resolution

Worked closely with the business team to translated business needs into Epics/Stories in JIRA

Conducted triage with the QA analysts, application teams, testers and other environment support teams to drive out defect problem resolution

Planned Sprints for the project and serve as liaison between various team members, including developers, project manager, quality assurance team and the client

Assisted with documentation test data, test scenarios and execution test cases for quality assurance during the UAT phase.

Communicated back and forth with the stakeholders, IT, Ecommerce team and with the scrum product owners to resolve and identify pending issues

Employ ad-hoc data analysis capabilities and design reporting methods, tools and techniques

Provided Post Go-live support by prioritizing and categorizing tickets by module Kinetic Worldwide Lahore, PAKISTAN

Business Intelligence Analyst/Data Analyst (Unilever Pakistan) February 2012 – February 2013

Led and conducted a change management initiative to improve a workflow.

Built automation framework to extract data from different data sources which reduced the reporting turnaround time by 30%.

Designed dashboard using filters, parameters and action filters as well as produce standard monthly reports.

Built and publish customized interactive reports.

Participated in various meetings, reviews and user group discussion as well as communicating with stakeholders and business groups.

Worked closely with the project management team to analyze and consolidate request requirements to ensure a rapid turnaround for these ad-hoc requests.

Used Pivot tables to create reports, performed dicing and slicing functions on data by using Excel

Developed and maintained sales reporting using in SAP Lumira and SQL queries. Produced performance reports and implement changes for improved reporting.

Worked on data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart

Makro-Habib Pakistan Ltd. (Retail Chain) Lahore, PAKISTAN Business Analyst August 2011 – January 2012

Implemented SDLC methodology – Agile

Conducted user interviews, gathered requirements, analyzed the requirements using Agile methodology

Collaborated with the designers and developer to align the stakeholder’s vision and deliverables

Created Use Cases, Activity Diagram and other Process Flow Models were designed using Visio

Updated and managed the Product Backlog

Performed GAP Analysis for the “As is” to “To be” system

Participated in the daily Stand-Up meetings, created and prepared the meeting notes.

Worked closely with the business and translated business needs into Epics/Stories in JIRA

Ensure successful design, testing and deployment of application functionalities that support the business unit ACADEMIC PROJECTS

Texas A&M International University Laredo, TX

Data Mining and Business Analytics February 2018 – May 2018 Extensive experience of multiple modeling techniques. Analyzed the relationship between different car manufacture companies by examining the multivariate relationship between different variables, using ggplot2 and lattice packages on R. Built a prediction model by using Bagging and Random forest techniques to analyze the quality of wine using part, rpart, ipred and random forest packages. Predicted the relationship between rain and forest fire using Kmeans clustering technique. Developed an optimal policy model by using reinforcement learning package for winning the race in R. Information Systems Analysis August 2017 – December 2017 Developed a system request document to address the needs of the client that was losing customers with traditional business model (offline retail store) and was willing to maximize the profit with the launching a new online system. Defined & refine the purpose and scope of the business, effectively conducted background research, and listed functional and non-functional requirements. Also, generated use-case, activity, class, sequence, package and web navigation diagrams. Suggestions to profitability enhancement were also a part of the project. Database Management and Design February 2018 – May 2018 Developed a database for a mid-sized hospital. Defined a project description of the hospital along with the functional and data requirements for operations department. Also, defined the business rules, created metadata, constructed entity relationship diagram (ERD) and enhanced relationship diagram (EERD), transformed ERD into relational data model, developed ER Diagram composite usage map, transforming logical model into physical model by creating tables, populating sample data and joining tables in Microsoft SQL server management, integrated and implemented the Microsoft SQL server management with .ASP web applications by using Github server and visual studio. Delta State University Cleveland, MS

Enterprise Resource Planning January 2017 – May 2017 Created different Scenarios on SAP ERP (WM, MM, SD, PP) in the course. Procurement scenario included the steps ranging from customer purchase requisition to vendor payment. Fulfillment scenario included steps like generating quotation, creating internal order, preparation and shipment of goods and, finally, updating accounting record. Production scenario, finally, involved the raw material conversion into finished goods. Business Intelligence January 2017 – May 2017

Extensively worked on Business Intelligence tools such as Tableau, SAP HANA, SAP Predictive Analytics and SAP Lumira. Analyze and visualize the GBI Big data sets to understand the correlation of different variables based on prices, cost of goods sold and unit cost etc. to predict the sales model. CERTIFICATIONS, ACHIEVEMENTS, HONORS & AWARDS

Udemy, Machine Learning A – Z (Python & R in Data Science) In-progress

Pluralsight, Beginning Time Series Analysis and Forecasting with R, Recipient Jan 2019

Pluralsight, Advanced SQL Queries in Oracle and SQL server, Recipient Jan 2019

HarvardX, Data Science: R Basics, Recipient Oct 2019

LinkedIn Learning, Advanced SQL Server Reporting Services (SSRS), Recipient May 2019

Code with Mosh, C# Certification(pending), Recipient Dec 2018

LinkedIn Learning, Planning AWS Solution Certification, Recipient Fall 2018

Texas A&M International University, Fellowship Program, Participant Fall 2017

Delta State University, MBA Presidential Scholarship, Recipient April 2017

Contact this candidate