Ashok Mulpuru

Systems Integration Sr. Advisor

: ac0j1a@r.postjobfree.com : 732-***-****

Summary:

Over 8 years of overall IT experience in all phases of SDLC methodologies.

Expertise in implementation and development of end-to-end BI solutions following standard OLAP methodologies using all components of Oracle Business Intelligence (OBI EE).

Strong experience in implementing OOTB OBI Applications: HR and Financial Analytics.

Strong experience in administration of end-to-end OBI application (Weblogic/Ent Manager/BI Server)

Expertise in BI upgrades, applying patches and application monitoring scripting.

Expertise performing administrative tasks of migrating repositories of OBI EE, Informatica and DAC between various environments like DEV, SIT, UAT and PROD.

Expertise in configuring application security (LDAP), setup Object and Data level security, configuration of Multiuser Development Environment (MUDE) and Usage Tracking.

Experience in interacting with business in scoping new requirements and participate in end to end delivery of the project.

Expertise in design and development of the three layers (Physical/Business Model/ Presentation) of OBI Repository using Oracle BI Administration Tool.

Expertise designing Metadata objects, Variables (Repository /Session /Presentation), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Analysis/Answers (ad-hoc querying, reports), Delivers (iBots) and administering Web Catalog Objects (Dashboard, Pages, Folders, Reports).

Experience in creating aggregate tables, table partitions, indexes and cache management.

Vast Experience in implementing and configuring pre-built OOTB Analytics (Financials, HR, and Supply Chain) and configuring Informatica and DAC.

Underwent training in the new Oracle BI Application stack 11.1.1.10.2 – which added skills implementing BI Applications 11.1.1.x with ODI 11g.

Performed proof of concepts for client using BI application stack 11.1.1.10.2 for Fixed Assets analytics

Hands on experience on various reporting tools – Tableau, SSRS, Power BI, Business Objects.

Proficient in defining key metrics, dimensions, hierarchies and building Star and Snow flake schemas.

Upgrade and Deployment experience from of various versions of OBIEE (10g to 11g)

Experience in integration of BI Publisher with BI server and building rtf reports

Expertise in extracting data from OLTP sources and loading them to OLAP systems.

Expertise using DAC to administer and monitor various ETL routines and design complex DAC metadata.

Proficient in ETL processes of creating Source/Target definitions, building Mappings/Mapplets and creating and monitoring Sessions/Workflows.

Extensively worked on Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Expertise in performance tuning of BI Repository, Reports, Informatica Mappings/Mapplets.

Multi Environment working experience – UNIX/LINUX, Windows.

Experience in performing production support activities.

Team player and a self-starter with excellent communication, analytical and interpersonal skills.

Technical Skills:

BI Tools:

Oracle BIA 11.1.1.x/7.9.x, OBI EE 12c/11g/10g, BI Publisher, Tableau, Power BI

ERP:

Oracle e-Business Suite R12.x/11i (HR, GL, AP, AR, Fixed Assets)

ETL Tools:

ODI 11g, Informatica 9.x/8.x/7.x/6.x, DAC 11g/7.9.5

Database:

Oracle 11g/10g/9i/8i, DB2, Exadata, IBM Netezza, MS-SQL Server, MS-Access

Dev Languages:

SQL, PL/SQL, Korn Shell Scripting

OS:

RHEL,HP-UX, Windows XP/2000/NT, Sun Solaris, MS-DOS

Education:

Masters in Computer Engineering, NJIT, NJ

Professional Experience:

Owens and Minor, Mechanicsville, VA

Sr. Application Lead / Administrator June’11 –Till Date

Project: SRI Analytics Industry: Healthcare Services

Owens & Minor is the nation’s leading distributor of medical and surgical supplies to the acute-care market and a leading provider of healthcare supply chain management solutions. OMNI BI Analytics has been implemented to create Financial and HR Ad-hoc and Operational reporting to analyze the Business performance and HR performance.

Responsibilities

As an application specialist, worked on SDLC of various version of OBIEE.

Actively interacted with customers to gather the functional requirements and configured the BI application to populate the data warehouse as needed for reporting.

Participated in end-to-end implementation process of the upgrade project of OBIEE 10g to 11g and BI applications from 7.9.5 to 7.9.6.3

Upgraded DAC 10g to 11g on all environments

Upgraded the 10g production rpd to fit the needs of new 11g BI application.

Involved in training activities on new environment to the client so as to give an overview of the new system and teaching them the capability to create new reports and how they get the enhanced features of 11g reporting.

Developed the RPD based on enhancement requests (GL Real time, Annual Incentive, GL Costing)

Installed various upgrade patches in OBIEE 11g environments

Developed Custom reports (Finance and HR) and did enhancements to the OOTB reports per client requirement.

Designed the security (row level and object level) for the BI application.

