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 utilizing Tableau 9.x/8.x/7.x/ 6.x (Desktop, Server, Public, Mobile), MicroStrategy, Informatica etc.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Expertise in interaction wif end - users and functional analysts to identify and develop Business Requirement Documents (BRD) and Technical Specification documents(TSD).
• Strong understanding of project life cycle and SDLC methodologies including Agile, Waterfall, RUP and RAD.
• Experience in facilitating Joint Requirement Planning (JRP) sessions wif Business User Groups, conducting Joint Application Development (JAD) sessions wif IT Groups.
• In depth understanding of teh 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, Capturingand Communicating teh Requirements using Requirement Traceability Matrix (RTM)which halped in controlling numerous artifacts produced by teh teams across teh deliverables for a project.
• Outstanding data analysis skills including Data Profiling/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 in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Experience in configuring reports from different data sources using data blending.
• Expertise in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards wif Page and dashboard Prompts.
• 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 teh end user requirement.
• Expansive experience in preparing dashboards using calculated fields, parameters, actions, groups, sets and hierarchies in Tableau Desktop.
• Experience wifJavaScript API to customize teh views, selects, filters, date and time.
• Efficient management of Tableau Server by managing & setting permissions, publishing various data sources and workbooks to Tableau Server.
• Extensive knowledge on working wif IBM Curam software which provides health care solutions..
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, DB2, Oracle and SQL Server technologies.
• Experience in designing teh data conversion strategy, development of data mappings and teh design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Strong influence management skills, reporting and analytical/problem solving skills wif attention to detail.

TECHNICAL SKILLS

BI/ Analytics Tools: Tableau, MicroStrategy, SSRS, Business Objects

ETL Tools: Informatica, DataStage, SSIS

Operating Systems: Windows 7, XP, 2000, NT, Linux and UNIX

Scripting Languages: C++, C, HTML, UNIX Shell, Java Scripts and VC++

RDBMS: Teradata, Oracle, SQL Server, DB2 and MS-Access

SQL Tools: Toad, SQL Developer, Teradata SQL Assistant, SQL Explorer

Modeling Tools: ERwin, Power Designer, ER Studio, MS Visio

Specialty Tools: HP Quality Center, Visual Source Safe, Share Point, Documentum

Scheduling Tools: AutoSys, Control M

PROFESSIONAL EXPERIENCE

Confidential, Skokie, IL

Sr. Tableau Developer

Responsibilities:

• Interacted wif Functional/End-user's to gather requirements for teh Cloud Survey Dashboard, understanding teh user expectations, business logic.
• Used a star schema to load teh data into teh SQL server Management Studio.
• Created data mapping documents for teh worksheets to be built.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Conducted JAD sessions, interacted wif teh End users on a regular basis for resolving issues pertaining to teh reports, attending weekly status meetings.
• Used Tableau URL Actions to navigate from teh main Dashboard to detail Reports
• Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring teh Sales growth by different departments wifin teh company.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.
• Worked on domain areas including Sales & Marketing, Member, Product, Health Claims, Provider, Medical Management, Call center and Pharmacy data by using various joins and blending options in Tableau to find out teh key elements.
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for teh different cost types.
• Worked on solving performance and limit queries to teh workbooks dat when it connects to live database by using a data extract option in Tableau.
• Created and edited teh update schedules, managed scheduled update tasks on Tableau server.
• Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, and geographical maps.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Published teh developed dashboards into production and ensured teh data was up to date by scheduling extract refreshes, performed performance tuning of teh dashboard and created tableau functional design document.
• Provided tableau training on teh Survey dashboards built to teh end users.
• Extensively involved in doing user acceptance testing (UAT).

Environment: Tableau Desktop 9.0, Tableau Server, SQL Server 2014 Management Studio, SQL, T-SQL, MS Office Suite ( Word, Excel, Powerpoint).

