Mifisys Swetha

Summary:

  • Around 7years of professional experience asTechnical ERP Developer/ConsultantinOracle E-Business Suite Applicationsand BI Applicationswith expertise inGeneral ledgerGL,Account PayablesAP,Account ReceivablesAR,Fixed AssetsFA,Order ManagementOM,Iprocurement and Purchasing PO, Inventory INV and Payroll.
  • OverFour yearsof experience inOBIEE Technical Consultant.
  • Extensively worked on Installation and configuration of Financials, Supply Chain Analytics, Procurement Analytics and Spend Analytics.
  • Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
  • Expertise in design, development, and implementation of Business Intelligence applications includingBusiness Analysis, Dimensional Modelling, Repository Management (RPD), Extraction Transformation and Load (ETL).
  • Proficient within the Physical Layer, Business Model and MappingLayer 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.
  • Expertisein Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and DrilldownProperties.
  • Extensivelyworked on BI Server, BI Answers, BI Dashboards andBI Delivers(iBots)
  • Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
  • 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.
  • Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite usingPL/SQL, Developer 2000, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher5.6.3/5.6.2.
  • Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
  • 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 / OBIEE10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Teradata7.2, 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 8.1.1, 7.1, 6.2, 5.1,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:

Pinellas County, Clearwater, FL Sep'10 – Till Date

Oracle BI Apps/ OBIEE Consultant

Project Description: Pinellas County wishes to conduct substantial elements of its current Financials, Procurement, Budget, Human Resources, Time reporting and Payroll operations using the Oracle E-Business Suite and Hyperion Applications. It is understood that the County plans to implement the packaged software with minimal customizations while leveraging and incorporating the Public Sector best business practices during the project. The following key objectives have been identified as the organizational ideals and goals, against which the overall success of the OPUS project will be measured.

Responsibilities:

  • Implemented Financials, Supply Chain and Procurement & Spend Analytics.
  • Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
  • Involved in installation and configuration of OBIEE, Informatica and DAC.
  • Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Responsible for configuring the Source and lookup files.
  • Experience in developing detailed steps for configuration, integration and security using Apex.
  • Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables including Physical, Logical data modeling in the OBIEE Administration tool.
  • Work with end users to identify, create, and deliver reports according to requirements.
  • Develop the overall data warehouse architecture and physical implementation standards.
  • Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
  • Administration of all components that make up the Data Warehouse and Business Intelligence infrastructure, applications and related tools including software installation, patching, configuration, monitoring, and tuning.
  • Design, create and tune physical database objects (tables, views, indexes) to support logical and dimensional models. Maintain the referential integrity of the database.
  • Develop and implement Data Warehouse, data mart techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models.
  • Diagnose and resolve Data Warehouse access and performance issues.
  • Expert in building oracle Apex Databases and Application development.
  • Customizing the existing informatica repository and adding new mappings and workflows based on the requirements.
  • Experience with Teradata Database.
  • Analyzes and develops complex Siebel Customizations, Workflows, and SmartScripts. Performs sophisticated systems analysis in the enterprise environment.
  • Extensively worked as a Techno-Functional consultant in providing CRM solution with excellent business domain experience in Siebel Telecom, Finance and Siebel Call Center, Sales and Marketing Applications.
  • Analysis, Design and Development in SQL, Informatica and OBIEE 11g/10g.
  • Developed the repository, merges the repository, performance tuning and enforcing repository best practices.
  • Expert in Oracle Warehouse management system (WMS), Oracle mobile supply chain Application (MSCA) and Oracle Inventory in functional capacity.
  • Troubleshooting and debugging of defects and production issues in the areas of SQL, Informatica and OBIEE 11g/10g.
  • Works in conjunction with System Administrators for migration, deployment and performance tuning of repositories.
  • Collaborate with Technical and Business SME’s to design the physical Data model and security model.
  • Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
  • Experience in Architecting large BI implementations over Enterprise Data Warehouse.
  • Experience with Analysis, design, development and implementation of projects for corporate Data Warehouse.
  • Extensive BI and Data warehousing experience using Siebel Analytics 7.x/OBIEE and Informatica 8.1/7.x/6.x.
  • Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
  • Translated business requirements into functional design solutions, support development, testing and release activities.
  • Created OBIEE reports & dashboards for the Marketing Operations organization.
  • Develop, test and implement complex ETL flows for the Data Warehouse using PL/SQL, Oracle warehouse builder and Oracle Data Integrator.
  • Worked with OWB 11G R2 for ETL and data profiling.
  • Created Dimension hierarchies to achieve the drill down functionality.
  • Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
  • Designed and Developed Custom Mappings, Workflows and Registered in DAC.
  • 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.
  • 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.
  • Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
  • Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.Migrated AnalyticsRPD and Web catalog from one environment to another.
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
  • Experience in designing and implementing Siebel CRM modules.
  • Technical knowledge of Siebel EAI and EIM components, including Virtual Business Components
  • Implemented the single sign on (SSO).
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
  • Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
  • 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.
  • Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
  • Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
  • Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
  • Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
  • Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
  • Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
  • Imported and Exported Execution Plan in DAC from one Instance to other Instance.
  • Involved in Integrating Oracle BI Presentation Services with BI Publisher.
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
  • Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
  • Designed and Developed Sessions and Workflows.
  • Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
  • Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
  • Extensive hands-on exercises using both GUI tools and SQL*Plus provide you with the practical skills to administer an Oracle 11gdatabase.
  • Building an Oracle database.
  • Experience in modeling, designing and developing OBIEE or any other analytical applications.
  • Expert in developing OBIEE Mobile applications as BI indicators.
  • Strong analytical and conceptual skills in Database design and Development using Oracle 10G,SQL Server2005, IBM DB2, SQL, Teradata and PL/SQL.
  • Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.
  • Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
  • Created functions, procedures and triggers in PL/SQL.
  • Created mappings using PL/SQL packages to implement business rules while loading data.
  • Written test scripts to compare OLTP vs OLAP for ETL testing.

