Sql Server Data

Manasvi Reddy Email:***************@*****.***

Tableau Developer/Analyst

Career Summary

Over 7+ years of total IT experience in Analysis of data, designing the data, Development of structured data, Documentation and Implementation of Business Intelligence applications.

Experience in Tableau Desktop and basics of Tableau Server in various version of tableau including Tableau 7 x and Tableau 8x.

Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analytics projects.

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

Involved in Trouble Shooting, performance basis checks of the reports, analyzing and rectifying issues within Tableau Server and dashboards.

Extensive Tableau Experience in Tableau Administration and Enterprise environment experience including technical support, Troubleshooting, Report design and Monitoring of system administration parameters.

Experience in Tableau Administration Tool for creating users, groups, sites projects etc.

Experience on creating visualizations and analytics using ROAMBI.

Experience in managing licenses, data connections, scheduling tasks, set in views by integrating with other platforms like SharePoint.

Experience in Tableau Architecture, functionality of each component.

Extensive experience on building dashboards using Tableau Desktop.

Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.

Working Knowledge of Qlikview 11.

Experience usage of Data Blending for joining Multiple Data Sources.

Worked extensively with Calculations, Parameters, Background images, Mapping, Advanced Analysis Actions.

Experience on Star schema and Snowflake schema.

Translate product requirements and business questions into report requirements and visualization dashboards.

Extensive experience on using functions like Index, Discrete, Table down, Table across, Pane Down, Product Category.

Knowledge on Business Objects, Supporting the customer reports by enhancing the decision making which includes relevant and factual data.

Ability to analyze data and create queries and reports using Web Intelligence.

Assisted BI team in learning Tableau and addressing development roadblocks.

Have a clear understanding of building Dimensional Models, Data warehouse architecture.

Extensive experience on setting of multiple filters using Default filters, Show quick Filters, Context filters and Cascading filters.

Strong complex reporting skills utilizing Burst Reports, Crystal reports, Summary reports, Complex Drill-Through and Discontinuous Cross-Tabs.

Deep dive into VIZQL, Fast Data Engine.

Experience in Tableau Reader, Tableau Public.

Hands-on experience on various Functions, Sets, Parameters.

Experience on various types of Joins and Queries.

Deploying interactive dashboards, visualizations and story.

Extensive usage of Data Blending multiple data sources into a single dashboard.

Experience on Custom SQL, Pivot, Assume referential integrity, Join Culling.

Experience on Tableau Analytical Issues including pitfalls and solutions.

Outstanding team player with good interpersonal and communication skills and the ability to work in a team or as an individual.

Excellent problem-solving skills with excellent business communication.

Technical Skills:

BI Tools

Tableau 7.0, 8.0, 9.0, QlikView11 (Trained), MS Excel, ROAMBI, Spot Fire, MS Office, Outlook, Cognos.

Relational Databases

MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, ETL, Teradata, MS Access.

Tools and Packages

SQL Server Management Studio, Microsoft Visual Studio, Toad, ETL (SSIS,SSAS,SSRS).

Languages

SQL, C, C++, HTML, CSS, PHP.

Operating Systems

Windows 9x/XP/2000/Vista/7, Unix, Linux.

Configuration Management Tools

Team Foundation Server, IBM Data Management.

Professional Experience

Client: Pfizer, New York, NY

Designation: Tableau Developer Dec 2014 – Till date

Description:

Pfizer Inc. is a world’s largest pharmaceutical company developing vaccines and medicines for an extensive range of medical disciplines. The project is intended to provide the Quarterly and yearly growth Reports to Senior Executive Directors. Leading the team in an agile-driven environment of development.

Key Responsibilities:

As a Tableau Developer, will create and Analyze Reporting within Tableau based on the business requirement.

Interact with the business analysts and customers for assessing the requirements and needs, described, documented, and performed impact analysis.

Analyze the data from different data sources and develop Tableau Reports.

Imported Data from Oracle data source and built dashboards in Tableau.

Enhance and refine the technical architecture to keep in pace with new tableau software releases and changing business demands.

Creation of dashboards with Combination Charts, Custom Charts based on the customer requirement.

