Resume

Sign in

Project Data

Location:
Hyderabad, Telangana, India
Posted:
November 12, 2017

Contact this candidate

Name: K. Naga M Mobile: +** 810*******

Email: ac2976@r.postjobfree.com

Designation: Sr. Tableau developer

Profile:

Over all 12 years of I.T experience in MAINFRAMES, TESTING, SAP BW, SAP BO, and TABLEAU. Includes 5 years of U.S.A experience

4 years of experience in TABLEAU 8.x, 9.x, and 10.x

Good process knowledge in Industries like Insurance, Retail, Health Care,

Banking

Extensive Tableau Experience in Enterprise Environment and Tableau Experience including

Technical support, troubleshooting, report design and monitoring of system usage.

Implemented Agile Life cycle methodology by working across functional teams working simultaneously on various areas like planning, requirements analysis, design, coding, testing.

Knowledge on creating users, sites, site roles, Projects in Tableau Server.

Knowledge on Scheduling and Security in Tableau Server.

Knowledge on Regular Expressions (REGEX), ALTERYX,PYTHON and R Languages, Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, SAP BW, MS Access and client/server applications.

Understanding and developing Analytics solution for specific client requirements

Sound knowledge of Data Warehousing Concepts.

Experience in Preparing Design Specification documents based on Business requirements.

Worked on LOD like fixed, include, exclude and table calculation & cascading filters

Experience working with Business Intelligence data visualization tools with specialization on Tableau, Power Pivot, and Excel.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Tree maps.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and

Drop down menu option and Parameterized using Tableau.

Highly effective communication skills proven by effective interaction with management, users, Onshore and Offshore team members.

Extensive experience in SQL.

Experience in interpreting and analyzing data for driving business solutions.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using Tableau.

Creation of metrics, attributes, filters, reports, and dashboards.

Created advanced chart types, visualizations and complex calculations to manipulate the data.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameter using Tableau.

Hands on experience on different Visual Analytics concepts in Tableau like Parameters, Groups, Sets & Filtering conditions Etc.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within

Experience/Project Work:

Project # 1.

Client : Hudson’s Bayes

Role : Lead Tableau Developer

Environment : Tableau 10.0, MS Excel,Oracle 11g,Windows2012 Server R2

Teklink Inc, HYDERABAD-(UBN Qtech Solutions, Jan 2017 to Till Date)

Hudson’s Bayes a chain of 90 department stores that operate exclusively in Canada. It is the main brand of the Hudson's Bay Company, North America's oldest company. It has its headquarters in the Simpson Tower in Toronto. The chain uses both the English and French versions of the name in some parts of the country. The stores are full-line department stores, with a focus on high-end fashion apparel, accessories, and home goods. Price points at Hudson’s Bay are co-parable to U.S. retailers Lord & Taylor, Neiman Marcus and Saks Fifth Avenue. The average store size is 135,000 square feet.

Responsibilities:

Involved in gathering and analyzing business requirements from the client

Involved in all Agile-Scrum meetings like standup meetings, Sprint planning and Sprint review and retrospective meetings

Created relationship between two different Data Sources by using Data Blending.

Responsible for creating extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Developed Ad-hoc reports using Tableau Desktop

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.

Generated context filters and data source filters while handling huge volume of data

Used filters to display information from various time ranges such as YTD, MTD and Fiscal Year-to-date.

Published reports to Tableau Server so that users could have daily updates via email subscriptions.

Built Tableau visualizations by connecting to various Data Sources Relational Databases.

Working with Level of Details/LOD expressions and Regular Expressions/REGEXP

Created actions to navigate to various pages as per user requirement.

Executed and tested required queries and reports before publishing.

Published Workbooks by creating user filters so that only appropriate teams can view it.

Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks.

Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

Extensive testing and migrating the reports or objects from development to Production system.

Responsible for developing provisioning reports for various groups and upper management.

Project#2.

Client : Ergo Insurance Group

Role : Tableau Developer

Environment : Tableau 9.0, MS Excel, Oracle 11g,Windows 2012 Server R2

Wipro Technologies, Bangalore- (UBN Qtech Solutions, Jan 2016 to Dec 2016)

Description: Ergo is the one of the major insurance groups in Europe. It is represented in more than 30 countries and mainly concentrating in Europe and Asia. It was found in the year 1997 with Headquarters located at Dusseldorf, Europe. In Europe, ERGO Claims to be NO 1 In the health and legal Expenses insurance Segments.

Responsibilities:

Business requirement gathering, review, analyze, documenting and execute the business plans accordingly.

Design, develop and implement Tableau Business Intelligence reports.

Worked on individual axis, blending axis, dual axis.

Representing data using the Cross Tabs, stacked Bars, Pie Charts and Bar Charts.

Use groups, hierarchies and filters, Quick filters, Context filters, to create focused and effective visualizations

Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports

Use Trend Lines, Reference Lines, Forecasting and statistical techniques to describe the data.

Use parameters and input controls to give users control over certain values and Discrete, continuous.

Created Actions to navigate to various pages as the user wish.

