Work Experience:

Confidential C, VB.NET, JavaScript, ASP.NET, MVC 4.5, SQL Server 2012, SSRS, Developer Contractor, Malvern, PA

• Confidential provides a best - of-breed, Lending Collections web site solution t over 500 Institutions Credit Unions in ASP.NET SQL Server 2012.
• I leveraged Visual Studi 2013, SQL Server 2012, SSRS, AccuRev, FinalBuilder, and homegrown tools t feed SQL scripts, web pages, middleware, metadata, and SSRS reports, int continuous integration streams for multiple versions of the Confidential product lines.
• Delivered an SSRS Report stored procedure t deliver an SSRS Bar Chart Report with Date Range, Daily/Weekly/Monthly parameters and a multi-selectable checkbox parameter.
• Cloned re-factored a .NET Nuke ASP.NET.aspx page to
• Upload files int 2Gb varbinary max fields in a new database table that I scripted.
• JavaScript validate for the 2Gb file size limit.
• Authored Feature Design Documents and scheduled and led QA Feature Handoff meetings.
• Used OnTime Replicon for
• Feature Status, Collaboration, Workflow, Time Reporting
• Defect Status, Resolution, Collaboration, Workflow, Time Reporting
• HR-Payroll Reporting

Dow Chemical C 4.5, SQL Server 2008, JSON, WinForms Developer

Confidential

• Dow Chemical Engineers use a new C, WinForms application t model materials properties for the manufacture of semiconductors.
• Fixed bugs produced new functions, new Nevron and Microsoft charts, new stored procedures in Visual Studi 2012 and SQL Server 2012 Management Studio.
• Collaborated with other software developers via Team Foundation Server TFS authored and resolved User Stories merged software changes int Main and Local software stores
• Deployed multi-selectable ListBoxes on WinForms that display results statistics in the Chart control DataGridViews pass XML t ADO.NET stored procs t flexibly search tblXXX exec storedProc ' 123456 '
• storedProc
• DECLARE tempIdTable TABLE id int -- if parameterIdListXML is null
• XML is null, s get all Ids from tblXXX int tempIdTable insert int tempIdTable select distinct Id from db .tblXXX else XML not null, User multi-selected Id subset, s get XML Ids int tempIdTable
• INSERT INT tempIdTable id
• SELECT row.value ' id 1 ','varchar max '
• FROM parameterIdListXML.nodes 'DocumentElement/Table0' as Tabx row end
• Select from tblXXX where Id in select id from tempIdTable
• Used LINQ t Objects t parse parent-child DataTables int hierarchical, classes
• Deserialized JSON data files int hierarchical, JSON tagged classes
• Displayed the scientific, data hierarchies in a TreeView.
• Revised exception handling t automatically email screenshots t development team.

Confidential

Developer

• Specialty Rx pharmacists fulfill prescriptions and log the workflow in vendor software, but the vendor software does not meet Specialty Rx's partial fulfillment needs. For example, if patient needs 30 tablets, and we only have 12 tablets, we send the 12 tablets now, but new software needs t log the 12 tablets manage the eventual fulfillment of the other 18 tablets.
• The software manager and I worked together at Davidsohn in 2007, s he called me again in 2013. We collaborated on and documented his software specifications and I produced the new C WinForms solution and SQL Server 2012 tables and stored procedures.
• Built the WinForms in a Multiple Document Interface MDI with custom logic t allow just one instance of each child form type that controls full, read only, or n access privileges per child form user and group names are managed in Active Directory forms and access levels are stored in SQL Server 2012 tables
• Built basic lists and insert-update functions with ADO.NET in WinForms DataGridViews with right-clickable rows that persist Partial Partial Details data in SQL Server 2012 tables via stored procedures.
• Built Crystal Reports file t a strongly typed, ADO.NET dataset with related tables from my SQL Server stored procedure with an XML list parameter t produce shipping labels prescription labels that look like what you see from your own pharmacy.
• Created a class inheriting from ComboBox t create a smarter, Intellisense ComboBox s that user's keystrokes are limited t ComboBox members.

