DMITRI ALEXEEV

** ********* ***, 908-***-**** adii8y@r.postjobfree.com

East Brunswick, NJ 08816 www.linkedin.com/in/dmitrialexeev

PROFESSIONAL SUMMARY:

Software Specialist in business and software analysis, database modeling, design and development, object-oriented application design and development through the full SDLC.

TECHNICAL SUMMARY:

RDBMS, NoSQL

ORACLE 7.x-12c, MS SQL Server, SYBASE, DB2, MongoDB

DB/ETL Tools

PL/SQL Developer, Quest Toad, ERWin, SAP Power Designer, DB Artisan, Informatica

IDE and Libraries

PowerBuilder v.3-12.6; 2019, PFC, MS Visual Studio .NET, Angular, Tableau, Business Objects, Crystal Reports, IBM Rational RAD/RSA 7, Eclipse

O/S

MS Windows, UNIX, Linux, DEC VAX/VMS

Servers

IBM WebSphere, Apache, Sybase EAS

Languages

SQL, PL/SQL, TSQL, Powerscript, C#, Pro*C, Python, JAVA, JavaScript, HTML, CSS, XML, JSON, VBA, Perl, Shell Scripts

Other

Serena PVCS, ClearCase, CVS, CMS, Enterprise Scheduler, MS Visio, SVN, ServiceNow

PROJECT EXPERIENCE:

NECA, Whippany, NJ

Sr. Software Developer / Analyst

2019 - Present

-For the NECA(National Exchange Carrier Association) Settlements application designed and developed modifications to the Data Entry, Reporting and Models modules according to FCC requirements and Business Users specifications, provided maintenance support for the whole cycle of Settlements system processing.

-Developed modifications to underlying Oracle Database Objects, packages and triggers. Converted Pro*C data loading and calculation scripts to Oracle PL-SQL.

-Provided SQL and PL-SQL Modules optimization, System Testing and creation of Functional specifications, User documentation and Test cases for UAT.

-Participate in ongoing moving of data entry and reporting Settlements functionality to Settlements-Web .Net/C# platform.

Environment: Oracle 12c, Oracle SQL Developer 4.2, MS Visual Studio 2017, MS SQL Server 2017, PowerBuilder12.6 - 2019, Crystal Reports, MS Windows 10, Linux

Mizuho Bank, Jersey City, NJ

Sr. Software Developer / Analyst

2017 - 2019

-Responsible for the development and maintenance of the ACBS (Advanced Commercial Banking System), ETL scripts for data transfers to downstream systems (GL, Treasury, Payments, Risk Management) and reporting Data Warehouse, development of ad-hoc reports and support of Loan Administration Unit business users, vendor development coordination.

-Provided support of the PowerBuilder reporting application and rewriting reports to bank’s Web/ BusinessObjects platform.

Environment: FIS ACBS 6.7, LANSA, Oracle 11g - 12c, Toad 12, PowerBuilder v.12.5, PFC, SAP BusinessObjects 4.2, Pro*C, Perl, IBM Aix 7.1, IBM i7.1 DB2,MS Windows 7, SVN, Tidal Enterprise Scheduler

ARGO Group, Jersey City, NJ

Sr. Software Engineer

2013 - 2017

-Responsible for enhancements and support of in-house developed MARS and Inspire systems for Property Catastrophe Reinsurance and XS Casualty and Professional Insurance divisions of ARGO Group, supporting US and International risk analysts, actuaries and underwriters. Functionality supported includes business workflows, pricing, portfolio management, exposure management, risk analysis as well as accounting, claims and financial reporting. Supported integration and automation of process using Property Catastrophe Modeling tools RMS (Risklink DLM) and AIR (Clasic).

-Responsibilities include ad-hoc reporting and data analysis, investigation and problem solving of critical issues affecting risk data, functional specifications, development and testing of modifications of Oracle schema objects, PL/SQL packages, triggers, MS SQL Server tables and procedures, front-end applications and MI dashboard reports, technical supervision of applications’ off-shore development teams.

Environment: Oracle-11g, MS SQL Server 2008-2014, PL/SQL Developer, PowerBuilder v.12.1, PB .Net, PFC, Tableau 10, Serena PVCS, Windows 7, Linux

Standard & Poor’s, NYC, NY

Sr. Software Engineer

2010 - 2013

-Provided SF Surveillance System modifications and business support for the S&P Structured Finance department. Responsibilities include ad-hoc reporting and data loads to Core, Surveillance and Reporting Data Warehouse databases, modifications to Oracle schema, PL/SQL packages and front-end SFSS CMBS PowerBuilder application, as well as ABS off-shore team development coordination.

