SUMMARY

• 8 years of experience as a Data Analyst, Tableau Developer and Data Modeler related to Data Warehousing and ETL and Reporting environments
• Extensive experience using Tableau Server, Tableau Desktop and Tableau Public.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and built the Data warehouse, Data marts using Star Schema for faster and effective Querying.
• Experience connecting to various data sources like SAP BW using Tableau
• Experienced at Data Modeling, Data Architecture, Business and Data Analysis.
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized data models.
• Produced reports and metrics that proactively identify operational and process/data issues.
• Extensive experience in analyzing and documenting business requirements
• Experienced in conducting GAP analysis, What if analysis.
• Involved in the maintenance of therepositories for the metadata
• Experienced indata transformation,data mapping, data migrationfrom source to target database schemas,data cleansingprocedures
• Flexibility to adapt to the availability and needs of business subject matter experts or lack thereof and still produce results/recommendations
• Involved in the preparation of Detailed Design Documentation
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle.

TECHNICAL SKILLS

Operating Systems: Windows XP/2007, Unix/Linux

Languages: C, C++, SQL, UML, SAS, Python

RDBMS: Oracle 10g/9i, MS SQL Server 2008, Teradata

Tools: Tableau 9.0, Erwin 7.2, Power Designer 15, SQL*PLUS,PL/ SQL Developer, TOAD,Cognos, Crystal Reports, Business Objects

Office Tools: MS-Office-Word, Excel, Access, PowerPoint, MS Project

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Tableau Developer

Responsibilities:

• Acted as a liaison between developers and Business Users to communicate critical areas to be analyzed.
• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader. Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Generated reports using SQL queries in Tableau 8.x/9.x and published them to users in online thru Tableau server.
• Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.
• Worked on Bubble chart, Drill down analysis using tableau desktop.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Reporting by Regions, Products, Departments, Cost categories for various reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Gathered data using SQL Server, Oracle Business Objects, MS Access and other internal Cisco tools
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Proactively evaluated business landscape and requirements and identified explicit and implicit needs.
• Analyzed, designed and optimized business processes for better performance and reporting.
• Supported tasks and activities for business operations and project management teams.
• Interacted and built relationships with internal (business, technical, sales) teams and vendors / partners to drive project and provide support.
• Created executive level presentations using Microsoft Power Point.
• Participated in all phases of the development life cycle for assigned projects and coordinate business issues resolution throughout each project.
• Participated in business systems planning for integrated analytic needs.
• Participated in defining approaches and priorities for satisfying needs.

Environment: Business Objects 6.5, Tableau 9.0/8.1, Oracle 11g/10g, 9i,8i, PL/SQL,SQL*Plus, SQL Server 2005, 2000, Erwin, Microsoft PowerPoint, Word, Excel, Outlook, TOAD

Confidential, Wilmington, DE

Data Analyst/Data Modeler

Responsibilities:

• Worked with identified business users to define data requirements.
• Determined corporate metadata definitions for all Enterprise Data supported databases, developed logical and physical data models that document source data from multiple internal and external sources.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Built and analyzed queries from data sources.
• Worked closely with analytical and reporting infrastructure teams to ensure operational and analytical data warehouses are able to support all business requirements for OLAP reporting across the organization.
• Developed mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping.
• Coordinated with the Data Warehouse Development (ETL) team to research and define existing source to target mapping for the corporate Data Warehouse.
• Defined and developed designs to support departmental and functional data marts.
• Provide input to data modeling and physical database development standards with the Data Modeling Team. Assist in the review of database structures of proposed business application purchases.
• Built and analyzed queries from data sources.
• Worked closely with analytical and reporting infrastructure teams to ensure operational and analytical data warehouses are able to support all business requirements for OLAP reporting across the organization.

Environment: Tableau 7.0/8.0, PL/SQL Developer 8.0.4, Informatica 8.1.1, Oracle 10G, Quality Center 9.0 Version One, Display Fusion, Ultra Edit, Subversion (SVN), MS Visual Source system 6.0, MS Outlook

Confidential, Indianapolis, IN

Data Analyst

Responsibilities:

• Gathered business rules and information requirements from business partners
• Developed logical data models and their associated metadata based on the business rules and requirements
• Used three schema Architecture to design new data models.
• Managed offshore team explaining the business priorities and motivations for each project or enhancement.
• Developed a review and approval process for the logical data models.
• Documented and published the data models and their associated metadata.
• Assisted the application teams with the data needs related to new releases or other changes and updated the data models as needed
• Created UML diagrams including Activity diagrams, Sequence Diagrams, Use case diagrams, process maps, sequence diagrams, and data flow diagrams.
• Involved in mapping data from one store to another as may be required for data migrations, data loads, data integration
• Supported multiple applications and programs.
• Created SQL tables with referential integrity and developed queries using SQL, TOAD
• Created triggers, indexes, views in the data models to execute in the database.
• Resolved problems related to data quality or inconsistencies
• Identified possible sources for data population and promoted the use of shared data within a business area
• Worked with both relational and dimensional data models.
• Reverse Engineered COTS packages to the customer to gain agreement on the data usage, business rules, data flow.
• Worked closely with ETL team to map the data model.

Environment: Power Designer 15.1, Oracle 11g (10.211.1), Remedy ARS (Client version 5.01.02), Toad (10.6), Lotus Notes (6.5.4), Regulus, MS SQL Server (2008R2), MS Visio (2007 SP2), MS Project Professional (2007 SP2), SAP GUI (v21), MS Visual Studio.

Confidential, Manhattan, NYC

Business Analyst/ Data Modeler

Responsibilities:

• Involvedwith Business Analysts team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Translated business needs into data modeling initiatives.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Served as point of contact to address customer concerns
• Communicated hard to deliver issues with the customer and made the necessary changes
• Performed the data source mapping.
• Utilized Power Designer’s forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Review the data model with functional and technical team.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Assistdevelopers,ETL, BI team and end users to understand the data model.

Environment: Power Designer,Informatica PowerCenter 8.1.1/8.0/7.1, Oracle 10g, Teradata, Putty,TOAD, UNIX

Confidential

SQL Developer

Responsibilities:

• Created design documents after getting the requirements from the clients.
• Designing and developing complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Tuning and code optimization using different techniques like dynamic SQL, dynamic cursors, tuning SQL queries, writing generic procedures, functions and packages
• Developing reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by the team and satisfying the business rules
• Documented testing methodology and devised test scripts and plans to help the QA team in the functional aspect of the package and apply the same before submission to the client.
• Assisted in designing implementation plan and monitored the same by actively participating in user training, live data entry and obtained sign-off from the concerned departmental head

Environment: Oracle Designer 6i, Oracle 8i, PL/SQL, MS-Office, Win 98/NT