PROFESSIONAL SUMMARY:

• Certified Tableau Developer & Business Data Analyst with 8+ years of IT experience in Data warehousing, Data analysis, Business analysis, Business intelligence, Implementation and Maintenance of Database & Reporting applications
• 5+ years of extensive Tableau Development and Administration Experience using Tableau 2018,10.x/9.x/8.x
• Expertise in end to end Business Intelligence, Data Visualization, Data Analysis, hands - on with creating solution driven dashboard.
• Extensive knowledge with many data mapping, programming, and advanced Excel functions and Teradata.
• Highly proficient in Agile, Test Driven, Data driven, Iterative, Scrum and Waterfall methodologies of Software Development Life Cycle (SDLC).
• 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.
• Proficient in creating requirements specifications including Project Vision, Project Scope, BRD, FRD, Test cases, Gap Analysis, Data models and Requirements traceability matrix (RTM).
• Proficient in creating Use Cases, Data Flow Diagrams, Sequence Diagrams, Class Diagrams, State Transition Diagrams, ER Diagrams etc.
• Expertise in collaborating with Scrum team members including Product Owner and Scrum Master; proficient in creating SCRUM artifacts like User Stories / Backlogs, Burn-down charts.
• Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis, Physical and Logical data modeling.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources
• Hands on experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau server.
• Hands on experience Heat maps, Geo Maps, Pie charts, Tree Maps, Scatter plot charts, histogram in Tableau Desktop.
• Highly proficient in design and development of prototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
• Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filters, actions and creating Dashboards for key performance indicators.
• Expert in creating Quick Table Calculations, Static and Dynamic sets, Parameters and Level of Detail using advanced logical and statistical functions in Tableau Desktop.
• Extensive experience in using Tableau (Desktop/ Server), Teradata, Informatica Power Center, Business Objects Enterprise, Java Script API, SQL Server, Oracle10g.
• Scheduled data refresh on Tableau Server for daily, weekly and monthly increments
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Flexible, enthusiastic and project-oriented team player with excellent communication and leadership abilities to develop creative solution for challenging requirement of client.
• Able to communicate complex concepts and analysis to a variety of audience knowledge levels. Data visualization and storytelling skills

TECHNICAL SKILLS:

Requirement Management Tools: Power Designer, MS Word, and Excel.

Methodologies: RUP, Waterfall, Agile.

Modeling Languages: SQL, UML, XML.

Business/Data Modeling Tools: Power Designer, Smart Draw, MS Visio, Just in Mind.

ETL tools: Informatica Power Center10,9.1

Project Management Tools: MS Project, MS Excel, SharePoint.

Scripting Languages: C, C++, HTML, SQL, XML, VB, JavaScript, Python

Database: Oracle 11g/10g/9i/8i, MS SQL Server, Teradata MS Access

Application: MS Office including Visio, SharePoint, MS Project

Reporting Tools: Tableau (Desktop 8x, 9x, 10.5.1,2018)

Operating systems: Windows XP/10

PROFESSIONAL EXPERIENCE:

Confidential, Basking Ridge, NJ

Tableau Developer

Responsibilities:

• Involved in reviewing requirement and finding end to end implementation of intents of chat bot responses, starting from requirement gathering and dashboards developments in tableau desktop.
• Studied and analyzed similar application and brainstormed with business team to gather effective requirements for the systems along with dashboard development.
• Strong product development mindset and focus on actionable analytics: e.g. Ability to surface signals in our data and work with Product/Engineering to transform these into concrete tests
• Analyzes data to describe client behavior and preferences, understand channel usage, diagnose client experience problems, size marketing opportunity, target clients for treatment and measure the impact of marketing and servicing initiatives. Utilizes appropriate analytic methods and specialized tools to generate insights, answer the business questions and fulfill project objectives
• Created numerous dashboards in Tableau Desktop based on the data collected from Chabot by importing and blending data from Teradata SQL server database.
• Developed Geo Maps to show details on which states are most connected using app and web.
• Created bar charts which is complied with data sets and added trend lines and forecasting on future usage of the app.
• Created crosstab to display underlying data based on various graphs and charts created for further data analysis.
• Developed scatter plot and area maps to show states utilizing the app most and least.
• Created interactive dashboards with parametrized control so business or end user can access data based on their requirements.
• Developed and reviewed SQL query with complicated calculation and join statements such as left, inner and right join to obtain require results and used in visualization.
• Performed data analysis on daily, weekly and monthly scheduled refresh of data based on that business or system change that have happened to ensure that developed dashboards are displaying accurate and up to date live data and send those into production after editing.
• Created view in Teradata server to review the data validation of million rows of data with tableau desktop
• Participated in weekly meeting, reviewer and user group meeting as well as stakeholders and business groups.

