Software Engineer

Extensive experience in analyzing requirements and meeting business objectives through creative design and efficient implementation. Strong background in analysis, object-oriented programming, web development and database design. Excellent interpersonal, written and verbal communication skills having led, trained, coached and mentored high-performance teams.

Languages: 10 years in .NET development (VB, C#, ASP), 4 years using PowerBuilder, 5 using Oracle Forms, XML, HTML
Databases: 19 years using SQL (10 using SQL Server, 5 using Oracle, 4 using Access)
Operating Systems: Microsoft Windows (7, XP, 95, NT, 2000)
Networks: Microsoft Internet Information Server (IIS 6, 7)

Selected Career Achievements

• Wrote a parser that is able to break down any valid SQL syntax into a tree structure.
• Created a GUI with dynamically created objects used to render the contents of the parsed SQL tree structure.
• Received a Verizon Excellence Award for work on BillManager.

Professional Experience

Confidential, New York, NY 1996 – September 2, 2011
Lead System Analyst and Programmer

• Team leader of 4 developers for the BillManager 4.0 project. BillManager is a desktop billing analysis tool that Verizon provides to 2000+ customers to analyze, browse, report, organize and redistribute across internal departments its billing data which the customer receives either via download or on a CD. Led a team of 3 offshore developers in Argentina to maintain and upgrade BillManager with newer features.
• Designed and wrote a SQL parser class in VB.NET that allowed BillManager to provide advanced users the capability of using the full power of SQL instead of being limited to a predefined set of query methods. Designed and wrote the GUI that then uses the parsed text to display the query in the form of buttons, textboxes, checkboxes and listboxes. This enables users to create or modify complex SQL without knowing SQL syntax. This was possible by creating a complex parser based on syntactic metalanguages.
• Designed and wrote the SQLBuilder class. This class dynamically creates all the objects as needed by the SQL passed to it. This allowed the GUI to show only the controls that the current report/SQL requires.
• Designed and wrote all the base classes used by BillManager. All the objects used in the application then inherited from the base class a standard set properties and methods. This allowed an easy way of implementing, for example, context sensitive help, by updating the base classes with the appropriate properties and methods.
• Designed and wrote an application wide error handling routine, implemented via the base classes, which standardized exception handling, resolution and logging.
• Created a dynamic report generator class using DataDynamics ActiveReports that was used to generate complex reports such as embedded reports, parent-child subreports, running subtotals, dynamic page headers/footers/footnotes and graphs to name a few.
• Designed, created and maintained the relational database backend of BillManager using SQL Server 2000/2008 which consisted of 235 tables and 1196 views.
• Maintained the Online Analytics web app using ASP.NET and VB with some C#. Optimized the application by finding and fixing memory leaks caused by improper creation of connections by implicitly creating connections inline that prevented the connections from going out of scope and therefor being ignored by the garbage collector.

Software Engineer (Consultant)

• Developer for the BillManager 3.0. I was originally brought in due to my PowerBuilder and object-oriented background but I quickly adapted to using VB.NET when it was decided to be used instead.
• Because the previous version (BillManager 2.0) was written in Access, my main contribution was the introduction of object oriented programming and methodology to the team.
• Created 200+ reports using Seagate Crystal Reports and created report filtering forms to allow users to fine tune their results.
• Designed and wrote an application wide error handling routine, implemented via the base classes, which standardized exception handling, resolution and logging.
• Analyzed, designed, developed, tested and documented the Power Information Management System using PowerBuilder 4.0 and Oracle 7.3.

Confidential, Whippany, NJ 1996
NECA is a membership association of U.S. local telephone companies dedicated to keeping customers connected on state-of-the-art communications networks.

Software Engineer (Consultant)

• Maintained the Cost Study and Network Usage System. Created cost study reports using Oracle stored procedures and created front end filters using PowerBuilder 4.0.

Confidential, Hartford, CT 1995 – 1996

Software Engineer (Consultant)

• Maintained and modified the Specialty Risk Management System using Oracle 7 (SQL*Forms 3, SQL*ReportWriter 1, SQL*Menu 5 and SQL*Pro C)

Confidential 1994 - 1995
Once a J.C. Penney pharmacy group, then in 1996 JCPenney purchased Eckerd, and decided to merge Thrift Drug and all other pharmacy chains into the larger Eckerd chain (now CVS/pharmacy and Rite Aid) in 1997.

Software Engineer (Consultant)

• Maintained and developed internal PowerBuilder 4 applications using Oracle 7 as the backend.
• Developed a batch process that aggregated sales data downloaded from the mainframe that reduced the previous process from 22 hours down to 6 hours. This was achieved by changing the sequential process of aggregation into multiple "threads" that aggregated non-dependent tables at the same time.

Confidential, Philippines (Software Engineer) 1991 - 1994

Education
Bachelor of Science in Mathematics, majored in Computer Science