Udaya Sri

510-***-****

acw7yg@r.postjobfree.com

Objective To acquire a challenging and responsible position in an environment where I can best utilize my skills and education.

Education Masters of Science in Electrical Engineering Graduated- Dec14

Fairleigh Dickinson University, Hackensack, New Jersey GPA: 3.5/4.0

Bachelor of Science in Electrical Engineering Graduated–Jul 12

Osmania University, Hyderabad, India GPA: 3.3/4.0

Technical Skills:

Databases: Oracle, DB2 and MS SQL Server

Reporting Tools: Tableau, Spotfire, Peoplesoft

Defect Reporting Tools: HPQC, Visual Studio

MS-Office Suite: MS Word, MS Excel, MS Project

Professional Summary

Created Crosstab reports to display underlying data based on various graphs and charts created for further data analysis.

Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

Prepared dashboards using calculated fields for different logics for trends, extended price calculations for different cost types, parameters, calculations, groups, sets and hierarchies in Tableau.

Ensured the user security for the views using User filters and shared with business users.

Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard and created tableau functional design document.

Mentored business power users to create reports/dashboards using tableau desktop.

Designed and Developed various analytical reports from multiple data sources by blending data.

Dashboard Visualization through Tableau BI application.

Worked with Business Analyst and the Business users to understand the user requirements, 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.

Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan

Professional Experience

Client: Alliance Data systems, Dallas, Texas Jun16 -Current

Role: Tableau Report Developer/Analyst

Preparing Dashboards using calculations, parameters in Tableau.

Understanding of relational database structures, theories, principles, and practices.

Created drill down and drill up in worksheets in tableau.

Involved in creating a dual-axis bar chart with multiple measures.

Created report schedules on Tableau server.

Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

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.

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.

Client: Hughes Network Systems, Germantown, MD Nov14 -May 16

Role: Tableau Report Developer

Developed interactive data visualizations and developed automated processes for updating content used in standardized Dashboards.

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

Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

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.

Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Reviewed SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Created Views in Tableau Desktop which were published to internal team for review and further data analysis and customization using filters and actions.

Involved in creating calculated fields, mapping, hierarchies and Drill through Reports.

Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.

Implemented best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.

Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.

Client: ZS Pharmacy, Redwood City, California Sep13 -Oct14

Role: BI Report Developer

Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

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

Worked with Trend Lines, Statistics, and Groups, hierarchies, Sets to create detailed summary level Report and Dashboard

Building and 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.

Effectively used data blending feature in tableau.

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

Executed and tested required queries and reports before publishing.

Create, customize & share interactive web dashboards in minutes with simple drag & drop.

See a comprehensive view of your sales pipeline and results.

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

Client: Satyam, Hyderabad, India Aug12 – Aug13

Title : SQL Developer

Understand the business requirement and preparation of Business Requirement specification.

Worked with the Project Manager and Data Analyst. Assisted the designer in designing by doing source data analysis, rectifying the requirement documents, creating source to target mappings.

Provided extended production support based on the demand and complexity of the issue.

Involved in requirements gathering, designing functional and technical specifications for reporting needs.

Worked with Business Analyst and Reporting and Information Delivery Architect to design solutions that simultaneously meet both functional and architectural requirements.

Developed Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies.

Did error analysis for continued improvement of the system by catching data anomalies and code issues.

Created design to handle huge amount of data and perform business related operations.

Set up the Topology including physical architecture, logical architecture and context.

Created new models for the data sources flat files, XML, Oracle, and SQL Server.

Did reverse engineering for the data sources and targets.

Identify production and non production application issues.

Develop technical designs for application development.

Develop and execute unit test plans.

Prepare all project timeline and prepare schedule for all deliverables and prepare design for Java applications and documents all project deliverables and ensure compliance to all quality guidelines.

Developed interfaces to load the data from flat files, xml and oracle database to Oracle target DB

Client: Engineering Intern, Medha Servo Motors, AP May 11- Jun 11

Analyzed and provided recommendations on phase balancing for 25 distribution systems

Performed load flow and voltage drop analysis on all the 25 substations

Coordinated construction work plan

Special Qualifications

Fast and autonomous learning capability, self-motivated, very good, communication skills, goal oriented, organized, dedicated and reliable.

Contact this candidate