Profile

More than 16 years in IT: close work with accounting department, automation of the office processes from gathering of the requirements to development and implementation, development of the complex databases from the logical to physical design, database administration, STP optimization, data analysis, local and web applications. SQL Server/MS Access developer of multi - tier applications. Extensive hands on experience in design of the ETL automation solutions SSIS, DTS, and command prompt batch jobs, documenting and analysis of the existing and being designed software. Software development with agile methodology scrum .

TECHNICAL

SQL Server 2000/2005/2008/2012, SSIS, SSRS, Tableau, MS Access 97/2007/2010/2013, VBA, VB.NET, ADO.NET, C, WinCVS, Visual Basic 5.0/6.0 ASP XML, VB Script, Java Script, MS IIS, Apache, MS Index Server, HTML, ADO, MS Report Designer Crystal Reports Excel, PowerPoint Clipper 5.1/ 5.2 ERWIN Windows XP/7/8, MS Source Safe, Axosoft Ontime, EKTRON

PERSONAL

Good Team Player, Excellent Problem-solver, Quick Learner, Creative Thinker, Ability to multi-task and work with cross-functional teams in a very fast- paced environment.

SOFTWARE DESIGN

• Designed an architecture and maintained complex flexible client-server MS Access/SQL server billing applications for accounting to generate pass-through and management six figure thousands of items invoices.
• Generation and automatic processing of inbound and outbound feed files from MS Access.
• Migrated MS Access/MS Office 2000 applications to 2003 and to Office 2007/2010.
• Automated email with report attachments and word document generation from MS Office applications
• ETL to SQL databases of the inbound sales force feed files through SSIS, DTS and direct execution of the stored procedures. Generation of the outbound feeds. Re-design of the STPs to improve speed from 10 to 100 times.
• SQL server databases modification to facilitate required changes of the business processes.Data Analysis: Identify root cause of inconsistencies/errors in the reports and fix the data in the SQL databases.

Business Analysis

• Created SOP and Gap Analyses documents for existing and designed automated feed processes.
• Created requirements BRD, TRD for business applications.
• Documentation and improvement of existing processes.

Database Administration

• Installation, maintenance and updates of the SQL Server database systems, DR planning and documenting.
• Database security audit and implementation of the required policies.
• Automation of the backup, restore and refresh of the Production, Staging and QA environments, scripts and reports deployment.
• Troubleshooting of the performance issues on the SQL server and Database levels.

WORK HISTORY:

Confidenital

• Database Administrator DBA Installation, maintenance and updates of the SQL Server database systems, 24x7 on call production support. Participation in DR planning and documenting. Resolution of the server performance issues caused by various factors.
• SME in MS Access applications. Created and deployed to production MS Access app to have 20GB Axosoft OnTime PMS web database data accessible including all attached files after migration to Inflectra Spira PMS
• Tableau reporting database implementation.
• Documenting, dry run testing and maintenance of the business continuity/disaster recovery infrastructure, databases and applications.
• Performed security audit of the SQL servers and databases. Designed, documented, and promoted security best practices, policies, standards and protocols.
• Setup and monitored Transactional Replication, Database mirroring on production and QA servers. Automation of the replication deployment. Monitoring and troubleshooting of the Log Shipping.
• Review and advise on physical and logical database design to ensure appropriate referential data integrity and data types are used, STPs are designed and tuned for the best performance and reliability. Enforcing of the database naming conventions for the organization to ensure consistency in the database development.
• Created and modified processes and procedures for efficient and reliable system development life cycle.

Senior Developer

• Close work with DBA team on SQL server changes for various projects as well as troubleshooting SQL server performance issues caused by various factors.
• Project design and development of the outbound check processing feed: tech lead. MS Access/SQL Server .
• Optimizing SQL STPs for better performance and error trapping.
• Tier 2 support and troubleshooting production issues for SQL databases and local applications.

Software Engineer III