Testing and retrieving and validating the data using SQL statements.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Continuous Client Interactions for analyzing business requirements.

Developed Compelling, Interactive Dashboards in Tableau.

Developed Tableau visualizations to support Data Summary, Analytical Reports.

Trained the business users on tableau’s self-service model of Creating and Publishing the Reports.

Built Complex Formulas (using “calculated-field” feature) in Tableau for various business calculations.

Documenting the end user requirements, testing it and providing solutions.

Managing and supervising the team on business requirements and accomplishing the tasks before deadline.

Migrated Legacy system from Oracle Forms into Tableau Dashboards.

Worked on Ad-Hoc Reports based on business requirements.

Management of Metadata to perform routine management tasks.

Developed complex visualizations using Amazon Redshift.

Provided resolution to performance problems of dashboards deployed on tableau server using out of the box performance analyzer tool of tableau desktop and tableau server.

Strong SQL skills including use of nested expressions, unions, multi-table joins.

Developed business reports intelligence applications of Tableau Pivotal GreenPlum Database, MapR Hadoop Hive.

Worked on SAP BO, analysis and retrieving of the data.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.

Developed Cross Tab, Chart, Line, and Drill Through Reports in Tableau.

Created complex reports by using Multiple Formulas, Joins and Queries.

Administered user, user groups, and scheduled instances of data refresh activity to be consumed by Tableau reports.

Environment: Tableau Desktop 9.0/8.2/8.0, Tableau Server 8.2, Oracle 11g, MYSQL Server, MS SQL Server 2008, Excel, TSQL, UNIX, SQL Server 2008, MS Office.

Client: L Brands, Columbus, OH

Designation: BI/Tableau Developer Oct 2013 – Sep 2014

Description:

L Brands is a Fortune 500 company. It is a fashion based retail industry. As a part of BI Team we provide Business growth reports of all the products. As a part of BI team we provide business growth reports of all the products and migration of the spot fire reports to tableau visualization and extension.

Key Responsibilities:

Understanding Business Requirement and providing solutions by analyzing data sets.

Develop and deliver the data infrastructure required to support needs of predictive modeling.

Query Data from Hadoop/Hive & MySQL data sources to build visualization in Tableau.

Developed Compelling, Interactive Dashboards in Tableau.

Developed Tableau visualizations to support ad-hoc analyses.

Build information platform or data spaces designed for exploring and understanding the data.

Trained the business users on tableau’s self-service model of Creating and Publishing the reports.

Creating and publishing reports by Firebird.

Design/lead/develop prototypes for business solutions (dimensional models, model builds) so that end users may understand and have a clear cut idea of visualizations and explore a new feature.

Manage the team in task allocations and completion of works.

Knowledge of various components within Cognos and how they interact with each other.

Created global sort of different scenarios of the report including filters, extensive columns like sales vs last year, and transactions vs last year using ROAMBI.

Ensured prototypes meet the organization standards to allow transfer to production.

Managed and efficiently allocate analytic resources (e.g. tools, storage) for QRA. Forecast and maintain storage space and resource availability.

Developed complex reports using Parameters, Sets and by using multiple queries and joins.

Build relationship with Technology partners. Support communication and cooperation between the teams.

Environment: Tableau Server 7, Tableau Desktop 8.1, MS SQL Server 2008, Excel, UNIX, SQL Server 2008, Oracle 11g, Toad, ROAMBI, Qlikview.

Client: MetLife, Somerset, NJ

Designation: BI & Reporting Developer - Tableau Nov 2012 – Aug 2013

Description:

MetLife, Inc. is a leading global provider of insurance, annuities and employee benefit programs. As a member of their BI Team, designed and created dashboards and packages according to the customer requirements. Generated various Query related subjects using SQL and calculation of complex queries.

Key Responsibilities:

Created Tableau worksheet and dashboards which involves Schema Import, Implementing the business logic by customization.

Created Data Connections, published on Tableau Server for usage with Operational Dashboards and story points.

Built Complex Formulas (using “calculated-field” feature) in Tableau for various business calculations.

Spot Fire: Created analytics, dashboards, reports by using main concepts like data on demand, filtering scheme and property controls etc.

