SUMMARY:

• Great experiences of managing and leading IT staffs to design, develop and maintain enterprise databases and data warehouses in the most optimized performance environments
• Solid knowledge of accounting, finance, financial markets and skills in ERWIN, PL/SQL, T - SQL, Toad, ETL, AWS Cloud Applications (Hadoop, Spark, EMR, HDFS, S3, RDS, Jenkins, JSON/XML, HIVE, PIG, Flume, NoSQL and PostgreSQL)
• Strong practical experiences of design and adoption of complex technical visions to develop or migrate terabyte and petabyte scale levels of data warehouses and Big Data
• Outstanding abilities of analyzing, evaluating, managing and solving the most complex and high scale business problems of ERP, CRM, MDM and Real Time (or near Real Time) OLTP, OLAP and ETL processes under RDBMS, Data Marts and Data Warehouse
• Over 18 year great experiences in logical and physical designing, developing, maintaining and tuning large scale databases and Data Warehouses for Oracle, MS SQL and DB2 under Unix/Linux/Windows/AIX/AWS and AWS Big Data

PROFESSIONAL EXPERIENCE:

Confidential

Senior Lead Data Architect

Responsibilities:

• Lead key analytical projects and processes to deliver actionable insights and recommendations for enhancing products such as enterprise sales and maximizing revenues
• Support and assist CIO to define and develop strategic directions, plans and roadmaps for designing/redesigning, migrating and implementing ERP, CRM and BI solutions (data marts and data warehouse) in MS SQL Server, Oracle and Cloud
• Define and develop data collection from multiple sources, data storage, data process, data presentation and data governance strategies including data quality, MDM (meta data management), data lineage and data protection for new designing data marts and data warehouses in Cloud
• Work with business analysts and IT technical leads and engage in business analysis, data concept, logical and physical dimensional modeling for data marts and data warehouse development with ERWin
• Work with data developers to define, design, develop & optimize ETL processes for enterprise data warehouse in Hadoop, Hive and Spark
• Design and develop data analysis, dashboard, built-in reports and user-self analytical reports

Senior Lead Data Architect

Responsibilities:

• Review, evaluate, establish and conduct proof of concepts of both CBOE and FINRA option market data (quotes, trades, clearing and settlements) elements for regulatory surveillances to layout the strategies and plans for the migrations from CBOE Oracle data warehouses to FINRA AWS Clusters of using Hadoop, EMR, HDFS, S3, RDS, JSON/XML, HIVE, PIG, Flume, NoSQL and PostgreSQL
• Maintain data mapping documents, business matrix and other data design artifacts that define technical data specifications and transformation rules for Hadoop MapReduce, Hive, RDS and Redshift
• Perform source data analysis and data discovery and data profiling for market regulatory surveillance patterns under AWS cloud
• Work directly with developers and internal customers (users) technical resources to devise and recommend solutions based on understood requirements
• Produce technical frameworks or architectures that in corporate business rules, workflow and role based actions and balance technical purity with practical necessities to arrive at tangible and sustainable business outcomes
• Analyze complex distributed production deployments and make recommendations to optimize performances
• Define the strategies for transferring CBOE option trade data to FINRA stage and the comprehensive MDM, ETL roadmaps and processing procedures of storing and managing CBOE’s data in AWS environment via API publisher, Key store, Gateway, EMR, S3, RDS and PostgreSQL for DEV, QC and PROD environments
• Research and recommend best-fit technical solutions for a specific project, program or practice area need to convert CBOE regulatory surveillance batch programs into FINRA regulatory surveillance patterns in AWS Clusters (RDS and Redshift) with LINUX, HBASE and PostgreSQL Scripts
• Design standards for using normalized data structures, de-normalized structures, and dimensional structures. Defines common design patterns for modeling various types of relationships
• Produce and document CBOE’s logical and physical database design using Erwin (Model Mart) as a data modeling tool, while working with business users and developers to understand their data needs and relationships to existing corporate data so as to redesign and develop data models
• Perform CBOE’s physical database design at the object level, create DDL scripts, define database snapshots, table partitions, and backup/recovery strategy for Oracle databases and data warehouses
• Oracle database tuning and administration including security management, instance performance monitoring, table space utilization, schema object management, database capacity planning, *bottlenecks* and *offensive* SQL activity monitoring and resolution
• Coordinate testing with other development groups and operations. Identify appropriate level of testing and ensure that testing is complete before signing off

