We provide IT Staff Augmentation Services!

Bi Consultant Resume

VirginiA

SUMMARY:

  • 17 years of experience in Information Management, developing end - to-end Data Warehousing Applications, Business Intelligence, Data Integration & Migration Systems. Involved in Developing Data Warehouse roadmap, strategy and architecture, enterprise data warehouse, ODS, MDM, Dimensional Data Marts and BI reports. I have also worked on creating interfaces for Oracle Applications.
  • Good Experience in designing and implementing a Data Warehouse System.
  • Good experience in Business Analysis, preparing functional and technical design documents and Data Modeling using Designer 2000, Erwin and Rational Rose.
  • Familiarity of ETL process and OBIEE reports.
  • Good knowledge of Network concepts configuring ports and integrating legacy systems to implement and support Data Warehouse and Web applications.
  • Good experience in Developing PL/SQL programs, Performance Tuning, Monitoring and Supporting Production environments.
  • Specialized in Database Concepts and Oracle Products. (Oracle 7.x, 8i, 9i, 10g, 11g Architecture)
  • Extensive experience dealing with Order Entry, Manufacturing, Enterprise Asset Management, Insurance, Financial systems and Data Migration Projects.
  • Very strong in developing Unix shell scripts using AWK and SED for data handling and writing batch programs.

TECHNICAL SKILLS:

Database: ORACLE (11g, 10g, 9i, 8i, 7.x, 6.x) - SQL *PLUS, PL/SQL (8.x, 2.x), SQLJ, C, PRO *C (ver. 2.x, 1.x), Oracle Applications 10.7/R12, DB2, Teradata

Database Utilities: SQL *Loader, SQL *Net (version 8, 2.x, 1.x), Export/Import, DbDebugger, Toad, Sql Navigator, Oracle Discoverer, Server Manager, SQL *DBA, Sql Tuning using Sql Trace, Hints, TKPROF and Explain Plan.

DWH Tools: Informatica v4.5 to 9.x, Datastage 7.x/8.x, Hyperion MDM 9.x, Talend MDM 5.x, Informatica MDM, OWB 9g/10g/11g, SSIS

BI Tools: OBIEE 10g/11g, Microstrategy 9.x, Cognos 7.x/8.x, SSRS

Operating Systems: UNIX (Solaris, Sun OS, SCO Open Server, Confidential & Confidential, AIX), WINDOWS Server and WINDOWS 7 /8.1

Languages: C, C++, Java, MF COBOL, Perl

