Data Manager

MITHIL THANNERU

Phone: 248-***-**** (c)

Email: ac2x9s@r.postjobfree.com

SUMMARY:

•7+ years of IT experience in analysis, design, development, maintenance and building complex business analytics using Tableau development and server components, ETL processes using Informatica.

•Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using Tableau tools versions 8.x/10.0.

•Involved in Installation and configuration of Tableau Software.

•Gather requirements from business users, created technical specifications, estimation documents.

•Created different Interactive views in workbook to visually analyze data.

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

•Tableau development skill set including visualization development, use of parameters, and report optimization.

•Extensive knowledge in various reporting objects like Attributes, Hierarchies, Transformations, filters, calculated fields, Sets, Groups, Parameters etc., in Tableau.

•Proficient with Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Density Chart, etc.

•Experienced in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

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

•Develop and generate standard and ad hoc reporting capabilities from new and existing data sources

•Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

•Experience in to design and deploy rich Graphic visualizations with Drill Down menu option and parameterization using Tableau.

•Experienced in developing rich Interactive reports, dashboards and other user interface elements integrating various reporting components from multiple sources.

•Security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.

•Experience in integration of various data sources like Oracle, MS Excel and Flat Files into staging area and involved in SDLC for the projects.

•Expertise experience in design and development of decision support systems (DSS) and experience in Release management and Production Deployment activities, Production support.

•Experience in Data warehousing, Data migration and Data modeling.

•Experience in database development skills using Oracle PL/SQL to write stored procedures, functions, packages, and triggers.

•Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks using Workflow Manager to move data from multiple sources into targets.

•Experience in creation and customization of ETL extracts and load process using Informatica.

•Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.

•Good knowledge of Entity-Relationship concept, Facts and dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.

•Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.

•Extensive experience in Installation, Configuration, Administration and Maintenance of Microsoft SharePoint based solutions.

•Experience in using Informatica Data Quality (IDQ).

TECHNICAL SKILLS:

Tableau Tools

Tableau 8.x/10.x desktop and server

ETL tools

Informatica 8.x/9.x, Informatica IDQ

Database Modelling

Erwin, TOAD

Databases

Oracle 8i/9i/10g/11g, Teradata, DB2, SQL Server

Languages

SQL, PL/SQL

DB Tools

Toad, SQL Developer

Schedulers

N Alteryx, Informatica Scheduler, Autosys, DAC

OS

Windows 2012/2008/2003, UNIX

EDUCATION:

•Bachelors in Information Technology from JNTU, India.

PROFESSSIONAL EXPERIENCE:

Client: Cisco, Houston, TX Oct 2015 – Till Date

Role: Senior Tableau Consultant

Project Description:

Cisco Systems, Inc. (known as Cisco) is an American multinational technology conglomerate headquartered in San José, California, that develops, manufactures, and sells networking hardware, telecommunications equipment, and other high-technology services and products. Through its numerous acquired subsidiaries, such as OpenDNS, Cisco Meraki, and Cisco Jasper, Cisco specializes into specific tech markets, such as Internet of Things (IoT), domain security, and energy management.

Tools and Technologies: Tableau 10.X/9.X/8.X Desktop, Tableau server, Windows 2012/2008

Responsibilities:

•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.

•Experience with Tableau for Data Acquisition and data visualizations for client and customers.

•Using Multiple Measures like Individual Axes, Blended Axes, Dual Axes

•Involved in Custom Geo-Coding - by creating a CSV file and assigning geographic roles to fields not recognized by tableau.

•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.

•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.

•Involved in preparing the estimation documents, design document for new reports that are to be developed and involved in preparing the impact analysis document for a change that is imminent.

•Creating and setting privileges on Users/User Groups.

•Worked diligently individually and as team member to consistently reach client satisfaction levels.

Smartmonk Innovations/CVS Caremark, Dallas, TX Apr 2013 – Sept2015 Role: Tableau Consultant

Project Description: This project was implemented for CVS Caremark which is one of the nation's leading pharmacy benefit management (PBM) companies, provides comprehensive prescription benefit management services to over 2,000 health plans, including corporations, managed care organizations, insurance companies, unions and government entities.

Tools and Technologies: Tableau 8 Desktop, Tableau server, Windows 2008

