Data Manager

Karthik Reddy Lakkireddy

Email: acvavc@r.postjobfree.com 571-***-****

Tableau Developer

Summary

Eight years of professional IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing, Data Integration.

4 Years of progressive experience in Tableau. 9/8/7/6 versions for Business Analysis, Reporting and Dash-boarding for enterprise applications, experience on Tableau server side and 4 years on Informatica Power Center.

Developing, Designing and supporting interactive Tableau Dashboard reports.

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

Applied different filters like normal filters, quick filters, context filters, sharing filters, use as filters, user filters.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report.

Extensive experience on building Interactive dashboards using Tableau.

Established Best Practices for Enterprise Tableau Environment and application intake and development processes.

End to End experience in designing and deploying date visualization using tableau.

Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center 9.x/ 8.x.

Strong Data warehousing ETL experience in Informatica power center client tools (Power center designer, workflow manager, workflow monitor & Repository Manager) and Power Exchange

Good in data warehouse concepts/data warehouse architecture and best practices.

Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance.

Worked on various heterogeneous sources like Oracle, SQL, XML files etc.

Experience in Performance tuning of targets, sources, mappings and sessions.

Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

Strong positive communications and working relationships at all business levels.

TECHNICAL KNOWLEDGE:

Software / Applications : MS XP, MS 2000, MS Word, MS Excel, MS Access, Outlook, PowerPoint.

Database : Oracle 11g/10g/9i

BI Reporting Tools : Tableau Desktop, Tableau Server

ETL : Informatica Power Center 8X/9X

Programming Languages : SQL, PL/SQL.

Tools : TOAD, Harvest, ALM, WINSCP

Operating Systems : UNIX, Windows NT/98/2000/2003

Projects:

Client : Amtrak, Washington D.C

Duration : Sep’14- Till Date

Role : Tableau Developer / Administrator

Firm Snippet:

The National Railroad Passenger Corporation, Amtrak, is a corporation striving to deliver a high quality, safe, on-time rail passenger service that exceeds customer expectations.

Roles &Responsibilities:

Responsible for Preparing the Report Design specifications based on the User’s requirement.

Handled Tableau admin activities granting access, managing extracts and Installations.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

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

Analyzed the source data and handled efficiently by modifying the data types.

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Generated context filters and used performance actions while handling huge volume of data.

Generated tableau dashboards for sales with forecast and reference lines.

User Java Script API to customize the views, selects, filters, date and time.

Generated tableau dashboards with combination charts for clear understanding.

Created Reports and Templates according to the requirements which include Filters, Cal-culations, Prompt controls, Member Summary options, and Conditional Formatting, Drill-through & Master-Detail relationships.

Created different type of charts.

Created worksheets and dashboards by using custom queries and multiple tables.

Created various interactive customized dashboards and stories.

Applied various types filters like Data source filters, Quick filters and Context Filters.

Created table calculations, calculated fields and parameters.

Extracted data from various sources and performed data blending.

Publishing sheets and dashboards on server.

Developed complex reports and visualizations using Tableau Desktop as per requirements.

Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.

Define best practices for Tableau report development.

Administer user, user groups, and scheduled instances for reports in Tableau.

Execute and tested required queries and reports before publishing.

Executed and tested required queries and reports before publishing.

Involved in gathering the requirements and analyzing the requirements and interact with the customer to find the proper information.

Develop implement and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.

Validate the data for each report and review the reports.

Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.

Updating the weekly status and tracking the query sheet.

Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters and date functions.

Created Stories using Tableau as part of report presentations to Business.

Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

Delivered reports on time with all the required documents as report specification and Unit testing.

Reviewed reports as per guidelines to avoid defects in UAT.

Environment : Windows XP, Tableau Desktop(Version 8.1.2 – Version 9.0.2), Tableau Server(Version 8.1.2 – Version 9.0.2), SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel, Informatica.

Client : British Petroleum, Houston TX

Duration : April 2012 to Aug 2014

Role : Tableau Developer

Firm Snippet:

BP's commitment to the U.S. dates back 150 years through our heritage companies, Atlantic Refining and Richfield Petroleum. In the 1960s, the two companies merged, forming Atlantic Richfield or ARCO for short. That same decade, Standard Oil of Ohio (Sohio) and BP reached a deal that led to the first oil to flow from the North Slope of Alaska through the Trans-Alaska pipeline in 1977. Ten years later, BP acquired Sohio and made it the cornerstone of a new national operation, BP America. In 1998, Amoco and BP announced their merger, combining their worldwide operations into a single organization. Overnight, the new company became the largest producer of both oil and natural gas in the U.S. Fast-forward to today: BP is leading the way in helping to meet the energy needs both of America and the world.

Description:

Gather and analyze the business requirements and then translate them to technical specifications.

Created different views in workbook to visually analyze data.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Created External filter, internal filter and Context filter to improve performance.

Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Created Level of Detail Expressions and Date functions.

Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

Created parameters and quick filters. Created sets to display top products based on their sale.

Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Created Dashboards with interactive views, trends and drill downs.

Published Workbooks and Dashboards to the Tableau server.

Performance Tuning of Dashboards and working with users and Database teams for design review and modeling.

Combined visualizations into Interactive Dashboards and publish them to the web.

Created groups and users in Tableau server

Involved working in POC to various team for their Adhoc analysis of data with Tableau.

Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 7/6 Desktop, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/ XP.

Client : ValueLabs LLP, India

Duration : July-2011 to Feb-2012

Role : ETL Informatica Developer

Description: Over the last 18 years, have grown into a leading mid-sized IT solutions and services provider. 5,000-people-strong organization, with a presence across the US, UK / Europe, Middle East, Asia-Pacific and Australia, serving over a 100 clients in multiple industries. Over the years, we have developed many long-standing client relationships – 15 of our clients consider us a strategic partner, with the average tenure of these strategic engagements being eight-and-a-half years. Traditionally, topline growth has been twice the industry average, with regrettable attrition being less than a third of the industry. We have also acquired several marquee clients during our journey.

Responsibilities:

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalize, Sorter and Union to develop robust mappings in the Informatica Designer.

Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

Extensively used workflow variables, mapping parameters and mapping variables.

Involved in Unit, Integration, System, and Performance testing levels.

Prepared documents to describe transformation logic, coding, testing, and changes.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Involved in production support and Maintenance of the applications.

Environment: Informatica Power Center 9.5.1, Oracle 11g, PL/SQL, WinSCP, Putty, TOAD.

Client : EA Sports, India

Duration : April-2008 to June-2011

Role : Application Developer

Responsibilities:

Involving in production maintenance for the entire system.

Identify the bugs in the system and fixed those bugs by enhance the mappings and the sessions.

Handling enhancement request for the entire One VIEW systems.

Developing mappings using Informatica for ETL

Trouble shooting implementation / post implementation issues

Handling trouble Service requests/concerns raised by users

Analyzing or identifying Data Issues If any be it related to Informatica and fix the same

Frequent communication with the customers to ensure that the reports are distributed on time within SLA or intimate them if there is any delay

Writing Unit and System Test Plan / Test Cases as per the requirements from the client.

Environment: Informatica Power Center 7.1.5, Oracle 11g, TOAD, Windows Server 2008.

Education Qualification:

Bachelors of Engineering - EEE, JNTU University, Year-2008.

Contact this candidate