Confidential

Developer

• Performed software development tasks problem solving on a legacy ASP.NET web site.
• Enhanced C, VB.NET, Web Services, JavaScript Oracle stored procedures packages.
• The assignment was related t my earlier work at Merck from .

Confidential

Architect Developer Confidential

• Tools: Visual Studi 2010, SQL Server 2008, Oracle 10g, Subversion, Sharepoint Designer
• Created the Identity Delta Tracker, C, Console Application Oracle Database.
• Reads an ADAM Identity Management Database.
• Inserts and updates Oracle Employee Records with different organizational and location attributes.
• Emails results and .NET software error stack trace inf for pinpoint error tracing.
• Worked with the Control-M Team t schedule the console once a week.
• Created the Compliance11 Delta Tracker, C, Console Application Oracle Database.
• SQL selects the Identity Delta Tracker Database for employees pertaining t compliance.
• Inserts and updates Oracle Employee Records with different organizational and location attributes, t mirror the vendor database.
• Performs C automation t create, PGP Encrypt FTP transport results t the external Compliance11 Vendor.
• Emails results and .NET software error stack trace inf for pinpoint error tracing.
• Worked with the Control-M Team t schedule the console once a week.
• Created the Compliance 11 Watch List Processor, C, Console Application
• Reads an Excel 2003 file int a .NET DataTable.
• Performs C automation t transform, create, PGP Encrypt FTP transport results files t the external Compliance11 Vendor.
• Emails results and .NET software error stack trace inf for pinpoint error tracing.
• Worked with the Control-M Team t schedule the console once a week.
• Inherited the Compliance Risk Assessment Tool, C, WinForms Application.
• Persists state in a SQL Server 2008 Database.
• Took over the project on day 1 of first production release.
• Emails .NET software error stack trace inf for pinpoint error tracing.
• Made extensive WinForms enhancements, complex data editing and stored procedure additions.
• Rekeyed the database and stored procedures for multiple years of data.
• Created the Custom Web Utilities, C, IIS 7.0 web site and redirection sites
• Compliance11 Single-Sign-On SSO
• Or user clicks vendor email URL with query string info.
• Windows authenticated user is translated t email address vendor key.
• A URL is constructed with query string info, then is PGP encrypted.
• Page redirects t encrypted URL t redirect, aut login and place user at the emailed external Compliance11 vendor, sub web page.
• Intellum Single-Sign-On SSO
• Windows authenticated user is translated t keycode vendor key.
• A URL is constructed with query string info, and POSTed t vendor.
• POST results are used t create URL t redirect aut login user int external Intellum vendor site.
• Building Access Resolution Processor
• User loads 7 different Excel 2003 Excel files related t Employees in Buildings and Floors int a network share data source folder.
• Files are consolidated int one CSV file s employee errors and omissions can be easily identified eliminated from Building Floors systems.
• Emails results and .NET software error stack trace inf for pinpoint error tracing.
• Created the SDE Timesheets, C, IIS 7.0 Web Site
• SDE is an EMC asset management tool with its own SQL Server 2005 Database.
• Created new SQL Server views, functions, stored procedures, and CTE SQL.
• Create new IIS 7.0 WebForms project with user controls, DataGridViews and ObjectDataSource binding t allow user t persist days worked on a monthly basis.
• Managers and CI Office users can d the timesheets for their groups.
• Emails results and .NET software error stack trace inf for pinpoint error tracing.
• Software support of legacy systems
• Performed content updates on Sharepoint 2007 pages using Sharepoint Designer, document lists, navigation lists and web part HTML content editors.
• Ran Unix scripts in Citrix windows.
• Performed basic FTP file management on Vendor folders.

Architect Developer

Confidential