Confidential, Chicago, IL

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Gatheird Business Requirements, Interacted wif teh Users, Project Manager and SMEs for Loyalty eligible indicator fix issue.
• Solving and halping teh users wif teh data issues in teh Customer aggregate project, Transaction aggregate.
• Coordinated wif EDW and source team to identify and fix teh Loyalty eligible indicator fix issue.
• Performed data analysis and extracted data from various tables in teh Enterprise Data Warehouse to identify teh problem wif teh existing data and prepared documentation on teh ongoing fix and data issues.
• Interacted wif end-users and functional analysts to gather and identify teh requirements for developing Advanced Customer Analytics Platform (ACAP).
• Tracking, Documenting, Capturing, Managing and Communicating teh requirements using Requirement Traceability Matrix (RTM) for ACAP which halped in controlling numerous artifacts produced by teh teams across teh deliverables.
• Conducted Joint Requirement Planning (JRP) & Joint Application Development (JAD) sessionswif Business User Groups, Project, Product manager and team to accelerate teh design of information technology solutions, planning and development of ACAP.
• Interacted wif 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 wif business power users to create reports/dashboards using tableau desktop.
• Worked wif technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction wif data layer.
• Produced accurate analysis of project datasets as defined by teh 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 teh 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 wif various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy teh 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 teh reports.
• Prepared project reports for management and assisted teh project manager in teh 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 wif key resources, stake holders and SMEs to keep everyone involved in teh project on teh same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau (Desktop/ Sever/ Reader), Teradata, SQL, PL/SQL, Teradata SQL Assistant, Teradata Administrator, DB2, Oracle, SQL Server, MS Project, MS Visio.

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 wif 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 teh business.
• Interacted wif business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and tan converted business requirements into Functional Requirements Specification.
• Worked wif teh report development Manager and other team members on report requirements based on exiting reports/dashboards.
• Worked closely wif 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 wifin Interactive Dashboards.
• Created Table of Contents (TOC), a common navigation page which had all teh links to various reports.
• Make use of filters and making them local and global accordingly.
• Publish teh developed dashboard, reports on teh Tableau Server so dat teh end users having access to teh server can view teh data.
• Scheduled frequency and time to refresh data for teh 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 teh developed product wif teh set performance standards.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting wif teh Clients.
• Created Test Cases and documented teh Test Results.
• Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled teh performance issues TEMPeffectively.
• Involved in Onsite & Offshore coordination to ensure teh completeness of Deliverables.

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

Confidential, Riverwood, IL

Tableau Developer/Sr. Data Analyst

Responsibilities:

• Served as Lead Business Systems Analyst meeting deadlines and budget requirements.
• Gatheird Business Requirements, Interacted wif teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Prepared project reports for management and assisted teh project manager in teh 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 teh required specification.
• Developing and maintaining high level overview of teh project and design flows using MS Visio.
• Used Autosys as Third Party Scheduling tool.
• Worked on Business Intelligence standardization to create database layers wif 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 teh performance of a particular state.
• Developed customized calculations when required.
• Migrated all teh reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing teh version on Sand Box.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect teh same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between teh views on teh sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing teh 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 wif 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 wif key resources, stake holders and SMEs to keep everyone involved in teh project on teh same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau Desktop(Desktop, Server), Teradata, Teradata SQL Assistant, 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 wif business to collect and understand Requirements.
• Translated teh business needs into system requirements by communicating wif teh business on non-technical level and wif teh System Analyst on technical level.
• Arranged walkthrough sessions wif teh user group and to confirm dat all teh requirements has been captured and obtained sign off on teh requirements documents.
• Identified teh key facts and dimensions necessary to support teh business requirements. Develop teh logical dimensional models.
• Used UML and Visio for creating Activity diagrams, Sequence Diagrams.
• Identified teh objects and relationships between teh 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 teh models and ensure dat conflicts in descriptions and definitions are resolved.
• Translated teh logical model into physical model using Forward Engineering technique in Erwin tool for both OLAP and OLTP systems.
• Conducted and participated in JAD sessions wif teh users, modelers, and developers for resolving issues.
• Worked wif 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 teh database from DDL scripts.
• Created documentation, worked wif users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified teh existing Dashboards using MicroStrategy Desktop.
• Completed formal training in Tableau.
• Interacted wif teh End users on a regular basis for resolving issues pertaining to teh 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 teh 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 teh completion of various difficult assignments.
• Gatheird Business Requirements, Interacted wif teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Prepared project reports for management and assisted teh project manager in teh 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 teh Logical Data Model using Compare and Merge Utility in ER/Studio and worked wif teh naming standards utility.
• Performed GAP analysis wif Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
• Worked wif 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 teh project.
• Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
• Worked on exploring teh dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering teh data etc.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Arranged walkthrough sessions wif teh user group and QA teams to confirm dat all teh requirements has been captured and obtained sign off on teh requirements documents.
• Implemented security in reports according to employee groups and roles according to teh 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 wif teh stakeholders by interviewing them, preparing questionnaires and getting feedback.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Worked wif Project team to determine technical and development impact of a project.
• Responsible for defining teh scope of teh project, gathering business requirements, doing gap analysis and documenting them textually or wifin models
• Gathering and documenting teh requirements dat are critical to teh business mission and using those requirements to design application software.
• Modeled use-case diagrams in Rational Rose to show end-user interaction wif teh 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 teh application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for teh stakeholder review.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives wif each other, resolve any issues and come to an agreement quickly.
• Performed feasibility, adaptability study and risk analysis to identifythe business critical areas from teh user perspective.
• Worked wif Source system Subject Matter Expert (SME) to ensure dat teh 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 teh design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Actively tracking schedule, clear and crisp communications wif key resources, stake holders and SMEs to keep everyone involved in teh project on teh 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 teh project dat involved development and implementation of a data warehouse.
• Responsible for extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
• Designed, developed, and tested teh mappings, using Informatica 7.1
• Interacted wif management to gather sources and their requirements
• Involved in teh 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).