SUMMARY:

• 10+ Year experience in IT sector exposure to diverse technologies, business operations, a service and client focused.
• 8+ Year experience in business system analysis and design, analyzing business process, gathering detailed requirement and translate them into system requirement specification, business requirement documents.
• 8+ Year experience in database management (RDBMS), data warehousing, data modelling, both physical and logical, star and snowflakes schema, data normalization and entity relationship
• 8+ Year experience SQL/TSQL, PL/SQL, ETL - SSIS, writing queries, stored proc, UDF, views, data manipulation, data cleansing, data mapping/profiling, data validation and analyzing, building master data, data conversion from old to new DB.
• 8+ Year experience in business intelligence, data analytics, developing and managing reports, dashboard and data visualization, using Spotfire, Tableau, SSRS, Crystal Reports, Intelligence, Cognos, Excel, VCL Delphi reporting tools,
• 8+ Year experience in software development, coding, debugging, using structural, OOP, XML, HTML, JavaScript, Pyhton.
• 7+ Year experience in Quality Assurance (QA) all aspect of the system from UI, task/loading performance, data validation, UAT/BAT testing, system deployment/database deployment from development to QA to production environment.
• 6+ Year experience writing documentation data or work flow diagram, data dictionaries, test case, job aid and users guide.
• 7+ Year experience software programming (OOP) including commercial application, and custom applications.
• Experience working with large dataset like Azure usage data, Trades, P&L, MFL, Securities, SalesForce, Finance (Capital Market), Insurance data, employee’s data, transactional data, PeopleSoft data, Taleo, BAAN.
• Formulate and implement best-practices around data mining, data aggregation, data consumption, data visualizations and user interface design to deliver high quality information, reporting and analysis
• Identify and resolve medium to highly complex production problems for support of applications, identify root cause and defining actions or recommend solutions to eliminate recurrence aligned with business objectives.
• Strong analysis and logic problem assessment/solving skills and attentive to details.

TECHNICAL SKILLS:

Programming Reporting Languages: 4+ Year Spotfire; JavaScript, HTML, XML, Iron Python 2+ Year Tableau; 5+ Years Crystal Reports/ SAP Crystal Enterprise 3+ SAP BO Web Intelligence, Cognos Reporting 6+ Year MSBI Stack, SSIS, SSRS, Excel, VBA 10+ Year Delphi: OOP, Delphi 4/5/7, Delphi 2009/2010, Delphi XE/XE3/ X7, Delphi Berlin/Tokyo. 5+ ADO, FireDac, MIDAS, dbGO, DataSnap, 3rd party component,DevExpress, Raize, Teechart, Gnostice 5+ Year VCL Report QuickReport, ReportBuilder, AceReport, FastReport1 Years SAP BI/DW, SAP BO, SAP BEx Query, BEx Analyzer,BEx Designer 2+ Year C#, ASP.NET, ADO.NET

Databases: 10+ Years MSSQL Server (2000,2005,2008,2012,2016) SQL, T-SQL, Store proc, UDF s, Triggers, ViewData warehouse design, data modelling, table relationship and data entity, data normalization, data transformation, ETL, data analysis,data mapping, data cleansing.3- Oracle 9i,10G, SQL, PL-SQL, Toad, Advantage Database,6+ Year Access DB

ERP System: SalesForce, Dealogic,PeopleSoft, Taleo, BAAN, Amtech, Paymate Sofware (Clarity, Acclaim), BOS/e, Emerge,EWA

Others: Microsoft office (Excel,Word,Powepoint,Visio),Tidal, Toad, Multilizer, PVCS,SVN.

Methodology: CCMI, SMART, SWOT, SDLC, RDBMS

PROFESSIONAL EXPERIENCE:

Confidential

BI/Spotfire Developer

Responsibilities:

• Work with VP, director, business owner, end users to gather and analyzed business requirement.
• Lead development of Dashboard Trader and Securities, Marketing and Events, Research Reader Ship, Expenses using Spotfire.
• Maintain Spotfire Server, scheduling reports, users’ access, design information link, data sources, datasets on server side.
• Lead design database warehouse (MARS) for reporting and dash boarding that ingest large dataset Trades Products, Securities, CRM products,
• Design MARS data warehouse, data model, table schema and entity relationship
• Developed SSIS packages, SQL/TSQL scripts, stored procs, views to extract and transform and load data into MARS database such as SalesForce,Trades, Bloomberg, Imagie, BPSA, StreetContext,BlueMatrix,Dealogic, FlatFiles
• Do database documentation such schema, data model, SSIS process, reports doc
• Develop CRM Reports, Trades Reports using SSRS, Crystal Reports, Adhoc reports and data analysis.
• Lead testing POC server MSSQL 2016 new technology In memory database.
• Lead the development of Trade Data Community Dashboard using Spotfire 7.7, that shows Trades Source System (Calypso, Murex,Bloomberg, InTrader, WSS etc.) daily level either Gold, Silver or Bronze.
• Successfully implemented Trade Data Community Dashboard and used by 30+ users in data governance, analyst, managers in daily basis.
• Dashboard track Daily System Control check, Material Term Comparison, Products Values Check, Liquidity, MFL, Control catalogues.
• Dashboard track daily, monthly consumer control and regulatory reporting like H4,FR2520a,FX Rates, Volcker, MFL values, Proof of balance, Trades, P&L
• Developed Daily P&L Reconciliation Dashboard using Spotfire 7.7. This report used to spot daily difference between daily post trades product amount and the analyst reported amount. Also used to reconcile with other dashboard reported amount in daily, monthly, month to date, quarterly and year to date.
• Perform ad hoc data analysis and reporting.

Confidential

Business System Analyst & BI Developer

Responsibilities:

• Worked closely with Sr Manager, end user to gather and analyzed business requirement and translate them into technical/requirement specification.
• Led development of Cloud Cost and Usage Allocation charge back reporting for the whole enterprise.
• Successfully implemented Cost and Usage Allocation reporting and used by IT, support managers, subscriptions owners, VPs and IT Finance.
• Design MSSQL database warehouse and data model, table schema and entity relationship for Azure data, develop data mapping, into transit code, application code, resource group, locations, EMP Code to align cost and usage to LOB’s.
• Developed SSIS packages, SQL/TSQL scripts, stored procs, views to extract and transform and load azure data in daily basis, weekly basis, monthly basis.
• Developed, test self-service report using SSRS and roll to production SQL server such as daily, weekly, monthly Cloud Azure cost and usage.
• Analyze Cloud Azure data cost and usage of networks, applications, virtual machines, data writing, reading usages, market place pricing etc.
• Design MSSQL database warehouse and data model table schema of Server Inventories for the whole enterprise both physical and virtual servers, virtual machines, data center used for executive reporting and dashboard creations.
• Developed SSIS packages, stored proc, SQL/TSQL scripts, extract and transform and load all data coming from different System such SIMS, Azure Cloud, Private Cloud (IBM), vRA, Nutanix and excel feed coming different global users and align to EPM Code and LOB’s.
• Automate mailing list for Global Technology Services for SVP, VP’s, Directors, for message broadcast or, townhall invitation, directly reading from HR data.
• Consolidate all GTS IT projects compiled all approved business case, compiled cost saving amount, cost expense for fiscal year budgeting purposes.
• Develop technical documentation, database and server environment, data flow diagram, data dictionaries, reports inventories, frequencies, reports job aids.

Confidential

Business System Analysts

Responsibilities:

• Worked closely with business owner and end user to analyzed and review existing process and gather detail business requirement for new reports project and translate them into system and business requirement specification.
• Design MSSQL database warehouse and model table schema and entity relationship for Employee Job Data Reporting for the whole enterprise.
• Developed SSIS packages, SQL/TSQL, queries, stored proc to load and transform employee data coming from Peoplesoft HCM, Taleo, Excel,EWA
• Develop Weekly, Monthly, Quarterly, Yearly HR reports such Employee Job data report, Talent Data reports, FTE Reports, Diversities, Job Grades, Hire and Termination, Employee Hierarchy, Job Grades reports for whole enterprise using SSRS and automatically upload to SharePoint sites.
• Developed Employee dashboard, matrix using Spofire such Age Composition, LOBs/Enterprise Head Counts, KRI FTE’s, Senior Leaders, Diversities for whole enterprise and LOB’ using Spotfire 6.0
• Designed Employee Talent report using SAP Web Intelligence from TALEO, employee report, data extract queries using PeopleSoft Query from Peoplesoft.
• Performed employee ad-hoc reports, data analysis/investigation and perform additional duties to meet all business needs for management information.
• Performed user’s acceptance testing (UAT), business acceptance test (BAT)
• Performed QA testing report, data analysis, validate and compare data accuracy, between EWA and Peoplesoft, Taleo data.
• Develop technical documentation, database and server environment, data flow diagram, data dictionaries, reports inventories, frequencies, reports job aids.
• Developed desktop application to download employee data straight to Cloud PeopleSoft HCM which improve and increase report productivity up to 85%.

Confidential

Business Analyst-Developer

Responsibilities:

• Worked with business owner, end users of the following system, Wage Loss System, Shelter Rebate System, CIS - Claim Intake System to gather and review business requirement as part of the system maintenance.
• Maintained Software program, enhanced update program, fix users’ issues, bugs, and reflex changes in government mandate using Delphi. (OOP Pascal).
• Perform QA, UAT testing in accordance to user and business requirement.
• Enhanced, fixed issues, developed new reports of more 70+ for workers, employers, health services, government legal forms reports using SAP Crystal Reports, and SAP BO Web Intelligence and successfully implemented in the EMERGE System - Worker Claim Management System.
• Perform QA testing in development, UAT environment and worked closely to end users before moving them into production environment.
• Design MSSQL database and convert Annuity System from Access to SQL server database.
• Performed Ad hoc reports/data analysis and investigation and do additional duties as required to meet all business needs and support to end users.

Confidential

Business System Analyst / Developer

Responsibilities:

• Worked with Stakeholder, VP-Finance, Accountant, Sales managers, end users to conduct and review process, gather detail business requirement and translate them into technical requirement, system requirement, and business requirement specification. Solution Architect of the following system: Rebates and Sales Commission System, Product Gran Costing System, Profit Sharing System, GL Reporting System all this system was manual process and I transformed them into database driven software/application and successfully implemented.
• Developed and design application (SRS,BRD,ERD) in accordance to business requirement.
• Design MSQL database warehouse and data model, table schema entity relationship data normalization, stored proc,views of Rebates, Sales and Commission System, Product Gran Costing System, Profit Sharing System, GL Reporting System.
• Design application system using Delphi, from user interface, form design, screen design, program coding, debugging, testing, implementing.
• Developed SSIS package to extract data from ERP system AMTECH, BAAN.
• Integrate GL posting to BAAN from Sales Rebates Commission, Costing system
• Performed QA/UAT/BAT testing, worked closely to end users, accountant validate, analyze data, make sure business requirement was met and correct.
• Trained end user’s walkthrough application and system changes.
• Document changes, issues, and defects through traceability matrix using excel.
• Implemented and do technical and user support.
• Rebates and Commission System - Tracked and monitor sales, commission, rebates for the company. Tracked sales reps commission contracts and policies, customer rebates contract. This system delivers 98% accuracy of commission and rebates and increase accountant productivity up to 95%.
• Product Costing System - Tracked customer product cost by pound, rolls, millions of prints which deliver 90% time of cost accountant productivity.
• Profit Sharing System - Tracked and compute employees profit share, bonus. for top management translating KPI goals to dollar value.
• GL Reporting System - Used to reports profit center expenses and used to also for top management reporting, which saves them 60% printing cost.

