Caryn Oresky

Gales Ferry, CT ***** 860-***-**** adwq4y@r.postjobfree.com

SUMMARY:

Ms. Oresky is an accomplished software developer and an architect of premium quality applications with extensive accomplishments in backend, front-end, and Internet/Intranet applications. She has superb hands-on skills with a proven track record for delivering sophisticated work products on schedule. Caryn has established techniques for identifying and correcting existing design flaws and for creating code that successfully translates user requirements into working systems. She has a solid reputation for integrity and dedication to excellence.

SKILL PROFILE:

Operating Systems: Windows NT, Windows 2000, Windows XP, MS-Windows 3.1/ 95, UNIX, MS-DOS, OS/2

Languages: C#, VB, Ajax, Entity Framework, Linq, SQL, PL/SQL, JSON, JQuery, JSP, HTML, DHTML, JavaScript, XML, Java, Java Swing, Struts, PowerScript

Software: ASP.Net, Active Server Pages, Visual Studio, Infragistics .NET Advantage, Livelink, Visual Basic, New Relic, SQL*Forms, Microsoft Access, Visual Interdev 6.0, Eclipse IDE, SQL Navigator, TOAD, XMLSpy, Visual Café, MS FrontPage 98, Adobe Photoshop, PowerBuilder, Erwin, DBArtisan, Visio, Report Writer, Visual Voice, Visual SourceSafe, Designer 2000, Q&E, SQL Studio, Sheridan Data/Designer Widgets, True Grid, Wise Installation, Lotus Notes 4.6, File-Up, Joust Outliner, Installshield Professional 6.1, TFS, Star Team, Visual SourceSafe, Right Fax, ZipFind, TallComponents, Infragistics

Frameworks: WCF, .NET

Cloud Based: Salesforce

Databases: Oracle, MS-SQLServer, MS Access

PROFESSIONAL EXPERIENCE:

AmerisourceBergen/Lash Group 1/2006 – 4/2023

Application Engineer III, Lead Developer, Intranet & Data Services – Centocor eBIF, Centocor SPP/CAP, Cephalon MD Locator, Cephalon eEnrollment, Berlex Nursing Tool, Janssen Reimbursement Roadmap, Johnson & Johnson Access To Wellness, Pfizer Bridge, Pfizer Sales & Marketing Reporting Portal, Enterprise Provider Portal, Configuration Tool, Patient Plus, Messaging, Benefit Reverification, Salesforce CRM

Participated in agile development teams – defined stories and tasks, estimated work hours, and tracked progress using Scrum methodology.

Developed and implemented client solutions using programming language expertise.

Managed and mentored programmers – directed daily activities of developers and performed code review and feedback.

Participated in requirements gathering to provide technical solutions that would meet user needs and enhance productivity.

Documented software development methodologies in technical manuals to be used by IT personnel in future projects.

Lead code walkthroughs for System Architects, IT management, and development teams.

Participated in unit testing to validate business rules with PM/BA team.

Collaborated with multidisciplinary teams to design, implement, and maintain technology features.

Performed build and release management.

Performed troubleshooting and support for production systems.

Triaged defect/enhancement requests and assigned to developers.

Created proof of concept for innovative new systems.

Built and maintained database tables and stored procedures for web applications.

Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.

Coordinated deployments of new software, feature updates and fixes.

Implemented New Relic monitoring for legacy clients.

Improved stored procedure efficiencies boosting performance by 70%.

Skills: MVC, Kendo UI, JSON, Bootstrap, C#, WCF Services, VB, ASP.NET 2.0, ASP.NET 4.0, Classic ASP, AJAX, QJuery, JSON, Silverlight, Visual Studio, Right Fax, ZipFind, Tallcomponents – PDFRasterizer/PDFKit, Infragistics, Team Foundation Server, Star Team, Active Directory, ADO.Net, VB Script, Javascript, SQL, MS-SQL Server, CSS, HTML, DHTML, Microsoft IIS, Visual Interdev 6.0, Scrum – Agile Development, New Relic, Salesforce

