Faridabhanu Karumanchi

Email: ada9ce@r.postjobfree.com

Phone: 980-***-****

SUMMARY

•9+ years of IT experience in analysis, design, development, testing, implementation and support on Data warehousing projects.

•6+ year’s extensive experience in working with Tableau 7.x/8.x/9.x/10 product suite (Desktop, Server, Public, Reader, Mobile) and other BI technologies like Micro strategy, PowerBI etc.

•4+ years of experience in Micro strategy 10.x/9.x/8.x Product Suites including Micro strategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligence Server.

•6+ year of experience with SQL Tables, Queries, Views, Store Procedures and Triggers.

•In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

•Hand on experience on Tableau 7.x/8.x/9.x /10.x as a Developer and Analyst.

•In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

•Experienced in Complete Software Development Life Cycle (SDLC) which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business Applications.

•Worked extensively on joining tables, multiple data connections using blending worked on data extracts, managing queries.

•Analyzed various reports, dashboards, scorecards in Micro strategy and created the same using Tableau desktop.

•Experience with all the modules of Micro strategy product suite namely Micro strategy intelligence Server, Web, Dashboard, Narrowcast Server and Desktop.

•Dashboards using calculations, parameters in Tableau.

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

•End to end experience in designing and deploying data visualizations using Tableau.

•Having Experience in design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.

•Respond to ad hoc data requests and conduct analysis to provide valuable insights to partner groups, including sales, product, operations and finance.

•Handled data extraction from multiple source platforms - Flat files, Oracle and SQL Server.

•Scheduling the jobs using Auto sys, crontab scheduling tool.

•Involved in Unit Testing, System Testing, and Integration Testing in pre-production environment.

•Experience includes technical support, troubleshooting, report design and monitoring of system usage.

•Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

•Knowledge of MSBI stack (SSIS/SSAS/SSRS). Have good Analytical and Problem Solving skills and Excellent Communication and Interpersonal Skills, ability to understand and adapt to new technologies and environments faster.

•Knowledge of Power BI and Micro strategy.

SKILLS & TOOLS

BI Tools : Tableau Desktop and Tableau Server (Tableau Administrator7/8/9), Tableau public, Tableau Reader, Tableau Online, Micro strategy, PowerBI, Qlikview/Qliksense.

Programming Languages : SQL, PL/SQL, Shell Scripting, Java Script, HTML, CSS

Databases : MS SQL Server, Oracle, MS Access, MS Excel

Operating Systems : Windows, UNIX

ETL TOOL : Informatics

Scheduling Tools : UNIX Crontab, Windows Task Scheduler

EDUCATION:

Bachelor of Engineering in Electronics and Communication from JNTU Hyderabad, INDIA.

Work Experience:

1. Wells Fargo, Charlotte, NC Sep2019-Till Now

Role: Analytical consultant/Sr.Tableau Developer

Description:

Whole Banking Provides financial solutions to business across the US and globally .our four major business line include Corporate & Investment Banking, Commercial Banking, group risk, finance, marketing, human relations and the Wholesale Chief Operating Office that support our business.

Responsibilities:

•Design, develop, test and maintain Tableau dashboards based on user requirements.

•Developed Tableau data visualization using praetor’s combo charts, Heat maps, Box and Whisker charts, Scatter plots, Geographic Map, Histograms etc.

•Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions.

•Developed LOD reports on various KPI's, Performed Tableau type conversion functions when connected to relational data sources.

• Maintained and Installed Tableau Server in all the environments. Performed UNIT testing and help the UAT testing team to performing various testing scenarios.

•Fixed the JIRA tickets raised during the UAT testing. Created incremental refreshes for data sources on Tableau server.

•Mastered in different Formatting techniques, using Annotations and Mark label. Developed effective and interactive Dashboards using Parameters and Actions.

•Implemented Quick Filters, Cascading Filters, Context Filters and Data Source Filters while handling huge volume of data.

•Developed effective and interactive Dashboards using Parameters and Actions. Strong Dashboard design experience and passionate practitioner of effective data visualization

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

•Published and shared views on Tableau server, scheduled extract refresh and subscriptions.

•Involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.

•Develop simple/complex sql queries, query tuning for data preparation for reporting.

• Provided support in building Web portal using HTML, CSS, JavaScript.

Environment: Tableau 10.5.7/10.2,SQL server Version 4.1.4.21.21, Oracle, Excel, GitHub.

2. Wells Fargo, Charlotte, NC

Role: Analytical Consultant/Tableau Developer Oct2018-June2019

