jagannadharchari.ennikapati

**** ****** **** *******, ** – Atlanta GA 30080

Mobile: 404-***-**** – Email – ac8t9c@r.postjobfree.com

Senior BI Analyst / Tableau Developer

Seeking a challenging position with an Organization that enhances my Technical and Managerial capabilities while utilizing technical expertise, innovative abilities & interpersonal skills.

Summary

13+ years of software Development and system Engineering experience with a demonstrated ability to quickly learn and integrate new technologies in Retail, Manufacturing and health care domains using with BI – Tableau, Cognos, SSRS,MicroStrategy, SAS, R,, Alteryx,SQL Server, Teradata, Hadoop and Python

Currently working as a Senior Business Intelligence Analyst and developer using Tableau, Alteryx, R, SAS, also generated various report using Python Report lab and sent to Business users to improve their decision-making.

Having excellent analytical, Problem solving and debugging skills

Collaborate with Directors, Business teams, Operations and various applications stakeholders to get the reporting requirements and creating business required visualization reports

Proficient in translate business logic from one system (Excel, SQL, Python,etc) into Alteryx in a quick and accurate manner for process automation

Expertise knowledge of database concepts in SQL, PL/SQL, PostgreSQL, Teradata, Hadoop performance tuning, query optimization, materialized views and data compressions.

Experience in working with an Agile team in Scrum/XP based software development

Experienced in modern software development using continuous integration & Deployment (CI-CD) process.

Experienced on various agile project management tools such as Assembla, Jira and Piotal Tracker.

Fluent understanding of project management and software development life cycle (SDLC).

Support projects through end-to-end implementation of the SDLC; including Requirements, Design, Development, QA, Pilot, Rollout and Post-Implementation.

Attended daily standup meeting, sprint planning, and product backlog grooming and retrospective sessions.

Possess sound interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.

TCS Certified advanced Tableau developer and I have trained more than 50 members internally.

Pipeline learning technologies are Machine Leaning and AWS.

Technical skills

PROGRAMMING LANGUAGES: Tableau JavaScript api, Rest api, R, SAS and Python.

DATABASES: Teradata, SQL Server, mongodb, Oracle, Netezza and Hartonworks Hadoop hive. Salesforce

TESTING :TABJOLT

BI & ANALYTICS TOOLS: Tableau 10, CONGO’S 8, OBIEE, R, SSRS, Power BI, Qlickview, Alteryx and Micro strategy 9

ETL TOOLS: informatica, ssis And data stage

SERVER: Tableau server 10.

Benchmarks & Milestones

Certified in ITIL Foundation.

