TECHNICAL SKILLS:

MS SQL Server 2005/2008/2012/2014/2016 , SSRS, SSIS, SSAS, Power BI, Oracle, DB2, MongoDB, VB.NET, C#, ASP.NET 4.5, ASP.NET MVC/Web Forms, XML, Visual Studio, ASP.NET Web API 2, Entity Framework, Windows Phone 10, Xamarin, Azure, Telerik, SVN, Agile Development, Visual Studio Online

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

Technical Consultant

Responsibilities:

• Built back end system to support work allocation system for one of the largest clients in the organization.
• Used C#, MVC, Web API and MongoDB to architect the solution.
• This application was built in a very short timeframe and under budget.
• The application is now deployed and being used throughout the organization with significant user acceptance.

Confidential, Parsippany, NJ

Senior Developer

Responsibilities:

• Responsible for adding functionality and improving performance for several heavily used management reports. To improve performance, new indexes were added and existing indexes were refactored. The SQL that drives the report was tuned to force the report to utilize proper indexes. Added significant logic to both the underlying SQL and the C# front end to add new functionality.
• Developed workflow to include orders from Canadian system into US implementation system. Designed and coded logic to identify orders from ADPs Canadian implementation system and usher them through the standard implementation system. The implementation system is very complex and required significant modification to ensure that Canadian orders are processed properly.
• Designed and implemented a new workflow for payroll customer implementations. Using C#, SQL Server 2012 and JQuery, coded new process for onboarding customers Implementing ADPs Payroll products.

Confidential, Bridgewater, NJ

Technical Lead

Responsibilities:

• Responsible for designing and coding complex financial reports. Reports were built on top of an Izenda reporting platform that consumes an Oracle database. These reports perform complex and intense financial calculations.
• Built a new module for the Confidential Pharma Application. This module focuses on sales and rebate forecasting. Technologies used in the construction on this module include MVC, C#, ASP.NET 3.5 on top of an Oracle database.
• Implemented Agile practices based on the strengths of the incumbent development and business teams. Practices successfully implemented include focused daily stand - ups, sprints and sprint planning, continuous integration and, in some cases, test-driven development ( Confidential .) These practices allowed the organization to deliver in intervals of 3 week sprints as opposed to quarterly.
• Configured and deployed the team communication platform Slack throughout the organization. Confidential employees work remote 2 days per week. Previously, there was no organized team communication platform to keep employees connected while remote. With Slack deployed to all associates, communication was greatly improved both in the office and remote.
• Designed an implementation of Telerik controls (Kendo UI) in the Confidential Pharma Application. These controls allowed the application to become responsive to any device or screen size. Previously, this was a major challenge with no simple solution.

Confidential, Far Hills, NJ

Development Team Lead

Responsibilities:

• Designed and coded a module to send text messages through the Confidential tournament planning application. This functionality was built using VB.NET and SQL Server 2008R2 to consume texting services from third party vendor MessageMedia. A management console was also built to allow for internal monitoring and billing of texting usage.
• Developed a series of web services to allow third party vendors to consume Confidential data. These services were built using C# and consuming data from both SQL Server 2008R2 and DB2 9.6.
• Standardized important elements of software development that previously did not exist within the Confidential . Implemented ELMAH error logging and handling modules to gracefully handle and log server errors. This led to some teams of mature products being able to adopt a development model centered on mitigating previously unknown errors. Implemented NUnit for unit-testing and some test-driven development. Redgate tools for SQL object versioning and SQL object deployment. SVN with TortoiseSVN client for code versioning. This replaced a Visual SourceSafe installation that only managed code for several products. Now, all products have code properly controlled.
• Worked with other Development Team Leaders to implement portions of Agile methodology. Including scrum software development, sprint planning/delivery and Kanban boards. Migrating a team that was deeply rooted in waterfall delivery methodology to these basic tenants of Agile methodology was difficult but proved to be ultimately worthwhile. Each team would implement the tools that made the most sense for that project. With the development and project management teams supporting each other during the transition, we created an Agile implementation that worked for our organization.
• Updated the codebase for a high profile web application from VB.NET 1.1 to a more modern framework stack including C# 4.0 with MVC 4 on top of Entity Framework and SQL Server 2012. This platform migration resulted in significant performance improvements and code manageability.
• Acted as the subject matter expert on many products. Inherited and owned the code and knowledge bases for these products. Worked with other developers to transfer knowledge frequently.
• Led a team that identified and repaired many significant performance issues across a wide assortment of internal and external applications. Repairs included performance improvements within the data layer, business logic and display code. In the data layer, index analysis and tuning combined with query optimization yielded great overall performance benefits. Tools such as New Relic were used to identify which queries required attention. .NET Reflector was used to rapidly discover and correct performance problems in the .NET business logic.
• Participated on a team that migrated many of the most heavily used applications from old and untrustworthy hardware to new servers in a managed environment. Completion of this project resulted in very significant performance and stability improvements, especially under heavy load. Maintenance time and cost have also been drastically reduced.
• Migrated delivery of all email from internal SMTP servers to third party vendor SendGrid. This migration resulted in very significant improvements in delivery rates and minimized maintenance and delivery costs. One of the most high profile products of the Confidential is the bi-monthly handicap email that golfers receive. It is absolutely imperative that these emails are delivered without fault. The Confidential entrusted me with the responsibility to shepherd this system.

Confidential, Livingston, NJ

Production Support

Responsibilities:

• Provided production support for the application used by the Legal department to track case status.
• Developed new features and fixed bugs using SQL Server 2008 R2 and C#.

Confidential, Somerset, NJ

