Shilpa Suvarna

*** ** **** *******, ********** FL 33324

954-***-****

ac7kd6@r.postjobfree.com

Summary

Over 6 years of experience working in Information Technology industry with strong focus on Business Intelligence & Data warehousing. Have experience working as a Developer, Tester, Technical Business Analyst and Project coordinator. Have experience working in all phases of software development including Requirements Gathering/Analysis, Data Modeling, Development, Testing, Performance Tuning, Maintenance, Production Support and Administration

Have experience leading multiple projects for one of the leading Hotel management companies, where managed end to end solutions using SAP Business Objects, Tableau, Informatica, Cognos, Teradata SQL, SQL server and Oracle SQL. Have good knowledge of software development lifecycle (SDLC), Project Life cycle, Waterfall, Scrum, KANBAN.

Have experience in requirement gathering, conducting (JRP & JAD) sessions, Unified modeling language (UML), development of use case models, creating system architecture design, data modeling, process flows, business modeling, gap analysis, impact analysis and Risk analysis.

Education

Degree

College/University

Masters in Computer Applications

Passed out: 2012

RV College Of Engineering, Bangalore

Technical skills

Databases

Oracle 10g/11g, Teradata 12/13/14, SQL Server 2008/12/16

Database Tools

Oracle SQL Developer, Teradata SQL Assistant

ETL/BI Tools

SAP Business Objects XIR4, Business Objects XI Administration, Informatica 9, Tableau Administration 10.3, Cognos 10/11

Defect Tracking Tools

Quality Center, JIRA

Operating systems

Windows 7/vista/XP, 2003, 2008, Linux

Awards and Recognitions

“IHG Star Award” from Intercontinental Group of Hotels (IHG) Vice President.

“Rainmaker” Award from Cognizant-EIM Travel &Hospitality .

“Rising Star “Award from Cognizant-EIM Travel &Hospitality.

Appreciation mails from the client and Onsite for Value Adds.

Relevant Project Experience

Organization: Cognizant Technology Solutions

Project #1

Title BI/ETL Developer

Client Intercontinental Hotel Groups

Tools SAP Business Objects XIR4.1, Informatica 9.6, Oracle 11g, Teradata 14

Team Size 9

Period Nov 2012 till May 2018

Client Description:

InterContinental Hotels Group is the largest hotels company in the world and has over 4,500 hotels in over 100 countries. Its brands include InterContinental, Holiday Inn and Crown Plaza. Around 3,800 of the company's hotels operate under franchise agreements, around 630 are managed by the company and 16 are owned.

Project Description:

IHG Reporting is a central platform allowing hotel and corporate users globally to locate all business data via reports and dashboards.

The tool streamlines the various channels used by hotels to locate reports and enables IHG to provide a more consistent corporate standard when it comes to the location, presentation, and delivery of reports.

Roles and Responsibilities:

Provide primary support to the BO Reports & their Universes under IHG reporting folder using incident management tool Service Now.

Report Integration and bug fixing related to integration

Coordinating with downstream application stakeholders for any environment related issues.

Provide query resolution supports for Pre-Generated Reports and Dashboards hosted over IHG-Reporting Portal.

Maintain IHG-R Security over LDAP – Addition of Roles/Users on a need basis. Coordinate with PDB team for any additional information.

Integrating & Maintaining Reports/Dashboards in IHG-Reporting Prod environment. Updating configurations when required.

Setting up and maintenance of FTP upload jobs for Pre generated Reports.

Coordinate and drive the data queries for Pre generated reports with respective business teams.

Minor enhancements are in scope based on available bandwidth.

Drive CMR process for IHG-R Production Deployments and validation of completed deployment.

Track the status, and prioritize the tickets in consultation with client contact.

Create Adhoc BO Reports to the Client as and when Requested for Analysis.

Continuous monitoring of the loads for Failures and Long Running sessions (Informatica jobs)

Primarily work on incidents or make sure that the incidents are being looked into in case of multiple failures/Long-Running sessions

Follow the Escalation process in case of any incidents related to SLA loads

Come up with probable solution approaches, Analyze, estimate and design and implement resolution of issues.

Project #2

Title Business Objects Administrator

Client Intercontinental Hotel Groups

Tools SAP Business Objects XIR4.1

Team Size 3

Period Aug 2015 till May 2018

Client Description:

InterContinental Hotels Group is the largest hotels company in the world and has over 4,500 hotels in over 100 countries. Its brands include InterContinental, Holiday Inn and Crown Plaza. Around 3,800 of the company's hotels operate under franchise agreements, the company manages around 630 and 16 are owned.

Project Description:

Providing Primary support for Business Objects Production Environment, which includes monitoring BO Servers & Cluster Monitoring, BO Content Management, Content Security and Application Security Management.

Roles and Responsibilities:

BO Content management and Migration Activities from Dev to QA to Production environments (Creating New Folders/ Categories/ Domains/ Connections etc.).

BO Server Management activities include Server Admin activity, monitoring health of the servers.

Security Management includes User/Group Administration (Creation, deletion, enable, disable, access issues).

Notifying users and key stakeholders in case of any environment outage/change.

Opening tickets and coordinating with SAP team for any product /Environment related issue.

Analyzing the problem and classifying it as platform or report/universe issues, fixing or escalating the issue to respective teams.

Provide weekend support to the users and make sure the environment is Highly Available.

Project #3

Title Business System Analyst

Client Intercontinental Hotel Groups

Tools SQL server, Quality Center 10.1, SQL, PLSQL, MS Office, Cognos, MS Access

Team Size 6

