ALEXANDER

MOSHKOVICH

** ******* **. **** ****, NY 11729

+1-646-***-**** ac12yk@r.postjobfree.com

SUMMARY

Experienced IT Professional specializing in database administration, data analysis, effective reporting, technical support and CRM technologies

SKILLS

Technical

Tools and Languages: MSSQL Server(2000, 2005 2008, 2008R2, 2012), T-SQL, Crystal Reports, MySQL Server, Oracle, DreamWeaver, HTML, CSS, JavaScript, Adobe Photoshop, Adobe ImageReady, Microsoft Access, C++, C, Java, Assembler, Visual Basic

Productivity and Collaboration: Sage Saleslogix, Microsoft SharePoint, Adobe Professional, Microsoft Visio, Microsoft Office

Platforms: Microsoft Windows 95/98/2000/ME/XP/Vista/7

Communication

Excellent written and verbal skills

Effectively conveyed technical concepts and project requirements to various levels of the organization

Proven ability to distill complicated data into simple and meaningful management reports

Web Design: Created numerous efficient and aesthetically pleasing websites for various projects

Interpersonal: Established on-going relationships with coworkers, attorneys and vendors across multiple continents

Analytical: Evaluated requirements and proposed fitting solutions

Training: Trained and tutored more than 80 people in Saleslogix, web design, and C++

Bilingual: Fluent in Russian

PROFESSIONAL EXPERIENCE

Astoria Bank September 2016- Current

Mortgage Systems Analyst/Reports Developer Lake Success, NY

Responsible for the creation, design, implementation and enhancement of more than 200 financial, statistical and analytical reports and forms using Crystal Reporting tools

Maintained mortgage loans in NETOXYGEN

Responsible for the daily morning routine, which includes:

Gallagher Security Validation

Checking the daily master file and daily delinquency report

Upload the daily CPI Data File to powerseller

Run the Residential Portfolio Payoffs report

Check failed objects in Central Management Console

Make sure there are no duplicate loans in NETOXYGEN

Scheduled, maintained, and uploaded daily, weekly, monthly, and quarterly reports in Central Management Console

Rebranded all of the reports and documents for the upcoming merger

Tested the Development, Staging, UAT, DR and Production servers every month after the new patches are installed

Complete and close out tickets and work requests in the GMB-Mortgage Systems mailbox in Outlook and the FIS Helpdesk System

MISONIX March 2014- March 2016

Reports Developer/IT Support Farmingdale, NY

Responsible for the creation, design, implementation and enhancement of more than 200 financial, statistical and analytical reports and forms using Crystal Reporting tools

Developed FDA compatible Quality Assurance forms

Created sales dashboards in IQMS

Maintained the IQMS ERP System

Created over 200 user fields and forms in IQMS

Responsible for technical support

Maintained the ORACLE database consisting of over 200 tables, 100 commands and 100 views

Managed multiple concurrent projects for every department

Nature Publishing Group November 2011-April 2013

Reports Developer New York, NY

Responsible for the creation, design, implementation and enhancement of more than 200 financial and statistical reports using Crystal Reporting tools and MySQL/MSSQL database engines

Developed strong expertise in producing accurate and timely reports consisting of data from over 10 distinct databases.

Ensured consistent client satisfaction through the creation and scheduling of automated report distribution in client-tailored formats

Utilized Scrum methodology to streamline development

Collaborated with more than 40 colleagues in the United States, England, India, and Japan

Created a SQL commands library for Crystal Reports

Managed multiple concurrent projects and workload using the JIRA issue tracking software

Utilized THINK software to ensure data consistency and integrity

Greater New York Hospital Association May 2008 – June 2011

CRM/Database Administrator New York, NY

Responsible for database support, troubleshooting, enhancement and migration

Monitored database size and disk space in Development, Staging and Production environments

Performed installations of SQL Server 2000, SQL Server 2005 and Sage Saleslogix

Created and scheduled database and log backups and restores

Created monitoring scripts to alert for production issues

Responsible for design, implementation and administration of SAGE Saleslogix, company’s CRM tool, which stores 20,000+ Accounts (Hospitals, Suppliers, Consulting groups, etc), 40,000+ Contacts, 100,000+ Opportunities, Activities, Reports, and various other items

Maintained separate Development and Production environments

Resolved infrastructure and client issues

Expanded functionality by adding custom tables and fields to the SQL database backend

Developed and maintained over 500 Crystal Reports and ad-hoc SQL reports used by more than 150 users, from administrative staff to C-level executives. Major improvements include:

Reduction in time to get to meaningful data from 8 hours to less than one minute

Reduction in user errors by removing the need for manually compiling reports

Advanced data analysis by combining numerous sources into a single report with conditional logic

Enhanced usability and quality by only showing meaningful data in simplified and aesthetic format

Enhanced Saleslogix’s functionality by developing and maintaining over 100 custom forms using Visual Basic. Selected functionality includes:

Automated data entry and validation by allowing users to upload thousands of Opportunities at one time, reducing user error and greatly improving efficiency

Integration with company Intranet, allowing one-click email and fax blasts to Senate and Legislature custom contact groups

Custom integration of various Microsoft Outlook items into Saleslogix

One-click mail merges and address label creation using Saleslogix and Microsoft Word

Involved in weekly meetings with Saleslogix stakeholders to address issues and gather requirements for new features

Trained over 70 people on Saleslogix

New York City Law Department June 2006 – April 2008

Intern/Contractor (IT Department) New York, NY

Responsible for design and implementation of several projects. These include:

Weekly Newsletter - HTML-based newsletter (DreamWeaver, CSS, and Adobe Professional Suite) received by over 3000 employees

Bi-Weekly Project Planner – Created Excel-based and Visio-based charts for various projects and meetings

MAC Reports – Query-based (Microsoft Access, Crystal Reports) reporting system that generates PDF documents that are sent to upper management

Use collaboration software (SharePoint) to establish document workflow for a 10 person team

Use Adobe Photoshop to convert personnel photos in a recent ID-card migration

Brooklyn College September 2003 – December 2008

Student Brooklyn, NY

Course Website

Responsible for design, implementation, and support of faculty course website (DreamWeaver)

Completely overhauled previous implementation making it more efficient and user-friendly

Data-mining Project

Used Microsoft Access to create a data-mining platform applicable in restaurant marketing

Multiplayer Games

Created an action game using C++. Allowed two players to play against one another using two different sides of the same keyboard

Used C++ GUI library to create a “rolling dice” game. Implemented game logic to allow for realistic playing conditions

EDUCATION

Brooklyn College (Brooklyn, NY) December 2008

Degree: BS in Computer and Information Science

Certificate: SQL Database Developer and Administrator

Contact this candidate