Service Data

SUMMARY:

IT professional with *+ years of expertise in Analysis, Administration, Design, Configuration, Development, testing and implementation of Business Intelligence and Data warehousing applications.

Certified Oracle Business Intelligence Foundation 11g Implementation Specialist

Certified Oracle Business Intelligence Cloud Service Specialist

Expertise in translating user requirements into functional, technical and system specifications.

Involved in end to end life cycle starting from initiating the kick-off meetings, Requirements definition, Preparation of effort estimates, handling client approvals, Solution design –Statement of Work/Business requirement documents, Coordinating UAT with the client.

Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.

Expertise in OBI Apps customization, implementation on BI, ETL fronts per customer requirements.

Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.

Executed OBIEE administrative tasks such as OBIEE server installation, code migration and user maintenance, Authentication and Authorization in Simple, Enterprise and Software Only installation methods.

Proficiency in security management of all aspects of OBIEE.

Hands on expertise in Administration and Customization Development of Business Intelligence Applications using Oracle Business Intelligence (OBIEE).

Experience in Installation and Configuration of OBIEE.

Proficient in warehouse design, OBIEE Repository, Delivers, Answers and Dashboards

Equally at ease working within a team and independently

Hands on experience in the development of all areas of OBIEE Repository

Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.

Experience in creating entity relational & dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema.

Experience in Client Management and fostering a positive working relationship.

Experience in web-technologies like HTML and JavaScript.

Experience in Database technology: Oracle & SQL Server

Experience in RDBMS database design, writing Stored Procedures, Triggers and SQL queries.

Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint, Visio).

Good communication and interpersonal skills

Ability to master new technologies very fast.

Highly motivated and eager to learn new things

Excellent communication skills in written and verbal both.

Ability to work as individual as well as in group.

TECHNICAL SKILLS

Business Intelligence

OBIEE 12c, 11g, 10g.

BICS (Business Intelligence Cloud Service).

OBIA 7.9.6/ 7.9.6.4

BI Publisher 11g, 10g.

Qlik Sense.

ETL Tools

Informatica Power Center 8.6.1/9.5.1.

ELT Tools

ODI 11g.

Programming Languages

Core Java, C++, C #, C.

IDE

Eclipse & My Eclipse.

Scripting Languages

VB Script.

Markup Languages

HTML, CSS, XML.

Database Server

Oracle, & SQL Server

Operating System

Windows XP/2000/98, Linux, UNIX.

Interactive Front-End

JavaScript, AJAX & JQuery

EDUCATION:

Pennsylvania State University, Worthington Scranton PA GPA 3.2/4.0

Bachelors of Science Information Sciences and Technology August 2014

Mumbai University (India)

Bachelors of Science in Information Technology March 2011

Related Experience:

Project: Court Analytics, Mass Court Product Role: Business Intelligence Analyst Feb 16 – Till Now

Responsibilities: (on Cloud Instance - BICS) Mar 16 – Till Now

Involve in all the requirement gathering meetings to understand the business requirement.

Responsible for creating tables into the database schema.

Using data modeler load data into the table from the excel sheet.

Built data model and add all the related tables to the data model.

Defined the Fact and Dimension table into the Data Model.

Responsible for designing the data model and creating the measures into fact tables.

Created joins between the tables, and hierarchy and the detailed grain level.

Defined the permission and the privileges to the users.

Developed Analytics Reports and Dashboards for Business Users.

Backing up the catalog after any changes made to system.

Responsible for creating an Interactive Dashboard, drill down from summary report to detailed level.

Built different kinds of report. (Graphical, Tabular, Pivot, etc.).

Create Documents for the end users.

Environment: Oracle Business intelligence Cloud Service, Oracle Database Schema - BIS50 16.1.4.0.0

Responsibilities: (OBIEE 12c) Feb 16 – Mar 16

Installation and Configuration of OBIEE 12c and the Oracle Database 12c.

Created tables into database, and import the data using Excel Sheets.

Participated in discovery phase for business requirements.

Prepared Technical Design Documents (TDD) of complete implementation of the Business Module and User Guides for the use of Siebel Analytics.

Participated in complete life cycle of the project from Project Initiation, to Development and Maintenance.

Designed repository, with complex Time Series Calculations, for prior months/ quarters/ years.

Built Reports and Dashboards for Business Users.

Responsible for the performance tuning task.