Pfizer, New London, CT 4/2005 – 12/2005

Team Lead, Intranet Application Consultant – TABS

TABS is one of Pfizer’s core systems enabling the Therapeutic Area Strategy Alignment Team process. TABS is a global web based application that facilitates the linkage of product concepts to Pfizer’s internal pipeline.

Completed data feeds from Discovery and Compass systems into the TABS database, automating a timely manual process.

Managed programmer to ensure proper completion of change requests from clients.

Worked closely with clients and project manager to define requirements.

Responsible for all database changes including addition of tables, table fields, database constraints, views, and functions.

Created Entity Relational Diagram.

Developed, debugged, and deployed all code versions.

Created system ISLC documentation including design, requirements, architecture, and traceability matrix documents.

Worked with testing team to ensure proper system testing and generation of user acceptance test scripts.

Migrated TABS modules from ASP to ASP.Net using Microsoft Visual Studio .NET. Migration included implementation of server controls, code behind forms, and use of classes for globally used code.

Skills: ASP.NET, Microsoft Visual Studio .NET 2003, Visual SourceSafe, ADO.Net, ASP, ERWIN, Microsoft Access, VB Script,Visual Basic 6.0, Javascript, SQL, MS-SQL Server 2000, CSS, SQL Navigator, TOAD, HTML, DHTML, Microsoft IIS, Visual Interdev 6.0

NEOS, Manchester, CT 1/2005 – 4/2005

Senior Developer – Oracle Forms to Java Conversion Proof of Concept

Worked with team of programmers to provide Oracle Corporation with proof of concept for automating the conversion of an Oracle Forms application to J2EE.

Generated and developed a J2EE/JSP/Struts thin client and Java Swing thick client based on XML metadata from the Oracle Forms application.

Worked closely with developers of the NEOS Vgo Java code-generation engine to identify opportunities for automation of the conversion process.

Provided knowledge transfer for JSP, client-side scripting, and HTML for members of the development team.

Coded J2EE/JSP/Struts as well as Java Swing.

Skills: JSP, J2EE, Java Swing, Struts, Javascript, Eclipse, Ant, Javascript, JDK 1.2, Oracle 8.0, Vgo

Pfizer, Groton, CT 4/2004 – 3/2005

Intranet Application Consultant – Global Comparative Agent Database (GCAD), Clinical Image Forecast Tracking System (PTRAC)

Clinical Supply Forecast application uses, as an input, clinical study forecast information gathered from clinical project teams to build a list projected clinical studies and related clinical supply campaigns. The system allows users to input study information on the protocol level and link drug product manufacturing and packaging information to these jobs. The system has a set of stored procedures that are run on a per protocol basis that calculate the cost of manufacturing and packaging cost for the supplies produced for a given protocol.

Comparison of new chemical entities to currently approved drug therapies in a manner that hides the identity of the drug therapies from both the patient and the physician administering the therapy is a fundamental step in drug product assessment. To blind the identity of the approved drug, it is necessary to develop a blinding method that does not impact the performance of the approved drug. Development of the blinding method is both time consuming and expensive so it is not an activity that should be repeated unnecessarily. The Global Comparative Agent Database (GCAD) was developed to store information on about qualified comparative agent blinding methods and make that information available to Pfizer sites throughout the world. Additionally, GCAD has functionality, which allows Pfizer clinician’s to submit requests for development of comparative agent blinding methods.

Coded Library, Comparative Agent Request, Security, and Reporting modules for the GCAD applications using Microsoft Visual Studio .NET, ADO.Net, ASP.NET, Javascript, HTML, DHTML, and PL/SQL. Coded Protocol, Job Security, Reporting, and Administration modules for the PTRAC application using ASP Javascript, DHTML, HTML, and PL/SQL. Migrated PTRAC to ASP.Net framework using Microsoft Visual Studio .NET. ASP.NET versions of applications included web forms, code behind forms, use of server controls such as labels, datagrid, and drop down lists, and organization of globally used code into public classes.

