Bronx, NY *****
**************@*******.***
Harold Mercado
Profile Accomplished Business Analyst seeking a position within a company that offers me
the opportunity to utilize my skills, and provides ample room for growth.
Product oriented professional skilled in achieving operational efficiency and increasing
revenue in the insurance industry, with diversified experience in various insurance,
information and financial systems.
Results-oriented, decisive leader, self-starter, who employs root cause analysis to identify
issues and develop process improvements that lead to cost savings strategies.
Exceptional planning and implementation capabilities.
Effective communicator and problem solver. Excellent analytical and organizational skills
Enjoy supporting the efforts of the team as well as other departments
Experience 2012 - 2014 Guardian Life Insurance New York, NY
Senior Agency Technology Analyst
Collaborate in the UAT process to ensure the new financial system meets the
requirements prior to its implementation.
Collaborate in the financial systems’ transition from FAS to Varicent.
Analyze reports and perform reconciliation of controls, notify imbalances and initiate
required fixes.
Support the Agency Finance systems application and the IT department with any systemic
changes to the financial system.
Develop test plans/cases and acceptance testing, documented the expected vs. actual
results. Provide resolutions where needed.
Act as the team Liaison between the Agency and IT departments. Collaborate in the
facilitation and flow of data.
Develop scenarios that depict business challenges and needs. Propose solutions and
implement systems enhancements.
Support the systems implementation and deployment through the interaction with the
technology partners and field personnel
Provide production support to field personnel.
Validate business requirements and user requirements.
Collaborate in the creation of training manuals that helped users access the new financial
system.
Participate in the Guardian on-line UAT redesign.
Served as the Subject Matter Expert for the Agency systems.
2007 - 2012 New York Life Insurance Westchester, NY
Senior Systems Associate
Collaborated with the documentation of business requirements, including the creation of
new forms and policyholder communications and/or modifications.
Develop and execute test plans and document results.
Report all results of testing and, where necessary all troubleshooting actions.
Prepare user documentation and training materials.
Handle production support and user guidance requests, inclusive of systems extracts.
Collaborate with the research of new projects and/or emerging technology.
Manage and lead the implementation of new applications.
Analyze and review print policy contracts for general and variable states.
Proactively assist other team-members in completing their work assignments to ensure
the timely completion of projects assigned.
2004 - 2007 New York Life Insurance Westchester, NY
Systems Associate III
Oversee the implementation of new products and ensure that quality standards are met
during their testing and production phases.
Develop test plans, which are independently based on available product documentation.
Create, analyze and review comparison reports for various products.
Develop instruments that served in the facilitation and communication of data.
Manage the calculations for the term policies inclusive of waiver, total and gross premiums
and other product benefits
Analyze situations, course of actions and consequences. Recommend solutions to
supervisors and assume responsibility for decisions.
Created a procedural manual for our products which detail all processes and features of
the products
Cooperate in the creation of business requirements such as procedure manual, print
policy and product specifications
Supervise product quality control.
Edit and review all product information and written communication such as quarterly
statements, Annual Policy Statement and welcome letters.
Trained and coached fellow co-workers on the NYL products.
2002–2004 New York Life Insurance New York, NY
Systems Associate II
Earned the Corporate Be the Best award in 2002 for demonstrating an outstanding
participation in the implementation and execution of the developed products.
2000–2002 New York Life Insurance New York, NY
Systems Associate New York Life Insurance Trainee
Education 1996–2000 The City College, CUNY New York, NY
B.A., Bachelor of Arts in Economics
Awards Nominated and awarded 6 BE THE BEST Awards.
Skills Microsoft Excel, Word, Lotus Notes, APL, Cyberlife, Microsoft PowerPoint, Access,
Sharepoint, NB21, Varicent, SQL, Clear Quest, fluent in Spanish
Interest Jogging, Basketball, Reading, Member of Big Brother Big Sister club.