Management Sql Server
Resume:
Robert Cooper
* ****** ****, *********, ** *****
**********@*****.***
www.linkedin.com/in/robertmcoop
Insurance Business Analyst with 14 years experience in all phases of an
insurance product's lifecycle, including underwriting, rating, billing and
issuance, for both P&C and L&H products. Solid Business Analyst skills
including requirement elicitation, specification preparation, and UAT
support. Strong technical skills such as advanced SQL knowledge and several
programming languages. Experienced in managing small workgroups. Effective
in working with diverse technical and business groups to define and
prioritize needs and wants.
Seeking new opportunities while undertaking continuing education in
Business Analysis methodologies and supporting technical competencies
including: CBAP test preparations; requirements elicitations techniques;
understanding tools for requirements visualizing, simulation & management;
Agile / Scrum methodologies; business rules creation and management; and MS-
Office 2010 Business Intelligence reporting and analysis tools.
Professional Experience
USI AFFINITY, New York, NY July
1994 - September 2008
An insurance agency / brokerage / MGA / TPA managing and invoicing over
$106 million in premiums for 72,000 professional and personal insurance
policies. Pre-2004, company was known as Bertholon-Rowland Corporation.
Affiliation ended in September 2008 because of a reduction in workforce.
. Senior Business Analyst / Manager, Application Development (January 2001
- September 2008)
Lead team effort to determine business and software requirements to
enhance and maintain Agency Management System. Managed team of up to six
programmer/analysts in implementing and supporting software solutions,
including business processing rules, workflow management, CRM, document
generation,
and reporting for operations, sales, marketing, accounting and general BI
needs..
o Directed upgrade of business rules, rating calculations, and policy
certificates for a professional liability product, affecting 12,000
policies in 13 states and $50 million in premium. Upgrade completed
before the insurance carrier completed its own updates, helping
negotiations that netted a 0.5% commission increase.
o Analyzed, designed, helped code, and coordinated the IT portion of a
precipitously approved project to add an optional feature to a life
product. Completed in the four-weeks before invoices were generated;
produced $40,000 in recurring revenue; No additional staff needed to
process the 8,000 plus responses.
o Developed extensive knowledge of Professional Liability, Workers Comp,
Life, and DI products, with broad expertise in insurance policy
management, underwriting systems, and premium/rating calculations.
o Improved department productivity by cross-training staff to handle
business and system analysis for all application components. Followed
OOP / OOD principals in SQL 2005, VB6, and C# / .NET languages.
o Provided business intelligence reports, data extracts, and data
analysis for 8 years of policy records that included coverage, payment
and claims data. Project allowed the company to successfully market
and transfer a major book of business to a new insurance carrier,
while maintaining relations with largest client.
Senior Business Analyst / Programmer (July 1994 - December 2000)
Primary IT analyst and liaison between developer of third-party Agency
Management System and business users. Added VB5/6 & SQL tasks when in-
house development of new Agency Management System commenced.
o Led an ETL (Extract, Transform, & Load) project that transferred
records from a black box third-party system with minimal documentation
to an evolving, internally developed replacement system. Completed the
project by a very hard, go-live date, and helped prevent a major
lawsuit for breach of contract.
o Performed business and system analysis and championed upgrade of
company's renewal premium invoicing system (used to generate over
250,000 invoices annually). Simplified and consolidated procedures
enabling business users to create and produce invoices without
involvement of IT staff.
Member, Board of Directors (October 1996 - October 1999)
Employee-elected Director of the predecessor Bertholon-Rowland
Corporation, an ESOP company with over $20 million in revenue, and 150
employees in four cities.
o Gave quarterly presentations to Board and staff. Involved in all
levels of corporate policy and strategy decisions including the annual
corporate budget, infrastructure investments, acquisition proposals,
and funding two startups. Also participated in the removal and
replacement of the company's CEO.
SKIDMORE OWINGS & MERRILL LLP, New York, NY
1987 - July 1994
An architecture and engineering firm that is a world leader in the use and
development of digital design tools.
Senior Database Analyst / Application Developer / DBA
o Directed needs analysis, vendor product evaluations, and customized
vendor's database components for a turnkey Facilities Management
system delivered to a major New York bank. Expedited loading of
Computer-Aided Facilities Management database and linking CAD drawings
to database records.
o Designed, developed and maintained architectural applications written
in C and Ingres's 4GL for AIX workstations, as well as applications
written for MS Windows PCs with the Paradox DBMS system.
o Created and maintained numerous multi-user Ingres short-term project
databases, and developed tools to automate DBA maintenance routines in
both AIX shell scripts and the C programming language.
Technical Competencies
. Most recent environment: MS SQL Server 2005; MS Visual Basic 6.0; MS
Visual Source Safe 7.0 converting to Visual Studio 2005, C# and .NET, SQL
2005 Reporting and Analysis Services, Visual Studio Team System.
. Previous DBMSs: MS SQL Server 6.5, Ingres 5.x, Oracle 5.0; Informix 4.3,
MS-Access
. Previous operating systems: Unix, AIX, SCO UNIX, Linux, Windows NT,
Windows 2000.
. Previous languages/tools: C, Unix shells Bourne and CSH, various Unix
utility languages including AWK and SED, Ingres's Quel & Equel, ERWIN,
Crystal Reports.
Professional Development
. Agile FireStarter & CampFire Workshops, Microsoft, December 2009 & May
2010
. World Congress of Business Analysts, Baltimore, MD, 3 days of
workshops & classes, June 2009
. Business Systems Analysis Certificate, InQuestra On-line courses (IIBA
approved training), May 2009
. ILOG JRules BRMS Workshop, IBM, May 2009
. Project Management for Software Development, Learning Tree International
class, October 2007
. XML: A Comprehensive Hands-On Introduction, Learning Tree International
class, September 2007
. Developing High-Performance SQL Server Databases, Learning Tree
International class, June 2007
Professional Association Memberships
. International Institute of Business Analysis (IIBA) - NJ Chapter member
. NJ SQL Server User Group (NJSQL.org)
. Association of Computing Machinery (ACM)
Educational Degrees /Licensing
. M.S. - MOT, Polytechnic University, New York, NY
Executive Master's degree in Management of Technology with a focus on the
innovative uses of technology in the insurance industry. Participation
fully sponsored by Bertholon-Rowland Corporation
. Architectural License, New York State
. B. Arch, University of Cincinnati, Cincinnati, OH
Bachelor of Architecture degree with Professional Practice Certificate
Contact this candidate