Yana Sizonenko Email and Phone Number

- Developer of the Pearson Information Enterprise Reporting System application designed for VPs and senior managers to keep track of schedules, deadlines and budgets for 450 airport projects.- Created the application from scratch using C#.NET, VS 2010, SQL Server 2008, JavaScript and CSS while being involved in decision making of every step with the project manager.- Implemented complex logic and algorithms of user permissions, user hierarchy and schedule hierarchy.- Designed and administrated the database, including database structure, normalization, stored procedures, triggers, user creation, backups, restores, transfer of data to/from various sources using SSIS.- Delivered the code on time while dealing with daily business requirements changes.- The application became an essential tool for early problem detection, issue management and resolution along with financial budgeting and program management within the largest airport department, the turnover of which had exceeded over 7 billion dollars in last 10 years.

- Provided system, report and process data enhancements to Capital Market Global Supply and Demand Management application using C#.NET, VS 2010 and SQL Server 2008.- In a short time I was able to grasp the logic and essence of GSDM to a point that under a month I provided invaluable solutions to several problems in addition to new development of Forecast Funding and Forecast Pricing reports.- Analysed data issues surrounding immense static tables and provided recommendations, scripts and implementation to data discrepancies. - Offered continuous timely and responsive support of system issues for the end users as well as for the department VP.- Updated full GSDM and ANGL technical and support documentation.

- Acting in a role of a software developer in Bermuda based eCommerce solutions provider dedicated to supplying businesses and banks with payment and risk management solutions designed to facilitate online transaction processing- Developed and supported majority of reconciliation/settlement procedures for multiple hosts; responsible for accurate movement of transactional information of over million dollars a day- Main developer of numerous reports. Worked on all phases from new database structures, parsers, stored procedures to Crystal Reports- Developed a virtual terminal demo application with extremely tight deadline of one day- Developed numerous small applications such as an extract of failed transactions and all end-to-end procedures with our partner Ethoca; custom Excel reports for our VIP merchants; plugins for new hosts; XML to Excel conversion application.- Designed SSIS Packages to transfer data between servers, load data into database; Scheduled the jobs to do these tasks periodically- Took an active role in all daily activities/fixes such as providing ad hoc reports for upper management and accounts department; helping clients and support department with all their queries and questions; assigning high priority and fixing production issues- Worked well in fast paced environment on multiple projects under pressure and tight deadlines

- Supported Direct Investing website, giving all requests full attention and professionalism.- Developed and implemented SSIS packages as well as numerous complex SQL scripts for mass updates and reports for business purposes with backup and rollback strategies.- Initiated the improvement of a release process, thus removing unnecessary workload from support, QA and deployment teams.- Member of a social committee. Organized and planed events, made up strategies for greater involvement and profit.

- A main developer of a "terminal server configuration utility" project using C#.NET and SQL Server 2000.- Led a team of five people, producing a defect free web application one month before the deadline.- Took key part in all phases of the project including: gathering business requirements, creating a database structure, front-end as well as back-end development and assistance with test cases.- Created a SharePoint website structure, to unify seven team's websites, serving our clients with friendly and efficient navigation system. Received a positive feedback from upper management for a twenty minutes presentation of the structural importance and its maintenance.

- Point of contact for maintenance related matters between Brascan Media and its biggest client Royal LePage.- Resolved over 400 maintenance issues on the Royal LePage Internet and Intranet websites in half the allocated time using ASP, ASP.NET, XSLT and SQL. Today, the Internet site draws over 500,000 unique users every month.- Improved call center’s quality of service by taking the initiative to fix the root causes of problems by redeveloping code in ASP / ASP.NET and stored procedures instead of numerous patch fixes.- Reduced turn around time for defects from 2 months to 2 weeks by transforming a disorganized and inefficient maintenance cycle, through assignment of specific roles and proper distribution of tasks to available resources.- Conducted weekly status meetings with Royal LePage call center’s manager.- Promoted to a .NET developer of a major internet redesign project.- Developed office and agent search and results pages on the .NET platform using eDirectory on the backend.- Assisted with application design and functionality.