Developer Sql Server

SUMMARY

A skilled Development Consultant with *0 years of experience using a wide range of technical applications. An honest, “down to earth” professional that gravitates towards and enjoys troubleshooting, innovative thinking, and quality assurance. A hard worker and problem solver. A charismatic leader and team player.

Software: PeopleSoft 8.8, SQR, SQL, PeopleTools 8.9, MSSQL, HTML, MS Office Suite, STAT, PL/SQL, TOAD, ASP, Java Script, VB, VB Script, Crystal Reports, Lotus Notes, .Net, MS Developer, C#, Razor

Platform: Windows 95/98/ME/NT/2K/XP, UNIX, AIX, Oracle 9i, SQL Server 2000 - 2012, DB2

PROFESSIONAL EXPERIENCE

Diligent (formerly ICSA Software North America), Stratford, CT 2/2014 – 10/2017

ICSA Software International is a software company of ICSA: The Governance Institute. ICSA Software International have been providing governance solutions since the original Blueprint Company Secretary launched in 1986.

Product Developer

Responsible for designing, building, testing, and supporting Blueprint product and product based modules

Developer for Blueprint product. Responsibilities include using HTML, JavaScript, VB script, and a homegrown language, JPL (C++ based) in a classic ASP environment, to build new functionality into vanilla product builds.

Client services product developer that designs, builds, tests, and implements one-off solutions specific to client’s business needs. Solutions include new web pages, workflow, field setups, data manipulation scripts, data dumps, RTF editing for government forms, and generic reports.

Third level product support. This means supporting the help desk on difficult client issues.

Occasional local SQL Server and IIS support, including web site setup, database installing and archiving, and issue trouble shooting.

Learned C# in Razor environment in preparation of removing all JPL code from product pages

Winklevoss Technologies, Greenwich, CT 3/2008 – 1/2014

Winklevoss Technologies is dedicated to being the worldwide software standard for defined benefit pension plans, other post-employment benefit (OPEB) plans, foundations, and endowments.

Corporate Website and Web Product Lead, SQL Server DBA

Responsible for designing, building, testing, and supporting Microsoft based web environments

Lead Developer for Corporate Website: www.winklevoss.com. Updated company information (products, personnel, and history) using HTML and scripting language when necessary. Migrated from classic ASP site hosted at Network Solutions to a DotNetNuke site hosted on Microsoft’s Azure environment.

Lead Designer, Developer, and Implementation specialist for participant portal product ProAdmin Online: http://winklevoss.com/ProAdmin/Overview/ProAdmin-Online.aspx. Implementation lead for new clients using this software, including packaging software, database, and web meeting support for hands-on initial boot up and maintenance.

SQL Server DBA: Responsibilities included archiving, backing up and restoring databases, comparing object and data differences using Red Hat products. Environments ranged from 2000 to 2012.

Design, build, test one off solutions for clients in a consulting capacity which generally included new web pages and SQL Server objects, but also Word Mail Merge, PDF generation, and a VB based data loading tool.

Accenture Technology Solutions, Hartford, CT 1/2004 – 2/2008

Web and Reporting Applications Technical Architect 11/06 – 2/2008

Responsible for designing, building, testing, and supporting Project Management/Financial Management Tools

Build web pages for homegrown based Financial planning tool including ASP pages with server side VB Script and Java Script on SQL server 2000 database (administered tables, PL/SQL stored procedures, scheduler, and data transformation tools)

Support Mercury ITG: client use of demand, resource, time, and project management (workbench, templates, security, and workflow) including back end support of Oracle 9i (modifying tables, SQL views, PL/SQL functions and procedures) accessed by TOAD and PL/SQL developer

Design, build, test Project management oriented Crystal Reports (v.10) for PMO including stored variable manipulation and formula creation along with standard reporting tasks (layout, appearance, query creation, etc)

Design, build, test Lotus Notes forms, views, scripts, and agents on a homegrown contract management database

