SUMMARY

• Certified database professional with 15+ years of experience in the financial, retail and medical industries, specialize in custom made reports, data analysis and database design.
• Proficient in Web Development.
• Certified in Unix/C/C++ and MS SQL.
• Team player with great communication, creative, great problem solving skills.

TECHNICAL SKILLS

• UNIX Solaris/SCO
• Linux
• Windows XP/7. JavaScript
• CSS
• XML
• HTML jQuery
• PHP
• ASP/ASP.NET
• Visual Basic 6.0
• VBA for Access
• VBA for Excel
• Crystal Reports 11. SSRS
• DTS/SSIS
• MS SQL 2014
• Oracle 8i
• Sybase 11
• MySQL 5.5
• MS Office
• Adobe Photoshop
• Apache Couch DB Mongodb.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SQL Database/Web Developer

Responsibilities:

• Designed and maintain Confidential ’s web reporting portal by using ASP.net, Crystal Report 13 and SSRS.
• Performed various data analysis by using complex queries to assist with processing inventory, purchases and orders.
• Responsible for migration of OLTP and OLAP databases to new version of MS SQL Server 2014.
• Participated in design of Waggle online learning solution by creating tables, store procedures, views, and triggers.
• Designed and maintain SSIS packages for enterprise data warehouse system process.
• Developed data flow diagrams for ETL process.
• Collaborated with other team members and stakeholders in order to deliver effective technical solutions.

Confidential, New York, NY

US IT Application Support Manager

Responsibilities:

• Managed IT infrastructure and implemented Confidential .com driver’s portal (CSS, HTML, DHTML, PHP, MySQL, Ajax, jQuery) increasing Company’s revenue by $1.2M.
• Supervised development, maintenance and production support of global inventory system (across UK, US, Israel, Russia).
• Designed and maintained Customer Services database (MySQL) and various Analytical reports (Crystal Report 11, MyDBR) enhancing Company’s Financial department capabilities and efficiencies in analyzing Clientele business data.
• Led offshore team Unit, Assembly, SIT, End to End testing efforts of various releases of DriverBox application.
• Troubleshoot and managed fixes of Confidential .com production issues.
• Conducted research, analysis and initiated the implementation of the best market solution for Confidential .com customer service.

Confidential, New York, NY

Content Engineer

Responsibilities:

• Developed and maintained Confidential ’s retail sales website (CSS, Spring/Tiles, HTML, DHTML, ASP/ASP.net, Ajax, JQuery).
• Accountable for design and update of the lookbooks, microsites and styleguides.
• Performed Configuration management, leading creative releases joint effort of offshore and onshore team members.
• Created and maintained views, stored procedure and reports (MS SQL 2000/2005/2008 Crystal Report 11, SSRS, DTS/SSIS).
• Conducted comprehensive web research and analysis to recommend and implement the best course of actions.

Confidential, Brooklyn, NYC

SQL Server DBA/Database Developer

Responsibilities:

• Conducted database research and analysis in order to create various analytical reports (SQL 2000/2005, Crystal Report 9/11, McKesson system).
• Maintained MS SQL server, including database backups and recovery, job scheduling, and replication procedures.
• Responsible for the Cell Track application (SQL 2005, SSIS, ASP.net, Java Script, VBScript, XML).
• Designed and maintained Ineligible Providers application (SQL 2005, SSIS, SSRS, ASP.net Crystal Reports 9, JavaScript).
• Responsible for large quantity of data extracts and analysis to assist with unprocessed A/R balances.
• Designed DTS/SSIS packages, alerts, store procedures, views, and triggers.

Confidential, Bronx, NY

Senior Systems Analyst/SQL Server DBA

Responsibilities:

• Produced Data Analysis Reports (MS SQL 2000, Crystal Report 9.0/10, MS Access, Misys system, OLAP data cubes).
• Migrated old Delta database to MS SQL 2000 to provide management of the agency with up to date financial and patients information.
• Responsible for database replication, designed DTS packages.
• Worked in conjunction with clinical, administrative and financial management groups to create various analytical reports and application.
• Maintained MS SQL server, including database backups and recovery, job scheduling.
• Responsible for the full cycle development and implementation of Client/Server and Web applications (ASP.Net, Visual Basic 6.0, OLE DB, ADO, Crystal Reports) used by senior management of the agency for financial and statistical analysis
• Responsible for rewrite of PIMS application from FoxPro into ASP.Net, MSSQL 2000, Crystal Reports 10 platform.

Confidential, New York, NY

Systems Manager

Responsibilities:

• Developed and maintained the CAU Data Log application used as a primary tool to monitor incoming information about patients of Central Admission Unit.
• Performed full cycle migration of the CAU Data Log application from MS Access 97 to Oracle 8i OLTP database using Visual Basic 6.0, ASP, JavaScript, MS Access 97 OLE DB Technology, Crystal Reports 7.0 and Oracle 8i. Implementation included logical and physical database design, coding of stored procedures, packages and triggers. Performed thorough system testing
• Designed the Compliance Monitor application for the internal department auditing by using VBA for MS Excel
• Acted as department liaison

Confidential, Weehawken, NJ

Senior Programmer/Systems Analyst

Responsibilities:

• Designed various financial Client/Server and web applications, which utilized the following technologies: ASP, JavaScript, MS Access 97, Sybase 11, OLE DB Technology, COM, Crystal Reports 7.0 and Visual Basic 6.0
• Designed the Fiche Viewer web application to view numerous financial statements
• Developed Brokers Performance Report application to allow the trust officers to view financial information about Brokers or clients by using VBA for MS Access
• Was responsible for maintenance and support of existing financial applications on Novell network server

Confidential, New York, NY

Programmer/Systems Analyst

Responsibilities:

• Was responsible for the full cycle development and implementation of various Client/Server programs and systems for financial and retailing analysis and reporting of Computer Systems Department, which are used as management planning tools by senior management of the company.
• Implementation on the server side included interaction with CICS and DB2 screens through Attachmate Extra for transferring data into MS SQL server, and Access databases in real time. Front - end design and coding was done in Visual Basic 4.0/5.0, VBA for MS Excel, VBA for MS Access, ASP using the following (ActiveX Controls, DAO, RDO, ADO 2.5 and OLE DB technologies), Extra Basic, MS Access, and Crystal Reports.
• Responsible for migration of the existing application from MS Access to MS SQL server and Intranet use.
• Implementation included interaction with end users and establishing their needs for certain applications, logical and physical database design, coding of stored procedures and triggers.
• Participated in maintenance of the MS SQL server.

Confidential, New York, NY

Computer Programmer

Responsibilities:

• Designed and developed Customer Inquiry System (Visual Basic, MS Access) to perform accounting, financial computation and analysis.
• Prepared multiple reports in MS Excel and Lotus 1-2-3. Designed back-end databases.
• Developed and tested front - end Travel Database Program (MS Access) to keep track of travel arrangements and expenses
• Reconciled General Ledger monthly documents, bank statements.
• Conducted tax research and preparation.