Software Information Technology
Resume:
Gary Wuerth
*B ROCKVILLE RD
Broad Brook, CT 06016 **********@*****.***
Summary
~15 consecutive years experience in the information technology field, with
a wide range of responsibilities including ETL development, software
development, software and systems architecture, technical implementations
and maintenance, customer/client support, technical documentation, data
analysis and reporting, as well as testing/QA of new technologies and
software.
Certified, Microcomputer Information Technology.
Professional Experience
SS&C Tecnologies/BenefitsXML, Glastonbury, CT
2009-present
Technical and Operational Systems Lead and Data Analyst
. Develop, implement, and support cutting edge and cost saving electronic
data exchange/ETL services for benefits administrators in the healthcare
enrollment industry.
. Architect, develop, and optimize tools utilizing XML/XSLT (Altova
toolsets, schema/XML/XSL, ontological methodologies) in order to maximize
developmental and procedural efficiency and internal cost reduction as
well as fostering agility of process.
. Design and manage internal processes (Shell scripting, some Java), as
well as developmental and overall operational direction and business
practices.
. Personally responsible for supporting cross-corporation data exchange
processes across different platforms (Windows workstations and servers,
Linux servers, mainframes, etc) utilizing multiple technical utilities
for over 425 separate feeds spanning the formats and methodologies of
more than 120 different carriers (Flat files/X12 834/etc).
. Interact directly with benefits administrators to determine data exchange
requirements and needs.
. Extensive data mining and analysis of benefits administration system
transactional data models.
Ingenix, Rocky Hill, CT
2008-2009
Business Analyst II
. Developed ETL integrations (various claim and enrollment system, X12
834/etc) with clients and health plan carriers (Medical, Drug, STD/LTD,
etc) for ETL into custom reporting tool for the purposes of health care
informatix data modeling.
. Data analysis and modification of internal system processes utilizing SAS
programming.
. Specification writing for ETL process and data mappings for various
internal departments.
. SAS70 compliant levels of documentation utilizing Lotus Notes databases
and tools.
. Configuration of internal ETL tool (DSOWeb) based on written
specifications, using modified PERL environment.
. Custom ad-hoc reporting utilizing Oracle (Toad Software).
. Liaison between offshore resources (India) and various onshore clients.
USI Consulting Group, Glastonbury, CT
2007-2008
Business Systems Analyst
. Implement automated secure data transfers (PGP encryption, FTP/SSH/SFTP)
with new and existing clients and their health benefit plan carriers to
facilitate timely eligibility enrollment and ongoing benefit changes.
. Customize and configure (cost formulae, eligibility rules, custom
configuration parameters) core benefits administration product (Ceridian)
for new business partners as well as maintain current configuration for
existing relationships.
. SAS70 compliant levels of documentation required for all business
processes, to ensure proper auditing and standards.
. Copious business analysis required to determine the needs and best
technical solutions for the business needs of current and new clients.
Evolution Benefits, Avon, CT 2005-
2007
Technical Analyst
. Integrate technically with health plan carriers and pharmacy benefits
managers on multiple technical levels to ensure the exchange of
information pertaining to core product, utilizing myriad platforms and
processes externally (VPN, FTP, ETL processes, etc) for integration into
house systems (Microsoft BizTalk, core product).
. Maintain established integrations (~200) from all business relationships,
ensuring proper data exchange.
. ETL project lead, guiding and training new ETL technical analysts in my
small group and leading cross-department integration projects.
. Significant business analysis required. Mining, relating, and
interpreting internal data and statistics for various operational areas
with SQL, Access, and Excel.
. Provide documentation and reporting on all running projects, on a weekly
basis, to all related internal departments.
. Produce and distribute ad-hoc reports as requested, by various internal
business units, utilizing SQL and other reporting tools.
The Yankee Candle Company, South Deerfield, MA
2002-2005
Technical Support Specialist
. Provided application and system support for over 350 retail locations as
well as extensive support for YCC corporate campus population.
. Supported software/systems included VB applications (inventory systems,
POS systems, in-house app's), Unix applications and jobs, both Novell and
IBM server software, Crystal reports, Business Objects, Microsoft Office,
etc.
. Analyzed, organized and distributed monthly systemic statistical reports
regarding system performance utilizing Excel and Access.
. Facilitated the daily processing of financial data from all retail
locations for reporting, utilizing various platforms such as Unix based
Lawson software.
. Tested and implemented new software products utilized on both the YCC
corporate campus and for all retail locations, such as new inventory
tracking applications as well as reporting software packages.
Hansco Information Technologies/Given-Hansco, Ludlow, MA
1998-2002
Client Services Analyst
. Developed reports for core accounting product, utilizing Borland Delphi
and Microsoft SQL.
. Provided application and system support for entire client base, from
phone support to developing/customizing applications to meet business
needs.
. Traveled to client sites for software installation, analysis, and
integration of core product to satisfy the business needs of the client.
. Actively participated in major systemic upgrades and patches across
client base, such as Y2K patch implementations on Unix and windows
platforms.
Education
Westfield State College, Westfield, MA
Double Major, Economics/Finance, 1997-1998
Holyoke Community College, Holyoke, MA
Certificate awarded, Microcomputer Information Technology, 1996-1997
Contact this candidate