We provide IT Staff Augmentation Services!

Etl / Dw / Bi / Ba / Bsa Analysis And Developer Resume

2.00/5 (Submit Your Rating)

Brea, CA

PROFESSIONAL SUMMARY:

  • A proven results - oriented IT BI / ETL professional, versed in Object-Oriented Analysis and Development, with in-depth knowledge of the full software development cycle in the Automobile, Entertainment, Aerospace, Distribution, Financial and Manufacture industry
  • Diverse expertise SQL Store Procedure Unix Data Warehousing, BI Reporting and ETL process:
  • 10+ years’ experience ETL Architect: Strong in using Informatica, IDQ, DVO and ODI ETL.
  • 10+ years’ experience DW Architect: Good on Data Modeling using Erwin & Star schema
  • 10+ years’ experience BI Architect: Gather and translate business requirements into BI solution
  • 4+ years’ experience OBIA & OBIEE: BI APPS 7.9.6.4+ and 11.1.1.7+ based on OBIEE 11.1.1.7
  • Good on Metadata & data staging develop Performance tuning, load optimization batch & RPD process
  • Proficient on Gathering, business requirements, policies, rules & process, Design ETL to load data to DW, Build repository, design dimensional Erwin Star schema data model and data integrity, develop OBIEE Dashboards, Reports, Publisher using industry best practices and UI standards, define security, tune caching & testing QA.
  • Excellent oral & written communication skills, strong troubleshooting & Agile manifesto.
  • Experience in Installing, configure, Develop and Administer Oracle Business Intelligence (OBIEE) upgrade from 11.1.1.5 - 11.1.1.7 Weblogic Server, Fusion EM with Oracle EBS 12.1.3 - 12.2.5 and Design BI/DW Architecture.
  • Develop IBM/SPSS Showcase Definitions, Sets, Run UC4 Jobs D/W/M/Q to update db2 & Essbase builds, Upgrade SPSS from 7.0 to 8.0, 9.0, as well as Design and Develop Oracle ELT ODI 11.1.1.1
  • Administer Essbase Console for user, group, session and security setting, design/develop Essbase Analytic for cube builds, such as Outline: Time, Account, Geography etc. Dimension, Code SQL in Calculation scripts, Rules files, import partition manager & Replication data from source, Data load for databases, maintain variables value weekly monthly quarterly, Migrate Essbase from 6.5 to 7.1, 7.2
  • Administer Hyperion Performance Suite, manager user, group and security, setup BQY access control, properties for. OCE, schedule jobs
  • Develop Informatica Power Center, IDQ Architecture: Client Tools, Repository and Server, Develop/manage transformation, mapping, sources and targets. Map/Convert data from legacy/variety sources to ODS/DW, create/manager the session/workflow, monitor the session/workflow log
  • Oracle ERP Migration, mapping and convert data

TECHNOLOGICAL SKILLS:

ETL Architect: Use IBM/SPSS Showcase, Oracle ODI 11g+, Informatica 8.1-9.x, IDQ, DQV tools for Integrating & mapping various data/source/format tables, load to various DW.

DW Architect: Data Modelling various data sources OLTP/ODS, Oracle, IBM/DB2, MS/SQL, Files, XML and Designing targets at Multi-Dimensional DW Oracle ROLAP & Essbase Cube, Cognos MDOLAP.

BI Architect: OBIEE end to end life cycle, hands on RPD, use Admin Tool to build data model and mapping, Use dashboards or answers for Reporting and Publishing, HPS Essbase & Cognos for Query And Analyze. Experience in Business Objects WEBI, Miscrostrategy, SSIS, SSAS, SSRS.

BI Reports: Develop Interactive/Dashboards, Ad-hoc Analysis, Scorecards, Proactive Detect & Alert KPI, Financial/Interactive/Production and AP/AR/GL Reports.

BIAPPS: Installing & configuring BIAPPS 7.9.6.4+ and 11.1.1.7+ on OBIEE 11.1.1.7, experience on Oracle Weblogic Server Administration Console, Enterprise Manager - Fusion Middleware Control, BI Administration Tool and BI Presentation Catalog for Web based Navigator. (4+ years’).

Administer: Hyperion Server, Essbase Server, Cubes and MDX, OBIEE Server Console. (4+ years’ each item).

Languages: Good on Oracle 11g/12C & SQL, PL/SQL, Unix/Shell/DOS scripting for Windows and Linux. Mainframe IBM/AS400 and HP RPGLE, CLP, SYNON and COBOL.

BA/BSA: Support all aspects of the business unit(s) functions by acting in a functional capacity in all phases of the Project Life Cycle for medium to large projects, post support. Advance with production support and problem resolution, using Visio and Use Case.

Experience: with Oracle EBS OAF ADF AOL, Discoverer, TOAD, & AS400, HP, Windows/Linux OS.

Experience: with ERP, CRM and Industry Analytics, Financial Close & Reports, Planning and Forecasting, strategy/cost management, Master Data Management and networking TCP/IP, Lan/Wan.

Experience: with MS/SQL Server & Access, Excel, Word, PowerPoint, H/W memo, CPU, SAN, RAID and I/O.

PROFESSIONAL EXPERIENCE:

Confidential, Brea, CA

ETL / DW / BI / BA / BSA Analysis and Developer

