SUMMARY

• 7+ years of experience as a Data Analyst, Tableau Developer and Modeler related to Data Warehousing and ETL and Reporting environments
• Worked directly with the customer to gather requirements and served as point of contact to address customer concerns.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Adept with Tableau (Tableau server and Desktop) and Microsoft Excel & PowerPoint
• Expertise in full life cycle of Business Intelligence implementation and have understanding of all aspects of project implementation
• Produced reports and metrics that proactively identify operational and process/data issues.
• Conceptual, logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
• Proficient inData Analysis, design usingER modelingand implementingRDBMSspecific features,Normalizationto3NFandDenormalizationtechniques for optimum performance
• Extensive experience in analyzing and documenting business requirements
• Efficient inDimensional Data Modeling, Process ModelingforDataWarehouse /Data Martdesign, identifying Facts and Dimensions, creation of cubes,Star SchemaandSnowflake Schema
• 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

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:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created static reports (dashboards) in the areas of Bookings, Revenue, Forecast, Budget & Expense, Profit & Loss, Headcount and other adhoc reports for business leaders.
• 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 visualizations and dashboards using Tableau Desktop.
• 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
• Proactively evaluated business landscape and requirements and identified explicit and implicit needs.
• Identified business critical issues using GAP analysis and help the team make right choices and create business solutions for review by top management.
• 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.

Environment: Oracle 10g, SQL, MS Excel 2011, MS PowerPoint, MS Project, Tableau 8.2/8.3/9.0

Confidential, Wilmington, DE

Tableau Developer/Data Analyst

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.

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

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