Manager Project

Priyanka

Phone : 609-***-****

Mail : ************@*****.***

PROFESSIONAL SUMMARY

Overall 8+ years of experience in Complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, GAP Analysis, Design / Modeling (Star and Snow flake), Development, Testing, Implementations and Documentation.

Strong technical knowledge of OBIEE Architecture.

Very strong experience in developing OBIEE / Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using page and dashboard prompts, Security Setup (groups, object and data level), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling Agents.

Experience on Multi-User Development Environment (MUDE).

Experience on EBS modules like Financial, Supply chain Management and HR etc

Implemented Usage tracking to analyze and tune the query performance.

Expertise in creating Calculation Measures and Dimensions, using Initialization Blocks and Variables (Session and Repository), adding multiple sources, executing direct Database requests, Implementing Siebel Security Setup (groups, object and data level), LDAP, External Tables, Single sign on (SSO) etc.

Executed software projects for Insurance, Healthcare and Power & water domains.

Changing parameters in Presentation and BI Server configuration files based on report requirements.

Worked on Cleanup project to reduce the size of repository and catalog by deleting unused user reports for past one year

Worked on Retirement project that reduces ETL loads twice by pointing repository and reports to original ETL tables rather than developer created customized physical tables

Bouncing the OBIEE Services such as Admin server, managed server and system components.

Business Analysis experience with excellent communication & interpersonal skills, broad understanding of business operations and requirements.

Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.

OBIEE Repository and Catalogs as well as BI Publisher reports migrations

Install, upgrade, configuration, maintenance and troubleshooting of OBIEE environments

Experience on upgrading from 11.1.1.6.8 to 11.1.1.6.12, 11.1.1.7.150120 and 12.2.1.0, 12.2.1.1,12.2.1.2, 12.2.1.4

Multi-platform experience on UNIX / Linux /AIX and Windows Server family.

Worked on User management in OBIEE, Informatica and DAC

Experience on OBIEE 12C installation and configuration

Staring & stopping of Informatica services such as Integration service, Repository service at the time of several outages.

Killing user connections/locks of PowerCenter objects.

Deploying of Informatica objects, parameter files and the scripts among different environments using Power Center manager/designer/repository manger.

Worked on four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Created mappings using various transformations of Lookup, Aggregator, Expression, Stored procedure, Sequence Generator, Router, Filter, and Update Strategy.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Experience on Informatica IDQ

Monitored Execution plan runs in DAC client and worked on issues such as making DAC server up, checking DB connectivity.

Worked on changing settings like Informatica servers, Physical data sources in DAC client.

Participated in review meetings and weekly status meetings.

Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.

Developed excellent professional skills by working independently and as a team member to analyze the Functional/ Business requirements and to prepare test plans.

Strong knowledge in data warehousing and data modeling

Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines

Excellent written and verbal communication skills.

EDUCATION: Bachelor of Technology with Information Technology as specialization from Nagarjuna University.

TECHNICAL SKILLS

OLAP/Reporting Tools

OBIEE 12.2.1.1.0, OBIEE 12.2.1.2,12.2.1.4, OBIEE 11g, OBIA, Discoverer, Tableau 9.3

ETL Tools

Informatica Power Center 9.1.0, ODI

Databases

Oracle 11g/10g/9i, Teradata, DB2, SQL Server 2008

Data Modeling

Dimensional Data, Star Schema, Snowflake, Tables, Physical, Logical

Languages & Scripting

SQL, PL/SQL, Java, J2EE, XML, HTML, C, C++

Schedulers

DAC 11g

Operating Systems

IBM AIX 7.1, UNIX, Linux, Windows 9x, XP, Windows Server 2008,2012

PROFESSIONAL EXPERIENCE

Conduent Business Solutions- Germantown MD Feb 2017 – May 2019

Senior OBIEE Consultant

Project Description:

Conduent Inc. is a technology-led business process services company headquartered in New Jersey. It was formed in 2017 as a divestiture from Xerox. The company offers digital platforms for businesses and governments. It has 85,000 employees in more than 40 countries. I work on state transportation projects like NJ Ezpass, FL Sun pass and NY Ezpass on daily basis.

