Mahender Kongari

adiovi@r.postjobfree.com

Mobile: 313-***-****

Graduated Masters in Computer Engineering at University of Michigan. Passionate in deriving Data Insights and ardent to explore the space of Data Analytics.

4+ Years of experience as a Business Systems and Data Analyst. Experienced in elicitation, evaluation, analysis & Management of user and system requirements, Business process modeling and Business process Improvement.

Experience in Datamining with large datasets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive modelling, Data Visualization and experience in designing, Implementation, Deployment and supporting production environment

In depth knowledge of Project Life Cycle, User Interface Designing, Testing, Quality Assurance, implementation and support within Agile/Scrum, Waterfall & Kanban environments.

Competent in transforming Business Requirements into Functional Requirements and designing business models using UML diagrams - Use Case diagrams, Activity diagrams and Sequence diagrams.

Provide an updated network infrastructure that enables business growth.

Extensive experience in all phases of Software Development Life Cycle (SDLC) including requirement gathering, analysis, design, development, testing, and implementation and deployment of projects.

Professional experience in Business Process Modeling, Business Process Improvement, MS-Project, MSOffice, MS Visio, MS (Excel, Word, PowerPoint), Eclipse and MS SharePoint 2010, SQL and PL SQL.

Strong analytical and problem-solving skills, excellent planning and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprise make critical decisions.

Ability to work under pressure and tight deadlines.

Proficient in preparing Test Plans, designing Test Scenarios and formulating Testing Strategies.

Planning and reviewing the Test cases for Functionality, Security, Performance, Ad-Hoc Database and User Acceptance testing.

Provide continuous planning support for all projects for Strategic Network Planning and Operations.

Education

UNIVERSITY OF MICHIGAN USA

Master’s in Computer Engineering 2016-2018 GPA:3.3

JAWAHARLAL NEHRU TECHONOLOGICAL UNIVERSITY(JNTUH) INDIA

Bachelor of Science in Electronics & Communication Engineering 2011- 2015

GPA: 3.5/4.0

Tools and Technologies

Querying Language

SQL\PLSQL

Programming Languages

C, C++, R

Data Visualization /Statistical Tools

Tableau 10.3, Power BI, Qlikview, R Programming

Data Analysis tools

Smartsheet, Advanced Excel, MS Project, MS Visio

Office

MS Office word, Excel, PowerPoint, MS Project, Visio

Databases

SQL Server 2012/2008/2005

Operating System

Windows XP/2007/2010, Linux

Professional Experience

FedEx Services (Mphasis Corp.) Memphis, TN

Role: Business & Data Analyst Aug 2018-Till date

Project: Network Life Cycle Management

Create and maintain project schedules by developing project plans and specifications, estimating time and resources, monitoring milestone completion.

Experience with working on a large-scale enterprise network with more than 30,000 nodes including routers, switches and 4G Cradlepoints.

Tracking all phases of the project lifecycle, providing timely reporting of issues that impact project progress, coordinating actions and resolving conflicts.

Comprehend business strategies and requirements and develop necessary designs and plans to ensure projects and solutions satisfy those needs.

Prioritize, Plan and coordinate multiple simultaneous projects to maximize the efficiency and achieve critical timelines.

Automated Netgate decommission process and saved more than $1 M by disconnecting unused POTS lines at all FedEx OpCos.

Extract data from the Network database by running the different queries in SQL to populate the list of active devices (Routers, Switches, APs) at all FedEx site locations.

Work with engineers to develop a comprehensive inventory of components needed for each project.

Create and manage various Electronic Procurement (ePro) systems orders in Network Inventory Management tool.

Involved in Data -Migration from various systems by connecting to the legacy databases.

Estimate and manage implementations, overseeing projects are completed within timeframe and budget for all project phases. Developed 5-year project forecast for all Network equipment by using Tableau.

Assist with designing and developing solutions to applications problems, system administration issues, or network concerns.

Responsible for Extraction/Transformation/Loading (ETL) of data into MIS (Management Information Systems) data warehouse, for the report generation.

Experienced in developing and maintaining large and complex visualizations as per the reporting and dashboard requirements using Tableau.

Developed Customer Experience Dashboard to measure the Key Performance Indicator’s (KPI’s), which will be available for higher management for Decision Making.