Created GCAD/PTRAC databases in Oracle, which included table, referential integrity, sequence, stored procedure, package, error handling, function, and trigger creation. Used UTL_SMTP to add email capability to the applications.

PTRAC - Performed Microsoft Access to Oracle data migration. Rewrote Microsoft Access code used to compute forecasted costs for protocol, job, job components, job packaging, tooling, and job product using PL/SQL. Complex algorithms were organized into PL/SQL packages containing constants declarations, stored procedures, and functions. Debugged and tested all PL/SQL. Interfaced with management/users to define business requirements. Participated in user review and user acceptance testing meetings.

Developed, debugged, and deployed all applications.

Created system documentation. Worked with documentation/testing team to ensure documents met ISLC standards and test scripts were accurate. Performed system testing based on scripts generated.

Reverse Engineered Oracle databases using Erwin to create Entity Relational Diagrams.

Skills: ASP.NET, ADO.NET, Microsoft.Net Framework 1.1, ASP, ERWIN, Microsoft Access, VB Script, Javascript, SQL, Oracle 9.i, PL/SQL, CSS, SQL Navigator, HTML, DHTML, Microsoft IIS, Visual Interdev 6.0, Adobe Photoshop

Pfizer, New London, CT 9/2002-4/2004

Intranet Application Consultant – Discovery Decision Support Environment (DDSE)

DDSE is a high profile, globally used product built to support the management of Discovery’s Project Portfolio and to facilitate the implementation of the stage gate framework.

Coded security module of DDSE based on the ability of users to be granted roles and thus obtain the functionality within those roles. Implemented security throughout the application by ascertaining user’s roles and looking to see if accessed functionality was permitted via the role. This included coding of the user setup module – where users could be created, deleted, and have their personal information and roles updated. An additional module implemented via XML and ASP allowed the setting of functionality for various roles.

Coded special functions area of DDSE, which allowed specific users the ability to perform Yearly POP (Project Operating Plan) cycle activities on a bulk scale. Functionality included the ability to by work type and document type - release documents from the workspace to the public area, assemble released documents, edit documents, print them, and file them to Livelink.

Worked on administration area of DDSE whose modules included database table maintenance, help document maintenance and upload functionality, as well as Livelink document maintenance.

Coded project creation notice (PCN) which included a specific approval hierarchy – project creation, submittal/unsubmittal for approval, project approval/unapproval, and rollback to master.

Created PILS (project termination document) and Guidelines Checklist, which were integrated into ePOP documentation.

Coded the Quarterly Tracking module, which allows scientists to track project quasar, series, and lead compound information.

Coded various reporting and search functionality in DDSE. Coded export functionality to Microsoft Word and Excel, for reports and information obtained via search performance.

Designed application icons and graphics as needed.

Used ADSI for NT Authentication in various areas such as user login and user setup.

Responsible for system documentation regarding all modules worked on.

Managed testing efforts and testing team to allow creation of proper test scripts, system bug resolution, and bug assignment.

Participated in database design sessions. Created and maintained Oracle tables, views, triggers, and sequences.

Involved with production support and efforts to maintain data integrity.

Interfaced with upper level management to ensure proper understanding of the system and made suggestions for future development.

Coded Java classes, which interfaced with the Livelink API (LAPI) to give application users the ability to view project related documents stored in Livelink, as well as administer files and folders. Functionality included: upload/delete files, creation of project folder with necessary permissions within appropriate hierarchy, moving of project folders based on project status, and renaming of project folders.

Generated Java classes for database objects and created Java code to test performance of these objects.

Created COM objects using object oriented development principles to act as business layer on middle tier using VB 6.0 in effort to begin the porting of code base to Java.

Created XML for Tree Navigation Structure which was utilized by a Java Applet. Validated XML against DTD.

