SUMMARY

• 7+ years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of projects using Tableau, Cognos, Microstrategy, SSRS, SSIS, Informatica, Teradata, Oracle, etc. in Retail, Healthcare, Transportation and Financial industries
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Proficient in Tableau 7.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.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Having Good Knowledge of Qlik view.
• 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 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 requirement of client.

TECHNICAL SKILLS

Reporting Tools: Tableau, Cognos, Microstrategy, SSRS

Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

Data Integration Tools: Informatica Power Center SQL Server DTS

SQL Tools: Rapid SQL, Toad, Teradata SQL Assistant, PL/SQL Developer

RDBMS: Teradata, Oracle, SQL Server, DB2, Access etc

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation: Documentum, SharePoint, HP Quality Center

Scripting/Lang..: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows 7/XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

Sr. Data Analyst/ Sr. Tableau Developer

Responsibilities:

• Gathering the clients, Suppliers and internal resource data from all the Vendor Management Systems.
• Actively involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• 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, Chicago, IL

Data Analyst/ Tableau Developer

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.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Worked with the report development Manager and other team members on report requirements, timelines, testing, and technical delivery.
• Designed and developed Tableau reports, dashboard and metrics to support Claims Reporting and Business Intelligence strategy
• DevelopedTableau objectslike Filters, Parameters, Calculated fields, Hierarchies, Actions, etc.
• Extensively usedTableauReport Servicesto generate Report Documents.
• Created calculated fields for comparative reports like claims this year to last year (year to date and month to date).
• Designed different BI Dashboardsfor the Company Executives, through an efficient use of Tableau Report Services.
• Created all possibleMetrics, for enabling the end users to generate customized reports by creating their ownTemplatesandFilters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Creating and developing test strategies, test cases and test plans

Environment: Tableau (Desktop, Server), Teradata, Oracle, SQL Server, Power Designer, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite ( Word, Excel, Power Point, Visio).

Confidential, Dover, DE

Business Systems Analyst/ Data Analyst

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Involved in the completeLife cycle of the Project and in thedata analysis process
• Gather the various requirement matrices from the business analysts.
• Worked with Master Data Management.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Designs for the various reporting requirements.
• Conduct Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Used Erwin for developing data model and forward engineer the data model.
• Reverse engineer the data base in to physical data model by using Erwin.
• Developed entities and relationships using Sybase Power Designer.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents between legacy, production and user interface systems.
• Designed different type of STAR schemas like detailed data marts, Plan data marts,
• Used Erwin for monthly summary data marts and inventory data marts.
• Designed ER Diagrams, star schema and snow flake schema.
• Importing source definitions. Creating and importing target definitions. Creating the table targets.
• Created and modified of Attributes, Facts, Metrics, Filters and other report objects.
• Conducted data validation testing to ensure data quality.
• Active Participation in checking the data at database level and at SSRS level in case of displaying wrong data.
• Tested all the business application rules with test & live data and automated.
• Involved in testing and fixing bugs on test and On-line data.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Informatica, Cognos, Power Designer, PL/SQL, Oracle9i, TOAD, UML, Microsoft Office Suite ( Word, Excel, Power Point, Visio).

Confidential, San Jose, CA

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 personal information, 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 and developed a business intelligence dashboard using MicroStrategy’s Web development tools, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• 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).

Confidential

Business Analyst

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 Requirement. 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