Responsibilities:

• Hands on experience in OBIEE 12C installation and configuration.

• Hands on experience OBIA 11.1.1.10.2 installation and configuration.

• Hands on experience on upgrade of OBIEE 12.2.1.0 to 12.2.1.1, 12.2.1.2, 12.2.1.4

• Hands on experience on LDAP, SSL, TLS, SSO set up.

• Works on BI Publisher runtime properties.

• Works on export/import catalog objects in OBIEE.

• Participates in daily status calls, ensure project are deliverables on time.

• Works on creating RTF/PDF Templates for BI Publisher reports.

• Experience on migrating Crystal reports to OBIEE.

• Experience on performance tuning of OBIEE reports.

• Worked on application performance tuning and applying patches.

• Hands on experience on 11g to 12C upgrade.

• Hand on experience with SQL Developer & TOAD.

• Hands on experience on OBIEE 12C versions in-place & out of upgrade.

• Works on PCI remediation for OBIEE vulnerabilities reported by Security team.

• Works as CM for production RPD, Oracle BI & Catalog maintenance and migrations.

• Worked on custom configuration file changes.

• Worked on BI Publisher runtime properties.

• Worked on several scheduler issues

• Works on JIRA, ServiceNow, CMMS ticketing applications on daily basis.

• Works on user’s management for DEV/QA/PROD environments.

• Works on application database change issues.

• Exposure on Microsoft power BI.

• Worked on configuring SMTP, FTP and Printers as delivery destinations for BIP reports scheduling.

• Works with Network, Database, Linux support team.

• Works on EJB creation, deployment and server configuration to enable shared path configuration functionality to save the OBIEE reports

Outputs to Linux server paths.

• Worked on sever configuration changes like increasing the number of BI Publisher scheduling jobs count, Online reporting data size

issues and excel export more than 170k rows.

• Works on disaster recovery environment set up for NJ & FL state projects.

• Works on scripts that monitors the OBIEE services status for every 1hour.

• Worked on major server issues such as “No predefined scripts (start/stop/status) running”, “No device space left on device”, “Java heap

Size”, “Unable to run wlst.sh – No class loaded”, Services went to Admin mode.

• Works on critical server to function properly in severe stage which decided to rebuild the environment by clearing the trillions of Maps

Viewer image files which occupied 100% of INodes and mount space.

• Worked on Oracle Advanced Security settings for production databases that caused BI Server, Scheduler and Presentation services down

After application set up due to security errors.

• Worked on migration of OBIA – OBIEE 11g APPS to OBIEE 12.2.1.0.0 application.

• Worked on installation of OBIEE on Azure environment.

• Worked on image sizing and deployment on images server paths

• Leads offshore and onshore Admin Team

• Trains development and testing team.

Ricoh Americas Corporation- Malvern, PA June 2016 – Feb 2017

OBIEE Analyst

Project Description:

The Ricoh Company, Ltd. is a Japanese multinational imaging and electronics company. Ricoh's headquarters are in Ricoh Building in Chou, Tokyo. My project deals with Ricoh products sales and its related transactions on daily basis.

Responsibilities:

• Applied patches for OBIEE 12.2.1.1.0 breadcrumbs, hyperlinks enabling for non-hierarchical columns, the opening dashboard page next to hidden page makes other pages invisible, Home page VA & Go to Home Page and HTML Markup not working in migrated reports from 11g to 12.2.1.1.0 issues.

• Worked on configuration changes of Skin & Style of OBIEE & BI Publisher which has column headers wrapping, data cells spacing and prompts alignment issues by default skin of 12.2.1.1.0 version, disabling the scrollbar in all reports, BI Publisher scheduling jobs, SQL Query timeout and report data exceeded maximum limit issues.

• Worked on GO URL implementation in ActionFrameworkConfig.xml file, created a bi server variable that takes the server details of current environment and makes Action links to work without manually effort of changing the server details in all environments when we migrate the catalogs.

• Proactively worked with Oracle Support for functionalities issues in 12.2.1.1.0 and resolved them.