Involve to solve in QA testing and in the production issues.

Migration of OBIEE metadata files across environments

Environment: OBIEE 12.2.1.0.0, Oracle 12c, SQL, PL/SQL.

Project: Travel Analytics, Albuquerque Role: OBIEE Developer/Analyst April 15 – Jan 16

American Airlines, Inc. is a major American airline headquartered in Fort Worth, Texas. Operating an extensive international and domestic network, American Airlines is the world's largest airline by fleet size and revenue, and the second largest by number of destinations served.

Speridian took up the responsibility to create an analytical reports using OBIEE 11g. It was a completely new environment setup including installation, configuration, development, testing and deployment. It will help the travel industries to keep track of the sales and the Compensation they have provided, it will generate report in the Graphical views, bar diagrams, charts, Pie charts, etc.

Responsibilities: (on Cloud instance - BICS) Aug 15 – Jan 16

Involved in requirement gathering and interaction with end users to understand the requirements.

Identified & Created Facts, Dimensions, and Hierarchies of the business model.

Responsible for designing the data model.

Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.

Responsible for Migrate on-premises database to Cloud Service

Built Reports and Dashboards for Business Users.

Taking Snapshot/Backup the data model after making any changes.

Configured Interactive Dashboard with drill-down capabilities from summary level to detailed level.

Developed different kinds of reports (pivots, charts, tabular, pie, etc.).

Load data from Flat files into target tables in BICS.

Responsible for creating the relation between the tables, defined dimension and fact tables.

QA Testing and Preparing the assumptions and Exceptions Document

Provide on-call support to production system to resolve any issues.

Involved in troubleshooting the load failure cases, including database problems.

Trained Client site resources.

Environment: Oracle Business intelligence Cloud Service, Oracle Database Schema - BIS50 16.1.4.0.0

Responsibilities: (on Premises instance) Apr 15 – Aug 15

Installation and Configuration of OBIEE 11g.

Apply Latest Bundle Patches with installation and configuration bug fixes.

Creation of Application roles and users in OBIEE Admin console and setting permissions and privileges.

Configuration of cache management at table level for faster query performances.

Configured usage tracking for helping the development team to understand the most fired queries and generated reports.

Created system for capturing, reporting, and correcting error data.

Performed Performance Tuning tasks.

Interacting with the Business teams and executing the changes in the data.

Review peer documentation.

OBIEE training for client side resources.

QA Testing and Preparing the assumptions and Exceptions Document.

Provide on-call support to production system to resolve any issues.

End to End BIP-Siebel and OBIEE-Siebel integration.

Migration of OBIEE metadata files across environments

Environment: OBIEE 11.1.1.7.0, Oracle 11g, SQL, PL/SQL.

Project: Optima, Albuquerque Role: Associate Consultant Oct 14 – Apr 15

Optima Health is based in Virginia, Optima Health currently serves more than 452,000 members with a network of more than 15,000 providers including specialists, primary care physicians and hospitals.

Sales/Service Analytics would bring the data from Sales – Marketing OLTP application using Informatica and DAC. Build/Customize Reports, Metadata, ETL, DAC and Database objects to include Siebel with Analytics as the single solution that supports the Activities for the different Group Types. ETL Mappings and reports are customized and build in custom dashboard.

Responsibilities:

Effectively interacted with end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from source.

Identified & Created Facts, Dimensions, and Hierarchies of the business model.

Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.

Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.

Applied Cascading Prompts and Multi Level Prompts on Dashboards.

Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.

Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

Wrote Custom SQL Codes for the reports.

Applied Optimization Techniques for the better performance of the reports.

Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.

Used external tables to Transform and Load data from Flat files into target tables.

Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.

Involved in troubleshooting the load failure cases, including database problems.

Implemented Security by authenticating against the LDAP and external table.

Trained End Users and Pilot Users about OBIEE.

Environment: OBIA 7.9.5.1, Oracle 11g, Informatica 9.1, BI Apps 7.9.6.1, SQL, PL/SQL.

Project: Penn State, Dunmore, PA Role: Technical Intern May 14 – Aug 14

The Pennsylvania State University is a public, state-related research-intensive university with campuses and facilities throughout Pennsylvania. The university has a stated threefold mission of teaching, research, and public service.

Description: The Website gives the information about matches, about the team, information about the tournaments, scheduled practice timing; allow students to book the basketball court for practicing.

