SUMMARY:

• 10+ years of experience in Data Warehousing, Business Analysis, and Business Intelligence technologies along with 5 years of data visualization using Tableau.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using Tableau's Advanced Capabilities
• Excellent technical, logical and problem - solving capabilities and proficient in learning new technologies and quickly adapting to new environment.
• Strong knowledge of technical implementations and upgrades, QA processes, data migration, and change request management in deadline driven environments; advanced expertise in all facets of database management, including data mining, analysis, and reporting.
• Broad experience in Business Documentation such as: BRD’s, FRD's and other technical documents for organizational Reporting needs and other Business workflows.
• Extensive, distinguish experience in various Business Domains including (Banking, Healthcare, Data Processing and etc.) with emphasis as Business Analyst lead, Software Development Lifecycle (SDLC) process, requirements documentation, testing of software, and developing reports by using multiple BI Reporting Tools.
• Involved in troubleshooting of performance issues which were associated with Tableau reports.
• Coordinate and support business in defining and performing QA/User Acceptance Testing. Worked on SQL Queries for testing and reports/data validation.
• Comprehensive experience of report development using MicroStrategy (MSTR) SQL SSRS, Crystal Reports and Webi reports applications by developing relationship among tables describing joins, resolving loops and designing all major reports including drill down, drill through, Sub reports, linked and parameterized reports.
• Strong IT experience in the areas of analysis, design, development and testing in ETL process, Oracle, PL/ SQL and Data warehousing concepts.
• Extensive experience in creating Queries using T-SQL, PL/SQL for extracting and manipulating data based on available database tools.
• Experienced in all major databases including Oracle, SQL Server, DB2, MS Access, Sybase and Terra data.

TECHNICAL SKILLS:

OLAP and Reporting: Cognos, MicroStrategy (MSTR) 9.4 and 10.11, Inquiry Framework (IFW), Business Objects 6.x,BO XIR2/XIR 3.1,BO BI 4.0/4.1, CMC, CCM, Universe Designer (UDT/IDT), Business Object Desktop Intelligence, WEBI, Business Objects Live Office, Query as a web service, Crystal Reports 2008, 2011, 2013 and Crystal Xcelsius 2008, Tableau 9.1, 9.3

ETL Tool: Informatica, SQL SSIS

RDBMS: Clarity Database, Epic Database and Applications (Cogito), Oracle 10.2g,9i/8i, MS SQL Server 2000, 2005, 2008, 2012, 2015 MS Access, Terra Data, DB2, SAP HANA, SAP BW.

Web Technologies: C#, VB.NET, XML, HTML

Operating System: Windows 95/98/NT/2000/XP/Windows7/Linux/Unix

PROFESSIONAL EXPERIENCE:

Confidential,Tampa, FL

Enterprise Data Warehouse analyst/ BI Developer

• Gathered Business Requirements, interacted with the Internal and External Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with the Business Users, Managers and End-clients in gathering requirements to create/modify business requirement documentation for the Data Feed Files receiving from various Policies Carriers.
• Created Business Requirement Document and Functional Documents for the new Data Feeds into Prestaging and Staging tables and finally into Fact Tables for the reporting and applications.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Followed Implemented Standards for BI DW at various levels of the SDLC
• Developed, executed and documented test plans for Unit and System Integration Testing.
• Extensively used SQL Queries to validate the data in both source and target Databases
• Modified/Edited SQL codes in ETL process to accommodate Data Feed into Staging tables and Finally into Production tables.
• Involved in designing, planning, implementing and the highest level of performance and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Involved in Data Extraction from SQL Server and Flat Files using SQL Loader Designed and developed mappings using SSIS.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Heavily involved in Errors handling into SQL Server jobs failures related to ETL Packages.
• Involved in maintaining and updating the procedure for ETL process on daily basis.
• Involved in developing reports using Tableau Desktop to meet the reporting requirements
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Confidential, Tampa, FL

Sr. Business Analyst/BI Developer (Tableau Developer)