Environment: Tableau Desktop10.x, Tableau Desktop 2018, Tableau Server 10x, Teradata, MS Excel, SQL, Power Designer, MS Office, MS Visio

Confidential, New York City, NY

Tableau Developer

Responsibilities:

• Performed requirement gathering and knowledge extraction about the financial services through interviews, audio/video conferencing and JAD sessions
• Identifying and gathering business requirements from different groups, end users for developing reports.
• Translated the gathered requirements into user stories by detailing in the functional and non-functional requirements based on interactions with the Product Managers and SME’s who gave the customer’s real-time feedback about theasset under management (AUM)and net new assets (NNA).
• Analyzes data to describe client behavior and preferences, understand channel usage, diagnose client experience problems, size marketing opportunity, target clients for treatment and measure the impact of marketing and servicing initiatives. Utilizes appropriate analytic methods and specialized tools to generate insights, answer the business questions and fulfill project objectives
• Prepares and delivers insight presentations and action recommendations. Communicates complex material in layman's terms. Guides business partners on the interpretation and use of analytic results
• Worked with Front Office/ Middle Office to understand KPI and build workflows for business process modeling using Power Designer
• Identified ‘AS-IS’ process and ‘TO-BE’ process as parts of Gap Analysis for implementing NNA component.
• Assisted Scrum Master and participated in Daily Scrum to summarize what has been done, plan what needs to be done and to recognize the impediments
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 10
• Coordinated Phased Report Migration process to handle large and complex volumes of Teradata and address dashboard reporting capabilities.
• Have extensively used Tableau functions like Data Blending, Custom SQL, Interactivity, and Chart types, Navigation, Images and Parameters in this process.
• Have used Custom SQL, Aggregate and Analytical functions to extract the requiredcontracts/Opportunities Teradata for reports and dashboard development.
• Tableau advanced charts using geo maps, Gantt charts, Pareto charts, scattered plots for providing multidimensional views.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Creation of tableau users and testing with different security levels for web authorization and authentication.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Produced Requirements Traceability Matrices to support the application development that included Business Requirements, Actor Survey, Use Case Survey, Supplementary Specification Survey, Analysis Model, and Design Test Case Survey.
• Work with data scientists to analyze Teradata and develop insightful data visualization.
• Exploring Tableau 10.2 features for web editing and authoring, filters and server monitoring.
• Build and publish Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs and Actions.
• Integration of tableau reports with web application and viewing reports online.

Environment: Tableau Desktop10. x./9.x, Tableau Server 9x/10x, PL/SQL, Oracle 10g, Teradata, MS Excel, SQL, Power Designer, MS Office, MS Visio

Confidential, Hopewell, NJ

Tableau Developer/Analyst

Responsibilities:

• Worked closely with business stake holders for gathering requirements and managing the delivery, to understand layout, and design of the application to be developed, covering the entire Tableau development lifecycle.
• Executes analytic projects to provide insight into client needs and behavior, supporting marketing and client servicing decisions
• Engages with project sponsors and stakeholders to understand each business question. Probes for hidden questions and goals. Helps bring structure to each request and translate requirements into an analytic approach
• Acquires structured and unstructured data and prepares it for analysis. Investigates, extracts, cleans, transforms, QCs and manages data using SQL and Base SAS programming techniques. Identifies and diagnoses data inconsistencies and errors and forages to fill data gaps
• Performed requirement gathering and knowledge extraction about the credit risk involved and loan balanceusing both formal and informal sessions through interviews, audio/video conferencing and JAD sessions
• Responsible for documenting functional specification documents based on user requirements using Use Case Modeling.
• Designed and developed various analytical reports from multiple data sources, Teradata by blending data on a single worksheet in Tableau Desktop
• Performing joins to combine data from Oracle and Excel by performing relevant mapping
• Optimized various data collection, Teradata procedures and generated reports on a weekly, monthly, and quarterly basis
• Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions
• Used Snowflake and Star Schema Designs for data modeling.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau
• Got a Good Experience in working with Macros either in Excel
• Analyzed the source data and handled efficiently by modifying the data types.
• Developing front-end dashboards and interactive data visualizations to convey both visual storytelling and visual representation of risk
• Created User Acceptance Testing (UAT) plans with several test scenarios to ensure that the proposed features and functionalities are functioning correctly.
• Excellent in creating various artifacts for projects which include specification documents, data mapping and Teradata analysis documents.

