Ruchi Nihalani

Email: jym1n8@r.postjobfree.com

Phone: +659*******

Experience Summary

A career in Business Analysis, Data Warehousing and Business Intelligence with extensive experience in multiple full life cycle DW/BI development projects including gathering business requirements, analysis of source systems, design suitable data model/architecture (both relational and dimensional including star schema) for data warehouses and data marts, implementation.

Extensive experience from designing to implementing DWH/BI systems including Roadmap definition, Solution Architecture, Security, Metadata Management, Data Modelling and Data Quality.

Experience in Installation, configuration and executing BI projects involving SAP Business Objects

Strong hands on experience in Informatica, SAP Business Objects, BI Project life cycle, BI Road map definition

Hold a number of internationally accepted certifications like BO XI certified Designer and Administrator, Informatica Certified Designer, Introduction to Oracle 9i (PL-SQL) etc.

Worked as an Architect, team lead, technical consultant and business analyst in multi-cultural teams spread across Australia, US, India.

I have a total of 6+ years of experience in BI/DWH space.

Achievements

• International exposure of working in US, Australia, India etc

• Received appreciation from clients for successful execution of projects.

• Graded CRR (Top 5%) and “Above expectations” in the performance appraisals.

• Team received excellent customer satisfaction rating consistently

• Won a Star Tech Award for Integration project at Westpac Bank. From over 139 nominations, our team had been recognized as role models for living Westpac values and actively helping to bring their customer centric culture to life.

Domain Experience – Banking Industry (Core banking, Finance, Credit/Risk Management, Compensation Management), Insurance (Annuities, Security), Retail (Sales), Energy/Utilities (Sales and Stocks), Media (Physical and Digital Sales)

To summarize, I have got financial projects exposure on handling Core banking, Finance, Credit/Risk Management and Compensation Management systems with Westpac Bank, Insurance projects exposure on Security domain like Credit Card with All State Insurance in US and Maintenance projects on Individual Annuities and Group annuities domain with Hartford Insurance in US, Retail experience on Sales with Bestseller and Nordstrom, Media exposure related to Physical and Digital Sales Reporting with Warner Brothers in US, Utilities exposure on Sales and Stocks with BP

Specialties

• Business Analysis

• Global DWH/BI Consultant

• Global exposure of various countries

• Onsite-offshore coordination

• Experience in full cycle Implementation

• BI Workshops

• Client Interactions

• Technology Architecture and Consulting

• Expertise in SAP Business Objects, EPM, Xcelsius Dashboards and other BI tools

• Expertise in BODI, Informatica and other ETL tools

• Expertise in Oracle, SQL Scripting, PL-SQL Performance tuning, Unix Shell Scripting

Non-Technical skills include strong analytical ability, good communication skills, taking ownership of project, mentoring/assisting within team, flexibility and hard-work etc.

Technology

Software Products Tools

Reporting

BO 5.7, BO 6.5, Business Objects XI R2 including WebI, DeskI, Crystal Reports XI, Enterprise Performance Management, Crystal XCelsius, Oracle Reports

ETL - Informatica, BODI, OWB

DBMS

Oracle 10g, PL/SQL, SQL, Ms Access

Scripting - Unix Shell Scripting Reporting/ETL

PL/SQL

UML

Visual SourceSafe

SQLPlus, SQL Loader

Toad

Erwin

Control M, Autosys

TrueComp

Career Profile

Dates Organization Role

Apr 2010 – 10 Feb 2011 OpenSymmetry Australia Pty Ltd Senior DWH BI and Comp Mgmt. Consultant

July 2009 – Mar 2010 Westpac Banking Corporation Australia Senior Associate DWH BI Consultant

August 2004 – June 2009 Infosys Technologies Ltd India DWH BI Managing Consultant

Qualifications

Degree and Date Institute Major and Specialization Percentage (%)

Bachelor of Information Technology, June 2004 Jamia Millia Islamia University, New Delhi Information Technology 80

Assignments

Project Compensation Management and Dashboard Design

Role Senior DWH BI and Compensation Management Consultant

Customer Westpac Banking Corporation, Australia

Westpac is Australia's First Bank with a range of innovative financial packages to suit your needs. As of the merger with St.George in December 2008 the bank has 10 million customers, Australia's largest branch network with almost 1200 branches and an ATM network with more than 2800 ATMs.

