MRUDULA

Email: acth8w@r.postjobfree.com

Ph #: 703-***-****

PROFESSIONAL SUMMARY:

Over 7+ years of Data warehousing experience with Business Intelligence Tableau 9.0/8.2/8.1/8.0/ 7.0, OLTP and OLAP, Microsoft SQL Server as a Developer in various domains.

Experience in complete project lifecycle phase of requirements gathering, Analysis, Design, Development and Testing. Part of production support and maintenance for migrating database tools.

Experience in Service Management tools, integration implementation and maintenance phase of the project.

Extensive experience in Tableau Desktop and Tableau Server in various versions of Tableau 7/8 and the latest Tableau 9.

Experience with Tableau Desktop for data visualization. Produced reports and analysis based on cross maps, scatter plots, geographic mapping.

Created Tableau dashboards by using SSAS as the data connection. Used Custom MDX to created calculated members.

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

Efficient with table calculations and parametric assignments of different views in terms of dashboard reporting. Use of formatting tools for multiple outputs by using layout containers and marking tables. I have used all the above-mentioned techniques in Tableau Desktop.

Expertise in creating visualizations using Bars, Pies, Scatter plots, Gantt charts. Worked with Bubbles, histograms, Bullets, Heat maps and Highlight Tables and implementing the techniques in dashboards using Tableau.

Expertise in dashboards creation and help users to identify critical and important KPIs. Depict story-telling concepts using Tableau.

Extensive experience in Installation, configuration, upgrade (simple Configuration, 3-server and 5-Server Cluster) and administration of Tableau Desktop/Server.

Hands on experience in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.

Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

Strong understanding of data modelling. Strong SQL skills and metadata management.

Experience with various software development life cycles like Waterfall, Test Driven, Scrum and agile. Constantly adapted to the various agile systems in learning the basics and implementing the logics.

Experience with different levels of axes in Tableau like Dual axes, blended axes, individual axes.

Experience in developing Entity-Relationship diagrams and Snow Flake Schema Designs. Worked with Transactional Databases, Oracle, SQL and PLSQL.

Worked closely on the test cases and developed the test scripts for various scenarios. Report tracking, UAT plans and cases.

Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes

TECHNICAL SKILLS:

Specialties

Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection, Big Data. Waterfall, Agile, Iterative, Scrum

Data Visualization

Tableau, Qlikview, PowerPivot, Excel, SSRS, SSAS, Visual Analytics, Crystal reports XI/2008

Relational Databases

MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, MS Access.

Tools & Packages

SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, Crystal Reports

Languages

SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL

Web/App Servers

MS IIS 5/6.0, Apache Tomcat, Web logic Server 8.1/9.2/10, Web Sphere

Databases

Oracle 11g/10g/9i/8i/7.3, SQL Server 7.0/2000/2005, Sybase, DB2, Teradata and MS Assess.

Reporting Tools

Tableau, Business Object suite (XI R3.1/R2/6.x/5.x), Business Objects BI 4.0, SAP BW,Web I XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client (3.1), Supervisor, Broadcast Agent, Info view, Crystal Reports 2008/XI/10, Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius 2008/4.5.

Operating Systems

Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

ETL tools

SQL Loader, Informatica Power Center 8.1, 7.1, 6.2.

Configuration Management Tools

Team Foundation Server, Visual Source Safe, Clear Case

PROFESSIONAL EXPERIENCE

Client: MasterCard, St Loius, MO Feb 15 – Till Date

Role: Tableau Developer

Responsibilities:

Part of SDLC, which included gathering requirements, design documentation and planning. Published all the record using tableau dashboards.

Used advanced chart visualization in Tableau using the Show Me button. Acquainted with Donut chart, box plots, tree maps, heat maps, dual axis, bullet graphs and assist business users in solving complex problems.

Story writing and development of scorecards for major Request for Proposals and perform prioritization dashboards vs de-prioritization RFPs.

Extensively used analysis to detect the statistical functions and calculations based on trend lines and for casting many reports in Tableau.

Accessing the Tableau Server performing administrative activities for end user access to various server options.

Frequent client meetings for requirements gathering and scripting of various changes requested.

Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.

Effectively used data blending feature in tableau.

Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.

Created Schedules and Extracted the data into Tableau Data Engine.

Conducted test cases for SQL scripts, which was a part of report developments, and handling the performance issues effectively.

Assisted the QA team and helping with test reports and test cases. Assessment of the test scenarios and real time problem solution

Organized training for UAT sessions and helped in assisting the business teams throughout the UAT phase

Modified worksheets and data visualization dashboards and designed dashboards, which are easily accessible using IPad, IPhone and other smart phone.

Generated files using excel and csv and saved data using .twbx and .twb for further implementation. Blended the files from reports to primary keys from each database for data validation.

Handled Tableau admin activates and created projects and gave rights for users and worked with synchronizing.