Environment: Oracle-11g, Quest Toad, Erwin DataModeler, PowerBuilder v.11.5, PFC, Informatica PowerCenter, Business Objects, Crystal Reports, CVS, Windows XP, HP/Unix

Mizuho Corporate Bank/IBJ, NYC, NY

Sr. Programmer/Analyst

2001 – 2009

-Designed, developed and supported Global Customer Maintenance and Reporting system (GCust) for the Credit Risk Management and Portfolio Management Groups. Designed and created Oracle GCust database and reporting data-mart schema objects, PL/SQL packages and front-end modules for Customer Inquiry and Maintenance, X-Ref Search, Certification (Patriot Act, FRB), OFAC Lookup modules, Oracle data loading interfaces to Home Office ACBS system, external ratings (KMV, Moody’s, etc.) and MicroEdge Gifts databases.

-Designed and developed Credit Derivative Support System (CDSS) for the front office registration and middle office mark-to-market valuation and scenario simulation of CDS, First-to-Default, CDX credit derivative deals. For CDSS created Oracle Tables, PL/SQL packages and Perl scripts for re-formatting, x-referencing and loading of the pricing data (GFI, Markit, Bloomberg). Set-up, configured and supported Quantz CDS, Mizuho FtD and CDX Java based calculation services.

-Developed and supported Security Access System (SAS) providing Oracle role-based application access control and user/application/role management, reporting and database synchronization for Security Administration group.

-Produced on-demand reports and data extracts for System support, Legal and Compliance and Security Administration groups. Supported and monitored nightly End-of-Day and End-of-Month processing, internal database synchronization and external (pricing, rating, etc.) data loading.

Environment: Oracle 8i-10g, Quest Toad, Erwin, Sybase PowerDesigner, PowerBuilder v.7-11.2, PFC, IBM RAD 7/WebSphere, Apache HTTP Server 1.3, Apple WebObjects v 5.2, MS.Net 05/08, Object Cycle, Serena, CMS, Enterprise Scheduler, Windows 2000, XP, Red Hat Linux ES/WS, DEC VAX/ VMS

Schering-Plough, Cranford, NJ

Sr. Programmer/Analyst

2000 – 2001

-Designed and implemented extensions to Sample Suspense (SSA) and Inventory Reconciliation Report (IRR) applications based on the user requirements and new FDA rules and guidelines for the Product Samples Accountability.

-For SSA and IRR modified Oracle and DB2 tables, PL/SQL stored procedures and packages, performed application and database performance tuning and optimization according to the user requests.

Environment: Oracle 8i, DB2, MS SQL Server, Quest Toad, PowerBuilder 6.5, PFC

Standard & Poor’s, NYC, NY

Sr. Programmer/Analyst

2000

-For the S&P Public Finance Rating unit participated in the design and development of the School Performance System Analytical Toolkit application (SPS). Responsible for the design and implementation of Raw/Analytical Data, Exceptions, S&P Conclusion, School District Write Ups application modules and associated Oracle Tables, PL/SQL Triggers and Stored Procedures, Java based Data Loader.

Environment: Oracle 8i, Quest SQL Navigator, PowerBuilder 6.5, PFC, Chart FX, IBM Visual Age

SIAC/NYSE, NYC, NY

Sr. Programmer/Analyst

1998 – 1999

-As the Lead Developer for NYSE Trading Floor Services area designed, developed and supported Technician, Billing and Trouble Desk modules for the work order management and inventory control system (FFA). Responsible for the user requirements collection, design and implementation of the FFA Application modules and Sybase database modifications, development of supporting T-SQL triggers and stored procedures, Unix scripts.

Environment: Sybase System 11.5, SQL Programmer, ERwin, DBArtisan, ClearCase, PowerBuilder 5.3-7.0, Visual C++ 1.5, Object Warehouse, Windows NT4, HP/Unix

ADDITIONAL PROJECT EXPERIENCE:

Industrial Bank of Japan, NYC, NY

Sr. Programmer/Analyst

1997

ENTEX Systems, Rye Brook, NY

Sr. Programmer/Analyst

1996 - 1997

Quest International, Mt. Olive, NJ

Programmer/Analyst

1994 - 1996

Center of Mechanical Engineering, Kharkov, Ukraine

Engineer/ Programmer

1990 - 1993

EDUCATION:

M.S. Degree: Applied Mathematics. Kharkov State Polytechnic University; Kharkov, Ukraine 1990

CERTIFICATIONS:

ITIL Foundation (2011 ed.) - 2015

Certified PowerBuilder Developer (Associate –1996, Professional –1997)

Contact this candidate