• Reduced man-hours by 75% parsing XML formatted translation files into PL/QL using Python. • Designed and ran data migration process to refactor data. • Worked with data models (ERDs) to create schemes and support application design and functions. • Solved database level constraint and index problems. • Participated in Agile stand-ups, iterations and continuing application deployments. • Database administration, including space management, user/schema creation and aggressive password strategies. • Consulted with multiple teams to create and modified objects in the database to keep projects and tasks on schedule. • Analyzed and reported on data for developers, managers and end users. • SQL performance tuning to help often resulting 30%+ reduction in processing time. • Maintained consistency between development, test, stage and production environments. • Refreshed data in lower lanes using Oracle Datapump to transport data between different lanes. • Used internet and local resources to resolve many day-to-day development issues when needed.

• Streamlined tuition waiver system and in the process found an error that was costing the university a $100,000+ per year. • Built a retirement tracker that reduced the amount of time my manager spent on providing information for retirement for 70%. • Created health insurance calculator for HR that saved the Benefits manager an hour per person evaluating health insurance. • Assisted with employee data auditing and reporting (tuition waiver invoices from different schools). • Compiled, analyzed and reported data using Excel spreadsheets that included tuition waivers, retirement lump sums and higher education assistance (helped to track the budget). The data is used to see the how the benefits programs that university has are progressing.

• Reviewed, analyzed and evaluated business systems and user needs. • Improved systems by studying current practices. • Managed all aspects of workflow practices that are used in homesteads, elderly care services and residential centers by doctors, nurses and other staff. • Trained doctors, nurses and staff on how to use our new programs. • Conducted regular interviews of medical personal, asking them what kind of work do they do in order to improve the workflow processes via web applications. • Developed reporting and dashboards using SQL queries to show metrics such as many people were in a homestead, age, free rooms, medicine and more resulting in increased efficiency of staff. • Developed good and trustworthy relationships with clients.

• Created a CRM system that helped reduce the time for searching and analyzing potential customers by 30%. • Collected and analyzed data to learn more about consumer behavior (product, prices, activities, season of the year, age, location, etc.). • Kept accurate records pertaining to inventory and account notes to reduce customer debt, timely payment of bills to the company. • Ran Accounts Payable including verifying documentation and requesting disbursements. • Assisted in projects and objectives, involving all relevant stakeholders and ensuring technical feasibility through coordination of contracts between private or state organizations. Verified contracts and authorized final versions. • Project Manager for the installation of audio and video equipment, my task was to finalize agreements with the client, calculate the cost estimate, select the necessary equipment, appoint the installer, invoice, track the quality of services, track the payment from the client. Managed changes to the project scope, schedule and costs.

• Produced error-free accounting reports and presented their results to the accounting department. • Responsible for managing the service center workflow, finalizing contracts with clients, balancing the cash register, making bank runs, ensuring inventory accuracy and managing payroll. • Contributed to strong client relationships through positive attitude and daily interactions with clients. • Communicated with Manager and/or Director on office status and customer issues.

Science and Engineering, Computer Information Technologies

Исторический, История