Accenture (cont.)

PeopleSoft 8.3 HRMS Transition Developer/2nd and 3rd level support 7/06 – 11/06

Transferred support of PeopleSoft HRMS module for a large consumer goods conglomerate’s outsourcing project

Documented all facets of PeopleSoft HRMS system including homegrown HR add-ons, UNIX system monitoring techniques, database refreshes, tax upgrades, and system topography.

Support all HR, Payroll, and Benefits problems until outsourcing group was operational by troubleshooting 2nd/3rd help calls using SQL queries and PeopleTools

Develop new solutions for external interfaces, online functional issues, and background systems processing using SQR and basic ftp shell scripts

PeopleSoft 8.8 HRMS and local Applications Developer/Performance Lead/Upgrade Script Tester 4/05 – 6/06

Responsible for Performance testing PeopleSoft HR and Financial systems for a State government project

Used PeopleSoft Trace, PeopleTools, and debugging techniques (metrics comparisons) to address poorly performing queries in online processes, SQRs, App Engines, or stored SQL for COBOL’s by reviewing Oracle 9i explain plans with one subordinate

Supported locally based apps that ensured departmental security for reports, proper interface file transfer and validation, and lockout of non payroll user ids during payroll runs using Visual Basic and Microsoft scripts

PeopleSoft 8.8 HRMS Implementation/Transition Developer 1/04 – 3/05

Responsible for building/modifying/testing of PeopleSoft objects and SQRs

Reviewed, developed, and tested Benefits Design requests using PeopleTools and SQR

Coordinated (Plan, Develop/Modify, Test) the PeopleSoft query effort of 6-person off-shore team

Provided on-site information link from client to developers for PeopleTools designs

Reviewed Technical Design Spec for large employee data reports in PL/SQL and SQL

Modified PeopleSoft delivered payroll SQRs and PeopleTools pages (bond, check print, and direct deposit)

Built new Payroll SQRs and PeopleTools pages (interfaces – parking, union dues, financial front end, etc.)

Built new HR SQRs and PeopleTools pages (rosters and directory outputs)

The Brink’s Company, Darien, CT 1/2002– 9/2003

Programmer Analyst, Information Technology

Responsible for designing, building and testing new PeopleSoft objects and SQRs for new business needs. Support the day to day operations of the PeopleSoft Financials systems for Brink’s CHQ.

AR Archiving – Contributed in designing archiving methodology. Designed, built and tested SQRs for Pending Items, Posted Items, Payment Items and Group Controls.

AP Archiving – Troubleshot delivered archiving process that wouldn’t work without advice data. Constructed a data load SQR that would populate the payment advice table from data derived from adjacent payment tables.

GL Archiving – Identified potential routes for a GL archiving process by plotting table structure and business rules used by the GL business process.

CSC, Norwich, CT 6/1997 – 12/2001

Programmer Analyst, Information Systems

Responsible for designing, building and testing new PeopleSoft objects and SQRs for Payroll/HR/Benefits/Pension system.

Designed, built and tested packages that would solve fit/gaps between legacy systems and PeopleSoft. Applied changes to PeopleSoft panels, records, fields and PeopleCode.

Worked on upgrading all GD business units from PeopleSoft v.6 to PeopleSoft v.7 and v.7 to v.7.5. Submitted compare reports on SQRs, App Engines and all PeopleSoft objects. Tested new versions of code and day to day functional business processing.

Engineered General Ledger Interface that summarized or listed payroll transactions for all processed payroll runs and fed legacy systems and external software.

Designed Accounts Payable Interface that would summarize payroll data and feed Platinum system.

Developed labor interface that would upload hourly payroll data to PeopleSoft payroll tables keeping track of local union rules, leave accrual, and work schedules.

EDUCATION/PROFESSIONAL TRAINING

WPI, Computer Science, BS, 1997, Worcester, MA

Contact this candidate