We provide IT Staff Augmentation Services!

Senior Consultant Resume

CA

SUMMARY

  • Confidential is a Business Intelligence (BI) Consultant with over 9 years of experience in Analysis, Design, Prototyping, Coding, Implementation, Maintenance, Documentation, Dimensional Modeling, Planning and Scoping of Data Warehousing and Business Intelligence Applications.
  • His skill set includes ETL, creating technical design documents and extracting data from DB2, Oracle, Informix, XML, SQL Servers and Flat Files etc.
  • He also has experience in BI/BI - APPS Analytics components such as Interactive Dashboard, Answers, BI Reports, BI Publisher, BI Presentation, Adhoc Reports and Custom Analytics.
  • Confidential has interacted with stakeholders at all levels of the organization, coordinated and facilitated the testing for enhancements and bug handling during implementations (Development, Quality Assurance, User Acceptance, and Production).
  • He possesses excellent linguistic and interpersonal skills.

TECHNICAL SKILLS

Platforms and Architecture: Oracle BI Suite EE (OBIEE) 10g/11g, OWB, Oracle Data Integrator (ODI) 10g/11g, Informatica., Oracle 9i OLAP, Oracle ERP R12, Oracle Retail and Merchandising(RMS), Oracle Web Agent, Oracle 8i, SAP-BODI, Hyperion FDMEE, Oracle Reports 6i/6.0/3.0/2.5, Weblogic server Administration, Hyperion Financial Analytics, IBM- Cognos, Data Stage

Programming Languages: HTML, Express SPL, OLAP DML, C/C++, PL/ SQL, SQL*Loader

Hardware Operating Systems: Windows NT, Windows 2000, Unix, Red Hat Linux

Databases: Oracle 10/11g, MS SQL SERVER, MY SQL, Informix, MS Access, DB200

Methodologies: Data Warehouse, Software Development Life Cycle (SDLC), Ralph Kimball DW Methodology, Bill Inman DW Methodology

Industries: OIL&GAS, Banking, Finance, Beverage, Retail, Airline, Communication, Insurance, Education, Manufacturing

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Consultant

Responsibilities:

  • Manage BI project and perform analysis, design and or package review, development, testing, quality assurance, deployment, and production support.
  • Responsible for analyzing project requirements, specifications, impact to existing systems and business areas and preparing time and cost estimates for system development work.
  • Report on status of systems and projects on a regular and timely basis
  • Escalate anticipated risk with mitigation and contingency options to management promptly
  • Develop strategic partnerships with systems and business management and develop understanding of business unit’s goals and processes
  • Recognize the need for improvement in existing process/applications, present solutions and implementation plan to team.
  • Lead the overall delivery of projects including the direct management of project team members.
  • Improve and streamline processes regarding data flow and data quality to improve data accuracy, viability and value.
  • Identify opportunities for incremental and accelerated growth, coalition building, and collaborative project execution
  • Project/Work request implemented on time, within budget and meets the business expectations.
  • Perform project management duties including the creation of status reports, work plans and presentations to stakeholders and management.
  • Acts as the key interface with all the offshore teams, manages project schedules and ensures that high quality code is delivered in a timely manner.

Confidential, Redwood City, CA

Senior Consultant

