SUMMARY:

• Dynamic & results - focused industry professional with 12years (Insurance & Manufacturing) progressive experience in leading Data Analytics and Reporting hands on experience in Credit Rating, Mortgage Insurance, Manufacturing domains. To Secure Business Intelligence SME position with an opportunity where my creativity and the ability to take on new challenges can be utilized.
• 12 + Years of rich experience in creating enterprise reporting dashboards using Business Intelligence Tools.
• Experienced in Reporting Architecture, Install and configure of each component.
• 7+ Years of experience in Tableau reports development and support.
• 3+ years of experience in Building reporting enterprise using PowerBI, Domo software.
• Work experience in Agile Project execution as Scrum master role.
• Proven ability to deliver reports in Agile Sprints for quick feedback and updates.
• Always available for any technical queries and mentoring team members.
• Played BA roles in conducting Ideation workshops, quick dashboard demo’s for requirement gathering and capturing the requirements in BRD, BFSD.
• Handled 160+ service requests using KANBAN Board with high customer satisfaction.
• Successfully Project take over from vendors and completed 7 software upgrades.
• SME for company Business Intelligence/visualizations Implementations.
• Expert in Business Intelligence tools like Brio, OBIEE, Power BI, Excel, SAP BO, and DOMO Software.
• Experience in connecting to Social Media data using web data connectors for Sentimental analytics.
• Experienced in working on Data Warehouse building (DW), Dimensional Modeling Star Schema and Snowflake Schema using ETL tools and writing Custom SQL’s.
• Expert in reducing reports, dashboards execution using Performance Tuning techniques.
• Installing Tableau Reporting Servers and running TabCMD/TabAdmin Commands.
• Expert in reports deployment, movement, scheduling, monitoring in Tableau Server.
• Created Published data sources and implemented self-servicing capabilities in Tableau services.
• Implemented Tableau visualization best practices and coding standards for projects.
• Completed successfully reporting migration from Cognos, Hyperion, SSRS to OBIEE/Tableau.
• Work experience in loading data from source to target using ETL Tool SSIS.
• Experience in preparing Technical architecture diagrams and project presentations.
• Worked on Production support and adhoc reporting projects.
• Provided Trainings on Tableau, DOMO Software and Agile Scrum Implementation.
• Excellent presentation and documents management skills using MS Office Suite.
• Managers pet for Project Management activities like WSR, Leave approvals, Project Metrics Preparation and monitoring team in manager’s absence.
• Working with TFS, Jira for Sprint Activities and Version Control.
• Played Business Analyst roles in preparing BFSD, Defect Triage and Product Demo’s.
• Excellent communication skills with very good customer/Team handling capabilities.
• Experienced in Conducting Fun Friday and games for team building activities.
• Extremely dedicated, self-motivated, Committed and willing to assume responsibility

TECHNICAL SKILLS:

Visualization Tools: MS Excel, Tableau 2018, Power BI, DOMO.

Reporting: Hyperion Interactive Reporting10, SSRS,OBIEE11G,SAP BO 4.0

ETL: SSIS

Database/RDBMS: Oracle, DB2, MS SQL Server

Office Software: Microsoft Office

MultiDimensional Tools: Hyperion Essbase 8, SSAS

Operating System: Windows, Windows Server 2008

PROFESSIONAL EXPERIENCE:

Confidential, Andover,MA

BI Technical/Project Lead/Business Analyst

Environment: Tableau Desktop, Server 2018.1,Informatica

Responsibilities:

• Technical Design and architecture for Tableau development and Support.
• Planning and execution for Installation and upgrade of Tableau Desktop and server.
• Preparing dashboard mockups and documenting the reporting requirements in BFSD.
• Tableau Reports development estimations, development in iterative sprints and deployed reports on agreed timeline.
• Coaching and guiding team members in Agile Scrum and Tableau implementation.
• Preparing Clarification points and setup meeting with clients in closing questions on time.
• Closing the technical debts, Support tickets in KANBAN Model with in timeline.
• Daily monitoring teamwork progress and resolved any impediments.
• Prepared Published, Extract, live data source and established Tableau Self servicing capabilities.
• Standardized Tableau Development activities by Coding, Formatting standards, Design and deployment documents.
• SME for BI Reporting POC work, Planning and implementations.
• Lead Technical Code review and weekly technical talk discussions.
• Working with Tableau extract for large dataset and implemented RLS using data blending and cross database joins concepts.
• Building Tableau text tables and Visuals like Combined Bar, BarINBAR, Pie, Donut, Dual axis, combined axis, Tree map, Line &Trends with Rolling Avg, Heat maps, Funnel, Butterfly, Lollipop, Waterfall, Bubble Charts in Dashboards based on business needs.
• Quickly captured KPI Indicators for business operations and helped Business owners in decision making with less turnaround time.
• Implemented the Quick Filters, Hierarchy, sets, Quick Filters, Table calculations and LOD Expressions.
• Expert in implementing the date calculations like YTD, PYTD, QTD, MTD and excel based functions.
• Utilized Tableau Table calculation and Level of Detail calculations.
• Every challenging visual, calculations have converted in quick meaningful Tableau Dashboard.
• Used Actions, Parameters, Filters, Legends techniques for achieving full interactivity and user-friendly User Interface.
• Worked on Row level security Implementation using Tableau User functions and external table concept.
• Worked on integrating Tableau reports in share point and company website.
• Expert in report deployment to Dev/Qual/Prod environments.
• Expert in using TabAdmin and TabCMD commands for Tableau admin work like adding Groups, Users, Sites and starting and stopping services etc.
• Extracted Social media data using Web data connectors for implementing Marketing Analytics.
• Working knowledge on creating R code for Sentimental Analytics.
• Daily/Weekly Tableau Extract Status Tracking and client notification.
• Expert in resolving Tableau to Database connectivity, Server admin issues.
• Tableau Server Management and Production supports Tickets handling.
• Expert in connecting to Face book, Twitter (Sentimental Analysis), Google Analytics, SQL Server, ODBC, Flat files.
• Data cleaning and data loading using ETL Magic Transformations.
• Worked on implementing Row Level Security using PDP, Cross database join using Data Fusion functionality.
• Writing Complex SQL statements for data analysis and data set preparation.
• Worked on workbench for publishing RDBMS files to Domo.
• Built Dashboard based on Google Analytics data.
• Designed Dashboard Pages for Sales, Inventory, and Purchasing, Service and Quality Teams.
• Expert in Business Analysis and designing Hero cards for summary view.
• Created Pivot tables using Sumo Tables.
• Expert in creating Cards and meaningful data visualizations.
• Recommended best visuals for clients and trained them for self-servicing.
• Built visuals like Single Bar, Stacked Bar, Side By Side Bar, Pie, Donut, Line, Dual Chart, Scatter Plot, KPI, Area, Geographic Maps using Analyzer.
• Expert in applying Color Coding, Sizing, using Chart properties.
• Designed dashboards with Interactivity using Tooltip and Card, Page level filters.
• Created Custom Calculations using Beast Mode.
• Built Slide shows for product demos.
• Experienced in assigning, adding, sharing the Pages/Dashboards with Business Users.
• Embedded Domo cards in Corporate Website pages.
• As an admin was responsible for adding Users, Groups and applying the SSO.
• Expert in applying security using PDP (Personalized Data Permissions)
• Monitoring the Datasets and resolving any connectivity issues.
• Preparing daily, weekly, monthly usage metrics reports.

Confidential, Philadelphia, PA

Sr. Consultant

Environment: Tableau,MS Office,Power BI

Responsibilities:

• Was able to quickly capture requirements Using Ideation work shop techniques.
• Worked with UI Developer in understanding the Visualization Integration to Corp Dashboards.
• Creating DB views and writing Custom SQL for Tableau Reports.
• Worked on extracting data from various data source and integrating them to Tableau Dashboards using the Data Blending.
• Worked on Tableau Sets, Groups and Table Calculations.
• Created visuals like Bar, Trendline, Geographic Maps, Donut, Tree map, Bubble charts.
• Implemented dynamic filters, hiding of visuals using Tableau Parameters.
• Created Interactive Dashboards using the filters, parameters, Actions.
• Worked on Date calculations for YTD, MTD,QTD analysis.
• Integrated the Tableau Viz in Company Web Portal.
• Helped user by correcting the user custom reports and Training Assistance.
• Tableau Server Install, Upgrade, Maintainance and Production support activities.
• Installing and configuring LDAP, SSO in Tableau server.
• Created report schedules, data connections, projects, groups in Tableau server.
• Used TabAdmin and Tabcmd for Tableau server administration activities.
• Scheduling and Monitoring the Tableau Subscriptions/data extracts.
• Build Visualization/Dashboards using Power BI Desktop.
• Working on Server upload and providing access to Users.
• Helped Business Users in understanding the Visualizations using Simple Read and try Training Material.

Confidential, NYC,NW

Sr. Consultant

