SUMMARY:

• Qualified professional with 7+ years of extensive IT Experience in Data Warehousing and Business Intelligence applications in Retail, Financial, Health Care and Manufacturing industries.
• Experience in end to end designing and deploying data visualizations using Tableau 6.x/7.x/8.x/9.x (Desktop, Server).
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement
• Collaborating with stakeholders to define scope for new projects, documents risks and assumptions, develops the delivery approach, and estimates cost and timings
• Working closely with project managers and team members through all phases of the systems development lifecycle
• Collaboratively documented test criteria with requestors, developers, and QA teams .
• Take part in the functional consulting services we provide to our partners and customers.
• Analyze customers’ needs and business processes in order to map them properly with Tableau.
• Quantify resources required for a task/project.
• Accompany customers in the full delivery cycle from software configuration to go-live.
• Coach customers on how to use Tableau efficiently through individual training.
• Support the sales team during pre-sale
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Proficient Star Schema dimensional modeling, which include understanding business processes, modeling dimensions, hierarchies and facts.
• Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
• Experience in support a large number of consumers and retain large amounts of data using Apache Kafka.
• Experience in real-time processing, dashboards and offline analytics in Hadoop
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production support.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

TECHNICAL SKILLS:

BI Tools: Tableau 7/8/9.x, Micro Strategy, SSRS,OBIEE 11g,12g

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

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

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

Databases: Google big-query, Teradata, Oracle, SQL Server, DB2, Sybase, Access, apache tomcat, apache kafka

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

Defect management tool: HP Quality center 10.0

Programming Languages: C, C++, HTML, SQL, PL/SQL, XML, Python, C#

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

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Tableau Developer/Admin/Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Collaborating with stakeholders to define scope for new projects, documents risks and assumptions, develops the delivery approach, and estimates cost and timings
• Worked closely with project managers and team members through all phases of the systems development lifecycle
• Acted as translator between business and technical community interpreting user needs and translating them into more technical language for the developers (and vice-versa).
• Collaboratively documented test criteria with requestors, developers, and QA teams.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
• Used Sql Queries at the custom Sql level to pull the data in tableau desktop.
• Validated the results in Tableau by running Sql queries in Oracle Sql developer and Google Big-Query.
• Tableau security (e.g. SSO) experience
• Experience migrating or translating reports from legacy systems like MSFT SSRS, direct SQL queries to Tableau Demonstrable examples of past Tableau portfolio
• Tableau server administration tools experience Expert SQL query tuning for performance
• Experience pulling data from Hadoop through Hive on Tableau Experience working on Hadoop distributions.

Environment: Tableau desktop 8.1/8.2/9.1/9.2, tableau server 8.1/8.2/9.1, OBIEE 11g, Oracle, Google Big-Query, Informatica, Talend, Salesforce.

Confidential, Woodlands, TX

Tableau Developer/Admin/Analyst

Responsibilities:

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Collaborating with stakeholders to define scope for new projects, documents risks and assumptions, develops the delivery approach, and estimates cost and timings
• Working closely with project managers and team members through all phases of the systems development lifecycle
• Acted as translator between business and technical community interpreting user needs and translating them into more technical language for the developers
• Collaboratively documented test criteria with requestors, developers, and QA teams .
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Used Autosys as Third Party Scheduling tool.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Loading from disparate data sets. Maintain security and data privacy using Apache Hadoop.
• Worked on drill through reports by creating HTML references.
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Communicates with Development and QA teams regularly to ensure accurate understanding of requirements.
• Assists with research on software and hardware products.
• Worked closely with the technical delivery managers for overall coordination of project activities.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• 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: Tableau 7/8, Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Westbury, NY

Business Analyst/Tableau Developer/Admin

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Managing project tasks or parts of the project plan assigned within scope, quality and timeframe allocated with minimal supervision.
• Create and deliver through the full sign off process project/program documentation by working with Key Stakeholders to elicit information and gain agreement.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Document procedure and policy changes from current state model through future state impacts of project.
• Maintain and develop knowledge of project methodologies and a professional network of contacts, sharing knowledge and best practice where appropriate to support continuous improvement.
• Where role includes management of project resources, coaching, training & development and performance management of resources may be required
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
• Improved organizational and staff performance by analyzing/developing work flows, processes, and functional gaps and developing optimal solutions.
• Served as project lead during application selection and implementation, facilitating communication between and decision-making of the business and technical teams.
• Worked closely with affected business units and associated technical teams, develop and maintain appropriate documentation for application implementation, including workflow diagrams, business requirements, requirements management plans, system implementation work plans, change management documentation, and other documents as necessary.
• Manage vendor relationships, with focused effort during periods of application implementation.
• Develop systems and processes to support operational strategy.
• Compile data, analyze information, and prepare reports.
• Facilitate and document meetings.
• Communicate information in an organized and easy-to-understand manner, translating business needs to the technical team and vice versa.
• Serve as liaison between business units and technical teams to ensure that all parties of a project are working in a cohesive manner toward optimal organizational results.
• Ensure timely completion of all deliverables.
• Research issues related to assigned projects, including regulatory compliance; identify impact on the plan.
• Worked to ensure high levels of data consistency between systems.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Implemented security in reports according to employee groups and roles according to the requirement. and Involved deployment process.

Environment: MicroStrategy, Oracle, MS Access, Teradata, Informatica, TOAD, SQL Developer, PL/SQL Developer, Autosys, HP Open View, Windows 2003/XP, ERwin, and MS Office Suite ( Word, Excel, PowerPoint).

Confidential

Business Analyst/ Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Expertise in achieving cost-effective production with increased quality.
• Expert in identifying the requirements and also in finding the system requirements.
• Expertise in prepare Integration Test Plan which was used by functional team as well as development team.
• Acted as single point of contact between Project Management and appropriate IT groups from solution planning, sizing, to fulfillment.
• Persuade visual designers by understanding usability and design principles.
• Actively participated in data modeling and business modeling.
• Wide knowledge in re- engineering concept.
• Ability to make people understand and convince them.
• Ability to produce the best result in pressure situations.
• Ability to work in team as well as individual.
• Expert in various business tools as MS Office
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Documented the business process by identifying the requirements.
• Preparing excellent documentation on business requirements.
• Handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
• To make the Test plan for the testing team.
• 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.
• To do the User acceptance testing in the final project

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