Summary : Results-Oriented Project Lead / System Analyst with over SEVENTEEN years experience in systems development and project management. Creative problem solver, able to communicate with all levels of management. Have a unique blend of technical, business, and organizational skills that allow me to bridge the gap between technology and business driven goals. Have managed and developed systems in Business Intelligence, Client/Server and Web-Based technologies.

Major Skills:

More than 8 years of VB.NET, ASP.NET, C# , VB, ASP , XML, MQ
More than 7 years of Java, JSP, XML , HTML, JavaScript, MQ
More than 12 years of Oracle PL/SQL
More than 5 years of SQL Server , DB2, T-SQL
More than 3 years of Cognos, Informatica (Cognos Certified)
More than 6 months with .NET 3.5 - WPF, LINQ, AJAX web controls and WCF services.

Confidential Lakeland FL Nov2007 till to date
Role: Sr. Software Consultant

SUPPLY CHAIN WORKBENCH: ASP.NET, C#, Oracle10g, SQL-Server2005, VB.NET, MQ, WCF. NET3.5, SSRS and CRYSTAL REPORTS.
The Supply Chain Workbench (SCW) is an intranet web-based application that will have portal and standalone components that automate the replenishment of products sold at the store This is front end to a very large complex supply chain system comprising of various components like forecasting , scheduling, generating orders and data mining of historical sales and lost opportunity.
Web application is used by more than 10,000 store managers to review up coming orders, forecasting demand of more than 25000 products per store. UI is used by users to make educated decisions about the replenishment of their inventory.
Languages used for building Web application are ASP.NET, VB.NET, C# and crystal reports.
Numerous key disparate subsystems used by Web application are based on WCF web services built using ASP.NET, SQL Server2005, DB2 and Terra Data.
KEY DELIVERABLES:

• Core member of Supply Chain Workbench applications/services.
• Developed solutions for critical functionality using ASP.NET, Oracle Pl/SQL, SQL Server T-SQL , VB.NET , C# .
• Writing high quality code in ASP.NET, VB.NET and C# and within tight schedules.
• Data modeling/development using SQL Server2005 / Oracle 10g.
• Design and development of stored procedures and user defined functions for .Net applications and batch processes.
• Design and building framework components, common controls, web services and infrastructures that have been leveraged by the application development teams using ASP.NET, VB.NET and C#.
• Design high performance computing and scalable architecture.
• Communicate with the team as well as key stakeholders.

Window Services and IBM MQ Queues : All changes made from the ASP.NET UI will be written to a database table and picked up and published to an MQSeries queue asynchronously. This is all done using a WCF windows service keep alive mechanism and a constantly running set of .NET executables that use the WCF PAIL to publish messages to a predefined set of queues.
American Family Insurance, Madison, WI March 06 to Nov2007
Role: Sr. Software Consultant
Web applications :

• AFP Agent Finance Plan :The AFP web application is used by District Managers to model the first five years of a new agent's financial operation which includes production goals. Java, JSP, Hibernate, Ajax, Oracle 9i, DB2 , Struts, Websphere, WSAD.
• SPD Sales Planning Dashboard : The Sales Planning Dashboard is a web based analytics and reporting application .This system provides "diagnostic pathways" for 5 major groupings of data. The 5 groupings are Profit, Growth, Market Data, Production and Retention. Java, JSP, Spring, Oracle, DB2 , Struts, Websphere, WSAD, CEWolf, SSO, JSTL, JFreeChart.
• EVTRTRBTC (EVENT ROUTER BATCH APPLICATION) : This Batch application is to route event message from a message queue of the Sales Initiation Suite (SIS) Auto Quote application to ETL processes for EDW loads and Business Activity Monitoring tools such as telemetry dashboards. MQSeries, Java, DB2, Oracle10i.

Data Warehousing Application and Business Intelligence System

• SIS AUTO QUOTE : Parse XML documents from event messages from a message queue of the Sales Initiation Suite (SIS) Auto Quote application. Gather Customer requirements and defining Fact Qualifier Matrix for SIS AUTO QUOTE. Create Draft Lineage document for SIS Auto Quote, Create Data Models, ETL Specifications, ETL Unit Test Plans. XSD, XML, Informatica 7.1.4, DB2.

Confidential, Madison, WI Jan 04 to March 06
Role: Project Lead/ Analyst/ Programmer
Web applications :

• CCPVS, The Construction Contract Payment Viewing system is an Extranet application accessible from the WisDOT Highway Construction Contract Information site. Java, JSP, Oracle(PL/SQL), Websphere5.1
• ESUBMIT, This application will create facility allowing outside contractors to electronically submit engineering drawings to WisDOT via the Extranet. Java, JSP and IIS on Websphere5.1. This web application for file upload uses Apache\'s file upload utility, IIS HTTPPUT and socket programming using MVC architecture.