Period Apr 2010 to Feb 2011

Description The project involves loading Fund Manager Statements to RDB, reconciling them and then loading them into Comp Mgmt Tool using Integration Tool Informatica as Inbound process and Reporting/Data Visualizations is done on top of that as Outbound process for effective decision making and Reconciliation purposes

Responsibilities

• Liaising with Users and Technical team to convert business requirements into Technical Specifications

• Analyze the requirements and create the High-level, detailed design document

• Participate in creating application architecture document

• Assist developers during the build and perform QA checks of the completed code

• Impact analysis of Code

• Create unit test plans for complex programs in order to validate and maintain the application.

• Develop and review Artifacts (Code, Documentation, Unit test plans) and conduct reviews.

• Perform validation activities (Functional, integration, system, user experience) based on the plans

• Performance testing to deliver a quality work.

• Provide UAT Support to end users and look after all their queries.

• Create Deployment Guide, provide deployment and Post deployment Support

• Participate in Change Management meetings

• Respond to production issues and arrive at a quick solution with inputs from stakeholders.

• Managing client expectations, status reporting, documentation and escalating issues

• Conducting Workshops for team members

Software BO XI, BODI, Crystal Xcelcius, Informatica 8.1, Oracle, Windows/Unix, Control M, Quality Centre

Project Financial Systems Integration

Role Senior Associate DWH BI Consultant

Customer Westpac Banking Corporation, Australia

Westpac is Australia's First Bank with a range of innovative financial packages to suit your needs. As of the merger with St.George in December 2008 the bank has 10 million customers, Australia's largest branch network with almost 1200 branches and an ATM network with more than 2800 ATMs.

Period July 2009 to Feb 2010

Description This project involved replacing St George Bank Walker system (GL, AP, FA and Purchasing) with the Westpac Oracle Financials system as part of the Financials Systems Integration project and reporting on top of that.

The project involved design, development, maintenance and support of Informatica Powercentre ETL systems and Dashboard reporting.

Responsibilities • Requirement gathering, analysis and documentation

• Impact analysis, participate in high level design, create design specifications

• Development of the code, testing and reviews for self and peers.

• Bottom line responsibility for the on-time delivery of the project.

• Effective stakeholder management

• Issues and risks management

• Mentoring new team members and effective resource management

• Providing reports to senior management.

• Effective client management

• Application Improvement initiatives across the portfolio.

• Effective situation management for high severity issues.

• Creating visualizations for effective decision-making.

Software BO XI, Crystal Xcelcius, Informatica 8.1, Oracle, Windows/Unix, Control M, Quality Centre

Project Webfocus to BO Remediation

Role BO XI Managing Consultant

Customer Allstate Insurance, USA

The Allstate Corporation NYSE: ALL is the largest publicly held personal lines insurer in the United States and the second-largest of all personal lines insurers in the U.S. Allstate was founded in 1931 as part of Sears, Roebuck and Co. Allstate sells 13 major lines of insurance, including auto insurance, home insurance, life insurance, and commercial insurance. Allstate also offers retirement and investment products, and banking services.

Period Dec 2008 to June 2009

Description This project involved converting existing 20 Webfocus reports containing accounts payable data to Business Object Reports.

Reports Design involved accessing details from Master-Detail tables to display Multiple Credit Card Employee report, TIN Verification reports, Bank Details of Employee report, DHL report, Vendor Information Report etc.

Responsibilities • Involved in all phases of SDLC - requirements gathering, business process analysis, design, coding, testing (Unit Testing, SIT, UAT Support), reviews, implementation

• Developed Universe and user friendly BO and Crystal Reports for Accounts Payable department

• Lead a team of few members – Assisted team during build, documentation and creating unit test plans, conducted code reviews

• Consulting on IT issues, coordinated with offshore and ensuring quality of deliverables

• Responsible for handling issues with product vendors, consulting on IT issues, coordinating with offshore and ensuring quality of deliverables

• Managing client expectations, Weekly status reporting, documentation and escalating issues

• Responsible for training team members

Software BO XI, Crystal Reports, Oracle, Windows, UML

Project ETL and Reporting for CM

Role DW/BI Technology Consultant

Customer Invitrogen, USA