SQL query optimization and worked with agile team setting for BI tools with the help of Micro Strategy.

Environment: Tableau Server 9/8.3, Tableau Desktop 8.3, SQL Server 2008/2012, Oracle, MS Office, Windows 7.

Client:The Gordian Group,Greenville,South Carolina. Jan 14 – Jan 15

Role: Tableau Developer

Responsibilities:

Gathered all the business requirements and actuate them to Tableau reports for presentation to the end users.

Analyzed requirements based on the resulted dashboards, scorecards and created a prototype using Tableau Desktop.

Collect and develop various reference documentation for knowledge transfers and reduce the burden on future projects.

Helped in migration documents from older version of Tableau to a newer version of Tableau. Provide dataset for analysis and presentation and develop these documents.

Assist the analytics team by studying the data and interacting with high end users. Also interacting internally with the Directors and VIPs for a clear understanding of the final product.

Train and aware the employees of the data policies of the company. Becoming familiar with many of the requirements of the company policies and implement them religiously.

Assist in creating process maps which shows a pictorial representation for the data steps, which are being implemented in the project.

Identify the end user gaps and data inconsistencies and make modifications in the data based on the result expected.

Used many statistical functions and calculations for better forecasting using tableau reports.

Responsible for importing and exporting documents for the sales and purchases.

Created prompts for conditions and quick filters both on a local and global level. Parameter implementations and groups for sets to filter the data based on the requirement understanding from the end user.

Schedules various frequency events for refreshing the data based on a source and publish the data to an extracted server.

Reporting built on Set analysis and have different set of data. Following up with the testing, maintenance and development team on the updates of the project and gathering of the analysis.

Using MS Excel and Access/Spreadsheet Reports to get analyzed output for the front user analysis.

Environment: Tableau Desktop 7.1, Tableau Server, MS Office Suite, Oracle SQL, MS Excel.

Client: Community health network, Indianapolis, IN Oct 12 – Dec 13

Role: Tableau Developer

Responsibilities:

Data blending implementation using SQL server database.

Assist the senior manager for customer identification and enrichment strategies. Identify the best industry practices and KPIs and conduct data profiling and reporting. Help in presentation of summaries of data quality audits and recommend action plans.

Kept tract reports, which shows the historic data and helps in plotting future trends and identify potential opportunities.

Created dashboards with quick filters and parameters for customizable options and variations in the presentation.

Published ad-hoc reports to create an agile development output and for low-level security. Worked with Waterfall chart.

Handled Tableau admin activities for installations and profiling of the customers.

Built SQL scripts, indexes, and complex queries for data analysis and extraction.

Supported BI solutions, which involved in debugging, monitoring, and troubleshooting issues.

Scheduled database extracts based on daily reporting and have been a part of sophisticated procedures and triggers based on the online application.

Experience with the service request-handling tool for raising requests and clearing them and providing end user solutions.

Experience with performance modeling techniques and customizing the product based on requirements gathered.

Environment: Tableau Server v8.1/8.2, Tableau Desktop 8.1/8.2, SQL Server 2008/2012, Oracle

Client: Thomson Reuters, Hyderabad, India Jun 11 – Sep 12

Role: Business Intelligence Analyst

Responsibilities:

Created collaboration, activity diagrams, project flow diagrams in MS Visio.

Conducted JAD/RAD session. Helped project manager with project status reporting tools and conducted walk-through, teleconferences, ticket management.

Prototyping charts, presentation using parameters and developing ad-hoc reports using tableau developer and Excel.

Met deadlines and served budget requirements. Gathered Business Requirements and interacted with the end users and project managers.

Modified various project reports and prepared new project reports for the development of weekly and monthly status updates on the project.

Worked with MS Visio for use case and activity diagrams.

Analysis based on the database layers to create various reporting. User storytelling and segmentation for implementation of the requirements, which have been asked.

Environment: MS Excel, MS Visio, Oracle Apex, MS SQL Server 2008, Win Server 2008 R2, Active Directory

Company: UIDAI, Bangalore, India Sept 08 – May 11

Role: Business analyst

Responsibilities:

Conducted various tests and part of UAT test cases and test plans.

Involved in meetings with the business owners and subject matter experts for requirement gathering phase of the project.

Creating metrics and dash boarding and was point of contact for data analytics and BI teams.

Worked on Oracle reports and forms and deployed the User Interface using Oracle Developer 6i Forms.

Performed optimization using SQL queries and normalization. Used several joins and procedures to work with the different tickets raised by end users.

Worked with the change management and service management ticketing tools.

Debugging and troubleshooting using Oracle SQL/PLSQL.

Prepared the documents (DOU, DOW, FS, and DS) for project application.

Environment: MS SQL Server 2008, QA,MS Excel, MS Access, TOAD, Oracle Reports and Forms,Windows.

Education: Bachelors in Computer Engineering India.

Contact this candidate