Data Project
Resume:
Priya
Sr. Tableau Developer / Sr. Data Analyst
******@***********.***
SUMMARY:
* ***** ** ********** ** Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of projects using Tableau, Cognos, SSIS, SSRS, Informatica, Teradata and Oracle in Retail, Transportation and Financial industries
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.
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 and Parameters 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.
Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
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.
SKILL SET:
Reporting Tools
Tableau, Cognos SSRS
Modeling Tools
Power Designer, Erwin, ER Studio, MS Visio.
Data Integration Tools
Informatica, Power Center, SQL Server DTS,SSIS
SQL Tools
Rapid SQL, Toad, Teradata SQL Assistant, PL/SQL Developer
RDBMS
Teradata, Oracle, SQL Server, DB2, Access
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
Abercrombie & Fitch, New Albany, OH June 2014 – Till date
Sr.Tableau Developer/Data Analyst
Abercrombie & Fitch, also known as A&F, is an American retailer that focuses on casual wear for consumers aged 18 to 22, and is headquartered in New Albany, Ohio. It has over 300 locations in the United States, and is expanding internationally. The company also operates three offshoot brands - Abercrombie Kids, Hollister Co., and Gilly Hicks. The project is to implement Business Intelligence application by creating various reports, dashboards and scorecards using Tableau Reporting Services.
Responsibilities:
Gathering the clients, Suppliers and internal resource data from all the Vendor Management Systems.
New KPI generation for Scorecards.
Involved in Data collection and leveraging data manipulation team for required data based on report requirements.
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.
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.
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.
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.
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.
Environment: Tableau Desktop 8, Teradata,Excel 2013, Outlook 2013, VMS Systems, Microsoft Office Suite ( Word, Excel, Power Point, Visio).
The Nielsen Company, Schaumburg IL Feb 2013 – May 2014
Tableau Developer/Sr. Data Analyst
The Nielsen Company is the leading global provider of market information gathered from a wide range of sources, advanced information management tools, sophisticated analytical systems & methodologies and dedicated professional client service to help their clients get a near to accurate sales data based upon which Nielsen’s clients determine their business strategy. By delivering an unmatched combination of insights, market intelligence, advanced analytical tools and integrated marketing solutions, Nielsen provides clients with the most complete view of their consumers and their markets. The privately held company has more than 42,000 employees and is active in more than 100 countries, with headquarters in New York, USA. This project is to implement BI reporting solutions by creating reports, dashboards, and scorecards in Tableau.
Responsibilities:
Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
Analyzed requirements for various reports, dashboards, scorecards and created the same using Tableau desktop server.
Mentored 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 advanced features of Tableau software like, linking 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.
Created and modified Interactive Dashboards and had Created guided navigation links within Interactive Dashboards.
Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
Made use of filters, making them local and global accordingly.
Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
Scheduled for Tableau extract to refer new data, based on Weekly and Monthly data refresh schedules
Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, iPhones and other smart mobile phones.
Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
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 in 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, Informatica, SQL, PL/SQL, MS Project.
Blue Cross Blue Shield, Chicago, IL Jan 2012 - Jan 2013
Tableau Developer/ Data Analyst
Blue Cross and Blue Shield insurance companies are licensees, independent of the association (and traditionally of each other), offering insurance plans within defined regions under one or both of the association's brands. Blue Cross Blue Shield insurers offer some form of health insurance coverage in every U.S. state. The project is to support Business Intelligence strategy by development of various reports, dashboards using Tableau on Claims Data and also document Claim data flow within the Databases.
Responsibilities:
Interacted with business users and performed Gap Analysis on Client requirements
Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows and requirements traceability matrix.
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, timelines, testing and technical delivery.
Designed and developed Tableau reports, dashboard and metrics to support Claims Reporting and Business Intelligence strategy.
Developed Tableau objects like Filters, Parameters, Calculated fields, Hierarchies, Actions in report development.
Extensively used Tableau Report Services to 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 Dashboards for the Company Executives through an efficient use of Tableau Report Services.
Created all possible Metrics for enabling the end users to generate customized reports by creating their own Templates and Filters.
Built Complex Reports using advanced reporting functions with YTD calculations, percentage differences, sets and groups etc.,
Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
Responsible for testing, fixing defects and troubleshooting the technical problems.
Creating and developing test strategies, test cases and test plans
Environment: Tableau 8.x, Teradata, Oracle, SQL Server, Power Designer, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite ( Word, Excel, Power Point, Visio).
DelDOT, Dover, DE Sep 2010 - Dec 2011
Business Systems Analyst/ Data Analyst
DelDOT is a Delaware Department of Transportation Company. The Mission of the State of Delaware's Department of Transportation is to provide a safe, efficient, and environmentally sensitive transportation network that offers a variety of convenient and cost-effective choices for the movement of people and goods. They maintained Equipment Management and Maximo Maintenance Management Databases on Oracle. The Project is to implement Reporting Models, Cubes and Reports for these Data Bases.
Responsibilities:
Involved in Requirements Gathering for application users, interviewing them and obtaining their reporting needs.
Involved in the complete Life cycle of the Project and in the data 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 data model
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 and Plan data marts.
Used Erwin to define data model 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 Attributes, Facts, Metrics, Filters and other report objects.
Conducted data validation testing to ensure data quality.
Actively participated 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 defects against test data and On-line real time 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).
BB&T Corporation, Winston-Salem, NC May 2009 – Aug 2010
Business Systems Analyst
BB&T is the Financial holding company operating banking subsidiaries in the eastern and southern United States. Smart Acquisition is the product of BB&T, which helps in getting new customers who are interested in a mortgage loan from the bank. This project involves development of the smart acquisition system and providing support, resolving various issues and providing enhancements in the existing system. The Business rules are evaluated on the existing information to find out the customers who are willing to take a loan.
Responsibilities:
Gathered and documented business requirements for existing and future business systems.
Worked with the business unit to define business requirements and analyze the possible technical solutions.
Responsibilities included requirement gathering, business process flow, business process modeling and business analysis.
Facilitated and managed meeting sessions with committee of SME from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
Designed and developed project document templates based on SDLC methodology.
Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
Conducted workflow, process diagram and gap analyses to drive requirements for the automation process.
Using detailed knowledge of application features and functions access scope and impact of business needs throughout analysis and completion of all enhancement specifications.
Providing Support and Maintenance for all the clients.
Environment: Sun Solaris, Windows NT, Oracle 9i, My Sql, JSP, Servlet, Dhtml, Kornshell Script, SQL Server(SSIS, SSRS), Microsoft Office Suite ( Word, Excel, Power Point, Visio).
ITC Info Tech, Bangalore, India June 2007 – Apr 2009
Role: QA Tester
As a Quality Assurance Analyst, in Testing Group of ITC Info Tech, Involved in testing the various client server and web applications developed using Microsoft and Java technologies which are developed for various financial, health and government sectors.
Responsibilities:
Worked with onsite team for gathering requirements and determine the scope of the solution.
The content format for creating test scenarios, test cases and bugs.
Involved in defining test scope of the application, creating master test plan, detail test plan, writing high level scenarios based on use cases.
Coordinated with business users and development team members to understand business requirements and develop test cases.
Proactively involved in conducting the triage meetings and resolved issues and bugs.
Performed Integration, functional, Black box, performance and acceptance testing.
Involved in developing Test Plans and test cases in Test Director.
Ran automated scripts using QTP Extensively for Regression Testing
CDF / ILINK applications are used to create life, group life, dental, health, property, disability plans, and rate groups and assign these plans to customers. These applications also involve the benefits associated with a specific plan, billing customers, and handling claims.
Application was developed using XML, EJB on Web Logic server. There is also Client Server based version developed using Visual Basic. Database used was Oracle 8i.
Involved in System, Regression, and Performance testing of the Application. Production support with any issues / errors in the production system. Interact with developers and business users to solve software defects and other product relevant issues.
Environment: Win 2000, Visual Basic, XML, HTML, Java, .NET, QTP, Test director and Oracle.
Contact this candidate