PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Requirement Gathering, Analysis, Documentation, Design, Development, Testing, and Implementation in Business Intelligence and Software Applications.
• 5+ Years of extensive Tableau Experience in Enterprise Environment, in Tableau as a Developer, Administrator and Analyst.
• Proficient in Installing, Configuring and Administration of Tableau Server and good understanding of Tableau architecture, design, development and end user experience
• Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView and designed and developed data models and backend queries for presenting data.
• Good Knowledge in Users and Group Management, Licensing and Data Connections, Scheduling in Tableau Server.
• Run cleanup and create backups of the database, workbooks, log files and upgrade Tableau server software.
• Create/Modify/Manage server task Scheduled data refresh on Tableau Server for increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Extensive knowledge of Tableau Server Concepts like tab cmd, tab admin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
• Extensive knowledge in creating various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters, aggregates, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Diversified experience in implementation of BI systems with in Healthcare, Finance, Pharmaceutical, Insurance, Accounting and Telecom sectors, etc.
• Expertise in gathering, analyzing and documenting Business Requirements and Data Specifications.
• Hands on experience on Hortonworks and Cloudera Hadoop environments.
• Good understanding on ER Diagrams, OLAP, OLTP and Database techniques.
• Expertise in testing Data Warehousing jobs (Informatica, SSIS, Data Stage) and applications, Business Intelligence reports (OBIEE, SSRS, Business Objects, BEx, Tableau, Cognos), Java based applications, Quality Assurance and management, Risk, Compliance, Data management, Internal audit and Enterprise risk management projects and programs.
• Experience in developing reports from various sources like Oracle, MS SQL Server, Access, and DB2.
• Experience in working with Operating Systems like Windows and UNIX.
• Train the users on the BI practice within the organization.
• Highly skilled, self - motivated team player, outstanding organizational, excellent communication and interpersonal skills with result-oriented dedication towards goals.

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects XI R4.x/3.x/XI R3/XI R2/6.x/5.x, SAP HANA, WebI XI R2/6.x/2.x, Infoview, CMC, Designer, DeskI, Crystal, Xcelsius, Tableau, Qlikview Dashboards, Scorecards. Hadoop Ecosystem.

RDBMS: Oracle 10g/11g/12c, SQL Server, MS Access, Visual Studio, ERPETL Tools Informatica Power center/ Power mart, SSIS

Software/Tools: Designer/Developer 2000, TOAD

Languages: C, C++, Java, SQL, PL/SQL, SQL Plus, R-Programming, ANSI SQL, Alteryx 9.5/10VB, Unix Shell Scripting, Kernel Programming.

Internet Technologies: JSP, XML, HTML.

Operating Systems: Windows, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

Tableau Developer / Administrator

Responsibilities:

• Involved in requirement gathering and analyzing business requirements from clients
• Providing solutions on designing and developing of front-end BI applications and Visualization solutions for clients according to specifications.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Designing the Reports as per client Requirement and created the reports using Excel file and BOBJ.
• Visualized the objects created in SAP HANA using Tableau to demonstrate data and visual analysis.
• Working 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.
• Translating business requirements into report visualization, design documents.
• Responsible for universe designing and hierarchy building for data analysis.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Build prototypes for demonstration and illustration purposes for peer groups, business partners, senior leaders followed by design, deployment and on-going enhancements.
• Involved in adding users and providing permissions to sites, projects and data source, Load Balancing.
• Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections
• Add/Edit Sites and corresponding administration right to the site admin.
• Trained users on site administration by providing step-by-step guidance from basics to advanced functions.
• Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Donuts Charts, Maps, Line Charts, Scatter Plots and Filters, Marking, Drill Down, Hierarchies and Coloring, Calculated Columns and Custom Expressions using Tableau.
• Coordination with business and technical teams.
• Defect analysis and assisting QA team in testing the reports and fixed the defects.
• Assisted users in UAT

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server9/10, SAP HANA, SQL Server, MS Office tools.

Confidential, Madison, WI

Tableau Developer / Administrator

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle/SQL Server for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop.
• Involved in installation, upgrading version, Load Balancing and configuration of tableau server.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Developed Courses sales reports, best course sellers’ reports and marketing campaign reports for Marketing department.
• Created Heat Map showing course sales by color that were broken into regions allowing business user to understand where we have most sales vs. least sales.
• Created dashboard using parameters, sets, groups and calculations.
• Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections
• Create/Modify/Manage server task Scheduled data refresh on Tableau Server for increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Monitor server activity/usage statistics to identify possible performance issues/enhancements.
• Projected and forecasted future growth in terms of number of subscribers by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.
• Created dashboards for analyzing POS data using Tableau on top of SAP HANA.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created monthly, quarterly and yearly financial reports for Finance department.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 9,10, Tableau Server, MS Office Suite, Oracle, R, SQL Server, SAP HANA, Salesforce, Microsoft Dynamic CRM.