Installed and configured .NET framework and researched the possibility of porting of DDSE to ASP.Net. Implemented DDSE functionality in ASP.Net in order to gauge effort levels.

Skills: ASP, ASP.Net, Livelink, VB 6.0, VB Script, Javascript, Visual Basic 6.0, Java: SDK 1.4.2, XML, XMLSpy, HTML, DHTML, SQL, Oracle 8.1, CSS, SQL Navigator, OJB, Microsoft IIS, Visual Interdev 6.0, Visual Studio .Net, Visual Source Safe, OLEChart, TXTextControl, MS-Office 2K, ADSI, Adobe Photoshop

Astroved.com, White Plains, NY 3/2002 – 9/2002

Project Manager – www.Astroved.com

Directed the design, architecture, and implementation for a 3 tiered web site. Automated back end processes for database maintenance. Implemented utilities for sales tracking.

Involved with purchasing of production servers and hardware. Installed and configured operating system, IIS, and additional software.

Implemented bug tracking system and methods for utilization.

Wrote all supporting materials and design specifications.

Mentored and managed the administrative and programming staff in the US and India.

Enabled Astroved to create a base of regular paying clients and was involved in the creation of new resources to further growth.

Skills: Microsoft Office Suite, Visio

Universal Music Group, New York, NY 10/2001-3/2002

Intranet Application Developer – Product Solicitation System

Coded approval, solicitation, solicitation history, order, depot, forms, maintenance, and reports modules for product delivery system using ASP, DHTML and Javascript.

Created SQL Server stored procedures.

Participated in discovery sessions regarding application and database design.

Trained developers in order for them to maintain the system.

Skills: ASP, VB Script, Javascript, HTML, DHTML, SQL, SQL Server, CSS, Microsoft IIS, Visual Interdev 6.0

McKinsey & Company, New York, NY 4/2001-9/2001

Intranet Application Developer

Coded the Knowledge Object Summary Page utilizing ASP, which was used to present the profile of a knowledge object, as well as provide options to order, download, or view the object. Used Microsoft XML 3.0 and XMLDOM methods and properties to parse, process and provide information from XML located on various server locations.

Coded the Research Tools page utilizing JSP. This page was used to present research tools either in alphabetical order or by category view and expansion of a category.

Used XTAGS to process the XML directly in JSP.

Implemented DHTML to hide and show various layers – depending on user selected Knowledge Object order specifications.

Created Plumtree remote gadgets which included the Knowledge Object Summary Pages and Research Tools gadget. Set user preferences and used Plumtree API to obtain user settings from the portal.

Converted existing ASP pages to JSP to comply with new company standards.

Created all feature specific documentation.

Skills: ASP,JSP, VB Script, XTAGS, XML, Javascript, HTML, DHTML, Plumtree Corporate Portal, ADO, SQL, Oracle 8.0, CSS, Microsoft IIS 5.0, Visual Interdev 6.0, Windows 2000

Intelliclaim, Norwalk, CT 10/2000-4/2001

Intranet Application Developer – Dictionary Configurator

Designed and coded a complex ASP/COM/Oracle based application, which allowed users to maintain an insurance claims processing dictionary. The Dictionary Configurator held data used by a rules application to process claims based on each client’s individual specifications. Modules included category, customer, edits, code, template, inheritance structure, and classification hierarchy. Some specific functionality included: import/export of data, file upload/download capability, ability to update/delete/restore multiple or individual records, user permission definition, record filtration, code search mechanism, error handling…

Utilized ADO paging and cachesize properties, as well as user defined filter options, to improve database performance on very large recordsets which contain thousands of results.

Coded and maintained Visual Basic classes, which were implemented using a 3 tier architecture.

Utilized the Joust Outliner to provide an outline navigational system for a classification hierarchy. Coded the outline to allow improved performance via dynamic menu loading and provided a structure for user based menu hierarchy definition.

Implemented site navigation using DHTML based drop down menus.

