System administrator/ Business Analyst

YELENA KONTOROVICH

**** **** **** ******: 847-***-****

Buffalo Grove, IL 60089 ************@*****.***

SUMMARY

System Administrator / Software Developer with extensive experience in all phases of SDLC. Effectively analyzed, designed and implemented global enterprise-wide systems with multi-tier client server architecture. Highly specialized in PeopleSoft HR and Payroll applications and infrastructure. Proven success enhancing existing systems with new features, performance improvements, conversions and upgrades. Possess ability to communicate complex technical information to non-technical audiences. Adaptable, customer-focused, and self-motivated. Core strengths in:

• System Administration – installation, configuration, upgrade, tuning

• RDBMS – configuration, performance analysis and tuning, space management

• Troubleshooting & Problem Solving

• Delivering IT Projects

• Cross-function Communication

• Data Model & Database Programming; Data Mapping, Analysis

• Operations, Customer service and Help Desk Support

TECHNICAL & SPECIALIZED SKILLS

Applications: PeopleSoft HRMS, Cognos BI, Control-M, Data Mirror, ISOTrain, PMP (Softscape), Actuate, Master Tax

Platforms: UNIX Solaris, Window 2000 & 2003 Servers, AS/400

Databases: Oracle, SQL Server, DB2

Languages: PeopleTools, PeopleCode, Application Engine, SQR, SQL, PL/SQL, Shell scripts, FTP, SFTP, cron, stored procedures, triggers, dblinks

Internet: Weblogic, PeopleSoft PIA, SSL, Citrix, VPN

Tools: Application Designer, Upgrade / Change Assistant, PeopleSoft Data Management Tools, ETL Tools, Cognos Report and Query Studio, TOAD

Additional: Six Sigma White belt, MS Office (Excel, Access, Visio), SDLC

PROFESSIONAL EXPERIENCE

BAXTER HEALTHCARE, Deerfield, IL

A global medical products and services company specializing in medical devices, pharmaceuticals and biotechnology, with approximately 50,000 employees globally.

Quality Data Analyst I 2010 to Present

• Create and facilitate reporting for a GFS team to assure compliance with FDA requirements.

Technical Consultant 1999 to 2010

• Served as an administrator for PeopleSoft applications – installation, configuration, security, performance tuning, monitoring, troubleshooting, patches, Tax updates, etc. System (15+ databases, 10+ UNIX servers, 8+ Window servers, and desktop support) was available 99.5% of the time and complied with SLA.

• As an administrator for BMC Control-M application, provided installation, upgrades and environment support. Created tables, calendars, jobs. Resolved scheduling conflicts / issues.

• As a technical consultant, led several key projects: PeopleSoft application implementation and upgrades, Tools upgrades, infrastructure, hardware, Data Center migration, creation of Global single PeopleSoft instance.

Yelena Kontorovich Page two

• Administered Change Management, Change Control and Release Management Activities for audit compliance.

• Designed and developed new processes to increase productivity, including nightly batch schedule with scripts to integrate Control-M with several PeopleSoft processes. Created daily Global HR Reporting environment and daily HR Data Warehouse refresh. Developed various processes automation via Control-M and Control-M notifications.

• Developed custom automated data transmission system to accommodate numerous transmission protocols which eliminated the need for additional software purchases.

• Increased efficiency and saved on additional hardware by tuning database, applications (CALC, Tuxedo, web server) and individual processes, programs and queries. Reduced nightly process time from 6 hours to 1.5 hours.

• Supported daily / weekly / monthly HR Data Warehouse load, performed ETL modifications based on user’s requirements, developed reports using Cognos BI tools.

• Provided integration solutions for European offices running SAP HR applications.

• Automated application related startup and shutdown scripts, system cleanup and space / process monitoring.

• Served as a liaison between Baxter and ASP providers to coordinate UNIX and Oracle version upgrades, monthly maintenance activities, and problem resolution.

• Served as a member of compliance team for S-Ox and Safe Harbor audits. Achieved successful approval by external auditors and Baxter Safe Harbor certification by European commission.

• Enforced the use of PGP, SFTP, Oracle encryption, data masking, ID/password management, laptop encryption.

• Participated in DRP, high availability and release planning, software evaluation, testing and installation.

NEWARK ELECTRONICS, Ravenswood, IL 1998 to 1999

Project Manager

• Designed, developed and supported various customer front-end systems. AS/400, RPG, CL.

SOFTWARE SYSTEM ASSOCIATES, Chicago, IL 1996 to 1998

Senior Programmer Analyst

• Supported Account Payable and Receivable systems on BPCS. AS/400, RPG, CL, BPCS.

PSC CONSULTING, Arlington Heights, IL 1995 to 1996

Programmer Analyst

• Designed and developed customized applications for several companies. AS/400, RPG, CL.

EDUCATION / PROFESSIONAL DEVELOPMENT

• BS Computer Science, Leningrad Institute of Technology, Russia

• 2006 – 2009 IBM Training in Cognos Data Modeling and ReportNet

• 2001 – 2006 Training in Oracle, UNIX, Control-M, SQL tuning, Tuxedo tuning

• 1999 – 2007 PeopleSoft University - Training in PTools, PCode, Config & Admin, Upgrade, Data Management

• College courses in AS/400, RPG, CL

• Six Sigma White belt & SLCD certified

LANGUAGES

Fluent in English, Russian, intermediate proficiency in French

Contact this candidate