Post Job Free

Resume

Sign in

Sql Server Visual Basic

Location:
West Orange, NJ, 07052
Salary:
65,000+
Posted:
June 25, 2017

Contact this candidate

Resume:

Joseph Fishman

*** *** ***** ***** **. Apt.***,

West Orange, NJ 07052

Phone: 973-***-****

ac0z20@r.postjobfree.com

Summary Of

Qualifications: IT professional with extensive experience in financial and commercial data processing field.

Strong analytical, design and programming skills with solid mathematical background and resolute commitment

to teamwork. Excellent communication and people skills. Experienced in all phases of the project life cycle.

Skills: Platforms: Windows NT 4.0, Windows 95/98/2000/XP/Vista/7/8,

Languages: SQL, Microsoft Visual Basic 5.0/6.0, Visual Studio.NET, HTML, .ASP, XML, Custom. Delphi 7.0

MS Excel (VBA) 2000/2003/2007/2010, MS Access (VBA) 2000/2003/2007/2010/2013

Databases: Microsoft SQL Server 6.5/7.0/2000/2005/2008/2010/2012, MS Access 97/2000/2003/2007/2010/2013

Tools: DTS/SSIS Packages; SSRS - Microsoft SQL Server Reporting Services 2005/2008; Citrix Server,

Crystal Reports 8.0, 10.0; Concordance/Opticon, DocuLex, Summation, I-32 Forms Design tools

Applications: Microsoft Office products; Visio, Microsoft Project, Microsoft Excel, MAS90, QuickBooks.

Professional

Experience: BNF Partners Auto Group, White Plains, NY

IT Application/Technical Support (Sep 2016 – Apr 2017)

BNF is the fastest growing automotive retailer group in the New York Metro area. BNF are experts in one of the most challenging marketplaces in the country.

Responsible for setup, support and maintenance of user’s desktop applications on two sites in White Plains, NY.

Manipal Education Americas LLC, New York, NY

American University of Antigua School of Medicine

Lead Developer/Analyst (Feb 2015 – Oct 2015)

Responsible for maintaining the suite of applications for Financial Aid Department (Bursar)

Created ETL processes for generation of tuition Statements, Balances and Refunds

Developed Demographics package for reporting and data analysis using MS Access(VBA) and SQL Server 2008

Supported Student Management System database facilitating enhancements, data transformations & reporting.

Main software development tools include: SQL Server 2008, MS Access 2010(VBA) and MS Excel 2010(VBA).

Manu MediSoft Inc., Wayne, NJ

IT Application Developer/Analyst (Apr 2014 – Dec 2014)

Application development for Maquet Company (Client) that focuses on manufacturing various equipment for surgical workplaces, anesthesia systems, workstations for intensive care and cardiovascular devices.

Responsible for providing a comprehensive technology for client’s regulatory requirements to comply with FDA industry standards.

Re-designed and developed CERT (Complaint Event Reporting Tool) application allowing company to record, manage and investigate incoming complaints.

Enhanced PSSD (Product Surveillance and Support Dept.) application used to implement and document Maquet Complaint Quality System.

Main software development tools include: SQL Server 2008, MS Access 2010, 2013 and MS Excel 2010(VBA).

Weichert Financial Services, Morris Plains, NJ

IT Application Developer/Analyst (May 2012 – Apr 2014)

IT professional responsible for supporting company’s financing applications. Provided technology solutions to comply with evolutions of the industry standards and new regulatory requirements.

Main responsibilities include:

Design, development and implementation of enhancements to variety of applications for Lending

Processing Services, using customized Delphi language and SQL Server 2008.

To facilitate intense design need of the mortgage lending industry used I-32 Forms Automation to create complex forms with hundreds of data fields using unique identifiers.

Facilitated robust data analysis utilizing Crystal reports (BI)

Provide Documents management solutions including on-line search tools, dynamic data capture capabilities using SQL Server 2008 and various UI tools.

Automated nightly processing reports generation using Visual Basic 6.0 and SQL 2008.

Created functional & technical documentations, user guides.

Main software development tools include: SQL Server 2008, Customized Delphi 7.0, I-32 Forms Design,

Visual Basic 6.0, MS Access 2007, MS Excel 2007(VBA), Crystal Reports 9.0.

