SUMMARY:

Over 15 years as Asst VP, Team Lead, Developer, Software Engineer, Data Architect, Business Analyst, Systems Analyst, Tech Writer

TECHNICAL SKILLS:

LANGUAGES/SOFTWARE (current): Microsoft SQL Server 2008/2005/2000, Oracle 11g, Visual Studio 2008/2010 (C#),Team Foundation Server, Microsoft SQL Server Integration Services 2008/2005, Microsoft Reporting Services,ASP.NET, XML, Web Services, Java, Microsoft Analysis Services, OLAP, Data Cubes (MDX)

LANGUAGES/SOFTWARE (previous): JSP, Java, Cold Fusion, Jakarta Tomcat Java Application Server, Jakarta Struts Web Tools, C/C++, Foxpro/Visual Foxpro

PROFESSIONAL EXPERIENCE:

Confidential, Agoura Hills, CA

Assistant Vice President

Responsibilities:

• Responsible for design and implementation of data validation system of consumer information transmitted to credit reporting agencies.
• Platform is Oracle 11g Exadata. Extensive work with leading, designing, coding, and optimization. Also was in charge of a system involving troubled mortgages on a SQL Server platform. The system receives data from multiple sources in multiple formats daily and is converted to a standard format in an operational data store. This is used to send data to downstream users to send to the government, particularly the Dept of Justice per legal settlements. The system also included C# applications that aided in the data conversions.
• This job required architecting data, team lead, system design, code design, and writing code.

Skills: SQL Server 2008, Oracle 11g, Visual Studio 2010 (C#), SSIS, SSRS, TFS, Visio, some Java.

Confidential, Agoura Hills, CA

Lead Application Developer

• My responsibilities included leading, designing and developing enhancements and support patches to the system used to manage application software deployed to all local Confidential branches.
• All mortgage application software at every branch had to go through my system. The system was a multiple component system using SQL Server, C# ASP.NET, and web services.
• My system was also used to build new releases of bank software. In addition, each branch needed to upload data such as employee data into my system.
• I was also responsible for managing and designing the TFS implementation for storing source code.
• I designed the disaster recovery code process and helped migrate this system to new servers across multiple domains. This position extensively used SQL Server 2008/2005, C# ASP.NET, SSIS, SSRS, TFS, Visual Studio 2008, and XML

Confidential, Baton Rouge, LA

Contract Developer

• Confidential is the largest home health care provider in the US. I performed a multitude of tasks including designing/developing solutions and application support.
• Most of the work involved billing and claims systems, including Medicare claims involving OASIS assessments and 835 and 837 electronic submissions.
• Also provided applications support to do time sensitive bug fixes and providing help to the BI group for ensuring the accuracy of metrics for reporting.
• This position was very SQL Server intensive (stored procedures, user defined functions, SSIS, SSRS) with some .NET and Foxpro support. Team Foundation server was used for source control and task management.

Confidential, Boston, MA

Lead Database/DataMart Developer/Analyst and Report Designer/Developer

• Designed and developed a Reporting system including OLAP datamarts and extensive ETL processes using SQL Server, DTS/SSIS, .NET and Stored Procedures as well as numerous report templates using Microsoft Reporting Services and Visual Studio .NET. Developed more than 100 reports used by upper management for reporting contract compliance to the State of Massachusetts.
• My system needed to interact with the phone system as well as production systems (Oracle, SQL Server, and text files) to build the datamarts.
• Many times links needed to be developed between systems that did not exist. I built the system so that reports run automatically weekly and monthly using default parameters into PDF or Excel files but could also be used to do manual reporting using user - entered values.
• Since Confidential faced state imposed fines for non-compliance and missing reporting deadlines, the system needed to be accurate as well as “on time all the time”. Also responsible for many server based automated processes and debugging server to server issues.
• Extensive interaction with upper management stakeholders to gather requirements and write specs.
• Also spend extensive time doing complex analysis and custom ad hoc data extractions for upper management to provide client with financial and performance data.

Confidential, New York, NY

Lead Application Design/Development

• Designed and developed application allowing the general public to search for Financial Education resources. Front-end development used C# and VB.NET. Back-end used SQL Server 2005 with XML. Application needed to be designed for use on a 3-tier physical architecture deployment. Therefore Web Services and SSL technology was used as well as encryption for sensitive data.
• My responsibilities also included heavy interaction with upper management stakeholders to analyze and put together specifications as well as interfacing with New York City’s hardware agency for the necessary secure server setups.

Confidential, Akron, OH

Database Developer/Report Designer

• Short-term contract working for a healthcare HMO designing and developing check generation and printing as well as explanation of benefits.
• Used Microsoft SQL Server 2005 Integration Services to extract data from tables and text files to generate lists of check recipients (also C#). Then used Reporting Services 2005 to generate checks and explanation of benefits for healthcare providers and customers.

Confidential, Boston, MA

Software Developer/Test Plan Designer

• Developed a test plan for an offshore testing company to test new product enhancements for a Reporting Services 3rd party product. Required extensive knowledge of Reporting Services and the ability to quickly learn new product details.
• Also developed demo applications using Reporting Services, SQL Server, and .NET for marketing department to use in sales presentations. Needed to develop applications crossing various industries.
• Also aided staff in debugging Reporting Services problems and Reporting Services setup.

Confidential, New York, NY

Lead Developer/Data Warehouse Lead/Disaster Recovery Lead

• Designed and developed data warehouse and data marts to standardize and integrate customer and financial information across multiple systems and locations across the U.S. Required developing multiple ETL processes via DTS and SQL, as well as OLAP Data Cubes.
• Also designed, and developed multiple reports to view warehouse data.
• Also designed and developed a central clearinghouse to synchronize data between financial accounting system and CRM system used by marketing. The clearinghouse allowed for order entry into any system with a nightly process that updated every other system accordingly. The clearinghouse also generated invoices as well as multiple reports.
• Each system dealt with millions of records at a time.
• I also designed and implemented a disaster recovery system extracting data and source code from multiple systems and porting it to off-site servers in case of emergency. These servers were not just for storage, but needed to be functional so all other locations could operate if one location had an emergency.
• Also implemented “do not call” lists and integrated 3rd party lists into a Lyris server.
• The above work required constant contact with business users and managers and any stakeholders to gather requirements, design specs, obtain sign-off, and deliver finished products.
• The above work required MS SQL Server, ASP.NET, Visual Foxpro, Microsoft Reporting Services, Microsoft Analysis Services, DTS, Visual SourceSafe, Microsoft BI Portal, and Data Cubes. It also required very intense data conversion routines.