CORE COMPETENCIES:

• Research, Requirements, Data Analysis, Data Diagrams
• Data Acquisition, Analyzing, Compiling, Process, Modeling
• Business Process Re - engineering, Business Process Management
• Business Requirements Document ( Confidential ), 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)

TECHNICAL SKILLS:

Applications & Software: Microsoft Office, Sharepoint 2010-2013 (Access, Excel, PowerPoint, Publisher, Visio)

Development & Reporting Tools: ASP.NETBusiness ObjectsDreamWeaverInformaticaOutlooksoftOracle, 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 2008-2014, 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 Confidential (government-owned, contractor-operated) system by Confidential:
• Audit function: review and validate various reports provided by Contractor to Confidential Inspector General Office ( Confidential for their periodic operational audit regarding travel debts management and collections.
• Accomplishment: 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 Confidential Compliance group.
• Defense Travel Management Office is an agency who is responsible for this Confidential ’s 5-billion-dollar program. Compliance group is responsible for identifying non-compliance payments through data collections and analytical reporting.
• Accomplishment: assisted the Confidential Compliance group with sources and methods of collecting and analyzing data from high volume of data in the transactional and/or reporting systems. Complex schema involves Authorizations, Vouchers, Payments and/or Debts and Collections on millions of trips taken by Services members annually.

Financial Services Business Consultant

Confidential

Responsibilities:

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

Principal Consultant

Confidential

Responsibilities:

• Supported Confidential, Confidential and Confidential 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.
• Created Confidential (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 ( Confidential ) program (golden records from disparate sources).
• 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 Confidential rules have always been challenges due to multiple, scattered data sources.
• Built on Business Requirements Documents ( Confidential ) 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 membership 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 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, Training & Education 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 Confidential 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.
• 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 Confidential and Confidential for this system.
• Led a small team of ETL Developers and Reports Writers to build a set of sophisticated OBIEE reports (including scattered-plot graphs). Confidential dashboards and reports helped Account Managers with prioritization their efforts by focusing on accounts with more potential than other (using macros metrics of “Impact to and Influence by Confidential ”).
• 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 Confidential XI that shown best-selling versus most-profitable products by each market, customer segments, regions and marketing channels.

Confidential, San Jose

System Analyst, Data Architect

Responsibilities:

• supported major upgrade to its planning and forecasting system on SAP’s Outlooksoft Confidential which utilized most recent Confidential 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.
• 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.
• Supported Chief Finance Officer ( Confidential ) 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.
• 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 ( Confidential ) 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.
• 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).
• Supported Global Data Warehouse network which was a general business system used for planning and forecasting at Motorola. 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 training, 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.