SUMMARY:

• 10+ Years of focused experience in the field of Information Technology. This includes pioneering work in Analytical Software Applications, Business Analysis, Requirements Gathering, Development, Testing and administration of OLAP/OLTP databases, Business Intelligence tools and client/server projects using industry accepted methodologies and procedures.
• Over 9 years of experience in business intelligence technologies such as Tableau, Oracle Hyperion BI, SAP Business objects and Cogno’ s.
• Extensively developed 1500+ reports which includes Sales Analysis, Inventory Analysis, Claims & Policy Analysis, Overall Business Performance, Full Year Budget, Actual vs Budget, Rolling forward reports, comparisons (YoY, QoQ, MoM), CapEx, Corporate Adjustments, Stress Testing, Segment/Product breakdown analysis, Top N ranking, Month end P&L’s etc. for various sectors.
• Extensive experience in creating interactive dashboards with guided techniques such as drill down capability, slicing and dicing of data and navigating to external webpage with URL’s using tableau desktop and Hyperion IR.
• Developed advanced data visualizations such as water fall chart, Pareto chart, M otion chart, Donut chart, and custom G eo coding maps .
• Expertise in creating report objects such as hierarchies, advanced filters, parameters, sets and calculation fields using Tableau Desktop.
• In depth knowledge of regression and time series analysis.
• Built aggregated views from various data sources using data blending and data joining techniques in tableau desktop.
• Experience in performing data extracts and incremental refreshes using Tableau Desktop/Tableau Server.
• Hands on experience in using Tableau server Product for publishing dashboards and workbook packages, managing user security, administration and Content Restriction.
• Expertise in performing analytics on Big Data using MapReduce, Spark, Hive and Pig.
• Extensive experience in creating hierarchies and calculations on multi dimensional databases (oracle Essbase & SAP BW).
• In depth knowledge on regression and time series analysis.
• Extensive experience in creating forecast templates for data inputs using Essbase, Smart view and Oracle cloud.
• Excellent understanding of concepts like Star - schema, Snowflake schema using fact and dimension tables in relational databases .
• Hands on experience creating reports using SAP BO (Crystal reports, webi, Xcelsius, BEx Analyzer).
• Hands on experience in ETL layer of tasks using ODI, HAL tools
• Experience in Insurance, Banking, Retail, Manufacturing, Educational and Financial Service Domains and analyzing big data.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an ability to learn new technologies.

TECHNICAL SKILLS:

Data bases: MS SQL Server 2005/2008/2012, Oracle 10g / 9.i / 8.i / 7x, DB2, PL/SQL, MS Access, Oracle Essbase, MS Access

Business Intelligence Tools: Tableau 10/9/8, Hyperion Financial Reporting Studio 9/10/11, Hyperion Interactive Reporting 7/9, Hyperion Web Analysis, Brio, Hyperion Spreadsheet Add-in, Hyperion System 11/9 Smart View, Hyperion Excel Add in 11/9/8/7, Cognos, SAP Business Objects

ETL Tools: Oracle Data Integrator (ODI), HAL

Operating Systems: Windows 95/98/2000/2008/ NT/XP, UNIX, LINUX

Languages: C, SQL, PL/SQL, HTML, XML

Domain: Insurance & Banking, Manufacturing, Healthcare, Retail

Other: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken NJ

Tableau Developer

Responsibilities:

• As a Tableau BI end to end life cycle implementation resource, involved in financial data analysis, dashboard development and administration.
• Engaged in obtaining business requirements from FP&A and CCAR team.
• Established connections and integrated data sources SAP BW & SQL Server with Tableau Desktop.
• Developed and reviewed SQL queries with use of join clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data.
• Effectively used data joining and data blending techniques to extract data from SQL server and SAP BW to create a CONSOL reporting application in tableau desktop.
• Designed tableau dashboard prototypes, presented to business users and involved with the business to sign-off and freeze out prototype designs.
• Developed and managed financial KPI dashboards featuring Current ratio, Monthly and Cumulative data, Comparison of past year and target values, Trend charts, Major key sales performance indicators etc. with advanced filters, drill down hierarchies, parameters, embedded url’s, Trend lines, conditional format and calculations.
• KPI dashboards include dual axis charts such as donut chart, water fall chart, Pareto chart, line and area charts Other charts used are stacked bar, scattered plots, customized geo spatial maps.
• Extensively created various KPI calculations such as Gross Profit Margin, Operating Expense ratio, Net Profit Margin, EBIT Margin, Current Ratio, Accounts Receivable Turnover ratio, Accounts Payable Turnover, working capital, budget variance etc. for financial planning and analysis.
• Modified existing dashboards and optimized performance for new user experience.
• Extensively created rolling forward reports for monthly and Quarterly forecasting analysis across all operating companies.
• Published developed dashboards to tableau server, managed authentication, authorization and security.
• Performed tableau extracts, scheduling and refreshes, user management (adding users and groups) and content restriction.
• Performed data analysis on daily, weekly, and monthly scheduled refreshes of data based on business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live.
• Conducted Training sessions for tableau power users and created documents for end-user support.

Environment: Tableau 8.3/8.2/8.1, Tableau Server, SAP BW, MS Access, SQL Server 2008.

Confidential, Rochester, NY

Tableau Developer\Admin

Responsibilities:

• Involved in requirements gathering, data analysis, dashboard development and administration.
• Developed interactive and dynamic dashboards and performance scorecards featuring Policy analysis, Claims analysis, Overall Business performance, Performance breakdown by Product and Region, customer analysis, Stress Testing etc.
• Effectively used dual axis technique, trend lines, images and developed advanced visualizations such as donut chart, customized geo spatial maps, line chart and scattered plot.
• Established connections between tableau and datasources (SQL and Oracle Essbase).
• Created complex reports in Tableau Desktop using Tableau Functions such as color coding, formatting, sorting, filtering(quick Filters, cascading filters, context Filters),ranking, Top-N Analysis, hierarchies etc.
• Developed KPI calculations such as Avg Time to settle a Claim, Avg cost per Claim, Return on Surplus, Loss Ratio, Severity, Expense ratio, Customer Retention, Strike rate, Avg. Policy size, Policy sales growth etc.
• Published developed dashboards to tableau server, managed authentication, authorization and security.
• Performed tableau extracts, scheduling and refreshes, user Management (Adding users and Groups), Content Restriction to users, to share content based on access level as a Tableau Content Administrator.
• Modified existing reports and dashboards to make it more dynamic and brought the number for optimal management.
• Worked with users for better understanding of their reporting and dash board needs and presented solutions using structured Waterfall and Agile project methodology approach.
• Created Cross tab reports to display underlying data based on various graphs and charts for further data analysis.
• Involved with business to sign off the dashboard prototypes/mock ups and freeze out the report format to facilitate the project to move in a right direction.
• Closely worked in the peer reviews for the final dashboards for impact analysis and gap analysis as per the requirements.
• Resolved performance issues and worked for better scalability and availability of Tableau server.
• Performed data analysis on daily, weekly, and monthly scheduled refreshes to ensure developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups
• Assisted Project Manager in documenting the progress of the project and any possible road blocks.
• Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved.

Environment: Tableau Desktop 9.0, 8.1.6, 8.2.2, Oracle Essbase, SQL, SQL Server, MS Visio, MS Access, MS Excel

Confidential, Pittsburgh, PA

Sr. Tableau/Hyperion Developer

Responsibilities:

• Gathering requirements from various stake holders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Understanding and translation of existing Hyperion reports to convert them as Tableau reports and dashboards.
• Created and tested connections to Hyperion Essbase and extracted multidimensional databases in to tableau desktop.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo coding.
• Created various report\dashboard functions such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analyses Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
• Performed data\business predictive findings, for trending, for finding the pattern of data over the period of time.
• Involved in creating mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.
• Involved in creating the report mock ups, proto types for the end dashboards and interacting with stakeholders for report change request and sign - off on the requirements.
• Involved in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
• Implemented various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Published developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access.
• Liaison between various cross functional departments, stake holders and business end users for the reports, dashboards clarifications, development, Usage of reports and end user tableau reports training.

Environment: Tableau Desktop 7.0.1, 7.0.18, 6.0, SSRS, MS SQL Server, Oracle Hyperion Essbase, MS Excel, Essbase Addin.

Confidential, Financial District, NYC

