EXPERIENCE SUMMARY:

• Over 12 years of professional work experience and over 5 years as Oracle BI/ERP Developer/Consultant in Oracle E - Business Suite Applications with expertise in General ledger GL, Account Payables AP, Account Receivables AR, Fixed Assets FA, Order Management OM, Iprocurement and Purchasing PO, Inventory INV and Payroll.
• Over Five years of experience as OBIEE Technical Consultant.
• Extensively worked on Installation and configuration of Financials Analytics, Supply chain and Order Management Analytics, HR Analytics, and Procurement and Spend Analytics.
• Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management and well versed with OBIA 7.9.6.1.
• Experience in Oracle Business Intelligence 11g, data modeling and reports and dashboard development. In addition, worked on Exalytics in-memory BI machine for different domains and imparted OBIEE 11g training for different project specific requirements
• Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.
• Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Create dashboards using Tableau and prepared user stories to deliver actionable insights.
• Worked on tableau reports along with OBIEE, Business Objects and Power BI queries.
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD and UTL FILE.
• Experienced in Complete Software Development Life Cycle ( SDLC) which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Involved in development of RICE objects (Reports, interfaces and data conversions, customizations, extensions) for the Oracle Applications E-Business Suite implementation across major modules.
• Designed Report Templates using XML/BI publisher.
• Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines.

TECHNICAL SKILLS:

Oracle Applications: Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator).

Developer Tools: OBIEE 11.1.17/6/5/1, 10.1.3.x, SAP Business Object, Tableau, Oracle Reports 10g/6i/4i, Oracle BI Apps 7.9.x Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer.

ETL Tool: Informatica Power Center 9.0.1,8.6.1,8.1.1, SAP Data Services, Wherescape /ODI,DAC 10.1.3.4.1

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux

Languages: SQL, PL/SQL, C, C++, C#, HTML, XML

RDBMS: Oracle 10g/9i/8i, MS Access, SQL Server 7.x, 2000

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Lead BI/OBIEE Developer (Oracle Business Intelligence)

• Design, Develop and Implement Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Work on converting reports from other Business reporting tools and legacy systems to migrate in OBIEE Analytics.
• Work on SAP Business Object and Integrations Services, and migrate reports to OBIEE.
• Work and manage offshore team and pass on the business requirements and technical specifications to develop and design the operational reports.
• Import Noetix query metadata structure in OBIEE RPD, and convert existing reports and dashboards from business objects in OBIEE Analytics.
• Responsible for Business Analysis and Requirements Collection and involved in Designing and creating Technical Specifications
• Analyze existing SAP Business Objects reports, document technical specifications, document user acceptance criteria, and assist user with acceptance testing.
• Gather requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Design, developed, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, and Repository Management.
• Configuring Interactive reports with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Create financial reports and dashboards like Balance Sheet, Trial Balance, SLA Transactions, P&L Analysis, AP and AR invoice aging and so on.
• Create Order Management, Billing, Service contracts and Shipping modules data marts and reports.
• Create custom reports and dashboard for executive managers.
• Write T-SQl queries using CTE and store procedures to connect and publish reports using Power BI queries.
• Created Power BI Queries using SQL Server to connect and Configure the changes and source to prompt the values for big data extract reports.
• Working with business users to have them test and validate reports during development phase, UAT, Mock C, Cutover and Production migration.
• Manage the client relationship, address client requirements, meet the projects specifications and deadlines, and ensure client satisfaction
• Direct the project team through the full system development lifecycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation, and support & assigning work.
• Conduct reviews of team projects on a routine basis, sought information about completion obstacles, and aligned teams as necessary or managed customer expectations as necessary
• Promote reports from Dev to Stage and from Stage to UAT environments and involve in support plan for release and go live dates.
• Possess strong technical/functional skills, including SQL and PL/SQL.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Work on creating tableau reports along with OBIEE and Power BI queries for certain set of users using TDS files.
• Identify problematic areas and conduct research to determine the best course of action to correct the data and ongoing issues.
• Work and implementing the financial/accounting principle modules to support day to day retail activity for the project.
• Write Complex T-SQL Queries to give data dump to users, used CTE statements or created views to reuse complex calculation in SQL queries.
• Designing/Developing Reports, Dashboard, Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Working on Oracle Business Intelligence Enterprise Edition (OBIEE) 11g application tools and Oracle ERP development concepts.

Confidential, Seattle, WA

Lead OBIEE Developer (Oracle Business Intelligence)