Environment: Oracle Applications R12 , General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management,Oracle Purchasing, OWB, Oracle 11g/10g/9i (9.2.0), OBAW,(OBIEE 10.1.3.4.1,EBS11.5.10,Teradata 7.2,Siebel Analytics/CRM/OBIEE/BA, RPD, Apex 4.0,ETL,Informatica Power Center 8.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor), DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 11g, MSCA,ANSI SQL, PLSQL,SQL*PLUS, SQL*Loader, TOAD, Unix(shell scripting).

Sports Authority, CO Oct'09 – Aug’10

Oracle BI APPS/OBIEE Consultant

Responsibilities:

  • Involved in the installing and configuring of Financial and Supply Chain Analytics Analytics.
  • Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
  • Extensively worked on SRs as per the client’s requirement to get the reports for the Business Analyzation.
  • Integrated OBIEE with EBS for Single Sign On (SSO).
  • Extensively worked with various re-usable tasks, workflows, worklets, Mapplets, and re-usable transformations.
  • Worked on integrating and configuring BI Publisher with OBIEE.
  • Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
  • Built Siebel Analytics 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 (create presentation catalogs).
  • Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
  • Design, code, test, and document all new or modified BI systems, applications, and programs.
  • Create, organize, and maintain metadata layer and models using Framework Manager.
  • Build and maintain Cognos Transformer Cubes.
  • Develop web interfaces, graphs, and portals for components interacting with data warehouse processes using Cognos.
  • Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system using DataStage.
  • Troubleshoot Cognos, DataStage, and all other relevant BI systems and software; performance-tune these applications as necessary.
  • Performs other duties as assigned.
  • Responsible for customizing the out of box reports and creating new reports and dashboards.
  • Developed Reports/Dashboards by implementing different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).Created Environment Variable on Unix/Linux Environment.
  • Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
  • To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
  • Expert in designing and implementing for Data Warehouse.
  • Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
  • Extensively developed mappings on various business areas in the project by employing the available Transformations.
  • Experience converting SAP BO to OBIEE.
  • Responsible for extracting Data from Oracle AppsModules & loading into stage system and warehouse system.
  • Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEEAdministrator tool.
  • Used Template, sub Template method for a creating single report with multiple Layouts.
  • Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.
  • Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
  • Imported and Exported Execution Plan in DAC from one Instance to other Instance.
  • Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
  • Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
  • Developed Custom Reports from OLTP without creating any Views or Tables in EBS Database in IProcurement, Payables and General ledger.
  • Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
  • Designed and Developed Procurement and Spend and Supplier Performance, General Ledger Dashboards in OBIEE.
  • Designed and Developed Dashboard Pages Like Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance in Supplier Performance Dashboard.
  • Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
  • Designed and developed Delete Cancelled requisitions program to delete all the cancelled requisitions in iProcurement.
  • 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.
  • Technical knowledge of Siebel Architecture, including Gateway, Siebel, Web, and Database Servers.
  • Conducted training Sessions on Informatica power center and OBIEE.
  • Designed, implemented and tested security privileges on subject areas, dashboards and reports.
  • Created functions, procedures and triggers in PL/SQL.
  • Created mappings using PL/SQL packages to implement business rules while loading data.
  • Written test scripts to compare OLTP vs OLAP for ETL testing

Environment:OBIEE 10.1.3.4,Oracle Applications R12 ,General Ledger,Account Payables, Accounts Receivable, Inventory, Order Management,Supply Chain(SCM),Service Contracts, Install Base, Oracle 11g/10g/9i (9.2.0), OWB, OBIEE 10.1.3.4.0,SIEBEL CRM/Analytics 7.x, RPD, Dashboards, Delivers.(iBots), Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix(shell scripting).

CACI,VA Apr'08 – Sep’09

OBIEE Technical Consultant

Responsibilities:

  • Created Dashboards and Answers for End user.
  • Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
  • Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
  • Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
  • Was involved in the installing and configuring of FinancialAnalytics.
  • Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
  • Developed Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
  • Developed Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
  • Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
  • Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
  • Setup Multi User Development Environment (MUDE) in OBIEE.
  • Monitored Incremental and Full load of Data through Data Warehouse Administration Console(DAC) and InformaticaWorkflow Monitor.
  • Responsible for extracting data from Oracle Apps Modules & loading into stage system and warehouse system.
  • Created and ran Sessions & Workflows to load the data into the Data warehouse.
  • Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
  • Configured and Scheduled Sessions and Workflows.
  • Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
  • Worked on multiple folders at time to meet the dead lines of the tasks.
  • Created VPD security for reports in OBIEE.
  • Designed and developed logical model in BMM in Repository.
  • Installed and Configured DAC.
  • Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
  • Imported and Exported Execution Plan in DAC from one Instance to other Instance.
  • Created custom reports in Payables in OBIEE according to user requirement.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, BI Apps 7.9.5, SIEBEL CRM/Analytics, OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, ,SQL*PLUS, SQL*Loader, TOAD, UNIX.