ANUSHA TATIKONDA

Denver, CO 720-***-**** adk7h9@r.postjobfree.com

Career Objective

Over 6 years of diverse experience in information technology with an emphasis on Software Quality Assurance & Tableau Development in industries like Telecom, Banking and Insurance. To Purse a highly responsible and challenging position with a turbulent and dynamic organization where I can apply my experience, knowledge and creativity to acquire new skills and contribute effectively to the organization.

Professional summary

Around 6 years of extensive professional IT experience in Design, Analysis, Quality Assurance with ETL Testing and Development on Telecom, Insurance and Banking domain using BI Tools.

4+ Years of experience of Tableau Developer and Analyst.

Experience in Data Warehousing and Business Intelligence area in various domains.

Strong hands-on experience implementing dashboards, data visualizations, and analytics using Tableau desktop and Server.

Good exposure to all the Oracle concepts as Joins, Views, Indexes, Partitioning, PL/SQL.

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

Good experience on in dashboards designing with large data volumes from various data sources ( Sqlserver, teradata etc).

Expertise Configuring Repository, Create/Manage Dashboards as per requirement.

Experienced in Analyzing the BI Needs, interpreting business user requirements and translating them into reports.

Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.

Extensively used ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using OWB, Informatica and Microsoft SSIS Packages

Expert in retrieving database information writing SQL Queries and transforming data to information as needed. Performed extensive Backend Testing of the applications using PL/SQL Queries in SQL Developer, DB Visualizer and Microsoft SSMS.

Strong at Bug-reporting, Bug-tracking, Bug Analyzing and change management using Test Management tools like Quality Center (HP ALM) and JIRA

Experience working with Agile software development methodologies.

Good Exposure to all stages of Software Development Life Cycle (SDLC), Software Testing life cycle (STLC) and Bug Life cycle.

Effective communication, proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

Good communication and presentation skills with ability to communicate at all levels.

Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.

Ability to handle multiple tasks concurrently and meet the deadlines.

Technical Skills

Testing Tools HP Quality Center, JIRA

Languages C, C++, Java, SQL, PL SQL

Database Tools TOAD, SQL Developer, SQL Navigator, SQL Plus, DB Visualizer,

MS SQLServerManagementStudio (SSMS)

Databases Oracle:12c,11g,10g and 9i, MYSQL, Postgres, Vertica.

ETL Tools Oracle Warehouse Builder (OWB) 11G, Informatica, MS SSIS

Reporting Tools OBIEE 12c/11g, Tableau

Operating System Windows 10, Windows 7

Education:

Bachelor of Engineering in Information Technology (Jun 2009 – Jun 2013 Full time)

JNTU Hyderabad, India

Certification:

International Software Testing Qualifications Board (ISTQB) Foundation level.

Tableau Desktop Specialist.

Work Experience

Sr. Tableau Developer/Data Analyst - Jun 2019 to Apr 2020

Wells Fargo - Denver, CO, USA.

Information Security Metrics & Reporting (ISMR) is responsible for front line defense reporting with a focus on an enterprise executive audience and EIS Data Governance. ISMR partners with domains and business groups to drive change and improvements across the company to represent EIS. Our Goal is to manage centralized sourcing of governed data for EIS program and line of business risk that is consistent across all publications. IS Metrics reporting was published to IS leaders and Board Directions. Worked as Tableau Developer, ETL tester and Validated IS Metric Reports in Cognos and Tableau Dashboards.

Responsibilities:

Analyze the Regulatory and Compliance Metric Reporting requirements.

Identify the Metrics that need to capture to satisfy the reporting requirement.

Designed, developed, tested, and maintained Tableau(Tableau desktop 2019.4) ) functional reports based on user requirements.

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

Involved in creating database objects like Tables, Views, Procedures, Triggers, Functions using Oracle SQL to provide definition, structure and to maintain data efficiently.

Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. Involved in creating a dual-axis bar chart with multiple measures.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.

Extensively conducted Back-End Testing using which involved complex SQL Queries.

Validated Informatica maps to check whether the data is mapped properly are not.

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

Utilized Tableau server to publish and share the reports with the business users.

Coordinating with team members and make sure that deliverables adhering to the time lines, status reporting to management, and escalating.

Tableau Developer/Data Analyst - Dec 2018 to Jun 2019

Oppenheimer Funds - Denver, CO, USA.

Oppenheimer is an insurance company which holds the customers data in different databases.

I worked as ETL tester and Tableau Developer for different applications which holds the FOR (Firm, Office, Rep), Transactions and Account data and stores in different databases (Oracle cloud, Oracle, SQL, Postgres, Vertica) and It maintains current as well as historical data and are used for creating trending Reports for senior management reporting as well as external customers. It receives Data feeds regarding FOR, Transactions and Accounts data. We need to transforms these data and use them to generate Volumetric reports.

