We provide IT Staff Augmentation Services!

Senior Oracle Warehouse Architect Resume

3.00/5 (Submit Your Rating)

SUMMARY OF QUALIFICATIONS:

  • An insider of Oracle ERP (E-Business Suites) and its tools, Great Plains and Banking Software (from installation, business concept design/functional implementation, customization for reports and batch processes to patch application, database maintenance and function supports for all modules)
  • Excellent abilities to analyze, evaluate and solve business problems with optimized solutions
  • Solid experiences in logical and physical designing, developing, maintaining and tuning databases and Data Warehouses for Oracle (7.3/8.0/8i/9i/10g/11g), MS SQL (7.0, 2000,2005), and DB2 (Common Server and UDB 5.0/6.0/7.0), Oracle ERP (Oracle Financial Applications 11.5.6, 11.5.10.2 and R12) under Unix/Linux/Windows/AIX
  • Strong experiences in ERWIN, PL/SQL Developer, Toad, ETL, ASM, Oracle Application Server Configurations, ADI, Discover, Adadmin, Adctrl and Adpatch, XML,PERL/K-shell scripts, C and Java

EXPERIENCES:

12/2009-Present Senior Oracle Warehouse Architect/EBS Apps DBA Consultant 
Confidential,Chicago

  • Maintain Oracle Applications security including database, applications users, and responsibilities and roles management
  • Monitor, optimize, performance tuning, back-up/restore, replicate, clone, deploy and migrate data to multiple environments in support of business activities
  • Support the rollout of applications and application patches utilizing databases and application servers
  • Support the database/applications/infrastructure administration activities running on Oracle Apps11.5.10.2 and R12, 10g and 11g RAC databases
  • Administer core frameworks for Oracle E Business Applications.
  • Work with business and technology teams to ensure that the business needs are clearly understood and the technology implemented meets the needs and expectations of the business
  • Analyze emerging technologies and work with business and IT Leadership to translate implications of the new trends into an effective technology vision and strategy
  • Lead all activities including business analysis, data acquisition, access analysis/design, database and load optimization, and system implementation
  • Work with the Information / Data, Application, and Technical Architects to develop the target state business process model; adhere closely to the corporate vision, as well as to the business and technology strategy
  • Create partitions with local indexes, build cubes based on multiple dimensions and large dataset and integrate Financial data mart with Essbase cubes
  • Physically and logically design data warehouses with ERWIN and develop ETL stored procedures, packages and programs to populate data
  • Serve as the point of contact to business partners for new initiative assessment . Conduct frequent and formal meetings with key business partners to review / discuss overall technology performance for the specific functional areas under responsibility
  • Develop the detailed project plans for data requirements gathering, data modeling with ERWIN and database design, development and implementation