Expertise in design and development of DAC tasks/subject areas/execution plan/container specific SQLs/custom table and index analyze scripting/complex dependencies.

Implemented well maintained Remedy ticket system and on-call support activity for the team.

Monitored the daily ETL activities in PROD, TEST and DEV and involved in Full load to Incremental conversion project in Informatica.

Worked with Oracle/Informatica Customer Support to fix the bugs and apply the patches.

Implemented OBIEE 10g / BI Apps 7962 prototype in sandbox for customers to identify the added benefits of new version of BI Apps.

Creating Analyses and Dashboards, created iBots/Agents, created BI publisher reports in OBIEE11g.

Active administrator for maintenance of all new OBIEE 11g environments (DEV/TEST/PROD) and taken care of all required security in new environment.

Auditing of OBIEE user-license using AD scripting, to ensure we haven’t capped the licenses.

Setup and administered Usage Tracking using the direct insert process.

Created action links for accessing the e-BS content from Oracle BI application.

Administered Weblogic deployments, security maintenance in Weblogic, RPD and Web Catalog migrations, DAC and Informatica deployments, maintenance of user’s roles for the application access.

Point of contact for business users for any issues/ enhancements/ new requests.

Involved in day-to-day support activities of the application

As the team lead for the application, have worked with offshore team for day-to-day activities

Actively participated in requirement gathering meetings with client for new enhancements and reports.

Environment: OBIEE 11g/10.1.3.4.1, Oracle BI Apps 11.1.1.10.2/7.9.6.3/7.9.5, Oracle e-BS R12/11i Weblogic, Finance/HR/Fixed Assets Analytics, Informatica 9.x/8.6, ODI 11g, DAC 11g/10.1.3.4.1, Red Hat Linux, Windows Server/XP

Baylor Scott White Health, Dallas, TX

BI Analyst May’16 –Jul’16

Project: BI Tool Assessment Industry: Healthcare – Hospitals

As the largest not-for-profit health care system in Texas and one of the largest in the United States, Baylor Scott & White Health was born from the 2013 combination of Baylor Health Care System and Scott & White Healthcare. Today, Baylor Scott & White includes 48 hospitals, more than 1,000 patient care sites, more than 5,500 active physicians, over 44,000 employees and the Scott & White Health Plan.

BI Tool Assessment project was a short term project to analyze the various reporting tools at BSWH and come to a conclusion of one BI reporting platform.

Responsibilities

•Analyze the 7 BI Tools (OBIEE, Cognos, Tableau, SSRS, SAS, Microstrategy and BO) and gathering details for consolidation

•10 Functional areas (BSWQA, Quality, Nursing, Finance, HealthPlan, HTPN, CTX EMR (Epic), NTX EMR (Allscripts), Transplant and Data Warehousing) are considered for analysis.

•Gather and understand Current reports Inventory, Usage Patterns, Complexity distribution by LOB and Reporting Platforms

•Analyzed up-to a total of 4000 reports (across platforms) for Metadata analysis and metadata driven rationalization analysis and recommendations

•Participated in a total of 12 interviews/workshops, with around 10 stakeholders from business and IT and up to 12-15 additional people for surveys

•Understand the main data sources and data issues for EDW

•Understand key business priorities and expectations from reporting, information consumptions from EDW

•Gather existing and planned business use cases, corresponding data needs (Top 6 existing business use cases and up to 20 KPIs are considered for analysis )

•Performed thorough analysis on - where and how the BI tools are currently used, purpose and benefits, gaps in existing data integrations with EDW, data issues, gaps between existing BI capabilities and future state needs.

•Deliver high-level effort required to migrate off other BI tools and onto a standard existing tool for IDW reporting.

Environment: OBIEE, Cognos, Tableau, SSRS, SAS, Microstrategy, Business Objects, IBM Netezza, Oracle, SQL Server, Red Hat Linux, Windows Server/XP

California State University Chancellor’s Office, Long Beach, CA

OBIEE Administrator/Developer/Production Support Aug ’10 –May’ 11

Project: CFS/CMS Analytics Industry: Education

The California State University (CSU) is one of three public higher education systems in the state of California. The CSU system is composed of 23 campuses and has over 417,112 students supported by 47,000 faculty members and staff. The primary goal of the Common Financial system implementation project is to produce a fully configured, enriched, common baseline prototype built on a single database platform and deliver a financial reporting solution via a data warehouse, along with the production support of the current Analytics project.

Responsibilities

Conducted interactive sessions with the business users in order to understand the legacy reports and then build the OBIEE reports.

Involved in all production support activities for the existing phase 1 project that’s in production.

Production support involves – on call support for end user’s issues, troubleshooting and fixing the issues,

Enhanced existing Oracle BI Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level.

Created multiple connection pools, imported physical tables and then created aliases.