Front End Tools: Developer 2000(Forms 5.0, 4.5, Reports (3.0, 2.5)

Networking: TCP/IP, ODBC, JDBC, TELNET, and FTP

Scripts: Unix Shell (Bourne, Korn) - Shell scripts using AWK and

Web Platform: Oracle Web Server, HTML, XML, Java Servlets, EJBJSP, ASP, .NET, JDBC, Wiki, Share Point

Data modeling Tools: ER-win, Silverun, Designer 2000

Test Tools: Silk, Load Runner, Win Runner, Data Quality Centre

Version Control Tools: MKS, PVCS, Clear case, Serena ChangeMan Dimensions.

PROFESSIONAL EXPERIENCE:

Confidential

BI Consultant, Virginia

Responsibilities:

  • Production Support and maintenance of the existing Financial Data Store ( Confidential ) which stores the Policy and GL information for Confidential .
  • Monitoring the load process for BI Reporting and Recon Process and fixing errors as necessary.
  • Developed Drill Across Reports in Tibco Spotfire based across products, accounts and projects .
  • Golden Key Project - To maintain Policy Master Data, update other Confidential tables with the accurate policy information. Exception healing process to match policies with the right product, plan information.
  • Developed Spot fire Reports - STAT / GAAP and P&L Reports.
  • Involved in the designing of Reporting mart.

Environment: UNIX, Windows 7, Oracle Apps 11i, R12, Oracle 11g, PL SQL, SQL Loader, SQL Developer, Visio, Erwin.

Confidential

DWBI Consultant, Seattle, WA

Responsibilities:

  • Fate Crow Convergence to Calvin (Fate Dep) - to be implemented for CN, EU, JP as in Retail Refunds for NA
  • Fincron Tax report deprecation (Fincron Dep) - Development of new Tax Reports
  • PYOP(Payment only Product) for subsidiaries - new reporting request for Month end closing balance based on Subsidiaries launching Confidential Payment.
  • PYOP (Payment only Product) - Was completely involved in the process design, development and implementation of the project using Datanet/SQL- a solution to provide Month End Closing Balance Reports to Subsidiaries and Confidential 's Payments accounting group as part of the Quidsi's Confidential Payments launch, (the first Subsidiary to launch Confidential Payments). This module now serves as the source for month end closing balance reporting for any new subsidiary launching Confidential Payments. This process model has been used as a template for other similar applications (Prime gifting) Confidential .
  • Inventory - Involved in the implementation of the Inventory module into BI
  • Also involved in resolving tickets for the BI group.

Environment: UNIX, Windows 7, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, SQL Developer, Informatica, Essbase, OBIEE 10g, 11g, Visio, HP Unix 11, Datanet.

Confidential

BI Solution Data Architect, FL

Responsibilities:

  • Migration of data from EBS R11 to R12, Warranty and Claims.
  • Conversion of the Data warehouse to bring in R12 data for Warranty and Claims.
  • Production Support of OBIEE/DAC/OBIA Systems.
  • Monitoring ETLs through DAC and resolving any problems in the loads.
  • Designing the analytical schema, creating Dashboard and BI Publisher Reports.
  • Build Adhoc Reports requested by users and departments
  • Build Analytical Model for Vendor and Customer Rating using PLSQL.

Environment: UNIX, Windows 7, Oracle Apps 11i, R12, Oracle 11g, PL SQL, SQL Loader, Toad, Informatica, Essbase, OBIEE, Visio, HP Unix 11.

Confidential

Data Consultant, Buffalo, NY

Responsibilities:

  • Executive Dashboard, Board Reports, Financial Reports Design and Implementation.
  • Production Rollout and Support of OBIEE/DAC/OBIA Systems.
  • Building Operational and Analytical Dashboards for the different Manufacturing units and Service units.
  • Integration of different business units into the Data warehousing system.
  • Administration tasks, Creating and Maintaining the Metadata Repository.
  • Coordinating the offshore resources on new development and maintenance.
  • Conversion of Oracle and Discoverer Reports to BI Publisher Reports.
  • Building Reports Framework using SQLs and PLSQLs based on client’s requirements.

Environment: UNIX, Windows 7, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, Toad, Informatica,, OBIEE, Visio, HP Unix 11, Oracle Discoverer and Autosys.

Confidential

DWBI Consultant

Responsibilities:

  • Creating OBIEE and BI Publisher Reports based on client’s requirements.
  • Migration of OBIEE from 10g to 11g.
  • Designing the analytical schema, for OBIEE Reports.
  • Administration tasks, Creating and Maintaining the Metadata Repository.
  • Data migration Strategies using Oracle tools and Utilities.

Environment: UNIX, Windows 7, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, Toad, Datastage, Informatica, Essbase, OBIEE, Visio, HP Unix 11, Oracle Discoverer, SSRS and Autosys.

Confidential, Boston, MA

DWBI Consultant

Responsibilities:

  • Maintenance and support of the Financial Data Warehouse application.
  • Identify and resolve any problems relating to the application.
  • To keep all the FDW QA environments in Sync. Create & Manage ETL process across all QA environments. Assist in testing and maintain Scheduling across all environments.
  • Preparation for Implementation Strategy for Spend Analytics.
  • Involved in Oracle 11g upgrade of FDW Database.
  • Develop and Support of ETL process using PL/SQL programs, trouble shoot and resolve problems that arise during testing.
  • Create and Maintain the FDW Knowledge Repository in SharePoint.

Environment: UNIX, Windows 7, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, Toad, Datastage, Informatica, Essbase, OBIEE, Visio, HP Unix 11, Oracle Discoverer and Autosys.

Confidential, Boston, MA

DWBI Lead Consultant

Responsibilities:

  • Provide Resolutions to Problems identified by the Confidential Technologies Offshore Production Support Team supporting the CSO-IT applications namely EBS R12, FDW, Finapps, OFA, OFSA, GEER, GHR(Peoplesoft), P2P, MDM, BPM, BI Reports (Essbase, Discoverer, Oracle and Actuate) and any other new application developed by Confidential .
  • Resolving Problem tickets by analyzing Cube data and PL/SQL codes used in the programs.
  • Preventive maintenance / Job Monitoring, fine tuning of all ETL Transformation and Reporting processes using OBIEE.
  • Maintain SOPs for all jobs created to support the CSO applications.

Confidential, Boston, MA

DWBI Consultant

Responsibilities:

  • Development and implementation of ETL processes using Data Stage/Informatica and PL/SQL to move data from different sources to FDW.
  • Development, Deployment and Administration of OBIEE Reports.
  • Production Support and Wiki Administration to maintain knowledge Repository.

Confidential, Boston, MA

DWBI Consultant

Responsibilities:

  • Analysis and Design of the different Recon Process based on the Business Specs.
  • Development of the GL Recon process to validate Essbase Cubes Data against the Financial Data warehouse.
  • Data Modeling, Database Design, Process Design of Packages relating to the process.
  • Development of complex Packages and Stored Procedures using latest 10g features of bulk insert and parallel updates.
  • User Acceptance Testing support for NAGL (North America GL) Project.

Environment: UNIX, Windows XP, Vista, Server 2003, Oracle 9iAs, 10g, PL SQL, SQL Loader, Toad, Report writer 10g, Datastage, Essbase, Cognos, Visio, Oracle Discoverer, Erwin and Hyperion MDM.

Confidential, MI

DWBI Consultant

Responsibilities:

  • Preparing Technical Design Documents using Visio, Data modeling of the system using Oracle Designer and resolving Maintenance / Support tickets.
  • Development of PL/SQL Packages, Procedures, functions and Triggers for enhancing the Data warehouse.
  • Development / Enhancement of Reports using SQR, Oracle Discoverer and Oracle Reports.
  • Performance tuning of the Data warehouse system wherever necessary.
  • Lead a Migration Project from 9i to 10g Oracle Warehouse Builder.
  • Production Support - Monitor and execute monthly and daily process runs. Solving Prod. Support tickets and maintaining the integrity of the Data warehouse System.

Environment: UNIX, Windows NT/2000, Oracle 8i, 9iAs, 10g, PL SQL, SQL Loader, Toad, Report writer 3, SQR, Visio, Oracle Warehouse Builder 10g, Oracle Discoverer and Oracle Designer.

Confidential, Ford, Dearborn, MI

DWBI Technical Lead

Responsibilities:

  • Preparing Functional and Technical Design Documents using Visio and Data modeling of the system using Oracle Designer.
  • Development of Service to Engineering mapping process using PL/SQL Packages using Hierarchical queries, which forms the core part of the application.
  • Development of Java program to interface Oracle and Teradata through JDBC / ODBC.
  • Publishing of Supplier Performance Reports to the Suppliers using Single Sign On Web Security.
  • Analysis, Design and Creation of a Data warehouse system to house the data collected for reporting, using OWB.
  • Production Support - Monitor and execute monthly process runs / Monitor Daily runs.

Environment: UNIX, Windows 2003, Windows XP Oracle 8i, 9iAs, 10g, PL SQL, SQL Loader, Toad, Forms 6.0, Report writer 3, Java, JDBC, Visio and Oracle Designer, Oracle Warehouse Builder.

Hire Now