software development front-end, n-tier, OO

Technical skills

• Extensive experience: MS-SQL Server, SQL, Oracle, PL/SQL, DB2, iSeries Navigator, Database Migrations, PowerBuilder/PFC, OO/N-Tier application development, Visual Basic, MS-Access, MS-Excel,VBA, GnuPG
• Strong familiarity with: MS- SQL Server stored procedures, triggers, scripts, MS-SQL Reporting Services SSRS , Oracle SQL Developer, Eclipse, SoftTree-24x7, Linux, ad-hoc reporting, Database design normalization
• Familiarity with: Java, Javascript, XML, jboss, Hibernate, Visual Interdev, ASP

Professional skills

• Strong ability to handle multiple tasks and prioritize effectively
• Clear and effective communication with technical and non-technical groups
• Strong cooperation with business units on design and implementation tasks
• Strong initiative, follow-through to project/task completion and documentation

Work experience

• Employment gap
• Taking on-line Java training University of Illinois Urbana , and self-studying for a Microsoft certification for MS-SQL Server 2012 Database development.
• PowerBuilder Consultant

Contract position with publisher of medical staff credentialing software.

Responsibilities:

• Modified databases to add functionality to front-end application.
• Backed-up and restored/recreated production databases for training and testing purposes.
• Added auditing capabilities to data modification processes on both front-end and database.
• Researched and recommended future purchases of software development tools.
• Researched and tested transparent interfaces through Web-Services.
• Tested upcoming new release.
• Logged, tested and fixed defects.
• Reason for leaving: Contract expired.

Applications Developer

Confidential

• This company makes software products for the management of hospitals' high-acuity areas operating rooms, emergency rooms, post-anesthesia recovery rooms . Products included OR Manager, Credentials Manager, Bed Manager, Print Manager, Auto-Sync, as part of a comprehensive Hospital High-acuity areas management systems.
• Programming support role.
• Responsible for resolving functionality issues on end-user production databases and front-end application.
• Modifications of data on end-user production databases to recover from user errors, through scripts and stored-procedures.
• Modifications to MS-SQL Server stored-procedures and scripts to perform custom tasks on end-users production servers.
• Finding defects in code, recommending specific code fixes.
• Testing live scenarios and functionality issues reported by clients
• Recreating and resolving issues remotely, on client's own test and live environments both MS-SQL Server databases and PowerBuilder front-end .
• Resolving functionality service-requests involving surgery bookings, outcome and case reporting and charges, supplies and inventory tracking, and re-ordering.
• Implemented and followed HIPAA policies in all communications with both clients and colleagues.
• Reason for leaving: Company-wide layoffs.

Programmer

Confidential

• Contract position with the Elections division, managing census and elections data and preparing data and ballots for upcoming elections.
• Programming/development role.
• Responsible for enhancements and maintenance of Census and Voter Registry Oracle database and PowerBuilder front-end.
• Modified and optimized database reporting process to reduce execution time from 3-4 days to 9 hours.
• Responsible for creation of ad-hoc PL/SQL based reports and data-extracts, often with time-critical demands.
• Resolution of reported malfunctions and data-entry errors.
• Addition of enhancements to PowerBuilder front end bug fixes, new report functionality, new input screens .
• Re-creation of an existing application from the ground up.
• Responsible for research, analysis, and resolution of field-reported software and process-related issues.
• Created data management and reporting applications from end-user tools MS-Access, Excel running against Database servers Oracle 9/10 .
• Reason for leaving: Contract expired.

Senior programmer

Confidential

