We provide IT Staff Augmentation Services!

Etl System Architect Resume Profile

3.00/5 (Submit Your Rating)

Qualification Summary

  • Oracle Data mart Architect/Lead Developer
  • Oracle OWB/ETL System Architect /Lead Developer
  • Business Object Integration/Customization Lead Developer
  • Spotfire BI system integration/Application Admin/Lead Developer
  • Oracle SOA Fusion Lead Developer
  • Checkfree Fiserv RECON Frontier Integration Lead Developer
  • Solid experience in data warehousing, data mining, data automation, database programming.
  • Solid experience in Business Intelligence, Search Engine powered BI design.
  • Solid experience in Fiserv checkfree Recon Frontier System/Application Admin App, Recon App, Recollector, Thin Client .
  • Solid experience in Business Objects system/permission admin, universe design, webi report dev, customization Added-ons
  • Solid experience in Spotfire 4.5/5.0 system integration, application admin and privilege management
  • Advanced Expert level SQL, PL/SQL Developer
  • Advanced skills in Mass data processing/ Batch Automation.
  • Experienced Search Engine integration Fast/Solr
  • Experienced .Net/Java developer
  • Experienced Web Developer/ Web Hosting industry
  • Currently mainly working on integration of Oracle data warehouse, Business Obejects, Frontier and Oracle BPMS.

Application and System

  • Oracle Warehouse builder
  • Oracle database 10g/11g
  • SAP Business Objects
  • Fiserv Checkfree RECON Frontier 5.1
  • Oracle BPMS SOA Suite
  • SQL Server 2005/2008
  • SSIS/SSRS

Work Experience

Sr. Software engineer,

  • Architect and Lead Developer for OWB/ETL integration
  • Oracle Datamart Architect /Lead Developer
  • Spotfire BI system integration/Application Admin/Lead Developer
  • Oracle SOA Fusion Middleware/SOA
  • System integration and Setup for Checkfree Recon Frontier system.
  • Migration and integration for the Fiserv system.
  • Build Operation Reporting Data mart
  • Build BI reporting using business Objects
  • Build Data processing and loading using Oracle warehouse builder
  • Build and integrate Oracle SOA/Oracle Bam.
  • Integrate ETL systems with automation, SOA and business intelligence reporting.
  • Build service oriented middle tier reporting service infrastructure.
  • Working on financial reports and integrated processing with external partners such as BONY, BPSA.
  • Cooperation on Compliance and securities.

Sr. Software engineer

  • Build domain and repository Objects framework for Enterprise application.
  • Build web service for job, resume and application search
  • Build virtual storage management system for very large database.
  • Integrating search for Fast Search Engine API 4.1 and ESP
  • Build targeted candidates email campaign tools for Employer
  • Build customizable and localizable application framework for all international sites.
  • Working on Data warehouse Business intelligence system infrastructure, technical designs,
  • data models and other documentation for DW deliverables.
  • Create data dictionary, data definition, business rules, metadata
  • Participate in establishing data policy, ETL architecture, data standard, exception handling process, data load batch process, data extraction process , Data Auditing, data purging policy.
  • Apply design patterns adapter, decorator, factory, proxy in daily work.
  • Build enterprise business intelligent application for job and resume searching, matching and reporting.
  • Build asynchronous data processing and batch processing framework.
  • Code asynchronous Queuing management system for document and message processing and replication.
  • Code data and network object for virtualized storage management
  • Code domain and business objects for power posting, multi-geo job posting, and target email campaign.
  • Code search converter object for the Fast Search engine API
  • Code homegrown search engine built on Apache Lucene
  • Code server site control script manager to render dynamic controlled JavaScripts
  • Code customized .NET data list, localized hyperlink, Localized literal, Localized String Builder
  • Code rich user interaction pages using AJAX
  • Refactoring and extracting the business logic to decouple the current business logic from data object and add repository and domain object layer
  • Telerek .Net component integration
  • System/technology: SQL server 2008/SQL Server 2005, Visual Studio .NET 05/08, Microsoft .Net Framework 2.0/3.5,
  • Windows Server 2k3, Vb.net, C , Spring.NET framework, AJAX, Soap, NUnit Test, Rhino Mock, Fast Search 4.1, Fast Search ESP, Apache Lucene

Senior Software Engineer

  • , VB.Net programming for interfacing old ERP System SYSPRO Application to migrate to SAP
  • Bank Automation System for AR/AP ACH, LockBox file
  • QL database replication, extractions, backup, load balancing and performance tuning.
  • Backups and recovery planning, scripting and drilling.
  • Data Warehousing and data mining. database security, privilege and user management. Create/edit stored procedure and trigger.
  • ETL tooling/Database Programming
  • Design and developed Data Warehouse cube application using SSAS to analyze business analytics.
  • SAP Financial module implementation A/P, A/R, Inventory
  • Telecom billing automation and Crystal Report
  • Installing, configuring, patching, supporting in a multi-tier environment database cluster, applications servers, web servers .
  • Build and maintain the different system environments including Dev, QA, Staging and Production.
  • Create, code and maintain scheduled jobs. Coordinate database integrations, migrations and data mapping and conversions for SAP data integration.
  • TD Access data encryption and decryption integration.
  • System/technology: Oracle PL/SQL, SYSPRO6.0, SAP AR/AP/HR Module, Lockbox/ACH, Hyperion, Sql Server 2005/2000, Visual Studio .NET 05, Windows Server 2k3, C /Vb.net/PERL/, TDACCESS encryption/decryption, Secured FTP, Crystal Report, SharePoint07/WSS3 Webpart

Senior Software Engineer/Programmer

  • Data modeling, data integration, database design and implementation for Interland.com
  • Database mining for the customers risk analysis and potential service upgrades.
  • Performed MSSQL, MYSQL database administration assistance.
  • Performed decision support data statistics, data analysis and report creation.
  • Key developer for Trellix Site Builder
  • .NET programming for corporate web site and support site.
  • VB programming for Great Plain Customization.
  • PERL and PHP Programming.
  • JAVA programming for HR employee administration and Public Communication.
  • Lead Web marketing Analyst and Search engine analyst.
  • Performed end user training for technical support.
  • Designed and implemented database for web application service network.
  • Performed Oracle8i and MYSQL database administration assistance.
  • Developed internal web application tools for technical support and customer service.
  • Data modeling, data dictionary, and the data validation.
  • PERL programming for automate data warehouse processing.
  • Performed Oracle8i and MYSQL database administration assistance.
  • Developed and implemented a centralized hub and metadata strategy
  • Designed, developed and delivered logical and physical data model.
  • Designed and implemented data warehouse and data mart for healthcare physician group for claim and case research and reporting
  • System/Technology: SQL Server 2000, windows server 2000/2003, Linux Redhat Linux enterprise , FreeBSD, Oracle 8i/9i, C /Java/VB/Javascript/XML/PERL/PHP, PGP encryption/decryption, ADP HRIS, Great Plains, KANA
  • Developed knowledge based intelligent porno-detect system.
  • Developed web master application tools website.
  • Extensively involved in Oracle PL/SQL programming to create
  • Triggers, database Packages Procedures/Functions etc.
  • Creation of database objects like Tables, Views, and Synonyms etc.
  • Extracted data from Oracle using PL/SQL through facility and generated ad-hoc reports.
  • Director of the Inspection Center, Fujian import export commodity Inspection Bureau.
  • Performed chemical inspection including trace chemical, pesticide residue for Imp Exp. Commodities, such as food, drinks, metals minerals.

We'd love your feedback!