Maintained and coded Oracle stored procedures.

Responsible for all system documentation.

Skills: ASP, VB Script, Visual Basic 6.0 – COM, Javascript, HTML, DHTML, SQL, PL/SQL, Oracle 8.05, CSS, Microsoft IIS, Visual Interdev 6.0, Joust, Installshield Professional 6.0, 3 Tier Architecture

LEGO Direct, NY, NY 9/2000 –10/2000

Internet Application Developer – http://shop.lego.com/gateway.asp

Participated in a team effort to improve performance of ASP/COM based internet site, which resulted in an increase in efficiency from 3 page hits per second to 600 page hits per second.

Responsible for implementing site navigation using drop down cascading menus.

Implemented German version of web site using XML.

Skills: ASP, VB Script, Visual Basic 6.0 – COM, XML, Javascript, HTML, DHTML, SQL, LDAP, CSS, Microsoft IIS, Visual Interdev 6.0, MTS, 3 Tier Architecture

Philip Morris Management Corporation, NY, NY 5/2000 – 9/2000

Project Manager / Intranet Application Developer

Managed vendors associated with Worldwide Records & Information Management Intranet initiative. Met with users for systems requirements, prepared all documentation, and kept the project on track.

Prepared Request For Proposal documentation for Legal Intranet Site.

Researched products for web initiatives and made recommendations to upper level management.

Created MS-SQLServer database for dynamic application

Coded dynamic Intranet document management system using ASP. This application allowed users to search for, preview, and administer legal notice documentation stored on the web in PDF format.

Skills: ASP, VB Script, HTML, SQL, MS-SQLServer 7.0, Microsoft IIS, Visual Interdev 6.0, File-Up

Tigris Microsystems, NY, NY 4/2000 – 5/2000

Internet Application Developer - www.scholastic.com/ecatalog

Responsible for testing and coding dynamic Internet site using ASP, which enabled users to buy Scholastic products via the Internet. Modules worked on included order-check out, review order, logon, and order receipt.

Created MS-SQLServer stored procedures and tables. Stored procedures enabled sending of email to customers via SQLServer.

Coded and maintained Visual Basic classes, which were implemented using a 3 tier architecture.

Skills: ASP, VB Script, Visual Basic 6.0 – COM, HTML, SQL, MS-SQLServer 7.0, CSS, Microsoft IIS, Visual Interdev 6.0, MTS, 3 Tier Architecture

Bates Worldwide, NY, NY 1/2000 – 4/2000

Internet Application Developer

Added complex functionality to survey building sections of Internet based authoring tool using ASP. Specific functionality included the ability to create codes for survey answers, the ability to create column names for flat tables generated in SQLServer so users could understand statistical results better, and the addition of new question types such as a go to and jump question.

Responsible for redesign of site interface using ASP/HTML.

Created MS-SQLServer stored procedures and tables.

Skills: ASP, VB Script, HTML, Javascript, SQL, MS-SQLServer 7.0, Microsoft IIS, Visual Interdev 6.0

PFIZER, NY, NY 10/1998 – 5/2000

Intranet Application Developer

Projects - CRO Report Cards / Investigator Profile Report / Patient Tracking System / PPG Intranet Site

Design, coded, and thoroughly tested dynamic ASP applications to enable users to view reports and/or maintain application related information via the Intranet.

Specific functionality which was derived using ASP included; coding an elaborate search mechanism for retrieving report information; creation of user reports; provision of validation rules to monitor for correct user input; design of extremely user-friendly interfaces and an on-line help system; creation of user administration interfaces.

Maintained and enhanced existing departmental Intranet site. Converted from a static to a dynamic site using ASP. Designed and developed backend and all components of user interface.

Evaluate and tested third-party software and developed an in-house prototype using ASP for on-line computer-based testing system, which tests employees’ knowledge of policies and procedures.

Worked on Visual Basic 6.0 DLL which enabled users to email data upload results.