Description: Wealth and Investment Management (WIM) businesses build enduring client relationships through sound, thoughtful and objective advice. We help our clients by developing individualized plans for everything from retirement goals to business succession planning, to family legacy intentions. Services include comprehensive planning and advice, investment management, brokerage, private banking, estate planning strategies, trust, insurance and both individual and institutional retirement.

Responsibilities:

•Interacting with Business users to gather requirements and prepare reports specifications document.

•Preparing data and mapping document.

•Created Queries to build data source for the tableau Dashboards.

•Created visualizations leveraging Tableau 10.5.7/10.2.

•Created action filters to interact from one dashboards to other in Tableau.

•Created complex formulas and Calculations.

•Created Complex dashboards for the Management analysis.

•Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculation fields on Tableau reports with blended data created dashboards using multiple data sources.

•Expert in design and deploying rich Graphic visualizations with Drill Down feature and Parameter. Produced attractive visuals/dashboards to convey the Story points of the data.

•Participated in business discussions with the users and created requirement documents from which the dashboards are created.

•Expert in analysis, design, development, testing, and production rollover of reporting and analysis

•Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

•Excellent communication skills in facing the end users and training them in using the tool.

•Site-related tasks include managing content and assign permissions, running extract refreshes, create groups and projects, monitoring site activity, adding users, and other content-related tasks. Grant Permissions

Environment: Tableau 10.5.7/10.2,SQL server Version 4.1.5, Oracle.

3. Michaelkors, NJ Mar2017-Sep2018

Role: Tableau Developer/Tableau Consultant

Description: Michael David Kors is an American sportswear fashion designer. He is the honorary chairman and chief creative officer for his company, Michael Kors Holdings Limited (NYSE: KORS), which sells men's and women's and ready-to-wear, accessories, watches, jewelry, footwear and fragrance.

Responsibilities:

•Participated in gathering BI requirements from various teams.

•Designed and developed interactive Tableau dashboards and reports and recommending Tableau and its visualization features for other teams

•Upgraded Tableau server from 8.0 to 9.0 in DEV and QA along with Migration of reports.

•Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business users, program Managers and End Users.

•Created action filters, parameters and calculated sets for preparing dashboards and worksheets In Tableau and effectively used data blending feature in Tableau.

•Built complex reports using advanced reporting functions like YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.

•Used advance charts visualizations in Tableau like Dual Axis, Box plots, Bullet Graphs, Tree maps, Bubble charts, Water Fall charts etc. to solve complex problems.

•Worked on metadata in SQL to return information about objects in database.

•Worked in writing complex SQL queries that involved multiple joins and users defines functions.

•Scheduled the tasks and time to time refresh data when the sources are published or extracted to server.

•Analyzed various reports, dashboards, scorecards in Micro strategy and created the same using Tableau desktop.

Environment: Tableau Desktop 10.5, Tableau Server 9.0, 8.0, Parameters, Action Filters, Complex Reports, Flat files, CSV Files, YTD & MTD Calculations, R Language, SQL Server Management Studio, Excel.

4. Key strata Princeton, NJ Dec 2015-Jan2017

Role: Micro strategy Developer

Description: Data warehouse and Intelligence Solutions Company. As a developer, had to pull data from

Heterogeneous source and created multi cross domain Interactive Dashboards to analyze different

Departments like HR, Finance, Sales and Marketing, IT in the organization to analyze their company performance and growth for different target of audience like Individuals, Managers, and senior level executive’s Key strata is a Data.

Responsibilities:

•Created and integrated Micro Strategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.

•Performance improvement was done on existing documents by using Micro Strategy Report Cache and Intelligent Cubes.

•Created highly interactive and complex reports in Micro Strategy Desktop and web and provided production support.

•Created Micro strategy Reporting - Templates, Filters, Metrics, consolidations, Prompts, custom group, and DataMart optimization of reports.

•Importing tables using Warehouse catalog and Creating Logical Tables.

•Worked on creating custom groups and consolidations as per requirements

•Working extensively with the end user, finalized the dashboard layout and worked on fine detail formatting for a desired look and feel.

•Designed and built Micro Strategy schemas with data architect.

•Created attributes and defined their relationship on schema objects.

•Constructed reports with view filters and derived metrics on a report for further analysis of report which reduced database load and improved response time to end users.

•Drilling options (Drill up down across) were used to generate ad-hoc reports.

•Customized reports, documents and deployed them to Micro Strategy web.

•Tested all the reports by running queries against the warehouse using SQL Navigator and also validated the queries with the Micro Strategy SQL engine generated queries.

•Created Transformations (table based, formula based) this week vs. last week analysis reporting.

•Provided support for QA and UAT.

•Worked along with MicroStrategy Knowledge Base to troubleshoot some report related issues.

