Sr. Obiee / Etl Lead Resume
Houston, TX
OVERVIEW
- A software professional with 10 years of IT experience, including 5+ years of Team Lead experience, with emphasis on DW&BI space.
- Ability to plan and manage projects aligning business goals with technology solutions. Has managed large teams and delivered complex engagements while performing various roles ranging from Project Manager, Team Lead, Solutions Architect, and Developer.
- 8+ years of experience in complete life cycle implementation of Enterprise Data Warehouse & Business Intelligence systems and processes. Strong experience in Data Warehouse design, Dimensional Modelling, ETL (Informatica & DataStage) / OBIEE 11g / 10g Development & Administration.
- Strong expertize in Implementation, Configuration and Deployment of Oracle BI prebuild analytics (OBIA – HR, Supply Chain Management, Inventory Analytics, Order Management), as well as customized BI solutions (OBIA – Finance, Accounts Payable, Receivables, Collections) tailored to Customer Requirements.
- Experience in integrating ERP solutions such as Oracle EBS, JDE 9.1, PeopleSoft to data warehouse and finally to BI dashboards.
- 5+ years on BI and Informatica administration such as setting up Security, creating users, groups, and roles / Monitor server performance, BI clustering / Space constraint issues / ETL jobs and BI Report Performance issues.
- Extensive experience in developing BI metadata (RPD), building reports & dashboards, BI Publisher reports, and creating & scheduling Agents / Ibots.
- Strong experience in Administration and Performance enhancement of data warehouse / debugging performance issues at database, ETL and BI reports.
- Proficient in working with multiple databases such as Teradata V2R6, Oracle 11g, SQL Server 2010, DB2, and Informix.
- Strong expertise in ETL tools such as Informatica / DataStage. Extensive experience in creating Informatica mappings / workflows, and schedule them using DAC
- Strong expertize in setting up DAC, integrate with Informatica and database servers, configure metadata, and create Subject areas / Execution plans.
- Experience in implementing Informatica CDC (Change Data Capture) on JDE XE to capture incremental data.
- Strong knowledge on database development, PL/SQL scripts, Stored Procedures, Triggers, Packages, Functions, and performance tuning techniques such as creating indexes, materialized views, parallel hints, partitioned tables, database compression techniques and etc.
- Expert in Iterative, Agile and Waterfall Project Management methodologies. Significant experience in all phases of the Application Lifecycle Management – Build, Deploy, Transition, Stabilize & Optimize
- Excellent communication skills, Ability to bridge gap between Administration and Technical teams. Leverage technical, functional and business acumen to communicate effectively with client executives and respective teams. Excels in building effective teams and keeps them motivated.
TECHNICAL EXPERTISE
BI Tools: OBIEE 11g/10g, OBIA 7.9.6, BI Publisher, Tableau 7, QlikView
ETL/Data Modeling tools: Informatica 9.5.1 / 9.1 / 8.6.1 , DataStage 8.1, SSIS
Database: Teradata, Oracle, SQL Server 2005/2008, Informix, DB2
Operating Systems: AIX, SUSE Linux, OEL, Windows
Project Management: Microsoft Project, MS Office.
Languages: PL/SQL, UNIX
PROFESSIONAL EXPERIENCE
Confidential Houston, TX
Sr. OBIEE / ETL Lead
Confidential, Oil and Natural Gas Service Company, provides products and services for drilling, evaluation, completion, production and intervention of oil and natural gas wells, along with pipeline construction and commissioning.
List of Projects at Confidential : Upgrade from OBIEE 10G to 11G / OBIA Supply Chain Management Analytics (Oracle EBS) / OBIA Human Resources Analytics (PeopleSoft) / Order to Cash (JDE) / Accounts Payables, Receivables, and Collections / Enterprise Asset Management / JDE Upgrade (XE to 9.1) / DataStage 8.6 to Informatica 9.5.1 Conversion / OBIEE 10g to 11g Update & High Availability setup
Responsibilities:
- Installed, configured and setup OBIEE 11G environment on Windows server and Oracle Enterprise Linux operating systems.
- Upgraded OBIEE 10G existing reports and dashboards to OBIEE 11G.
- Designed and implemented OBIEE 11G security model. Worked on day to day maintenance and support of OBIEE 11G environments.
- Worked on integration with LDAP and Enterprise Single Sign On for OBIEE.
- Setup OBIEE vertical clustered environment to implement BI high availability, configure Security, Single Sign on, monitor BI traffic and fine-tune BI environments by increasing CPU, Memory, Space, and etc.
- Installed and configured BI on multiple virtual machines to cater multiple needs such as, a separate environment for POCs, a separate environment for Staging environment and etc.
- Setup Multi User Development (MUDE) for parallel development and debug any issues related to Multi User Development. Created scripts to automatically deploy MUDE RPD to Development RPD and backup of catalog every day, and purge any objects that are older than 7 days.
- Created custom made cache purge and cache seed scripts to automatically purge and seed cache after the end of Daily ETL loads. This will ensure no stale data is present in reports and automatic seed will ensure to have optimal performance.
- Migrate RPD from DEV to QA to PROD using three way Merge / Patch Merge, and through scripts.
- Worked with Oracle consultants to perform patch installations and upgrades from OBIEE 11.1.1 to OBIEE 11.1.8
- Created scripts for automatic database backups for 7 days and restore whenever required.
- Analyzed customer requirements and provided roadmap for BI implementations. Worked with executive management to gather requirements and created Business Requirement Documents, High Level and detailed technical documents, Project Planning, and Risk Management documents.
- Conducted gap analysis to identify gaps, Cross-functional team meetings to develop Project Plan, and On-Site / Off-Shore meetings to assign tasks to developers.
- Deployed Out of the Box OBIA SCM Analytics to provide valuable insights on Inventory (JDE 9.1 as source system) / HR Analytics (PeopleSoft was source system). Developed customized solutions for Order to Cash, Accounts Payables & Receivables, and (Enterprise Asset Management) EAM by creating datamarts and BI reports.
- Migrated to Informatica 9.5.1 from DataStage 8.6. Implemented Informatica Change Data capture against JDE 9.1 to generate Incremental data.
- Diagnosed Data warehouse, ETL, and Business Intelligence platform issues and developed cost effective solutions. Significantly worked on to enhance ETL / BI reports performance to conform to company SLAs.
- Created many customized ETL mappings using Informatica 9.1 and 9.5.1. Migrated Informatica ETL workflows using Deployment groups.
Confidential Bentonville, AR
BI Infrastructure & Administration
Confidential, multinational retail corporation, has the biggest implementation of OBIEE with more than 350,000 users with several Petabytes of data. Confidential has 4 BI environments to support its business operations – Enterprise, Stores, Merchandising, and Logistics. Each environment has 8 servers clustered to maintain high availability.
List of Projects at Confidential: Assessment of Architecture, Capacity Planning, OBIEE 11g POC, Pre-Integration, Usage Tracking Redesign, and Administration of BI Environment, POC on Tableau / QlikView.
Responsibilities:
- Worked with 18 BI administrators to monitor Confidential BI servers that were installed on SUSE Linux.
- Upgraded OBIEE 10g on AIX machines to OBIEE 11g SUSE Linux machines.
- Monitored server administration making sure all environments are up and running.
- Install and configure Weblogic Application server and configured BI to integrate with Weblogic.
- Integrate LDAP and setup security at multiple levels to achieve data security and object level security.
- Handled server startup issues, user access issues, and any performance issues such as stuck threads at Websphere, or Presentation server or BI server. Augmented existing BI capacity with increased capacity to resolve any stuck threads issue.
- Installed and configured BI on multiple virtual machines to cater multiple needs such as, a separate environment for POCs, a separate environment for Staging environment and etc.
- Investigated stability issues at Web Server, App Server, and Application and DB layers. Performed 'profiling' of current state of OBIEE Usage and identified areas of improvements.
- Stabilized the entire OBIEE infrastructure within 2 weeks by reducing issues by 85%. Coordinated with offshore and onsite teams to implement the proposed architectural changes.
- Prepared the ‘Capacity Planning’ strategy for scale up. Assisted in preparation of the ‘Data Governance’ strategy. Monthly review meetings with application teams to understand code design issues with Data Model, Repository Design, Dashboards and Reports Design.
- Involved in the Development Lifecycle of several applications in a Technical Advisory capacity to oversee the Requirements, Testing, Production Release and Post-Production support phases.
- Helped client understand the migration strategy to Oracle 11G. Performed evaluation of BI Management Pack vs in-house developed monitoring solutions. Involved in daily meetings with the client to understand reporting requirements and future trends. SME for BI Publisher.
OBIEE 11g POC – Proof of Concept to test the functionalities of OBIEE 11g (11.1.1.5) and Weblogic server (Web Sphere is the only available app server at Confidential ). POC on Tableau and QlikView to test functionalities and demo to higher management. Usage Tracking Redesign – This project is paramount to Confidential to determine BI usage and to determine capacity planning for BI servers. We developed scripts / reports that even provide CPU and memory statistics for every minute. Pre-Integration Business Intelligence: Confidential systems integration with Massmart (Africa). Worked with International Business users to gather requirements and create ETL Jobs to integrate Massmart data with Confidential .
Confidential Irving, TX
Sr. OBIEE / INFORMATICA Lead
Confidential is an American broadband and telecommunications company based at Irving, TX.
List of Projects at Confidential : HR Analytics, Workforce Scorecard, Rationalization, Real Estate Analysis
Responsibilities:
- Gathered requirements, analyzed existing source systems, and documented the Technical Design. Deployed OBIEE 10.1.3.4 on IIS server, configured scheduler services in Production servers (windows).
- Created hierarchies, level based measures, derived facts, fragmented data, and aggregated tables (using aggregate persistence wizard) in BMM layer.
- Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements. Created highly formatted reports using BI Publisher based on conventional data sources.
- Created proactive agents iBots and interactive Dashboards to alert the call center team about business changes.
- Configured and modified several mappings from multiple sources like Oracle 10g, SQL Server 2005, XML, flat files and loading data to OLAP systems.
Confidential, Overland park, KS
Oracle & BI Developer
Confidential is a United States telecommunications holding company that provides wireless services and is a major global Internet carrier.
Responsibilities:
- Supported various Process Improvement and Cost Savings initiatives through analyzing data, supporting development of recommendations, and helping with communications / implementation of change.
- Created daily reports of Network daily data sets. Involved in a conversation with regional managers to keep the files current with regional submissions and updates for the execution review committee.
- Documented all information sources and procedures for specific analysis tasks so that NSD team can use it for training purposes going forward. Tracked budget scheduling and cost accountability. Interacted with marketing business representatives for gathering the Reports / Dashboards requirements.
- Created detailed Functional Specifications Documents, including data samples, report samples, data flows, and data models.
- Designed and developed the Analytics Metadata Repository (RPD) using OBIEE Admin tool by importing the required objects with integrity constraints into Physical Layer, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating Presentation catalogs in Presentation Layer.
- Designed and developed the new Reports/Dashboards with different Analytics Views using OBIEE Answers. Worked on correlated sub queries and also used hierarchical tree structured query.
- Developed initial and incremental Informatica Mappings/Mapplets for ETL per changes in requirements.
- Created Pl/SQL packages integrating the related procedures and functions together for better performance. Performance Tuning of Dashboards/Reports by requesting Aggregate tables, Indexes Creation & re-building of indexes and managing Cache.
Confidential Dearborn, MI
OBIEE Developer
Lead Developer for an Oracle Business Intelligence implementation at Confidential Association (AAA), Michigan. AAA is a not-for-profit organization with more than 50 million members. This project was an enterprise wide initiative to create a central Data Warehouse and leverage the functionality of OBIEE 10.1.3.3.
Responsibilities:
- Worked with data feeds from National Oceanic and Atmospheric Administration (NOAA), Decision Sciences Research Associates (DSRA), PeopleSoft, Avaya CMS, Edify IVR, Hertz Rental, Cisco ICM & Contract Payment System.
- Analyzed reporting requirements for data mart, dashboards and reports & converted them into low level design.
- Responsible for Oracle Business Intelligence (OBIEE) implementation following Siebel eRoadmap methodology. Configured Fact tables, Dimension tables and Hierarchies based on the customized data model.
- Developed and maintained Data Extraction Transformation & Loading for the data mart using Informatica 8.1.1.
- Used the DAC Client to create scheduled load plans for data movement into the warehouse.
- Created customized solutions for Security layer, Multi User Development, Backup & calculating ROI. Conducted in-house trainings & Awareness Sessions for employees and internal businesses.
Confidential Houston, TX
OBIEE Developer
Confidential is an oil and natural gas company based in Houston, Texas.
List of Projects: Planned and delivered the Human Resources Data Warehouse
- Led the requirements gathering effort, analyzed the requirements, and created the scope.
- Worked with the Subject Matter Experts (SMEs) to obtain buy-in on the common definitions.
- Planned the entire Data Warehousing initiative from requirements gathering, analysis, design, identifying and analyzing the source systems, to data quality, to ETL, and to the end user data access.
- Utilized the iterative phased approach to create data marts.
- Conducted risk workshop to identify, plan, and mitigate those risks.
- Provided strong technical leadership to the project team.
- Developed the ramp up and the deployment strategy.
- Analyzed the training needs, developed the course contents.
Confidential Hyderabad, India
Operations Manager
Confidential, owned by myself, is a major garments manufacturer / retailer in Hyderabad and Bangalore. As an Operations Manager, I worked with multiple clients to establish customer relations, oversee daily production run, help customer with enquires, and resolve customer disputes.
Responsibilities: Managed $400K company with 80 employees. Motivated employees to improve production and designed “Production Incentive Program” that resulted in 10% increase in production, 15% increase in employee salary and 20% increase in profits. Interviewed many customers and introduced customized products to retain customers and improve customer satisfaction. Worked directly with key clients to ensure exemplary provision of quality and service.