SUMMARY

• 8+ years of IT industry experience in implementing all phases of the Software Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Data Warehousing/Business Intelligence Applications.
• 4+ years of Experience in building visualizations and Dashboards using the various versions of Tableau suite (9.0, 8.2, 7)like Tableau Desktop, Server, Public and Reader.
• Sound knowledge of Health Care, Technology, Retail, Finance and Banking domains.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Proficient in conducting Gap Analysis, Business Process Re - engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Good Experience in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Expert in design and development of various dashboards/ reports utilizing Tableau advance visualizations like Bars (Horizontal, Stacked, Side by Side), Lines (Continuous, discrete), Bullet Graphs, Scatter Plots, Circle Views, Pie-Charts, Packed Bubbles, Funnel Charts, Geographic Maps (Symbol, Filled) to represent different datasets.
• Good Knowledge on JAVA Script API to integrate Tableau Visualizations into web applications and also control user’s interactions.
• Hands on experience in creating users, groups, projects, Data connections, settings, incremental refreshes for data sources on Tableau server
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database tables, constraints, indexes.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau.
• Proficient in Dimensional Modeling using Kimball and Inmon methodologies for Star and Snowflake schema designs of Data Warehouse and Data Integration projects.
• Extensive experience working on Erwin utilizing features like Reverse/Forward Engineering, Subject Area, Domain and developing Data Dictionary and publishing Data Models.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Flexible, enthusiastic and project oriented team player with excellent communication skills and leadership capabilities to develop creative solutions in challenging environments.

TECHNICAL SKILLS

Reporting Tools: Tableau (Desktop/Server/Public/Reader), Business Objects, Microsoft SQL Server Reporting Services (SSRS)

Data Warehousing ETL Tools: Informatica Power Center, Data Stage, SSIS

Databases: Teradata, NETEZZA, Oracle, SQL Server, MS Access

SQL Tools: Toad, Teradata SQL Assistant, PL/SQL Developer

Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

Scripting Languages: PL/SQL, SQL, Unix shell scripting, Java, C, HTML, XML

Testing Tools: Mercury Test Director, IBM Rational Tester, Quick Test Professional (QTP)

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Others: MS Word, Excel, PowerPoint, VISIO 2007

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Prepared Business Requirement document and then converted business requirements into technical designs.
• Designed standardized Data Mart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created report schedules on Tableau server and Tableau Online.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Created and assisted users in Tableau dashboard development.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Manage the application’s users, groups, and integration with Active Directory.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau (Desktop / Server), Teradata, Oracle, MS SQL Server, SQL, Toad, UNIX, Teradata SQL Assistant, MS Visio, Java Script API, Asp.Net VB, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Waukegan, IL

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Served as Business Systems Analyst/ Data Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mentored Power users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Provided Tableau server and Tableau desktop training.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau, Teradata, Teradata SQL Assistant, Share Point, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Columbus, Ohio

Sr. BI Analyst/ Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, Scorecards in BO and created the same using Tableau desktop.
• Analyzed the source systems and created technical design documents and data flow diagrams.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Created 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.
• 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.
• 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.
• 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.

Environment: TableauDesktop, Tableauserver, SQLdeveloper, Oracle, Microsoft Excel 2007, MS Access, Windows 2007 server,, Microsoft office 2007, Quality Center

Confidential, Atlanta, GA

SQL/Report Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• Upgraded MS SQL Server using detach/attach, backup and recovery and by replication.
• Used SSIS Import/Export Wizard, for performing the ETL operations.
• Createdalerts, notifications, and emailsfor scheduled SSIS packages execution.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MSSQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008r2.
• Generated reports usingSSRSthat could be used to send information to different primary vendors, clients, and managers.
• Designed astarschema for the data warehouse using dimensional modeling and developed it using the Erwin 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.
• Designed and 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 ALM
• Troubleshootand fixed issues in existing cubes in SSAS.
• Designed a new schema for the data mart databases.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MSSQLServer 2008r2, T-SQL,SSRS2008r2, Visual Studio 2008r2, Erwin 8.0, HP ALM, UNIX, MS VISIO, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential

Systems Analyst

Responsibilities:

• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Recovered the backups of SQL Server production databases in test server environment.
• Refactored poorly performing SQL queries to improve application performance.
• Monitoring MS SQL Server performance and network issues.
• Coordinating with peer groups for Network, Infrastructure and DatacenterOperations.
• Performance monitoring and tuning of SQL servers.
• Used SSIS to load data from multiple SQL Server sources to adenormalizedset of tables for analysis.
• Built SSRS report to support reporting needs.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server, XML, Microsoft Suite (Excel, Word, and Visio), Quality Center, and SSRS