PROFESSIONAL SUMMARY:

• 8+ years of extensive experience in Report design, Dashboard development, data quality testing, Quality Assurance and Testing of Software applications.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Around 3+ years of development experience in Tableau 6.x/7.x/8.x
• Expertise in interacting with end users, functional/technical experts and identifying, analyze and developing the reports that meet the business needs.
• Experienced in all activities of full life cycle implementation including Project management, requirement analysis, Data Modeling, Design, Specification development, Reporting, Web publishing, Portal integration, Performance tuning, testing, Documentation.
• Proficient in conducting Gap Analysis, Designing data flows and communicating the trade - off decisions on product features based on technology and customer requirements.
• Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
• 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.
• Managed cross-functional teams through Software Development Life Cycle.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Hands on experience in publishing various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Extensively provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Outstanding knowledge in designing and developing Data Marts using Kimball/ Inmon methodologies.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Strong knowledge of business/process data flow in organizations and experienced in data modeling Concepts.
• Extensively worked on development of Web Intelligence, Desktop Intelligence Reports.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization,Business ProcessAnalysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Good knowledge on troubleshooting and problem solving skills.
• Excellent communication, interpersonal and analytical skills with ability to manage and work effectively to meet deadlines in fast paced environment.

TECHNICAL SKILLS:

Reporting Tools: Tableau 6.x/7.x/8.x (Desktop/Server), Microsoft SQL Server Reporting Services, Business Objects.

ETL Tools: Informatica, SQL Server Integration Services (SSIS)

Databases: MySQL, MS SQL Server, Hive, Amazon Redshift, Teradata, IBM DB2, Oracle, MS Access

Programming: SQL, ESQL, HTML Documenting and

Office Tools: MS Office (MS Excel, MS Word, MS PowerPoint), MS Project.

Scheduling Tools: Autosys, Control MChange/ Service

Management Tool: HP Service Manager, CA Service Desk Manager, Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Sr. Data Analyst/ Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked as Tableau developer/SME in standardizing Tableau for shared service deployment.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Worked with Tableau administrator in installing Tableau Server in Dev, QA, UAT and Prod environments.
• Utilized advanced features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created and modified Interactive Dashboards and Created guided navigation links within Interactive Dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhone, and other smart mobile phones.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau (Desktop/Server), IBM DB2, Windows Server Standard R2, Clearquest, Clearcase, Oracle 11i, Netezza, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.

Confidential, Princeton NJ

Sr. Business Systems Analyst/ Data Analyst

Responsibilities:

• Liaison for project managers, managers, directors, and stakeholders.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
• Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
• Developed, derived and clarified functional specifications and Use cases.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Designed the conceptual and business process models.
• Implementation of new systems including the integration of the new system with existing systems.
• Verifying installed systems to ensure that they adequately meet user requirements.
• Physical design of data record data files and databases.
• Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.
• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
• Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.
• Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.
• Deployment of defect free code while managing the timeline set for the project.

Environment: Tableau, Teradata, Oracle, SQL Server, TOAD, PLSQL Developer, ERwin, SQL Developer, SAS, Informatica, MS VISIO, Microsoft (Word, Access, Excel, Outlook)

Confidential, New Albany, OH

Business Intelligence Consultant/ Data Analyst

Responsibilities:

• To oversee the performance of Design to develop technical solutions from Analysis documents.
• Possessed and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
• 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.
• Translated business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• Worked to ensure high levels of data consistency between systems.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data, etc.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.

Environment: MicroStrategy, Oracle, MS Access, Teradata, Informatica, TOAD, SQL Developer, PL/SQL Developer, Autosys, HP Open View, Windows 2003/XP, ERwin, and MS Office Suite (Word, Excel, PowerPoint).

Confidential, Denver, CO

Business Systems Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Worked with users and coordinated with actuate developers to understand and capture data/reporting requirements.
• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Worked with Project team to determine technical and development impact of a project.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models.
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
• Modeled use-case diagrams in Rational Rose to show end-user interaction with the rmation, loan information & property information modules.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from the user perspective.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Designed various analytical reports, dashboards in MicroStrategy on Sales, Finance data as per end user requirement.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• 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: Oracle, TOAD, SQL, Share Point, TFS, Agile-Scrum, Informatica, MicroStrategy, Autosys, UNIX, SQL Server (SSIS, SSRS), ERwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).

SQL Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to get a better understanding of client business processes and to gather business requirements. Analyzed the Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Converted the User Requirements into Business Requirements, Functional Requirements and Technical Requirements. Also created Business Process Models from the requirement specifications.
• Created Use Case specifications, Business flow diagrams, Activity/State diagram and Sequence diagram using MS Visio, so the developers and other stake holders can understand the business process according to their perspective with possible alternate scenarios.
• Communicated extensively with the Financial Examiners and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Implemented RUP and followed iterative, Use Case driven process for requirement documentation and deployment.
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing / verification.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Developed user test cases and validated test results during user acceptance testing.
• Assured that all Artefacts are in compliance with Department’s SLC Policies and guidelines.
• Used Test Director for Defect Tracking and prioritizing defects and for enhancements after base lining the requirements.

Environment: MS Outlook, MS SQL Server 2000, Microsoft Visio, MS Office, XML