• Worked with stakeholders and lab workers t specify, develop deploy the next generation of software solutions on MOSS 2007/2010 Sharepoint Portals, ClickOnce WinForms, ASP.Net WebForms, Oracle 11g and SQL Server 2005 platforms.
• Authored deployed ClickOnce WinForms C 3.0/VB.NET applications that fetch persist data in a half dozen Merck Oracle and SQL Server Databases t optimize the workflow for pharmaceuticals tubes, plates, barcode labels, lab workers, researchers, robots and the Merck Data Analyzer API. Wrote Oracle 11g and SQL Server 2005 stored procedures accessed via the .NET Enterprise Library. My windows and web solutions send workflow emails t research teams and send software exception emails with source code line numbers t the support team.
• Wrote software roadmap documents proposals t expose hidden functionality, clarify database relationships, show system data flows map out earlier software solutions.
• Enhanced deployed WebForms Excel Automation on the gcs.merck.com intranet.
• Created a new. AJAX, ASP.NET 3.5 intranet web site for ordering compounds and other jobs that connects t my earlier order fulfillment solution in the lab. The users particularly like the AJAX CollapsiblePanels for organizing the Web UserControls on webpages.
• Research: Built deployed C Visual Studi Projects t deliver SharePoint features, pages web parts on a Hyper-V VM WSS 3.0 Sharepoint 2007 Team Site.
• Tools: Visual Studi 2008, SQL Server 2008, Oracle 11g, Visual Source Safe 2005

WinForms Developer

• Treasury Department gave me an Excel file that needed t become an MSAccess database.
• Designed normalized database table structures.
• Coded and reused some C MDI WinForms and components that:
• Run processes in separate threads thread can update the WinForm controls
• User can start other threads or kill the program cleanly insert the data int the hierarchy of database tables. view the database hierarchy in DataGridViews bound t BindingSources bound t DataSets with DataTables with DataRelations.

WinForms, Developer

• Designed coded an extendable, C, Web Scraper console application that automatically downloads an Excel file from a URL, s that n daily, human, web session is needed.
• Studied the ORC Cameron Vendor FIX Protocol Server. Downloaded their C Source code sample application that streams FIX messages. At the time, vendor did not offer a C .Net streaming version, s I had t figure out a way t pass a C delegate t the C code s that the C vendor code could run C client applications t store portions of the stream int SQL Server tables.
• Re-factored four legacy C WinForms Clients that pass a delegate t my new C Managed Financial Exchange FIX Protocol Server. a delegate is a pointer t Client Logic that parses each FIX message trader, account, price, quantity, etc. updates a SQL Server 2005 database via ADO.NET.
• Authored a new C Managed FIX Protocol Server that encapsulates the Platform Invoke P/invoke marshalling of unmanaged C data passes Client Delegate through t my new C Unmanaged FIX Protocol Server.
• Authored a new C Unmanaged FIX Protocol Server that reuses the ORC Cameron vendor's C code for socket message streaming. runs the Client Delegate Callback logic t process each streamed message.
• Authored a detailed architectural whitepaper on the 3 classes of components above.
• Links: FIX Messaging Protocol, ORC Cameron Vendor, First New York Securities,
• Tools: Microsoft Visual Studi 2008, SQL Server 2005, Visual Source Safe 2005

Confidential

• Inherited source code for ASP.NET, C, web sites, web services, window services, Oracle 10g databases, SQL Server 2005 databases MSI installers.
• Purchased workstations built VMware Virtual Machine VM development environments for Visual Studi 2008, Visual Source Safe 2005, Oracle 10g, SQL Server 2005.
• Recruited, interviewed hired four C, SharePoint, ASP.NET, SQL developers.
• Directed developer task assignments software change management.

Confidential

• Installed VM development environment with Windows Server 2003, SQL Server 2005, Visual Studi 2005 Source Gear Vault similar t Visual Source Safe .
• Authored a white paper and prototyped a website that produces Microsoft Word 2007 documents via Microsoft Office Open XML automation.
• Produced JavaScript, CSS, C, ASP.NET SQL Server 2005 components for ASP.NET 2.0 reinsurance web sites.
• Produced SQL Server Procedures, Views, Triggers, Excel Pivot Tables Charts
• Coded SQL Server scripts for Reference Table truncation and parent-child table scrubbing.

Confidential