Invitrogen Corporation (Nasdaq:IVGN) provides products and services that support academic and government research institutions and pharmaceutical and biotech companies worldwide in their efforts to improve the human condition. The company provides essential life science technologies for disease research, drug discovery, and commercial bioproduction. Founded in 1987, Invitrogen is headquartered in Carlsbad, California, and conducts business in more than 70 countries around the world. The company employs approximately 4,700 scientists and other professionals and had revenues of approximately $1.3 billion in 2007.

Period Jul 2008 to Nov 2008

Description This project involved creating a Campaign Management solution using Unica, a third-party vendor product consisting of Unica front-end application.

a) Data Modelling for CMDB (referred as CMDB – Campaign Management Database)

b) To build an Extract, Transform and Load (ETL) interface between its existing EDW (Enterprise Data Warehouse) to bring certain data into the proposed Campaign Management Database (CMDB).

Reports Design involved displaying Product Offer and Discounts information for products sold across different geographies in different Campaigns.

Responsibilities • Requirements analysis and gaps analysis

• Involved in Data Modelling and Design of EDW tables, Source to Target Mappings and transformations, Creation of Sessions, Workflows, Versioning, Unix Shell scripting

• High-level design, detailed design, build, review and consultation.

• Creation of professional reports using BO Reporting

• Client management responsibilities

• Defect and risks management

• Coordination of the business enhancements

• Took the ownership of on-time delivery of the project.

• Responsible for Team Lead activities like building traceability matrix, knowledge mgt, configuration control, Scheduling and Tracking of tasks, Preparing Project plan, Running project meetings

• Responsible for training team members

Software Informatica, Oracle, BO XI R2, EPM, Crystal Reports, MS Visio, VSS (Visual SourceSafe), Windows , Erwin, UML

Project WWS Development

Role DWH BI Global Consultant

Customer Warner Music Group(WMG), USA

Warner Music Group (WMG) became the only stand-alone music company to be publicly traded in the United States in May 2005. With its broad roster of new stars and legendary artists, Warner Music Group is home to a collection of the best-known record labels in the music industry. Warner Music International, a leading company in national and international repertoire operates through numerous international affiliates and licensees in more than 50 countries. Warner Music Group also includes Warner/Chappell Music, one of the world’s leading music publishers

Period Jan 2008 to Jul 2008

Description This project involved estimation, analysis, design, implementation and support for ETL and reporting. The objective of the project is ETL (Modification of existing functionality and building new functionality) and Reporting (Universe Design, Reports design and Development)

Reports Design involved display of Physical and digital transactions of title tracks including Title Ranking, Account Ranking, Label Summary, Product Summary, Account Summary reports etc.

Responsibilities • Responsible for analysis, design, build and implementation of a global, 24x7 sales reporting application integrating physical and digital product lines.

• Involved in Data Modeling, responsible for performance tuning of DB focusing on partitioning and indexing strategies, including implementation of Materialized Views for use with star transformation.

• Design and build of adhoc universes to be used by a select group of power users and WebI reports.

• Also involved in assisting BO Admin team, creating Test plans, UAT Support, Implementation Support, Maintenance and Enhancement post production

• Conducted training for team members

• Responsible for handling issues, coordinating with offshore and ensuring quality of deliverables

• Responsible for managing client expectations, status reporting, documentation and escalating issues

Software BO XI R2, EPM, Crystal Reports, Oracle, PL-SQL, PVCS, SharePoint, UML, Erwin

Project ANALYSIS AND DESIGN PHASE FOR DWH/BI IMPLEMENTATION

Role BO XI Technical Consultant

Customer Bestseller

Bestseller is an international fashion business in Ringkøbing, Denmark. It was founded in 1975 and today over 13,000 employees design, develop, market and sell the company’s products on the world market. Bestseller launches collections of designer wear for men, women and children in Europe, the Middle East, China and Canada every year, distributing through chain stores and wholesalers.

Period November 2007 to December 2007

Description This project involved implementing Single Sign On (SSO), security at user level and data level to be used by reporting.

Responsibilities • Responsible for Data Modelling

• Implemented SSO on BO infoview for enterprise users

• Responsible for administering BO environment including managing users, contents, security, servers etc and reports design and development

• Responsible for project management activities like building traceability matrix, knowledge mgt, defect prevention & configuration control, Scheduling and Tracking of tasks, Preparing Project plan, Running project meetings

Software BO XI R2, EPM, BODI, Crystal Reports, Oracle, OWB, VSS