• Working with Business Groups to identify, analyze, and document Business Requirements.
• Gather requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Designing, Developing and Implementing Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Involved in upgrading Oracle 11i to R12.
• Managing critical business changes whenever necessary in short notices.
• Working closely with business to identify potential improvement plan for the company.
• Working with business users to have them test and validate reports during development phase, UAT, Mock C, Cutover and Production migration.
• Designed and Developed Data model for core Financial Analytics module.
• Configured Financials, Order Management and Procurement & Spend Analytics.
• Customized Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger.
• Customized Dashboard pages like AR Balance, Payments Due, Invoice Details and AR Transactions in Receivables.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Convert the FSG reports in OBIEE and all the management deck reports using custom groupings.
• Create Balances and Sub-ledger details dashboard reports to help during close and reconciling.
• Design and develop AP Invoice listing, AR aging & bucketing along with FA depreciation and mass additions reports and dashboards.
• Recreate FSG and Oracle Seeded reports in OBIEE 11g and test the data against Oracle 11i and R12 reports for comparison during upgrade process.
• Created many Reports / Dashboards using various Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector) with global and local Filters using OBIEE.
• Created Star Schema and Custom Subject Area in OBIEE RPD for Financial Analytics module.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Did reverse engineering for the data sources and targets.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Manage the client relationship, address client requirements, meet the projects specifications and deadlines, and ensure client satisfaction
• Direct the project team through the full system development lifecycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation, and support & assigning work.
• Worked in SCRUM and agile environments to meet project specific deadlines.
• Configured Interactive Dashboards with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)

Confidential, Seattle, WA

Senior OBIEE Developer (Oracle Business Intelligence)

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Designed and Developed BI specifications for core Retail Sales/Inventory Management module and working with business users/groups to identify, analyze, and document business requirements.
• Working on Oracle Analytical Workspace Manager (AWM) OLAP Cubes/Microsoft SSAS cubes to import in OBIEE and Design the rpd based on business user’s requirements.
• Worked on Exalytics suite and OBIEE in general. Developed tools including gdb scripts and code instrumentation to aid in diagnosing stress related issues in the OBIEE server suite to debug numerous crashes, memory leaks and memory corruption bugs.
• Created Star Schema and Custom Subject Area in OBIEE RPD for Analytic Center - Global Retail Sales Summary and Transaction Detail project for (Asia, Europe and North America regions)
• Configured Interactive reports with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Working on complex reports, Union reports and creating & executing report requirement from multiple subject areas.
• Working on creating dashboards and enhancing existing one as well.
• Possess strong technical skills, including SQL and PL/SQL.
• Worked with Admin team in connecting ETL to Exadata and Exalytics.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Working and implementing the financial/accounting principle modules to support day to day retail activity for the project.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Designing/Developing Reports, Dashboard, Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Implemented Financial, Procurement, Supply Chain Management, Demand, CRM, Retail and Spend Analytics.
• Worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)
• Working with Starbucks Business users to help and understand and resolve ETL failures issues.
• Conduct remedial End-user/Administrator training as required by Starbucks BI support staff

Environment: Oracle BI foundation with Exadata, Oracle Applications R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 10.1.3.4.1, 11G, Oracle BI Apps 7.9.6.1, Informatica Power Center 9.1.1, Oracle 11g, Exalytics X3-4, OBIEE 11.1.1.6/7, DAC 10.1.3.4.1, Toad, Linux/Windows, File-Zilla.

Confidential, Philadelphia, PA

OBIEE Developer

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Designed and Developed Custom Mappings, Workflows Online Billing and Invoice for and Registered in DAC.
• Worked with TW Business users to resolve EBS data/configuration issues that may be contributing to HR/Finance ETL failures
• Created Star Schema and Custom Subject Area in OBIEE RPD for Online Billing and Invoice.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Worked on (DAC) to schedule the Informatica jobs and metadata management and well versed with OBIA 7.9.6.1.
• Designed and Developed Data model for core Online Billing and Invoice module.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.

Environment: Oracle Applications R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 11G, OBIA Apps 7.9.6.1, Informatica Power Center 9.0.1 hotfix, Oracle 10g, 11g, DAC 10.1.3.4.1, Toad, SQL Developer, Linux/Windows, WinScp.

Confidential, Warrenville, IL

OBIEE Developer