Worked on query subjects, relationships within query subjects; iqd's for cubes, importing views, tables in Framework Manager & established Package security and published packages to Cognos Report Studio.

Provided resolution to performance problems of dashboards deployed on tableau server using out of the box performance analyzer tool of tableau desktop and tableau server.

Created and assisted end users in Tableau dashboard development.

Administered and provided production support for Enterprise wide Tableau application consisting of multiple functional business units responsible for operations and strategic decision making.

Technical documentation with the concepts of various business processes integration.

Designed and developed reports using Qlikview.

Maintained and supported Microsoft Team Foundation Server (TFS) to give access for code management from various sources and reporting in a multi-team environment.

Optimized queries by interpretation of valuable data.

Developed performance management dashboards internally and externally by using Crystal Reports.

Environment: Tableau Desktop 7, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, MS Office, Visual Studio 2010, ROAMBI.

Client: Blue Cross Blue Shield of Florida, FL

Designation: BI Consultant Nov 2010 to Oct 2012

Description:

Blue Cross Blue Shield Provide insurance to more than 100 million Americans. As a part of BI team our project is to provide the Year on Year growth of Government employee’s insurance usage and claims. Created forecasting reports for predicting and observing trends in tableau for upcoming years.

Key Responsibilities:

Involved in Gathering Business Requirements for the Model and for developing reports from the business users.

Created Framework Manager Packages with various security settings defining the cardinalities and namespaces and published them onto Cognos Connection.

Established Relationships and Joins between the query subjects of the Model.

Implemented object level security for query subjects and query items to make them available only for the end users who are authorized.

Developed various reports using table’s types like Table Across, Pane Down, Pane Across.

Enhanced reports with new features and functionality based on the business requirements.

Developed List, Cross Tab, Chart and Drill through Reports in tableau.

Worked on Context Filters and Cascading Filters page and implemented various parameters, filters, calculated table calculations, aggregations, specific conditions, & created analytical reports.

Scheduled reports in Cognos Connection based on the reports to run daily, weekly basis using Event Studio.

Created and analyzed various reports, dashboards in Micro Strategy and created the same using Tableau desktop.

Using Tableau for creating reports of existing Micro-Strategy reports for Finance and Merchandizing subject areas.

Prepared the design documents using Crystal Reports.

Developed many reports using the conditional variables according to the need of end users.

Testing and improving report performance, performance tuning on complex reports on the report level.

Worked on scheduling reports to run Monthly, weekly and daily basis using scheduler.

For enhancement of New business strategies modified the existing mappings.

Environment: Tableau 6.0, Oracle 10g, SQL, PL/SQL, Toad for Data Analyst 2.5, Windows XP, Unix, ROAMBI, Micro-strategy.

Client: GD Inc., India

Designation: BI Consultant June 2008 to Sep 2010

Description:

Part of GD Inc. reporting structure is based on Tableau and MS products. As a member of BI Team, successful execution of multiple consulting and customized projects for industry clientele from the Pharmaceuticals and Biotechnology domain. Syndicated Research and Business Intelligence, Journals and Conference Intelligence.

Key Responsibilities:

To develop Custom Reports for all Clinical phases.

Created complex filters using Parameters, Query related items.

Handled Complex Queries as separate Query Subjects.

Updated various database changes into the Framework manger model.

To work with Sales and Distribution Team to develop better client demonstrations.

To Design process functionalities for Quarterly audits.

To design Syndicated Data reports for internal drug intelligence database.

Delivered Software functionalities for Global Data Integrated Platform.

Collecting data from various journals and giving meaning to the data by analyzing and structuring.

Created reports Using Quick table calculations and business calculations like Year over Year growth, Running Total, Rank etc.

Dealing with Metadata and creating, generating reports quarterly wise, validating the data with sales team.

Contacting the sales and finance team working on managing metadata for checking routine management tasks.

Sending the Visualized Data to clients as an overview of our company products.

Collecting basic information of Principal Investigators, doing research of the data collected and inserting in a tool.

To work in tandem with the Sales and Distribution teams to develop better client demonstrations and ensure better client handling.

Environment: MS Excel, Oracle 9i, Windows 2003, Unix, Linux.

Contact this candidate