• The Confidential network, which includes GSM R, is an originator, guarantor, and service-agency for higher education loans.
• Programming/development role.
• Assumed DBA responsibilities MS-SQL Server 2005, DB2 Universal, iSeries Navigator to perform data changes, data-structure modifications, and database management tasks.
• Performed critical after-hours database tasks data and structure changes , coordinating with a variety of teams and individual principals.
• Developed database processes procedures, triggers etc to add audit and history functionality to production database, both DB2 and MS-SQL Server 2005.
• Performed upgrade of production database from MS-SQL Server 7 to MS-SQL Server 2005, including administrative scripts, user privileges and security settings.
• Performed backup/restore tasks on production MS-SQL Server 2005 database.
• Created automated reports based on management and business-unit requests MS-SQL Server 2005 and SSRS
• Performed frequent data-format transformations for debugging and troubleshooting
• Created data management and reporting applications from end-user tools MS-Access, Excel running against Database servers MS-SQL , using MS-Access/Excel VBA programming capabilities.
• Maintained and enhanced several critical enterprise applications processing student-loan information PowerBuilder, making extensive use of the PFC
• Actively participated in development team working to produce a marketable WEB-based product, requiring expertise in newer languages and tools Eclipse, Java, Javascript, jboss, Hibernate .
• Worked closely with business analysts in several business units within the network, to define requirements and specifications for software products.
• Implemented functionality to meet industry-wide compliance requirements set by the National Council of Higher Education Loan Programs NCHELP .
• Implemented encryption functionality using third-party components GnuPG .
• Created automated task management and auditing systems using third-party components SofTree 24x7 .
• Provided after-hours support for critical manual and automated nightly processes.
• Provided configuration support and testing requirements for Quality Assurance staff.
• Assisted release-engineering teams with deployment/promotion of new releases.
• Assumed complete support responsibility for deployed, business-critical applications in production environments.
• Created detailed, clear, concise documentation for technical and non-technical staff operations, QA, end-users .
• Reason for leaving: Company-wide layoffs.

Senior consultant

Confidential

• This organization is a major consulting firm in the IT services industry
• Client/server application Development MS-SQL Server, PowerBuilder . Primary developer responsible for maintenance, enhancement, packaging and deployment of a mission-critical, enterprise Client-Server application to over 40 branches across the U.S.
• Performed database migrations from MS-SQL Server to Oracle, using PL/SQL stored procedures as well as SQL Server ETL and PowerBuilder capabilities. Provided analysis, requirements and coding, created data dictionaries, data-integrity checks, and migration procedures.
• Created Excel-based macro-automated reports from database back-ends.
• Provided technical analysis and review, design specifications, risk assessment and mitigation, coding, defect tracking and resolution throughout system-test and user-acceptance-test phases, and additional project administration assistance.
• Functioned as technical contact for the business unit.
• Web-based, 3-Tiered Application Development Visual Basic, Visual Interdev, ASP . Created a new, internal, web-based enterprise application for a user community well in the thousands.
• Provided management and financial analysts with ad-hoc reporting solutions MS-SQL Server, MS-Access, Excel, using VBA programming capabilities .
• Functioned as technical contact to corporate business units as well as outside vendors.
• Reason for leaving: Company-wide layoffs.

Technical support engineer

Confidential

• Technical support role
• Developer hotline technical support for the PowerBuilder development environment, with an emphasis on database-related expertise, mostly with MS-Sql Server and Oracle.
• Provided research and resolution of critical, show stopper development issues to developers and DBAs.
• Worked in a team environment, interacting with product development and database expert groups.
• Created and delivered technical presentations and tutorials to colleagues.
• Provided support with configuration tasks for the team's technical test lab.
• Mentored colleagues.
• Participated in the quality assurance cycle of the product over several releases.
• Contributed technical articles to the Sybase web-based Knowledge-base.
• Developer/DBA hotline technical support for the Sybase Adaptive Server Enterprise database platform.
• Provided research and resolution of critical DBMS issues, mostly to DBAs requiring assistance with administration and development issues on this platform.
• Interacted with database experts development/programming group for the research and mitigation of defects.
• Reason for leaving: Pursued a development position opportunity at Keane, Inc.

Technical support engineer

Confidential

• A division of this company was under contract with Microsoft, to provide hotline technical support for the MS-Office Suite.
• Hotline technical support role
• End-user hotline technical support for the MS-Access application development tool.
• Provided research, mitigation and resolution of development and database issues for developers/users.
• Collaborated closely with Microsoft escalation teams.
• Created and delivered technical presentations and training classes to colleagues and new hires.
• Mentored and assisted colleagues with escalated technical issues on a high-volume, time-critical, internal hotline.
• Contributed technical articles to the Microsoft web-based Knowledge-base.
• Reason for leaving: Opportunity at PowerSoft.

Technical support representative

Confidential

• End-user support on a high-volume hotline, for electronic-imaging software and hardware, as well as for photographic products.
• Assisted with the creation of the company's first electronic Bulletin Board System BBS .
• Reason for leaving: Contract expired, pursued opportunity at Corporate Software.

Technical support representative

Confidential

• End-user technical support, for a business-graphics software vendor.
• Participated in quality assurance efforts for new releases, resolving compatibility issues with a wide array of graphic input and output devices.
• Managed the entire release process.
• Reason for leaving: Company-wide layoffs.