Shireesha Reddy

Professional Summary:

* ***** ** ************ ********** in the field of IT, End to End ETL transactions, Business Intelligence, Project Management, Data Warehousing, Business/Data Analytics, Data Visualization, Data Integration and Data Modeling.

Skilled in BI tools of Tableau, Power BI, SSRS including report, query writing using SQL and building front end BI applications as per specifications.

Experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.

Hands on Experience in working with WDC (Web Data Connectors), Tableau Desktop, Tableau Admin and Tableau Server in various versions of Tableau 10, 9 and Tableau 8.

Experience in designing various Data Visualization Dashboards, gathering customer requirements, writing test cases, preparing analytical reports to help users to identify critical KPI's and partnering with developers to ensure full understanding of internal/external customer needs.

Secured Tableau Server by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.

Experience in creating extracts in Tableau from various source files including flat files, excel sheets, access files and different databases.

Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.

Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters. Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), End-to-End ETL validations.

Consulted with business clients, collaborated with developer teams, using data visualization tools, Such as Tableau, Power BI platform to create business intelligence visualizations.

Designed, developed and supported BI solutions, Involved in Debugging, monitoring, Tuning and troubleshooting issues/tickets. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

Strong proficiency in the full life cycle of business solution development with outstanding capabilities in analysis, problem definition and requirements gathering.

Hands on experience with SDLC models, SCRUM/Agile based analysis and project management.

Education:

Bachelor in Information Technology, JNTU

Certifications:

Sun Certified Java Programming (SCJP)

International Software Testing Qualifications Board (ISTQB)

Technical Skills:

ERP : Oracle 9i/10g

BI Tools : Tableau Desktop, Tableau Online, Tableau Server, Tableau Admin, Crystal Reports, Power BI, SSRS

ETL Tools : SQL Server Integration Services (SSIS), Data Stage, Informatica

GUI/IDE Tools : Microsoft Visual Studio, PUTTY, Toad

Testing Tools : HP QC, ALM, QTP, SOAP UI, TFS

Languages : C, C++, Java, SQL, UNIX Shell Programming, .Net, ETL

Web Technologies : HTML, XML, UML, Shell, Perl, VB Script, Java Script, UNIX

Databases : Oracle, SQL Server, MS Access, DB2

Operating Systems : Windows 7/XP/2000/NT/98, Linux, UNIX (Solaris, HP-UX)

PROFESSIONAL EXPERIENCE

Sherwin Williams, Cleveland, OH Aug 2014-Till Date

Tableau BI Developer / Data Analyst

The Sherwin-Williams Company is an American Fortune 500 company in the general building materials industry. The company, with headquarters in Cleveland, Ohio, primarily engages in the manufacture, distribution, and sale of paints, coatings and is mostly known through its Sherwin-Williams Paints line.

Responsibilities:

Served as a liaison between the business and the IT department by conducting weekly meetings with stakeholders, developers, QA Team to document any changes and apply them to Tableau reports as needed.

Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration and configuration for data warehouse with automated and manual field data collection systems.

Involved in creating database objects like tables, views and procedures, triggers and functions using SQL to provide definition, structure and to maintain data efficiently.

Extracted the data tables using custom generated queries from Excel files, Access/ SQL database and providing extracted data as an input to Tableau.

Designed dashboards on the concept of Dynamic availability where in a variety of worksheets/ Views were connected by Actions.

Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.

Extracted data from multiple data sources into internal data base by creating Database Objects.

Experience with Tableau as an administrator, including providing installation, maintenance, upgrades, scheduling, performance tuning and monitoring.

Developed various reports using different visualizations such as Donut charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles and Scatter Plots.

Used LOD functions like fixed, Include and Exclude to show revenue shrink and financial debts at different granularities such as region, state and stores.

Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.

Created action filters, parameters, KPI’s, calculated sets and hierarchies for preparing dashboards and worksheets in Tableau Desktop. Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live and extract datasets, VLOOKUP in Excel.

Worked effectively on Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries. Involved in Production Support based on priority.

Experience with Tableau as an administrator including providing installation, administration, configuration, maintenance, scheduling, performance tuning and upgrade.

Assurant Solutions, Miami, FL May 2013-Apr 2014

BI Analyst / Tableau Consultant

Headquartered in New York City, Assurant is 310 on the Fortune 500 list of the largest publicly traded companies in the United States. The application is used by customers all across the globe and is highly configurable in order to cater to demands of different market segments related to Insurance.

Responsibilities:

Implemented advanced collections for Accounts Receivables which increased the collections by 26% by conducting credit investigations, collected delinquent accounts and all credit related issues.

Making strategic recommendations on Data collection, integration and retention requirements incorporating business requirements and knowledge of best practices.

Upgrading Tableau Server, creating tableau sites, groups for admins, performance tuning of Tableau server, defining the user roles and responsibilities.

Built business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity.

Making Data Extractions for Budget from external Web Data Connectors (WDC) that impact the business.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Online, Involved in Performance Tuning of Tableau Reports.

Created External filter, internal filter and Context filter to improve performance. Quick filters to display as per user requirement.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Extensive experience in using all Level of Detail (LOD) expressions like Include, Fixed and Exclude to create visualizations that are different than the view level or visualizations level of detail.

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

Extensive knowledge in all types of aggregations like Sum, Average, Count, Count (distinct), Median, Minimum, Maximum, Percentile and Std.Deviation etc.

Developed Tableau workbooks from multiple data sources using Data Blending.

Provided 24/7-production support for Tableau users.

Involved in creating database objects like tables, views and procedures and functions using SQL.

Yearly and Quarterly Budget forecasting for ongoing, future Products with the help of BI Tools

(Tableau, Power BI).

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Effectively used data blending, filters, actions, Hierarchies feature in tableau and Power BI.

Created Power BI Dashboards (Power View, Power Query, Power Pivot and Power Maps), integrated them to share point.

Used Power BI (Power Pivot) to develop data analysis prototype, used power view and power map to visualize reports.

State Of West Virginia, Harrisburg PA Feb 2012-Mar 2013

SQL BI Developer

State of Virginia Integrated Eligibility is the largest affiliation of Healthcare Plans in the Virginia Department of Social Services in the Virginia State. The Virginia Department of Health and Human services program is to check if People are eligible for Medicare, Medicaid, Food Stamps (SNAP), Child Care and Temporary Assistance to Needy Families (TANF).

Responsibilities:

Actively participated in interaction with Team Lead and technical manager to fully understand the requirements of the system.

Developed SQL programs in T-SQL, writing Views, Stored Procedures, Joins and Queries with best execution plan.

Generated Sub-Reports, Cross-tab, Conditional, Drill Down reports, Drill through reports and Parameterized reports using SSRS.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.

Created Packages using Import and Export Wizard for exporting the data from Excel Spreadsheet to SQL Server.

Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.

Understanding the ETL process from the business requirement documents.

Developed test parameters using ETL process to map source data base to target data base.

Verified ETL process using Data Stage and validated the output data with expected results.

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.

Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS. Developed, monitored and deployed SSIS packages.

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Developed SQL queries to Insert, Update and Delete data in Database.

Worked on stored procedures, triggers and on substantial number of business analytical functions.

Cognizant Technology Solutions, India Sep 2010-Dec 2011

Data Analyst

Payment manager is a banking application that integrates end-to-end solution for the Customer and Business based Web Application, manages the total management of Electronic Billing, Payment Process.

Responsibilities:

Participated in analysis and testing of the redesigned brand web sites to ensure the highest level of quality.

Worked closely with the Business Users and SMEs to Define the Project scope for new clients and enhancement requests for existing clients.

Defined project deliverables, resources and timelines and documented them in MS Project.

Analyzed Gap between current state and desired future state to define enhancements and opportunities.

Coordinated with Technical Team, Project Manager, Business users for the requirements elicitation and review.

Worked with SMEs, Data architects, ETL and DBAs to elicit functional requirements and convert them into technical requirements and design definition.

Used interview, document analysis, data analysis, prototype, JAD sessions and workshops for requirements elicitations and conducted walk through sessions for requirements review and approval.

Project run with the testing of Agile Scrum methodology.

Prepared and maintained Requirement Traceability Matrix for requirement, change control, design, and development and testing.

Created and maintained data mapping based on client data and application requirement specifications.

Prepared data transformational rules documents and data dictionary for the downstream users.

Created test data for design and development, functional/regression and UAT testing.

Executed SQL queries to extract data on SQL Server and Oracle databases for data analysis and validation.

Created Business Requirements Document, User Processing Manual and other project artifacts.

Worked extensively to define test plan, test cases, and execution of testing using multiple scenarios and update/maintain issue log using HP ALM.

Worked closely with business to define Retirement Planning services, pension planning accounting and financial analysis retirement planning and investments.

References:

Available upon request.

Contact this candidate