Responsibilities:

  • Perform analysis and support in the choice of a BI Solution; formalize business needs, define functional, technical and financial choice criterions; a company end users in the choice of the most adapted solution.
  • PLM Solutions Change management; analyze and harmonize business and design processes; formalize business needs; manage deployment technical aspects (migration, specifications...)
  • OBI EE System configuration & architecture Leading practices definition; OBI EE 10g to 11g upgrade Assessment and Recommendations, OBIEE and BI Publisher Development leading practices definition
  • Manage the project; organize and animate the project follow up meetings; supervise technical staff ( OBI EE / ODI consultant and function JD Edwards consultant); track the spent vs. budget project workload; analyze and define workload for new user change requests (maintenance); develop new change requests; train internal and customer teams on the software evolutions;
  • OBI EE Architecture configuration; Active Directory Integration with OBI EE and security detailed design; Oracle BI Publisher Java Customization (Core API, Web services, Bursting, Data templates); Reporting Platform Configuration Design; Report Publication and Scheduling Design; Reporting Platform UI Interface design
  • User acceptance phase coordination; Key users training (more than 160 engineers and designers)
  • Organize and animate the requirement gathering meetings; define the preliminary, the functional and the detailed analysis; define the interfaces data feed schemas; write and maintain the functional and technical documentation.
  • Built Physical, Business, Presentation model and mapping layer, which include hierarchies, dimensions, and aggregates.
  • Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle BI Analytics platform.
  • Mapped presentation layer objects to Oracle BI Answers.
  • Configured and Managed OBIEE Catalog manger.
  • Develop and optimize the ETL static and dynamic processes with Oracle Data Integrator; develop Oracle BI Publisher Template for invoices and other enterprise documents; train the customer technical team for set up and maintenance; perform and follow up unit and integration test phases; guaranty delivered development quality and consistency;
  • Develop and optimize ETL processes with Oracle Data Integrator; design cubes (measures, KPI, dimensions and hierarchies) in Oracle Business Intelligence Administration Tool; define security; develop dashboards and guided navigations; answer to users need in terms of alerts generation and delivery; execute and follow up unit, integration and functional testing; guarantee deliveries consistency; install, configure and maintain development, test and production environments; document technical installations (Windows server 2003);
  • Coordinate User Acceptance Tests; define and write functional and user test scenarios; define training strategy; write and maintain the training materials; set up and maintain the eLearning web site; train and support key users (20 people); manage maintenance of the Enterprise Performance Management system
  • Organize and animate requirement gathering workshops with end users; define business use cases; realize preliminary studies, functional analysis; realize detailed analysis; define data warehouse loading schemas; write and maintain functional and technical specifications;
  • OBI EE and Oracle BI Publisher Training Curriculum and material design; Developer and Key Users training; Oracle BI Publisher Developers supervision; prepare Deliveries Test Plan and scenario.

Confidential, Chicago, IL

Technical Specialist

Responsibilities:

  • Worked on Informatica Power center and Designer tool
  • Created and maintained interface in a heterogeneous environment.
  • Used and modified different ETL modules for complex transformation
  • Imported the metadata from a selected system into the Informatica repository source.
  • Export / Import different projects in Informatica from Development environment to QA and production environments.
  • Create Batch and Real time packages in Informatica
  • Create Bi-Directional interface from Legacy system to oracle E-business suite for data Synchronization.
  • Install and configure Oracle Stream packages on database for Data replication /change and data capture.
  • Delivery of daily/weekly/monthly/yearly outbound client extracts.
  • Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
  • Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel/Oracle BI Analytics platform.
  • Built business model and mapping layer, which include hierarchies, dimensions, and aggregates.
  • Mapped presentation layer objects to Oracle BI Answers.
  • Developed new subject areas in the repository per business requirements
  • Used BI publisher for static reports and configured IBOT to schedule the BI reports and alerts.
  • Created Dashboard, portal, and ad-hoc reports In Oracle BI-presentation services.
  • Integrate OBIEE with OAM to enable SSO and populate the OBIEE session variable from http header variable.
  • Implement Data level and object level security in OBIEE.
  • Work on Hyperion (HFM) model and configure ERPI for data loading.
  • Write stored procedure, trigger, sequences and user functions in PLSQL.
  • Trained user for OBIEE reports.
  • Overall project delivery and hot fixes.
  • Onsite and offshore coordination.
  • Resource management

Confidential, Atlanta, GA

BI Consultant

Responsibilities:

  • Migrated master and work repository from Sunopsis version to Oracle Data Integrator ETL Tool.
  • Worked on Oracle Data Integrator (ODI) / Sunopsis Designer, Topology Manager, Operator and Security Manager
  • Database sizing & CPU estimation on Data Base, ETL & OLAP for Development Server, Test Server and Production Server.
  • Performed risk analysis, Business requirements, Project Plan and Hardware/Software Requirements.
  • Extract data from CSV file as a source using Database SQLDR capabilities into oracle tables
  • Created data flow diagrams to demonstrate data origination and data flow sources and the data warehouse.
  • Designed and configured the initial ‘folder’ structure / Meta-Model for selected environments.
  • Data Model: Logical and Physical Data Design and Star schema Modeling.
  • Create Batch and Real time packages in ODI.
  • Worked on OBIEE 10g (10.1.3.4.1 ) version.
  • Built Physical. Presentation, business model and mapping layer, which include hierarchies, dimensions, and aggregates.
  • Pulled User and group’s information from OID/LDAP and stored in OBIEE Administrator.
  • Configure and Managed OBIEE Cache on database/table/user level.
  • Created Dashboard, portal, and ad-hoc reports In Oracle BI-presentation services.
  • Implement Data level and object level security in OBIEE.
  • Delivery of daily/weekly/monthly outbound client extracts.
  • Involved in developers training for ODI.
  • Trained user for OBIEE reports.
  • Onsite and offshore coordination.

Confidential, Grand Rapid, MI

BI Consultant