Lead Developer

Responsibilities:

• Planned and coded C# modules to process complicated life insurance calculations from several data sources. The modules produce interface feed files used to send financial data between multiple systems throughout the organization. To successfully produce these files, business rules from several different parts of the organization had to be synthesized.
• Led analysis meetings between business users and the technical team. Using financial and business understanding, completed requirements documents for several important functions needed for the production of the interface feed files.
• Developed financial transaction confirmation communications. These reports are generated from scheduled system processes and mailed to customers after financial transactions are applied to their policy. As these reports are customer-facing, it was mandatory that the data presented was perfectly accurate.
• Designed and coded a training website for ad hoc report writing in InetSoft. Used for hosting forums and videos for InetSoft training, this internal website will be re-branded to train for other products. This site is built in ASP.NET 4.0 using C#, SQL Server 2008, Silverlight, AJAX and HTML5.
• Composed reports for mortgage tracking system using MS Reporting Services and InetSoft platforms.
• Crafted a web service using C#.NET to access several corporate Active Directory servers and perform authentication methods. This web service is now used throughout the enterprise to validate credentials for any Confidential server.

Confidential, Bridgewater, NJ

Lead Developer

Responsibilities:

• Expanded and maintained the main digital sales aid (DSA) for the large team of sales representatives. The DSA tool is Flash-based with ActionScript 3.0. Using AS3 and Flash, added many new features and back end upgrades. Created several ancillary applications using C#.NET, SQL Server 2005 and XML.
• Upgraded Content Deployment System (CDS) to handle mass deployments of the DSA framework. This effort was completed using SQL Server 2005 and .NET 3.5 (VB.NET/C#.NET). A major component of this project involved coordinating disparate teams of content and framework developers to ensure all sales representatives received their proper software.

Confidential, Murray Hill, NJ

Lead Developer / System Architect

Responsibilities:

• In short time period, designed system architecture for an upgraded telecom usage management system.
• This system collects data from various telecom switches and buffer boxes and prices/reports on that data.
• Responsible for ASP.NET/SQL Server 2008 system and database design.
• Also responsible for reporting platforms on MS Reporting Services and JasperReports.
• Coordinated development effort with offshore team in India.
• This leadership aspect of the role was very important, as a good deal of development was completed by the team in India.

Confidential, Madison, NJ

Lead Developer

Responsibilities:

• Completed a refresh of a major consumer product website. The original website was static and all changes had to be made manually. The refreshed website uses ASP.NET 3.5 with C# and SQL Server 2005. Using this architecture, a management application was created to allow the product content team to update the website dynamically.
• Updated labeling information for several consumer products. Worked closely with product management team to institute a system where important label changes could take place more rapidly. Changes that previously would take up to five weeks to process now are completed in less than two weeks.

Confidential, Bridgewater, NJ

Lead Developer / Project Manager

Responsibilities:

• Developed three products for the third largest pharmaceutical company in the world. The projects include an intranet portal for project management reporting, a validated clinical trial management system and an upgraded process for requesting exceptions to the IS security policy.
• Created an intranet portal for project management reports. This portal houses custom built reports used by project managers. Built with MS Reporting Services 2005 and ASP.NET 2.0, these reports are an important link between the project managers and their data.
• Acted as the lead technical liaison between the project management systems and a new process management system. This role ensures that functions are not duplicated unnecessarily and existing functions can be readily shared and extended. The integration of these systems increases the utility while decreasing the development time and cost of both systems.
• Using advanced C# 2.0, SQL Server 2005 and ASP.NET 2.0 techniques, built a tool that tracks changes made to a project. With the deployment of this enhancement, project managers can audit changes to the status of all items in their project. This tool allows management to view an entire status history of a project.
• Upgraded the SQL Server database from MS SQL Server 2000 to MS SQL Server 2005. This important upgrade was performed with zero downtime for production applications and development initiatives.
• Performed both project management and lead developer roles for a system that keeps track of pharmaceutical clinical trials. This project was based on ASP.NET 3.5 with Oracle 11i using AJAX.NET.
• Prepared functional specification documentation for the clinical trials management software. Also created and maintained workflow charts to ensure the project was completed on schedule. This is a validated IT project and capable of standing up to an FDA audit.
• Led meetings between business users and development staff. These meetings were designed for the IT team to ask questions of the end user group and for the end user group to remain updated on the work that is completed. These weekly meetings were essential to the success of the project.

Confidential, Hopewell, NJ

Lead Developer / Reporting Specialist

Responsibilities:

• Migrated existing management reports to the MS Reporting Services platform. This migration resulted in several important benefits. A lighter load on the database server when running complex reports leading to significantly faster run times. A uniform look and feel between reports aiding in lowering training time and cost. Using MS Reporting Services as a standard method to develop custom reports also dramatically reduced development time and costs for new report development.
• Responsible for creating reports for upper management. Using a combination of SQL Server 2005 and MS Excel 2007, these reports are accurate, powerful and easy to consume. Many times, technical specifications for these reports are sparse. Intense knowledge of the systems and of the management team was integral in providing the requested products.
• Participated on development of new web portal application. This application was developed using C#.NET 2.0, ASP.NET 2.0, XML and MS SQL Server 2005 using Visual Studio 2005. The portal incorporated the use of web services to selectively expose functionality. The use of web services allowed other applications to consume data from this portal project.
• Extended functionality of legacy applications. This was a major development initiative that both modernized and expanded the Merrill Lynch corporate training intranet site. Technologies used in this project include ASP, ASP.NET (VB.NET & C#.NET) and MS SQL Server.