SQL Server, Oracle, Filemaker Pro 11, MS Access, Excel, Ssrs, Vba, SQL
Resume:
Denise M Atkinson
**** *** ***** ***** **** apt A1
Blackwood, NJ 08012
ac8a9v@r.postjobfree.com
DATABASE PROGRAMMER/ANALYST/REPORT WRITER
Software Development/Testing/Data Analysis/Database Programming/User Training/Web Programming
Diversified experience in coding, database development, report writing, developing ad-hoc applications and providing user training for several companies spanning several industries. I can create applications to automate and streamline processes in offices or factory floors. I can also put data into terms that managers or workers understand.
Custom Computer Specialists, Hauppauge, NY 2018-present
Software contractor providing data and IT services to an urban school system.
Database Programmer
● Volunteered to work on writing reports in absence of a full-time report writer to eliminate backlog.
● Created SSRS reports to organize data in a form that SDP officials could understand and act upon.
● Created, maintained, and debugged stored procedures to support SSRS reports.
Research Foundation, City University of New York, New York, NY 2016-2017
Research and evaluation arm of a large public university.
Database Analyst I
● Created function in PL/SQL that read survey data from any form created in Formstack and placed the results into Oracle database tables using dynamic SQL.
● Assisted in creation of web-based data collection software using Oracle APEX. Made changes to final product based on feedback from internal customers.
● Provided assistance with SQL techniques and trained personnel in the use of Oracle SQL and MS Access SQL.
● Worked on the Start By Asking text-messaging campaign (SBA).
Created database views, functions and functions.
Built a list of 81,000 students eligible for SNAP benefits using FAFSA data and CUNY student data.
Built a schedule using Oracle database tables and sent out targeted text messages to all students on the list based on the schedule.
Partnered with Single Stop USA personnel to share data between CUNY and Single Stop following CUNY guidelines.
Developed metrics to report progress and efficiency of messaging.
Created reports that were sent daily to management.
Broadridge Output Systems, Secaucus, NJ 2012-2016
Direct mailing firm specializing in the financial services industry.
Technical Support Specialist
● Helped build database-driven system allowing management to track individual work items on the factory floor.
● Maintained existing FileMaker Pro database which kept track of locations and statuses of all jobs in the facility. The system eventually tracked jobs at the rate of 1,200 per day.
Denise M Atkinson
1501 Old Black Horse Pike apt A1
Blackwood, NJ 08012
ac8a9v@r.postjobfree.com
Broadridge Output Systems, Secaucus, NJ (cont’d) 2012-2016
Direct mailing firm specializing in the financial services industry.
Technical Support Specialist (cont’d)
● Worked with key personnel in mailroom, print rooms, manual distribution area, and production control. Streamlined processes. Implemented changes to apps as business requirements changed.
● Created database-driven applications that simplified job tracking and record keeping.
● Built both canned and ad-hoc reports to interpret data for both management and workers.
Harvey Gerstman Associates, Garden City, NY 2004-2009
Manufacturer’s representative firm interacting with nationwide retail chains.
Programmer
● Built a web-based IVR system to track employee hours by phone from locations across the country.
● Consolidated company spreadsheets onto an Access database.
● Upgraded company database to SQL Server 2000 then to SQL Server 2005 as the company grew.
● Built web apps to convert timesheet data from MySQL, SQL Server, Excel, and Word into a single standard format for input to the main database.
● Built ad-hoc reports and flexible-format reports for management use.
Hendriks Institute, Westbury, NY 2002-2003
Instructor
● Taught logic programming principles, desktop programming, database programming, and general computer knowledge to students with no prior computer knowledge.
● Designed, developed, and taught Visual Basic.NET course to teach the .NET Framework and VB.NET programming skills to students with a basic knowledge of programming.
● Redesigned Basic Computer Knowledge courses so non-technical people could better underatand.
DynaLantic Corp, Deer Park, NY 1998-2001
Programmer
● Built the Instructor Operator Station (IOS) for the R42 subway simulator for NYC Transit.
Built the Instructor Operator Station (IOS) for the R34 subway simulator for NYC Transit.
Created database model of the #4 subway line in MS Access to relay simulator location and display it on the instructor’s screen.
Created a database in Microsoft Access to simulate oil spills for the Coast Guard.
EDUCATION:
Bachelor of Professional Services, Computer Science, Long Island University/C. W. Post, 1987
PROFESSIONAL DEVELOPMENT:
Top Gun Program, Chubb Institute, Parsippany, NJ, 1997
Desktop Programming, Hendriks Institute, Lindenhurst, NY, 2002
Contact this candidate