Performed ad hoc data analysis and using Business analysis methodologies such as SWOT analysis and GAP analysis for better project outcomes.

Create ad-hoc reports for clients and management on daily/weekly basis using Smartsheet and Microsoft office tools.

Analyze and gather innovative technical trends and contribute quality technical documentation and prepare design documents for business requirements.

Design Swim lane Process flows for projects by using Advanced Excel.

Facilitate work with Vendors and Technicians to upgrade the network equipment at all FedEx OpCos.

Open Nexus batch for EoL devices like Routers, Switches and Cradlepoints and schedule with Techs by using Peoplesoft CRM tool and raised PDSM requests for all sites scheduled with in the FY.

Environment and Tools: SSIS, Oracle DB, Agile, Version One, Smartsheet, Tableau, SQL Server, Python, Advanced Excel, Power BI

Datamatics Global Services Inc Livonia, MI

Role: Data Analyst Feb2018-Apr2018

Conducts analysis, summarizes key findings and trends, and produces data sheets, graphics and presentations.

Works with research analysts to plan, create and distribute surveys

Manages market research projects from start to finish. Meet all timelines, budgets, and objectives.

Researches best practices; develops implementation plan of operational and cost improvement strategies; assists in seeking, evaluating and implementing new technology

Requirement gathering, review the data while utilizing the tax processing software.

Generate the various forms and sending them to clients using the prosystems tool.

Process the individual and corporate tax data.

Prepare the spreadsheets supporting the tax returns using the Microsoft tools.

Provides research assistance for strategic planning and business development efforts

Gathers data from multiple sources and assimilates into meaningful inputs for databases and store in SQL database.

Analyzes data, creates summary reporting, and performs analysis to support the decision making of research, senior management, member companies and internal departments.

Supports marketing & sales management in identifying new customers, markets, and applications for services and assesses the business impact of those implication

Prepare reports for internal and external audiences using business analytics reporting tools such as Tableau.

Hemkus Hyderabad, India

Role: Data Analyst June 2014-Nov2015

Worked on Software development life cycle (SDLC) methodology, Framing out Business.

Conducted Surveys and Brainstorming sessions with SMEs for requirement gathering and prepared User Requirement Specifications Documents Created & managed project templates, Use Case templates, requirement types & traceability relationships in Requisite Pro.

Performed User Acceptance Testing (UAT) to test the functionality of the application.

Documented Use Cases and Activity diagrams using MS Visio to understand the requirements and communicate them to the development team.

Transaction rules and related Documentation, creating Test Plans based on Functionality and Business rules.

Performed Gap Analysis of the As-Is and Should-Be process within the organization to analyze and fill the existing gaps in the business processes.

Examined, analyzed and modeled Test plans & Test procedures based on RUP methodology.

Conducted feasibility study and performed impact for proposed enhancements.

Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and taken care of data conversion from legacy system.

Involved in walkthroughs and meetings with development team to discuss related issues.

Used Rational Rose to visually determine the proper structure, key elements and optimal design for the database and to aid in efficient creation of tables and storing procedures.

Wrote clear, concise system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.

Coordinated with the development team in documenting End User Manual.

Academic Project

UNIVERSITY OF MICHIGAN DEARBORN. USA

A Predictive & Statistical Analysis on Permanent Visas Issued by United States Sep2017 – Dec 2017

Tools Used: Tableau 10.3, R- Programming

In this Project, we had used data from USCIS, Department of Labor official websites for Creation of various reports and dashboards for key metrics.

Used Tableau analytics pane for drawing statistical trend lends and grouping using clusters.

I have Forecasted the number of applications filed by the top three Employers in 2018.

I had tested correlation between the visa approval rate with the Nature of employer, Employer Creditability, no of employees under this employer, employer location etc..

I had done both Predictive analysis like Regression and Descriptive analysis like Clustering & Association algorithms.

POC DOC (Master’s) Jul2017 - Aug2017

POC DOC an abbreviation for pocket doctor. PocDoc is an app that puts you at the center of your healthcare anywhere, anytime.

By providing symptoms of the illness one can find what medicines should be used by this app. so the app gives you quick access to a huge healthcare and medical database in your pocket.

Environment: IDE-Xamarin, C#, Xamarin xml, XML, Android SDK

Contact this candidate