• Each web session reads database data from a shared memory cache.
• Radically improved site performance and user satisfaction.
• Minimized large, expensive, duplicate database data I/O.
• The cache is refreshed only when the database data changes.
• Authored a white paper on the solution for the other developers.
• Added cached data access Excel Export t more than 60 web pages.
• Authored C classes, SQL Server stored procedures and triggers.
• Optimized, enhanced and deployed UIs, middleware and data tier.
• Tools
• Microsoft Visual Studi 2003, ASP.NET 1.1, C, SQL Server 2000
• Visual Source Safe, Intuit QuickBase, Visio

Confidential

• Built ASP.NET 2.0, Oracle and Corda objects for AquaLogic/Plumtree web portals.
• Developed 20 portlets/webparts that communicate with each other.
• Developed 12 ASP.NET 2.0 search/sort/insert/update portlets.

Confidential

• Designed coded a Visual Studi .NET SQL Server 2000 MSDE solution t allow agencies t upload payment transactions from remote locations.
• Helped my manager tw programmers t learn VB.NET for Windows, with a focus on 3-tiered philosophy, debugging coding standards.
• Built Windows Forms Web Forms processed by a common business tier.
• Built the tables for a new SQL Server 2000 MSDE database.
• Coded ADO.NET for DataStream, DataSet, DataView, DataRelation XML.
• Added inheritance overrides t controls for HotComboBox OnFocus extension.
• Added a Crystal Reports Viewer, t show payments for any date range.
• Implemented consistent Try-Catch coding standards t log faulty instruction line numbers t log the call stack trace.

Application Architect

• Designed built a new insurance claims management system with VB6 COM components MSAccess database t run with n in-house software support.
• Gathered documented software needs from non-technical, business users.
• Claims Reps manage financial adjustment items for multiple concurrent claims per session.
• Provides a unified view of Outlook WinFax messages linked t each claim.
• Message Builder t build quick, complete, professional messages with:
• Automatic headers, footers, addressees, dates, salutations
• Easy boiler plate insertion archiving
• HotComboBox for Outlook contacts.
• Direct e-mail delivery or simple export t Outlook WinFax.
• Views t legacy FoxPr databases.
• Sophisticated ad hoc querying, query saving reporting.
• Authored the system specifications, user guide, acceptance test plans.

Confidential

Panagon WorkFl Developer

• High volume, medical prescription, fax traffic automation.
• Developed a syllabus conducted weekly seminars on VB6 COM topics.
• Converted the user interface from Gupta Centura SQL Windows t an n-tiered, VB6 solution.
• Business tier Sybase, MQ, Panagon WorkFl data tiers with Microsoft Transaction Server MTS
• Created a new Intranet Web Site t allow administrators t unlock hung work objects.
• Coded a VB6 tool that loads work objects graphs performance of dispatch browse times as work queue sort rules are applied tweaked.

Confidential

Application Architect,

• Designed coded a VB6 Financial Research Targeting System t identify institutional buying patterns based on Institutional/Ticker/Peer Group financial factors.
• Built a new MS SQL Server database reused legacy tables.
• Coached an ASP developer t use my new business tier components that deliver XML stylized with XSL as HTML.
• Mentored other project managers in engineering n-tiered, software solutions.
• Managed five Visual Basic 6.0 developers, three Oracle 8 developers and four QA Testers in the pre-production, QA phase of a mission-critical, Editorial Management System.
• Developed and documented software tasks in the Test Director tool.
• Managed and prioritized the last 300 tasks created by developers, users and QA people.
• Coded VB 6.0 code and Oracle PL/SQL t fix 10 software bugs.

Confidential

Developer

• Directed performed various software for a business-to-business, E-commerce site.
• Authored VB6 application that copies parent child SQL Server 7 departments, categories, products, variants prices t a new wholesaler.
• Modified a VB6 application that uploads departments, categories, products, variants prices from Excel t SQL Server 7 via stored procedures Excel automation.
• Led a team t find off-the-shelf, knowledge management solutions. Conducted meetings t match our software delivery re-engineering needs with vendors' solutions.
• Received Microsoft training in Site Server 3, Commerce Edition 3.