PROFESSIONAL SUMMARY:

• Around 8 years’ of experience in Business Intelligence projects that span the full life cycle implementation of Oracle Business Intelligence (Siebel Analytics), Informatica and Data Warehousing.
• 6+ Experience with Designing, implementation and gathering the business requirements and working various Data warehouse, Transactional application, Analysis and BI.
• Five years of extensive Business Intelligence and Data warehousing experience with Kimball and Inmon Methodology using OBIEE 11g/10g, OBIA and Informatica.
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Interactive Dashboards with drill - down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Cat Objects (Dashboard, Pages, Folders, Reports) and scheduling Agents.
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE
• Expertise in creating projects and Working in MUDE environment.
• Sound knowledge of database architecture for OLTP and OLAP applications.
• Expertise in creating complex reports in Answers using various views and extensive experience in setting up Session and Repository Variables using various Initialization Blocks. Extremely strong in OBIEE Metadata development.
• Ability to create templates for Oracle BI Publisher, and deploy those templates to an Oracle business Suite instance. Expertise in creating dimensional hierarchies, Level based measures, Fragmentation content, Aggregations, and complex joins.
• Expert in Creating Security Policy in OBI Servers and by designing Projects Groups (Power Users, Analysts,) in OBI Console and adding Users to respective Groups in AD
• Experience in OBIEE DAC configuration and Used DAC (Data Warehouse Administration Console) to configure, administer, load and monitor modular data warehouse applications
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using RalphKimball and BillInmon Methodology.
• Experience with Oracle E-Business suit (EBS) upgrades and support mainly in General Ledger (GL), Account Payables (AP), Account Receivables (AR) and Order Management (OM).
• Develops, executes, and manages Customer Relationship Management (CRM) marketing activities in an organization, including e-marketing programs and strategies, campaign management, and analytics.
• Experience in creating Execution Plans, Subject Areas, Tasks and Repository Management using Data Ware House Application Console.
• Expertise in Report Bursting using BI Publisher.
• Experience in BI Apps for Sales, Service, Financials and HR Analytics.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution.
• Experience in Upgrading, Maintaining all the L3 Environments DEV/STAGE/QA
• Expertise in analyzing business issues and providing possible reporting solutions to end users.
• Experience with all phases of SDLC-Design, implement, and test phases.
• Excellent analytical, problem solving skills and a motivated team player with an excellent inter-personal skills and familiar with offshore and multi-site development.
• Strong Collaborative skills and had an excellent communication, Diagnostic, Problem solving skills.
• Strong technical background with advanced personal computer skills and experience in different operating systems.
• Ability to work independently with good work ethics and also collaborative in the team environments.

TECHNICAL SKILLS:

BI Tools/Analytics: OBIEE 11g, OBIEE 10.1.3.x,OBIA 7.9.6.4,BIPublisher, Siebel Analytics 7.8.2

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).

ETL Tools: Informatica 9.1/8.1/7.x/6.x, Oracle Data Integrator(ODI)

Database: Oracle 11g/10g/9i, SQL, MS Access

Data Modeling/Scheduling Tools: DAC(Data warehouse Administration Console), Autosys, Erwin, Oracle Designer, and Microsoft Visio

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

Oracle Tools/Utilities: SQL*Loader, Oracle Designer, SQL Developer, TOAD, Putty, SQL Navigator, JDeveloper, Oracle Developer 2000

Scripting Languages: JavaScript, VBScript and UNIX shell script

Operating System: Windows Vista, Win 95/98/2000/XP, Win NT 4.0, Linux, Unix

Knowledge: Oracle Discoverer, Oracle Warehouse Builder (OWB)

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Business Intelligence Developer

Responsibilities:

• Responsible for Working with Vendor to Setup Files and File Criteria that needed on Daily Basis for Reporting.
• Responsible to Explaining a team for Defining plans, schedules, monitors, and coordinates the activities of the team.
• Responsible to Write Python Scripts to retrieve the CSV Files from the Confidential to Confidential Internal Server.
• Responsible for Creating SSIS Packages for loading the CSV files and doing Transformations
• Designed Dataflow Tasks to load the CSV’s Both Direct and Incremental Loads. And also use multiple Transforms like Slowly Changing Dimensions, Multi Cast, Derived Column, Merge etc.
• Responsible for Analyzing and Designing the Data Model.
• Responsible to perform Unit, Performance and Regression testing to Complete Database Schema
• Installed configured and administrated OBIEE 11.1.1.7.1
• Customized Oracle BIEE Metadata Repository using SQL Server Data Source by importing some of the required objects with integrity constraints into Physical Layer.
• Worked on Key Performance Indicators (KPI) within the BI environment which can be used as the catalyst toward driving more responsive interaction between users and data.
• Responsible for Building the RPD three Layers Physical, BMM and Presentation. Creating Dimensional Hierarchies, Level Based Measures in the BMM Layer, worked on Expression Builders and Calculation Wizards to generate certain expressions.
• Involved in the installing and configuring of Financial Analytics (OBIA)
• Developed Functional Requirement Document and Technical Requirement Document for Commercial Analytics using OBIA-Siebel.
• Installed and configured OBIA with the existing OBIEE setup by merging the RPD and importing all the OOTB OBIA objects and custom columns from Siebel source.
• Modifying and managing the Informatica workflows relating to OBIA OOTB objects.
• Responsible for Creating Aggregated Tables using the Base Fact Tables Created in the Database.
• Responsible to Set Content Level Management and Split Large Table to Small Chunks of Data to enhance Performance.
• Configured DAC and integrated it with the Informatica workflows and scheduled the full load and incremental loads for the objects required
• Responsible for designing the Security model for OBI Subject areas to restrict access to some of the sensitive data like revenue
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Developed Three Dashboards to the Upware team Executive, Sales and Ops and Revenue.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders
• Implemented data level security (Location Managers, Sales Executives etc.) using Session Variables by creating content filter in dimension table in rpd.
• Implemented object level security for both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Responsible for Creating BI Publisher Data Models to enable Interactive Reporting.
• Responsible For Creating Interactive BI Publisher Dashboards for the revenue reporting to Traverse through Fiscal Year, Quarter, Monthly Revenue based on Products
• Provided Multiple Bursting options to BI Publisher Reporting to deliver the reports to Email’s, FTP Sites, Printers and Faxes across multiple Channels
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Responsible to Lead the Meetings of Pre-Deployment Call and Acted as bridge between L3 and L2 team to have a Seamless deployment from lower level to Higher level environments
• Responsible for doing SQL Server Query banding to Eliminate Multiple Sessions Creating at the Backend

Environment: OBIEE 11.1.1.7.1, BI Publisher 11.1.7.1, SQL Server 2012, SQL Server Integration Services (SSIS) 2012, Oracle BI Apps 7.9.6.4, Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets Windows 7, Oracle Data Integrator (ODI), OBIA, Python 2.7, AWS Console 3.1, DAC 10.1.3.4.1

Confidential, Atlanta, GA

Sr. OBIEE Developer/Admin

Responsibilities:

• Understanding the Client requirements, source data, business objectives and key performance indicators.
• Installed and configured OBIEE11g in Linux/Unix Environment.
• Implemented Load balancing for High Availability in OBIEE 11g.
• Integrated OBIEE with Site minder for SSO configuration.
• Worked on web logic server for Configuring with OBIEE.
• Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details.
• Responsible to Explaining a team for Defining plans, schedules, monitors, and coordinates the activities of the team.
• Installed configured and administrated OBIEE 11.1.1.7.1
• Customized Oracle BIEE Metadata Repository using Composite Data Source by importing some of the required objects with integrity constraints into Physical Layer.
• Worked on Key Performance Indicators (KPI) within the BI environment which can be used as the catalyst toward driving more responsive interaction between users and data.
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions and managing Cache.
• Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders
• Implemented data level security (Location Managers, Sales Executives etc.) using Session Variables by creating content filter in dimension table in rpd.
• 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 object level security for both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
• Created Dimensional Hierarchies and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Created 30-35 Init Blocks using Teradata Database Query’s to Accommodate the Business Needs
• Participated in the Upgrade of Servers from 11.1.1.6.2 BP1 to 11.1.1.6.8 by applying patches for Both DEV and TEST Environments.
• Maintained MUDE Shared Drive and Responsible for Deploying Latest RPD to DEV Servers.
• Responsible for Creating Security Policy in OBI Servers and by designing Projects Groups(Power Users, Analysts, ..) in OBI Console and adding Users to respective Groups in AD
• Responsible to Lead the Meetings of Pre-Deployment Call and Acted as bridge between L3 and L2 team to have a Seamless deployment from lower level to Higher level environments
• Responsible for UAT/SIT testing with Business users and L2 teams
• Responsible for Coordinating off Shore and Onsite L2 and L3 teams.
• Responsible to Lead off Shore Development Team.
• Responsible for doing Teradata Query banding to Eliminate Multiple Sessions Creating at the Backend

