KALPANA M. AVALAKKI

Tableau Developer/DataVisualization Developer

Ph: 562-***-****

Email: ac4dok@r.postjobfree.com

U.S Citizen

Professional Summary:

Over 10 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.

Extensive knowledge in Health care, Retail, Manufacturing and Human Resource.

Extensive experience in working with Tableau Desktop, Tableau Server in various versions of Tableau 10/9/8/7.

Extensive experience in creating Tableau reports, Tableau dashboards using stack bars, bar graphs, scattered plots and geographical maps.

Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.

Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.

Experience in generating reports by fetching data from different sources (RDBMS/ Text/ CSV/ EXCEL) using Data Blending.

Employed various Tableau functionalities like Tableau Extracts, Cross Database joins, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.

Experience in Administering user, user groups, Projects, Sites and scheduled instances for reports in Tableau.

Extensively used other BI reporting tools Cognos, Qlikview and Microstrategy for reporting.

Diverse knowledge in software technology.

Hands on experience with ETL tools like Data Manager and Informatica.

Project management and cost management.

Strong knowledge and use of full life cycle methodologies, standards and procedures.

Excellent knowledge in sql and pl/sql.

Knowledge of etl and data warehouse concepts.

Expertise in report development.

Excellent knowledge in multidimensional modeling.

Able to do leadership and mentoring role.

Strong development and analytical skills, proficiency in root cause data analysis, and ability to problem solve.

Ability to multi-task and provide expertise for multiple development teams across concurrent project tasks.

Good experience with complexities of crosses functional issue identification, resolution and prioritization.

Able to develop project plans.

Excellent ability to gather and understand business requirements and translate into it solutions.

Good experience in testing.

Education:

B. S. Computer Science, Bangalore University, India 1994

Roles:

Tableau Developer/ Data analyst– Inventateq – Bangalore (2014-2017)

Sr. Application Engineer - Tata Consulting Services, Tampa, FL (2012 – 2013)

Business System Analyst – Trimble Navigation, Westminster, CO (2011 - 2012)

BI Developer - Fast Track Technologies, Bangalore (2009 – 2010)

Programmer Analyst - Honeywell Utility Solutions, El Segundo, CA (2004 – 2007)

Programmer Analyst - Viking/Office Depot, Torrance, CA (1999 – 2001)

Technical Support Analyst - Sqribe Technologies, Long Beach, CA (1998 – 1999)

Technical Skills:

Languages

SQL, PL/SQL,C, Powerbuilder

ETL Tools

DataStage, Informatica

Databases

Oracle, Sql Server, DB2

BI Reporting tools

Tableau, Cognos, Qlikview, Microstrategy, BO, Microsoft Power BI

Scripting Language

Javascript

MS Office

MS Word, MS Excel, Powerpoint

Professional Experience:

Inventateq, Bangalore - India Mar, 2014- Dec, 2017

Tableau Developer/ Data Analyst

Healthcare business intelligence system/ Retail

Tableau 8/9/10, Oracle 10g, Excel

Responsibilities:

Understand the Requirements and Functionality of the application from specifications.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

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

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Converted existing Cognos reports to tableau dashboards

Created different KPI using calculated key figures and parameters

Developed various dashboards, reports utilizing Tableau Visualizations like Bar Graphs, Scatter Plots, Pie-Charts, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Bump Charts, Heat maps, Geographic Visualization and other.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Utilized Tableau server to publish and share the reports with the business users.

Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.

Created Tableau mobile and geographic maps.

Scheduling dashboards and reports.

Designed a dashboard where the users can slice and dice the data at a wide range of Data elements.

Created Forecasted Reports for the Upcoming Year to Observe Trends in Tableau.

Designed a dashboard to dynamically show or hide crosstab sheets with the detail records upon the selection on the summary chart on the dashboard.

Created a dashboard with row level security, restricting access to the data on the dashboard based on the user.

Tata Consulting Services – Pharmerica – FL Jun, 2012 – Mar, 2013

Sr. Application Engineer

Long term healthcare business intelligence system

Tableau 7, Cognos BI, DataStage, DB2

Description:

Long Term Care Pharmacy Business Intelligence System: LTC BI captured data related to pharmacy, facility, Patient, doctor, health plans, prescriptions, billing and other related information.

Responsibilities:

Gather requirements from clients and document.

Lead the team in design, development, testing and performance tuning.

Lead both onsite and off-shore team.

Maintained and scheduled and refresh ETL jobs, reports and cubes.

Develop several reports and dashboards using visualization tool like Tableau and Cognos reporting tools.

Using SQL for managing large volume of data.

Communicating with clients to analyze historical data and identify KPI.

Improving data processing speed by building automations.

Tweaking sql queries for best performance.

Analyzing the data so as to identify trends and share insights.

Build credibility, establish rapport, and maintain communication with client at multiple levels.

Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.

Coach, mentor and lead personnel within a technical team environment.

Trimble Navigation – CO Mar, 2011 – April, 2012

Business System Analyst

Trimble business intelligence system

