SUMMARY:

• A dynamic, creatively thinking, results - driven IT professional with extensive work experience as Business Analyst, Data Analyst. Independent and highly motivated team player that approaches new challenges with a ‘can do’ attitude
• Excellent analytical skills in impact analysis, root cause analysis - ability quickly analyze data to identify key insights and apply them to the business
• Hands-on work experience of data modelling, data analysis, data mapping, best practices with strong Oracle/MS SQL Server, SQL skill sets
• Marketing Automation and Database Marketing: in-depth knowledge and working experience of Marketing processes in IBM Unica campaign and eMessage management system
• Ability to bridge the gap between business and technology to ensure delivered solution meet business requirements with minimal iterations
• Broad and deep knowledge of Financial reference data technologies with directly supporting experience of financial reference data for Morgan Stanley
• Strong SQL reporting skills with the ability to create SQL views for data analysis, work experience with the design and development of visualization reports in Tableau

TECHNICAL SKILLS:

• Data Analysis
• Data Modelling
• Data Mapping
• SQL
• Excel
• Tableau
• Data Warehousing
• Database Marketing
• IBM Unica
• Operation Support
• XML
• Oracle HRMS
• Python
• JavaScript
• UNIX
• Cognos
• SharePoint

WORK EXPERIENCE:

Confidential, San Jose, CA

Sr. Business Analyst

Responsibilities:

• Led efforts in supporting financial reference data service for investment bank: Morgan Stanley.
• Played a key role in comprehensive analysis of securities between XML files and database, and identified the cross-referencing mapping criteria to match the securities between Exchange feeds and market vendor feeds (Bloomberg/Reuters).
• Supported Financial Master Data Management (MDM) system, implemented daily reports to track SLA metrics, exception tickets, client inquiries.
• Provided root cause analysis and preventative measures for any data quality issues that may occur in day to day operations.
• Increased securities cross-referencing percentage 40% by re-engineering data mapping rules and developing/implementing operational best practices procedures.
• Analysed and maintained financial reference data workflow in a complex database by using advanced SQL to ensure the data validation in place at different stages of data processing cycle.
• Reviewed and updated the Exchanges feeds mapping document to verify SmartStream distribution XML files have valid elements and attributes.
• Improved the team members technical and analytical knowledge by providing mentorship and guidance.
• Designed and delivered the weekly cross reference visualization report by using complex SQL queries and Tableau. The report served as a KPI that demonstrated overall Exchanges and Bloomberg/Reuters cross-reference rates in the distribution XML files which SmartStream delivered to Morgan Stanley.

Data Lead/IT Engineer

Responsibilities:

• Played a key role in Marketing IT support group. Responsible for Cisco Marketing data daily support activities and data quality.
• Facilitated weekly meeting with business to address client cases and concerns. Prioritized bug fix to ensure data correction and system performance meeting and exceeding the business expectation.
• ‘Marketing Data Operational Store (MODS)’ was the data hub for Cisco marketing activity. Data was obtained from various sources into MODS (through ETLs), it maintained all the marketing contact information and responses that Cisco received as part of the marketing campaigns and ran the rules to classify the contacts as ‘lead candidates’ and/or leads for the Sales team (Salesforca.com) to follow up so they became customers.
• Proven track record of implementation of Marketing data enrichment process. Increased Lead generating rate 20% by improving overall data quality.
• Performed data validation as part of integration, created end-to-end test cases in Quality Centre to ensure the valid data flowing to Data Warehouse.
• Supported IBM Unica Marketing Campaign application - from Campaign management, Contact/Response data processing to Lead generation and integration with Salesforce.com. Teamed up with Campaign specialists to resolve Unica campaign flowchart issue and data issue.
• Identified and resolved the root cause of campaign data discrepancy between BI reporting and Marketing data warehousing.
• Worked as IT engineer in Cisco Human Resource IT group earlier. Responsible for developing and supporting of Cisco Compensation Tool (MAT) which being used by 5000+ Cisco Global managers for Equity increase, Bonus program, ongoing stock granting and Sales Focal program.
• Played a key role as SME in Cisco Compensation program implementation. Supported PeopleSoft, Oracle HRMS, Cisco rewards tools, web letter tool, etc.
• Participated HR system migration from PeopleSoft to Oracle HRMS and led supporting of Oracle Time and Labour, Payroll process.

Software Engineer

Responsibilities:

• Developed and supported e-commerce system. The system was used for serving IT resellers, retailers and original equipment manufacturers (OEM).
• Delivered the system functional requirement and technical specification.
• Worked on database design. Implemented MS SQL server stored procedures and triggers. Wrote web pages with HTML, JavaScript and JSP.
• Collaborated with business throughout the implementation particularly in the management of deliverables and User Acceptance Testing (UAT).

Programmer/Analyst

Responsibilities:

• Developed Merchandise Authorization (RMA) application in Customer Support Centre. The application improved process efficiency and reduced the manual error by 60%.
• Supported ETL process from multiple data source (including data source from Hitachi America Sales and Japan)