Used VBA to generate ASP code which populated a Microsoft Word template with data derived from a SQL recordset.

Skills: ASP, VB Script, Visual Basic 6.0, VBA – Microsoft Word, Javascript, Microsoft IIS, HTML, Oracle, Microsoft Access, CSS, SQL, Adobe Photoshop, Visual Interdev 6.0

Omnicom Group, NY, NY 6/1998 – 7/1999

Lead Application Developer, DBA

Coded and tested new marketing database for pharmaceutical industry client.

Performed Oracle 8.0 Installation on Windows NT.

Created Oracle databases, distributing logical objects using the Optimal Flexible Architecture.

Assessed system for use of replication to load summary tables.

Performed daily data loads via SQL*Loader. Created all parameter and control files.

Configured Net8 manually.

Performed daily logical and physical backups of the database.

Cleaned and migrated data to new database architecture.

Extensive user and vendor contacts to insure requirement compliance. Performed initial data analysis for upper level management.

Coded very complex procedures to accommodate data analytics capability and to insure data integrity of conversion from prior system and external data inputs.

Skills: Oracle 8.0, PL/SQL, SQL*Plus, SQL*Loader, DBArtisan, Erwin, Windows NT

TIAA-CREF, NY, NY 12/1997 – 9/1998

Intranet Implementation – Project Lead, Project Coordinator, Management Consultant

Coordinated project between users, consultants, upper-level management, and project management.

Responsible for initial site proposals and prototypes, site theme and flow, page design, layout, and graphics.

Established coding standards, HTML templates, and implemented quality control.

Administered testing on platforms utilized and ensured the validity of all site links.

Maintained and designed several Lotus Notes databases, to be utilized via the intranet.

Evaluated and recommended software.

Skills: MS FrontPage 98, Lotus Notes 4.6, HTML, Javascript, AS/400 Web Server, Adobe Photoshop, Visio

Texaco, Fishkill, NY 6/1997 – 12/1997

Database Administrator, Programmer/Analyst

Created maintenance modules in VB, which allowed users in specific roles to add, edit, or delete records.

Created Oracle packages, tables, and views and granted access to these objects.

Maintained database triggers, stored procedures, functions, and packages and retained users in their roles.

Improved the physical appearance, organization, and functionality of all forms, which were worked on.

Thoroughly tested all code for performance and bugs.

Improved performance by reducing unnecessary hits on the database and eliminating needless code.

Enhanced database design in order to meet new specifications and improve existing design.

Wrote PL/SQL migration scripts to update newly created tables with information.

Skills: Visual Basic 4.0, Oracle, Oracle Objects For OLE, PL/SQL, SQL*Plus, True Grid Pro, SQL Studio, Unix, Zebra Programming Language II, Visual SourceSafe, Crystal Reports 5.0

Additional Client History 2/1994 – 12/1997

City Of Yonkers, Yonkers, NY - VB Programmer/Analyst

Womex, Norwalk, CT – Oracle DBA, VB Intranet Application Developer

March Of Dimes, White Plain, NY – Lead Programmer MS Access Developer

Educational Testing Services, Princeton, NJ – Oracle Developer

Weisleder Tele-Communications, Manasquan, NJ – VB/MS Access Developer

PVSC, Newark, NJ – BA, Datamodeler, Powerbuilder Developer

Synapse, Inc., NY, NY – MS Access Developer

EDUCATION:

COLUMBIA UNIVERSITY, New York, NY

CTA Program - Completed coursework in Oracle and Systems Analysis, GPA: 3.8.

COMPUTER LEARNING CENTER, Philadelphia, PA

DIPLOMA PROGRAM FOR COMPUTER PROGRAMMING, 11/1993, GPA: 4.0.

BOSTON UNIVERSITY, Boston, MA

M.S. in Nutrition, Spring 1990, GPA: 3.65

UNIVERSITY OF PENNSYLVANIA, Philadelphia, PA

B.A. in Psychology, Spring 1986

Contact this candidate