Created the TRAINING environment for end user training, with multiple connection pools and applied security for connection pool based on the user login.

Developed dimensional hierarchies, aggregate tables, level based measures in the BMM layer.

Implemented the Bulletproof Single Sign On process so that users can navigate from the portal to the OBIEE dashboard.

Enhanced different levels of security using Initialization blocks, system session variables and Non-system session variables, implemented ‘Group’ level security over the RPD.

Customized the dashboard banner and created reports with features like Column selector, View Selector, Pivot table, Guided Navigation.

Implemented the BI Publisher from scratch and integrated that with OBIEE SSO.

Gathered the requirements for BI Publisher reports and developed the templates and reports.

Implemented the scheduler for BI Publisher reports so that end users can select the parameters for the report and schedule the report.

Participated in new data mart design and used Visio for designing the data model.

Created reports/supported existing reports with different types of prompts and effectively used the presentation variable feature.

Implemented BI Delivers (Ibots for Cache seeding), Usage Tracking.

Migrated Web Catalog objects using Catalog Manager from DEV/TEST/PROD.

Documented all the development and Admin tasks that have been performed.

Participated in all end-end meetings and involved in assisting the Business Analyst in documenting the requirements as well.

Environment: OBIEE 10.1.3.4.1, PeopleSoft Financials, Data Stage, Windows 2003 Server, Windows XP

Zebra Technologies, IL

Sr. OBIA / OBI EE Consultant Apr ’10 – Jun’10

Project: Merlin Gold Analytics Industry: Computer Hardware Manufacturing

Zebra Technologies Corporation provides the broadest range of innovative technology solutions to identify, track, and manage the deployment of critical assets for improved business efficiency. Zebra’s core technologies include reliable on-demand printer and software and hardware solutions. The Project Merlin Gold Analytics was a Phase 3 implementation of Financial and Supply Chain OOTB Oracle BI Analytics, wherein I was responsible for Customization of Informatica mappings, OOTB Repository on Subject Areas: Financials – AP Balance, AP Transactions, AP Invoice Matching, and Supply Chain – Inventory Balances

Responsibilities:

Involved in Analysis, Requirement gathering, Development, Deploying and Testing.

Prepared Fit/Gap Analysis documents on requirements (based on the MD50, MD70 documents) necessary for customizations of out-of-the-box Oracle BIA functionality.

Successfully improved the performance of the Oracle BI Presentation services login and resolved Oracle e-BS SSO authentication issue of BI presentation services in SIT environment.

Successfully implemented new Custom subject Areas: Financials (AP Invoice Matching), Supply Chain (WIP Jobs, WIP Job Requirements, WIP Serial Numbers and customized existing subject areas ( AP Transactions) to create reports necessary as per the Zebra’s business users requirements to effectively run the Financial and Manufacturing operations.

Customized the OOTB Informatica Mappings and OBIEE Metadata Repository to include new Facts and Dimensions.

Customization of OBIEE Repository involved working in Physical(importing of additional Facts and Dimensions, creating Aliases, defining keys, variables, Init Blocks, Star schemas), BMM (creating of logical table sources, hierarchies, aggregates, defining complex joins, time series measures) and Presentation layers (creating of new presentation catalogs)

Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers, SmartCVS to move the RPD to Servers.

Developed and Customized Interactive Dashboards / Reports as per the business needs with various views (Pivot, Table, Charts and Column Selector), implemented Prompts (Dashboard and Page scope) to provide dynamic filter condition to End users.

Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.

Setup the visibility of dashboards to employees with respect to their responsibilities.

Provided object level security for different web groups based on responsibilities.

Administered NQSConfig, NQServer, NQQuery files for Server configurations and troubleshooting reports performance.

Worked on Oracle R12 container and Developed new SDE and SIL Informatica mappings for newly created Dimension and Fact tables and also customized existing SDE and SIL Informatica mappings and created Tasks and Workflows to fit the requirement.

Used various transformations - Source qualifier, Aggregators, Connected and Unconnected lookups, Filters and Sequence Generators for mappings based upon the requirement.

Added new tasks to DAC and synchronized the tasks to informatica tasks, created subject areas and assembled them in DAC, successfully built execution plans by creating them and generating parameters.

Maintained the Full and Incremental loads through DAC on different environments like Development and Test environment.

Worked closely with the Business users, Administrators and resolved issues that arise from SIT and then pushed the reports to Production.

Created comprehensive documentation for entire development and customization that’s done.

Environment: Oracle BI Applications 7.9.5, OBIEE 10.1.3.3.3, Oracle e-BS R12.1.1 (SCM and Financials), DAC 7.9.5, Informatica 8.1, Oracle 10g, Smart CVS, Red hat Linux, Windows XP

Client: Marsh & McLennan, Hoboken, NJ

Sr. OBIEE Developer Nov’09 – Mar ‘10

Project: RMB Analytics Industry: Insurance Brokerage

Marsh & McLennan Companies is the premier global professional services firm providing advice and solutions in risk, strategy and human capital. Through their market leading brands, colleagues in more than 100 countries help clients identify, plan for and respond to critical business issues and risks.

RMB Analytics project has been started with design of Custom data warehouse on the Revenue and Management Application. This application is used by client to do the track the various metrics related to their business.

Responsibilities:

Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.

Designed and developed the Physical Layer, Business Model Layer and Presentation Layer in the repository.

Implemented Security by creating roles, web groups, external tables and LDAP.

Developed the reports based on the functional specs from user – steps involved meeting with business analyst, understanding the requirement, developing the RPD, reports and fit-gap analysis if we need new tables/columns in the data warehouse.

Created RTF/Excel templates for BI Publisher reporting.

Explored the bursting feature and implemented for a report, which requires excel file burst based on the check number. ( Remittance advice reports)

Configured the BI Scheduler and worked on iBots in OBIEE.

Involved in performance tuning of reports and interacting with DBA for table level tuning.

Developed the Technical design documents for the reports.

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle database, Informatica Power Center 8.1, Toad for Oracle, Windows Server 2003, Windows XP

Client: Ora Apps Inc, Edison, NJ

Sr. OBIEE Developer Feb’09 – Oct‘09

Project: HR Analytics

Ora Apps is a growing Information Technology Solution provider delivering innovative and cost-effective solutions for many customers. Ora Apps provides services to various clients in government and commercial organizations. Ora Apps also provide services to support the deployment, implementation and support. Ora Apps have various OBIEE and Oracle e-BS implementation projects.

Responsibilities:

Performed GAP Analysis by gathering information from various sources.

Involved in support and development of various OBIEE projects.

Used BI Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd).