Period June 2017 to March 2018

Client Description:

InterContinental Hotels Group is the largest hotels company in the world and has over 4,500 hotels in over 100 countries. Its brands include InterContinental, Holiday Inn and Crown Plaza. Around 3,800 of the company's hotels operate under franchise agreements, the company manages around 630 and 16 are owned.

Roles and Responsibilities:

Conducting a series of interviews, gathering & analyzing requirements with the SME’s of the applications in order to create the application profile, report tracker, Process flow, business requirements, Disaster recovery plan for business Reports.

Gathering, analyzing & tracking requirements, identified the AS-IS process and documented the TO-BE process and developed the high level and low level process flow design by identifying the various organization units, resources, business rules involved in each application.

Have created a number of process improvement documents like Requirements Check List, Lessons Learnt, Issue Tracker, Best Practices, Question Log.

Conducted JRP & JAD sessions with the application team and the technology team for better understanding of the requirements and enhancements.

Assisted project manager in determining timeline and allocating resources for the project based on iterative development

Determined milestones and metrics/standards for all project phases by applying work breakdown structures and critical path analysis to organizational breakdown structures

Developed Business Requirement documents (BRD), functional requirements documents (FRD), Technical Design Document (TDD), process flow diagrams by interacting with the IT personnel, Business users & stake holders.

Worked closely with the System and database architects in order to understand the new architecture and to design the high level and low level process flows.

Involved in preparation of test plan, developing test cases and facilitated training sessions to the QA team with various business rules and data flow.

Tracking defects and rectifying errors to their closure

Project #4

Title Tableau Administrator

Client Intercontinental Hotel Groups

Tools Tableau 10.3

Team Size 3

Period Jan 2017 to June 2017

Client Description:

InterContinental Hotels Group is the largest hotels company in the world and has over 4,500 hotels in over 100 countries. Its brands include InterContinental, Holiday Inn and Crown Plaza. Around 3,800 of the company's hotels operate under franchise agreements, the company manages around 630 and 16 are owned.

Project Description:

Providing Primary support for Tableau Environment, which includes Monitoring Servers, User Management, and Application Security Management and other Day to day Admin Activities.

Roles and Responsibilities:

Responsible for handling support tickets and providing resolution within SLA.

Responsible for maintaining Tableau application server running 24x7.

Responsible for handling small Enhancements for existing dashboards.

Responsible for managing and administrating various Sites on Tableau Server.

Responsible for Server administration and performing regular maintenance activity.

Work with Business users to understand reporting requirement and provide optimal solution.

Project #5

Title BI Developer

Client Intercontinental Hotel Groups

Tools SAP Business Objects XIR4.1

Team Size 4

Period May 2015 - Oct 2015

Client Description:

InterContinental Hotels Group is the largest hotels company in the world and has over 4,500 hotels in over 100 countries. Its brands include InterContinental, Holiday Inn and Crown Plaza. Around 3,800 of the company's hotels operate under franchise agreements, the company manages around 630 and 16 are owned.

Project Description:

Loyalty member who do not have IHG Merlin Account are allowed to avail IHG employee Rate by updating their profile via Loyalty UI.

Employee Rate Eligibility Reports will help the Loyalty Program Monitoring team validate the changes and also refer back to changes if there are any fraudulent activities reported by the Hotels.

Roles and Responsibilities:

Establishing data requirements from the Business Analyst.

Formulating effort and time estimations for Report development.

Design and development of Universe.

Design and development of complex WEBI reports coordinating with onshore.

Prepare Report Specification, Report Handover Document,QA plans.

Project #6

Title BI Developer

Client Intercontinental Hotel Groups

Tools SAP Business Objects XIR4.1

Team Size 4

Period December 2014 – May 2015

Client Description:

InterContinental Hotels Group is the largest hotels company in the world and has over 4,500 hotels in over 100 countries. Its brands include InterContinental, Holiday Inn and Crown Plaza. Around 3,800 of the company's hotels operate under franchise agreements, around 630 are managed by the company and 16 are owned.

Project Description:

The email address of Loyalty member can be updated and as there was no mechanism, that records the change and who changed address. Email Fraud Audit Report will allow the Monitoring team validates the email updates for loyalty member.

The report will help the Loyalty Program Monitoring team validate the email changes and refer back to changes if there are any fraudulent activities reported by the Hotels.

Roles and Responsibilities:

Establishing data requirements from the Business Analyst.

Formulating effort and time estimations for Report development.

Design and development of a complex universe.

Design and development of complex WEBI reports coordinating with onshore.

Prepare Report Specification, Report Handover Document,QA plans.

Project #7

Title BI Developer

Client Intercontinental Hotel Groups

Tools SAP Business Objects XIR4.1

Team Size 4

Period July 2014 – December 2014

Client Description:

InterContinental Hotels Group is the largest hotels company in the world and has over 4,500 hotels in over 100 countries. Its brands include InterContinental, Holiday Inn and Crown Plaza. Around 3,800 of the company's hotels operate under franchise agreements, around 630 are managed by the company and 16 are owned.

Project Description:

Passkey is Group Reservation provider. Passkey collects and transmits the reservation via B2B gateway. The purpose of the Report “ Push Message Monitoring “ is to monitor the status of transmission from Passkey at a transaction level to enable the operations team to take appropriate action as needed.

Roles and Responsibilities:

Establishing data requirements from the Business Analyst.

Formulating effort and time estimations for Report development.

Design and development of a complex universe.

Design and development of complex WEBI reports coordinating with onshore.

Prepare Report Specification, Report Handover Document,QA plans.

Contact this candidate