SUMMARY:

• Over 15 years of experience in versatile software applications developer with BS and MS in IS.
• Highest score in the United States / 3rd in the world on the Brain Bench website on the RDBMS Concepts test.
• Extensive expertise in .Net, C#, VB.Net, SQL Server 2008, SSIS, and SSRS.
• Strengths include database development, data analysis and modeling, integration services, reporting services, query writing and optimization.
• Wrote an iOS application which helps someone find the right breed of cat to adopt and lists cats which are available at shelters near them. Is currently on the Apple App Store.
• Written in Swift with SQLite backend. Provides an interface to RescueShelters.org using JSON to provide data about cats to adopt.

TECHNICAL SKILLS:

Software: Accomplished developer of SQL Server / 2000 / SSIS / SSRS, Visual Studio 2005/2008/2010, XCode

Databases: SQL Server 2008, Oracle (various), Access, Sybase including bioinformatics experience

Operating Systems: Windows 7/Windows XP / 2000 / NT / 9x

Programming: C#, VB.Net, Swift, Objective - C, JSON, XML, ASP, ASP.Net, SQL, T/SQL with Stored Procedures, HTML, DHTML, XML, XSLT, JavaScript, COM, DCOM, Object Pascal, including multi-threading experience and web services

PROFESSIONAL EXPERIENCE:

Confidential

Senior Associate

Responsibilities:

• Lead developer and code reviewer of reinsurance system for the changes made to support the integration of Canadian business.
• Wrote a system which allows analysts to export all accounting invoice data to Excel and a SSIS system which handles the querying and exports of hundreds of thousands of rows on a nightly basis.
• Enhanced reinsurance batch system to handle an additional line of business and generate notice and proofs for that line of business.
• Wrote a system which handles the generation and emailing of invoices to customers. SSIS package converts HTML documents to PDF and generates supplemental data in Excel format. Zips package and emails invoices to customers.
• Lead developer when client went from handling national accounts to international accounts and had to support multiple currencies.
• Lead developer on a conversion project from VB6 to VB.Net. Lead a team of onshore and offshore developers in the conversion of a 5,000,000 line VB6 legacy Reinsurance system to VB.Net using a system called VBMP. 310 forms were converted.
• Replaced hundreds of instances of third party COM ActiveX controls with .Net controls which I wrote.
• Won an Above and Beyond award and my last performance review was exceeded most expectations.
• Implemented security enhancements into ACE's reporting system to allow external users access to only the data they are allowed to see.
• Wrote and modified SQL stored procedures and analyzed report query plans to ensure optimum performance.
• Worked on various production report issues to debug problems with existing SSRS reports.
• Wrote various ad-hoc and standard reports in SQL Server Management Studio and SSRS. Translated user requirements into reports they needed to run their day to day operations using SSRS and SQL Server Management Studio.
• Modified and ran various previously prepared reports in a timely manner as users requested them.

Confidential

Senior Software Engineer

Responsibilities:

• Play active role in full solution development life cycle (SDLC).
• Use technical and interpersonal skills to analyze diverse end user / business requirements and develop extensive additions and new features to existing applications and legacy systems.
• Work with end users to analyze existing solutions - design improvements or new systems as needed.
• Provide status reporting during development process and handle post-development application testing, debugging, and liaison services with production to handle any issues that might arise.
• Provide documentation and administration of work in 100% compliance with Sarbanes-Oxley (SOX) standards.
• Test and document key controls of systems developed.
• Designed and developed reports using SQL Server Reporting services.
• Slashed batch processing time (days to hours) by converting VB 6 batch system to SSIS using stored procedures / SQL 2005 / C# and building most of SSIS packages.
• As part of the batch process wrote an SSIS package which checked for the existence of files, performed data integrity checks, scrubbed files, and combined files from various sources to three unified combined files whose data was used during the rest of the batch process.
• As part of the batch process wrote an SSIS package which took the combined files and filtered the rows based on business rules into a set to be processed and a set that was filtered out with a custom transformation in the data flow process. The data that was not filtered out was then placed into the database using a BCP task and the flat files were archived.
• Wrote an SSIS package to set up direct claims as part of the batch system
• Wrote an SSIS package to attach claims to contracts using business rules. Package executed a CLR stored procedure and TSQL stored procedures. Wrote CLR stored procedure. Also part of the batch system.
• Wrote an SSIS package which processes reclaim data using a CLR stored procedure of which I wrote part. Spreadsheet with around 700 formulas to perform calculations. I wrote a program which read in all formulas, parsed them into C# code, and ordered them correctly for use in a C# CLR stored procedure. SSIS package used parallelism which executed the CLR stored procedure in separate batches run concurrently to speed up processing.
• Wrote an SSIS package which compares claim data from two different systems in order to ensure the two systems are in synch with each other and produces a report which shows the differences. This is used in the batch process.
• Wrote an SSIS package to send reclaim data out to the mainframe on a weekly basis which contains all transactions the reinsurance department processed for the week.
• Wrote interface code to send all documents in FIRST, our reinsurance system, to Apollo, a document management system. This included documents sent real time to Apollo and documents sent by an SSIS batch system in 15 minute intervals.
• Connected previously incompatible systems company-wide by developing DTS packages / interfaces.
• Won Performance Award for independently handling data conversion, data cleansing, and reconciliation of large-scale legacy mainframe database to enable transition to SQL Server.
• Cut treaty approval process time up to 50% by developing treaty control Document system that automatically generated Word documents with approval by electronic signature.

Confidential

Software Consultant

Responsibilities:

• Recruited based on expertise demonstrated in conversion and integration of legacy systems.
• Worked as a consultant for Confidential and was key member of team, quickly emerging as go-to guy for any software development problems other members of team encountered.
• Worked on projects ranging from development of disability management system, to writing library of JavaScript code used to quickly add various kinds of UI controls into ASP pages.

Confidential

Senior Software Engineer

Responsibilities:

• Worked as consultant for clients including the IRS and SEI Investments.
• Developed website for SEI Investments that generated $2.5 million annual savings in service calls and in printing of mailers.
• Wrote documentation for all systems created and wrote system specs for systems under bidding.

Confidential

Programmer Analyst

Responsibilities:

• Key member of a team that developed Bioinformatics system to identify patients at risk for disease for Kaiser Permanente and Blue Cross.
• Won several Crystal and one Bronze Award for my work on bioinformatics.

Confidential

Software Engineer

Responsibilities:

• Developed software for leading premier legal software company concentrating on customers with large corporate legal departments, government agencies and multi-office law firms.