EXPERIENCE SUMMARY

• Around 8 years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of projects in Manufacturing, Retail, Pharmaceutical and Financial industries.
• Certified Business Analyst by British Computer Society (BCS).
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in Tableau 8.x/7.x/ 6.x (Desktop, Server, Public, Mobile), Micro Strategy 9.x/8.x product suite (Desktop, Intelligence Server, Narrowcast Server).
• Interacted with end - users and functional analysts to identify and develop Business Requirement Documents (BRD).
• 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.
• In depth understanding of the as-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• 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.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• 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.
• Possess strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica UNIX, DB2, Oracle and SQL Server technologies.
• Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.

TECHNICAL SKILLS

BI Tools: Tableau, Micro Strategy, Business Objects, Pentaho, SSRS

ETL Tools: Oracle ODI, Informatica, Data Stage, SSIS, SSAS

Requirements Management: Microsoft Office (Word, PowerPoint Excel)

Change Management: Lotus Notes, BMC ITSM

Front End Tools: Microsoft Project, Microsoft Office

Databases: DB2, Teradata, Oracle, SQL Server, Access

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

Defect management tool: HP Quality center 10.0

Scripting Languages: C, C++, HTML, SQL, PL/SQL and XML

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

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr. Tableau Developer/ Sr. Data Analyst

Roles and Responsibilities:

• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Developed Tableau visualizations to support ad-hoc analyses.
• Interacted with Business users in understanding their requirements.
• Generated insights out of voluminous and complex datasets and built story lines.
• Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
• Designed excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
• Interacted with business users and performed Gap Analysis of Client requirements.
• 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 based on exiting reports/dashboards.
• Worked closely with 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 advance features of Tableau software like to link 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.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Make use of filters and making them local and global accordingly.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, iPhones, and other smart mobile phones.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• 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, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau (Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project.

Confidential, Miami FL

Sr. Tableau Developer/Sr. Data Analyst

Roles and Responsibilities:

• Served as Lead 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.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Used Auto Sys 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 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.
• 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.
• 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 in Tableau, 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 Desktop(Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Auto Sys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Mc Lean, VA

Sr. Data Analyst/ BI Developer

Roles and Responsibilities:

• Interaction with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Used UML and Visio for creating Activity diagrams, Sequence Diagrams.
• Identified the objects and relationships between the objects to develop a logical model in Erwin tool.
• Used Erwin for relational database and dimensional data warehouse designs.
• Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
• Translated the logical model into physical model using Forward Engineering technique in Erwin tool for both OLAP and OLTP systems.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Worked with Master Data Management architects to develop data models.
• Writing complex queries using Teradata SQL.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL mappings in ODI.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• 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.
• Completed formal training in Tableau.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

Environment: Teradata, Oracle, PL/SQL, SQL Server 2008, MS SQL, Oracle Data Integrator,MicroStrategy, Erwin, Power Designer, DB2, Windows XP, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Detroit, MI

Informatica Developer/ Business Systems Analyst

Roles and Responsibilities:

• Served as Informatica Developer and Business Analyst, meeting deadlines and budget requirements.
• Interacted with the stakeholders by interviewing them, preparing questionnaires 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 Micro Strategy’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: Informatica, Oracle, TOAD, SQL, Share Point, TFS, Agile-Scrum, Micro Strategy, Auto Sys, UNIX, SQL Server (SSIS, SSRS), ERwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Abbott Park, IL

BI Analyst/Data Analyst

Roles and 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.
• 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.
• 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.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• 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 in deployment process.

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

Confidential, Detroit, MI

Business Analyst/ Data Analyst

Responsibilities:

• Developed complex PL/SQL, DB2 queries and handled ad-hoc data & report requests.
• Participated & held discussions with functional groups in design and analysis sessions to ensure flawless end-to-end design of the ETL processes and job flows.
• Analyzed business data requirements and functional specifications to produce relevant ETL architecture deliverables (source analysis, source to target maps, identify transformation rules and develop ETL flows).
• Co-ordinated tasks with onsite and offsite team members and translated internal and external client requests into reportable data structures.
• Resolved ETL Load failures and handled production incidents.
• Prepared and executed ETL unit test plans, unit test cases and tested solutions for resolving data issues with Data Warehouses.
• Queried data sources (OLTP) and Data Warehouse (OLAP) to conduct ad-hoc source and target analysis.
• Conducted root cause analysis on all in-scope incidents and recommended appropriate corrective action plans.
• Facilitated in troubleshooting issues post release deployment including support for Data Warehouse production projects along with solution proposals to solve complex production issues.
• Created Unix Shell scripts and Batch scripts to automate file transfers from Data Warehouse to customer file landing gateway\zone.
• Executed complex T-SQL and PL/SQL queries using SQL Server Management Studio and Advanced Query Tool (DB2) for post deployment data validation testing.
• Involved in Process improvements, Production Support& Maintenance, Performance tuning and troubleshooting of Application programs.
• Unit Testing, Integration Testing and Preparation of Test plans/results to be shared with Client
• Development and Testing of code, Interfaces and Customizations as per client requirements.
• Conducted user interviews, gathered Requirements, analyzed and translated the business requirements to system changes.
• Developed Business Requirement Document (BRD) and Use Cases Specification/Document for various Use Cases.
• Documented and deliveredFunctional Specification Document(FSD) to the project team.
• Developed and Updated User Interface Manuals, Operations Manuals, Process flows, Test Scenarios and Test Cases.
• Proposed enhancements for the maintenance of existing systems and present to the business users.
• Participated in business meetings with functional users for the migrations of mainframe applications to ERP.
• Organized workshops with production support teams and identify the system deficiencies.
• Project management, estimated the work hours for the requirements and convinced the client users.
• Developed complex SQL queries for the development of reports requested by the client.
• Lead the Off-shore technical team and track the progress of the project providing weekly updates to the client.
• Conducted System Integration testing (SIT), user acceptance testing (UAT) and trained business users on new implementations.
• Created and Maintained change requests using BMC Remedy Tool (ITSM).
• Responsible for managing the project life cycle from business proposal to UAT using SDLC methodologies.

Environment: IBM DataStage, Parallel Processing, DB2, PL/SQL, SQL Server 2008, MS SQL, BMC Remedy ITSM, MS Office Suite (Word, Excel, PowerPoint).

Confidential

ETL/Data Warehouse Developer

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse for ICICI bank.
• Responsible for extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
• Designed, developed, and tested the mappings, using Informatica 7.1
• Interacted with management to gather sources and their requirements
• Involved in the some part of performance tuning.
• Developed simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL, PL SQL, Mainframes, VSAM, MS Access, SQL Server, Microsoft Office Suite ( Word/ Excel/ PowerPoint/ Viso).