Jeff S

Senior SQL Dev/ C VBA .NET

Summary

Expertise as a Sql developer/computer programmer built upon a base of undergraduate training in Computer Science and Economics augmented by graduate training in Computer Science with a specialization in software.

Over 20 Years of software development life cycle experience in Software Design, Development and Implementation of SQL.

Extensive experience in writing SQL Queries, Stored procedures, Functions, Database Triggers.

Very strong in Stored Procedures.

Improve the performance of slow SQL queries by implementing proper Index.

Have worked with VBA in both Word and Excel and have created numerous Excel AddIns. I have also worked with Excel macros. My work with VBA has included processing an XML file as an ADODB recordset that was read to generically display a properly formatted spreadsheet with report headings and subtotals along with the field values from that recordset, and also provided the option to generate a generic Pivot Table.

Have participated in comprehensive in-house training courses in Visual Basic 6.0 as well as Visual Basic.Net and have developed numerous Visual Basic and Visual Basic.Net applications.

Graduate schooling included a course in Database Systems, in which I learned about relational databases, database design, database programming, and worked with SQL. I have used SQL (in DB2, in Access, and in SQL Server) interactively, embedded within RPG programs, in SQL stored procedures, triggers and functions, in Visual Basic 6, Visual Basic.Net and in Visual Basic for Applications (Word and Excel) programs.

TECHNICAL SKILLS:

Database Tools

SQL Server. s SQL, DB2, Access, Crystal Reports

Programming

Languages

Visual Basic 6.0, Visual Basic.Net, Visual Basic for Applications (Excel, Word)

C, C++

I have learned C and C++ in college and graduate school. If you would please review my LinkedIn profile, you can see the reference that the instructor who first introduced me to C and three other programming languages, Mr. John Heartfield, wrote: “My course was a challenging one where students needed to understand the principles and applications of four programming languages in one semester. In order to receive his excellent grade, Jeffrey had to demonstrate superior talent at programming and concentration. Any employer would be fortunate to have Jeffrey as a member of the team.”

In addition, in my position at F. Logic, I worked with C in the context of designing stored procedures.

Asp.Net, HTML, JavaScript

I have also participated in comprehensive in-house training courses in Asp.Net, HTML and JavaScript, and have worked with them in the context of CGI programming in a client/server environment.

Query Languages

SQL, QBE, Quel, ISBL

PROFESSIONAL SUMMARY:

Stark Software Solutions Apr ’14 to Present

Projects Include:

Client: Local 272 Welfare and Pension Funds, New York, NY These are two Taft-Hartley Funds for the Garage Employees Local Union No. 272, which is affiliated with International Brotherhood of Teamsters, AFL-CIO. The Welfare fund’s chief function is to administer the health coverage of the union members and their dependents.

Role: Senior SQL Developer/IT Consultant

Responsibilities:

Provide programming support, research and review system, service user requests following stroke and paralysis of organization’s sole programmer.

I "SAVED HER LIFE,” a coworker exclaims with (slight) exaggeration as I retrieve the phone number that she needs to provide to a member with whom she is speaking on the phone.

Write SQL queries to review data.

Modify member program to write to/update secondary member file simultaneously for new additions/changes. Create SQL insert and update statements to synchronize existing files.

Correct and enhance data on spreadsheet used to prepare Form 1095 for verification of members’ eligibility for health insurance using VBA and other methodologies, ensuring that over ten thousand members and their dependents received their forms in a timely manner well before the tax-filing deadline.

Code query to determine if members with no address had claims (they did).

Check if members shown as ineligible for coverage in new system being tested were shown as covered in the existing system (most were).

Create and document process to reprint checks if checks had been printed with wrong check numbers.

Create query to find members with more than $250,000 in claims during two time periods.

Work with user to help her figure out how to use process for printing Cobra letters, earning me a heartfelt "high-five" for simplifying her job.

Client: Kenneth Cole Productions, Secaucus, NJ

Kenneth Cole Productions, Inc. (NYSE: KCP) is an American fashion house founded in 1982 by Kenneth Cole. Its aim is to sell premium clothing like shoes, watches and handbags.

