Flexible Schedule IT/Data Professional with Excel Expertise
Resume:
Andrew Tan
********@*****.***
* ********** *****, ********** ** 07039
Summary
Detail-oriented professional with expertise in Microsoft Excel, skilled in managing data accuracy and performing quality checks. Proven ability to organize project scheduling and provide client satisfaction in remote environments. Demonstrated strong communication and adaptable problem-solving skills to eƯiciently handle customer inquiries and administrative tasks.
Work Experience
Senior Software Engineer, Talcott Resolution
Hartford, United States
Nov 2020 - Mar 2025
Managed and updated complex data sets with precision, ensuring accuracy and completeness in line with company standards.
Coordinated scheduling and document management tasks, enhancing operational eƯiciency in a dynamic environment.
Communicated eƯectively with internal teams to support project timelines and data integrity.
Performed quality checks on data inputs, reducing errors and improving overall data reliability.
Maintained detailed records and documentation, supporting compliance and audit readiness.
Utilized Microsoft Excel to organize and analyze data, streamlining reporting processes and decision-making.
IT Developer/Technical Analyst, Prudential
Roseland, United States
Aug 2019 - Aug 2020
Operated within Agile Project workflow environment.
Worked and maintained existing OpenText Exstream applications.
Coordinated with Web Services in updating Online Payment options verbiage for Client.
IT Developer/Technical Analyst, RR Donnelley
West Caldwell, United States
Nov 2010 - Oct 2018
Designed and developed Touchpoints, Templates, and Variants in Messagepoint.
Created Smart Text, Messages, Target Groups, Target Rules and Data source.
Uploaded and mapped Client data into Cloud environment.
Troubleshooting and resolving production issues.
Worked directly with multiple Clients to create content for customizable communication components in Messagepoint Web environment.
Achievement: Merrill Lynch, a major client, asked us to find a way to consolidate their multiple accounts into a single mailing for a Customer Brochure Campaign. I utilized a Data Integrator to search multiple client data and identify records with diƯerent accounts under the same customer name and created the desired mailing list. As a result, Merrill Lynch eliminated multiple mailings to the same customer, with major cost savings and improved customer communications eƯiciency.
Designed and programmed from simple to complex, high volume and On-Demand applications. Worked with diƯerent input files, outputs, and reports.
Have strong knowledge of Page Layout Design, Data Mapping, Output Queues, Flow Tables, Image-Pass Throughs, Reference Data, Dialogue Engine processing and Application packaging.
Utilized knowledge and integration with Message Point program, created and managed connector logic in Dialogue – updating formulas, zone containers, and zone content variables.
Provided Client specialized marketing reports and custom business tracking utilities.
Composed and managed enrollment forms and brochures for Health Industries such as UnitedHealth Group and Optum RX Prescription Solutions.
Observed and Managed SOX Compliance Protocols for various IT applications.
Achievement: Optum RX Prescription Solutions wanted to introduce multi-lingual copy into their brochures. In addition to Spanish, they requested Chinese verbiage for their large Pacific-rim customer base. My fluency in Chinese Mandarin enabled me to incorporate text and logic for these important customers. The result was not only a marketing coup for Optum but also a significant savings in only having to produce one brochure.
IT Composition Software Specialist, Bowne
Jan 2006 - Nov 2010
West Caldwell, United States
Adobe DL Formatter programmer - maintained Print on Demand product for various Financial clients.
EZ Letter formatting for various Client inkjet mailer applications.
HP Exstream Dialogue Developer – serviced for various Financial, Health Care based Clients Adhoc/Direct Mail campaigns and marketing.
PERL Programming for creating custom client data information reports and utilities. IT Composition Programmer, Vestcom
West Caldwell, United States
Aug 2001 - Jan 2006
Managed the preparation and development of documents for web and print media campaigns.
Corporate image manipulation and normalization for client website interface.
Exstream Dialogue Programmer, invoice and document creation with client specific program functionalities, data management and processing for multi-media output.
Mainframe document applications conversion into Exstream Dialogue platform.
VIPP Developer – creating documents thru Xerox Variable-data Intelligent Postscript Printware coding.
Format and converted Client Quark Xpress files into Exstream Dialogue program for high volume document print with variable data encoding. Skills
Software Expertise:
Microsoft Excel
SOFTWARE EXPERTISE:
Adobe DL Formatter, Adobe Photoshop, Data Integrator, EZ-Letter, OpenText Exstream, Messagepoint, Microsoft Excel, Microsoft Powerpoint
LANGUAGES:
English, Chinese -Mandarin
Education
Bachelor's in Computer Information Systems, Caldwell University Caldwell, USA
Jan 2007 - Dec 2007
Associate's in Graphic Design, County College of Morris Randolph, USA
Contact this candidate