• Created Business Requirements Documents (MD050) and Functional Requirements (FRD's) for 2 major Projects of BAW Migration of CASP/CASP+ Cognos Reports in MicroStrategy (MSTR) and in Inquiry Framework (IFW) and Developing TP-RAP Server in BAW as a Direct Source for TP-RAP Reports.
• Created Tableau dashboards for business expansion on Sales growth, Claims Info and Customer services data from multiple Enterprise Data Sources
• Created Executive Dashboard sourcing heterogeneous sources extracting 15 Million records with decent performance
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports
• Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company
• Created and edited the update schedules, managed scheduled update tasks on Tableau server
• Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, 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
• Perform troubleshooting by using Oracle SQL Developer for analyzing Report's generated queries (in IFW and MicroStrategy) and issue resolution using analytical skills, and provide production support. Participate in weekly production support related calls to review support tickets. Provide timely user communications for any system related issues.
• Coordinated and supported business in defining and performing QA/User Acceptance Testing and worked on SQL Queries for testing CASP/CASP+ related reports/data validation, and debug and tweak the SQL Codes if necessary to run the reports successfully.
• Assisted and coordinated TPU Team during the whole process of migration of CASP/CASP+ Cognos reports in BAW Data warehouse (Reporting in IFW and MSTR)
• Lead and complete POCs of different analytical tools and other emerging technologies in Business Intelligence domain.
• Coordinated with department leadership and Business Users to collect comprehensive requirements for BAW Workflow (1- Migration of CASP/CASP+ Cognos Reports in MSTR and IFW, 2- Developing TP-RAP Server in BAW as a Direct Source for TP-RAP Reports thru BAW.)
• Assist with reports migration from one reporting platform to another (From Cognos to IFW and MSTR)
• Created Comprehensive Test Scripts for testing internally in both environments (UAT and PROD) for both projects Migration of Cognos Reports in MicroStrategy (MSTR) and in Inquiry Framework (IFW) and Developing TP-RAP Server in BAW As a Direct Source for TP-RAP Reports.
• Perform comprehensive and detailed testing thru HP-ALM Application Life Cycle Management Tool in (UAT and PROD environments) for newly developed reports in Inquiry Framework (IFW) and MicroStrategy (MSTR) to validate the existence of reports as per business defined requirements and functionalities and provided Sign-Off for Production Migration.
• Developed more than 100 Ad hoc reports as per Business Users requirements in MSTR by utilizing various report development features including Free Hand SQL functionality to create cubes and on top those cubes created Complex Reports and Documents.
• Performed the detailed testing thru HP-ALM Application Life Cycle Management Tool in (UAT and PROD environments) for all the contents/objects in MSTR including All the available Projects, Folders and reports during the upgrading of MicroStrategy (MSTR) from version 9.4 to 10.11 in (UAT and PROD) and provided the sign-off to Dev Team.

Confidential

Sr. Business Analyst/BI Consultant (Tableau Developer

• Coordinated with department leadership to collect comprehensive requirements for clinical workflow (Integrated with EPIC from Allscripts)
• Created Inpatients and Outpatients based reports for internal and external clients
• Provided End-to-End Reporting solutions by using various BI Tools Including SAP Business Objects, Crystal Reports, Tableau and SQL Server tools.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, mappings and workflows to meet business requirements.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Created Custom Hierarchies to meet Business requirement in Tableau
• Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped.
• Worked on the backend SSAS cube development which was the source data for the Tableau.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Develop, organize, manage, and maintain graphs, tables, and document templates for the efficient creation of reports.
• Designing and Developing the ETL Architecture and restructuring the reporting layer.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created Filter and URL actions to navigate from the Executive Dashboard to the Detail Report and implemented the back button logic to navigate back to the
• 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 directly with internal and external clients to get fully understanding of their reporting needs in terms of what Data Fields they need in their reports and what analytical aspects they need within the reports.
• Scheduled and provided support for scheduled reports using Business Objects BI Launch Pad.
• Used Epic tools such as Record Viewer, Column Search and Clarity Data Dictionary, to assist with creation of custom reports
• Mostly worked on on-demand reports as well as Scheduled reports (Automated Reports).
• Created reports by writing SQL Codes against EPIC Clarity database using MS SQL 2012 Management Studio
• Created Webi reports and automated them according to end-users needs.
• Developed custom reports against EPIC Clarity Database using SQL stored procedures and Crystal Reports.
• Created comprehensive documentation (BRD, Functional and other technical documents) for the implementation of new Applications in the system.
• Created Test Cases to validate the Data (Epic Clarity); validated with development team and end users.
• Coordinate and support business in defining and performing QA/User Acceptance Testing. Worked on SQL Queries for testing and report/data validation.

Confidential, Portland, OR

Business Analyst/Business Objects/Tableau Consultant

• Worked directly with internal and external clients to gather requirements.
• Created Business Requirement Document and Functional Documents for all reporting and application.
• Developed interactive Tableau visualizations after gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Created Business Requirement Document and Functional Documents for all reporting and application.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Utilized performance tuning procedures to increase performance and help make dashboard more visually appealing and user friendly.
• Implemented data blending and joins to work with data from multiple databases in a single report.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Validated Epic-Crystal Reports and modified as per Business requirements and needs for OHSU University and Hospital.
• Interacted directly with the business users in gathering requirements Optimize various SQL queries to make the reports run faster
• Worked on various existing reports to track and fix bugs on the report as well as server level.

  Created new reports and owned entire creating process including requirement gathering, documentation, report designing and UAT.

• Designed and deployed various SSRS reports displayed in tables, sub-reports, Matrices, Pie charts, etc using functionalities of drill-through, drill-down, cascading parameters, and numerous functionalities to visually and technically satisfy a very diverse audience.
• Used SQL extensively in command objects of Crystal reports
• Migrated reports from Dev to Production
• Provided on call support after reports are deployed to production
• Exported reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Used prompts, alerts, drill down analysis as per the end user requirements
• Created nested, conditional subgroups and formatting features in reports
• Created Sub reports called from the main report to implement the business logic
• Created various database objects like Tables, Views and Stored Procedures by using Toad
• Responsible for defects raised during testing of the reports
• Worked on existing reports to optimize and troubleshoot problems that occurred due to new business requirements

Confidential (Sacramento, CA)

Business Objects/Tableau Consultant

• Acted as key developer, leading a team of three (all remote) developers in the creation of Tableau Dashboards, WEBI reports and universes.
• Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, and logical calculations to create groups.
• Utilized performance tuning procedures to increase performance and help make dashboard more visually appealing and user friendly
• Implemented data blending and joins to work with data from multiple databases in a single report
• Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Published Tableau workbooks (.TWB) and Data Extract (.TDE) from Tableau Desktop to Tableau Server.
• Analyzed the warehouse Tables to design Universes by creating Classes and Objects.
• Designed the multiple Universe, Classes, Sub Classes etc. created Contexts and Aliases for resolving Loops in the Universes.
• Created Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulas.
• Created templates for standardizing the structure of corporate documents.
• Worked on major functionalities like Breaks, Filters, Sorts, Query prompt and Drill filters.
• Worked closely with the Data Architect Team to ensure the implementation of Business Logic/Rules in the ETL Process.
• Scheduled and monitored reports as per business requirements.
• Designed the End user training materials and practice Exercises.
• Created Interactive Dashboards by using the functionalities of Query as a Web Service (QAAWS) and Live Office.
• Built Sub Reports, Drill through, Crosstab and OLAP Reports by using Crystal Reports.
• Analyzed the reports using Slice and Dice and Drill down features.
• Performed data validation by applying PL/SQL Queries.
• Created different types of reports like Master/Detailed, Crosstab and Charts.

Confidential, New Jersey

Business Intelligence Analyst/Consultant

• Lead the whole process of data migration from old BO XIR3.1 version to 4.0 version also worked as BO Admin for creating groups/users/folders and files and set credentials.
• Created data mapping documents to load data from XML Files to SQL Tables then load them in BO Repository for Universe and Report creation.
• Designed and customized documents based on Data Extraction from Data warehouse and other multiple data sources.
• Involved in full Business lifecycle design and development of Business Objects reporting Applications.
• Installation of Business Objects and Repository creation.
• Extensively involved in Administrative Tasks to Create/Remove folders and related users and their rights to access folders and reports by using CMC application.
• Performed the task of tuning up performance of available server services within BO repository.
• Fully involved with Business users and end users for designing and developing various Business Universes by defining Classes, Objects and linking tables by setting appropriate Cardinalities, and resolving loop problems by defining Aliases and Contexts.
• Created Star Schema model of the Data Warehouse in BO Universe consisting of fact table and multiple dimension tables.
• Developed the Custom Hierarchy at the Universe designing and developing level for the Business Users facilitation for drilling purposes at Report level.
• Performed server management tasks by using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Created Drill down, Sub-reports, Parameterized and Summary reports in Crystal Reports using Groups, Sorting, and Parameters.
• Extensively used Alerts, Variables, Prompts, and also generated hyperlink reports using WEBI.
• Developed various complex reports which involved use of combined queries and sub queries from multiple data provider in PL/SQL.
• Created various Cross Tab Reports and Sub Reports.
• Involved in developing both Static and Dynamic reports.

Confidential, NJ

Business Objects Developer/BO Admin

• Created WEBI/DESKI Reports involving complex queries, sub queries, unions and intersection.
• Involved in gathering, analyzing and documenting Business requirements, functional requirements and data specifications for Business Objects Universes and reports.
• Created Business Layer, Data Foundation Layer, Multi-source Universe Parameters, LOV's Securing, Managing and Deploying Universes in SAP BO 3.1.
• Used Universe Design Tool (UDT) to design and develop the Universes, Classes, Objects, Joining the tables, setting Cardinalities, creating Prompts and queries and applied Contexts and Aliases to resolve loops.
• Addressed Chasm trap and Fan trap using Multi Parse SQL.
• Defined the Hierarchies in Universe to provide the users with Drilling (Up or down) options in reports and predefined conditions to use in Business Objects.

Confidential, Atlanta, GA

BO Universe Designer/Crystal Report Developer

• Interacted with Business users and Business Analysts to understand and document the requirements and transform them into technical specifications.
• Transformed the existing Data Integration Jobs, corresponding to the changing business requirements which include Addition, Mapping and data type changes to fields.
• Designed, Developed and Maintained Universes by defining Joins, Cardinalities between tables applying Contexts and Alias tables to remove cyclic dependencies.
• Used various functions such as: @Aggregate aware, @Prompt, @Select, LOV’s, Index Awareness, Custom Hierarchies etc. in Designer.
• Gathered functional requirements and designed Technical Specifications.
• Created several Ad-hoc, Canned, On-Demand, Standard Reports using tools such as Info view, Webi Rich Client and Crystal Reports.
• Created several Webi reports, Deski reports and Dashboard reports for graphical representation.
• Created stored procedures in PL/SQL for derived tables and used them as source for BO reports.
• Implemented Data Warehousing Schemas like Star-Schema, Snow-Flake Schema.
• Formatted reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Created dashboards using Xcelsius 2008 by using Excel as a data source with Combo Box, List Box, Selectors, Alerts, Drill-down and other functionalities.