SUMMARY

• Overall 8 + years of IT experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment.
• 3 years of extensive experience in Tableau Desktop/ Tableau Server, creating highly interactive Data visualization Dashboards using feature such as Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• 1 year experience in installing, configuring and testing hadoop ecosystems.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Sound knowledge of Retail, Health Care, Insurance, Telecom and Financial industries.
• Proficient in Tableau 9.x/8.x product suite (Desktop, Server, Public, Reader, Mobile).
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• 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
• Interviewed 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 ProcessAnalysis, 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.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Extensively involved in Reverse-Engineering and Business rules extraction expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirements

TECHNICAL SKILLS

BI Tools: Tableau 9.x/8.x, MicroStrategy, Business Objects, SSRS

ETL Tools: Informatica, Data Stage, Microsoft SQL Server Integrated Services

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel) Change Management HP Open View, CA Service Manager, Lotus Notes & Service Management

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: NoSQL, Oracle, SQL Server, DB2, Sybase, Access

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool: HP Quality center 10.0

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

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Austin,Tx

Data Analyst/ Tableau developer

Responsibilities

• Gathered business requirements from external source systems to develop a new Inventory Valuation process.
• Analyzed the changes to the existing source systems to OBIEE reports as a part of inventory Remediation project
• Documented the daily ETL job process and its dependencies from source to datamarts
• Created Source to target mapping documents for clinical data and documented schema changes for ICD-10 implementation.
• Analyzed and documented the existing functional ETL processes and validated its business logic with the reports.
• Worked with the data warehouse team and coordinated team meetings to facilitate knowledge transfer of the production systems to new team members.
• Proactively developed process flow diagrams to the existing process and organized and shared the information across teams for various projects
• Adhered with all the project timelines and BRD approvals from business users, project managers and director
• Analyzed and coordinated meeting with vendors of commercially available data warehouse tool.
• Analyze, define and document requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks, controls and outputs.
• Coordinating meetings to analyze the business requirements and document the business logic in SQL scripts.
• Prepared enterprise data sources for use with Tableau, including non-structured, dimensional, and relational sources.
• Involved in drawing upon full range of Tableau platform technologies to design and implement proof of concept solutions.
• Developed prototype reports for various requirements using Tableau and presented the same to business users.
• Developed and standardized the best practices in dashboard design and layout in terms of fonts, colors, container selection and size, incorporating the titles and logos in the right places, etc.
• Developed Trend charts, Pareto charts, Bubble charts and Pie charts, and actions involving hyperlinks and filters to connect different vizs within a dashboard and to connect other dashboards which utilize the same worksheets.
• Turned data sets into models, tools, and pictures that solve business problems.
• Trained and mentored power users to develop reports using Tableau Desktop.
• Provided on-going analytical and technical support including maintenance and support of existing data sources, data integration, operational reports and dashboards.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.
• Documenting the test results according to clinical data compliance.

Environment: Hadoop, Tableau (Desktop, Server), OBIEE, Informatica, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, NJ

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Effectively interacted with data modelers and defined the mapping requirements from source to target.
• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production
• Actively involved in new KPI generation for tableau Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Identify new metrics and enhance the existing KPI's.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with Teradata database and pull data to work on BI requirement.
• Provided Ongoing support to BI application running in production & troubleshoot.

Environment: Tableau (Desktop, Server), Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, GA

Sr.Tableau Developer/ Sr, Data Analyst

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 with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
• Worked closely with 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
• 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.
• 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.
• Actively involved in Setting up Tableau Environment.
• Worked with key business data to understand and analyze the customer data and.
• Creating Visualizations in tableau using Excel, DW and SharePoint data.
• 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, Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS VISIO, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential, Schaumburg, IL

Sr. Data Analyst/ Business System Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created the AS-IS and TO-BE process flow diagrams.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Defined functional business requirements, analyzed client requirements, and generated workflow processes
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.
• Designed, developed, and tested the jobs, using Data Stage
• Involved in the some part of performance tuning.
• Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Experience in using MicroStrategy in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential, Hartford, Connecticut

BI Developer/ Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created the AS-IS and TO-BE process flow diagrams.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Defined functional business requirements, analyzed client requirements, and generated workflow processes
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.
• Designed, developed, and tested the jobs, using Data Stage
• Involved in the some part of performance tuning.
• Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Experience in using MicroStrategy in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

SQL Developer

Responsibilites:

• Promote emphasis on tools and process to facilitate analytics
• Involved in the development of system test plan which included scope, objectives, resources, timelines etc. of the testing effort.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Analyzed the reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application with SharePoint as backend.
• Handled unit and system integration testing
• Prepared a help guide to system usage for the convenience of end users.
• 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: Oracle, SQL Server, Putty, SQL/PLSQL and Windows 2000.