SUMMARY

• 8+ years of IT experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Over 3+ years of TableauExperience in Enterprise Environment andTableauAdministrator Experience including support, troubleshooting, report design and monitoring of system usage.
• ExtensiveExperience in TableauDesktop and TableauServer in various versions ofTableau6.x, 7.x, 8.x as a Developerand Administrator.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Experienced in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture
• Experienced in Analyzing the BI Needs, interpreting business user requirements and translating them into reports
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Managed cross - functional teams through Software Development Life Cycle.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• In depth understanding of the Gap Analysis i.e., As-Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, bubble charts, funnel charts, heap maps, tree maps, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experienced in developing reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating various reporting components from multiple sources.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle Informatica, MicroStrategy, Tableau, Unix technologies.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Good knowledge of Data Warehousing concepts, RDBMS and multi-dimensional schema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases
• Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production support.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

BI Tools: Tableau, MicroStrategy, Microsoft SQL Server Reporting Services

ETL Tools: Informatica, DataStage, Microsoft SQL Server Integrated Services

Requirements Management: Requisite Pro, Microsoft Office (Word & Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, Oracle Apex

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, Access etc

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool: HP Quality center 10.0

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, CMMI Compliance, Waterfall, Agile, Iterative

Scripting Languages: C, C++, HTML, SQL, PL/SQL, and XML

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. Tableau Consultant

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Worked in coordination with clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Deployment of TableauServer in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in Tableau environment.
• 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 employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users
• Pushed all the created stored procedures and functions to the development, training and production servers.
• Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
• Involved in scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau 8.x/7.x (Desktop/ Server), TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Oracle 10g, Erwin r8, C#

Confidential, Austin, TX

Sr. Data Analyst/ Tableau BI Developer

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD).
• Deep experience with the design and development ofTableauvisualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Prepared BI Interactive Dashboards using calculations, parameters inTableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Background in installing and upgrading ofTableauserver and server performance tuning for optimization.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: TableauDesktop/Tableauserve, TabCMD, SQLdeveloper, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Microsoft office 2007

Confidential, Columbus, OH

Sr. Data Analyst

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques.
• Build and analyze queries from databases using SQL
• Working with client on customer data by relating from multiple internal and external sources into a central consolidated company-wide customer database
• Daily movement of users and handling cases, analysis and Ad hoc Reporting
• Provide input to improve customer dataprocessing
• Participate in weekly staff meetings and collaborate with various teams to develop and support ongoing analyses
• Conduct dataaccuracy analysis and support stakeholders for decision-making
• Analyzing data using advance Excel functions such as Pivot Table, Charts, Graphs and Macros
• Handled the company’s day-to-day reporting anddataaccess needs
• Developed and implemented a business intelligence strategy that ensures the systemdatais secure, integrated and accessible to staff
• Worked across departments to identify and understand key business questions, and standardize key metrics and measures
• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes
• Analysis, design and data modeling of Logical and Physical database using E-R diagrams
• Design/Build Extract Transform Load procedures in SQL Server 2005/2008/2008 R2 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email
• Designed and created Report templates, bar graphs and pie charts based on the customer data

Environment: SQL Server 2005/2008/2008 R2, MS Access, MS Excel, MS PowerPoint, R, SAS, Informatica ETL, VBScript, HTML, XML, Visio, ASP.NET, VB.NET, BIDS.

Confidential ., Pleasanton, CA

Data Analyst

Responsibilities:

• Assisted the SA to document all custom and system modification after the SCR’s were satisfactorily solved
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved with respect to the evaluation criterion
• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case
• Used SQL queries for organizing and abstracting data from MS access databases, created reports, forms on MS Access
• Captured Data flow diagrams and formatting of the data flowing through interfaces
• Accumulated system requirements from various departments like accounting, retail, IS (Information Systems) through surveys and interviews
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Configured the Data mapping between Oracle and SQL Server 2005
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis
• Facilitated user acceptance testing and test strategies with Information Systems Group
• Performed manual front-end testing to check all functionalities of different modules
• Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)

Environment: Oracle, TOAD, SQL, Share Point, TFS, Agile-Scrum, Informatica, MicroStrategy, Autosys, UNIX, SQL Server, ERwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Portsmouth, New Hampshire

Data Analyst

Responsibilities:

• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Worked with Excel Pivot tables.
• Create and Monitor workflows using workflow designer and workflow monitor.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Identify & record defects with required information for issue to be reproduced by development team.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate with offshore team.

Environment: Teradata Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatica, MicroStrategy, Erwin, DB2, HP Open View, Lotus Notes, Windows XP, MS Office Suite (Word, Excel, PowerPoint).

Confidential

SQL BI Analyst / Developer

Responsibilities:

• Created and/or strengthen systems fordatacollection, management, reporting and analysis. Advised the agency on technology needs to maximize efficiency and support a culture of managing todata
• Assisted in the creation and documentation of the business processes fordatacollection, entry, reporting, review and use ofdatato strengthen performance management
• Implemented logical and physicaldatamodeling
• Developed PL/SQL stored procedures for the end-user report requirements
• Created crystal reports on the stored procedures and exported the Business Objects reports to WEBI, to be viewed by all users on the intranet and extranet
• Created many simple, complex and adhoc reports using Crystal reports as maindataproviders and having the Powerful functionalities like @functions and formulae
• Created queries for multidimensional analysis using slice, dice and drill modes
• Analyzed complex business needs presented by the user community and/or clients and recommended technical solutions to improve the reporting environment
• Deployed Eport Reports on the intranet website in form of PDFs
• Accomplished Performance tuning of SQL queries and stored procedures using Database tuning advisor in SQL Server
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches
• Created SSIS packages and used Analysis Services processing task to update the cube with current data
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
• Identified the dimension, fact tables and designed the data warehouse using star schema
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Trained end users in basic and advanced ad hoc reporting skill
• Created report snapshots to improve the performance of SSRS
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures

Environment: Windows XP/2000 Advance Server, SQL Server 2000/2005, SSRS, Crystal Reports, Web Intelligence, InfoView, MS Excel, MS Word, MS PowerPoint, Windows 2000/2003, Microsoft office 2003, XML,T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), MDX, SQL Profiler, MS Excel 2003, Visual Studio 2005,.NET Frame Work 1.0,SharePoint 2007.