Sql Server Software Developer

New York, NY ***** 212-***-**** **********@*****.***

SUMMARY

A highly experienced software developer, database administrator and analyst with expertise in financial services. Managed numerous projects to create systems in support of retirement annuity, mutual fund and individual portfolio products. Managed system conversion from ADABAS to relational databases (SQL and ORACLE). Responsible for production support of mission critical applications, including net asset value calculations.

SKILLS

Data modeling and analysis to improve financial information flow and automate business processes.

Thorough knowledge of financial instrument processes to perform system integration.

Best practices of the full software development life cycle (SDLC).

Over 15 years of direct support for production systems in the financial services industry.

System scope definition and management, time and cost estimation, stakeholder communications and quality assurance processes.

Software compliance management.

Methodologies - Object Oriented Programming (OOP) and Object Oriented Analysis (OOA)

Mainframe Tools & languages - CICS, COBOL, NATURAL, JCL, TSO/SPF, MVS, Z OS, VM/CMS, Panvalet, Predict

Database Tools –ADABAS, ADASQL, ADAMINT, ADABAS Utilities, EntireX, VSAM, DB2, Oracle, PL/SQL, SQL Plus, Microsoft SQL Server, TSQL, SSIS, DTS, Access, DAO, ODBC, OLEDB, ADO, Informatica, Enterprise Manager, DBArtisan, SQL Navigator, Toad and Red Gate Suite

Design Tools & Languages - Visual Studio, C/C++, VB, ASP, IDL, VBScript, JavaScript, Perl, OLE, HTTP, FTP, XML, HTML, Crystal Reports, Active Reports, Actuate, SQL Reporting Services, Visual SourceSafe, StarTeam, and ANT.

Other - Eagle PACE/STAR, SunGard InvestOne (CUISpectra & Apollo), Trintech ReconNet, Gentran, Autosys, ABAT, CA Scheduler, 24x7 Scheduler, Internet Information Server (IIS), Terminal Services, Citrix, DoubleTake, IBM Mainframe, Mobius Reporting, VMWare, Virtual Server/PC, Microsoft Office Suite (Outlook, Word, Excel, Visio, PowerPoint, FrontPage, Project)

PROFESSIONAL EXPERIENCE

D LLC, NJ February 2014 – March 20017

Software Architect and System Administrator (Contractor)

E-Commerce Web site infrastructure design

Cloud based database and web server administrator

MS SQL Server database design, development and implementation

XML file processing, job scheduling

Department of BUILDINGS of NYC July 2013 – February 2014

Lead Developer (Contractor)

DOB Enterprise Licensing & Permitting Project(ETL)

Mainframe Developer (ADABAS/NATURAL, EntireX, JCL)

As a critical part of the integration team that responsible of loading data to new platform (ACCELA enterprise software)

Mapped ADABAS data to ACCELA, request new descriptors and superdescriptors to speed up downloads.

Developed & tested various batch programs to download data from ADABAS files to ACCELA.

Using Natural/EntireX broker developed and tested real time processes to upload Mainframe data to ACCELA and update ADABAS files using ACCELA data.

Developed new on-line functions (COBOL, CICS, and SQL) to map ACCELA to new department’s initiative.

Federal Emergency Management Agency (FEMA), Queens, NY Jan. 2013 – July 2013

IT Specialist (Temporary Employee)

Hurricane Sandy disaster recovery support

Computer and Network support,

Infrastructure setup (wireless network, switches and other peripherals)

Verizon, Rye Brook, NY March 2012 – Dec 2012

SQL Server Developer (contractor)

International Billing System, based on MS SQL Server and ABAT Job Management and Scheduling System

Developed, tested and implemented Local Route To Number VOIP system (LRN-VOIP).

Enhanced the LERG (Local Exchange Route Group) International Billing system. Created new Stored procedures, tables, views and triggers. Coded batch script files for ABAT scheduler.

Converted Excel Reports from ODBC to ADO in order to put reports into the network environment.

Deployed the LERG system to a new platform. Ran parallel tests on new and old environments. Fixed problems as they occurred and provided comparison reports.

Created functional specifications and implementation documentation.

First Commemorative Mint, Inc., Amityville, NY Jul 2009 – March 2012