Responsibilities:

  • Worked on Oracle Data Integrator (ODI) / Sunopsis Designer, Topology Manager, Operator and Security Manager.
  • Created and maintained interface in a heterogeneous environment.
  • Deigned and configured the initial ‘folder’ structure / Meta-Model for selected environments.
  • Imported the metadata from a selected system into the ODI repository.
  • Involved in Data Profiling and Data Cleansing activities.
  • Managed and created materialized views in a production environment.
  • Managed and scheduled the agents in different packages.
  • Export / Import different projects in ODI from Development environment to QA and production environments.
  • Setup the table’s structure in QA and production environment for initial load.
  • Provided Siebel expertise in application, integration and technical architecture to the team.
  • Implemented Security by creating roles & web groups, checks with External tables & LDAP
  • Technical Impact analysis on ETL/OLAP design.
  • Mapped presentation layer objects to Oracle BI Answers.
  • Used BI publisher for static reports and configured IBOT to schedule the BI reports.
  • Created Dashboard, portal, and ad-hoc reports In Oracle BI Presentation services.
  • Defined Security Level in OBIEE.
  • Managed the catalog manger in OBIEE.
  • Wrote database procedure, function, trigger and sequences.
  • Managed the clusters in servers.
  • Involved with business user in testing, documentation, production troubleshooting and support.
  • Involved in developers training for ODI.

Confidential, San Francisco, CA

BI Consultant

Responsibilities:

  • Migrated master and work repository from Sunopsis version to Oracle Warehouse builder (OWB)
  • Worked on OWB Designer, Operator and Security Manager.
  • Performed analysis, design, development, testing and implementation of business required Siebel Analytics Dashboards and reports.
  • Managed the Informix database in UNIX environment.
  • Extracted Financial Data from SAP R/3 4.7 using OWB SAP module and integrate into different target.
  • Managed and built OWB repositories and created workflow in OWB Designer.
  • Designed and configured the initial ‘folder’ structure/Meta-Model for selected environments.
  • Worked on Oracle 10g/11g Database for target in mainframe environment and the Size of Database is 4TB.
  • Used I-series navigator as a client tool for DB2 and used import / export and maintenance Utilities for data loading.
  • Managed the clusters in servers.
  • Managed and scheduled the agents in different packages.
  • Configured the IBOT in OBIEE.
  • Mapped presentation layer objects to Oracle BI Answers.
  • Provided Siebel expertise in application, integration and technical architecture to the team.
  • Built business model and mapping layer, which include hierarchies, dimensions, and aggregates.
  • Used BI publisher for statics reports.
  • Involved in developers training for OWB.
  • Used rational configuration and change management system.
  • Delivery of daily/weekly/monthly outbound client extracts.
  • Onsite and offshore coordination.

Confidential

Software Developer

Responsibilities:

  • Gathered requirement from user and create a feasibility analysis.
  • Gathered user requirement and documented complete business flow diagrams.
  • Created Financial Analysis report for various projects.
  • Created DFD, ERD, Test cases using Microsoft Visio.
  • Used XML for storing Data.
  • Used XQuery to extract and manipulate data from XML Documents.
  • Used Macromedia Dreamweaver in designer to generate HTML.
  • Helped in Database development and integrations.
  • Created database model and developed data driven application using Web Focus.
  • Maintained Data extraction and manipulated data in the production database.
  • Involved in process improvement, cost analysis.
  • Modified and Built Database using SQL Server 2005 and Oracle 9i, 10g.
  • Wrote Triggers, Stored procedures, Indexes and Views.
  • Gathered user requirements for Forms and Reports developments.
  • Coordinated complete testing and implementation.
  • Data acquisition, transformations, production migration and support activities.
  • Created and monitored remote distributed SQL statements.
  • Built Logical and physical design of database.
  • Prepared administrator application in Forms 5.0 and Reports 3.0.
  • Applied patches to production and development database servers.
  • Designed and created cubes in Oracle 10g OLAP.
  • Configured Database performance tool includes Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
  • Prepared source to target mapping documents.
  • Prepared software requirement specification document.
  • Data modeling using Erwin 3.5.
  • Created SQL, UNIX shell scripts and Express Data Loader Programs.
  • Managed clusters in servers.
  • Created and scheduled SQL packages.
  • Used rational configuration and change management system.
  • Overall project delivery and hot fixes.
  • Designed and implemented backup strategy.
  • Created and monitored the database schema objects.
  • Managed physical database structure, database objects, and database usage.
  • Involved in process improvement and cost analysis.
  • Write test cases.
  • On site and offshore coordination

Hire Now