James Oliva
Old Bridge, NJ *****
**********@*****.***
Computer Skills:
Programming Skills: C#, C++, C, SSRS, Java, VB
Database: Microsoft SQL Server 2012/2016/2018, Oracle SQL
Tools / Custom Software: Microsoft Visual Studio 2019, Microsoft Visual Studio 2017, Microsoft Visual Studio 2012, Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 6.0, Team Foundation Server, SharePoint
Work Experience:
Conduent, Secaucus, NJ
Senior SQL Developer Sept 2020-Present
Created custom SQL stored Procedures that would take new client data and convert it into Conduent Batch Loaders.
Create complex stored procedures, indexes, tables, views, SQL joins and T-SQL code to implement business rules
Created SQL scripts to gather data from multiple tables.
Create and maintain C# scripts for SSIS packages using .NET
Created custom SSRS reports using Microsoft Visual Studio 2019
Designed and implemented SQL reports based on user requests.
Created Stored procedures to pull in new clients data and load them into Conduent's databases.
Updated and maintained SSIS package to import 278 Authorization files.
Verified Customer data.
Selman & Company, Cleveland, Ohio
SQL Developer April 2020-Sept 2020
Created custom SSRS reports using Microsoft Visual Studio 2019
Created SSIS package for exporting data.
Improved performance of SQL stored procedures.
Carepoint Medical, Jersey City, New Jersey April 2014-March 2020 SQL Developer
Create tabular and matrix reports, list & chart reports, parameterized reports, sub reports, Ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment
Plan, develop and maintain internal dashboards, reports and other interactive Business Intelligence tools using SQL Server Reporting Services (SSRS), Excel.
Oversaw and implemented the conversion of Persevia to SSRS.
Underwent Power BI training with Microsoft.
Created Reports with power BI.
Designed data warehouses for the importation of data.
Preformed ETL data imports, exports, and data modifications.
Oversaw and implemented the conversion of PowerHealth to SSRS.
Create complex stored procedures, indexes, tables, views, SQL joins and T-SQL code to implement business rules
Designed and implemented SQL reports based on user requests.
Created SSIS package that FTP data to other vendors.
Interface directly with the users to define mapping specifications based on data analysis
Designed and implemented Meditech NPR reports based on user requests.
Designed and implemented Meditech M-AT reports based on user requests.
Assist with data import process and data cleanup and data migration from various systems
Handled the weekly revenue reports, and streamlined the process for creating them.
Shadow Financial Systems, Piscataway, New Jersey Aug 2007-Dec 2013 Developer - Grey Team
Implemented technical specifications, in C# using Microsoft Visual Studio using Agile Methodology
Worked on several projects that used the .NET Framework 4.0.
In C# designed, and coded the static data screens for money markets and mutual funds. Along with the middle tier code and the database.
Converted C++ and VB code to C#
Designed and implemented test plans for new applications
Developed SQL scripts
Worked on several different interfaces with third parties, such as Omgeo, DTC, and Bloomberg
Developed a generic and dynamic Audit trail system that could be used for any data structure.
Created a account import that interfaced with Omgeo using XML files.
Did extensive maintenance on the Bloomberg Asset Import System, and parsing methods.
Wrote the code for a asset template system that allowed users to control which fields defaulted, and which fields were locked.
Wrote technical specifications based on client details
Using C# wrote the code that would take Bloomberg responses and match them to a certain product type based on a user defined set of rules.
Wrote code that allowed TBA trades to be given up automatically.
Developed a 'alert' system that would send automatic messages when user defined activity occurred.
Implemented code changes
Identified and fixed bugs
Provided customer support
Used SharePoint for documentation
Meditech, Westwood, Massachusetts Feb 2006-July 2007
Programmer - Analyst Lab Group
Implemented code changes
Identified and fixed bugs
Assisted in designing, coding and testing custom changes
Depository Trust and Clearing Corporation, New York City, New York May 2004-Aug 2004 Summer Intern - Communication Department May 2003-Aug 2003
Assisted in the installation and maintenance of computer network equipment
Monitored the network using Open View
Responsible for the comparison of nodes on two different reports
Assisted in the planning of new networks
Assisted in the analyzing of reports
Education:
Western New England University, Springfield, Massachusetts
Bachelor of Science in Computer Science May 2005
Concentration in Object Orientated Languages, C++, Java, C#, C