SUMMARY

A strategic thinking and hands-on IT leader with extensive managerial and development experience. Proven track record of delivering superior business values with a focus on IT roadmap and strategy, Business Intelligence predictive analytics solutions, data visualization, data integration, application development, master data management MDM , data quality and governance, operation data store ODS , enterprise data warehouse EDW , and big data. Solid program management skills and experience in leading large global cross-functional teams, and influencing business and IT management on innovative approaches to solve business challenges.

Areas of Expertise

CORE ACHIEVEMENTS HIGHLIGHTS

• Led a global team and vendors to successfully launch a strategic Commercial BI analytics program integrated with mobile BI, data virtualization and predictive analytics, self-service BI reports, SAP ERP, CRM, and eCommerce systems for North America, collaborated with business to define more than 100 business performance KPIs, and initiated an innovated Big Data roadmap to drive business for advanced analytics at Avon
• Implemented One Bank Strategy for Barclays Capital to solve complex compliance challenges. Led a global cross-functional team and technical application architecture design to develop a large complex global Recertification application. This program had firm-wide impact and involved extensively intensive communications and coordination with key business stakeholders and regional technology, regulators, and operation leads at Barclays
• Revived BI, ETL, and data warehouse development for commodities trading and had business management buy-in for BI solution. The reporting analytics platform integrated with risk calculation engine and enabled business performed VaR analysis, daily P L, regulatory Basel capital, and commodities trading position analysis at RBS
• Drove global BI analytics, Big Data and real-time data integration roadmap, strategy, architecture and implementation from ground up to enhance operation efficiency and compliance monitoring capability , successfully launched the first centralized BI platform to the group with key performance management metrics reporting and scorecards at Barclays
• Led the architecture design to develop BI reporting and 10 TB data warehouse with processing 20M records daily from ground up for electronic equity trading, integrated with market data to develop price improvement calculation for algorithm trading, equity trading and order execution analysis, and reporting platform to produce equity trading execution, OATS, P L PDF reports at Citigroup
• Managed a BI vendor selection process with business approval, negotiated vendor contracts, architect and developed large end-to-end data integration with BPM Business Process Management flow including ODS, reference data, market data, risk calculation engine, data warehouse and BI reporting platform with predictive analytics at JPMorgan
• Direct report to CIO with C-level communications, led a global MDM Master Data Management program with SOA and ETL integrations, and successfully engaged more than 10 countries with this new program at insurance brokerage company
• Led BI OLAP and data warehouse development projects for eCommerce marketing campaign and enabled business real-time online marketing campaign, consumer shopping behavior analysis and shopping basket analysis

PROFESSIONAL EXPERIENCE

Confidential

Sr. Manager, Business Intelligence and Data Warehouse/Big Data

• Developed BI roadmap, strategic planning and engaged regional IT and business leads with the strategic program, established BI Center of Excellence CoE and developed BI Delivery Methodology, participated in CCB Change Control Board , managed complex projects and provided project status reports to key stakeholders, and delivered BI solutions and data strategy with integrity of Global Core Service Model and Support Model
• Led developers, data analysts, project managers and solution architects to successfully deliver a new BI analytics platform including architecture, business analysis, data models, data integration with a diverse set of technologies and SAP, Commercial BI and Oracle data warehouse development, and enhanced data quality by over 30
• Led BI reporting, mobile BI, data visualization, dashboard, and self-service reporting design and collaborated with business users to create 100 business performance KPIs for finance, sales, marketing, order fulfillment, supply chain and customer care, and supported more than one thousand active business users in North American
• Defined a strategic Big Data roadmap, and architected Big Data real-time analytics platform with Hadoop architecture and In-Memory database platform

Confidential

Development Manager,