Software Developer and Network Manager (Contractor)

Supported the entire computing environment of a 20 person small business, including servers, desktops and the physical network. SQL server DBA- Supported and enhanced the “Everest” application to provide the company with automated business management capabilities. It is based on SQL Server 2005. Created new functions to support inventory management, sales and accounting using SQL Server stored procedures and triggers on the server and C#/.NET on the client. Used Crystal reports to support the new functions.

Simplicity Co., New York, NY Mar 2009 – Sep 2009

IT Specialist (Contractor)

Desktop Rollout

Worked closely with in-house staff to identify appropriate hardware and software for 'the design' department. Integrated new systems into the existing domain and used Active Directory tools to enforce security p

TIAA-CREF, New York, NY 1994–2009

Asset Management Investments & Fund Accounting IT

Lead Developer

Mainframe systems (CICS, COBOL, ADABAS/ADASQL, NATURAL, Direct-Call, ADAMINT, JCL):

Retirement Annuity Funds - Leading member of a consulting team which created CAIMS (CREF Accounting and Investment Management System). Designed and developed the following modules:

Pricing, Corporate action, Holdings, Trades, History and Archiving, Statutory Reporting System.

Provided incremental improvements, production support and maintenance after project completion over 15 years.

Treasury - Project leader for the Treasury Commitment Mortgage and Real Estate application (cash flow projections).

Led a team of 3 developers for 6 months until project completion.

Provided incremental improvements, production support and maintenance for 10 years.

Mutual Funds - Adapted all CAIMS systems to MPAS (CREF Mutual fund system) and added new functions.

Supported mission-critical Net Asset Value (NAV) Calculation application for 5 years.

Provided incremental improvements, production support and maintenance for 10 years.

Euro and Y2k Conversion - Annuity and mutual fund systems.

Migration of data from ADABAS to ORACLE database (Data HUB) – Leading member of the team which convert investment accounting data from ADABAS to ORACLE.

Windows and web based systems (all applications were SOX compliant):

Multi-Vendor Pricing System (MVPS) - Managed all phases of this 10 person, $1 million project for 6 months. MVPS was the first internal web based application at TIAA-CREF. Data and functions were converted from ADABAS to SQL Server and ORACLE databases. MVPS provided an open platform to channel pricing data from any possible vendor to multiple internal departments. The team used a two-tier design approach. Business logic resided in SQL Server and Oracle stored procedures while the users were provided with an elegant web interface. Supervised and directed the work of other developers and designed normalized backend databases. Conducted detailed code reviews of Oracle and SQL Server stored procedures and ASP applications. Stressed ease of maintenance and standardization of coding techniques. Worked with users to define the scope of work and coordinated acceptance tests. Provided production support and maintenance for 7 years.

Unit and Net Asset Value Calculator and General End of Day applications - Led a team of 3 developers to create a mission critical application to verify and adjust data to close each business day.

Provided production support and maintenance for 5 years.

External Interface System - calculated and published mutual fund and tuition band values to external vendors (NASDAQ, BFDS) as well as various internal systems and the web. Applied client-server technology using Visual Basic, SQL Server and Crystal Reports.

Provided production support and maintenance for 5 years.

Eagle PACE data warehouse environment with Oracle ETL - member of a team that developed and maintained the system to support accounting operations. Created uploaders and exporters and performed various data steward tasks as well as reporting and scheduling.

CDO reconciliation - Designed and maintained data transfers using Informatica Power Center to feed vendor data (from Citibank, BNY-Mellon and JPMorgan-Chase) into Eagle/PACE (Oracle) by developing mappings, mapplets and workflows.

ADDITIONAL EXPERIENCE

TIAA-CREF, New York, NY

Sr. System Consultant

City of New York Department of Finance, New York, NY

Senior Programmer/Analyst and Adabas Database Administrator

ASCAP (American society of Composers, Authors and Publishers)

Programmer/Analyst

EDUCATION

Technological Institute of Odessa, Odessa, Ukraine

Bachelor and Master of Science, Mechanical Engineering

Professional Education – Oracle DBA, VB, Java, Computer Networking

CERTIFICATION

CompTIA A+

Contact this candidate