OBJECTIVE

• Continue developing IT profession as Senior Data/BI Architect, Data Scientist, Data Analyst, Analytics Engineer, Database Engineer, Business Intelligence Engineer and System Consultant.

SUMMARY

• Over 15 years of IT experience in Requirements Gathering, Data Mining and Data Analysis, Data Modeling and Anonymization, Business Analysis, Technical Designing, Software Development, Testing Components, Implementation activities, Support activities and mentoring team members.
• Senior level professional in data management, database design and implementation, mathematical modeling, simulation, artificial intelligence and genetic algorithms. Worked with massive and heterogeneous data sets to finding big answers to big business problems.
• Experience in different industry, with focus to Finance, Banking, Mobile Financial Service, Mobile Communication, Pharmaceutical, Biotech and HealthCare, Clinical and Medical Research, Manufacturing, Artificial Intelligence design and engineering service.
• Extensive project experience from concept to deployment, including defining problems, system design and development, and documentation.
• Hands - on practice in Relational Database Management System, Data Warehousing and Enterprise Reporting, Business Intelligence, Data Analytics, Algorithms Development, Artificial Intelligence, Machine Learning, Evolutionary Computing, Knowledge Modeling and Representation, and User Interface development.
• Highly motivated and goal-oriented professional with solid programming skills, organized, and advanced ability to manage multiple projects/tasks to meet deadlines.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, R, Perl, Visual Basic, SAS, Java, CGI, FoxPro, FORTRAN, HTML, XML, LISP, Assembly Language

Databases: Oracle 8i/9i/10g/11g, Netezza, Microsoft SQL Server, DB2, MS Access

DB Developmental Tools, Software and Business Intelligence Reporting Tools: TOAD, Oracle SQL Developer, PL/SQL Developer, Aginity, Informatica, Oracle Data Integrator (ODI), Informatica MDM, Informatica Data Qulity (IDQ), Informatica MM, Actuate BIRT Designer, Oracle APEX, Oracle Business Intelligence Discoverer, IBM Cognos, Tableau

Data Modeling Tools: Erwin, ER Studio, Power Designer

Platforms & Server: Windows, Macintosh, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, TX

Data/BI Architect

Responsibilities:

• Lead multiple projects on all phases of database and data warehouse development and BI reporting, from gathering business requirements, data analysis, data model design and implementation, ETL design and development, application testing and support, enterprise reporting solutions.
• Develop and maintain the logical and physical data models, and work with the database engineering and DBAs to create optimal physical data models. Manage data modeling repository, data modeling process and support model driven development. Define and govern data modeling, design standards, tools, best practices, and related development methodologies.
• Design and develop data integration models and specifications from requirements and Provide roadmaps for data integration needs.
• Lead on the MDM projects for design and development of data models, ETL design, data analysis, profiling and data cleansing, match and merge rules in MDM hub implementation for Customer and Store MDM. Work with developers on the detailed implementation steps and build the data foundation for Customer History KPI and Finance Reports.
• Lead on the GDS and Risk Based Pricing (RBP) project. Develop the predictive modeling on customer default payment activity, trend analysis and dashboard visualization using Tableau and R. Worked together with risk management team to provide the initial analytics results and data support for the RBP model based on customer history, GDS and KPI data.
• Lead projects on legacy database migration and EDW integration design and development. Develop technical infrastructure designs, data collection/filtering/transformation and mappings, flows and report dissemination mechanisms by architecting Data Warehouses and Marts. Collaborate with other data architects on the data warehouse infrastructure design and data modeling.
• Define, design and implement innovative and practical approaches to perform initial data loading and database systems timely updating. Integrates data from multiple different sources and designs, develops, and generates ad-hoc and operational reports in support of business objectives.

Confidential

Sr. Database and Data Warehouse/BI Engineer, Data Architect

Responsibilities:

• Leaded multiple database and data warehouse development projects on business requirements gathering, data model design and implementation, ETL design and development and BI analytics and reporting.
• Designed and developed the main Key Performance Indicator (KPI) and revenue reports. Worked with finance and marketing team on their business requirements and functional specifications, transform and load data according to the business specifications. Prioritize, focus on ideas and features that will have significant impact and value.
• Presented and communicated complex analytical data and results to varying users with a keen understanding of the needs of the user. Help to quantify and measure impacts of solutions, understand, categorize, organize, and interpret heterogeneous data sets.
• Identified, designed and developed process improvements. Implemented the database changes and enhancement for each application release. Design and develop models and provide roadmaps for data integration needs.
• Developed new mechanisms and methods in the use of the data and data mining techniques to effectively extract meaningful information from data sets. Researches new techniques, methods, and best practices within the industry.
• Developed ETL specifications, source to target mapping and other documentation required for ETL development. Ensure appropriate documentation was complete and stored in the appropriate repository.
• Worked with the DBA and database development team on Golden Gate replication and monitoring, SQL optimization, Database tuning, performance improvement, and problem solving.
• Designed and prepared applicable system design and implementation documentation and operation manuals.

Confidential, TX

Sr. BI Developer, Data warehouse Engineer

Responsibilities:

• Designed, developed, implemented and maintained PL/SQL stored procedures, packages, triggers and ad-hoc queries, within relational and star schema databases for analysis, problem solving and evaluating data quality/validity/integrity. Recommended process/customer service improvements and assist in efforts to improve reporting.
• Developed ad-hoc reporting for business users with BI Answers and solutions. Design and implement key capabilities in support of ad hoc reporting, cube browsing and manipulation, and user dashboards. Design experiments, test hypotheses, and build prototypes and models.
• Worked with the Value Added Service (VAS) team on the Vendor Adherence Rebate project. Help to define a new way to weight the patients and build a systematical process to do the analysis and re-weigh. With the usage of rebuild model and analytics results, the VSA team could earn up to $2M more in revenue.
• Worked with internal business users to deliver critical projects, such as auto phone call system, Renewals and ELIZA, UPQ Reporting projects. Designed and developed the data models, conducted the data mining and analysis, and satisfied the data visualization and reporting services needs.
• Automated reporting for more complex reports with many dependencies and variables and perform data analysis using very advanced Oracle SQL skills.
• Designed and developed scalable and reusable ETL components in data warehouse that reflect complex business logic. Extend and maintain existing ETL processes to accommodate new or changed data feeds.
• Conducted the re-engineering of existing database, re-designed and developed logical and physical data models (Power Designer), ER modeling for OLTP and dimension modeling for OLAP, in support of scalable, secure, reliable business intelligence applications and internal data that meet business requirements.
• Worked closely with DBA teams on the real-time production system troubleshooting and problem solving. Contributed and provide solutions on SQL optimization, Database tuning and performance improvement.

Confidential

Sr. Database Engineer/Information Analyst

Responsibilities:

• Tech lead in the area of database development, data mining, data analysis and statistic modeling, and performed key technical functions and provide project management and leadership in the development of new applications and the enhancement and maintenance of existing applications.
• Analyzed database requirements and lead the design and development of complex database systems, provides data analysis/fix, data mapping, Extraction Transform Load (ETL), SQL and PL/SQL programming during implementation/development and post-production.
• Created and managed Entity Relationship Diagrams, Data Dictionaries and Mapping documents. Created and maintained various technical documentation including System Design Document, ERD, Data Dictionary, Data Mapping, Data Validation.
• Designed and implemented application solutions that optimize database systems performance, availability, and capacity.