• Defined BI roadmap, strategy and architecture design with IT and business approval to completely transformed reporting for the group and increased business efficiency, overviewed global operation models and process workflows, and identified risks and opportunities to drive further efficiencies and synergies
• Implemented One Bank strategy and architected a real-time feed processing framework and engine to integrate 3000 data feeds from Investment Banking, Wealth Management and Retail Banking Business, led the UI interface design and Web application development, and integrated data for Recertification and Oracle Identity Access Management application
• Led a multi-terabyte data warehouse architecture, data mart/model design, and SSIS and Informatica ETL development with dynamic server connections, developed with data quality control and standard error checking process, managed hundreds of Autosys jobs to ensure data delivery under SLAs
• Managed a large global development team to develop a large complex re-certification application, enabled management and stakeholders to monitor KPIs, operational insight, audit compliance, and security metrics of information risk
• Effectively managed distributed resources for multiple complex projects, built strong working relationship within the team, improved cross-functional teamwork for production support activities, utilized abilities of team members, and ensured quality deliverables and successfully led the team to meet all project deadlines
• Architected and implemented a Big Data Splunk analytics platform to enable management and support team monitor and analyze highly unstructured multi-terabyte data in real time
• Led stakeholder meetings for requirement review and gathering and product demo, managed group budget and vendors, documented TOR Terms of Reference and Operation Model, managed SLAs, engaged global support team for daily supporting activity and managed level 3 production support
• Developed a Data Virtualization POC to federate heterogeneous global databases, create a LDW Logical Data Warehouse , and streamline data integration for downstream applications
• Defined application deployment policy and procedure to ensure developers follow the deployment guideline, developed standard development guidelines with error checking for ETL and database development, and defined database access security policy to ensure proper permission access of all database environments

Confidential

Development Manager, Data Warehouse/Business Intelligence

• - Risk Reporting using large data Warehouse, ETL, OLAP and BI Reporting Architecture and Implementation in Commodities Trading
• Defined BI Business Intelligence reporting and data integration strategy, architected a new high-availability global BI infrastructure to support business, managed BI project implementation with new directions and best practices, and built users' confidence on this new system and it became a core enterprise analytic reporting systems
• Led/Managed a new team to build a very large data warehouse, performed data analysis to identify data sources, engineer complex multidimensional data marts and SSAS OLAP cubes using SQL Server Analysis Services, developed high-volume Informatica ETL to load data into data warehouse, front-end reporting applications, SQL Server Reporting Services and SAP Business Objects, managed 24/7 real-time global data feed process, and built a new information architecture to efficiently facilitate information flow and business processes
• Played a key role and interface with business users on trading floor, gathered business requirements and managed SLAs, managed development projects, regularly updated senior executive management committee on project status, and provided production support for 400 global users, trading floor and risk management on daily issues and requests
• Created ad-hoc OLAP reports to enable senior management understand the impact of regulatory capital requirements and forecast capital usage
• Implemented/Integrated ETMS Energy Trading Market Surveillance compliance application with reporting system to automatically address monitoring and surveillance of commodity trading activities in global markets

Confidential

Build Manager, Risk Reporting and Analysis

• Managed 5 million group budget, Implemented BI and data acquisition strategies for new BI program and architect large scale enterprise BI Business intelligence application from ground up including BI POC process and vendor contract negotiation, large data warehousing with data integration from ODS and reference data, Oracle BI reporting platform and Essbase cubes for risk management
• Built/Managed a distributed development team with 20 onshore and offshore staffs to implement full lifecycle DW/BI projects including design, architecture, development, quality assurance, implementation, and operational support
• Built partnerships with vendors and collaborate with Infrastructure and Operate teams to build BI and data warehousing infrastructure, operating model, and DR Disaster Recovery process based on SLAs
• Designed/Built real-time BI reporting platforms integrated with sophisticated actionable workflows, BPM Business Process Management with 200 real-time daily data feeds, and predictive analytics reports with scenario analysis

Confidential

Program Manager, Global Data Management

• Managed and executed global strategic MDM Master Data management program with SOA architecture, worked with business stakeholders and IT to monitor project execution and ensure quality program implementation to facilitate Steering Committee and enterprise system integration process
• Developed global data and system migration and integration strategy, performed data analysis and identified global data sources, defined data models, led a distributed development team to develop data process to migrate data from global application systems and load it into enterprise data warehouse, and distributed the data to downstream global applications thru Web Services and enterprise business intelligence reporting systems

Confidential

Business Intelligence Lead - Consultant

• Collaborated with distributed infrastructure teams to build server environment for business intelligence analytics reporting platform and developed high-volume Informatica ETL process from global data source for risk reports
• Developed large complex SQL Server SSAS OLAP cubes from ground up, performance tuning large UDB databases and cubes, loaded 12 million rows into a fact table, and integrated OLAP cubes with ProClarity data visualization reports

Confidential

Manager, Business Reporting