Responsibilities:

•Designed and perfected the reporting requirement documents and the tracker logs to track and assign the work packets until they get completed /resolved.

•Created Schedules and Extracted the data into Tableau Data Engine.

•Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

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

•Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

•Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps

•Effectively used data blending feature in tableau.

•Defined best practices for Tableau report development.

•Administered user, user groups, and scheduled instances for reports in Tableau.

•Executed and tested required queries and reports before publishing.

•Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

•Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

•Converted Metric insight reports to tableau reports.

•Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

ZIPSCENE, Cincinnati, OH Mar 2012 – Feb 2013

TABLEAU DEVELOPER

Project Description: Zip scene is internet marketing service headquartered in Cincinnati, Ohio. This project makes restaurant marketing smarter by finding patterns in data. The project helps restaurant marketers use data to deeply understand guest dining habits and execute smarter techniques for more predictable and profitable results.

Tools and Technologies: Tableau 8 Desktop, Tableau server, Windows 2008

Responsibilities:

•Gathered user requirements, analysed and designed visualizations based on the requirements.

•Created aggregations, calculated Fields, Table calculations, Totals, percentages, Bubble chart, Analytics, drill down analysis using tableau desktop.

•Used Informatica to extract the data from Siebel CRM, transform and load to warehouse.

•Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters

•Created stories in Tableau using Story functionality.

•Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.

•Created Prompts, Conditions, Parameters, Sets, Local and Global filters, for various dashboards.

•Customized the tooltips and labels, to user understandable format.

•Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.

•Produced Forecasted Reports for the upcoming time to observe timely trends in Tableau.

•Generated views using multiple Measures like Individual Axes, Blended Axes, Dual Axes.

•Reviewed basic SQL queries and edited inner, left, and right joins in Tableau by connecting live and static datasets.

•Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Smartmonk Innovations/Wells Fargo, St. Louis, MO Jun 2011 – Jan 2012

ETL Developer

Project Description: Data Management team at Wells Fargo Advisors handles several projects involving ETL procedures with Oracle as their operational data store and IBM DB2 as the data warehouse. As an ETL developer, I was involved in several small scale to large scale projects.

Tools & Technologies: Informatica 8.6, Oracle 10G, IBM DB2, Sql Developer, IBM Data Studio, Autosys

Responsibilities:

•Requirement gathering, analysis and designing technical specifications for the data migration per the business requirement.

•Involved in data modelling discussions and provided valuable input from ETL perspective.

•Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.

•Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.

•Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.

•Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.

•Worked on complex Source Qualifier queries, Pre & 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.

•Performed metadata validation, reconciliation and appropriate error handling in ETL processes.

•Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

•Worked with Informatica Data Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.

•Prepared proof of concepts and business test cases using Informatica Data Quality (IDQ).

•Developed test cases and test plans to complete the unit testing. Support System testing.

•Planned and coordinated testing across multiple teams, tracked and reported status, created testing cycle plan, scenarios etc.

R-soft India Pvt. Ltd., Hyderabad, India June 2009 – Mar 2011

Role: SQL Developer

Tools and Technologies: Oracle 11i, SQL, PL/SQL, MSSQL, Windows Server

Responsibilities:

•Worked on the back-end part, written queries, and stored procedures. This helped where applications directly talk to the database.

•Worked as a DBA and created creating tables, users, rroles, permissions.

•Worked on the performance tuning part, as most of our applications have issues with the PL/SQL stored procedures.

•I have worked to design up new system based on requirements for front end. Also maintained already set up databases.

•Created Entity Relationship (ER) Diagrams to the proposed database

•Created database objects such as tables, views, stored procedures, Triggers etc.

•Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

•Identified columns for Primary Keys in all the tables at the design time and create them.

•Created functions to provide custom functionality as per the requirements.

•Be aware of potential blocking, deadlocking and written code to avoid those situations.

•Ensured that the code is written keeping in mind any security issues such as SQL Injection.

•Developed reports in SQL Server Reporting Services.

•Designed, Developed and Deployed SSIS Packages.

•Identified and written best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.

•Participated in discussions involving the application creation and understand the requirements and provided the back-end functionality for the applications.

•Participated in development and creation of Data warehouses.

•Created cubes in SQL Server Analysis Services.

Contact this candidate