Professional Summary:

• 9 years of IT-Software experience in the field of Finance IT Business Intelligence Reporting Applications and Enterprise Data warehousing.
• 8 years of Techno functional Experience in the Development, Design, Analysis, Test, Implementation and Upgrade of various Financial applications using OLAP and ETL tools like OBIEE 10g/11g, Hyperion System 9/11 FPM/EPM Suite, Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Planning 11.x/9.x/4.x, Hyperion Financial Management 11.x/9.x HFM , Financial Data Management FDM , DRM, SmartView, Essbase Excel Addin, Web Analyzer, and Business Objects XI Rx Reporting tool and Informatica Power Center using with ORACLE 10g/11, TERADATA Databases on Windows 7/XP, Pentahoe Kettle, TALEND Open Studio for Data Integration using SQLServer2012, Informix Db and UNIX Operating Systems.
• 3 years of Expertise as Production Support/Maintenance Engineer/Lead for IT Finance BI Reporting Apps, Finance Data Marts and Data Extraction System Applications at Cisco Systems Inc., San Jose, CA, USA.
• 5 years of Expertise as Business Intelligence Lead and Developer.
• 7 yrs. of Team Lead Experience working on various BI OLAP and ETL tools, managing and grooming the team in End End IT and Software Life cycle process.
• 7 yrs. of excellent experience working on the Financial Management and Reporting processes with multiple cross functional teams and financial business Analysts.
• 6 yrs. of Onsite/Client site Project Lead work experience in USA as a Business Intelligence consultant/Developer.
• 3 yrs. of Hyperion Admin Experience working on various Financial Modules.
• Experienced as IT-Business/Systems Analyst in the field of Finance DWBI at Western Union, Denver, CO, USA.
• Experienced as Project Lead managing the multiple teams having BI solutions at Western Union, Denver, CO, USA.
• Good Knowledge and Experience using Project Tracking tools like CA Clarity, RALLY , ALLIANCE REMEDY and HPSM
• Experienced as a BI and ETL developer for Contact Center Call Center Analytics.
• Very good knowledge and understanding of Cisco Systems Unified Contact Call Center/Enterprise domain.
• Expertise working on Data Quality and Profiling, TOAD analyzer for Data Analysis.
• Expertise working/using of Remedy Ticketing and case management tool for Production Systems Issues trouble shooting analysis and Resolution.
• Expertise in working with Application Systems End customers and providing excellent Customer Support.
• Expertise in Designing and Developing Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models Meta-Outlines across Block Storage BSO and Aggregate Storage ASO Cubes.
• 6 yrs of Expertise in Designing, Developing and Implementing ETL and Data Model solutions for Enterprise Data Warehouse and Business Intelligence.
• Proficient in Performance Tuning /Query Tuning of OLAP Hyperion/BO , ETL Informatica/TALEND tools and Databases Oracle PLSQL/ SQLServer/Teradata .
• Expertise in using Business Objects Enterprise Products Supervisor, Universe Designer, Desktop Intelligence, Web Intelligence, Rich Client, Info View, CMS, CMC CCM .
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models in order to meet DSS Business reporting needs.
• Hands on experience in Designing and Developing Universe, Business Objects Enterprise administration and thorough knowledge on Business Objects Enterprise Architecture.
• Excellent data-analysis skills and ability to translate specifications into a working Multidimensional Cubes, Universes, ETL, Data Model, Reports and Dashboards.
• Exposure to Dimensional Data modeling- Star Schema modeling and Snowflake modeling, FACT and Dimension Tables, Multidimensional modeling, Physical Logical data modeling, Normalization and DE normalization techniques.
• Good at Defining the long term strategy and direction for the Oracle Hyperion/BO/Informatica/TALEND Reporting Roadmap working with other members of the Enterprise Performance Management Center of Excellence team and the Cisco Enterprise Architects.
• Expertise in Automation of data and metadata loads using Dollar Universe batch scheduler and unix shell scripting.
• Expertise in developing Hyperion Reports using Essbase Excel Addin , SmartView , Planning, Analyzer, Financial Reporting Studio.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture and complete lifecycle of project from design to development and implementation.
• Expertise creating, maintaining and supporting user security and using Hyperion Shared Services and BO CMC.
• Broad functional knowledge of corporate finance processes Planning, Budgeting Forecasting, Reporting Analytics and Monthly/Quarterly/Yearly Close Process .
• Very good functional knowledge of various Finance data streams like Invoice, Revenue, Bookings, Expense, Headcount, Capital, Assets Liabilities, Chart of Accounts, General/Sub Ledger, ERP and HR.
• Expertise Analyzing the Finance data, performing Data Audits/Financial close tie outs across various OLTP OLAP systems.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Well versed with CMM Level 5 processes requirements and change management, configuration management, software lifecycle and product quality, review process, process defect management, process improvement and implementing best practices.
• Ability in managing and supporting multiple applications/projects.
• Skilled in Application Documentation, BRD's and Application/Software Processes.
• Excellent interpersonal skills, ability to work independently as well as part of an integrated team.