• Participating in daily upgrade scrum calls both with Offshore and Onsite clients, UAT calls, gathers the open issues and resolved them within estimated timeliness.

• Worked on complete instance validation and listed intended behavior changes like graphs reverse order, column header coloring in pivot, additional dashboard subpage, New Dropdown change, additional more option in dashboard properties, ability to change the Subject Area sorting in 12.2.1.1.0 version.

• Worked on creating the VA role, script to revoke the Author Role access and providing access to VA Role to restrict the VA usage to all users.

• Analyzing the performance of VA like dashboard folders taking time to open, enabling Case insensitive search and contains search by default, Multiple Queries getting triggered while performing search, cancel of a report in VA does not cancels the associated database session and provided the root cause analysis to Oracle for product enhancement.

Hitachi Consulting- Hyderabad, India Feb 2016 – May 2016

Senior Consultant

Project Description:

Hitachi Consulting Corporation is an American international management and technology consulting firm with headquarters in Dallas, Texas. My project deals with Business Intelligence & Analytics that drive insight and fuel innovation, enabling organizations to leverage the intrinsic value of all their data.

Responsibilities:

Worked on building reports in answers and placing them in dashboards and formatting changes as per requirements

Implemented RPD for Project Accounting and created the reports and worked on RPD Model Changes for different requirements.

Modified some of the existing reports and related dashboards, and fixed the issues related to reports, performance, during production support.

Worked on LDAP implementation and External table authentication.

Worked on merging Repositories.

Worked on setting usage tracking in OBIEE.

Worked on creation of repository variables and session variables.

Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.

Managed security privileges for each subject area and dashboards according to user requirements.

Designed and developed interactive navigational drill down reports in OBIEE Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.

Created connection pools, physical tables, defined joins in the physical layer of the repository.

Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.

Configured Agents to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

TIAA CREF- Hyderabad, India Nov 2014 – Feb 2016

Package Solution Consultant

Project Description

Teachers Insurance and Annuity Association – College Retirement Equities Fund (TIAA–CREF) is a Fortune 100 financial services. Organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. Worked on multiclassing for Proxy, CEW Retirement and Bus Reporting & Scorecards 2016 projects. In multiclassing for Proxy project, the CREF Proxy and TIAA Advisory Vote Application to accept additional CREF classes that will be available to plan sponsors and CREF Participants. Addition of CREF Revenue Credit Accounts and Forfeiture Accounts information to the current application. The CREF Proxy and TIAA Advisory Vote data is sent an external tabulator (currently computer share). TIAA-CREF provides computer share the required participant information to support a proxy event as of record date. The goal of CEW Retirement Project is to reduce the size of repository, catalog by deleting reports which has usage less than 10 times from 2014 to till date and unused subject areas in which no reports built on them. The objective of bus reporting & scorecards 2016 project is OBIEE Repository, Catalogs, BI Publisher reports migrations and replicating user’s repository changes from pre-production environment to Disaster Recovery and Production.

Responsibilities

Worked with Business Groups to identify, analyze, and document Business Requirements.

Migrated and merged OBIEE Repository.

Server Space management as per the need.

Worked on creation of weekly reports on change requests, service requests, incidents and problem tickets.

Extensive experience on Service now and ALM tools

Bouncing the OBIEE services to support quarterly Linux servers patching.

Worked on configuration file changes according to developer requirements.

Worked on Cache management and created automation scripts for cache purge.

Worked on 12C installation, configuration and upgrade.

Worked on setting up Audit feature in OBIEE.

Extensive experience on performance tuning.

Provided extended production support based on the demand and complexity of the issue.

Implemented Over all security, SSO, OBIEE content and Data level security.

Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.

Experience on configuration file changes for user requirements.

Worked in End to End construction of the BI model from repository to reports development.

Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, guided navigation, customization, graphs, conditional formatting of reports to satisfy the end users.

Designed and developed physical, logical and presentation layers of the repository with new data model changes.

Developed dimensional hierarchies to facilitate the drill down and report navigation.

Customizing the Look and Feel of OBIEE Application as per the requirements using CSS style sheets.

Created connection pools, physical tables, defined joins in the physical layer of the repository.