Confidential, Janesville, WI Jan 04 to March 06
Role: Project Lead/ Analyst/ Programmer
Web applications :

• Business partner access system is an Extranet application . This applications also allows individuals to print shipping label with bar codes. This application allows SSI Technologies to broadcast messages using ASP.NET, VB.NET , Oracle(PL/SQL), XML/XSL, XML DOM, XML Schemas and XSLT.

Data Warehousing Application and Business Intelligence System:

• Design Mappings in Informatica. Writing ETL Mapping Specification Template, Test Plan Templates, Design and develop various Decision making reports using Informatica , DB2, SQL Sever and Oracle.

Confidential, Madison, WI Jan 02 to Jan 04
Role: Lead Programmer/Analyst
Client Server applications

• Batch job in VB.NET to get Delegation keys from Active Directory
• Migration of VB6 application DWD Letter application using VB.NET and Oracle Stored Procedure using PL/SQL, Biztalk.
• ICMS Enhancements for WC using Oracle PL/SQL (Packages).
• Migration of VB6 application to .NET Windows Applications using C#, Oracle and XML.

Web applications

• WCReportAccessRequest Creating Accounts, Delegating Access and Maintain Access Rights in Active Directory using ASP.NET and VB.NET
• WC Reports - Active Directory Migration using ASP.NET and C# FROM ASP.
• Code Block Validator is used by various systems to test the validity of the Wismart Account Codes. Test forms were developed using ASP.NET . Business logic was embedded in Oracle Packages using PL/SQL in TOAD.

Confidential, San Francisco, CA Jan 2000 to Jan 2002
Role: Project Lead/ Analyst/ Programmer
The Balancing and Settlement System (BASS):
Web application: Java, JSP, VB, Coldfusion, Websphere, ORACLE 8i.

• The Balancing and Settlement System (BASS) is a browser-based application designed to provide the Balancing and Settlement (BAS) clerks with the information necessary to reconcile balances recorded with actual amounts received at ATM Machines. This extranet application was developed in Java, JSP, XML, VB and cold fusion, PL/SQL in SQL Navigator. Responsibilities included project planning utilizing MS Project, conducting weekly meetings with end-users, distributing work among six team members, designing the database and system, preparing test plans, reviewing code, testing, implementing and documenting.

Data Warehousing Application and Business Intelligence System: Cognos6, Informatica 6.1, Erwin for Data Model, ORACLE 8i, Windows NT/2000, IIS for NT, IE.

Confidential, Madison, WI Nov 98 to Jan 2000
Role: Senior Programmer/Analyst

• Sole designer and developer of Managed Forest Laws Application using PowerBuilder and Oracle (PL/SQL).
• Involved in design and development of Environmental Enforcement CASETRAK Application using PowerBuilder(PFC) and Oracle (PL/SQL).

Confidential, Las Vegas, NV June 98 to Nov 98
Role: Senior Programmer/Analyst

• Involved in design and development of PROJECT 2000 Application using PowerBuilder(PFC) and Oracle (PL/SQL).

Client Server Applications in India Dec 93 to Jun 98
Role: Programmer/Analyst advancing to Project Leader

• Led a 3 year application designing and developing Product Structure Management System Application using Visual Basic, PowerBuilder(PFC), Infomaker5.0, Oracle (PL/SQL) and MS-Access.This application was completed on time and within budget with minimum corrections by my six-member team. MS Project and Power Point were used for project management.
• Involved in design and development of various other systems using VB4.0, Crystal Reports, ODBC, Oracle SQL, PowerBuilder, C++ and SQL Server. Oracle on HP Unix.

Summary of Technical Skills from above applications:

Internet Technologies: Java, JSP, VB.NET, ASP.NET, C#, Rational Rose and XML
Frameworks : Spring , Hibernate, Ajax, Struts, EJB
Databases/Tools: Oracle 9i, MS-Access, MS SQL Server
OLAP Tools: Informatica7.1, COGNOS6, Crystal Reports
Web/Application Servers: IIS, Apache, JRun, Websphere, EAServer, JBoss
Others: COM+, ADO, ODBC, MTS, SQL-LOADER, MS-Access, OOAD, C, C++, FoxPro, Visual Source Safe, Microsoft Visio, Microsoft Project, Microsoft .NET
Data Modeling: Rational Rose, Irwin, Visio.
GUI Tools: PowerBuilder 6.5/5.0/4.0, Infomaker5.0, VB6.0, MS-Access

Education:

• Higher Diploma in Information Systems Management
• MS in Engineering