Confidential, Dallas - TX

Tableau & Alteryx Developer

Responsibilities:

• Involved in requirement gathering and analyzing business requirements from clients
• Providing solutions on designing and developing of front-end BI applications and Visualization solutions for clients according to specifications.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau Server.
• Designing the Reports as per client Requirement and created the reports using Excel file and Oracle database.
• Visualized the objects created in SAP HANA using Tableau to demonstrate data and visual analysis.
• Working 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.
• Involved in the migration of Oracle Discoverer reports to Alteryx Apps.
• Translating business requirements into report visualization, design documents.
• Responsible for universe designing and hierarchy building for data analysis.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Prepared proof of concept for best practices in Tableau deployment.
• Build prototypes for demonstration and illustration purposes for peer groups, business partners, senior leaders followed by design, deployment and on-going enhancements.
• Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Donuts Charts, Maps, Line Charts, Scatter Plots and Filters, Marking, Drill Down, Hierarchies and Coloring, Calculated Columns and Custom Expressions using Tableau.
• Coordination with business and technical teams.
• Defect analysis and assisting QA team in testing the reports and fixed the defects.
• Assisted users in UAT

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server8/9, R,, Oracle, Alteryx 9.5/10, SQL Server,Microstrategy, SharePoint, MS Office tools.

Confidential, Austin, TX

Tableau Developer

Responsibilities:

• Participate in requirement gathering and analysis of Business needs and responsible for creation of Functional Specification Document.
• Involved in complete SDLC
• Analyze the functional design documents and BUR Documents.
• Responsible for creation of Detail design documents for reports and universes.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Involved in the migration of Oracle Discoverer reports to Alteryx Apps.
• Interacted with ETL developers and architects on data load issues and also regarding issues with NSK jobs related to reports.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Responsible for writing unit test cases and documented the unit test case results.
• Defect analysis and supported QA team in testing the reports and universes and fixed the defects logged by QA team and responsible for changing the defect status in QC.
• Participated in UAT reviews.
• Support on existing report and universe design issues.

Environment:: Tableau Desktop, Tableau Reader, Tableau Public, Microstrategy,Tableau Server8/9 SQL Server, Word, Excel, and Windows 2007.

Confidential

BI Developer

Responsibilities:

• Designed and developed MIS reports for strategic production planning, accounts analysis and inventory planning using Microsoft SSIS
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment and deploy the data.
• Used Event Handlers for Exception Handling in SSIS packages.
• Supported Production Environment to schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Designed Change data capture to capture insert, update, and delete activities applied to SQL Server tables, and to make the details of the changes available in an easily consumable relational format.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, Table Variables and Stored Procedures.
• Implemented BizTalk solutions and Change Requests (CR) using BizTalk artifacts such as Orchestration, Maps, and Pipelines etc. as per client requirement
• Tested, developed BizTalk, SSIS solutions and conducted UAT for performance monitoring, system bug tracking and system integration testing
• Provided RCA’s for production environment issues related to BizTalk and SSIS solutions and ensured quick response time in providing rectification measures
• Involved in training, knowledge transfer and sharing sessions

Environment: SQL Server, SSIS, MS Excel, Windows Server 2008 R2, Microstrategy,QTP, Microsoft Biztalk Server, SQL Profiler

Confidential

SQL BI Developer

Responsibilities:

• Active in designing the logical and physical architecture of database.
• Analysis, design, development, and enhancement of the data warehousing application.
• Installation and configuration of MS SQL Server 2000/2005.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Developed custom reports using SSRS/SQL Server BI studio.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package
• Design and implementation of Replication solution for SQL Server 2000 using Enterprise Manager
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
• Performance tune SQL statements, queries, triggers and stored procedures
• Created indexed views, and appropriate indexes to cut the complex query time.
• Developed Backup and Recovery Strategies and Disaster Recovery Plan
• Developed OLAP cubes in SSAS using Data Ware house tables
• Database creation, database tuning, and performance planning, backup planning and database administration.

Environment: SQL Server 2000, ASP, ADO, Java Script, Crystal Reports, and Microsoft Visual Studio 6.0., Visio, IIS.