Klim Gofman

**** ****** **, ********* ** ***** 203-***-**** add9qr@r.postjobfree.com

Professional Summary

Result-oriented IT professional with a focus on design and implementation of enterprise software to maximize business productivity and enhance revenue and profitability. Lead and successfully completed large and complex projects in an Agile environment from concept to delivery. Demonstrated original, creative and cost effective approach in business systems design, maintenance and testing. Utilized latest industry knowledge and technology to achieve appropriate solutions. Built and trained highly productive and motivated teams.

Skills: C#, .NET, PowerBuilder, Python, MS SQL Server, T-SQL, Oracle, PostgreSQL, Sybase, DB2, Power BI, JIRA, TOAD, SVN, PL/SQL

Professional Experience

Sr. Developer/Analyst Planned Systems International / NYC DSS(HRA MIS), Brooklyn, NY Jan 2016 – May 2020

●Assigned as a senior developer/analyst for NYC Human Resources Administration (HRA) Management Information Systems (MIS) department;

●Participated in gathering business requirements and writing documentation for user review;

●Made deep analysis of business requirements to create technical specs for Paperless Office System (POS);

●Created documentation and consulted migration process of emigration (Alien) section in POS to web platform;

●Consistently drove process improvement through the development of new strategies;

●Coordinated tasks and work closely with business site and developers;

●Responsible for leading testing efforts, ensuring that issues are identified, tracked, reported on, and resolved in a timely manner;

●Created new screens for POS using PowerBuilder and C# (web services) on front end and Oracle on back-end;

●Developed stored procedures, triggers and tables. Tuned database programs;

●Successfully analyzed existing Help Desk tickets in JIRA and Service Now and propose technical solutions for production application problems and bugs;

Notable Projects include:

●Con Edison project: to establish data communication between POS and utility provider using web services;

●Address normalization services: to maintain standard USPS addresses across POS using web services;

●Client Services Screen: allows to collect and display special arrangements for clients using XML file processing;

●Set Fair Hearing Update Screen: allows to collect and process over different systems Fair Hearing data;

●Alien Registration numbers update in POS: sets new rules for Alien numbers in emigration section;

Lead Software Developer IMEX Global Solutions LLC – Newark, NJ Apr 2013 – Jan 2016

Lead Software Developer IMEX / Pitney Bowes, Inc – Newark, NJ Jan 2011 – Apr 2013 Consultant IMEX / Roney Technology – West Orange, NJ Jan 2010 – Jan 2011

Consultant IMEX / Robert Half Technology – Paramus, NJ Oct 2008 – Dec 2009

●Lead developer/analyst for IMEX. Worked on new projects and maintained existing enterprise applications written in ASP.NET and PowerBuilder;

●Lead, managed and coordinated IT projects from planning to deployment stage;

●Managed, guided and trained team of developers in US and offshore team;

●Implemented strategic approach to support Agile principles for assigned projects;

●Determined milestone deliverables, communicated with all parties involved in the projects, analyzed impact of changes on existing business process, coordinated project schedule with dependent groups;

●Analyzed existing enterprise software and proposed technical solutions/modifications for using it in a global market;

●Administered and supported Sybase and MS SQL servers as DBA on a daily basis;

●Developed new database objects like stored procedures, triggers, events and tables to support business logic;

●Created Translation module to automate mail processing and translation from Chinese and Japanese to Roman characters, which was required by USPS. Project was done in .NET web service(C#) and PowerBuilder;

●Started migration of client-server enterprise system to the Web using Visual Studio (VB.NET) and Sybase;

●Developed a new financial part of the IMEXOps to define and maintain value added tax(VAT) for other countries using PowerBuilder and Sybase Anywhere;

●Created functional specs based on business requirement;

●Provided every day production maintenance and support for clients in the US and UK.

Notable Projects include:

●IMEX Ops UK project: The existing US enterprise business application was adapted to work for the new European market.

●E-Packet project: First in the industry adopted a new USPS product. The goal was to bring a new shipping service from USPS to our customers. Project was done in PowerBuilder and MS SQL Server.

●USPS Customs Forms project: The goal was to automate all processes to move parcels through US Customs. Project was done using PowerBuilder, .NET web services and Sybase. The project completely eliminates the need of manual paperwork.

Sr. Programmer / Analyst The Bank of New York / Mellon – New York, NY Feb 2001 – July 2008

●Lead developer/analyst in UIT (Unit Investment Trusts) business managing a multi-billion dollar investment portfolio. Responsible for strategic front-end development, testing, implementation and production support using PowerBuilder, Visual Studio.NET, DB2, and MS SQL Server. Played a key role in every stage of SDLC.

●Managed, mentored and trained team of developers in the US and offshore team.

●Proposed and implemented original architecture, math algorithms, and solutions for high-profile UIT projects like Expenses, Corporate Actions, and QDI, etc. designed in PowerBuilder and DB2.

●Developed and introduced to life, development and production approaches using PowerBuilder and DB2 that became standard for many years in UIT for the Data Warehouse front-end system. Brought Data Warehouse application from pilot project to reliable solid enterprise business system, of which as a result, the number of transactions have increased tenfold.

●Proposed and developed in PowerBuilder and DB2 automatic utilities to identify potential UIT system and database problems before business day starts. It helped dramatically reduce interruptions in the business process.

●Started and led .NET(C#) development to bring the IRIS business application from Chase to UIT.

●Supervised daily activities in production support for all critical front-end applications and data.

●Introduced and developed application online help documentation for users built with Robohelp.

Notable Projects include:

●QDI (Qualified Dividend Income) project: The application calculates qualified dividends for securities in all portfolios by end-of-year according to latest IRS requirements. As a result, time for manual data processing was reduced from weeks to several hours while accuracy of the data became close to 100%. Designed in PowerBuilder with PFC; heavy business processing was done in stored procedures on DB2.

●Corporate Actions project: Allows setting up and processing corporate actions for each security on-line or in batch, enables future scheduling and more. The new process completely replaced manual multi-user approach to one user and reduced process time from hours to seconds. Project was designed in PowerBuilder with PFC and DB2.

●DSC (Deferred Sales Charge) project: Allows configuring, calculating and maintaining DSC for all funds on the UIT system. This helped completely eliminate tons of paper work and time that users used to spend in DSC calculations. Project was designed in PowerBuilder with PFC and DB2.

●Expenses project: Allows entering data from front-end to mainframe FACTS system; process up to 20 rates and fees for any fund. Calculates totals on a daily basis during scheduled night batch. Due to its simplicity and neat design the process became the most important in UIT. It saved hours of users’ time on a daily basis. Project was designed in PowerBuilder with PFC and MS Access.

●Wisdom Tree ® ETF (Exchange Traded Funds) project: Allows processing data from external investment firm according to business rules, updating UIT data and producing a new external file on a daily basis. The project automated data mining, validation and population and saved hours of work every day on the business site. Project was designed in PowerBuilder with PFC and DB2.

Education / Training

●M.E., Electrical Engineering / Computer Science – Kazan State Technical University, Kazan, Russia

(Formerly A. N. Tupolev Technical University)

●Advanced C# Programming – SAM Consulting Services, NY

●Python Programming Course – online

●C# MVC/ VB.NET – Hands On Technology Transfer, Inc

●PostgreSQL for developers – online

●MS SQL Server DBA – DBA University, Inc.

Language Skills

Proficient in writing / speaking Russian

Citizenship: United States

Contact this candidate