Certified PAHM (Professional, Academy of Healthcare Management.

Certified in MSTR (CPA, CRD, CDMD and CPA).

Awarded 3 times ‘On the spot’ Award for presenting innovative concepts, suggesting them to client.

Awarded Best Performer of the Year with Grade of A for past 3 fiscal years

Professional Experience

The Home depot, Atlanta, GA Sept 2012 - Present

Senior BI Analyst/ Tableau Developer

Pricing analytics

Designed and implemented a professional and production quality build, unit-test and Analyzing client data and preparing Tableau visualization to pull reports for different Markets / SKU based on different techniques like regression, scaled comp, scaling factor, forecast sales, units and gross margin for future weeks.

Technical Skills: Tableau 10, SAS 6, Qlickview, Tibco spotfire,SQL Server, Alteryx, R,MS Access, Teradata, GCP,Hartonworks Hadoop hive, tableau Rest API,python and tableau Java script API

Responsibilities

Expertise in design & development of complex Data Visualizations in TABLEAU version 10

Provides solutions to complex set of business requirements across lines of business/subsidiaries/multiple geographies.

Having knowledge and developed some of the reports by connecting Google cloud platform (GCP) and pivotal cloud foundry (PCF).

Provide training/demos to users on Tableau Desktop for development and Tableau Server for navigation.

Expertise to access, query, clean and consolidate subscriber data from various sources using SAS & SQL to manipulate large (several million record) data files for regular and ad hoc analyses that can be processed by SAS, R and/or Excel or visualized by Tableau.

Experience on Tableau server and data source administration, including upgrades, monitoring, troubleshooting, performance tuning, user management and change management.

Expertise to Perform advanced Tableau server management tasks including clustering, load balancing etc.

Expertise to build and support analytical databases as needed.

Build and support analytical solutions based on client requirement.

Preparing final workflow diagram and process documents. Presenting it to the client.

Experience with Requests, Numpy, Scipy, Matplotlib, and Pandas python libraries during development

Lifecycle.

Strong experience using Web Services and API’s in python

Expertise build analytical solutions for market analysis and data manipulation by using python.

Expertise providing solutions for adhoc analysis and data models by using R.

Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.

Participated in learning of techniques for statistical analysis projects, algorithms and new methods.

Formulated techniques for pricing of derivatives and other financial engineering instruments.

Supported other members in preparation and interpretation of financial statements such as balance sheets and income statements.

Build and support analytical solutions based on client requirement.

Having good understand on alteryx models.

Exploring on Microsoft Azure and AWS to get the certificate.

Developed some of the POC by using Qlickview and Tibco Spotfire.

Creating and maintaining analysis datasets that were extracted from Teradata and SQL server.

Preparing final workflow diagram and process documents. Presenting it to the client.

Passing SKU and Market information and pulling results like Sales units Gross Margin for current and forecasting for future weeks and sharing results to Merchandise team for decision making to implement for future weeks or revoking the price change.

Optimizing the existing SAS and R models.

Developing front end tools in ACCESS VBA to input data into SQL Server etc.,

Expertise to blend salesforce data with other type of data for a deeper understanding.

Good understanding of BI and Data warehousing concepts.

Knowledge in ETL Concepts and Best Practices for data feeding analytics systems.

Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environments.

Involved in managing the application’s users, groups, and integration with Active Directory.

Familiar with tableau migration and scheduling.

Familiarity with Big data technologies.

Knowledge in IOT and generate the tableau report by using IOT data.

Previous employer: Mphasis an HP Company Sept 2010 to Aug 2012

General Motors, Chennai, IND.

Global Premium Freight Application (GPFA)

This project aims to develop a standardized web Solution to crate & update resale contracts & Steel from ORCID. It is an online system developed to retrieve GM and Supplier’s resale contracts information. It consolidates purchasing, resale contracts & steel parts with their pricing information residing in systems used within General Motors. This application also allows uploading and exporting the GM & Supplier pricing and contract information in excel format and the project involves implementing a reporting solution based on Tableau for GM purchasing system for Steel Resale process. The system tracks Buy and Sell contracts between Mill, Processors and Suppliers or Stampers. As a Sr. Developer, I am involved in the following activities in the project:

Technical Skills: Tableau 7, ORACLE, MySQL and Tableau server 7.

Responsibilities

Interact with GM users and gathered user requirements.

Created a set of standard reports for the business needs.

Created a set of standard reports by using databases like Oracle, MySQL and Microsoft Excel.

Developed complex reports and dashboards.

Developed dashboards and various chart reports in tableau.

Applied Pages self, Marks and Quick Filters - narrow the data shown in a view, by using tableau Software.

Deployed developed reports in Tableau Server.

Previous employer: Vault Information Technologies Pvt Ltd., Deputed in Misys Software Solutions India Pvt Ltd.,

Mysis, Bangalore, IND. Feb 2010 to Sep 2010

AllScripts PM has been developed on pure Microsoft .NET Architecture. The Client is a .NET Windows Based Forms, ActiveX Controls and uses distribution logic over DCOM Requests and receipts. On the Server tier, AllScripts PM uses a COM+ Server for Business Objects, Rules & Data Manipulation and Transformation into Information. The Data resides on SQLServer 2005 Enterprise Edition. The Data access is controlled from the COM+ Server via OLEDB providers.

Technical Skills: Congo’s 8, SQL and .Net

Responsibilities

Involved in developing cogon’s framework models.

Working on Framework manager and preparing Models.

Working on SQL Server database analysis and preparing datasets for Analytics.

Working on Fact tables and dimensions for different projects using relational databases.

Involved in creating tables, constraints and loading the data.

Created list, crosstab and cell based reports in report studio.

Extensively used query joins, prompts, filters and conditional formatting.

Previous employer: UnitedHealth Group Pvt Ltd., June 2007 to Feb 2010

UnitedHealth Group, Gorgon, IND.

TOPS (The Online Processing System) are the most critical system among all other applications. It is ranked one of the top 5 complex applications (From the perspective of Architecture) that run on DB2 across the globe. TOPS are mainly deals with the Auto-Adjudication (Automated processing) of claims submitted by the customers, 50% of the UHG revenues come from TOPS. This system stores all the claim related information into DB2, SQL Server and Oracle database which retrieves the required data into by using different applications like Congo’s & SAS and then analyze the claims to identify any overpayment done to the providers.

Technical Skills: Congo’s 8, SQL, SAS and DB2.

Responsibilities

Working on Framework manager and preparing Models.

Working on SQL Server database analysis and preparing datasets for Analytics.

Working on Fact tables and dimensions for different projects using relational databases.

Working on Report Studio and created adhoc reports and complex reports.

Created a set of standard reports for the business needs.

Created highly formatted dashboards against Power Play cubes.

Working on Analysis studio for daily analysis of data using cubes.

Working on UAT testing of Framework manager models and cubes.

Working on creating Query Subjects, relationships and Calculations in business layer.

Working on Documentation of design framework of cubes and models.

Working on SAS9.1 and created datasets for analytics departments as required.

Previous employer: Hinduja Global Solutions Ltd.

Hinduja Global Solutions Ltd, Bangalore, IND. Dec 2004 to June 2007

The project (ACAS) aims at processing medical insurance claims, Quality control and Account Receivable analysis, Cash Posting. The module is designed to ensure that clean claims are transmitted to the US client. The claims transmitted comply with the US medical billing standards. The claim is not denied due to any Data Entry error or any noncompliance issue. To post payments received during the billing cycle from the insurance company, to sort out comprehensive solutions, to avoid claim denials, to analyze the claims, which have been denied by the insurance company.

Technical Skills: Congo’s 8, SQL, and Microsoft Excel.

Responsibilities

Created Complex Reports and modification of Standard reports with new functionalities included to automated run on weekly, monthly and yearly basis.

Worked on Framework manager and created an efficient model for BI Reporting.

Working on documentation of changes for Standard Reports whenever changes done and will be communicated to onsite and offshore teams regularly.

Worked on Framework manager and created models for different business segments and Worked on up gradation of reports and packages.

Education

UNIVERSITY OF MADRAS, Tamil Nadu, India

Master of Computer Applications

Contact this candidate