Role: Senior SQL Server Developer/Consultant for The Connors Group

Responsibilities:

Researched and reviewed alternatives for connectivity between an external MS SQL server and the Kenneth Cole IBM/i server.

Coded and tested SQL Stored Procedures to pass data between the systems.

Created database objects like tables using SQL.

Wrote SQL queries to verify changes and review data.

Loaded tables with data.

Added records, deleting records, and updating the databases in real time.

Employer: 3LOG Systems Inc., Forest Hills, NY Oct ’13 to Oct ‘13

Headquartered in greater Vancouver, British Columbia, Canada, 3LOG Systems is a software development firm specializing in the forestry industry. Its products support business activities for TIMO’s/REIT’s, pulp & paper mills, softwood and hardwood sawmills, OSB/plywood mills, pellet mills and biomass utilities. With implementations all across North America, its software solutions have become the industry standard. Companies from Washington to Florida, California to Maine and from British Columbia to Nova Scotia have made 3LOG products their systems of choice. Its software is used in companies that range from single mills to large, multi-divisional organizations.

Role: Principal Technical Consultant

Responsibilities:

Reviewed system to help get new branch office in the United States up and running. (System consists of frontend and MS SQL Server backend.)

Wrote SQL queries to review data.

Employer: Broadridge Financial Services, Jersey City, NJ Jan’12 to Mar‘12

Broadridge is the leading provider of investor communications and technology-driven solutions for wealth management, asset management and capital markets firms. It helps clients drive operational excellence to manage risk, accelerate growth and deliver real business value. Its technology-driven solutions power the entire investment lifecycle, enabling its clients to successfully manage the complexity and operational requirements of today’s capital markets. Broadridge is at the forefront of multi-channel communications, strengthening its clients’ capabilities to communicate with their clients and investors and meet regulatory requirements.

Role: Senior SQL Developer/Senior Consultant for enableIT LLC.

Responsibilities:

Received training in all aspects of operations including fixed income trading

Collaborated and assisted coworkers with projects.

Provided remedies for Fixed Income programs in production, including

Correcting bug preventing logging of error messages in production program.

Preventing incorrect client records from being retrieved during search by client name.

Wrote SQL queries to verify changes and review data.

Loaded tables with data.

Added records, deleted records, and updated the databases in real time.

Employer: Easter Unlimited, Inc., Carle Place, NY Oct’10 to Jun ‘11

Easter Unlimited, Inc. designs, manufactures, and markets toys for Halloween, Easter, Valentine's, St. Patrick’s Day, Christmas, and patriotic occasions.

Role: Senior SQL Developer/Computer Programmer

Responsibilities:

Developed and maintained programs for functions such as database maintenance, general ledger, Accounts Payable, and Accounts Receivable.

Serviced user requests.

Changed check printing to use overlay instead of pre-printed forms, eliciting a heartfelt thank you from the head of the Accounts Payable Department, whose job had been made that much easier and more efficient.

Generated Order Confirmation Emails.

Implemented Item Testing System.

Altered Credit Memo processing to use overlay rather than pre-printed forms and to email copies to salespersons, thus greatly simplifying the job of the person responsible for generating credit memos, and allowing the salespersons to check easily that the memos had been applied properly.

Coded Packing Slip generation for offline products.

Employer: F. Logic, Inc., New York, NY Feb’99 to Jan’09

F.Logic provides Fortune 1000 companies, as well as rapidly growing midsize companies and large organizations with browser-based contract management, rights and royalties management, and licensing management business software solutions. Its customers include recognized brands such as Brown-Forman, Hearst, Case Paper, King Features, NBC Universal, Focus Features, MTI and Scholastic.

Role: Senior SQL Developer/Computer Programmer.

Responsibilities:

Developed and maintained programs for functions such as database maintenance, general ledger, order entry, and report generation for clients in a variety of industries. Its customers include recognized brands such as Brown-Forman, Hearst, Case Paper, King Features, NBC Universal, Focus Features, Music Theatre International, Oxford University Press, and Scholastic.

