SUMMARY:

• 10 Years of experience in Data warehouse with tools such as BOBJ, Microstrategy, Tableau, SSRS, SAS EM
• 4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 8.0, 8.1, 8.2and 9.0
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Experience in developing and implementing tableau changes such as upgrades and migration.
• Experience in identifying the clientissues, analyze the causes, understand the impacts, develop the proposed state, manage the implementation and maintenances.

Project Management:

• Project Scope, Strategy & Budget Analysis, Planning, Support & Status tracking.
• Team Building, Applications Analysis, Development and Implementation.
• End to End Client management, Requirements control, Project Sign - Offs.
• Extensive experience with Onsite-Offshore models, Agile and Waterfall methodologies.
• Excellent cross group collaboration skills.

SOA- Webservice:

• Defined Test Strategies - Agile, Waterfall and V-shaped Methodologies.
• Experienced in SOA testing and performance testing of web based application and web services using Parasoft SOA& SOAP UI .
• Designed and developed user experience standards and guidelines for design and development.
• Performed black and white box system testing of applications.
• Communicate status and offer mitigation strategies to ensure on-time delivery of all committed projects to cross functional teams
• Database testing expertise with SQL query writing and functional testing knowledge on Windows and Web Services

TECHNICAL SKILLS:

BI Tools: Tableau(Desktop/Server/Public), Microstrategy, SAP Business Objects, SAS Enterprise Miner

Data Modeling Tools: MS Visio, CA ERwin

Databases: SQL Server 2012,SQL Server 2008 R2, MS Access, MYSQL, DB2

Project Management: MS Project, MS Outlook, IBM Lotus Notes 7, Clarity

Requirements Management: MS Word, MS Excel

Verification and Validation Tools: Mercury Test Director, Rational Test Manager, HP Quality Center 9.2, IBM Rational ClearQuest, Quick Test Professional, SOAP UI, HP Application Lifecycle Management, Parasoft SOA, JIRA, Bugzilla

Languages: C, C++, SQL, JAVA

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Tableau Developer

Responsibilities:

• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Interfaced with diverse business groups and end-users to design and present UX concept, and collaborated closely with the product engineering team to translate Data-heavy systems into meaningful user-focused experience in Web, responsive,
• Created elegant UX and UI for responsive, mobile, and Web-based applications using HTML5, CSS3, jQuery, JavaScript, and MVC
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Used SSAS Cubes as the data source and created Dashboards, also written Custom MDX to handle few Calculated Members in the dashboards
• Involved in validating and testing the numbers reported using Tableau Dashboards
• Also re designed the data source having data from different sources into one SQL Server and to tableau.

Environment: Tableau Software 7.0, 8.0, Microsoft office, SharePoint, SQL Server 2012, Visual Studio 2012, PostgreSQL

Tableau Developer

Responsibilities:

• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Mainly dealt with sales and networking team to analyze the sales which lead to the increase and decrease in the sales region by region.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• And with networking team, built dashboards about the outages and network loss in each and every region around the globe.
• Used Tableau Desktop 8.2 to build dashboards and PostgreSQL as a data source to analyze and build the visualization for the networking team
• Defined and created procedures to install Tableau desktop in silent mode.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues

Environment: Tableau Desktop 8.1 8.2, Microsoft Office, Oracle R12, PostgreSQL, Visual Studio 2012

Tableau Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Performed Gap Analysis for designing future state application by analyzing current applications and business processes.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Worked with the team in improving the BI process while maintaining alignment with Client Technology Solutions objectives.
• Interpreted project activities to ensure prioritization of deliverables and accuracy in estimated milestone parameters.
• Create highly visual analytical dashboards using Tableau.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Designed customer oriented interactive web reports and dashboards for different user experience KPIs
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Environment: Tableau Desktop 8.x, Tableau Server, MS Office Suite, MS Excel, Visual Studio, SQL Server.

BI Developer (Tableau / Microstrategy)

Responsibilities:

• Involved in analyzing data sources in Tableau desktop for design, development, testing, and production rolloverof reporting and analysis projects.
• Worked directly with business customers to build reports, dashboards and ad-hoc reports.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Involved in reviewing business requirements
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Involved in conducting trainings to user on interact, filter, sort and customize views on a visualization generated through Tableau desktop.
• Good hands on experience on SQL DBA and modern data ware housing.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• In charge of the team that builds tableau architecture and dashboards using Tableau desktop, Tableau Server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop .
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0.
• Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
• Prepared Dashboards using calculations, parameters in Tableau.

BI Analyst

Responsibilities:

• Direct interaction with clients to elicit the requirements and translate them into terms that development team can comprehend.
• ETL Transformation tools were used for Control Flow and Data Flow tasks
• Created star schema in SSAS and developed SSRS reports based on the cube.
• Conduct client interviews, high-level reviews, and be part of focus groups to derive and execute action plans, meet deadlines, and follow industry standards and best practices.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.

Data Analyst

Responsibilities:

• Worked with end users to gain an understanding of information and core data concepts behind their business
• Involved in Database design, creation and maintenance of Databases.
• Created tables and views.

Data Analyst

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• Designed a star schema for the data warehouse using dimensional modeling and developed it using the Visio tool.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating Indexes.
• Used the HTML code to make the report manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Tracking the life cycle of project using HP QC
• Designed a new schema for the data mart databases.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Software Engineer

Responsibilities:

• System Test Plan (STP) preparation
• Functional and Regression testing of Merlin platform application
• Creating Requirement Traceability Metrics (RTM)
• Maintaining Script Tracking Metrics (STM)
• Updating Visual Management Plan (VMP - Daily Planning/Execution Tracker)
• Create test plans and test cases based on business requirements, use cases, and functional specifications.
• Developed and executed test scripts.
• Performing Various Kinds of Testing Procedures Acceptance Tests,Functional Testing
• Manually conducted Functionality and GUI testing during various phases of development of the application.
• Track test results and participate in Quality Reviews on all projects assigned before going to production.