Responsibilities:

  • IBM Show Case 8.0 (ETL): Design/Warehouse Builder/Definition/Mapping/Job Sets with Enterprise Server, for the variety data source, set and run schedule to DW Essbase.
  • Connect followings Sources thru ODBC/JDBC. And Master Data Management (link all critical data to one file).
  • DB2 Source: AS400 DB2 and Siebel DB Server Data, None DB2 Sources: Siebel DB, SQL Server, Excel MS Access.
  • DQC: cleanse DB2 from RSS & MS/SQL Server & SiebelDB CRM into DW - Trillium Cleanse.
  • Administer Hyperion & Reports: Query and Analysis Dashboard creation for UI in Hyperion Performance Suite/Actuate (E-Reports)/MS Access/Excel (at accomplishments).
  • Hyperion + Essbase for Financial Close and Reports.
  • Experience in SSIS, SSAS, SSRS Reporting and Production Support for following systems:
  • Production System: (Solar) Parts Ordering, Shipping and Inventory Systems.
  • Vehicle Ordering and Distribution to dealers (wholesale): Supply Chain (SCA).
  • Dealer Communications System (DCS): Confidential Connect/SCAT BMP for Parts orders and Warranty claims.
  • Back Order, Recall, Warranty Review and Retail Sale Systems (retail).
  • Customer Relations Management Systems: Siebel (SQL Server) and Trillium Software.
  • Analyzes and documents business process for all systems by the Use Case and Visio.
  • Function Change Management for IT programming request.
  • Trouble Shooting for IT trouble report.
  • Project development/modification.
  • Review result and test.

Environment: ETL Enterprise Server, AS400/iSeries, DB2, SQL, CLP, COBOL, RPGILE, QRY.

Confidential, Torrance, CA

OBIEE Administrator and Developer

Responsibilities:

  • Administer Oracle Business Intelligence Enterprise Edition in Oracle Weblogic Server Administration Control, Fusion Middleware Control Enterprise Manager & Admin Tool. Build and configure Metadata Repository, set up roles and policies assign user and group permissions, tune performance by Cache value in NQSConfig.INI
  • BI/BA/BSA role to work close with managers to create sales and inventory analytics reports.
  • Physical Pane: Design BI Architecture of Star Schema from DW Oracle EBS/Essbase Cube.
  • Business Model or Mapping Pane: design logic based on the best business practice.
  • Presentation Pane: move mapping pane here, use EM load new RPD, and restart EM.
  • Develop OBIEE: Analytics and Publisher Reports, detect & alert KPI, Dashboards for User Interface.
  • Use Toad: Coding SQL. Using Informatica and ODI ETL process from EBS source files to target files DW.
  • OBI Discoverer: Oracle Discoverer Query report for users.
  • Develop OBICS and Data Sync: test for Manufacture System, and ETL Siebel DB, and Cleanse data.
  • Midrates Team Connect 3.0: Cross-Object for Legal Budget/Spend, Matter Statistics, Invoice.
  • Develop Informatica and IDQ Architecture: Client Tools, PowerCenter Repository & Server.
  • Business Objects Universe: gather requirements, design star schema, ETL data into DW, create class, join/map design Universe, set security, create reports using web intelligence.
  • Design ODI Orders Application, Interfaces Mapping, to Sale Administration. Process Master Data Management.
  • Experience the BIAPPS 7.9.6.4+ and OBIA 11.1.1.7+, Hyperion + Essbase for Financial Close and Reports.

Environment: ODI 11g, OBIEE 11.1.7, Oracle EBS 12g/OAF ADF AOL, HP, DB2, Toad SQL, Discoverer Query.

Confidential, Burbank, CA

ETL / DW / BI / BA / BSA Analysis and Developer

Responsibilities:

  • ETL Informatica Developer the following DISCO ( Confidential Integrate Supply Chain Operation) project.
  • Informatica, IDQ Architecture: Client Tools, PowerCenter Repository, PowerCenter Server.
  • Client Tools: Designer, Repository Manager, Workflow Manager, Workflow Monitor, Metadata Reporter.
  • Designer: design the mapping and transform data from sources and targets analyzer which between:
  • SAP and ODS (Operational Data Store), ODS and DW (Data Warehouse)
  • Repository Manager: to Import and export various objects which have sources, targets & mapping defined.
  • Workflow Manager: to create sessions, define which order to perform, run and manager workflow with different connection to which sources and targets extracted from ODS to DW.
  • Workflow Monitor: see the program so far executed, show succeed or fail status, individual see section log as well as workflow log. And Master Data Management (link all critical data to one file).
  • Metadata Reporter: Coding the metadata stuffs.
  • PowerCenter Repository: Client Tools communicate to it.
  • PowerCenter Repository Service: save any database, actions between Client Tools and Server, such as data backup, data dump the workflow, mapping, transformation etc.
  • PowerCenter Sever: connect to PowerCenter Repository where talk to Client Tools, the sources and targets connected to PowerCenter Server.
  • Connect followings Sources thru ODBC 5.1 to:
  • DB2 Source: AS400 DB2 Data Warehouse.
  • None DB2 Source: Siebel DB, SQL Server, MS Excel and MS Access.
  • Reporting: create Essbase/Microstrategy/MS Access/Excel.
  • DB2: Coding tables and convert for ODS and DW in AS400.
  • BI/BA/BSA Analysis: Production Support and Problem Resolution.
  • Maintain current AS400 system include:
  • Write document for existing system
  • Modify and maintain for existing application
  • Problem resolution, Application analysis, research, test, QA, cutover and go live.

Environment: ETL Server, AS400/iSeries, DB2, SQL, CLP, RPGILE, SQLRPGLE, QRY.

We'd love your feedback!