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.
• 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), MicroStrategy 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 halped 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.
• Posses’ 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,, InformaticaUNIX, 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, MicroStrategy, Business Objects

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

Requirements Management: Microsoft Office (Word, PowerPoint Excel)

Change Management: Lotus Notes& Service Management

Front End Tools: Microsoft Project, Microsoft Office

Databases: Teradata, Oracle, SQL ServerAccess

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, Chicago, IL

Data Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs for Loyalty eligible indicator fix issue.
• Solving and halping the users with the data issues in the Customer aggregate project, Transaction aggregate.
• Coordinated with EDW and source team to identify and fix the Loyalty eligible indicator fix issue.
• Performed data analysis and extracted data from various tables in the Enterprise Data Warehouse to identify the problem with the existing data and prepared documentation on the ongoing fix and data issues.
• Interacted with end-users and functional analysts to gather and identify the requirements for developing Advanced Customer Analytics Platform (ACAP).
• Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM) for ACAP which halped in controlling numerous artifacts produced by the teams across the deliverables.
• Conducted Joint Requirement Planning (JRP) & Joint Application Development (JAD) sessions with Business User Groups, Project, Product manager and team to accelerate the design of information technology solutions, planning and development of ACAP.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Analyzed dimensional and fact tables in data mart dat details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Worked with technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Produced accurate analysis of project datasets as defined by the required specification.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Built compelling, interactive dashboards in Tableau dat answer key business questions.
• Created very complex Dashboards using Tableau 8.1 using the drill down, drill across, actions for business steering committee.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Worked on SQL Tuning and Optimization of the reports.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures
• 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/ Sever/ Reader), Teradata, SQL, PL/SQL, Teradata SQL Assistant, Teradata Administrator, Teradata Monitor, DB2, Oracle, SQL Server, MS Project, MS Visio, Control-M.

Confidential, Columbus, OH

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Built compelling, interactive dashboards in Tableau dat 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 dat 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 dat 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, River wood, IL

Sr. Tableau Developer/Sr. Data Analyst

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 Autosys as Third Party Scheduling tool.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata dat can be used for development of various Tableau reports/ dashboards.
• Analyzed dimensional and fact tables in data mart dat 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, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Philadelphia, PA

Sr. Data Analyst/ BI Developer

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 dat all the requirements has 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 dat 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 Informatica.
• Created Data Definitions and halp 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, Informatica Power CenterMicroStrategy, Erwin, Power Designer, DB2, Windows XP, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Austin, TX

BI Analyst/ Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Possess and applied a broad knowledge of principals, 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 dat all the requirements has 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: 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, Wilmington, DE

Informatica Developer/ Business Systems Analyst

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 dat 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 dat 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 MicroStrategy’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, MicroStrategy, Autosys, UNIX, SQL Server (SSIS, SSRS), ERwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential

ETL/Data Warehouse Developer

Responsibilities:

• Worked on the project dat involved development and implementation of a data warehouse for Confidential .
• 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/ Visio).