•Converted old flash dashboards built on Microtrategy9.4 to current Presentation mode.

•Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.

•Tested report layouts, validated the SQL query, prompt orderings, export/print functionality and drilling options.

•Troubleshot and tuned MicroStrategy reports by analyzing the MicroStrategy generated SQL to determine data issues such as double counting, hitting incorrect fact tables, incorrect joins and insufficient data.

Environment: MicroStrategy 9.4.1,10.11,10.4(Architect, Desktop/ Developer, Web, Administrator, Object Manager), SQL Server, MicroStrategy SDK, Oracle 11g, Oracle SQL Developer, OLAP.

5. Progressive Group, Cleveland, OH

Role: Tableau Developer/Data Analyst May 2013 – Apr 2015 Description:

Progressive Group is an Insurance company where they are going to provide Service like auto insurance, information services of Automobiles like cars from different brands of Nissan, Volkswagen, Toyota and etc. The objective of this project is to create reporting that Increases Vehicle Owner/Operator interest in improving better customer service efficiency.

Responsibilities:

•Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.

•Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

•Analyzed requirements for various reports, dashboards and created proof of concept / prototype of the same using Tableau desktop.

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

•Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

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

•Modified view of reports using MS Power BI with implications of SSIS, SSRS.

•Extensively developed different types of visualizations in Tableau like Dual Axis, bar charts, Water Fall charts, Bullet graphs, box and whisker plots.

•Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once. Creating basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios.

•Implemented Grand Totals, Sub-totals, and Changing Aggregation for Customizing the Data.

•Created Hierarchies, sets, combined sets and Groups in Tableau.

•Generated ad hoc Tableau reports on demand for providers.

•Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

•Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

•Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

•Actively participated in clarification meeting with the Clients.

•Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.

Environment: Tableau 8.0 and 8.1, Microsoft SQL Server, Oracle, multiple data source extraction.

6. Healthsource RI, Rhode Island

Role: Tableau Developer Feb2012– Mar 2013

Description:

Health Source RI is the health insurance marketplace for the U.S. state of Rhode Island in the USA.

The health insurance marketplaces also called health exchanges are organizations set up to facilitate the purchase of health insurance in each state in accordance with Patient Protection and Affordable Care Act. The marketplace enables people and small businesses to purchase health Insurance, many at federally subsidized rates.

Responsibilities:

•Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

•Data blending implemented on Microsoft SQL server, Oracle database and generated interactive dashboards.

•Worked on Table Calculations with other Calculations, Sets, Grouping, and If/then Calculations.

•Created ad hoc reports to users in Tableau by connecting various data sources.

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

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

•Embedded Tableau views in to SharePoint

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

•Created Reports with forecast, reference lines and combination charts for clear understanding.

•Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports.

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

•Generated tableau dashboards for Dental Renewals, Medical Renewals, and Eligible & Employee Enrolls.

Environment: Tableau 8.3, Microsoft SQL Server, Oracle.

7.Safeway, Hyderabad, India

Role : Micro strategy Developer June 2008 – April 2011

Description:

The Safeway store chain consists of 68 conventional supermarkets in the Eastern United States. It’s offering a wide variety of food and household products, meat, fresh produce, dairy etc. the Company has located throughout & outside of the US, where the business involved is supermarkets. The stock is distributed from two centrally located warehouses after procuring from different vendors. The company has Operational systems for Purchase, Sales & Distribution, Stock maintenance, Customer management built to implement a centralized data base that collects and organizes and stores data from different operational systems, and historical data for the purpose of end user reporting.

Responsibilities:

•Worked with business users, development team and management to define needs and crafts user requirements (identifying application and schema objects necessary to meet requirements).

•Created and presented solutions and architecture design to client teams for approval (logical models, star schema or snowflake design, and schema objects configurations; hierarchies, drilling paths).

•Developed Micro strategy schema and application objects, reports, RS documents, dashboards.

•Assisting the team in integrating relational designs and business objects within their metadata and data warehouses.

•Tested and validated data by running SQL scripts to ensure continuous accuracy, ease-of-use, and integration with existing resources.

•Performed Micro strategy installations and configurations and troubleshooting ODBC DSN connectivity issues

•Worked with advisory architecture and development teams on guiding the design and development of new Micro strategy design standards, with a focus on enhanced insight capabilities.

•Built Intelligent Cubes and set them up for optimal complex document performance in need of 20,000,000+ records.

•Last but not least, migrated projects across the SDLC.

Environment: Micro strategy v8,v9,0.1,SQL SERVER 2005,Oracle 9g,DB2,MS Access, Teradata, Sybase.

Contact this candidate