Technical and Functional Skills:

Professional Experience:

Confidential

BI Analytics Engineer, Services Analytics Solutions Group

In Project Invent

• Develop complete Open Source ETL software for Cisco Analytics
• Develop Visualization and Management Information Systems using Open source ETL
• Develop Descriptive Statistics Analytics and Decision Support Systems using Tableau
• Develop Prescriptive Statistics Analytics using Revolution R analytics
• Develop Linkage Graph Analytics using Artificial Intelligence and Machine Learning/Programming
• Develop Integration of Web portal interfaces and Data Connectors using SAS Sentiment Analysis , Text Mining and Real Time Predictive Analytics

Tech Environment: Informatica Power Center, TALEND Open Studio for Data integration, Tableau, RALLY Project Tracking tool, R Analytics/Statistical Computing, SQL Server, Informix, Postgres, Composite Sever, SAS Web Services/Engine, Jive Web Portal, Core Java, Aggregator Profiler Data Quality and Data Profiler tool, SPLICE Machine/DB, DBVisualizer, Finesse Desktop, Exony VIMX

Roles and Responsibilities:

• In depth study, analysis and understanding of Solution Architecture for Cisco Systems Contact Center Analytics.
• Conducted Business interviews and reviews with stakeholders and analyze the business requirements to create appropriate analytical metrics dashboards that can be used to run operations based on GTRC/UCCE/CVP data requirements.
• Conducted Project Invent discussions along with all module leads to gather, understand and analyze the Module specific functional, technical and business requirements.
• Provided ETL Technical specifications and standards to meet Cisco Analytics Business requirements for Contact Center as part of Descriptive and Predictive Statistical Analytics for Decision Support.
• Served as RALLY Scrum Master for Project Management and Tracking using RALLY tool.
• Implemented and followed Agile/Sprint base methodology to achieve Project Tasks/Deliverables.
• Served as Lead for 2 Modules of the Project Invent involving ETL and Tableau.
• Identified Key data sources, conducted data quality checks and data profiling on various data sources of Cisco Customer Contact Center.
• Analyzed on the existing various Data sources and tools within the contact center system.
• Created appropriate data structure and model through ETL logic to create analysis ready data set.
• Served as a Key, Versatile Team Player in organizing all Modules of Project Invent and coordinating with the module leads.
• Designed and Developed the ETL jobs, mappings using TALEND and Informatica Power Center.
• Developed Invent DataMart to store Aggregated and Summarized Data of Near Real time and Historical Call Details.
• Designed , Developed and Implemented the project in a Full Software Life Cycle Development model.
• Supported and Coordinated with Business, IT and Domain Expertise teams in all respects of the Project Implementations for Module integrations and Business/IT specifications requirements clarity.
• Involved and supported in preparing and leveraging BI dashboards and Reports using Tableau for Cisco Analytics Contact Center like Cradle to Grave Call Detail reporting, Agent Watch analysis, Skill Group data, predictive talk time ,call duration, hold time analysis, Repeat Callers, Transferred calls, Call History and Topology.

Confidential

Business Intelligence Project Lead, Western Union Data warehouse and BI Systems

Project Description

Business Intelligence and Data warehousing is one of the key major IT sectors in Western Union involving various technologies like Oracle Hyperion Reporting, Business Objects Reporting, AS400, MS SQL Server, Oracle, DB2, Mainframe, Cloud based HPSM, Netezza, Data Stage for maintaining WU's Money Transfer Global Financial, Marketing, Sales, Customer, Compliance, Operations and IT related Information.

Oracle Hyperion HFM/Essbase 11x and SAP Business Objects XI R3 are the BI analytical tools used for Strategic level Reporting and Decision Support systems across the Globe by WU users.

Roles and Responsibilities

