Robert Co Email & Phone Number

New York, New York, US

• Connecting and Integrating a variety of business platforms (e.g. Salesforce, SAP and in-house systems) to achieve a coherent view of the whole Fitch business. Along the way, helping improve data quality and visibility.
• Integrating Business Applications (like SalesForce, SAP, etc.)
• Provided technical support in standing up the Boomi and its agents in AWS Kubernetes.
• Providing Analytics and Reporting service for migration of contract and invoice management systems.
• Data cleanup and management of Salesforce objects.
• Build pipeline for new issuance items from Bloomberg into rating and billing systems.

New York, New York, US

• Provided Data Warehousing, Business Intelligence and Regulatory Reporting service through direct business user engagement. I also integrated business developed applications to enterprise products. Tools used: Oracle.
• Automate the annual SEC and ESMA reporting requirements.
• Amazon web service migration from on-premise database and processes.
• Provide Python-based self-service business automation framework, which allows business to interact with RDBMS and NoSQL through a web api consumed by Excel.
• Develop user-controlled scheduling service for regular delivery of reports.
• Redesign data warehousing methods and reporting scripts

Bloomfield, CT, US

• Provided data analysis for the AccelRx PBM migration project. The role involved data mining legacy pharmacy data from a third party vendor; bridge the connection to Cigna's internal system; and build a new data.
• Acquired and data mined legacy PBM information from unstructured and structured sources to identify benefit features of Cigna clients.
• Built custom tools to acquire additional information from vendors.
• Built a relational database for newly acquired information in Oracle.
• Built data marts for reporting and analysis from internal Cigna source systems.
• Provided analytics and business intelligence to various Cigna business units.

Hamilton, Bermuda, BM

• Served as a business analyst in XL Capital's MI Analytics team in the Hartford office. The project integrates varied applications (mostly in Excel) within XL's portfolio of application into a central repository to.
• Provided technical guidance on making the Excel models compatible with integration infrastructure.
• Provided reporting and analysis to business units.
• Participated in scrum activities, including refining stories with product owners.
• Developed proof of concepts for new application features.
• Developed custom tools for Agile management.

Hartford, CT, US

• Provided data extraction and analysis to facilitate predictive modeling for the Commercial Lines - Research team. The project produced a new class plan for automobile line by realizing new variables and comparing them.
• Built data marts for data analytics in Oracle.
• Designed the GLM for the collision coverage.
• Collect, Combine and Transform dataset from various sources into a flat and wide file that can be consumed by Emblem (a GLM software).
• Refined and redesigned SAS Models for efficiency and maintainability.
• Restructured and consumed previously untapped MVR information from semi-structured sources.

Hartford, CT, US

• Provided technical assistance, data acquisition and reporting to the Commercial Lines Actuarial department. The department provides tools, analysis and guidance to underwriting and operations for all product lines.Key.
• Reverse engineered an existing worker’s compensation Excel pricing model to extract key actuarial concepts and methodology to share with the department; and reorganized the model to be maintainable.
• Executed and validated the quarterly renewal scoring model.
• Rewrote the renewal scoring model for automation using a combination SAS, Excel calculation engines/raters, Teradata, Oracle and VBA scripting. The raters are organized so that it will be easy to understand for common.
• Initially, I developed Excel user interface for underwriting to utilize the raters. These were replaced, when I developed web applications to use these raters, instead. This is an ASP.NET application that makes Interop.
• Needing to reduce multiple user inputs from multiple systems, I enhanced the application to make SOAP calls to an enterprise web service that returns an ACORD xml schema.

Bloomfield, CT, US

• Supported the Enterprise Pricing and Actuarial department by providing technical assistance with custom raters and tools. The role also included assisting with IT engagement to close the language gap and produce.
• Collaborated with actuaries to develop various Excel rating engines that are used to rate and price health benefit plans.
• Developed and supported a data collection facility in MS Access and Sql Server to store the iterative results when testing raters against a big population of cases.
• Developed and supported custom Excel applications for underwriting and sales. These tools range from comparing benefit plans to producing interactive executive decks that illustrates plan performance and adoption.
• Developed an automated tool that can be used by non-technical person to configure parameters to run against the pricing engines and produced the pricing matrix for a 3rd-party vendor that administered Cigna Choice Fund.
• Collaborated with actuaries to develop the stop loss tool. This tool prices reinsurance for the self-insured and smaller insurance providers. It is an Excel application that has rater, user interface and database.

Bloomfield, CT, US

• Supported the enterprise Pricing and Actuarial department as part of the IT organization. The role encompassed the whole SLDC: from design to production support. The applications included technologies from mainframe.
• Developed and supported client/server MS SQL/VB applications used for rate and price: Baseline, BOB, Manual Rate, BAWS and Healthsource Integration. This application has a batch synchronization procedure back to.
• Developed and supported a parameter maintenance VB application that directly interacts with CICS to update information in DB2.
• Quantified and qualified both business and IT personnel’s roles and responsibilities by performing in-depth interviews and produced an executive deck for management.
• Developed valuable system tools that collected DB2 environment details; compared stored procedures; and cataloged programs.
• Managed contractors and employees during the PCP optional project, which touched 80% of Cobol/DB2 programs.

Manila, National Capital Region, PH

• Managing a 15-member team to support the whole credit card operations of Equitable Bank. This included credit card operations of affiliate banks, like Bank of America, Commerce Bank, and other local and international.
• Designed and developed the first modern looking statements utilizing graphics features of mainframe laser printer provided with the IBM ADJUST software.
• Designed and developed the “first of its kind” mainframe to PC client/server real-time statement printing through a bank teller. This involved creating CICS programs communicating with a Turbo Pascal client.
• Supported and maintained compliance with Visa and Mastercard data transmission standards.
• Developed a domestic interchange system and standard for issuers and acquirers; bypassing Visa and Mastercard.
• Redesigned the sales slip data entry system to optimize key entry while maintaining intuitiveness for new personnel. Equitable was a provider for international companies that outsource their credit card sale slip data.

Manila, National Capital Region, PH

• Supported the banking operation of Equitable Bank. This included checking, savings and CDs. The applications ranged from mainframe batch, CICS online application and stand-alone PC-based banking suite.Key Highlights:
• Converted mainframe assembler programs to Cobol.
• Supported CICS/Cobol online inquiry systems
• Rewrote the Cashier’s Check batch mainframe system.
• Maintained and enhanced various PC-based data entry systems.