SUMMARY:

• 25+ years of experiences of technical solution design, system development, and deployment for Enterprise Data Management systems.
• Proven track records on project leadership, mentoring junior team members.
• Experiences of working on critical and difficult projects. Key technical person in all the projects.
• Strong analytical, business comprehension and problem solving skills.
• Specialize in solution architecture design on Business Intelligence and Analytics, Master Data management, Data Warehouse system.
• Self - starter and team player.
• Relational and Dimensional Model Design
• Informatica PowerCenter, Informatica MDM Hub, DataStage, SSIS.
• Cognos, Business Objects.
• Oracle 11g/10g/9i, Oracle Application (EBS) 11i, SQL Server, Sybase.
• MongoDB
• SQL, PL/SQL, T-SQL, C/C++, Java, Shell Script, Perl, COBOL.
• Erwin, ER/Studio, Toad, Harvest, ClearCase, SourceSafe, Subversion, ESP.
• UNIX (Solaris, AIX, HP/UX), Linux.
• TCP/IP, Socket and UNIX IPC (Shared Memory, Semaphore), Multithreading Programming.

PROFESSIONAL EXPERIENCE::

Confidential, Chicago, IL

Information Architect

Responsibilities:

• Architecture Design for Confidential View system. This is a 360 Consumer View system that consolidating Confidential customers data and multiple 3rd parties Consumer data and market insight data.
• Participated in the business requirement analysis activities to understand the business goal and requirements.
• Develop Data Flow and Data Integration diagrams and high level system architecture diagrams.
• Utilized IBM InfoSphere MDM system to match and link the Consumer data from all the sources.
• Utilized MongoDB flexibility to store data with different structure together to improve data retrieve performance.
• Utilized Solr system to build the “One Box Search” application that can be integrated into other front end applications to provide the end user the fast free format search capability.
• Installing IBM InfoSpere MDM system in a cluster environment.

Technologies used: InfoSphere MDM, MongoDB, Solr, Hadoop, Oracle.

Confidential, Chicago, IL 6

Senior Solution Architect

Responsibilities:

• Designed and implemented Confidential Customer Fuzzy Match Rules using MDM RE (IIR).
• Analyzed Client companies’ Enterprise Data Management systems current state and future state.
• Defined new business processes for Organization, Instrument creation, update, enrichment, etc.
• Contributed to Confidential ’s Enterprise Data Management Strategy Blue Print. Help Enterprise Architecture team re-define Enterprise Data Warehouse and MDM systems strategy. Adjusted the different enterprise data management systems’ architectures to better align to the Business and IT strategies and simplify the architecture design.
• System architecture design for Confidential Hill and Confidential ’s Enterprise multi-domain MDM system based on the business processes and requirements. Defining MDM system architecture, Data Integration and Data Quality architecture. Choose the right technologies (such as Batch vs. SOA, Powercenter vs. MDM Hub) to build the business processes.
• Application and Infrastructure design for MDM system High Availability and Disaster Recovery option. Worked with Infrastructure teams on the deployment plan for setting up the systems.
• Designed the security solution base current business requirement, including Identity Management and Role based Data Masking.
• MDM data model design for Organization/Customer and Financial Instrument. Fully utilizing the Informatica MDM Hub Xref table structure to benefit not only MDM system, but also the downstream application systems on the data integration. This increased the capacity of the Data Integration System.

Technologies used: Informatica MDM Hub, Informatica Powercenter, Informatica Data Quality, Informatica Data Director, JBOSS App server, Oracle 11g, Sybase, SQL Server.

Confidential, Chicago, IL

Associate Manager / Senior Data Solution Architect

Responsibilities:

• Led MDM team for Confidential 's Enterprise Master Data Management - Security Master System’s design, build, system test and production deployment.
• Worked with client's business requirement team for requirements and business logic analysis.
• Worked on Security Master System technical design and data model design.
• Following the Confidential 's Enterprise Data Repository guideline and business requirements, designed the Security Master MDM systems integration and consolidation with other systems.
• Implemented Security MDM system using Informatica MDM Hub.
• Designed Business Object Universe for Data Quality Team.

Technologies used: Informatica MDM Hub, Linux, Autosys, Oracle database.

Confidential

Responsibilities:

• Took over the interface ETL development team lead role at the critical time of a parallel multi-releases Enterprise Data Management project that was falling behind the schedule; learned the existing system in a very short time, coordinated different teams to work together to get the project back on schedule and restored Confidential 's credibility.
• Designed and developed ETL processes to load data into Duke Enterprise Data Warehouse (SQL Server), Finance Data Warehouse (Oracle) and load data from 3rd parties into PeopleSoft Finance.
• Led the development team for requirement analysis, detail design, ETL build, report framework design and build, system test and deployment. Managed both on shore and off shore teams.
• Assigned tasks to developers base on their strength. Coached junior developers to help them improve their skills and work efficiency. This helped the development team to complete all the deliverables before the schedule.
• Managed the defects in system test phase. Troubleshot issues and researched solution for the defects.
• Created detail production deployment plans. Supervised and coordinated with different teams working together to make the production deployment successfully.
• Conducted performance testing for client's existing systems. Providing performance improvement solutions.

Technologies used: Informatica Powercenter, SQL Server, Oracle, Workload Automation (ESP).

Confidential

Responsibilities:

• Implemented PeopleSoft EPM solution for the client.
• Led the development team for requirement analysis, gap analysis, build, system test and deployment phases. Managed both on shore and off shore teams.
• Assigned tasks to developers base on their strength. Coached developers to help them improve their skills and work efficiency. This helped the development team to complete all the deliverables before the schedule.
• Custom Data Model design, and custom ETL design and building.
• Used Cognos Framework Manager designed the semantic objects for Cognos Report Team.
• Managed the defects in system test phase. Troubleshot issues and researching solution for the defects.
• Created detail deployment plans. Supervising and coordinating with different teams working together to make the production deployment successfully.
• Identified PeopleSoft bugs. Provided bug fix solutions to Oracle.

Technologies used: Peoplesoft EPM, IBM Datastage, Oracle database, Peoplesoft Financial, Cognos.

Confidential

Responsibilities:

• Worked with client business teams on defining new Enterprise Asset Management Data Warehouse solution's requirements.
• Worked with client's technical team for gap analysis on the data requirements.
• Completed the new Enterprise Asset Management Data Warehouse blue print document.
• Based on the data requirements and gap analysis, completed the new multi-Asset Security MDM and Enterprise Asset Management Data Warehouse system logic and physical model design include the multi-dimensional and relational design.

Technologies used: ER Studio, Oracle and Sybase database.

Confidential, Chicago, IL

Development Team Lead / Senior Data Architect

Responsibilities:

• Helped upper level management conducted project scope and risk analysis.
• Helped business department conducted the business requirement analysis. Assessing business requirements and defining the technical specification.
• Defined the technical architecture for Newedge’s Enterprise Asset Management and Trading Data Warehouse projects by using Oracle 11g RAC on Linux cluster, SQL Server database, and Oracle GoldenGate.
• Led the source system analysis and data profiling, such as GMI, Kondor.
• Data model design for Customer Master MDM, Multi-Asset Security Master MDM, Enterprise Asset Management and Trading Data Warehouse and ODS systems, including relational and multi-dimensional data model logical and physical model design. Data partition strategy design.
• Worked with DBA team for database design.
• Designed the ETL processes for the MDM, Asset Management and Trading Data Warehouse and ODS systems. Define data field mappings.
• Led the development team for Newedge’s Enterprise Data Warehouse/Data Marts and MDM systems development, testing, and deployment. Promoting standards and good practice. Providing technical direction for the team. Mentoring team member.
• Designed Business Objects Universe for reporting team. Also used Cognos Framework Manager designed the semantic objects.
• Data profile analysis and Data quality control measures design.
• Coordinated the system tests. Conducted performance analysis and trouble shooting.
• Evaluated vendors' technology and products, making recommendations on technologies and best practices for Newedge.
• Having working knowledge on OLAP (ROLAP & MOLAP), BI tools, such as Cognos, OBIEE, Oracle Discoverer, and OWB.
• Oracle 11g, SQL Server, SSIS, SQL, PL/SQL, BusinessObject, Cognos, TOAD, Shell Script, Linux, Magic Draw.

Confidential, Oak Creek, WI

Senior System Analyst / Developer

Responsibilities:

• Customized Oracle Financial Application System (E-Business Suite). Performed business requirements analysis, logical/physical data model design. Developed PL/SQL stored procedures, Oracle triggers, Oracle Workflows, Oracle Forms & Reports and Korn Shell Scripts.
• Built custom EDI interface for taking orders and submitting invoices.
• Performed troubleshooting, Data validating, and provided production support to Oracle Applications systems.
• Performed performance analysis and tuning for the backend batch processes.
• Developed and maintained the Enterprise Data Warehouse ETL processes and data presentation reports/cube by using PL/SQL, Oracle Discoverer & Cognos.
• Managing Service Request (SR/TAR) with Oracle on Demand support to resolve production issues.
• Oracle Financial AR, AP, PO, Advance Collections, Credit Management, Workflow, Oracle 10g/9i, PL/SQL, SQL, Oracle Forms and Reports, FormScape, Oracle Discoverer, Cognos, TOAD, Shell Script, Linux.

Confidential, Highland Park, IL

Senior Consultant

Responsibilities:

• Consolidating two Manugistics Supplier Chain Planning Systems. Performed business analysis, system analysis, technical design, and developing new programs.
• Oracle 9i/8i, PL/SQL, SQL, SQL*Loader, TOAD, Korn Shell, Manuba, HP/UX.

Confidential, Northfield, IL

Senior Consultant / Developer Team Lead

Responsibilities:

• Designed customization solution of Manugistics Supplier Chain Planning System for Kraft Canada. Performed business analysis, legacy systems analysis, technical design, and logical/physical data model design.
• Defined interfaces between US and Canada Manugistics systems. Streamlined the cross border operations for Confidential North America. That increased the system capability to handle the US and Mexico cross border operation. Standardized the business processes.
• Base on the business processes and existing system capability, collaborated with application architect team and Infrastructure team on Application Architecture and Infrastructure Architecture design changes, which led to deduction of one Product Ordering System, one set of UNIX servers and corresponding Oracle databases. This reduced the system’s initial investment and on-going operation cost. Also reduced the time needed for the system deployment.
• Performed troubleshooting, and provided support to development and production systems.
• Manugistics application, Oracle 9i, IBM AIX, Korn Shell, Control-M Job Scheduling System.