Enhanced order entry system to aid marketing efforts by suggesting related items to customer.

Migrated legacy reports to a browser-based system that provided a more user-friendly method of entering report parameters and generated a generic Excel spreadsheet with report headings and user-controlled totals and/or subtotals, along with the field values from that recordset, and also provided the option to generate a generic Pivot Table.

Created Excel AddIns that provided enhanced user options not available in legacy versions, also simplified date selection and increased validity checking to give user immediate feedback concerning incorrect entries.

Participated in comprehensive in-house training courses in Asp.Net, HTML and JavaScript, and worked with them in the context of CGI programming in a client/server environment.

Implemented a credit card processing system for a publishing client.

Upgraded application to process international currencies, which involved changing SQL query to provide currency symbol.

Automated in-house invoicing process via the use of Word templates.

Created utility to edit, create, and test SQL stored procedures.

Created utility to generically generate source code for stored procedures and create objects.

Y2K Conversion implementation and testing.

Converted publishing client’s system from ISBN-10 to new ISBN-13 requirements.

Improved the performance of slow SQL dynamic query by creating a stored procedure: A VBA project had been executing a dynamic SQL statement that ran at least eight hours without completing. I told my manager that I thought the performance might be improved by creating a stored procedure to retrieve the data. My manager rejected that solution, saying that he didn’t want a stored procedure created. My manager was out sick one day, and told me to try to resolve the problem. After having attempted to trace the statement’s execution via the iSeries’ Operations Navigator without having gained any insight, I consulted with some of my coworkers and a superior and concluded that the statement was waiting indefinitely for sufficient resources to be run. I finally created a stored procedure. My assessment had been correct: The stored procedure completed within a minute or two, as opposed to the seemingly infinite loop of the dynamic SQL statement. When my manager returned the next day, he agreed that all future queries over large files should be created as stored procedures.

Created tables, indexes, Stored Procedures and functions in SQL.

Developed complex queries to retrieve data as per client requests based on certain parameters and restrictions.

Merged two or more files using union and union all.

Extensively worked with cursors.

Increased response time of the database by adding indexes.

Employer: Goldberg, Testa, and Co., Inc., Brooklyn, NY Apr’97 to Feb ‘99

Goldberg, Testa & Co, Inc. was founded in 1985, and is involved in creating custom software for a variety of clients.

Role: Computer Programmer.

Responsibilities:

Developed and maintained programs for functions such as database maintenance, general ledger, Accounts Payable, and Accounts Receivable.

Programmed extensively for banking client.

Coded in house and at client sites.

Trained and assisted junior programmer with debugging.

Responsible for all programming, problem resolution, and user support at a client site.

Implemented new Work Order system streamlining processing greatly.

Education

Queens College of the City University of New York

Degree: Master’s Degree in Computer Science – Specialization in Software

Degree: Bachelor’s Degree

Grade Point Average: 3.696 – graduated Cum Laude

Major: Computer Science

Minor: Economics--achieved lifetime status in Economics Honor Society

Minor included a course in Money & Banking. In that course, I earned an A+, along with a compliment from my professor that I had produced “consistently brilliant work.”

Honors & Awards

Governor’s Committee on Scholastic Achievement Citation for graduating in top 1% of Forest Hills High School’s class (6th out of a class of 691)

Achieved lifetime membership status in Omicron Delta Epsilon, the Economics Honor Society.

Regent’s College Scholarship winner

Dean’s List for 5 consecutive semesters

Provost’s letter for obtaining an average of at least 3.9 for 2 consecutive semesters—average was 4.000 for both semesters.

Eligible for and completed Honors Readings in Computer Science with grade of A-.

Eligible for and completed two semesters of Honors Calculus with grades of A- and B+.

Representative Programs Developed Include:

1. A C program that produces a basic graph for an arbitrary number of two-dimensional coordinates.

2. A Pascal program that simulates six Unix commands:

dd, df, ls, cd, mf, and md.

Contact this candidate