Environment: Tableau Desktop 9.x/8.x, Tableau Server, MS SQL Server 2008,, MS Visio, Oracle 10g, Teradata, Rational Unified Process (RUP) Methodology, SAP Power Designer, Microsoft Office Suite, Microsoft Visio

Confidential

Data Analyst/Tableau Developer

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Setting up of Environment to be used for testing and the range of functionalities to be tested as per technical specifications.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• 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.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• 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
• Apply your expertise in quantitative analysis, data visualization and data-engineering to tell the story behind numbers.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs work with data scientists to analyze data and develop insightful data visualizations
• Create and provide data visualization internal trainings
• Experience in providing Tableau server and tableau desktop training.

Environment: Tableau Server, Tableau Desktop 8.x/7.x, Windows Server Standard, Oracle 10g, Excel

Confidential

Business/Data Analyst

Responsibilities:

• Worked throughout the SDLC process, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Performed GAP analysis and wrote application enhancement specifications detailing in as-is/to-be process maps and critical test scenarios.
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD) by gathering requirements through detailed discussions with business users and Subject Matter Experts (SMEs).
• Closely interacted with designers and developers to understand the application functionality and navigational flow. Kept them updated on requirement modifications to continuously improve and develop new features.
• Developed Use Cases and Data Flow Diagrams (DFD) for the online claims filing method.
• Organized and participated in Joint Application Development (JAD) sessions with business users, development and testing teams.
• Participated in various meetings and discussed enhancements and modifications with business users and stakeholders.
• Provided structured walkthrough to the developers to understand the Use Cases and worked with quality control teams to develop Test Plans, Test Cases and test scripts based on usability and functional performance criteria.
• Organized UI/GUI Testing, Functional Testing, Progression and Regression testing and provided support for User Acceptance Testing (UAT) for multiple iterations involving the entire User environment setup.
• Tested the application manually and worked with RTM with the Quality Center (QC).
• Wrote SQL statements to extract data from the tables to validate data flow
• Participated in product release and deployment to end-users after successful development and testing of the product. Also participated in training the end-users and creating training documents.

Environment: SAP Power Designer, Visio, UML 2.0, SharePoint, Oracle, MS Office Suite 2007

Confidential

CMA Officer/ Loan Officer

Responsibilities:

• Gathered user and business requirements through interviews, surveys, prototyping and observing from subject matter experts while using MS SharePoint for storing project documents.
• CMA Data means Credit Monitoring Arrangement data. As per RBI guidelines, CMA data is required for Project Loans, Term Loans and Working Capital Limits. This data is to be provided by a company to bank for getting the loan from bank and every year, for renewing or enhancing their existing Bank loan.
• Planned and defined system requirements to use case, use case scenario and use case narrative using the UML methodologies for term loan application and working capital.
• Documenting processes step-by-step, reviewing with constituents, consulting with RBI guidelines, and reporting directly to project manager and upper management.
• Using UML Created Use Case diagrams, and Sequence diagrams to show various verification processes.
• Documented process flows, system specifications. Assisted JAD (Join Application Development) meetings/sessions using agile methodology.
• Checked various document such as audited financial report, projection of company, fund flow statement, etc.
• Worked on financial ratio, holding level, Assed bank finance, and fund flowto sanction the proposed project.
• After sanction, bank provide term loan payment schedule, bank approved interest rate with the term and condition, Maximum permissible bank finance report, sanction letter.

Environment: MS Office-Excel, Power Designer, XML.