Environment: OBIEE 11.1.1.7.1, Composite 6.2, Teradata 13.10.06.09, Informatica Power Center 9.5.1, Windows 7, SQL Server 2008, Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 11.1.1.3/ 10.1.3.4.1, Oracle BI Apps 7.9.6.1.

Confidential, OH

OBIEE Developer

Responsibilities:

• Worked with managers, business analysts as well as other teams to gather the business requirements.
• Customized and developed the OBIEE Business Model and Mapping layer, Implemented logical column measures and calculations.
• Implemented complex requirements like Dimensional hierarchies, time comparisons and Level based Measures along with rank measures.
• Effectively managed ODBC connections and imported the Physical tables, keys and foreign keys.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Used the Presentation Catalog and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• 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
• Good experience, and full flow of all the screens of these modules.
• Experience with workflow builder, form builder, report builder.
• Implemented caching and aggregate table techniques to improve the performance.
• Tested and validated the repository integrity with global consistency check feature.
• Worked extensively on OBIEE Presentation Services to create the reports as per the client requirements.
• Created In between dates Prompts using Presentation variables and used them in the Narrative views to show the values selected in the Prompts.
• Created, modified and formatted requests, along with charts and filters, in OBIEE Answers.
• Created a Custom Business model to report on Sales Rep and Installer Pay Stubs and Daily Commission Report. This involved creating dimensional hierarchies, Level based measures, Fragmentation content, Aggregations, and complex joins.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files according to the Business requirements.
• Managed cache and security as the part of Repository management.
• Performed Unit testing and integration testing of the reports before moving them to QA.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, BI-Publisher, Oracle EBS, Oracle 10GR2, UNIX, Toad, SQL*Plus, SQL, PL/SQL Windows XP, Oracle BI Publisher, DAC

Confidential, AZ

OBIEE Developer

Responsibilities:

• Participated in gathering Sales and Marketing Team business report requirements and identified various Key Performance Indicators (KPI’s) by meeting business users.
• Responsible for installation and configuration of OBIEE.
• Responsible for building the Repository(RPD) by importing the data, defining keys and joins(Physical Layer), defining the repository logical structure, building fact measures, performing calculations using physical or logical columns, creating dimensional Hierarchies(Business/Logical Layer) and by presenting in the Presentation Catalog/Layer.
• Involved in the development of Reports using different Analytics Views (Pivot tables, Charts, etc), Interactive Dashboards with drill-down capabilities using global and local filters.
• Configured & published Delivers / iBots to deliver analytics content based on schedule.
• Implemented OBI Security (Data Level and Object Level Security in the OBI Repository and Answers) among users and groups using Repository variables, Session variables and Initialization Blocks.
• Developed mappings, sessions, workflows and workflow tasks based on the user requirement and scheduled the workflows in workflow manager and monitor the load status in the workflow monitor.
• Based on the logic, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner transformation in the mapping.
• Configured Informatica connections source DB connection and target DB connection in Data ware House Application Console (DAC).
• Designed and added Customized Mappings to DAC and scheduled the Loads to run on regular basis.
• Imported new tables and columns from the Data warehouse, created Physical and Logical Joins, created Dimensional and Level Based Hierarchies.
• Created BI Publisher Reports using prebuilt templates.
• Created Connected, Unconnected and Dynamic lookup transformation for better performance and increased the cache file size based on the size of the lookup data.
• Performed various optimization techniques in Aggregator, Lookup, and Joiner transformation

Environment: Oracle Business Intelligence EE (OBIEE) 10.1.3.3.0, Informatica Power Center 7.1, Oracle 10g, Windows XP, Solaris, OLAP, BI Publisher Reports

Confidential

Informatica /Siebel Consultant

Responsibilities:

• Involved in meeting with business representatives for requirement analysis and to define business and function specifications.
• Identified the GAP’s by analyzing the Data mart instance and provided alternative solutions as well recommended changes to database
• 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 Mappings, Sessions and Workflows by using Informatica.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Created Pivot Tables and manipulated Initialization Blocks for report analysis
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Created templates for presenting results and Analytics modified the Siebel Dashboard using cascading style sheets.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy.

Environment: Siebel Analytics 7.x, Informatica Power Center 6.2, Oracle 9i/10g, UNIX