SUMMARY:

• C# with Entity Framework MVC 2+ years . Sequel Server Reporting Services SSRS, 3years, Sqlserver 7 years . MS ACCESS/VBA 7 years . JavaScript 1 year, Visual Basic 6.0, HTML5, CSS, XML, ASP, COM, ADO, DAO, API, ODBC. CRM Siebel Tools, jQuery, Ajax, LINQ. Visual Studio, Team Foundation Server.
• SQL Query expertise: Stored Procedures, Triggers,Views, Oracle, PL/SQL, and T - SQL.
• Project management and supervisory skills. Member Agile/Sprint/ Scrum team.
• Extensive experience writing Business requirements, Functional Requirements and Technical Requirements.
• Travelled around the globe for HP, Compaq and Arkwright Insurance to train users, gather business requirements and to establish good business relationships.
• Technical team leader (2-4) resources onshore and offshore.
• Production support experience for major CRM Call-center /Partner Management implementations for Confidential and Compaq and Mass Commonwealth.
• Hot fix and-release management. Technical and End User experience.
• Expertise in System migration, Data mapping and Integration. System simplification.
• Extensive QA experience. Found 123 bugs for Mass.gov Finance application and logged into Bug Tracker app with C# and SQL database as technical recommendations.
• Business application experience: Finance, Claims, Insurance Industrial and Personal, CRM Customer Relationship Management, PRM Partner Relationship Management, Sales and Call Center.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Migrated MS Access screens to C# entity MVC4 framework. Converting 1000 lines of VBA code to C#/MVC/Razor/HTML5. Converted payment and adjustment screens. Created SSIS scripts with embedded C# as the scripting language to migrate data to SQL server.
• Meet face to face with the business Functional requirements gathering. System analysis and project planning/scoping.
• Create SQL tables with auto Identity primary and indexed.
• Create SQL server views.
• Create Stored Procedures with cursors.
• Create light weight MVC controllers that interact with complex C# business layers.
• Create C# business logic with thousands of lines of code data manipulation.
• Create HTML/C# razor screens to present data.
• Interact MVC business layers with SSIS packages.
• Create robust C# screens with embedded hyperlinks that invoke pop up forms.
• Utilize Jquery and JavaScript to manipulate forms.
• Create MVC entity framework to work with the SQL data model.
• SSRS Reporting: Produced dozens of reports by creating the stored procedure or tables and used the stored procedures as a data stores in the SSRS reports. Reports utilized stored procedure parameters.
• Create simple SSIS modules with C# as the scripting language. Reads flat files, do calculations, populate sql tables and rename the files to folders.

Confidential

Responsibilities:

• Migrated MS Access Finance, Insurance/Claims/Payments applications to a normalized SqlServer 2012 backend. Improved performance across entire Finance Access application by creating optimized pass through queries and indexes. Stabilized application by correcting and creating more optimal VBA code. Improved the Claims user experience by reducing screen response time from 1.5 minutes per transaction to 3 seconds. Create a very robust Customer History screen with pages s VBA business and math logic as well vast amounts of conditional field formatting color and highlights . Mentor junior programmer in MS Access.

Confidential

Responsibilities:

• Enhance BizFon MS Access/VBA CRM application. Modify Access screens and Reports VBA code for additional functionality. Correct CRM/Siebel issues. Analyze batch Visual Basic 6 programs. Optimize MS Access and SQL Server queries. Utilize pass- through queries, optimize indices, tables and joins. Functional requirements gathering. System analysis and project planning/scoping.

Confidential

Data Integration Lead

Responsibilities:

• My role was to guide a team of developers from India, MA and California in building specialized data integrations and MS-ACCESS applications for Confidential ’s largest ever PRM (Partner Relationship Management) implementation. This included two dozen data integrations that imported data in a variety of formats into an Oracle database and a SQL server data mart. We used VB6 in batch mode to pull and verify the data on nightly bases. Visual Basic 6 and Access/VBA applications were created to front-end the Sql server data mart.
• Extensive project planning, overseas travel and requirements documents were also a major part of this project. Meeting face to face with the business for tram building was a vital part of the project.
• Compaq Computer Corp. Siebel CRM Consulting Services.As a member Professional Services Consultant team I was a Siebel developer working on loan for companies outside of Compaq. Extensive national and International travel.
• The state licensing agency wanted to replace inspectors carrying large manuals to construction sites with Siebel on an iPAQ. The state wanted to use the application to look up and enter information about the site such as people working on the site. Should they be there? Are they licensed?
• I configured a Siebel CRM prototype that allowed this in the field. I travelled to numerous New England states to meet with managers and business owners.
• Similar State Projects prototypes were developed for the State of Connecticut and State of Pennsylvania.
• Compaq Call-Center:To aid the Littleton call-center power users and sales teams I developed a host of JavaScript/ASP web sites and Visual Basic/COM, MS- Access/VBA and Excel/VBA screens to interact with a CRM Siebel Oracle database.