Project HLI DATAWAREG\HOUSE ENGAGEMENT

Role DW BI Consultant

Customer Hartford Life Insurance, USA

Founded in 1810, The Hartford Financial Services Group, Inc. (NYSE: HIG) is one of the largest investment and insurance companies based in the United States, with offices in Japan, Brazil, Ireland, England, Canada, and the United States. With 31,000 employees and $2.3 billion in income in 2005, The Hartford was ranked 78th on the 2006 Fortune 100 list.

The Hartford is a leading provider of investment products – annuities, mutual funds, college savings plans – as well as life insurance, group and employee benefits, automobile and homeowners’ insurance, and business insurance.

Period May 2006 to Nov 2007

Description This project involved estimation, analysis, design, implementation and support for reporting projects. The objective of the project is Major enhancements, Minor enhancements, bug-fixing.

Reports Design and Maintenance involved Owner-beneficiary reports containing Insurance data.

Responsibilities • Involved in Major Enhancement, Minor Enhancement, Bug-Fixing, Production Support

• Main Source of contact for all business queries.

• Handled multiple modules taking complete ownership of quality delivery

• Responsible for Universe and user friendly BO Reports

• Involved in Reports migration from BO 5.1 to BO XI

• Involved in American fund support using PL-SQL coding

• Involved in day to day Production Support handling reports in BO

• Metadata modelling using Cognos Framework Manager

• Creation of professional reports using Cognos Report studio Cognos

• Responsible for managing client expectations, status reporting, documentation and escalating issues

• Conducting Workshops for team members

• Played major role in Offshore setup and Knowledge Transition to team members

Software BO 5.1 Web Intelligence, BO XI, EPM, BODI, Crystal Reports, Oracle Reports, Cognos, OWB, Informatica, Oracle, PL-SQL, Unix, Autosys, BCA Server, Erwin

Project R&M BIGS Execute

Role Business Objects Consultant

Customer British Petroleum

BP is one of the world’s largest energy companies, providing its customers with fuel for transportation, energy for heat and light, retail services and petrochemicals products for everyday items. BP has transformed: growing from a local oil company into a global energy group; employing over 96,000 people and operating in over 100 countries worldwide.

Period Apr 2005 to May 2006

Description This project involved design and development of reports for in-depth view of Company’s Sales and Stocks including Volume, Gross Margin, Revenue, Daily Sales report.

Responsibilities • Gathering both functional and technical requirements

• Requirements Analysis and Design

• Data Modelling

• Universe Design

• Reports Design and Development

• Involved in running sql queries in Oracle

• Unit Testing and Integration Testing

• Maintenance and Support, Documentation

• Facilitating workshops

Software BO 5.1 Web Intelligence, BO 6.5, Oracle, Informatica

Project Portal Competency

Role Programmer Analyst

Customer Infosys Technologies Limited

Infosys Technologies Ltd. (NASDAQ: INFY) provides consulting and IT services to clients globally – as partners to conceptualize and realize technology driven business transformation initiatives. With over 36,000 employees worldwide, they use a low-risk Global Delivery Model (GDM) to accelerate schedules with a high degree of time and cost predictability

Period Nov 2004 to Mar 2005

Description This project involved development of a new Identity management solution which is later offered as a product with enhanced features like improved security and integration of identities. The objective of the project is to provide an easy to use remote management console to enable Consolidation, Single Sign On, Design and Build of LDAP schema, Integration with LDAP, Integration with various applications deployed on heterogeneous platforms / environments like IIS 5/6, Apache, Netscape HTTP server, Bea web logic, integration and system testing documentation.

Siteminder, which is basically a web access control tool, was used for providing secured access to various protected resources. This was achieved by setting up of various rules for the resources and then granting access to only a desired set of authorized users. The users who were allowed access depended upon the policy deployed for the particular resource.

Responsibilities • Requirements gathering and analysis

• Integrating Site minder with IE 6.0,Apache 2.0.52

• Resolving technical issues during hosting Web-pages

• Authentication ,authorization of Web-pages

• SSO(Single Sign On) solution build

• Design ,build of LDAP schema

• Writing sample applications to connect , query, create entries

in LDAP server

• Integration with LDAP server.

• Integration and system testing

• Documentation

Software Netegrity Siteminder, Sun One Directory Server, IE 5/6 Web Server, Apache Web Server, Windows

Contact this candidate