• ETL team lead for Informatica developers on Enterprise Data Warehouse• Responsible for architecture documentation and Source to Target Mappings on Enterprise Data Warehouse• Manage and develop BizTalk Orchestrations to communicate with 2500 Store POS systems (Prod, Dev & QA)• Handle support and development for internal Inventory management application including SQL queries, Stored Procedures, DTS loads, Javascript, VB.NET, HTML, NT Services and Network Load Balancing (NLB) issues. • Support 4 web applications that managed Executive reporting, Store space planning and Major Accounts• Convert ASP.NET 1.1 application to ASP.NET 2.0/AJAX/64-bit mode and added Telerik controls• Work on daily QA of other developer’s DTS, SQL, Stored Procedures, C# & VB.NET code and Excel files• Create SSAS Cubes for POS Sales and Store Inventory out of 2 TB data warehouse on a monthly basis• Implemented Dundas Chart against SSAS Cubes to produce an Executive Dashboard• Create various Sales, Inventory, Profit and Pricing reports from data warehouse in SSRS• Develop DTS packages to pull normalized data into Reporting tables for quick analysis• Write dynamic SQL scripts against data warehouse to produce ad-hoc Excel reports• Modify TFS Work Item Templates to suit custom department workflow requirements• Develop plug in Exception Handling framework for any internal ASP.NET application based on Microsoft Enterprise Library (June 2005 version)

• Senior developer responsible for converting business logic COM objects to custom VB.NET DLLs.• Lead developer in charge of converting Windows client/server application to ASP.NET in 1 year. • Changed application architecture from one database per client to multiple clients per database for manageability.• Created 3 tiered solution for ASP.NET application to allow for reusability, portability and database CRUD operations without making modifications to any consuming User Interfaces.• Developed code generation of data access layer classes if SQL Server table structures changed. • Mentored other developers in the group on best practices in: VB.NET, ASP.NET, Visual Studio.NET, Stored Procedures, User Defined Functions and database Table structures. • Used Infragistics web controls for competitive advantage and quick time to market • Helped enhance the business logic of the Vertex™ product with new financial metrics• Converted database lookup values to 5th order equations in code increasing application speed 5 fold

- Chief developer for migrating the company Intranet from ASP based website to ASP.NET including security model, data access layer, backwards compatibility and custom web controls- Built company specific framework of .NET Classes for data access, utilities, authentication and custom controls to improve developer productivity- Helped create Stored Procedures, User Defined Functions and Table standards for data access into SQL Server including naming, flow and documentation- Created C# and VB.NET templates, custom Project and WebForm wizards integrated into VisualStudio.NET for standardization, code re-use and productivity- Developed web based application for Risk Management to track unusual occurrences in electronic format instead of through paper processes- Converted Access based project management application to web based with various views, workflow and Help Desk integration. - Built custom application transforming surgery data into XML for import into nationwide surgery trending program- Created webservices to interface with Cloverleaf to enable storage of ADT in SQL Server. - Wrote TCP/IP Socket Windows service to receive HL7 data from Pyxis Pharmaceutical product for Just-In-Time pharmaceutical inventory management- Provided mentoring and knowledge transfer to other developers in C#, VB.NET, SQL Server and application architecture - Used SQL Server Reporting Services to create dynamic reports and graphs for management business intelligence on a variety of applications