Home

Sravani N - Data Analyst

[email protected]

Location: Eden Prairie, Minnesota, USA

Relocation: yes

Visa: H1B

Resume file: Sravani N Resume_1750772072773.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Sravani N +1 6123061777 [email protected] DATA ANALYST Professional Summary: Around 9+ years experience including Analysis, modelling, design and development of Tableau reports and Dashboards for analytics and reporting applications using Tableau. Extensive experience in Tableau Desktop, Tableau Reader and Tableau Public in various versions of Tableau like 10,9.0,8.3,8.1,8.0. Experience in configuration of backgrounds jobs, scheduling of the extract refresh activity, troubleshooting failed refresh activity, monitoring dashboards performance on tableau server. Experience in deploying and designing data using Tableau. Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau. Hands on experience in creating Dashboards as needed using Tableau Desktop and published in Tableau Server. Good understanding of Tableau Desktop architecture for designing and developing dashboards. Expertise in reporting and analytic applications and tools to drive sales and revenue growth. Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage. Creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop. Proficient in applying calculated fields, Hide/Unhide columns, creating parameters. Practiced live and extract options in tableau. Maintained efficiency of reports by generating graphs, tables templates. Responsible for coordination and management of applications development, specifically related to Tableau, in conjunction with the design, development, and maintenance of custom applications. ETL experience in Informatica PowerCenter (Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer, Transformation Developer, Workflow Designer, Worklet Designer, Task Developer, Mappings, Mapplets, Workflows, Sessions, and Shortcuts.) Good understanding of Oracle SQL and SQL tuning. Attempted to drive productivity through KPI metrics, automation characteristics, and customer projects. Possessed Good communication, presentation, and interpersonal skills. Quick learner, ability to meet deliverables on time, provided good service for customers by modifying and changing the reports as per their requirements. TECHNICAL SKILLS: Reporting Tools Tableau Desktop v2021.2, v2020.3/4, v9, v8, Tableau Serverv2020.3/4, v9, v8, Tableau Online, Tableau Public, Tableau Reader, Tableau Prep ETL Tool Informatica PowerCenter Languages PL/SQL, T-SQL. Data Bases Oracle 12c, Oracle 11g, 10g, 9i, MS SQL Server Project Methodologies Waterfall, Agile(scrum). MS Office Suite Word, Excel, Access, PowerPoint, Project, Outlook Wells Fargo, Plano Feb 24 - Till Date Data Analyst Responsibilities: Involved in requirements gathering, analysis, design, development, change management, deployment, and user training. Involved in reviewing business requirements and analyzing data sources form Excel/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation. Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau. Created complex data Views using multiple measures, also used sort, Filter, group, Create Set Functionality. Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers. Published Reports, workbooks & data source to server and exporting the reports in different Formats. Converted charts into Crosstabs for further underlying data analysis in MS Excel. Blended data from multiple databases into one report by selecting primary keys from each Database for data validation. Combined views and reports into interactive dashboards in Tableau Desktop that were presented To Business Users, Program Managers, and End Users. Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by Connecting live/dynamic and static datasets. Tested dashboards to ensure data was matching as per the business requirements and if there. were any changes in underlying data. 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. Worked on Jira ticketing system procedure for issues and tasks, update the tickets with proper explanation. Environment: Tableau Desktop 2018.3.12, Tableau Server, SQL, MS Office Suite. Aspire Technologies, Hyderabad, India Oct 2020 Apr 2023 Data Analyst Responsibilities: Gathered, interpreted, and analyzed business requirements and use cases, develop prototypes via iterative practices, and design reporting solutions (dashboards, scorecards, etc.) that met user cases/requirements, as well as achieve ease of usability and self-service capabilities. Perform data integration, write efficient SQL Queries, and develop/deploy reporting solutions that apply data visualization standards and best practices, and meet quality standards by performing unit testing. Created documentation and technical specifications for reporting solutions, developed procedures/standard work, support readiness/training activities to end users. Created Crosstab reports to display underlying data based on various graphs and charts created for further data. Developed meaningful, efficient dashboards and visualizations using leading platforms, primarily Tableau. Designed, developed and published customized interactive reports /dashboards and scheduled data refreshes for reports on Tableau Online. Developed story telling dashboards in Tableau Desktop and published them on to Tableau Serve which allowed end users to understand the data on the fly with quick filters to filter needed information. Using data blending, blended by from the multiple data sources, selected primary key for data validation. Created compound and dynamic reports with sets, groups and hierarchies. Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau. Proof read all documents and maintain accuracy of information, prepared SOP. Created complex dashboards using filters, calculations based on requirements and linked reports. Reviewed basic SQL queries and edited inner, left and right joins in tableau desktop by connecting live/dynamic and static data sets. Created views in tableau desktop that were published to internal team for review and further data analysis and customization using filters and actions. Designed graphs and tables visually exciting and aesthetically pleasing, without any loss in information. Environment: Tableau9.2,10, Oracle 11g, PL/SQL, Windows Value Labs, Hyderabad, India Feb 2019 - Sep 2020 Data Analyst Responsibilities: Understood the analytic needs of clients and translated them into meaningful and actionable data visualizations. Derived data from SQL Queries and Stored procedures utilized to generate reports in tableau. Created complex workbooks and dashboards by connecting multiple data sources using data blending. Translated complex reporting needs into technical specifications, including calculations, custom groups, parameters, filtering criteria. Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop to validate static and dynamic data for data validation. Effectively used data blending feature in tableau and defined best practices for Tableau report development. Using Tableau desktop performed dashboard development activities such as calculations, calculated fields, hierarchies, filters, Actions. Worked on the development Dashboard reports for Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure. As per project requirement added parameters to visualize KPI at specified constraints. Customized the tooltips and labels to user understandable format. For example, changing the numerical measure for representing the revenue, expense and margins as currency values. Developed complex reports and visualizations using Tableau Desktop as per requirements. Environment: Tableau desktop 9.2, Oracle 11g, PL/SQL, Windows. Tera soft India Pvt ltd, Hyderabad, India May 2017 - Jan 2019 Data analyst Responsibilities: Designed and developed Summary/ Aggregate tables using procedures and views from SQL. Elicited, translated, and simplified requirements. Achieved business insights for customers by designing visualization reports using tableau. Utilized filters like quick filters, data source filters, global filters, context filters and user filters in Tableau. Created groups, sets, bins and performed conditional sorting and filtering as per the requirements. Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet, Tree maps, Bubble Charts, to assist business users in solving complex problems. Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding. Created Sets, Groups and Data Bins as per user requirements. Created various views in Tableau like tree maps, bar chart, pie chart. Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in tableau desktop. Participated in project planning sessions with management and end users to analyze business requirements for real-time and historical reports and dashboards. Worked on iteration basis to make sure the deliverables are achieved on time. Created SQL Queries at the custom level to pull the data in tableau desktop. Wrote complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators. Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationship between tables using Primary Key and Foreign Key Constraints. Built reporting against Single, Multiple Tables, Views, Materialized Views, and Complex Custom SQL. Deleted useless tables, store procedures and views to improve the efficiency of database. Sound knowledge on oracle database. Wrote Custom SQL Queries to join data from multiple tables. Environment: Tableau desktop 8.0, Oracle 11g, PL/SQL, Windows. Infotech Enterprises - Hyderabad, India Sept 2014 - April 2017 Data Analyst Responsibilities: Used different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregator, Sequence Generator, Joiner, Union, Filter, Update Strategy and Router transformations in the mappings. Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting. Developed (SCD T1) and (SCD T2) to capture new changes while maintaining the historic information. Worked on developing the Jobs in Development, Testing the flow using placeholders, migrating the Jobs to higher environments like SIT, UAT & RT along with other team members. Worked on several scenarios of using triggers, resources and events in WLM/Control M. Coordinating with the team to deliver the tasks within the SLA. Worked on WLM/CTM related development and production issues. Supported EDWARD and BI applications. Worked on the conversion process i.e. Change the properties of the folders and created dummy folders to handle cross dependencies etc Preparing the case study documents. Analysed designs and creating event and Pred File watcher in Control-M. Analysing the requirements and creation of one-time load UNIX scripts. Understanding and documenting the Job sets properties, event designs, resources for each application (EDWARD/BI) in WLM. Ensure timely deployment, Quality and Testing of interfaces to improve the overall productivity. Environment: Informatica Power Center 9.1.0, Teradata, UNIX, WLM, Windows XP, Control M. Education: Concordia University St. Paul, St. Paul, Minnesota December 2024 Amritasai Institute of Science and Technology, Paritala, Andhra Pradesh 2010 -2014 Keywords: business intelligence microsoft procedural language