09/2000-11/2009 Lead Senior Oracle ERP (EBS) DBA/Architect
Confidential,Chicago

  • Monitor business processes, data migration and deployment to multiple environments in support of business activities; Maintain Oracle Applications security including database, applications users, and responsibilities and roles management; Assist Business Groups with configuration changes
  • Support the rollout of applications and application patches utilizing databases and application servers; Support the database/applications/infrastructure administration activities running on Oracle Apps11.5.10.2 and Database 10g; Administer core frameworks for Oracle E Business Applications; Identify and resolve application issues. Act as point of escalation for Business Groups analysts
  • Manage code promotion between development, test and production environments, procedures supporting production changes. Assist with definition of environment refresh schedule. Execute test cases for system changes prior to and following production deployment; Manage day to day vendor relationships, including Oracle On Demand; Escalate support issues as appropriate
  • Design, implement, and maintain integrations with other internal and external applications; Assist in definition of technical requirements for enhancements, external system integrations, configuration changes, and customized reports. Assist in translation of business requirements into functional / technical specifications impacting Oracle Applications
  • Implement, maintain and support Oracle Financial Applications(GL, AR, AP, FA, CE and Service Contracts) and Human Resource Systems (11i.5.6, 11.5.10.2 and R12) under multiple organizations and multiple currencies
  • Maintain and support ADP Payroll systems and Gupta Database (Computer Associate Database Engine)
  • Maintain and support Great Plains (Microsoft ERP) and its databases (MS SQL 2000, 2005)
  • Modify the setups and configuration of existing oracle ESB modules to enhance the functional and technical solutions and implement new oracle ESB modules
  • Install Oracle 8i, 9i and 10g database software; Install and configure11i Oracle Financial Applications (General Ledger, Cash Management, Fixed Assets, Receivables, Payables, and Service Contracts modules) (11.5.5) base, upgrade Oracle Financial Applications to 11.5.6 and to 11.5.7 by applying patches using Oracle Apps DBA tools—adpatch, adadmin and adpatch
  • Logical and physical design, data modeling with ERWIN and develop Customer Relationship Management (CRM) for internet payment, fulfillment and data mining under Oracle 9i; Develop packages and stored procedures to process online subscriptions, online payment, auto-batch renew customers’ subscriptions, auto-batch payment, book sale, book cancel refund, recognize revenues on transaction, product and GL levels
  • Customizes and develop reports, extensions, and interfaces as needed to support business requirements
  • Convert Great Plains, JD Edward and People Soft of purchased companies in US, Europe and Australia into Oracle EBS
  • Leads the development and maintenance of integrated business process & application roadmaps with focus on the ERP strategy in and around the enterprise. Advises on the effective use of information management methodologies/technologies and supports any needed changes in order to leverage information products, services, methods, and technologies
  • Supports front-end users (accountants and financial analysts) to do user daily and month-end close operation and technical function trouble shootings
  • Proposes, plans and initiates IT projects and solutions, in conjunction with various business units. Maintains existing application portfolio for scalability, reliability, performance and maintainability
  • Reviews all applications development and configuration project requests, coordinates schedules and related departmental activities to ensure project/program objectives are met in a timely fashion; Defines system integration and acceptance testing process and ensures adequate resources
  • Reviews and evaluates work of team members; Prepares performance reports, activity and progress reports regarding all software projects and programs
  • Assigns work, sets completion dates, reviews work, and manages performance in accordance with organizational policies, procedures, and performance management processes. Interacts directly with the end customer for the purpose of identifying and documenting business/systems requirements and processes
  • Clone Oracle 8i, 9i/10g databases for oracle 11i.5.10.2 and R12 ERP and HR test and development environments
  • Develop scripts to backup, recover and clone Oracle (8i and 9i) Databases and Oracle Financial Applications; Configure RMAN and Dataguard for oracle databases’ backups and recovers;
  • Design and implement Oracle 10g RAC Databases and Data MART with ERWIN for data modeling for Hedge Fund Research
  • Install, develop and maintain customized Oracle 10g RAC databases for large investment firms
  • Create Standby oracle 9i and 10g RAC databases for 11.5.10.2 ERP for DR
  • Upgrade Oracle Financials and HR from 11.5.6 to 11.5.10.2
  • Design and develop databases (MS SQL Server 2000, 2005 and oracle 9i) and data warehouses (Oracle 9i) for large institute clients’ mutual fund and equity portfolio simulation and optimization
  • Design and develop data warehouses (oracle 8i, 9i and MS SQL 2000, 2005 ) for Mutual Funds, Equity and Separate Account Research
  • Maintain and support Equity-Edge (E-trade stock options system) and Database (Oracle 8i)
  • Model, design and develop a large scale web based Morningstar Mutual Funds (Open End, Close End, Variable Annuities, ETF, and Separate Accounts) and Stocks Distributed Web databases for users to query and research on mutual funds and stocks, and to do portfolio research and asset management with ERWIN
  • Develop scripts and stored procedures to auto-load and backup OLTP and OLAP under MS SQL 7.0, 2000,2005 databases

09/96 – 09/2000 Chief Financial Application Architect
Confidential,Chicago,

  • Work with bank CFOs and Controllers to do overall business analysis, solution design, and functional architecture activities to plan banking ERP implementations
  • Oversees and guides implementation of proposed solutions for banks; communicate and coordinate between clients and functional / technical teams; Reviews all applications development and configuration project requests, coordinates schedules and related departmental activities
  • Defines system integration and acceptance testing process and ensures adequate resources; Works with business units, marketing and sales teams in decision making process to ensure effective cross-functional decisions and implementation plans
  • Design and develop bank marketing data warehouses for banks’ data mining
  • Design and develop market risk, interest rate risk and credit risk management systems for banks to model and hedge its risks using tools such as interest rate swaps and credit derivatives (Total Return Swaps)
  • Manage and maintain more than 200 databases and data warehouses under Oracle 7.3, Oracle 8, MS SQL 6.5, MS SQL 7.0, DB2 2.1 and DB2 5.0
  • Model more than 110 banks’ data to develop Assets/Liabilities Management implementation and customization guidelines using ERWIN
  • Design and implement logically and physically more than 110 large scale databases for banks and financial institutions, including hardware configuration, RAID disk space management, capacity planning, partitioning tables and indexes
  • Develop stored procedures to auto batch data transfer
  • Redesign activity based cost allocation to simplify implementation procedures and improve the performance
  • Design account, product and customer level profitability reports requested by Canadian and British banks
  • Analyze and diagnose internal and external databases’ performance issues and running errors
  • Redesign transfer pricing methods and tune SQL statements to improve the performance
  • Perform business and competitive analysis
  • Design assets/liabilities management, risk management, performance measurement business concepts and prototype models
  • Redesign cost allocation and add new features for banks to allocate cost based on budget and abilities to trace the allocated amount for each step
  • Model customers’ data, design and create databases with ERWIN, and implement user interface and integration with customers’ other products
  • Develop product definitions and functional specifications for banking software
  • Design and prepare banking performance measurement demonstration data for testing and sales

EDUCATION: 

MS in Accounting
MS in Physical Sciences
MS in Applied Mathematics

We'd love your feedback!