• Involved in the following WU Money Transfer Projects for BO Reporting:
• AGS iCertify Access Governance system implemented with Novell AGS Product
• ABMT Account Based Money Transfer Revenue Recognition
• MY WU UCD Unified Customer Database Customer Registration BO Reporting
• Canada RTRA compliance rules
• Involved in Business and IT Discussions, Gathered/Analyzed business requirements and provided
• application/IT specific solutions and roadmap to the business needs.
• Actively Involved in Business Requirements analysis and clarifications for BO, Data Stage, Data
• Marts and HFM reporting as a BI Project Techno functional expertise.
• Managed and Lead the Onsite-Offshore Team effectively.
• Designed, Developed, Tested and Implemented the BI reporting solutions in full software life cycle
• process model DEV-TEST-PROD .
• Designed, Developed, Tested and Implemented both ETL and OLAP solution's/Architecture for the above
• mentioned projects in the Enterprise Data Warehouse and Business Intelligence
• Created Universe using Derived Tables and Created simple to complex, ad hoc to standard BO
• Webi/Deski/Rich client/Infoview reports and Dashboards by applying various features like prompts,
• calculations, conditions, filters, variabl t with Business and Other cross functional / IT teams.
• Performed the development in a process oriented platform for change and release management using
• HPSM tool.
• Involved in Oracle Hyperion HFM/Essbase application Admin and Support activities for WU's Oracle
• Financial Budgeting, Planning and Forecasting.
• Created adhoc and standard HFM, Essbase Excel, Smart view reports and provided extensive user
• support for FP A team.
• Involved in HFM, FDM, and Essbase, OBIEE and Oracle R12 integration planning and activites.
• Provided Business, User and IT support effectively.
• Involved in DEV, QA and UAT support.

Tech Environment: Business Objects XI R3, OBIEE,HFM/EPM 11i, Data stage ETL , MS SQL Server 2008, AS400, Windows 7, HPSM case management tool

Confidential

Hyperion BI Technical Developer, GL/COA /CCER, FP A Finance BI

Project Description

• The Finance Business Architecture FBA program is focused on transforming Cisco's close process and related reporting, with an accurate, secure and trusted solution that is flexible, scalable, integrated, and will support Cisco's evolving business models and changing accounting rules. The FBA team is optimizing Finance processes and implementing Hyperion applications as a global consolidation platform to support business decision making through the availability of timely, accurate and detailed financial data and reports.
• Increased automation and reduction of manual calculations to generate reports.
• Improvement of data audits between systems.
• Enhanced delivery capabilities of reports and data.
• Increased security over Financial Reporting, with the ability to track and monitor all system access and activity by user.
• Enhanced ad-hoc analysis capabilities on GL and non-financial data
• Improved visibility into financial data for validations, reconciliations, tie-outs, etc.
• Increased accuracy of consolidated financial data
• GLCube was formerly called the COA Cube Chart Of Accounts built on Hyperion Essbase. GLCube is the Enhanced reporting application of COA Cube.
• As part of the CCER implementation, the GLCube is critical as it will be the only reporting tool where users can access both Oracle and HFM data at the full six segments of the chart of accounts. As HFR and Smart View ad-hoc reporting are both sourced by HFM, they differ from the GLCube as they only display data at the consolidated four-segment level. Complete data is sourced from the SSOT Enterprise Data Ware house Teradata EDWTD in to the GLCube and the data is refreshed daily in the Hyperion Cube. Business Users run the reports using Essbase Excel and web based Reporting tool.

Roles and Responsibilities

