Software Development Programmer Analyst

Marina Kolchinskaya

Highland Park, IL ***** 847-***-**** ad5drm@r.postjobfree.com

Senior Programmer Analyst

Driving projects forward from design inception through successful completion

System Improvement Focused Strategic Problem Solver

Strong Analytical Skills

Expert in all facets of software development life cycle (SDLC), from analysis and design through development, implementation, documentation, and user training. Software developer with extensive experience in Information Technology. Expertise in IT processes and procedures in security, financial and sales industries. Provide high-level development, testing, deploying, and maintenance for custom software solutions. Perform well in a project team and independently. Quick learner and self-starter with excellent communication skills, ensuring meticulous attention to details. Naturally inquisitive troubleshooter and detail-oriented team member. Adapt easily to changes in priorities, seamlessly manage multiple assignments simultaneously. Excellent follow-through skills.

Summary of Qualifications

–Programming and Scripting Languages: C#, Delphi, Visual Basic, C, HTML, VBA, VB Script, PL/SQL

–Databases: MS SQL Server, Oracle, Transact-SQL, Sybase, MS Access

–Operating systems: Windows NT - 10, DOS, UNIX

–Tools: SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Crystal Reports, SAP Business Objects, Service Now, Microsoft Office Suite (Word, Excel, Outlook, Access), MS Teams

Professional Experience

USA CLINICS GROUP, Northbrook, IL February 2022 – October 2023

Programmer Analyst

Created, maintained, enhanced, and optimized stored procedures, functions, cursors, and joins, created database objects like tables, views, triggers, indexes necessary to support SSRS reports. Designed and developed new reports from scratch, maintained and modified existing different types of SSRS reports to meet business needs. Provided ongoing design, development, and implementation of SSRS reports. Interacted with internal users and the third-party Services to determine which datasets should/should not be integrated over. Supported general business reports and benefit plan administration processes. Worked closely with various departments and supported their analysis and data needs. Optimized SQL Stored Procedures.

●Developed complex Stored Procedures to generate various Drill-down reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS.

●Created interactive parameter driven SSRS reports providing clients the ability to review and analyze their claims.

●Owned the design of advanced analytics dashboard and KPI reports starting from requirements gathering from billing, call center, and senior leadership teams to the delivery of a final, polished reports to production.

●Created numerous customized reports and ad-hoc reports based on end-user requests, analyzing effectiveness of business.

Marina Kolchinskaya ad5drm@r.postjobfree.com Page Two

USA CLINICS GROUP (Continued)

●Developed different type of reports including Billing Reports, Scheduling Reports, Accounting Statement Reports, Inventory Report, Auditors Reports, UFE QOL Study Report and Insurance/Payroll/Expected Payments reports using SSRS and SSMS.

●Optimized database by creating various clustered and non-clustered indexes. Managed index statistics, tables, cursors, and optimized queries by using execution plan for tuning the database.

●Extensively used joints and sub-queries for complex queries involving multiple tables from different databases. Analyzed data and re-mapped fields based on business requirements.

SECURITAS SECURITY SERVICES USA, Rosemont, IL June 1999 – October 2021

Senior Programmer Analyst

Designed, developed, and implemented frontend and backend models for various applications. Stored, retrieved, and manipulated data for analysis of system capabilities and requirements. Performed automated/manual data clean ups/updates on bad or corrupted records. Provided ongoing design, development, and implementation of Crystal reports for business needs. Monitored system operation to detect potential problems. Coached users on issue-prevention techniques. Documented system design specifications and other system-related information. Performed data conversion from Sybase to MS SQL Server.

●Designed, developed, and implemented frontend and backend Administrative, Billing, Accounts Payable, Scheduling systems designed to handle massive data traffic, using C#, Delphi, and Microsoft SQL Server, providing ongoing support of the implemented systems.

●Created numerous customized reports based on end-user requests, analyzing effectiveness of business.

●Wrote complex SQL scripts and queries, created Stored Procedures utilizing Dynamic SQL.

●Worked on enhancements and optimizations, addressing design gaps and ongoing evolving requirements requested by business.

●Developed billing portion of Billable Non-Worked process intended to flag Time Off (PTO) as billable and automatically create corresponding Supplemental Charge to easily tracking PTO through the scheduling system, reducing work required by the field, increasing accuracy of all changes, affecting client billing and employee payroll, and eliminating 100% data input manually.

●Successfully designed and developed Holiday Update application requested by business to automize annual process ran for U.S. and Canada systems, reducing processing time from 8 hours to 1 hour.

●Successfully designed and deployed Patrol and Alarm system used for scheduling and billing processes of mobile security services provided by the company, reducing input data time processing by 70% and increasing efficiency of provided mobile services by 50%.

●Collaborated with a team, creating, and maintaining payroll system.

●Communicated with testing leads for robust testing of requirements and solutions, ensuring compatibility, lower regression occurrences, and maintain code integration.

●Communicated with training leads, providing clear documentation of billing and payroll processes solution and scheduling system.

●Provided production level support for detailed and complex issues, requiring intense data review, script development and execution, and coordination with end-users.

●Successfully implemented migration of non-relational database-based application to a fully relational Sybase-based utility.

Marina Kolchinskaya ad5drm@r.postjobfree.com Page Three

SECURITAS SECURITY SERVICES USA (Continued)

●Developed tools to perform data-transformation service for uploading and downloading unsynchronized data from company centralized mainframe-based system to local offices.

●Modified the existing software, resolving issues to improve performance.

●Created interfaces, communicating with field data collecting devices, such as magnetic card readers, and chip-readers.

●Analyzed assigned Help Desk tickets from the end-users, developing solutions to resolve the issues.

●Provided technical support to end-users, leveraging broad-based expertise to handle problem identification, diagnosis, resolution, and escalation via helpdesk system, telephone, and remote support tools. Performed security administration functions for user, data, and remote access.

Additional Relevant Experience

VOLKSWAGEN CREDIT INC., Deerfield, IL, Programmer Analyst

Education and Training

Bachelor of Science (BS), Mechanical Engineering,

Tashkent State Transport University (TSTU), Tashkent, Uzbekistan

MS Visual Basic, MS Access, Project methodology,

Advanced Windows Development Program for Professionals, Lincolnwood, IL

SAP Business Objects for design and reports, Rosemont, IL

Webucator, Technical & Business Training, Rosemont, IL

Contact this candidate