ALEX LITMAN Home: 732-***-****

** ********** ***** ****: 732-***-****

East Brunswick, NJ 08816 E-mail: acy1l3@r.postjobfree.com

SUMMARY

Experienced Programmer with extensive experience in and comprehensive knowledge of all aspects of the MS SQL Server, including ETL, and complete life-cycle development.

I possess strong hands-on experience in engineering, tuning and problem solving. I gained comprehensive knowledge and practical experience of MS SQL SSIS and SSRS, performance tuning, MS SQL monitoring, tracking and maintenance. I have strong Analytics and problem-solving skills. My knowledge of database development, Reporting (SSRS, Tableau, COGNOS, Crystal Reports) in combination with object-oriented programming, client-server and MVC technology, visual libraries and Internet systems distinguish me from other candidates. Being excellent team player, self-driver, detail-oriented, accurate, and quick learner, I would be a perfect addition to a team of IT professionals.

TECHNICAL SKILLS

OS: Windows 7/8/10, SunSolaris

Languages: T-SQL, Visual Basic, Java, C, HTML, VBScript, JavaScript, JQuery, ColdFusion, PHP, XML, XSL, VBA, PL/SQL, ASP.NET, AJAX

Databases: MS SQL Server 2008/2012, Access, Sybase System 11.x /12.5, FoxPro, Oracle 10g/11.2, MySQL

Network: Ethernet, TCP/IP

Tools: SSIS, SSRS, Crystal Reports 9.0/10.0, Cognos, Tableau 9.3, SourceSafe, Win 32 API, ODBC, MAPI, MS Outlook, Erwin, MS Visual Interdev, EDI, COM/DCOM, ADO, RDO, DAO, LaserFiche, HomeSite 5, QuickBooks, SAGE, ULTIPRO, CSS

PROFESSIONAL EXPERIENCE

SENIOR SOFTWARE DEVELOPER 02/2010 to present

Platinum HR Management Brooklyn, NY

Provided expertise in the design, implementation and support of highly available databases, supporting Platinum Service Interface. Responsible for collecting, organizing, analyzing, and distributing data. Handled performance tuning and troubleshooting of stored procedures. Performed unit testing, debugging and problem solving of highly demanding stored procedures, and business objects. Organized MS SQL Server Monitoring managed locking, created notifications. Applying ETL, created set of SSIS packages to distribute input data between the servers and environments. Responsible for design, creation and distribution of Database objects. Created and monitored MS SQL Jobs and maintenance processes. Created an extensive set of Reports, using SSRS, Tableau, and WEB tools. Designed, developed and implemented Automated Quick Books and SAGE Feeds. Created set of Reports for Finance and Payroll departments.

Created Management Dashboard using Tableau. Interpret business requirements into fully-functional, robust, highly-accessible solutions.

Successfully created and deployed different feeds for the external clients, including encoding and FTP Secure transfer. Used MS SQL SSIS, C#, .NET, ColdFusion, jQuery, JavaScript

Completely designed, coded, tested, and implemented: Payroll Audit Application, Employee Eligibility System, Applicant Tracking System, ACH and Payroll Manual File Tool, EEO-1 Feed/Report, internal Time Keeping System. Used MS SQL, C#, .NET, ColdFusion, jQuery, JavaScript, HTML

Designed, developed and implemented WEB Tools for HR, Financial and Payroll departments: Facility Lookup, Checks Lookup, Direct Deposit Lookup, Tax Liability, Client Service System. Used MS SQL, C#, .NET, ColdFusion, jQuery, JavaScript, HTML

Granted constant support and necessary maintenance of databases and all developed Tools and Applications. Used MS SQL Server, T-SQL, SSIS, VBScript

Provided online and personal Users training sessions.

Performed code review to insure code quality.

DEVELOPER 03/2005 to 01/2010

Volt Computer Science (Procurestaff Dev) New York, NY

Provided expertise in the design, implementation and support of highly available databases, supporting Enterprise Comprehensive Managed Services Program (MSP) for major clients. Created an extensive set of Reports, using Crystal Reports, Cognos, Excel, WEB tools. Participated in design and coding of the Executive desktop Module, used by top management as source of statistic data and Reporting tool. Handled performance tuning and troubleshooting of stored procedures. Performed unit testing, debugging and problem solving of highly demanding stored procedures, and business objects. Responsible for design, creation and distribution of business objects. Used ASP, ASP.NET, MS SQL, SSRS.

Designed, developed and implemented Automated Paperless Expenses Module. Created set of Reports for Expenses and Billing. Redesigned and implemented Login Security Module as per Sarbanes-Oxley requirements.

Developed and implemented Timekeeping/Invoicing Module. Designed, developed and implemented set of Reports for Time Cards, Work Record, Invoicing and Purchase Orders

Provided online and personal Users training sessions.

Converted Applications from IIS5 to IIS6 - SQL 2005 environment.

