MARGARET ROMAN KLIBAN

919-***-**** / advt13@r.postjobfree.com

Programmer / Application Developer / Database Architect / Data Analyst Charleston, SC

SUMMARY

● Seeking a position to utilize my advanced knowledge of Microsoft SQL Server, Access, and .NET to create and maintain Windows desktop applications and backend services.

● Extensively applied Object Oriented Design (OOD).

● Good Knowledge and experience of VB 6.0, ASP, IIS 6.0/5.0, Visual Studio .NET, Extensive knowledge on Front End Technologies: HTML/DHTML, JavaScript and CSS.

● Experience in complete Software Development Life Cycle (SDLC) -Project Analysis, Requirements, Design, Development, Testing, Documentation and Deployment using Client-Server architecture and web based N-tier architecture system using Microsoft .NET Technologies. TECHNICAL SKILLS

Programming: C#, VB 6.0, VB.NET, DELPHI 6.0.NET, PASCAL, 4GL, C/C++, SQL, COBOL, HTML5, FOXPRO, .NET FRAMWORK, ASP.NET

Database Experience: MS ACCESS, SQL SERVER 6.5 – 2012,2016, 2017, TFS, WCF, MYSQL, INGRES. Software: GIT, CRYSTAL REPORTS 8.0, 11.0, RDLC REPORTS, MICROSOFT VISUAL STUDIO 2015, VISIO, SC4

PROFESSIONAL EXPERIENCE

A & V Realty, LLC., Charleston, SC 2016 - Present

Programmer

● Used C# and SQL Server to create an application that enabled a real estate management company to keep track of all clients, properties, tenants, accounts payable and accounts receivable.

● Designed and developed a data processing and import tool using C# and SQL Server 2012 for handling both CSV formatted credit card statements and Excel spreadsheets with invoices from many previous years.

● Created a desktop application using C#, SQL Server, and Crystal Reports that enabled users to build custom reports. Horizon Scientific, Inc., Summerville, SC 2015 - 2016 Database Administrator / SQL Server Developer

● Created a Transact SQL application for auditing transactions in an existing application for which no source code was available. Each INSERT, UPDATE, and DELETE operation performed by the existing application was written to an appropriate table using triggers.

● Designed and implemented a C# desktop application for generating reports used to perform audits of transactions in the original application.

● Troubleshoot and Configure network equipment to meet client specifications.

● Design and developed websites on ASP.NET framework through agile development methodology.

● Extensive experience in interacting with onsite and offsite team and leading a team, participated in defect review and module enhancement meetings,track record of collecting and analyzing information and implementing actions with a view to meet goal

● Provided technical expertise in reaching business intelligence goals through the creation of financialmodel

● Converted a stored procedure into a C# application for generating a Bill of Materials report

● Created a C# application for generating reports of quantities of shipped parts for different periods of time. The reports would contain graphs and tables. The application afforded users to export data into new Excel files or append it to existing files.

Tucker Administrators, Inc., Charlotte, NC (remote from Charleston, SC) 2010 - 2015 Programmer

● Performed design, coding, testing, maintenance and support of bulletin boards

● Designed, implemented, tested and maintained a bulletin board using SQL Server and C#. (Visual Studio)

● Users were able to create forums, create topics, add posts to topics, reply to other posts, and upload/download attachments.

● Created a tool to migrate data from AS400 to SQL Server database using VB.NET on a daily basis.

● The tool used an ODBC connection to access AS400 from a Windows server.

● Worked on various financial application utilizing back-end platforms

● Install, maintain and troubleshoot network equipment on short term projects

● UI Designing, Development and Testing of Web forms using ASP.NET, C# and .Net Framework.

● A scheduled job would read data from AS400 and create text files on the Windows server.

● The tool would read the data from the text files, analyze it and insert it into the SQL Server database.

● A log would be generated. The log file contained all the records inserted into SQL Server database.

● The log would also contain any errors with the error number, description, and the record that caused the error. Medical University of South Carolina (MUSC), Charleston, SC 2008 - 2009 Programmer

● Worked as administrator and programmer on Clintrack (3M-Softmed), an integrated system that uses

● SQL Server database and Crystal Reports to oversee all hospital statistical patient information

● Created user groups, user accounts, and set up permissions

● Created work lists and assigned them to different user groups

● Updated lookup tables in Clintrack to correspond with data in Keane database

● Created and implemented a Microsoft Access program to parse through error logs and group errors into various categories

● Work with supervisor and independently to provide technology and technical support for clients/carriers to supply access to policy information, project tracking, document collaboration, request systems and new applications

● Modified Core Measure screens to make them more user friendly

● Redesigned Financial screen

● Tested work lists created by 3M

● Created custom reports using Crystal Reports.

● Create reference and documentation for users on many financial systems for steps to take and solve reoccurring issues.

● Designed, coded, tested and maintained the Projects Database tracking system of status department’s projects using MS Access

● Modified the “Physician Profile for Peer Review” system – added a report generator and search functionality.

● Designed, coded, tested and maintained an interface between diagnoses related groups (DRG) and Service Lines using C#, MS Access, Crystal Reports and .NET Framework

● Designed, coded, tested and maintained the “Patient Stay Tracking Database” using MS Access Hudson Mann, Inc., Charleston, SC 2009

SQL Server/ColdFusion Developer

● Collected specifications for project deliverables.

