SHRUTHI MULAGADA

**** ******* **, *** ***, Vienna, VA-22180 571-***-**** ac0ytl@r.postjobfree.com

Summary:

Solutions oriented and analytical data expert on Business Intelligent systems and applications with 6 years of experience in Information Technology. Highly motivated data engineer with a master’s degree in Information Systems. Dedicated professional with rich knowledge in advanced reporting and data visualization using various tools and technologies. Professional Summary:

Expertise in multi-dimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling

Sound expertise on Software Development Life cycle from gathering functional requirements to process documentation, model creation to website development and testing-support

Worked extensively on documents, dashboards and Visual Insights to facilitate customized multi- report display for providing advanced visual effects for making better business analysis

Expertise in Configuring Repository and Creating/Managing complex Dashboards and Reports

Experienced in MicroStrategy Administration and performance tuning of the intelligence servers

Expertise in SQL troubleshooting, VLDB Properties & Performance Tuning, SQL, PL/SQL, Stored Procedures, Triggers, MS Excel Pivot Tables

Worked comprehensively in the Oracle, Teradata, IBM DB2 and SQL Server Database environments

Excellent communication, interpersonal, logical aptitudes and solid capability to execute as part of a team

Technical Skills:

Project Experience:

Wavicle Data Solutions LLC Jan2016 - Present

McDonald's Corporation

BI Developer (MicroStrategy & Tableau)

Creation of new projects, a metadata repository and the ODBC connections for the new project

Migration of various schema objects, reports and documents using object manager.

Creating schema layer objects for developing reports related to Global Analytics of all units of Mc Donald’s

Interacting with business users to identify dashboard strategies, report layouts, and analysis presentations

Helping to develop and create logic for schema layer development

Testing the reports against the database using Teradata SQL assistant

Applying advanced data analytics techniques to derive meaningful information out of large amounts of data

Collaborate with DBA to understand the data model and develop facts and dimension tables BI/DSS Tools

MicroStrategy, Tableau, IBM SPSS Modeler, IBM Cognos, ERP SAP, SAS Enterprise Miner and SAS Enterprise Guide

Databases Oracle 11g/10g, SQL Server, Teradata, SQL Visual Studio, SQL Management Studio Programming SQL, PL/SQL, C, C++, J2EE, Visual Basic, HTML, PERL, ASP.NET, R Programming Web

Technologies JSP, JavaScript, HTML, CSS and PHP

Other Microsoft Technologies SharePoint 2013/2010

Operating

Systems Windows Servers, Linux and Unix

SHRUTHI MULAGADA

Used Apply functions to execute the database specific function in the attributes, metrics and filters

Effectively used the VLDB settings for Join types, Max rows, Query optimization etc

Responsible for documentation and configuration of Enterprise Manager for logging statistics and reporting purposes

Executed Command Manger Scripts for Purging Caches, creating Schema and public objects Texas Tech University-Office of CIO September 2014 – December 2015 BI Developer

Generated reports using MicroStrategy, IBM Cognos, Tableau and Performance Point Services on SharePoint

Designed and planned data visualization in BI reports

Developed Schema, KPIs/Metrics definition, UI Design, Security, Intelligent Cubes and Data Marts

Used Command Manager to purge caches on database loads

Used free form SQL editor for complex report creation

Created Tableau scorecards, dashboards and publishing reports to Tableau Server

Used Data Blending in tableau to develop reports using multiple data sources

Developed strong understanding of advanced Tableau features including calculated fields, level of detail calculations, table calculations, groups, sets, parameters, data blending, and dashboard actions

Analyzed data from various databases and formatted it into graphs using MicroStrategy Desktop

Analyzed and developed insights on information of all User Security Incident issues related to TTU

Created a model which automatically generates reports and translates data analysis into insightful and actionable items using command manager

Experience in designing and maintaining schema and public objects within MicroStrategy

Developed configuration objects required at the architect level Oklahoma State University-Office of International Affairs August 2013 – May 2014 Business Analyst

Support development of custom reports and data visualization products such as Dashboards

Web mapping of all the students at OSU using Tableau and IBM Cognos

Created metrics, filters, Prompts, Custom Groups, Consolidations, Reports and documents in MicroStrategy Desktop

Tested reports in Tableau Web for fixing formatting issues

Wrote SQL against the database to compare and test report results

Built Tableau dashboards with live connect

Gathered and documented the analysis and reporting requirements required for the university JP Morgan Chase-iDDA UAT Test Execution July 2011 – July 2013 Data Analyst

Retrieved, reviewed and transformed client’s data from various LOB’s and loaded into internal system using ETL tools and SQL

Created test plans and validated them using SQL scripts

Identifying the Target Test Items to be evaluated by the test effort

Defining the appropriate tests required and any associated Test Data

Gathering and managing the Test Data

SHRUTHI MULAGADA

Evaluating the outcome of each test cycle

Ongoing management of the relevant iDDA(International Demand Deposit Account) UAT(User Acceptance Testing) environments supporting key testing programs and iDDA release projects, including:

Processing all agreed inbound files and sharing status with testing teams

Running all agreed iDDA batches

Transmission of all agreed outbound files and sharing status with testing teams

Raising, tracking and resolution of environment issues/defects in cooperation with the appropriate Technology teams

Liaison with the off-shore vendor team providing environment support services

Support the Test Event Leads and LOB(Line of Business) Application Leads in the co-ordination of the planning and execution of the test schedule for each testing program

Work with the Test Event Leads, CIB(Commercial International Bank) Technology teams, and LOB test leads to prioritize/track/resolve iDDA UAT environment issues

Production of test environment metric packs (daily, weekly, and monthly as required)

Good analytical skills

Challenging and inquiring mind

Attention to detail and tenacity

Understanding of common software failures and faults

Knowledge of the domain and system

Experience in a variety of testing efforts

Education:

Texas Tech University, Rawls College of Business August 2014 - December 2015 Master of Science in Management Information Systems Jawaharlal Nehru Technological University October 2007 - May 2011 Bachelor of Science in Electronics and Communication Engineering Accomplishments:

Certified in Software Testing

Best employee certificate by JPMC

TCS Gems awarded during the Initial Learning Program

Contact this candidate