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.
