PROFESSIONAL SUMMARY

• BI analyst with over 7+ years’ experience working on large, complex full lifecycle business analytics and reporting initiatives.
• Strong Business Analysis capabilities combined with excellent people, technical and project management exposure.
• Worked in an agile environment, engaged with users to bridge gap between data issues and business processes.
• Exposure to project management methodologies covering Agile, Waterfall and Iterative methods.
• Hands-on experience with requirements elicitation, Data & process flow documentation, use case scenarios, swim lane diagrams and test case development.
• Strong business/data analysis, data mapping, validation, testing and UAT engagement.
• Solid ETL knowledgeand good understanding of data modeling approaches.
• Possess strong ambition combined with problem solving and communications skills along with a passion for learning new technologies and meeting new people.
• Worked through all phases of business intelligence projects including analysis, design, development and testing.
• Excellent business analysis skills and comfortable working with business users to understand workflow and processes in order to elicit business requirements.
• Experience with Business Objects 5x/6.x/XIR2 and exposure to XIR3, including utilizing WebI, DeskI, InfoView, Universe Designer and CMC
• Hands on experience using Quality Center for documenting requirements, aligning testing to requirements, and tracking defects.
• Helped resolve team member issues inclusive of business /data issues and reporting

TECHNICAL SKILLS

Tools/Misc: Business Objects 5x, 6x/XIR2 / XI3.x(Web Intelligence, Desktop Intelligence, InfoView, Universe Designer, CMC), Hyperion Essbase, Hyperion Interactive Reporting 9.3, Erwin, TOAD, SQLdbx, HP Quality Center, Clearcase,
MS Project, MS Visio, Sun Accounting System

Databases: DB2, Oracle, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Aug 2011 – Sep 2011
Sr Business Analyst / Report Developer

• Analyzed data and created requirements from a business perspective for reporting
• Engaged with business users to elicit requirements for the supplier contact and profile management reporting application
• Created requirement documents and supporting materials for universe requirements, design, testing, and use cases to support business user demo’s and testing activities
• Engaged with users and ETL teams on business rules and data manipulation
• Created 2 universes as part of the project to support supplier company insurance, tax, contact and role management reporting
• Identified reporting needs and performed object mapping for universe objects from the data mart
• Performed source to target data mapping

Environment:SAP Business Objects 3.2, DB2, SQL Server 2005, SharePoint

Confidential,Oct 2010 – Jul 2011
Sr. Business Objects Consultant

• Analyzed existing reports in Hyperion SQR and rationalized report design and functionality to developnew reports using BO XI3.2
• Conducted JAD sessions and engaged with business leads to identify reporting and dashboard needs around flight owner profile business group
• Created and delivered PowerPoint presentation to depict user requirements to capture universe changes for each sprint.
• Validated requirements for universe and reporting needs
• Verified that requirements meet the standard guidelines provided by the company
• Worked in an Agile environment , engaged with users to bridge gap between data issues and business
• Verified business definitions in consensus for effective data mapping
• Performed data analysis on source data, developed data mappings for ETL, and documented metadata for the warehouse
• Created 3 new universes to support flight operations& performance, crew schedule and maintenance response activities;linked these universes to existing universes
• Performed unit and integrated testing of reports and validated ETL mapping through data analysis
• Managed defects logging and resolution for multiple projects and releases
• Worked with business users to facilitate UAT activities and resolved issues
• Handled BO administration functions including user, group, connection management and performed universe and report migrations through development, test and production environments
• Handled production tickets, research, follow-up and resolution activities

Environment: Hyperion SQR, Business Objects XI 3.2, Crystal Reports, Oracle 11g, Clearcase, Microsoft Project, HP Quality Center, IJets application

Confidential, OH Mar 2010 – May 2010
Business Objects Developer