● Developed and maintained the software as required.

● Managed source code and documented processes to enhance maintainability.

● Developed flexible data processing and import tool using ColdFusion 9 and SQL Server 2008 for handling both plain text and Excel files.

● Safeguard operations by keeping financial information confidential by minimizing applications control.

● Created complex analytic queries on data sets.

● Created/utilized stored inline queries, procedures, triggers, and functions.

● Analyzed data as required for project support.

● Generated code to extract, transform and load data from production data sources. Biowarn LLC, Pittsboro, NC 2007

Programmer (Contract)

● Designed, coded, and tested a system using VB.NET and MS SQL Server to manage large experimental data (big data)

● Designed graphical representation of data reconciliation, sorting, and statistical analysis Sigma XI(Aten), Research Triangle Park, NC 2006 - 2007 Programmer (Contract)

● Provided security access to an ASP.NET application driven by Pervasive Database

● Designed and coded an encrypted credit card application using MS SQL Server, MS Access, Crystal Reports and

.NET Framework.

Hill-Rom, Cary, NC 2005 - 2006

Programmer (Contract)

● Designed, implemented, and improved statistical tools and user interfaces using MS Excel and VBA. Family Medical Care, Inc., Cary, NC 2004 - 2005

Programmer (Contract)

● Designed, coded, tested, and maintained the Medical Records Archive System using Delphi. Greenville Utilities, Greenville, NC 2000 - 2004

Programmer Analyst

● Designed, coded, tested and maintained the following applications utilizing Delphi, SQL Server, MySQL and Crystal Reports previously written in COBOL:

● Payroll Budget System–a multi-user application that forecasts budgets for the following fiscal year and generates payroll records for all company employees.

● Cafeteria Plan–an application that generates statements for the accounting and human resources departments based on entries in the payroll database (Empower)

● Preventive Maintenance Program–an automation application that replaced manual processes for managing equipment.

● Electronic Timesheet–a timesheet management tool that allows users to easily record their work hours based on temporal keys and automatically updates the payroll database at the end of each pay period.

● Inventory System–a tool used to assist the warehouse supervisor and staff in daily inventory, ordering, and stocking management. It’s updated through an interface with VAX.

● Transformer Application–an application used to certify new transformers, track the inventory of transformers, and maintain a history on locations and repair information.

● Capital Plan–a planning application that prepares multi-year projects and work plans. It anticipates financing issues and rate changes and supports rate analysis studies.

● Telephone Statistics System–an interface for providing statistical information regarding all customer service calls. ASMO, Greenville, NC 1999 - 2000

Programmer Analyst

● Completed interface, reports, and forms-related projects requiring the use of the 4GL language and Ingres database expertise. Additional projects also involved design work, coding, testing, and maintenance utilizing Visual Basic 6.0, Microsoft Access, and Crystal Reports. Projects included:

● Computer Associates MK System Interface: Created an interface between AS400 and the company’s MK system (an Ingres database and 4GL programming language-based integration system that includes manufacturing, accounting, and purchasing modules) to facilitate the transfer of inventory, invoice, and request data from AS400 to the MK database.

● Computer Associates MK System Forms & Reports: Created additional forms and reports upon user request for the MK System.

● Design, coding, testing, and maintenance of systems and tools utilizing Visual Basic and Access database.

● Projects included:

● Request System: Created a network PC application used to transfer requests for service data from users to the IS department, document resolutions, and generate related reports.

● Education System Tool: Developed a tool used to track records and generate reports for classes offered by the human resources to associates (schedules, classes taken, grades, and certificates.) Compusult, Inc., Charleston, SC 1997 - 1999

Programmer

● Design, coding, testing, and maintenance of Compusult tools that required the use of Delphi Projects included:

● Mortality Management Tool: Modified and enhanced a tool used to calculate the number of deaths in any chosen region based on population size, which then created maps of the US or individual US states utilizing corresponding data and parameters such as race, sex, age, and location.

● Modifications included translating the existing Pascal-based system into Delphi and altering the user interface to simulate a Windows environment.

Productivity Systems Development Corp., Summerville SC 1997 - 1998 Programmer

● Design, coding, testing, and maintenance of systems and tools utilizing Visual Basic and Access database.

● Projects included:

● Invoice System: Created a system used to manage employee records, project and client information, and billable hours that utilized two separate Access databases and ASCII files to transfer information between the two databases.

● Chamber Service Tool: Developed a Microsoft Access-based, network PC application used to manage membership records and committee lists, generate invoices and reports, and print mailing labels. University of Technology, Kharkov, Ukraine 1982 - 1996 Application Developer

● Finance System: Created, tested, implemented, and maintained a FoxPro 3-based system used by a trucking company to calculate company income, profits, and staff salaries. The solution also generated driver schedules and invoices for users, car payments, materials, and aggregates.

● Finance System: Developed a similar solution for a road construction company using FoxPro, SQL, Visual Basic, Access, Pascal, C/C++.

Instructor, Mathematics and Economics

● Managed a staff of five and taught courses on Mathematical Methods in Economics. Created bookkeeping software using Pascal and C.

Math Assistant

● Designed and developed a new course on Mathematical Methods in Economics. Developed programs used to solve financial problems.

EDUCATION

● Bachelor of Science in Computer Science, Minors in Mathematics & Economics University of Technology,Kharkov, Ukraine

Contact this candidate