SUMMARY:

• PMO, Project management, Oversight (software development life cycle):
• Performed oversight functions on GOCO (government - owned, contractor-operated) Defense Travel System operated by Northrop Grumman at the Department of Defense’s Manpower Data Center (2016). Oversight functions included reviewing transactional and reporting systems, verify, validate audits and reports provided by Contractor on behalf of the government.
• Experience with Capital market, Loan Servicing at Confidential Residential Lending; with Insurance and Investment management at LPL Financial, HD Vest Financial: Worked with external consultants to build enterprise data warehouse to consolidate multiple sources of data for reporting. Reverse-engineered a set of operational reports (delinquencies mortgages) to rebuild them on Business Objects XI platform with more functionalities to help the business managed delinquencies more effective.
• System analysis, design and architecture for on-going or new applications:
• Navy Standard Integrated Pay & Personnel System (NSIPS, 2012): performed system analysis and review of data mappings, data flows and data transformations that made up of NSIPS/ODS reporting system to identify issues, problems, deficiencies in data integrity, data redundancy, information accuracy and as a direct result, system performance. Recommended solutions to alleviate issues and problems.
• Data management in high volume, large scale environment:
• Supported Digital marketing and Customers analytic at Sony PlayStation (2013): produced weekly digital marketing campaigns in the order of 1-10 million of emails selected from a vast system of more than one hundred million of customers and billions of transactions historically collected over the years (each customer played multiple games on multiple occasions).
• Customer services, problem solving and communication: excellent communication (verbal and written) with technical or non-technical stakeholders. Proven problem-solving, both in technical issues (system, software, hardware) or business domain (processes, people, ). Servicing both internal customers and external customers, in private sector (major corporations) and public sector (defense contractor).

TECHNICAL SKILLS:

Technology and Tools: Domains and Systems Capable and Competent in Mining Mountain of Data (Billions of Transactions) to Find Insights, Patterns, Behaviors, Hidden Relationship Core Competencies: Research, Requirements, Data Analysis, Data Diagrams Data Acquisition, Analyzing, Compiling, Process, Modeling Business Process Re-engineering, Business Process Management Business Requirements Document (BRD), Functional Requirements Document (FRD), Technical/Solution Design Document (SDD/TRD) Agile /Scrum Development Project Lifecycle Management Project Scheduling, Budgeting & Cost Controls Leadership, Team Building, Quality Assurance Testing (Acceptance, Performance, Regression, UAT) Applications & Software: Microsoft Office, Sharepoint (Access, Excel, PowerPoint, Publisher, Visio) Development & Reporting Tools: ASP.NET, Business Objects, DreamWeaver, Informatica, Outlooksoft, Oracle, Peoplesoft, Toad, Tableau, Qlikview, Spotfire Databases: Oracle Certified Professional OCP9i (2002) Experience with Oracle 10g-12c Microsoft Certified Technology Specialist MCTS (2007) Experience with MS-SQL Familiarity with Sybase, Teradata Proficient in Windows, Unix, Solaris, Shell Scripting

PROFESSIONAL EXPERIENCE:

Information Technology Specialist

Confidential

Responsibilities:

• Support PMO in performing its oversight functions in this GOCO (government-owned, contractor-operated) system by Northrop Grumman:
• Audit function: review and validate various reports provided by Contractor to Department of Defense Inspector General Office (DoD/IG) for their periodic operational audit regarding travel debts management and collections.
• : reviewed 400,000 outstanding debts in 4 days; identified millions of dollars of outstanding, uncollected debts as well as underlying issues, problems, errors that led to faulty system and its reports. Proposed solutions to fix both the system and its information delivery mechanics (reports).
• Institutional users support: support the DTMO Compliance group. Defense Travel Management Office is an agency who is responsible for this DoD’s 5-billion-dollar program. Compliance group is responsible for identifying non-compliance payments through data collections and analytical reporting.

Financial Services Business Consultant

Confidential

Responsibilities:

• Advised, assisted and supported HD Vest customers with products, services and sales offerings:
• Create awareness of Confidential products, services and offerings to individuals, family members, business owners in the local communities.
• Advised and assisted customers in the selections of HD Vest offerings to fit their own financial circumstance and benefits, short term and long term. Provided sales, services and supports for products selected.

