SUMMARY:

• Experienced Programmer with extensive experience in and comprehensive knowledge of all aspects of the MS SQL Server, .NET 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, C#, .NET, 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/2014/2016 , 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, SVN, 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 Developer

Confidential, Warren, NJ

• Created different reports to provide top management with highly visible sets of statistic and performance information. Used HTML, JavaScript. T-SQL.
• Developed an extensive set of stored procedures, functions, and triggers in MS SQL Server to support front-end WEB based applications. Used T-SQL, MS SQL
• Provided solutions to improve performance for the database objects in high demand, improved performance for some by 300%.
• Created and managed set of SQL Jobs.
• Provided support and customization for MSC Link and MSC OVA Applications as Global Systems.

SENIOR SOFTWARE Developer

Confidential, Brooklyn, NY

• Successfully created and deployed different feeds for the external clients, including encoding and FTP Secure transfer for ADP, Welsh Fargo, Citi Bank. Used MS SQL SSIS, C# (backend & front end), .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, SSRS
• 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 # (backend & front end), .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, .NET
• Provided online and personal Users training sessions.
• Performed code review to insure code quality.

Developer

Confidential

• Provided expertise in the design, implementation and support of highly available databases, supporting Enterprise Comprehensive Managed Services Program (MSP) for major clients - NCR, Aetna. 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
• 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.

PROGRAMMER-ANAlyst

Confidential

• 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

Confidential

• 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.