• Worked with NEC Business users to resolve EBS data/configuration issues that may be contributing to HR/Finance ETL failures
• Worked with HR Key Business User to identify and resolve any issues unrelated to ETL process failures - data integrity or missing data
• Identifying root cause for Inventory Product Dimension and Product Catalog/Category ETL failures and work with NEC on correction actions
• Worked with HR Business Key User to determine if OBIEE enhancements are required
• Document as necessary for presentation to NEC IT management.
• Support Vizaya integration to OBIEE, on an as-needed basis. Work closely with Vizaya team for implementation and scheduling of execution plans (HR/Financials, Vizaya, COMPASS)
• Identified poor performing ETL extract/load sessions and tune accordingly (focus on longer-running extract/load tasks)
• Re-examine BI technical landscape (especially as relates to data volumes) and create a recommendation document for NEC IT management consideration
• Conduct remedial End-user/Administrator training as required by NEC BI support staff
• Educate NEC BI support staff on BI upgrade steps and considerations, with a focus on preservation on custom objects.
• Start/stop DAC services with access and the directory structure on the DAC server to monitor Unix level process and access logs
• Scheduling and monitoring of Execution Plans (HR/Financials, Vizaya, COMPASS)
• Timely identification of failures and creation of help desk ticket(s) and notification to end-users of issue(s)
• Worked on (DAC) to schedule the Informatica jobs and metadata management and well versed with OBIA 7.9.5 and upgrade to 7.9.6.1.
• Trace DAC plan/task failures into Informatica session logs
• Access/maintain all source/target databases for issue such as tablespace updates, index creation, data reconciliation processes.
• Making Sure all the data migrated to OBIEE is correct and validated for (HR/Finance)

Environment: Oracle Applications R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, HR Analytics OBIEE 11G, OBIA 79.5/7.9.6.1, Informatica Power Center 9.0.1 hotfix, Oracle 10g, 11g, DAC 10.1.3.4.1, Toad, Linux/Windows, WinScp, File-Zilla.

Confidential, LA

Informatica and BI Developer

• Setting up LDAP configuration in shared services for Hyperion security. Also designed and implemented security models for Essbase and Planning users as per the business requirements. Caching options configured and defined overall cache strategy.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to DataWarehouse (OLAP) system.
• Migrated Informatica Workflows from one instance to another.
• Maintaining user security in shared services like creating and deleting groups/users.
• Hands on experience in ETL (Extraction, Transformation, and Loading) processes using Informatica Power Center 8.6/8.1/7.1/6.1.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Implemented the single sign on (SSO).
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.

Confidential

Graduate Assistant (Part Time)

• Provide review and editing support in writing research & thesis papers and grant proposals.
• Resolve technical computer related difficulties faced by student and Professors
• Keeping computer lab in general order and help student in writing their research papers.
• Helping Professor in collecting research work and correcting papers and study materials.
• Worked with Professor on writing research and thesis paper for the university on E-business model, Airport Security, Database management, GPS navigation and iCloud applications.

Confidential

Senior Analyst/Assistant Lead

• Worked in Health & Welfare Insurance Process (NAS) part of global delivery team.
• Dealing with clients and carriers to verify and fix information about employers and their employees. Day-to-Day basis handle issues related to those groups, as it’s large in number. Every month audit a percentage of each and every client and resolve issues, if any with Business Units.
• Handling to few Projects which deals with updating Web Database, Performing Audits and Special Audits of each and every client and also to check the percentage of audits need to be performed in a month for every client and insurance plans that need to be audited. Responsible for updating client’s information and generating roster that need to be audited every month for each client.
• Generating and Preparing client status report and would send them on daily basis to client, carriers and higher management, Handling Escalations on day to day basis for every project.
• Take huddles, giving presentations for team, updating process queries, resolving any issues for the team, coordinating with Business Units, driving project in a timely & efficient way, helping & coaching the new joiners and handling team in the Team Lead’s absence
• Worked closely with the Assistant Managers to stream line audits that are to be performed and also to generate the clients that are to be audited.
• Has been rewarded with Quality of Honor for my exceptional performance, team handling abilities, streamlining process on its Audits, Database Issues and Quality. And also couple of recognitions from Business Units and Management.

Confidential

Senior Analyst

• Handling Dental Benefits queries from provider’s office.
• Handling tier II & supervisory calls regarding claims enquiry.
• As an additional responsibility handled a new joiner’s batch to train them on the product specification and mentor the performance on the floor and provided appropriate feedback.
• Prepare and maintains the Team matrices like AHT, Productivity, Attendance, Quality reports & process related MIS, APR, Weekly Status reports. And also Agent Skill Improvement Plan for the up skilled agent. (Tier II)
• Working with the management team in developing a business project plan for the process improvement.

Confidential

Sales Executive

• Worked for a renowned Confidential cellular service as a telesales executive.
• Was a Group Leader & Verification officer.
• Was a consistent performer and my responsibility was to make call backs on behalf of my team. And do credit check of the sales.
• Have monitored calls for new joiners on the floor and assisted them in improving their Process skills.