Enhanced Financial Analytic

Confidential

Responsibilities:

• Supported EFA, CA and GRC projects which were very important to business since they show money inflow and outflow between platforms (brokerage or advisory), among fund families (ETF, mutual funds or fixed income) of millions of on-going accounts upon trading or rebalancing.
• Performed complex analysis on very large data sets received from financial data vendors (Thompson-Reuter, First Clearing). Created DDD (Data Requirements Design Document) to specify data sources, data mappings and data transformations (toward star-schema model) to ensure models and its elements (facts, dimension, attributes) satisfied business requirements for enterprise reporting.
• Worked with clients’ onsite resources, collaborated with offshore developers to ensure system was populated with accurate data following approved design documents. Advised and assisted with Master Data Management (MDM) program (golden records from disparate sources).

Confidential

Responsibilities:

• Part of its core business, Confidential conducted thousands of trials annually, each trial involved hundreds of subjects, from multiple sites around the country. Yet, producing compliance reports accordance to FDA rules have always been challenges due to multiple, scattered data sources.
• Built on Business Requirements Documents (BRD) prepared by client, worked with Senior Manager and Director to create as-is processes diagrams in order to convey to business partners for consensus building.
• Authored Technical Requirements Document (TRD) with to-be system diagrams for building a global data repository which consolidated data from dozens of sources systems (Oracle Clinical, Argus and Righttrack among other) into a single repository. Repository to produce a set of 10 enterprise metrics reports used for strategic planning, quality management and regulatory compliance purposes.

Customer Analytic

Confidential

Responsibilities:

• Supported Marketing Managers in conducting weekly marketing campaigns, monthly Newsletter by producing tens of millions targeted potential customers’ emails from hundreds of million data points (consoles bought, games played and demographics segmentations).
• Performed A/B testing to determine how customers responded differently to each campaigns’ variations, formulated hypothesis, proved or disproved each of them where necessary to discover insights, patterns from customers’ behaviors.
• Employed more complex schemes of customers’ segmentations (using tenure, number of games played, time spent on each game and customers’ life-time value) to discover potential business opportunities for marketing campaigns (based on customers’ quartile ranking, games played by each quartile).

Confidential

Responsibilities:

• Confidential transactional system ran on Peoplesoft with its associated Operational Data Store built in circa 2000s and used pure PL/SQL codes and thus were cumbersome, difficult to maintain, had performance issues and often provided inaccurate or incomplete information.
• Manpower, & System (MPTE schemas) was recently developed by another defense contractor in an effort to modernize Confidential system. However, old and new system have huge gaps in data compatibility and consistency due to different design schemes.
• Tasked with reviewing NSIPS data flows, data mappings, data transformations along with reports produced from current system to identify issues, problems, deficiencies in system performance and data accuracy. Issues and resolutions documented and recommended.

Confidential

Responsibilities:

• TRS Accounts are top 1% of 1% highest revenues producing accounts at Confidential . Combining sales performance data from the marketplace ( Confidential .com) and customer services data from Siebel Analytics would help to develop more of those accounts (based on room for improvement).
• Collaborated with Business Managers and Account Managers to identify essential metrics (such as Confidential ’s wallet, electronics wallet and total wallet), employed complex and sophisticated rating and ranking schemes (such as quadrants ranking based on accounts’ revenues generating potential and other factors) to complete BRDs and FRDs for this system.

Confidential

Responsibilities:

• Having ERP systems on Sage and QAD, quotes on salesforce.com; however, other systems (booking, backlogs, commissions) were still on personal desktops, thus providing comprehensive, on-time, accurate reports on product’s profitability have always been challenges at Cepheid.
• Led a small team of resources (onshore and offshore, internal and external combination) to gather business requirements, to design, develop, tested and implemented Sales Data Mart which integrated multiple data sources (above) utilizing star-schema design on Microsoft SQL Server 2008 platform.
• Data Mart and Dashboards created in Business Objects facilitated products and profitability tracking with reports developed in BOBJ XI that shown best-selling versus most-profitable products by each market, customer segments, regions and marketing channels.

Confidential (San Jose, CA)

System Analyst, Data Architect

Responsibilities:

• Flextronics: supported major upgrade to its planning and forecasting system on SAP’s Outlooksoft BPC which utilized most recent MSFT databases technology. Daily engaged with management and resources at client site; partnered with SAP Consultants; collaborated with Program Managers at Microsoft headquarter to produce regression testing plans, to execute patches and hot fixes to ensure customer’s successful upgrade
• Moduslink: dispatched to Singapore to help this partner with systems/applications tuning in project that directly involved Microsoft itself (Windows Vista Redemption Program). Examined multiple interfaces of data among systems (Websites to take orders, offshore fulfillment partners, Licensing offices in Redmond) to determine bottleneck and worked with related parties to have them resolved quickly to satisfaction of all involved parties.
• First American: supported first major migration of its DW on SQL/2000 to SQL/2005. This DW ran on HP/Superdome to support applications with worldwide stakeholders, critical to its business and having small windows of maintenance which made it even more complex environment.

Confidential

Responsibilities:

• Having half a million subprime mortgages originated or currently in services, however, Ameriquest didn’t have sufficient system to manage complete loan lifecycle (from origination to maturing included servicing). That was primary objective for EDW (Enterprise Data Warehouse).
• Worked with external consultants, offshore developers to build EDW by reviewed schemas, wrote sources to targets mappings. Once mappings were built by offshore team and shipped back, wrote scripts to verify if data were transformed accurately according to specifications.
• Utilized newly created enterprise data warehouse infrastructure, reversed engineered a set of risk management reports which were written on Access and Excel in semi-automated mode. Generated reports using Business Objects and Universe design.
• These reports shown delinquencies risks (30/60/90 days) by loan sizes (regular or jumbo), loan types (ARM or fixed), LTV (loan-to-value) and demographic regions which helped Customer Services Representatives proactively managed defaults risks.

Confidential

Responsibilities:

• Supported Chief Finance Officer (CFO) in generation of monthly, quarterly and annually financial statements reports by extracted data from corporate systems on Oracle databases.
• Once reports were created, assisted with variances analysis, return-on-investment analysis on IT projects such as IVR (interactive voice response system) and OTS (automatic dialing system).
• OTS-Automated Dialing System helped to reduce cost in marketing operations while IVR-Interactive Voice Response System lessened customer services and support expenses.

Confidential

Responsibilities:

• Collaborated with Financial Analysts, Production Planners, Business Managers and Oracle Consultants to gather business requirements from existing demands planning processes which were semi-automated on hundreds of Excels spreadsheets.
• Created Business Requirements Documentation (BRD) and Functional Requirements Documentation (FRD) to build Global Demands Planning Solution (GPS).
• GPS employed Oracle Express multi-dimensional databases technology with built-in functions, formulas and forecasting models which facilitated the processes of multi-site demands forecasting, roll-up and push-down planning almost seamless.
• Net results: old processes took almost a quarter to forecast for next quarter, new process took a little more than a week and resulted in narrower Plan-Actual variances.

Confidential

Responsibilities:

• Responsible for test, build, deploy and on-going support of EDAS3 (Engineering Data Analysis) which was developed with PowerBuilder and used for engineering communities to extract data from engineering data warehouse with visual, easy to use features compared to script-based reports previously.
• Supported Global Engineering Data, a network of manufacturing data from facilities in Austin, Germany and Malaysia. These are high-volume manufacturing data (due to complex processes within semiconductor industry), collected in near real-time (hourly interval) for the purposes of yields and processes improvement.
• Assumed role of Databases Administrator (Oracle 7/8 on Sun/Solaris platform). Support and maintenance tasks involved anything from index tuning and rebuilding for performance improvement (which were critical due to its high-volume nature) to data integrity and accuracy (following replication schemes around the world).

Confidential

Responsibilities:

• Global Data Warehouse network which was a general business system used for planning and forecasting at Confidential . Austin node, ran on IBM/SP2 with Oracle 7.3 was one among 9-node worldwide network.
• Responsible for daily operations, which among other tasks included data batches loading, reports generation, data replication, users, etc.
• Collaborated with Oracle DBAs for sporadic needs such as tablespace expansion, tables creation, index rebuilding and with System Administrator for system performance, load performance.
• Implemented, modified, created new reports using PL/SQL codes (to conform to data warehouse framework and infrastructure) to support users ever expanding needs.