Designed new Hierarchies and developed fact and dimension tables.

Designed and developed physical and logical star schema using BI admin tool.

Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.

Imported physical tables and added physical joins/keys. Also created new logical table tables.

Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.

Modified presentation layer dimensions and attributes to match user requirements.

Created global filters, complex queries, prompts and reports (charts, tables, graphs) in Answers.

Setup and administered Usage Tracking using the direct insert process.

Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.

Configured repository and session variables to get dynamic reports and dashboards.

Used Catalog Manager to maintain Analytics web catalog (migrations and setting permissions).

Using Security settings in Admin Tool created SSO, users, groups, access and query privileges.

Peer review of code, testing, monitoring NQSQuery and tuning reports.

Developed Informatica Mappings and Mapplets to build key interfaces using transformations for loading the data into data warehouse.

Monitored ETL runs in Workflow monitor and scheduled the execution plans for ETL runs.

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle e-BS 11.5.10,Oracle database, Informatica 8.1, Toad, Windows Server 2003, Windows XP

Client: Friendly Consultants, Princeton Junction, NJ

Software Developer – CPT Feb’08 – May‘08

Project: BIRP

Friendly Consultants is focused on helping its clients to fill their technical staffing needs by accurately providing experienced and qualified software professionals. Friendly consultants can also take complete responsibility of a project, including project management and managing the entire development life cycle.

Responsibilities:

As a part of Curricular Practical Training (CPT), undergone training in the fields of interest (SQL and Data warehouse design) and Oracle Business Intelligence reporting tool.

Installed and configured the OBIEE and Informatica tools and explored all the features of the tool.

Configured the BI applications to run the test loads and validated the e-BS data to OBIEE data.

Actively participated in ongoing project on OBIEE implementation and involved in SDLC of the project.

Developed Custom reports with various features of the tool ( Various views/ guided navigation/ links/ sections/ iBots/ BI publisher reports/ Scheduler/ Security)

Created new logical columns using expression builder to meet the report requirements.

Created User Groups in Analytics repository and modified the Dynamic Session Variables and configured security at the repository and catalog level.

Completed Oracle SQL/PL SQL developer certification from Oracle.

Participated in business requirement meetings with the client.

Environment: OBIEE 10.1.3.x, Informatica 8.1, SQL/PL SQL, Oracle 10g,

Client: NJIT, Newark, NJ

Assistant to Systems Administrator Jan’07 – Dec’07

Project: Infrastructure Maintenance

Responsibilities:

As a part of student life while doing the masters in Computer Engineering at NJIT, got a great opportunity to work part-time on-campus.

Work includes troubleshooting various computer and printer problems, hardware repair, installations of Windows, Linux and SUN OS and new software, managing domains and user accounts, troubleshooting LAN problem

Also designed a custom application using database to track the inventory and to track the work orders received on daily basis, as a part of interest.

Environment: Solaris, Windows XP, Windows Server 2003, SQL/PL SQL, Oracle 10g

Contact this candidate