• ETL to SQL databases of the inbound sales force feed files through SSIS, DTS and direct execution of STPs.
• SQL server databases modification to facilitate required changes of the business processes.
• Migration of the MS Access/MS Office 2003 applications to Office 2007
• Weekly SQL script maintenance and Monthly code releases of the local applications
• Modifications of the MS Access billing system: implementation of the new types of billing. Close work with accounting department to supporting all stages of invoicing.
• Support and modification of the 1099 generating application.
• Data Analysis: Identify and fix mismatch of the data in the local and web SQL databases.
• Support and modifications of the data transfer web/local interfaces.
• Modification of the local MS Access and web c front end UI.
• Training of the new members of the IT team in automation and other Speakers Bureau applications.

Software Engineer II

• Automation of the FTP data feed files transfer.
• Re-design of the billing application to do most of the processing directly on the SQL server utilizing pass through queries and new STPs.
• Data migration from the databases from the businesses of the merged company.
• Design of the reports and reporting applications STPs, MS Access, MS SQL server reporting service
• Support of the MS Access applications.
• Design and support of the scheduled data base driven notification e-mail broadcasting.

Programmer Analyst

• Data recovery, move and launch of the MS Access Speakers Bureau SB application in a new location after fire in the company's building.
• Import Export of Data from the vendors to corporate DB conversion of the .doc files with listings into MS Access tables, data analysis, DB extracts. Custom database design for internal clients: Task Manager, Shipping, Products.
• Created custom MS Access program for Fax and E-mail broadcasting via Right fax Servers.
• Rebuild old DB according to up-to-date requirements.
• Set up index server to use for several web sites including Confidenital
• , and Physicians World Intranet document search.
• Implemented Java Script Menus to use at web sites designed in PW.
• Setup of the Right Fax 7.0 server for receiving of incoming faxes, and further delivery via E-mail.
• Designed Delinquencies Report to catch events with data lost on different stages of a work flow.
• Designed Statistic Reports for Continuing Medical Education. EDU.Surveys.
• Designed, tested, created deployment package of Health Economics Research Cost Analyzer for 1 and 2 years economic models of Valrubicin and Radical Cystectomy treatments, 1 and 2 year Decision Analytic trees, to add more levels for input components.
• Designed Job Numbers ASP page for tracking project codes with MS Access back end and ability to display dynamic data based on selected criteria numbers

Data Base Specialist II

• Design of the new and modification of the existing reports MS Access, Crystal Reports for various clients.
• Right fax Servers Administration.
• Prepare and launch application for Lilly Speakers Bureau
• Design of the various VB and ASP application

Data Base Specialist

• Designed VB utility for batch processing of the tables stored in any database accessible through ODBC connection for simultaneous changes in the multiple tables.
• Work with Continuing Medical Education department, eliminated back log of old data vendor's participants data. More than a thousand files were reviewed and processed.
• Year 2000 readiness project.
• Health Economic Research HER: Started re-design of the Cost Analyzer to accommodate new treatments.
• Routine work on DB extracts data analysis Participant Tracking and Event Management systems .

Data Base Support Specialist

• Conversion of the vendors data Text, MS Excel MS Access, ISAM databases files into PW standards compliant MS Access files. Transfer of converted data into existing PW Applications using standard PW applications interface. Design of the custom reports for end users in MS Access.
• Modification of the treatment branch modeling software Cost Analyzer: implementation of the new requirements of the Health Economic Research department.
• Designed Job Posting Application for HR department for publishing current vacancies on the web site, including front end ASP pages and back end MS Access database.
• Designed Application Server for Watch Dog program to track and enforce DELTEK time sheet completion by querying MS SQL Server database.

Data Base Specialist

• Designed MS Access DB applications: Continuing Med. Education Contacts, back end for GeoMed web site.
• Created program for conversion of the text files, submitted through FTP, into database table and export of the received data into Events Management System.
• Developed Bulk Fax broadcasting program for Right Fax v.6.0 and corresponding Reporting System.
• Re-designed Speed up to 5 times performance of Cost Analyzer Comparative representation and modeling of different treatments with recalculation of Decision Analytic Tree and Comparison Graphs in VB5/VB6.
• Worked with clients on implementation of their business requirements into vb applications.