Data Microsoft Office

Mahesh

540-***-**** **********.*.***@*****.***

Summary:

* ***** ** ** ******** experience in database, business analysis and data visualizations.

Experience with complete Software Development Life Cycle (SDLC), which includes analysis, design, coding, testing, and deployment.

Expertise in scripting HiveSQL queries, complex stored procedures, user defined functions (UDF), Database triggers, JavaScript.

Writing queries to extract data from Hadoop Big Data.

Proficient in implementing database and data warehousing solutions to large and small scale Enterprise Data Warehouse (EDW).

3 years of experience in Tableau Administration/Development.

Hands-on experience in the development of reports and dashboards in Tableau.

Extensive Experience in creation of Dynamic Enterprise Dashboards and Scorecards, which helps in better understanding of the Business trends.

Experience in Tableau report developing, testing and deploying reporting solutions using Tableau Server.

Communicating client’s business requirements by constructing easy-to-understand data and process models.

Identify and reconcile errors in client data to ensure accurate business requirements.

Used R, Python and HiveSQL scripts to standardize and normalize the data.

Used Python script to prep the data for analysis using Zeppelin.

Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

Created Customized and interactive dashboards using multiple data sources.

Moving the workbooks from one server to another Server or one site to another site

Analytical and problem-solving skills, capable of learning new technologies

Quickly.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Software/Tools skills:

Reporting Tools

Tableau 7.x/8/9.3/10.1/10.2/10.4, Excel, Zeppelin, R Studio, Oracle, Hue

Databases

ORACLE, SQL Server,MS Access, Big Data Hadoop

Languages

C, Java, SQL, HiveSQL, R, Python

Operating Systems

UNIX, Windows 95/98/2000/NT/XP/7/8/10, DOS

Professional Experience:

Madison Consulting Nov 17 – May 18

Data Analyst/Consultant

Responsibilities:

Worked on financial datasets to build reports for a Top financial firm.

Created multiple Temperory tables for analysis using HiveSQL in HDFS.

Writing queries to extract data from Hadoop Big Data.

Debugging errors and testing queries for fine tuning.

Created dynamic dashboards using Business Intelligence tool Tableau for the Stakeholder to understand and read through the data.

Suggested differents models to reflect the risk factor on the Dashboard.

Extracting reports from alert generating AML tools like Norkom, Actimize and Mantas.

Created builtin parameters which can identify the alert scenarios within the data.

Created multiple calculated fields, parameters and bins to break down the measures to certain metrics.

Used excel sheet, flat files, CSV files to generate Tableau ad-hoc reports.

Writing queries on different query editors like Hive and Imapala.

Used R, Python and HiveSQL scripts to standardize and normalize the data for analysis.

Used Python script to prep the data for analysis using Zeppelin.

Documenting the procedures into word and power point.

Experience in source control technologies like SVN repository.

Environment: Tableau 10.2/10.4, R, HiveSQL, Big Data, Norkom, Actimize, and Mantas, Python, SVN, Excel, CSV

Global Data Mart, Piscataway, NJ June 16 – June17

Role: Data/Business Analyst

Responsibilities:

Oversaw the installation and upgradations of SQL 2012.

Created tables and views.

Created function, stored procedures, triggers and constraints using T-SQL.

Performance monitoring and tuning of SQL servers.

Used excel sheet, flat files, CSV files to generate Tableau ad-hoc reports.

Worked with JSON data using Python scripting.

Generated Tableau dashboards based upon sales with respect to sales and reference line.

Communicating client’s business requirements by constructing easy-to-understand data and process models.

Identify and reconcile errors in client data to ensure accurate business requirements.

Created ad-hoc reports to users in Tableau by connecting to various data sources.

Created Tableau dashboards with combination charts for clear understanding.

Publishing reports into Tableau Server.

Environment: Tableau Desktop 9.3/ 10.1, Tableau Server, SQL server, Python, Putty, Excel.

Ma-Foi Randstad Technologies, Hyderabad, India Dec 11 – Sep 13

Role: Data/Business Analyst

Responsibilities:

Design and develop Tableau visualization solutions.

Design Dashboards using Filters, Parameters and Action Filters.

Produced ad-hoc reports to end users to meet their day to day requirements.

Created drill through, drop down reports and charts and dashboards for predictive and perspective analytics requirements.

Produce standard monthly reports using Tableau.

Create Thematic Heat maps using MapInfo.

Automate monthly Excel reports into Tableau Workbooks and Dashboards.

Develop business architecture using requirements such as scope, processes, alternatives, and risks.

Implemented ELT and ETL solutions using Informatica and Microsoft Business Intelligence Suite.

Running python scripts to load data into the custom tables with necessary customizations in the script.

Worked on generating various dashboards in Tableau server using a various data source.

Fine \tuned SQL Queries for maximum efficiency and performance.

Creating, Updating, dropping, joining tables using SQL query.

Creating views and index based on the tables and their columns.

Created VLOOKUP functions and GANTT CHARTS in Excel.

Involved in supporting other Tableau applications which include creation and cosmetic changes of different charts.

Environment: Tableau 7/ 8.x, SQL Server, MS Access, Python, ETL Informatica, Excel, PowerPoint, Outlook.

Educational Qualification:

Bachelor of Electronic Instrumentation from Jawaharlal Nehru Technological University (2007 – 2011).

Masters in Information Assurance/ Homeland Security (Information Systems) (2014 – 2016).

(Business Intelligence: As a part of the course work I participated and worked on a project which included preparing a strategic analysis for a company that includes SWOT Analysis, Area of performance, Strategic Vision and Goals and Objectives. Based on this report we prepared a case study which included KPI’s and how the Data flows and what are the threshold limits. Based on which we (as in group) created a sample dashboard using Excel to display the KPI’s and Thresholds)

GPA: 3.19/4.0

Additional Skills

Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint, Visio).

Expert Knowledge of SQL and Relational Database Management System.

Familiar with Agile software development methodology.

Contact this candidate