Mukesh Dachapally

adkelt@r.postjobfree.com +1-805-***-****

linkedin.com/in/mukesh-business-intelligence-

analyst

Summary

Engineering Management graduate with more than 6 years of professional work experience, seeking a challenging position related to Business Intelligence/Business Analysis/ Data Analysis with a firm, which provides an exciting environment and utilize all my abilities to the fullest. With experience in Business Analysis,Data Analysis, Data Modeling, Reporting, Project Management, Systems Analysis, Requirements gathering, Customer service, I am totally inclined towards learning new technologies and ready to work with a multidirectional attitude. Interaction with clients and various stakeholders directly in previous jobs has made me a good communicator, problem solver and a great negotiator. Experience

Business Intelligence Analyst

Conviva Care Centers

Jan 2019 - Present (2 years 1 month +)

Amalgamated role of Data Analyst, Business Analyst and Reporting Analyst focusing majorly on deriving meaningful solutions out of data.

• Clean and Model the incoming source data in various formats using SQL Server Integration Services(ETL)

• Build Reports and Dashboards for operations and Finance Department using Power BI, SSRS, IBM- Cognos

• Profecient in creating, configuring workflows designed in SSIS

• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts and also used DAX to create custom measures

• Querying data from SQL Server on day to day basis

• Automating data loading processes and source target mapping using SSIS, SSMS

• Administering SSRS & Cognos servers by granting access to users and deploying various reports & dashboards to servers

• Build SQL queries using advances sql methods like Stored procedures, Views, CTEs, Table Variables

• Customizing report designs using javascript in Cognos & processes using VB script in SSIS

• Learning Azure Data Factory to migrate all existing SSIS packages to ADF

• Creating jobs in Sql server and maintaining the schedules on day to day basis

• Performing in depth analysis of new incoming transactional data and building solutions by standardizing and normalizing it

Project Manager

Treehouse Technology Group

Apr 2018 - Dec 2018 (9 months)

• Worked with 3 teams, 36 members in size to build and maintain continuous and deliverable software in increments

Mukesh Dachapally - page 1

• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle

• Worked extensively on MS Project and created project charter, Gantt Charts and Calculated critical paths of project.

• Partnered to work with Product owner, Project managers, Scrum master and scrum team for prioritization and clarification of the work handled by the team.

• Created user stories and groomed them by picking from the product backlog

• Facilitated brain storming and JAD sessions to come up with the requirements of the project.

• Designed and developed Use cases and activity diagrams in MS Visio to analyse and translate business requirements into system specifications

• Conducted root cause analysis for recommending enhancements and improve the productivity of the application

• Created workflows using formal notation such as the Business Process Modeling Notation (BPMN)

• Facilitated requirement-gathering sessions using questionnaires and created Wireframes, Page Mock- ups, prototypes and Screenshots using Visio and HTML for UI Designer

• Generated reports and dashboards using Tableau Vizualization tool(Tableau Desktop)

• Performed feasibility studies and GAP analysis to analyse the gap between AS-IS and To- Be system

• Involved in activities such as status reporting, milestones, and resource allocation

• Created and documented test cases, test scripts and user manuals for the new application Business Intelligence Analyst

Humana

Feb 2017 - Dec 2018 (1 year 11 months)

Provided well defined business solutions using reporting tools. Analyzed data and the magic behind those numbers by utilizing Cognos SSRS Tableau Crystal Reports SQL SDLC Agile Practices HP ALM HP ALM.

• Gathered requirements from users and develop project charter by conducting JAD sessions.

• Developed Work Breakdown Structure

• Generated process flows for various activities of the business

• Generated Mockups, Wireframes and Dashboards for c level business associates

• Generated new reports & modifying existing reports (Dashboards, Drill through reports, Master detail relationship Reports, Cross tabs, list, Active Reports) using Cognos Report Studio, Query Studio and Analysis Studio

• Developed dashboards and stories using Tableau 10.2

• Replicated Crystal and business objects reports in Cognos

• Developed reports using SQL Server Reporting Services(SSRS)

• Published reports in Test, QA & Production Environments and making sure they are in same line of structure

• Tested the reports before user validation by comparing Cognos generated SQl and Native SQL

• Involved in daily scrum calls, sprint review and retrospective meetings

• Held the responsibility of administering the capabilities of 6000 concurrent users and 10000 active users by assigning them role level security through Cognos administration Data Analyst

STONE EDGE INFO TECHNOLOGIES PRIVATE LIMITED

Apr 2012 - Apr 2013 (1 year 1 month)

Mukesh Dachapally - page 2

• Analysed business needs and played a key role in planning and implementing web based database for storing important pharmaceutical data and user files of the organization

• Planned and documented procedures for data processing and prepared data flow diagrams for the new web based database

• Worked with Data Providers to capture and integrate sales data for use in internal deliverables such as Field Reporting, Incentive Compensation, Analysis, and Targeting

• Monitored and executed required weekly quality control checks for accurate and timely processing of data warehouse updates. Validated information to ensure it conforms to specification and within defined thresholds

• Collaborated with other departments (Finance, Operations, Sourcing, Marketing) to understand sales performance and improve reporting of results

• Created Ad-hoc reports from the database developed, using SAS and Cognos

• Created dashboards and score cards for the Organizations growth by considering various data regarding employee table and sales table along with product look ups

• Extracted data from database and data warehouse using SQl and modelled data in framework manager.

• Helped ETL team in developing OLAP models from the OLTP models. Education

University of Houston-Clear Lake

Masters in Engineering Management, Engineering/Industrial Management 2015 - 2016

Masters in Engineering Management

Auckland Institute of Studies (AIS)

Graduate diploma in international business, Business Administration and Management, General

2013 - 2014

Graduate Diploma In international Business -Level 7 Osmania University

Bachelor's degree in Pharmacy

2008 - 2012

Licenses & Certifications

Joint Certificate in Project Management & Six Sigma Green Belt - University of Houston-Clear Lake

Diploma in Clinical Research and Clinical Data Management - IIET I-1302567

Certified Designer-Cognos 10 Report Author - IBM

Mukesh Dachapally - page 3

Skills

Data Analysis • Extract, Transform, Load (ETL) • Report Development • Project Management • Six Sigma • Microsoft Power BI • Business Intelligence (BI) • IBM Cognos Analytics • SQL • Data Warehousing

Honors & Awards

Academic Excellence Scholarship - Auckland Institute of Studies Mar 2014

Awarded Academic excellence scholarship twice, successive for 2 semesters. Dollars for Scholars - university of Houston clearlake Aug 2015

Awarded Dollar for scholarship(50% Merit scholarship) for maintaining good academic standing before enrolling and also throughout the course .

Mukesh Dachapally - page 4

Contact this candidate