Created summarized menu options as tabs in homepage where the users easily chose the required option.

Responsible for dashboard design, layout, look and feel and development.

Connect the data from different database using the data blending

Created Sets, Groups and Data Bins as per user requirements

Generate reports delivered to end users through Tableau

Create interactive tableau visualization dashboards.

Write Unit Test cases and execute.

Publish and schedule the dashboards in Tableau server.

Schedule project meetings, tracking monitoring project updates/ project enhancements/ Project status reports.

Schedule Business Segment Status Meetings, Write MoM, Action Items, Follow-ups

Project Documentation, Management, Project Tracking, Monitoring and Update Project Status reports.

Project#3.

Client : Kilwins'

Role : Tableau Developer

Environment : Tableau 8.3, MS Excel, Oracle 11g, Wndows2012 ServerR2.

Tech Mahindra, pune - (UBN Qtech Solutions) -Jan 2015 to Nov 2015

Description: Kilwins' handmade chocolates, fudge, and ice cream have been delighting customers since 1947. Today, more than 90 franchisee-owned stores in 19 states bear the Kilwins name. This project involves developing the reports for total products sales and keeping track on which product to manufacture for which state to improve the sales according and determining the reason for low sale and forecasting the product sales with previous track of records. By this way Today with Tableau, Kilwins is able to easily use its data to guide promotional efforts and to inform franchise owners' purchasing choices.

RESPONSIBILITIES:

Responsible for interaction with business stakeholders, gathering requirement and covering the entire Tableau development life cycle.

Designed different types of charts (Scatter plot, Crosstab, Pie- Chart, Bar Chart, Line Chart, and Waterfall Chart).

Created actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter

Created sets and bins as per client’s requirement

Extensively used data blending, embed functionalities in Tableau.

Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Extensively Worked on Data Refresh, Data Joining and Data Blending.

Created Data visualization using Filters and Parameters.

Created sets, groups, data bins and calculated fields and hierarchies.

Using quick filters and quick table calculations when necessary.

Defined best practices for Tableau report development.

Developed customized calculations and table calculations when required.

Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server.

Project#4.

Client : Arby's Restaurant Group, Inc., U.S

Role : Tableau Developer

Environment: Tableau 8.2, MS Excel,Oracle 11g,Windows2012 R2 .

(KPMG, Bombay) (UBN Qtech Solutions) Sep 2013 to Dec 2014

Description: Arby's Restaurant Group, Inc. is the second largest quick-service chain in the U.S. with more than 3,400 restaurants. Main objective of this Project is to reduce the Manufacturing cost and improving the sales forecasting by identifying key factors like the total sales revenue in 1st Week, 1st Month, and 1st Quarter comparing to previous Week, Month, and Quarter Based on the Region, total Sales and the Sale amount.

RESPONSIBILITIES:

Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.

Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications

Thoroughly analyzed the current Architecture, databases and schemas.

Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop.

Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts.

Created Dashboards using Tableau the drill down, drill across, actions for business steering committee.

Created Complex dashboards and involved in performance tuning of operational dashboards in tableau using the various sources of data from Excel sheets, Oracle database.

Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

Created the AS-IS and TO-BE process flow diagrams.

Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation,Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/ reports

Optimized Tableau Workbooks and Background Tasks for Targeted Interactions Analytics.

Created and Published Tableau Dashboards into Tableau Server

Project#5

INFOTECH,HYD (UBN Qtech Solutions) Mar 2012–Aug 2013 Role: SAP-BI/BO Consultant

Project Description/Scope: Dr. Reddy’s laboratory, DEVELOPED WEBI reports.

Responsibilities/Deliverables:

Analyzing the existing system and identifying the different objects.

Identifying the Gap Analysis.

Monitored Info Objects, Data Sources, Transformations, Info Packages and Info Cubes for Master and Transactional data from SAP R/3 system and flat files into BI system.

Monitored custom Info Cube and other Info Objects as per the data model.

Monitoring of info packages and analyzing the reasons for frequent failures of info packages.

Monitoring Info Packages; Event Scheduling.

Developing new objects based on the requirement and the gap analysis.

Monitored process chains for master data loading transactional data loading for weekly deletion of Psa.

Extensively worked on Hierarchy, Conditions, Drilling functionalities, Drill down, Prompts, Functions, Formulas, Complex filters, Alerter, Variables, LOV’s, @Functions, and @Prompts

Created users/ groups and defined their roles and set privileges

Project#6

Client: BANK OF AMERICA,IBM, (Collabera), 2011 Aug – Jan 2012

Role: SAP-BI/BO Consultant

Project Description/Scope:

BANKING DOMAIN, DEVELOPED WEBI, CRYSTAL REPORTS.

Responsibilities/Deliverables:

Analyzed the Bex, Crystal Functional specs.

Interacted with Business Users to understand the requirements and translate these to Technical Specifications for IDT and Business Object Reports

Posted the issues in the issue Tracker.

Developed the Bex, Crystal Technical specs using the Functional specifications.

Reviewed the Technical Specs with the Business people.