Environment: Tableau 9,SSIS,SSRS,SSAS,Cognos

Responsibilities:

• Worked with Business Analyst in understanding the requirement and Business.
• Working with TFS for Sprint Tracking and Version Control.
• Creating DB views and Custom SQL for Tableau Reports.
• Worked on Performance Tuning for Custom SQL and Tableau dashboards.
• Combined the data sources by joining multiple tables and using data blending.
• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.
• Performed performance tuning on visualizations which designed.
• Used Trend Lines, Reference lines and statistical techniques to describe data.
• Used groups, bins, hierarchies, sorts, sets and filters to create focused and effective visualizations.
• Representing data using the Cross tabs, Scatter plots, Geographic maps, Pie charts, Bar charts, Heat maps, Tree maps etc.
• Used parameters and input controls to give users control over certain values.
• Build complex calculations to manipulate the data.
• Created Interactive Dashboards using the Dashboard Actions.
• Helped user by correcting the user custom reports and Training Assistance.
• Performed Unit testing of the reports.
• Worked on TabAdmin for Server Start, Stop, report backup and restore.
• Worked on Tableau dashboard Migration from Dev to QA and QA to PROD server using TABADMIN
• Created report schedules, data connections, projects, groups in Tableau server.
• Scheduling and Monitoring the Tableau Subscriptions.

Confidential

Sr. Consultant

Environment: Hyperion Interactive Reporting 9.3,OBIEE 11G

Responsibilities:

• Worked with Business Analyst in understanding the requirement and Business.
• Installed and configured of the Hyperion IR Desktop (Brio) and Server.
• Project planning and process standardization for Brio reports migration from version 8.3 to 9.3.
• Provided technical training on using the IR desktop.
• Created new OCE for connecting to Database.
• Developed various kinds of Interactive Reports by using Hyperion IR Studio.
• Involved in Java scripting for report development.
• Converted SQL queries in to Hyperion Reports (Adhoc Querying).
• Unit Testing the reports and writing the test case for covering the all the scenarios.
• Setup and Scheduling of Hyperion Interactive Reporting Jobs in Workspace.
• Hyperion Workspace Administration and Production Support Activities.
• Prepared the project plan for reporting migration from OBIEE to Tableau.
• Built Viz based on Excel based Templates.
• Unit Testing the reports and writing the test case for covering the all the scenarios.
• Administration and Production Support Activities for Tableau Visualizations.
• Installed and Configured the OBIEE on Windows Environment.
• Working experience on IR to OBIEE Conversion using Translation Workbench.
• Build the Semantic Layer based on Corporate Data Warehouse.
• Developing the Answers and Dashboards in OBIEE Analytics.
• Working on SSIS package for data migration from Brio to OBIEE.

Confidential

Sr. Software Engineer

Environment: Hyperion Interactive Reporting 9.3,Abinitio

Responsibilities:

• Visited Client Place for Gathering Requirement and prepared Requirement Documents.
• Worked with Business Analyst in understanding the requirement and Business.
• Installed and configured the Hyperion Interactive Reporting Client.
• Created new OCE for connecting to Database.
• Developed various kinds of Interactive Reports by using Hyperion IR Studio.
• Worked on Excel Macros for fulfilling the Formatting Requirements.
• Involved in Java scripting for report development.
• Converted SQL queries in to Hyperion Reports (Adhoc Querying).
• Unit Testing the reports and writing the test case for covering the all the scenarios.
• Setup and Scheduling of Hyperion Interactive Reporting Jobs in Workspace.
• Worked on various Defect and Service Request related to project.
• Keep updating the client on Hyperion IR Reports Job Status by preparing Daily Job Status report.
• Hyperion Workspace Administration and Production Support Activities.
• Involved in the weekly Status call with client for discussing on the current project status.

Confidential

Software Engineer

Environment: Hyperion ESSBase,Brio,Excel

Responsibilities:

• Involved in requirement gathering and designing Hyperion Essbase Cube.
• Created applications and databases, modifying the outlines manually (Add new members and modify existing members) as per the business requirement.
• Data loading using Rules file as well as Spread Sheet.
• Created groups and users.
• Created Filters and assign them to groups to restrict users to view data.
• Involved in issues solving like Hyperion Essbase Excel Add-In client installation,
• Involved in Creation of Report Scripts.
• Data cross checking using Excel Add-in and Brio reporting.
• Developed and testing SQL code.
• Developed and testing of Interactive Brio Reports/Excel Dashboards.
• Monitored full load and incremental load processes.