Deloitte Services LP, Westfield, NJ

IT Application Developer/SSRS Reports Developer (Jan 2008 – Dec 2011)

As a member of Integrated Solutions Delivery Team execute, deliver and support various IT initiatives/products, with a focus on client satisfaction and personal growth. Working closely with Deloitte international team in India to achieve common goals.

Responsible for design, development and implementation with focus on the reporting components using SQL Server; SSIS/SSRS reporting tool, MS Access, HTML and Active Server pages.

Key projects include:

IT Management reporting tool for Resource Allocation - firms’ Planning & Analysis tool – source for annual budgeting, year-around forecasting and analytical reporting tool. Used as a component for Compensation planning (SQL Server 2005, SSRS, Ad Hoc, SSIS, ASP, HTML(PHP))

Electronic Records Management System used for retention and management of electronic records pertaining to client service engagement (SQL Server 2005, SSRS, ASP)

DC Pricing Model - Document Library based application, designed specifically for Consulting Group to provide version control, centralized document library location, integrated security and access via internet (SQL Server 2005, SSRS, ASP)

Bankruptcy Billing project (SQL Server 2008, MS Excel 2010, SSIS/SSRS, ASP)

DCPS (Deloitte Consulting Processing System) - inventory application (SQL Server 2005, MS Access 2007)

Major enhancements and standardization of Document Collection Dbase application. The tool is used by the legal counselors nationwide (Citrix Server)

Barrasso Consulting LLC, Westfield, NJ (Acquired by Deloitte in Jan 2008)

Sr. Programmer/Analyst/Litigation Support Specialist (May 2003 – Jan 2008)

IT professional for the small litigation firm focusing on providing technology solutions for the business needs

Main responsibility include:

Gather, analyze and document business requirements; create functional and development specifications;

Database design, application development and implementation including jurisdiction components

Design user interface, reporting tools and supporting documentation

Database normalization and tuning; on-going maintenance

System installation and on/off site support;

Main software development tools include Visual Basic 6.0, VB. NET, SQL Server, Microsoft Access database and MS Access reporting tools, MS Excel 2007, Crystal Reports, Concordance Database, DocuLex, Summation and XML.

Key projects:

Document Collection Database application for keep track of Legal Documents collected by firms’ attorneys. The system is designed to facilitate the conversation with custodians, collect and store the data related the case.

(VB 6.0, MS Access Database, Concordance Database, MS Access reporting tools)

Human Resources Data Collection Application - used for collecting and reporting potential employee information. (VB 6.0, MS Access Database, MS Access reporting tools)

Eraptor application. Application is used for keep tracking of the workflow for review attorneys. (SQL Server 2005, VB.NET, ASP, Concordance software, DocuLex, Summation, Crystal Reports 9.0, XML)

Responsible for setup and support of Collection Team off-site users. Preparation and setup of team’s laptop; secure database access remotely; create supporting documentation and user guides

TeamStaff, Inc., Somerset, NJ.

Programmer/Analyst (Feb 1999 – May 2003)

Programmer/Analyst at the national headquarters of a billion dollar Personnel Employee Organization (PEO).

Main software development tools - Visual Basic 6.0, Microsoft SQL Server 2000, Microsoft Access database and MS Access reporting tools and Crystal Reports 8.0

Responsibility include:

Gather and analyze business requirements; create functional and development specifications;

Complete design and database implementation including application jurisdiction,

Application development, user acceptance testing management and implementation

Create reporting and data import/export tools

Provide system supporting documentation and user guides

Key projects:

Voucher Payment application for New York City Human Resources Administration and Administration for Children Services. The system allows Client Services department to generate checks for client’s distribution, facilitate client services and accounting. (SQL Server 2000, VB 6.0, Crystal Reports 8.0)

Call Tracking application for Client Services Department to monitor support calls from 700+ clients. (VB 6.0, MS Access Database, MS Access reporting tools)

Network monitoring system to track changes to internal financial applications.

Education: Polytechnical College, St. Petersburg, Russia

B.S. in Mechanical Engineering with minor in Computer Science

Professional classes: Designing and Implementing a SQL Server 2008 Database.

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services, MS Visual Studio

References available upon request



Contact this candidate