Creating column level prompts, page level, global prompts in answers and dashboards.

Configured Bi Scheduler and created agents to schedule and deliver Analytics content to multiple delivery destinations

Enabled Usage Tracking to monitor the usage and performance of reports.

Worked on MUDE (Multi User Development Environment) in OBIEE.

Worked on External table authentication.

Worked on writeback functionality.

GE Power & Water- Hyderabad, India Feb 2012 - Nov 2014

Software Engineer

Project Description:

GE Power is a world leader in power generation and water technologies for utilities, independent power producers and industrial applications. GE portfolio includes gas and steam turbines, distributed power, wind and renewable energy, nuclear energy, and water processing technologies.

Responsibilities

As an OBIEE Administrator, was responsible to deal with,

Design and implement data in various layers including physical, business and presentation.

User management like creation, deletion of users and groups and assigning roles to them.

Maintains overall security, SSO, OBIEE content and Data level security.

OBIEE Repository and Catalogs migrations.

Server space management for various log file, cache files, back up files.

Monitoring the overall OBIEE usage on server and capture the usage spikes to improve the performance.

Changing parameters in Presentation and BI Server configuration files based on report requirements.

Bouncing the OBIEE Services such as Admin server, managed server and system components.

Assess production faults and critical issues followed by identification of the root cause

Daily monitoring of OBIEE Services on servers.

Develop and implement strategies, policies and standards for OBIEE administration solutions in the enterprise.

Work in collaboration with development and software support team

Deal with on-shore and off-shore clients and ensure project delivery on time.

Extensive experience on Service Now tool.

Worked on setting up Auditing and monitoring in OBIEE.

Worked on several changes request, problem and incident tickets for OBIEE report and data issues.

Experience on upgrade of 11.1.1.6.8 to 11.1.1.6.12 and 11.1.1.7

Prepared Weekly reports to present to client in status meetings.

Created automated scripts for cache management in Dev, QA and Production environments.

Worked on LDAP Authentication.

Resolved all critical issues within SLA.

Worked on enabling usage tracking in all environments.

Research and remain abreast with latest technologies and techniques to recommend new changes or upgradations

Prepare documentation and communicate the status of the project to the management.

As an Informatica/DAC Administrator, was responsible to deal with,

Creation, modification and Access of Users, Folders and Connections.

Maintaining all level of securities for all Repositories

Responsible for the Administration of Informatica Server, User Administration.

Staring & stopping of Informatica services such as Integration service, Repository service at the time of outages.

Killing user connections/locks of PowerCenter objects.

Deploying of Informatica objects, parameter files and the scripts among different environments using PowerCenter manager/designer/repository manger.

Creation of Connections from the Informatica level. Creation of Oracle, Teradata, ODBC, SAP, Sales force and Sybase connections.

Scheduling using Informatica PowerCenter Manager

Fixing the issues related to database/connectivity/code while monitoring the loads by checking the logs and taking necessary action. Involving DBA/Support teams if needed to work together and fix the issues quickly

Checking the mount points space, server memory utilization and take necessary action to maintain the better performance

Take the. profile backup for maintaining safety & adding the new entries during new installations.

Solving tickets and working with the Dev/support teams to help them completing the projects in time.

Responsible for the Quarterly outage of recycling the servers by sending communication to the business and working along with the DBA and server teams during the outage and bounce the applications accordingly.

Monitoring of Execution plan runs in DAC client and taking necessary actions such as making DAC server up, checking DB connectivity.

Changing the various settings like Informatica servers, Physical data sources in DAC client.

As Java Developer

Responsibilities

The OPPM tool tracks the compliance of activities of associates of Tech Mahindra assigned to GE like background verification details of associates, governance exam details, project on-boarding, off-boarding details, GE specific ID creation and deletion etc. And finally, we have shown the compliance and non-compliance counts of activities in graphical representation using High charts technology.

Job Responsibilities:

Designed the application UI.

Participated in the DB design of the application.

Unit Testing and delivering a quality piece of code.

Handling UI components.

Involved in Integration testing.

Integrated and developed the charts in the application.

Contact this candidate