Responsibilities:

Provided Reporting, analysis and insights about Transaction and Account data to support corporate analytics.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered ability to design and deploy Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

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

Created different KPI using calculated key figures and parameters.

Developed Tableau data visualization using cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Developed donut charts and implemented complex features in charts like creating bar charts tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

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

Utilized Tableau server to publish and share the reports with the business users.

Responsible for creating calculated fields, combine field, bins, geo coding and hierarchies using Tableau Desktop. Involved in creating dual-axis bar chart with multiple measures.

Implemented data blending to blend related data from different sources.

Performed ETL Testing across different databases to verify the data after system integration.

Ensuring that data from database reflecting correctly in reports or not.

To ensure Database Validation developed Oracle, SQL, Postgres, Vertica queries for Database testing.

Tableau Developer/Analyst - Jun 2018 to Dec 2018

Wells Fargo - Denver, CO, USA.

Worked as Tableau Developer for CEIS application which is central repository of speech data which is created by converting customer Interactions speech into normal data using NEXIDIA tool. It stores current as well as historical data and are used for creating trending

Reports for senior management reporting as well as external customers. It receives Data feeds

Manually sent as the interfaces and transforms these data and use them to generate

Dashboards on Monthly basis.

Responsibilities:

Participated in requirement gathering and data mapping sessions to understand business needs.

Responsible for developing and building reports/dashboards.

Generated diverse SQL queries using necessary joins for data analysis and to develop data reports. Used different joins, sub-queries and nested queries in SQL.

Tested ETL SSIS Packages to check data flow from one database to another db.

Worked with DBA to maintain referential integrity by defining table and column level table and column level options such as primary/foreign keys on applicable data-mart tables.

Developed visualizations and dashboards using Tableau Desktop.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.

Created dashboards with interactive views, trends and drill downs.

Interfaced with cross-functional team of business analysts, developers and technical support professionals to determine comprehensive list of requirement specifications for new applications.

Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Met with client/users and business analysts to determine and articulate project scope and expectations.

Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Responsible for data validation testing using SSMS and executing testing on data Warehousing project

Jr. BI Tableau Developer- Sep 2015 to Nov 2017

Virtusa Consulting Services Private Limited - Chennai, India.

JP Morgan chase Banking Application which creates centralized location for its clients to watch all the trade related data at single location.

Responsibilities:

Design and develop Dashboards, visualization, Autonomous and Dynamic reports using Tableau and OBIEE.

Work on generating various dashboards in Tableau server using various data source.

Administer user, user groups, and scheduled instances for reports in Tableau and OBIEE.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Defined best practices for Tableau report development.

Prepare Dashboards using calculations, parameters in Tableau.

Assist in establishing and refining standards for enterprise reporting

Maintain existing and future report distributions.

Developed Tableau data visualization using cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Tested Informatica Maps to ensure the data load.

QA Engineer/ETL tester- Sep 2013 to Aug 2015

Virtusa Consulting Services Private Limited - Banglore, India

British Telecom EDW project is a central repository of data which is created by integrating data from different components across BTGS stack. It stores current as well as historical data and are used for creating trending reports for senior management reporting as well as external customers. It receives Data feeds from different components automatically through existing interfaces by various mechanisms and for few components the data feeds are manually sent as the interfaces and transforms these data and use them to generate volumetric reports/extracts for orders/incidents on monthly, weekly basis. It used to display data using OBIEE and Tableau tools in the form of Dashboards.

Responsibilities:

Worked on Agile SDLC approach implementation for the whole testing life cycle

Reviewing Business requirements, Design documents & done detailed analysis required for the project.

Tested all the OBIEE Dashboards and few Tableau Dashboards.

Ensured that data from database reflecting correctly in Dashboards or not.

Tested ETL OWB mapping to check data flow from one database to another db.

Extensively conducted Back-End Testing using which involved complex SQL Queries.

Responsible for data validation testing using SQL and executing testing on data Warehousing project

Created test scripts for security. Functional and System integration testing (SIT) were performed.

Verified the test cases and tests scripts written by Jr. Testers in QC.

Responsible for writing the test cases and test scenarios based on the functional specification and technical specification and documented in HP Quality Center.

Worked on Quality Center for bug status tracking and maintained and created status reports for the application.

Tracking the functional queries to closure with the help of the Component designers and developers.

oPreparing the presentation of New Functionalities and providing the information to entire team and Customers on for every release.

Coordinating with team members and make sure that test deliverables adhering to the time lines, status reporting to management, and escalating the issues

Contact this candidate