Responsibilities:

Updating athletic web page at www.psuscrantonathletics.com, and modernize the layout.

Keeping a record of web site hits per sport article

Updating rosters, stats and scores via web

Creating database for the Student who play for the college

Maintaining the contents on the web pages

Creating YouTube channels for events and upload videos

Create videos about campus awareness

Creating banners and flyers for the scheduled matches

Update photos on web site

Environment: HTML5, CSS, XML, JavaScript, Ajax.

Project: Victaulic, Easton, PA Role: Jr. OBIEE Developer March 11 – July 12

Victaulic is the originator and world's leading producer of mechanical pipe joining solutions and grooved pipe joining systems. Used in the most demanding markets, Victaulic innovative pipe fitting technologies and services put people to work faster while increasing safety, ensuring reliability and maximizing efficiency.

Responsibilities:

Served as Upgrade Specialist for BI Apps upgrade project in Microsoft Windows platform.

Validated prerequisites for OBIA 7.9.6.4 upgrade.

Upgraded to Oracle BI Applications 7.9.6 to 7.9.6.4

Upgraded OBIEE 10.1.3.4.1 to OBIEE 11.1.1.7.1.114.140

Upgraded to Informatica PowerCenter Version 9.0.1 Hotfix 2.

Upgraded to and Configure DAC Version 11g.

SSL Configuration for OBIEE 11g through Admin console.

Upgraded Oracle BI Repository and Presentation Catalog to the Oracle BI Enterprise Edition 11g Version.

Merged Oracle BI Applications Version 7.9.6.4 Repository With Customer Repository.

Merged Oracle BI Applications Version 7.9.6.4 Presentation Catalog With Current (Custom) Catalog.

Re- Configure integration of marketing and segmentation module for Siebel Campaigns.

Fixed Upgrade issues with the help of Oracle representative support.

Regression Tested the Oracle BI Repository Merge.

Implemented BI Security Model through Initialization block SQL method.

Patched DAC system with latest jar file to get rid of installation and configuration defects.

Configure DAC Tasks as per Informatica mappings.

Environment: Siebel 8.1x, OBIEE 11.1.1.7.0, Oracle BI Publisher 11g, Siebel Client 8.1, Siebel Tools 8.1, Oracle 11G,SQL Developer, Informatica 9.1 HF2, DAC 11g

COLLEGE PROJECT EXPERIENCE:

Lead a three member team creating a simulation of dynamic password generator for the ATM machine using ASP.NET and SQL Server 2005 on the backend.

Coordinated with team of Five & Created a Business Proposal for an Archive of Polish National Catholic Church.

Worked with a team of four creating a new graphical user interface for ITunes using Paint and Adobe Fireworks, designed a low fidelity prototype for usability testing and research to make the design more usable.

Coordinated with team project in which we produced the interface of the ATM machine using Visio and Adobe fireworks.

Created an Interface of a video player application for tablet, for kids who are not familiar with numbers. Developed with MS paint and Adobe Fireworks involved a child to get the low fidelity prototype and user testing.

Created a website for Ski Park Project using Visual Studio 2010 and Microsoft Access as a backend.

OTHER EXPERIENCE:

Junior Executive, Show Time Gallery, Staff July 2008 – Mar 2011

Worked as a Junior Executive (Duties: update customer information, answering customer service phone calls, handling customer’s complaint, attend meetings).

COMMUNITY SERVICE:

Took photographs & distributed chocolates at “Santa Parade” in Scranton 2013

Distributed food and drinks at “Independence Day”. 2008 - 2012

Participated in “Green Mumbai, Clean Mumbai”. 2008 - 2012

Raised money for Supplies, books, cloths, & food for Orphanage in Mumbai 2008 – 2011

ORGANIZATION & LEADERSHIP:

Penn State International Club – President 2013 - 2014

Blue and White Society Club, IST Club, Lion Ambassador Club – Member 2013 - 2014

AWARDS AND ACHIEMENT:

Oracle Business Intelligence Cloud Service Specialist Certification 2016

Oracle Business Intelligence Foundation 11g Implementation Specialist Certification 2016

Received Certificate for participating in Research Fair 2014

Received Certificate of Recognition as a Lion Ambassador 2014

Won Penn State Cricket Tournament 2014

REFERENCE: Available upon request.

Contact this candidate