Developed the POC in the Crystal Reports

Reviewed POC with the Business and made the required changes to the POC.

Designed and Developed the Bex Queries for the reports in BI 7.0

Designed and Developed the Crystal Reports based on the requirements

Setting up the configurations for publishing process for the Crystal Reports.

Extensively worked on Hierarchy, Conditions, Drilling functionalities, Drill down, Prompts, Functions, Formulas, Complex filters, Alerter, Variables, LOV’s, @Functions, and @Prompts

Created users/ groups and defined their roles and set privileges using the CMC

Used the formatting options like cross tab representation, Group By, data sort options, calculations, font, colors etc.

Prepared Test Cases for Unit Testing.

Involved in Unit testing, System testing and User Acceptance Test (Universes and Reports) throughout migration process.

Project#7

Client: Robert Halfnternational,(nanosemantic inc,USA) AUG 2008- JUN 2011

Role: QA Engg

Project Description/Scope:

Recruiting man power consulting for full time and contractors .

Responsibilities/Deliverables:

Developed test plan, test cases and test scripts in Quality center, after the requirements are signed off.

Used Quality center to develop Test Sets.

Used back-end database SQL queries to perform data testing

Executed the UNIX scripts and commands to check the log files

Documented Manual Test cases, Test procedures and Test results.

Extensive Black box Testing

Performed Functional, GUI testing.

Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

Involved in Gathering the Onsite Biz requirements and sending to Offshore .

Coordinated the Test Env Downtime during Test cycles as a part of code Deployment to accommodate the Onsite and Offshore Test timings.

Involved in coordination of QA activities from Onsite to offshore

Involved managing offshore QA resources

Conducted Defect Status meetings with Offshore and Onsite Leads to discuss the defect Details found during testing

Created the Automation framework for the application to make sure the adequate coverage for the regression testing

Project#8

Client: LifeMasters, South San Francisco, CA, (nanosemantic inc,USA ) OCT 2006 – AUG 2008

Role: QA Engg

Project Description/Scope: Online-hospitalized services

Responsibilities/Deliverables:

Reviewed Business Requirement documents (BRD), Software Requirement specification (SRS) and prepared Test Plan.

Used back-end database SQL queries to perform data testing

Documented Manual Test cases, Test procedures and Test results.

Extensive Black box Testing

Performed Functional, GUI testing.

Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

Developed positive & negative scenarios for the requirements.

Developed test plan, test cases and test scripts in Quality center, after the requirements are signed off.

Used Quality center to develop Test Sets.

Conducted the Smoke testing to check the High-level functionality of the application.

Created the Automation framework for the application to make sure the adequate coverage for the regression testing.

Project#9

Client: Mc GrawHill, Monterey, CA,USA.,(nanosemantic inc,USA ) DEC‘04 to JUN ‘06

Role: QA Engg

Project Description/Scope:

Publishing company conducts online exams for primary and secondary schools

Responsibilities/Deliverables:

Reviewed Business Requirement documents (BRD), Software Requirement specification (SRS) and prepared Test Plan.

Used back-end database SQL queries to perform data testing

Documented Manual Test cases, Test procedures and Test results.

Extensive Web Testing & Black box Testing

Performed Functional, GUI testing & web based application.

Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

Developed positive & negative scenarios for the requirements.

Developed test plan, test cases and test scripts in Quality center, after the requirements are signed off.

Project#10

Client: AVIVA INSURANCE, (streamline technologies) Jun’03 to Nov ‘04,

Role: mainframe developer

Project Description/Scope:

This project is insurance domain developed in mainframes

Responsibilities/Deliverables:

Preparation of the document of understanding(high level design).

Preparation of detailed design ((flow charts, pseudo code).

Coding is done by using low level design docs(LLD) And Pseudo code

Coded in cobol language to prepare Stub

Code review is done against the High level design docs(HLD)

Project#11

Client: North American Bank, Toronto Dominion, Aug’02 to May’03

Role: mainframe developer

Project Description/Scope:

This project is Banking domain developed in mainframes

Responsibilities/Deliverables:

Preparation of the document of understanding(high level design).

Preparation of detailed design ((flow charts, pseudo code).

Coding is done by using low level design docs(LLD) And Pseudo code

Coded in cobol language to prepare Stub

Code review is done against the High level design docs(HLD)

Testing –preparation of test plans and test cases

Project#12

Client: Canadian Imperial Bank of Commerce (CIBC),Satyam computers(streamline technologies) Hyd, Mar ’01 to Jul ’02

Role: mainframe developer

Project Description/Scope:

This project is Banking domain developed in mainframes

Responsibilities/Deliverables:

Preparation of the document of understanding(high level design).

Preparation of detailed design ((flow charts, pseudo code).

Coding is done by using low level design docs(LLD) And Pseudo code

Coded in cobol language to prepare Stub

Code review is done against the High level design docs(HLD)

Testing –preparation of test plans and test cases

Education:B.tech (Mech) in 1997 from S.K university.ANANTAPUR(A.P)



Contact this candidate