Cognos 8.4BI, Data Manager, Oracle 10g, Toad, Noetix

Description:

Trimble Business Intelligence System: Trimble BI enables business users at all levels within the company to make faster, better decisions. It is used to drive strategic business initiatives, tactical decisions and operational actions for sales, marketing, finance, manufacturing, engineering, human resource and customer service.

Responsibilities:

Support different users in different divisions with various technical and non-technical issues in data warehouse.

Resolve on-going or any bugs or data problems in data warehouse.

Solve most or all the support tickets on time, which resulted in increased productivity.

Create and modify Reports in data warehouse using Report Studio, Query Studio and Analysis Studio.

Carrying out investigation of root cause analysis.

Communicating with customers to analyze historical data and identify KPI.

Create and modify models using Transformer and Framework Manager.

Support and maintain daily refresh of cubes and ETL Jobs.

Create and modify documents related to data warehouse.

Create and maintain data securities in data warehouse.

Perform administrative tasks.

Perform testing of reports and data.

Modify packages and cubes.

Support North America, EUROPE and ASIA regions.

Fast Track Technologies – Bangalore, India October, 2009 – December, 2010

BI Developer

Healthcare business intelligence system, HRBI

Cognos 8.3BI, Informatica, Oracle 9i

Description:

Healthcare Business Intelligence System used to capture and process all information related to the billing as well as the medical aspects of a patient event. A patient record is created which stores all the patient history, structured per event. The applications business intelligence can support billing processe for a healthcare organization. Worked with the health care management to understand their business needs and to design and build a data mart solution to track and examine the quality of health care. HC will give the hospital a way of loading utilization data into the data mart, and customized tools to be developed to allow users to transform and analyze data, and to produce custom reports.

Human Resource Business Intelligence System used to capture and process all employee related information and payroll information.

Responsibilities:

Understanding the Requirement Specifications.

Functional knowledge of HR and Health Care.

Design, develop, and support of the overall Cognos BI content including reports, cubes, packages, dashboards and presentation portals.

Collaborate with Data Architect/DBA to development/optimize the star-schema model for the Cognos reporting tools.

Collaborate with Data Architect/DBA to maintain optimal reporting tables and views within Cognos.

Solid understanding of the Cognos BI suite- Report/ analysis studio; Framework MGR; Transformer

Design and support public folder reporting via Cognos Report Studio and Query Studio.

Built Cubes using Transformer.

Develop and maintain technical documentation.

Honeywell Utility Solutions – CA Jun, 2004 – Apr, 2007

Programmer Analyst

Rebate and Voucher Programs

PowerBuilder, Oracle 9i

Description:

Rebates and vouchers were given to customers for water and energy saving devices. This

Information was captured and processed by BBCS application. BBCS used to keep track of customer information, list of utility companies participating in the program, list of water and energy saving devices, customer eligibility, and Rebate and voucher amount.

Responsibilities:

Analyze, Maintain, develop, modify, debug and troubleshoot BBCS Application. BBCS Application supports different programs, such as Voucher program, rebate program, meter program and audit program.

Design, develop, modify and debug reports that support different programs.

Assist users with procedural and minor technical problems.

Assist with design, analysis, develop, document and test new programs.

Viking/Office Depot – CA Sep, 1999 – Aug, 2001

Programmer Analyst

Retail Sales and Marketing

Cognos BI, Humming Bird, Microstrategy, Oracle

Description:

Viking Office Products, Inc. is a leading mail order seller of office supplies to small- and medium-sized businesses. The company relies on sophisticated computerized mailing systems to send customized catalogs to its potential buyers, and then provides them with a high level of customer service in order to keep their business. Data warehouse supported business development personnel on marketing analysis, mailing segmentation, and personalization to achieve the goal of reducing the advertising cost by 12% and increase the revenue cost by 16%.

Responsibilities:

Gather user requirements.

Interact with BI team for developing the reports and solving the issues.

Provide critical information like total sales, daily revenue, goals and various new plans.

Extensively used the Cognos reporting tools, Hummingbird and Microstrategy to create various types of simple and complex report.

Document and test reports.

Sqribe Technologies – CA Aug, 1998 -May, 1999

Technical Support Analyst

ERP Systems

Sqr,Visual Sqribe,Power Sqribe

Description:

SQRIBE Technologies, The Enterprise Reporting Company, is a leader in the rapidly expanding enterprise reporting market. SQRIBE's vision is to provide the high-return enterprise reporting solution for the Web-enabled business, enabling companies to improve the quality and speed of decision making at every level of the organization. SQRIBE Enterprise is an integrated solution designed to leverage a company's investment in data warehouses, ERP systems, and other software, hardware, and networking infrastructure technologies.

Responsibilities:

Troubleshoot, test, write, modify, edit, and debug customer codes.

Develop sample programs for clients.

Install, maintain, document, and test development software.

Train clients in SQR, VisualSqribe, PowerSqribe, and ReportMart.

REFERENCES

Available upon request

Contact this candidate