Christopher John Parulan Cobin

Christopher John Parulan Cobin

$8/hr
VBA, Excel, SQL, Reporting Analysis
Reply rate:
43.75%
Availability:
Full-time (40 hrs/wk)
Location:
Las Pinas, Metro Manila, Philippines
Experience:
15 years
Christopher P. Cobin B7 Lot 16 #31 Nazareth Street Camella Classic Pilar Las Pinas City Phone:-- Work Experience: May 2021 – Present Kepler Analytics – Australia, Remote Data Analyst – Analyze data, identify outliers and fix data in relation to calibrating sensors for the purpose of metrics in client dashboard. Utilize queries via MySQL, PBI and Excel to perform analysis and correct data discrepancies. July 2011 – February 2021 AIG Insurance – Madrigal Business Park, Alabang - MS Office Tools Programmer – Developed reporting tools in Excel and Access using VBA according to clients’ specifications and business needs. Provided ongoing support for said tools - Level 1 Sharepoint Support Analyst – handled level 1 Sharepoint issues via ServiceNow. Used email, chat, remote and phone as means of support. August 2010 – July 2011 AIG Insurance – Madrigal Business Park, Alabang User Acceptance Tester (UAT) for Financial Accounting System (FAS) - Performed test execution based on data files and reports test cases, documented the test execution results (proofs of tests), Performed "simple upload" and "complex upload" for expected results using MS Access 2007, performed peer quality reviews of the test specifications, revised the test specifications based on review feedback. UAT for Deferred Acquisition Cost (DAC) system – implemented the new DAC accounting guidline, Rolled out a new prospective model in 2 phases, testing of basic admin module for power-users to manage users Programming – developed ‘time tracker’ tool for testers using VBA in Excel which kept track of testers’ tasks. April 2010 – May 2010 GMR Internet Advancement – Paranaque Content Writer – wrote online articles for various web sites including content for blogging purposes Telemarketer – made U.S. outbound calls to prospects for debt reinvestment screening purposes; transferred calls to closer June 2008 – November 2009 Genpact, LLC – Alabang, Muntinlupa Reports Analyst – generated and analyzed reports for company process, came up with agent level and process level metrics and statistics, collaborated with management and team leads in streamlining process goals and metrics and for improving agent statistics and overall productivity and efficiency, utilized different tools and applications in generating reports daily, weekly and monthly. Software used: Aspect, Excel with VBA and Access Genpact LLC- Alabang, Muntinlupa Process Associate – was in first batch/wave on a pioneer account and was part of a team that was responsible with garnering positive client feedback which lead to keeping the account, handled both outbound and inbound collection calls (both manual and through dialer) February 2001 – May 2008 Self-Employed – Cherry Hill, New Jersey - assembled and repaired PCs, installed and maintained software applications, held computer classes November 1999 to 2001 Cendant Mortgage, Mt.Laurel, New Jersey Position: Junior Programmer / Database Analyst - Business Analyst: Responsibilities included generating daily, weekly, monthly and year-end reports to various departments within the company (including, but not limited to, Servicing, Collections, Insurance, and Foreclosure) and outside clients. Utilized the following database for report generating: MS Access, Brio, Crystal Reports and SQL. Analyzed information and took appropriate course of action based on information. Built databases tailored for various clients. - Programming: Collaborated with various departments to determine custom scripts needed based on departmental needs. Utilized the following tools: Visual Basic, Visual Basic Scripting and Visual Basic for Applications. - wrote software to automate repetitive tasks to assist team members, reducing redundancy and increasing departmental efficiency and productivity. - wrote front-end to interface with company's CPI terminal. - Created front-end for Excel and Access. November 1998 to 1999 Cendant Mortgage, Mt. Laurel, New Jersey Position: Loan Representative (Customer Service) - Duties included answering and resolving issues from existing homeowners in a high-call volume environment utilizing CPI and CPI Director; responding to homeowner's inquiries through e-mail, interfacing with other teams in resolving issues associated with mortgage accounts. September 1995 to November 1998 Alliance Data Systems, Voorhees, New Jersey Account Representative (Call Center): Worked in a high-call volume environment where duties included answering inbound phone calls pertaining to setting up accounts for customers to receive satellite programming on their dish systems, helping troubleshoot hardware problems, assisting customers with billing inquiries. - Promoted to floor lead whose duties include calculating employee time sheet information and data entry of exception codes for purposes of payroll computation, utilized Lucent Centerview to monitor floor reps' stats, monitoring calls to ensure quality control, entering statistical data for the whole department. Managed to keep call queue at a minimum even during peak call hours. September 1993 - 1995 BSI Incorporated Voorhees, New Jersey Customer Service Representative / Billing Representative / Collections - Worked in a high-call volume environment answering customers' inquiries/issues regarding their credit card. - Made outbound calls to follow-up on delinquent accounts (30, 60 and 90 days) and attempted to recover delinquent balance. June 1991 - 1992 Source Data Incorporated Cherry Hill, New Jersey Data Encoder: Responsibilities included inputting information into terminal for processing, performed verification of data, troubleshoot hardware issues. 1990 - 1991 Pro Direct Incorporated, Cherry Hill, New Jersey Telemarketer: Telemarketed major credit card accounts to pre-approved customers using auto-dial terminal. Education: Camden County Community College - Criminal Justice – Blackwood, New Jersey Hudson County Community College – Jersey city, New Jersey Hudson Catholic High School, Jersey City, NJ 1998 Xavier School – Greenhills, Q.C.
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.