• Engaged on a project team that supports reporting and analytics for real estate operations for US-based facilities, specifically providing data around trending, exceptions, operations, performance, maintenance, problem types, facility location, cost centers and SLA details.
• Collaborated with user teams to define report specifications and design report layout and created WebI report packages.
• Extensively used reporting contexts including ForEach,ForAll and In functions.
• Created trending reports along with top 20 issue category ranking with different dimension cuts to show SLA patterns and high-volume problem categories.
• Developed reports with drill through and linked functionality for various region specific needs.
• Identified data issues including missinginformation,data duplication, and incorrect data mapping used in ETL.
• Modified existing universe to add functionality to support new report development.
• Created report design specifications with detailed mapping and calculations and reviewed with end-users for accuracy.
• Mentored Junior BO development resources and trained end-users
• Managed UAT and delivered modifications, bug fixes and performance tuning.
• Assisted BO Administrator with universe modification, migration and bug fixes.
• Mentored Junior BO development resources and trained end-users.

Environment:Business Objects XI R2, Oracle 11g, MS Project

Confidential, OH Dec 2009 – Mar 2010
Business/Data Analyst

• Worked on a project that was focused on data analysis, validation and reporting as part of the Banking Center P&L (BCPL) group within EDW.
• Performed cube build validation by comparing data from multiple Essbase cubes against Hyperion queries.
• Created Hyperion reports for branch-level profitability reporting inclusive of account and balance activity, tracking of cost center migrations, and validation of high-balance aggregates.
• Generated ranking reports for branches based on existing accounts, new accounts opened and high-balance accounts and applied Y-O-Y trending across 4 years and showed region-wise performance for pre/post-merger situation.
• Analyzed data across multiple environments to validate cost center allocations and roll-up for deposits, loans and consumer data.
• Performed complex data validation and analysis in Excel through pivot tables, formulas, multiple and vlookups to isolate accounts based on various bands of balance and transaction activity.
• Created new reports and modified existing reports in Business Objects XI R2.

Environment:Hyperion Essbase, Hyperion Interactive Reporting, Business Objects XI R2, DB2, Excel

Confidential,VA Oct 2008 – Nov 2009
Business Analyst

• Worked on the RFP for the report conversion project to convert Web Intelligence and Desktop Intelligence reports in XI R2 version to Web Intelligence reports in XI R3.1.
• Created the SQL Loader scripts to set-up database layer.
• Performed source side data analysis to mimic report output for manual validation.
• Developed consultant utilization metrics, payroll actual and projected disbursement reports.
• Created client profitability analysis reports, with billing trends and provided drill down capabilities to an individual consultant level.
• Designed and built active contracting pipeline reports to help marketing managers manage job pipeline and consultant placements.

Environment:Business Objects R2, TOAD, Oracle 10g, SQL Server 2005, Windows XP, SQL Loader

Confidential,Accounting & Operations Jun 2003 – Apr 2006
Business/Data Analyst

• Selected as part of the MIS group supporting accounting, billing and operations business groups.
• Managed petty cash process, reporting and analysis across 55 branch offices.
• Utilized the ‘Sun Accounting system’ for financial accounting activities and created custom operational reports.
• Managed the business analysis and requirements definition activity for the new expense management application for petty cash and its interface with Sun systems.
• Created high-level process flows, swim lane diagrams, and Use Cases for the new web-based application.
• Performed ad-hoc SQL data analysis on sun systems database (SQL Server).
• Worked with branch executives and operations group to identify insurance active pipeline and conversion/commission reports for sales group.
• Captured business metadata and created reports for easier access by users.
• Trained business users on report usage and helped convert legacy reporting to Business Objects reports.

Environment:Business Objects 6.1, TOAD, Oracle 9i, Windows 2003, SQL Server 2000, Sun Accounting System, ASP.NET, Visio, Quality Center, MS Project

Confidential,India Sep 2001 – May 2003
Data Analyst/Intern

• Trained on Business Objects 5.1 report development.
• Worked with client group to identify core reporting functionality and design requirements.
• Performed source to target data mappings, business rules for ETL and ad-hoc analysis.
• Analyzed data from several source systems, assisted development teams to build solutions and provided support for testing and delivery of applications.
• Performed SIT through back-end data testing to validate business rules.
• Assisted with UAT activities and with writing technical as well as training documentation.

EDUCATION

Master of Commerce