Participated in design, coding and implementation of Payrolling Module.

Successfully deployed the MSP model for human capital acquisition and management into the Japanese,Czech Republic and France markets.

Provided on-time support for Global Clients.

Designed, developed and implemented electronic Automated Paperless PO Improvement Module.

PROGRAMMER-ANALYST 10/2000 to 02/2005

NYK Logistics & Megacarrier (OCS) Secaucus, NJ

Provided expertise in the architecture, design, and implementation of highly available databases, supporting the Global Supply Chain Application. Handled performance tuning and troubleshooting of stored procedures. Performed unit testing, debugging and problem solving of stored procedure, reports, and business objects. Responsible for design, creation and distribution of business objects.

Created logical and physical database schema using normalization and de-normalization rules. Provided solutions for increasing performance of stored procedures. Used T-SQL on MS SQL 2000, Erwin.

Developed an extensive set of stored procedures and triggers in MS SQL Server to support front-end WEB based applications. Used T-SQL, MS SQL 2000.

Created set of comprehensive reports for the Global Supply Chain module. Used T-SQL, ASP, VB, Crystal Reports.

Created Export Service object to automate export from Crystal Reports to different applications. Used VB, COM.

Developed variant of Joust object to provide customers with convenient Shipment Tracking, BL Tracking and PO Inquiry. Used ASP, DHTML, JavaScript, VBScript.

Deployed on MS IIS server WEB based application for Managing General Agent Billing. Application worked in conjunction with MS SQL Server on Windows platform.

Responsible for transferring full-life cycle three-tear application based on FoxPro/VB documents to MS SQL Server 7.0/2000 – ASP, MS IT techniques. Used T-SQL, MS SQL 2000, FoxPro, VB.

Involved in all phases of application development of the multiphase project for creation of the EDI Transfer (EDI TS) system to automate translation of EDI files to a flat file, parsing and transferring raw data to a database, applicably implementing business rules and customer-specific actions to check and process data.

Completely created a User Management and Security System (UMSS). UMSS provides with abilities to manage on-line the highest level of security as well as manage, automate and optimize creation of user Menu, User Access and User Permissions.

PROGRAMMER-ANALYST 1/2000 to 5/2000

Chelsea Technologies Inc. New York, NY

Responsible for design, development, implementation and distribution of stored procedures, reports, business objects and components, desktop and WEB-based full life-cycle three-tear applications. The company provided different software applications and reusable components as per user requirements.

Using MS SQL Server 7.0 created relational database for the Statue of Liberty Project. Created set of stored procedures implementing business rules as well as tokenizing the tables for future using in Update part of Administration Application and Search Engine. Used T-SQL, MS SQL 7.0.

Developed a set of comprehensive customized reports, including sub-reports and graphs. Used Crystal Reports 8.0. 8.5.

Participated in design, analysis, implementation and distribution of multiple VB applications and components. Used Visual Basic 6.0, COM/DCOM technologies.

Created multiple ActiveX DLL Components: Spell Check Engine, Debugging Component, Crystal Reports Automation Component, ActiveX EXE Helper Component, Mailbox Component, which wrapped ASP Mail object.

Created set of Weekly Programming ASP Pages for PSN Corporation which represented weekly TV programming schedule and Search Engine. Used MS Interdev, ASP ADO/ODBC connection to MS SQL Server with HTML interface on Windows NT Server.

Participated in creation of the Search Engine for the Statue of Liberty Application and implemented the R & D module. Created Administration Application for managing the Kiosk Application. Used VB 6.0, ADO, ActiveX EXE and ActiveX DLL, COM/DCOM, T-SQL.

Created Explorer type full life-cycle VB Application for major Perfume Company.

Created Telephone Search Component, which wrapped MAPI object, connected to the MS Outlook Public Folders, Retrieved Clients Information and implemented Search for Client telephone number or telephone extension. Used MS Outlook, MAPI API’s, ASP.

Created Administration Application for managing the Kiosk Application. Used VB 6.0, ADO, ActiveX EXE and ActiveX DLL, COM/DCOM, T-SQL.

EDUCATION

Bachelor of Science: Computer Science and Applied Math 1982

UkrainianState ChemicalTechnology University, Dnipropetrovsk, Ukraine

CERTIFICATIONS & TRAINING

Microsoft Certified Professional in Visual Basic - 6 Microsoft Corp, NY

Visual Basic – 5, Visual Basic – 6 BrainBanch, NY

NYC and NYS Asbestos Inspector New York, NYNYC Lead Inspector New York, NY

Database Administration of MS SQL Server 2012 2014

COGNOS-10 2010

WebLogic Server and Programming of J2EE, EJB 2004

Java Enterprise Applications 2004

SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS, SSIS,

T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer

T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer

T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer

T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer

T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer

T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer

T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer T-SQL SSIS SSRS Developer

Contact this candidate