• Developed data migration and acquisition, enterprise data warehousing and reporting strategy, led a full-life cycle of large-scale data warehouse and business intelligence infrastructure and development from ground up, and successfully implemented and rolled out a robust enterprise business intelligence solutions to business groups
• Designed/Developed 10 TB data warehouse architecture, large complex data marts/OLAP cubes, Reporting Services Web portal integrated with SharePoint, complex ETL processes for high-volume equity trading data, and delivered quality data with employing proper validation and auditing measures
• Designed high-availability business intelligence and data warehouse architecture and developed SSAS 2005 OLAP cubes based on clustered 64-bit SQL Server 2005 to empower business groups through BI reporting analytics platform
• Directed/Managed a development team to respond effectively and ensure quality of the technical team's deliverables, managed all phases of data warehouse/reporting project lifecycle, defined project objectives/deliverables/milestones and finished many critical reporting projects ahead of deadlines
• Led a cross-function team to develop a platform using Reporting Services Web farms integrated with trading applications and distributed thousands of trading execution and P L PDF reports to external clients daily
• Collaborated with IT infrastructure teams to design enterprise real-time data archiving infrastructure and data replication, storage requirements and DR disaster recovery infrastructure in Storage Area Network SAN , developed a Business Continuity Plan, and content management to meet compliance requirements

Confidential

OLAP/Data Warehouse Manager

• Successfully led development team to design and develop large, complex data warehouse and BI analytics reporting systems using IBM DB2, Microsoft SQL Server 2000 Analysis Services, performed Dimensional Modeling processes to design data marts and OLAP cubes with fact and dimensional schemas based on business requirements
• Led a group to build complex cubes for marketing and finance groups to enhance business analytical abilities to trace consumer shopping behavior, and developed shopping basket data visualization and dashboard reports to provide insight into bundling offerings or improved online campaign performance
• Tuned performance on large cubes with billions of records to solve data processing issues, remodeled/consolidated complex OLAP cubes, analyzed user's usage and designed appropriate aggregations with optimum MOLAP storage types to improve query performance, and automated cube archive process

Confidential

IT Developer eCommerce and Database Development

• Built a high volume e-commerce web site with shopping carts integration with EDI and backend integration, and performed physical logical relational database design and development
• Managed database servers, gathered business requirements, decided required data sources, developed ETL process using DTS, built OLAP cubes and dimensions, and developed OLAP reports using Excel PivotTable/Chart

Technology ASP/ASP.NET, C , ADO.NET, SQL Server, OLAP

Technology Expertise

• Analytical and Communication: Excellent business analysis, problem-solving ability, and articulate in verbal and writing
• ETL: Informatica 7/8, SSIS SQL Server Integration Services , working knowledge of SAP Data Services
• Database: Oracle 10/11, SQL Server 7.0/2000/2005/2008/2012 SSIS, SSAS/OLAP Cube, SSRS , Logical and Physical Database Model Design, Data Warehouse, ER/Dimensional Models, ACCESS, Sybase, IBM DB2, Working Knowledge of Hadoop/MapReduce/HDFS/Hive/Pig, Splunk, NoSql MongoDB/Hbase, In-memory database IBM Netezza, EMC Greenplum
• BI: Customized BI reporting portal in .Net and Flex, SQL ServerBI SSRS and SSAS OLAP , SharePoint, Excel PowerPivot and Power View, Crystal Reports, Business Objects 3.x, Oracle BI, QlikView, Microstrategy 9.x, Data Visualization, Predictive Analytics
• Database/Model: Star/Snowflake Schema Design, Embarcadero DBArtisan, Toad, Erwin
• Scheduling: Autosys, Tidal Scheduler, SQL Server Agent
• Computer Languages: T-SQL, SQL PL, PL/SQL, MDX, RDL, C , ASP/ASP.NET, ADO.NET, Silverlight, XML, XSLT, JavaScript and Sencha Framework, JSON, RESTful, Extjs, Flex, CSS3, HTML 5, AJAX, Shell Programming
• Systems/Applications: Windows, Unix/Linux, IIS/Weblogics, SOA, Unix, MS Office, MS Visual Studio 2005/2008/2010, MS Project, MS Visio, WebTrends, SharePoint, Cloud Computing, Splunk, Knowledge of Cisco Composite, Salesforce, Working Knowledge with SAP ECC/CRM, Amazon Web Services AWS , Oracle Identity Management
• Project/Change Management: ServiceNow, Remedy, HPQC, Jira, Clarity, Microsoft Project
• Source Control: Perforce, SourceSafe, Rational ClearCase, Subversion, Star Team