Senior Lead Architect (Associate Director)

Responsibilities:

• Develop constructive and cooperative working relationships with peers both within and outside of Technology, and maintain them over time.
• Establish and maintain external relationships with strategic product / service vendors and industry forums (government & private councils, standards bodies, product forums, etc.), as appropriate.
• Provide consultative services to other teams on their area of technical expertise.
• Contribute to the establishment, evolution and continued compliance with standard practices and processes.
• Manage and lead IT leaders to evaluate and plan next generation ERP solutions, MDM, databases, ODS and data warehouses’ design, data integration, recoverability and resiliency
• Supervise DBA team to design, develop and maintain oracle/MySQL/sql server databases, ODS and Data Warehouses’ ETL, BI tools, activities, processes, patches and upgrades
• Lead DBAs and developers to redesign and develop schemas and star-schema for oracle 11g databases, ODS and Data Warehouses
• Lead, participate and coordinate ERP team and other IT groups to migrate Oracle 11gR2 grid, ASM and databases to banner 8.5.2 and Luminis 5.0, oracle 11gR1 fusion middle wares for banner INB and SSB server, ODS and data warehouses under Linux 5.7 from banner 8.4, oracle 10gR2 and OAS under Solaris 10, which saved the university at least over 2 million dollars
• Design and customize forms, reports and batch processes; Create ERP user manuals for AR, AP, Assets, Payroll, General Ledger, Procurement, Purchases, HR, Students, and Financial Aid to improve the efficiencies of all ERP modules

Sr. Data Warehouse Architect

Responsibilities:

• Define strategies and approaches to collect the data sources of patient demographic, insurance, diagnostic, clinical, respiratory therapy, orders, lab results, pathology, radiology results, billing and administration and other data to build clinical and translational data warehouse using UIC medical center data and other vendors’ data from ground zero
• Plan and develop strategies for product/project management required for the architectural design, creation, installation and maintenance of the Enterprise Data Warehouse
• Purchase physical hardware (six node servers for the data warehouse) to install Oracle Linux and oracle 11gR2 RAC, create and configure MDM and the Enterprise Data Warehouse
• Work with medical online translation database team and clinical and financial business teams to collect data warehouse design requirements
• Design and develop ETL execution strategies starting ETL cycle initiation, build reference data, extract (from source), validate, transform (clean, apply business rules, check for data integrity, create aggregates or disaggregates), stage (load into staging tables), audit report, publish (load) to target tables, archive and purge
• Work directly with senior managers to plan data governance, system design, application interfaces and system specifications
• 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
• Logical and physical design and development of risk data marts and financial data warehouses
• Build data mart and data warehouse cubes with OBIEE and Essbase

Senior Lead Data Architect Sr. Financial Application Manager

Responsibilities:

• Keep abreast of market developments in area of technical expertise, assess their readiness and applicability, evaluate impact / opportunity on existing implementations, and recommend migration and implementation plans, as appropriate.
• Provide input into the technology development strategy plans for the company, produce technical frameworks or architectures that in corporate business rules, workflow and role based actions and balance technical purity with practical necessities to arrive at tangible and sustainable business outcomes, research and recommend best-fit technical solutions for a specific project, program or practice area need, participate in project architecture reviews
• 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
• 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; 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, support and upgrade Oracle Financial Applications(GL, AR, AP, CE, FA, INV, PO, OKC, OKS, Workflows) and Human Resource Systems (11i.5.6, 11.5.10.2 and R12) under multiple organizations and multiple currencies, ADP Payroll systems and Gupta Database (Computer Associate Database Engine), Great Plains (Microsoft ERP) and its databases (MS SQL 2000, 2005)
• 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
• 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

Chief Financial Application Architect

Responsibilities:

• 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 for bank 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
• 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)

Financial Analyst and Database Administrator

Responsibilities:

• Review financial statements to analyze companies' operating performance and efficiency, liquidity and capital resources, to assess credit history and investment risk, and to evaluate stock prices based on assets, dividends, free cash flow and earnings (including residual income) models
• Develop futures & options pricing models and trade volume allocation programs
• Develop application programs to review and forecast VaR and risk management performances
• Develop 30 year bond futures, ten year notes futures, S & P 500 index futures and options, Eurodollar futures, and OEX futures financial models
• Design and implement a database under DB2 to store trading data and customer information to allow remote customers to query their trading information