SUMMARY

• Around 5 years’ of experience in Business Intelligence projects that span the full life cycle implementation ofOracleBusinessIntelligence(Siebel Analytics) and Data Warehousing.
• 4+ Experience with Designing, implementation and gathering the business requirements and working various Data warehouse, Transactional application, Analysis and BI.
• 4+ 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 designingcustomized analytical reportsand creatingInteractive Dashboardswithdrill-downcapabilities using OBIEE
• Expertise in creating projects and Working in MUDE environment.
• Expertise in creatingcomplex reportsin Answers using variousviews and extensive experience in setting up Session and Repository Variables using various Initialization Blocks. Extremely strong in OBIEEMetadatadevelopment.
• 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
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using RalphKimball and BillInmon Methodology.
• 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 businessissuesand providing possible reportingsolutionsto 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 withoffshoreandmulti-sitedevelopment.
• 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,BI Publisher, Siebel Analytics 7.8.2

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

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

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

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

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, Bentonville, AR

OBIEE 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 Amazon Web Services 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)
• DevelopedFunctional 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 , 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

Confidential, Auburn Hills, MI

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.
• 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.
• Created 30-35 Init Blocks using Teradata Database Query’s to Accommodate the Business Needs
• 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 , Teradata 13.10.06.09 , Informatica Power Center 9.5.1, Windows 7, SQL Server 2008 Oracle 11G

Confidential

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.
• 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, Oracle EBS, Oracle 10GR2, UNIX, Toad, SQL*Plus, SQL, PL/SQL Windows XP