Confidential

Developer

Responsibilities:

• Developed application (Data Loader) a web portal use for data migration from their products. Using ASP.NET, C#, Javascript, XML, HTML, MS SQL 2008

Confidential

Data Analyst /SQL Programmer (Fulltime)

Responsibilities:

• Worked closely with campaign managers or owners to identify client requirement such data inclusion and exclusion, data segmentation and translate them into program or SQL scripts to pull the data.
• Provided data analytical and data processing services in support of mailing list for marketing, and fund raisers in accordance for business requirement.
• Validate and test data (UAT) with campaign owner to make sure all client requirement or expectations are met, prepare proof counts & sample data.
• Developed and implement query template used for data selection, data cleansing, data merging, data import for various Fund-Raising Organization to establish consistency query result.
• Write programs (SQL/T-SQL) per client specification or requirement.
• Performed data enrichment functions on databases, mass changes and other direct data update such modify, or insert or delete records
• ETL, data conversion, Import /export or merge data from database or other external file sources for analysis and reporting.
• Performed ad hoc analysis/report or queries and took additional duties as required to meet all business needs.

Confidential

Business System Analyst/ Developer

Responsibilities:

• Prepare BRD, FRD, ERD, design and developed Confidential Position & Job Modeling Management, Events & Employee Inventory, Succession Planning and various HR in accordance to system requirement.
• Prepare system requirement and functional requirement and work closely with Team manager in order verify and validate system functionality.
• Provided expertise knowledge, implemented software to client, work closely to end users, or owners from installation, data migration, walk through end users, acted as third level support
• Performed Quality Assurance on all aspects of the product (UI, performance, data validation, software functionality, requirement, test case)
• Document system such functionality, data dictionary, or entity relationship or update users guide to reflect changes in the system.
• Maintained and keep up to date Tax program for T3, T4, T4A, T4A-NR, T4E T5, T5018, R1, R3, reflex changes in government mandate, and online tax submission using XML, contacted CRA to make sure form is being certified.
• Developed custom programs for special routines or custom report when requested by customers, and perform various client data conversion from excel, text, dbase to SQL.

Confidential

Business Systems Analyst/Software Developer

Responsibilities:

• Work closely with development manager and team member to collaborate system functionality or new business rules to be implement to the software.
• Update or prepare documentation for system requirement to reflect changes or add new system functionality such as ERD, BRD’s
• Key member of the development and project implementation team acted as third level software support.
• Lead HRIS implementation of the following client (BOS/e, PayFast+ Software) HR, Time & Attendance, Payroll modules including large companies in various industry such as Epson Philippines, Motorola Philippines, China Trust Bank, Bank of Tokyo, Met life Insurance, Abbot Laboratories, Wendy’s Philippines, Dunkin Donuts Philippines, Covanta Energy, California Energy Philippines, Leighton Contractors.
• Lead 3 junior programmer, lead 4 members of implementation team (PayFast+)
• Work closely with client business owners, gathers and review process and recommend best practice to achieved business goal.
• Client data migration phase, data setup and DB installation, train end user walk through system functionality and setup business logics and parameters.
• Handled BOS/e & Payfast+ Software development modules Leave Management, Work Policies & Scheduling, Attendance Processing, Personnel Movements & Requisition Management, Succession Planning, Job Modeling, Events and Inventory.

Confidential

Business Analyst/ Programmer

Responsibilities:

• Successfully transformed manual raw materials & finish product inventory system into software driven application that delivers productivity of inventory accountant and have a great impact in the production.
• Developed accounting applications such as Accounts Receivable, Accounts Payable, Invoicing, Sales promotional and commissions program.