SUMMARY

• 7+ years of experience as BI Developer in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of projects.
• Expertice in using tools including Tableau development / Tableau Admin and Business Objects.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Proficient in Tableau 7.x/8.x/9.x product suite (Desktop, Server)
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher - level data analysis and data management services.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Involved in meeting with SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Experienced in preparing Business Process Re-engineering Models.
• 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.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Proficient in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Knowledge on all the data sources SQL Server, Oracle, DB2, or Teradata, Big Data as a data source for Tableau
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planningand tracking of results.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

BI Tools: Tableau, Business Objects, Web-Intelligence, Report Conversion tool, Desktop-Intelligence, Import wizard.

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

Modeling Tools: MS-Visio

ETL Tools: Tools Informatica, Microsoft SQL Server Integrated Services

Data Migration: Eclipse, Sun IDE, JBuilder.

Web/Application Servers: Apache Tomcat, Weblogic, WebSphere, JBoss.

Configuration Management Tools: Team Foundation Server, Visual Source Safe, Clear Case

Methodologies: SDLC, UML, Design Patterns, SOA

Databases: Oracle 9i/10g/11g, DB2, SQL Server.

OS: Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential, Middletown, NJ

Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1
• (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created
• Hyperlinks for each of the Metric to open a detail report using Open Documents
• Experience on writing SQL Queries.
• Experience on BW Analyzer & Query Designer.
• Strong verbal and written communication skills, ability to work effectively with user departments.
• Worked towards the goals of quality, time and budget.

Environment: Tableau Desktop, Tableau server / Administrator, Oracle 10/11g, Microsoft Excel, MS Access, Microsoft office MS SQL SERVER 2008, SSIS, SSAS, SSRS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access.

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site's financial transactions and database management applications operate Confidential peak efficiency.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.

Environment: Windows XP, Linux, Windows 7, Tableau, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB

Confidential, Scotts Valley, CA

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.
• Defined best practices for Tableau report development.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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 R11, PostgreSQL, Visual Studio.

Confidential, Richmond, VA

Tableau Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Organized Error and Event handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers in SSIS.
• Created and assisted users in Tableau dashboard development.
• Created SQL Queries for testing the tableau Dashboards.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services (SSRS)
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions
• Assist in the problem identification, analysis, design and implementation of development as required. Involved in SSAS cube design and development
• Optimized queries by looking Confidential Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MS SQL Server 2008, Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS, Visual Studio 2010, Windows.

Confidential

Bussiness Analyst

Responsibilities:

• Developed business process models in Agile methodology to document existing and future business processes.
• Documented business requirements and worked with stakeholders to elaborate on functional/non-functional requirements.
• Conducted drill down sessions with Subject Matter Experts to detail the requirements and adopted the best suitable SDLC techniques to gather the requirements, like interviews, in-person meetings etc.
• Documented requirements for the application and identified interfaces required for the system.
• Performed GAP analysis of existing system and evaluated benefits of new system.
• Communicated with the business team on regular basis to improve and meet the objective of the requirement analysis phase.
• Produced Use Case scenarios to help team drive through the requirements phase.
• Utilized macros in Excel to pull data from our defect/change management tool Remedy P/CM to generate daily reports. Performed Technical Analyst duties including executing and validating data corrections using SQL Server stored procedures and ad-hoc reports.
• Reviewed and signed-off on SOX database and file system access reviews to ensure that they complied with the SOX 404 regulatory requirements.
• Reported project milestones to multiple stakeholders on a daily basis for the Securities Cost Basis Sub-ledger work-stream.