• Supported the Legacy application COA Cube in Production.
• Involved in Business and IT Discussions, Gathered/Analyzed business requirements and provided application/IT specific solutions and roadmap to the business needs.
• Converted Business requirements in to Hyperion Essbase cubes , Summraized and Detailed data Reports.
• Designed/Developed/Tested/Migrated Dollar Universe scheduling jobs Batch script automation.
• Designed/Developed/Tested/Migrated Hyperion Essbase Applications, UNIX scripts, Hyperion EIS OLAP model, FDM application, HFM application, Informatica workflows and mappings - ETL.
• Created/Modified MaxL, Load Rules, Calc , UDA's Report Scripts , Partitions, Cube outlines, EIS metaoutlines and EIS OLAP models.
• Performed Essbase database backups, Dense/Sparse settings, partitioning, ESSCMD scripts, MaxL scripts, Optimization and tuning cubes, essbase queries.
• Key techniques used were resetting databases, grouping sparse members, combinations, using parallel calculations, managing caches, using two-pass calculations and changing buffer size.
• Designed/Developed/Tested/Migrated both ASO and BSO cube for various Finance cubes on Hyperion.
• Extensively worked and handled EAS , EIS and EPM tools.
• Installed and Configured Hyperion Suite HFM , FDM , EAS, Essbase , EIS and Shared Services on Unix.
• Designed/Developed/Tested/Migrated FDM Mappings and validation rules.
• Applied HFM to create Balance Sheets, Cash-Flow statement, financial and market forecasting through data retrieved from Essbase.
• Developed/Tested/Migrated Hyperion Essbase User Security using shared services.
• Designed and Developed Smartview/Essbase Excel addIn, Planning and HFM Reports for Finance Team.
• Extensively worked on database connectivity, data extraction, database issues, EIS, EAS, Shared Services, and Cube loading issues on Production environment.
• Designed/Developed/Tested/Migrated the Informatica Mappings,Transformations and Workflows inorder to extract data from Teradata.
• Created complex queries for Sorting and Sequencing of data from Teradata.
• Worked with multiple Technical and Business Teams of Finance/Data warehouse/Business Intelligence to resolve various Data Issues, Technical issues and understand systems.
• Automated Data extractions and Cube loadings using unix batch scripts and Dollar Universe batch scheduler.
• Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly Finance data.
• Created Groups, Users, Filters, user permissions and Maintained User Security on Shared Services.
• Performed Code reviews and regular application enhancements.
• Deployment of application cubes in to production from Dev/Test.
• Performed Daily/Monthly/Qrtyly/Yrly Data audits across between OLTP-Data warehouse-OLAP systems and helped business in Financial Close tie outs.
• Worked on Performance Tuning and Management of Hyperion tools and reporting applications.
• Troubleshoot and resolved Data issues and software issues and helped finance users to meet business needs.
• Provided end user training on Hyperion Applications to Finance users.
• Documented and maintained the support manual, BRD of applications.
• Developed Tested, Supported and Maintained the complete application until production go live.

Tech Environment: Hyperion Essbase MaxL , Unix Shell Script , PL/SQL , Teradata Bteq, OBIEE 11g,Hyperion Essbase v11,Hyperion EIS, Shared Services, HFM 11x, DRM, FDM/FDQM, Informatica Power Centre 9.1, Dollar Universe, Linux 5 , Windows 7

Confidential

Onsite Finance BI Reporting Project Team Lead, IT Finance BI/DW Enterprise Reporting

Project Description:

IT Finance BI Suite is a collection of financial data reporting applications in the form of Essbase Cubes and Business Objects Universes used for Business Decisions and Statistical analysis by Financial Analysts across World Wide of Cisco. It establishes a foundational BI platform and framework a scalable and integrated solution to effectively address the changing and complex business environment. Benefits of the Finance BI Suite include: 1. Easy custom reports 2. Access to updated data 3. Simplified multi-measure analysis and multi-dimensional functionality 4. Standardized, enterprise-wide solution.

Roles and Responsibilities:

• Actively Involved in Business and IT Discussions, Gathered business requirements and provided application/IT specific solutions to the business needs.
• Created Hyperion Cubes, Business Objects Universes, Meta outlines and OLAP/Relational data models for multidimensional view of data.
• Worked with multiple Technical and Business Teams of Finance/Data warehouse/Business Intelligence to resolve various Data Issues, Technical issues and understand systems.
• Applied OBIEE, Hyperion Financial Reporting to design specific financial reports to serve management requirements.
• Performed Production Bug Fixing and Solved priority issues at Month end/Quart end/Yearend critical times.
• Created instant Load Rules, Calc, MaxL ,MDx, UDA's ,Report and Export scripts to solve the Production issues to meet the client needs.
• Performed Essbase database backups, Dense/Sparse settings, partitioning, ESSCMD scripts, MaxL scripts, Optimization and tuning cubes.
• Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information, security, and migration from XIr2 to XIr3.
• Designed and Created several universes for different finance subject areas like Invoice, Inventory, Bookings, Revenue, Capital, Expense and Headcount.
• Created custom hierarchies to aid in Drill-Through analysis of Webi documents.
• Created various contexts, adhoc queries to see summarized/detailed finance data as per the business rules to meet the business reporting needs from different/multiple data sources.
• Created simple to complex, ad hoc to standard BO Webi/Deski/Rich client/Infoview reports and Dashboards by applying various features like prompts, calculations, conditions, filters, variable and user objects, formatting options.
• Migrated BO Universes and Reports across different environments Dev, Test/Stage and Prod .
• Upgraded Legacy BO reporting apps from older version 6x to XI R2 to XI R3.
• Resolved BO Report performance issues by fine tuning of complex Pl/SQL and Teradata queries, and tuning universe design/OLAP model and normalizing/denormalizing of database tables/views.
• Created mappings and workflows for data extractions by ETL Informatica and oracle PL/SQL.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web XI R2.
• Applied Essbase config settings for the better performance of Cubes, data loads and data retrieval.
• Developed and Implemented various ASO and BSO Cubes and their Partitions on all environments.
• Automated data extraction and data loading in to the cubes/OBIEE using unix batch scripts and Dollar Universe Job scheduler tool.
• Performed Daily/Monthly/Qrtly/Yrly Data audits across between OLTP-Data warehouse-OLAP systems and helped business in Financial Close tie outs.
• Created various consolidations and calcs for data aggregations.
• Migrated the application cubes across Dev, Test and Prod environments.
• Upgraded the legacy cubes from hyperion version 6x to 11i.
• Developed custom reports on OBIEE, Excel Add in, Smart view, Planning, Financial Reporting studio webi for the users and support users at Month end/Quarter end/Yearend critical times.
• Created user specific drill through and summarized data reports.
• Provided support in sharing and scheduling of user reports.
• Tuned Essbase queries, Cache settings, cube designs sparse-dense dimensions and formulas and resolved performance issues and data issues.
• Created Users/Groups/Filters. Maintained and supported user security over Shared Services for OBIEE, Hyperion and CMC for Business Objects.
• Provisioned user security by various Dimensional levels and hierarchies as per user needs.
• Involved in Change Management.
• Supported and Maintained full FPM suite infrastructure on Cisco Webex client site.
• Application maintenance and on call support in Full Production Life Cycle.

Tech Environment: PL/SQL, Unix Shell Script , Hyperion Essbase MaxL, Teradata, Oracle, OBIEE 10g/11g,Hyperion Essbase 11i,EAS,EIS, Hyperion EPM Suite, Business Objects 6x/XI R2, Informatica Power Center 9x, Dollar Universe, Linux 5.3 , Windows 7, XP, Remedy Case Management Tool

Confidential

Production Support Lead CISCO Finance BI, Customer Advocacy Finance

Project Description

CA- Finance IT is responsible for delivering standardized reports and data with business rules applied and provides business intelligence that helps to make the business decisions to retain the CA on its desired growth path. Main responsibilities of the team are operations i.e., job monitoring and resolving technical issues and team in supporting the applications.CA Finance involves generating reports for critical business decisions based on the data provided by the OLAP tools like Hyperion Essbase Cubes and Business Objects Universes.

Roles and Responsibilities

• Maintaining and supporting CUBE LOADS/BO Universes and Reporting.
• Maintaining and Supporting the production in a Full Life Cycle basis.
• Designed, Developed, Maintained and Supported BO Universes and Webi/Deski Reports.
• Extensively worked on code reviews and enhancements.
• Applied security features of Business Objects like row level, report level object level security in the universe so as to make the sensitive data secure.
• Performed Dense/Sparse settings, partitioning, ESSCMD scripts, MaxL scripts, Optimization and tuning cubes, essbase queries.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Created complex PL/SQL queries and informatica mappings/transformations/workflows for data extraction.
• Worked on creating/modifying Load Rules, Calc Scripts, Report Scripts, Business Rules, and Webforms.
• Exported the ad-hoc ready universes for making semantic layer available to the users.
• Created and defined different Classes and Dimensional Hierarchies for various reports based on the Business rule of the Organization.
• Documented BRD's and the Applications in the Support Manual.
• Troubleshoot errors in Cubes, reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created and Monitored Dollar Universe Batch Jobs and daily data loads in to cubes and universes.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created Derived tables, Developed Stored Procedures, Packages and Triggers database using PL/SQL.
• Production bug fix and Solving priority issues.
• Excellent in using the Remedy Case Management tool for Production Support Issues and End Customer Support Service.
• Migrated Cubes, BO universes and Reports across environments Dev/Test/Prod .
• Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly Finance data.
• Performed Daily/weekly/Monthly/Qrtly/Yearly Data load audits regularly.
• Created and Maintained user security on EAS 6/7x for Hyperion and Supervisor for BO 6x.

Tech Environment: Oracle PL/SQL, Unix Shell Script , Hyperion Essbase MaxL, Hyperion Essbase, Essbase Excel Addin, Business Objects ,Informatica, Unix, Windows