Hyperion Report Developer

• Planning Objects Recertification
• Dimension loads and Data Loads Automation
• Wine Operations cube Development
• Upgrade Project (11.1.3.3 to 11.1.2.2

Confidential

Responsibilities:

• Assisted in developing new hierarchy structures for Accounts, Business units, product and customer dimensions according to single global instance (SGI) Requirements.
• Involved in developing methodology to create and automate dimension loads and data loads using Oracle data integrator (ODI).
• Worked on ODI Migrations from development to production environment.
• Prepared catalogs for all Hyperion planning objects such as Financial Reports, Books, Batches, Snap shot reports, Snapshot books, Excel retrieves, Web forms, Business rules and Calc Scripts.
• Involved in gathering requirements for recertifying existing reports.
• Extensively worked on recreating more than 700 Financial reportsSuch as Daily Sales, Key brand performance, Month end P&L’s, Annual Plan Brand P&L’s, Forecast Brand P&L’s, Joint Venture reports, Cash flow performance, Balance sheet consolidated, Top 10 Declining customer reports for more than 5 Operating companies using Hyperion Financial Reporting Studio, Hyperion Interactive Reporting studio and Hyperion Web Analysis.
• Brought down 700 financial reporting objects to 250 financial reporting objects by creating Row/Column templates and utilizing batch bursting techniques.
• Scheduled and maintained more than 100 batches for emailing financial reports to end users by utilizing batch bursting options in Hyperion Workspace.
• Involved in daily monitoring of batches and troubleshooting reporting issues
• Successfully lead FPAR team in creating and managing Hyperion Financial Reports using various Hyperion reporting tools.
• Provided end user training and documentation on using financial reports in Hyperion workspace and also provided documentation to team on various financial reporting related issues.
• Recreated more than 40 web forms which include both composite and standard types with smart lists, cell text, supporting details, grid spread and mass allocate options.
• Developed more than 20 excel retrieves for business users to fetch/refresh budget and Forecast data using Excel Add in and Smart view by utilizing various options such as VLOOK up’s, Trim function etc.
• Worked on creating more than 50 business rules such as Outline consolidations, Currency Conversions, Allocations, Eliminations, Promote rules, Data copy rules, clear general rules, Sub Aggregation and Aggregation rules.
• Done migrations and retro migrations of various applications planning objects and business rules between various environments using both Life Cycle Management (LCM) and Import and Export option.
• Created Member formulas and MDX formulas on BSO & ASO cubes for scenario and time period calculations
• Administered security, user creation with Native and External authentication, Filters, dimensional level security, Groups.
• Created filters on subdivision of various cubes to grant appropriate access according to users jobs and responsibilities
• Optimized various multidimensional Essbase Cubes by tuning Cache settings (Index cache, Data cache, calculator cache) to balance the calculation & retrieval performance.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Financial Management (HFM) 11.1.1.3, Essbase 11 Excel Add in, Smart View, Oracle Data Integrator (ODI) 10.1.3, Financial reporting 11.1.1.3, Web Analysis 11.1.1.3, Interactive Reporting 11.1.1.3, Cognos, DRM 11.1.1.3, Windows XP, Microsoft SQL Server 2005, Oracle 10g.

Confidential:

Responsibilities:

• Participated in gathering functional requirements, designing reporting solution document, and implementing OPS Cube.
• Designed & developed Rule files for loading Actual data
• Developed various calculation scripts such as Outline Consolidations, Aggregations and variance calculations.
• Automated loading data and calculation scripts using MaxL.
• Worked on creating user groups and filters for winery operations team.
• Extensively worked on creating over 30 financial reports such as Winery Operations Summary reports, Department spending reports, Winery Operations Expense reports, Safety and Volume reports, Cost Comparison reports using Hyperion financial reporting studio and Hyperion Interactive Reporting Studio.
• Developed Budget and Forecast Excel templates for Operations group to fetch or refresh data using Hyperion Smart View and Excel Add in.
• Created batches using windows batch scheduler in Hyperion workspace to email out canned reports periodically to Winery operations group.
• Involved in daily monitoring of winery operations batches and troubleshooting reporting issues.

Environment: Hyperion Essbase 11.1.1.3, Essbase Excel Add in 11.1.1.3, Hyperion Smart View 11.1.1.3, Hyperion Financial Reporting Studio 11.1.1.3 and Hyperion Work Space 11.1.1.3, Windows 7.

Confidential 

Responsibilities:

• Involved in Installation and configuration of Oracle Hyperion 11.1.2.2 Components: Foundation Services, Hyperion Essbase, Hyperion planning, Hyperion Financial management, Financial Reporting Studio, FDM, FCM, Hyperion Strategic Finance, Reporting and Analysis framework, EAS.
• Involved in Migration of all Hyperion planning and Hyperion Essbase Applications.
• Performed Migration of all planning and Essbase objects such as financial reports, Web forms, Calc scripts, Rule files and report scripts using import and export method from 11.1.1.3 to 11.1.2.2.
• Deployed all business rules into calc manager
• Extensively involved in testing all Financial reports, web forms and Business rules in new environment
• Performed data validations between 11.1.3.3 and 11.1.2.2 applications.
• Involved in daily monitoring of 11.1.2.2 batches and troubleshooting reporting issues.

Environment: Hyperion Essbase 11.1.1.3/11.1.2.2, Hyperion Planning 11.1.1.3/11.1.2.2, Hyperion Financial Management (HFM) 11.1.1.3/11.1.2.2, Hyperion DRM 11.1.1.3/ 11.1.2.2, Essbase Excel Add in 11.1.1.3/11.1.2.2, Hyperion Smart View 11.1.1.3/11.1.2.2, Hyperion Financial Reporting Studio 11.1.1.3/11.1.2.2, Hyperion Web Analysis 11.1.1.3/11.1.2.2, Hyperion Interactive reporting 11.1.1.3/11.1.2.2 and Hyperion Foundation Services 11.1.1.3/11.1.2.2, SQL Server 2005, Oracle 10g, ODI 10.1.3/11.1.1.6, Windows 7, SAP BW.

Confidential, Kansas City, MO

Intern Hyperion Essbase/Planning Developer

Responsibilities:

• Involved in the Implementation of Hyperion system 9 components: Shared Services, Workspace, Smart view), Essbase, Planning, Web Analysis, FR studio.
• Participated in functional requirements gathering, designing, and implementing of various multidimensional cubes
• Prepared the Technical Design Document from the Functional Specification Document
• Designed & developed the Essbase CUBES (ASO and BSO) dynamically using Rule Files .
• Developed Rule Files to the load actual data
• Assisted in designing various calculation scripts such as Outline Consolidations, Currency Conversions, variance calculations, Eliminations and Allocations
• Assisted in Optimization of various multidimensional Essbase Cubes by tuning Cache settings (Index cache, Data cache, calculator cache) to balance the calculation & retrieval performance.
• Worked on restructuring the database outlines to get the best performance of the Essbase Server.
• Involved in automation of loading data, calculation scripts and Backups using MaxL.
• Involved in scheduling the entire process using windows batch scheduler in Development environment.
• Developed Excel Templates for Business user communities to Lock & Send the Budget and Forecast data
• Participated in testing, debugging and documentation.
• Worked on building dimension dynamically by using free-form data source and Excel.
• Created Rule files to manipulate the data source according to the database outline.
• Involved in the Planning Life Cycle process.
• Designed Applications such as Revenue, consol and analysis also called Financial Planning and Analysis (FPA) using Classic Planning and also EPMA.
• Created and managed various web forms with smart lists, cell text, supporting documents, grid spread and mass allocate options.
• Created and maintained Essbase databases using planning application.
• Involved in the Budget Process and created various Task Lists.
• Used Hyperion financial Reporting to create and modify more than 40 financial reports.
• Provided facility to the end user to perform Web analysis like slicing/Dicing and Drill down/up in order to let the end user view data from various business angles.
• Administering security, user creation with Native and External authentication, Filters, dimensional level security, Groups.
• Created filters on subdivision of various cubes to grant appropriate access according to users jobs and responsibilities
• Worked on Excel Add-in Tools to generate various reports for analyzing the business.
• Configured OBIEE for Hyperion Essbase database.

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion financial Reporting Studio 9.3.1, Essbase Excel Add in, Smart View, Windows 2003, Microsoft SQL Server 2005.