| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate 1
ALEXANDER NOVOSAD
Street Address Waterdown Rd., Home: PHONE NUMBER AVAILABLE
Burlington, ON, L7P 4Z8 EMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLE
________________________________________________________________________
To obtain a position of System Analyst/ Developer/ DBA with organization where I can utilize my
technical skills for the development and enhancements of Oracle Database systems.
PROFESSIONAL PROFILE
- Oracle PL/SQL Developer / Programmer Analyst with over 15 years of experience in software development in
Banking, Finance, Manufacturing and other sectors.
- Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored
Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Object Oriented PL/SQL Programming and
a good knowledge in Oracle 11g Developer Suite modules.
- Experience in designing & creating databases in Oracle 8i/9i/10g/11g for OLTP applications;
- Experienced in business requirements analysis, coding and testing various modules in a software development
life cycle;
- 10+ years of experience in Design, Development, Enhancement and Maintenance Support of Oracle
applications using PL/SQL in Windows and UNIX environments;
- Detailed depth knowledge in Oracle Architecture, Data Dictionary and DBMS packages;
- Highly experienced in development of Client-Server applications using front-end tools like Oracle JDeveloper,
ADF, Forms, and Reports;
- 2+ years of experience as Oracle DBA, responsible for modify existing databases and coordinating testing and
implementing;
- Extensive experience in data migration techniques using SQL*Loader, Import/Export;
- Excel in planning, coordinating and implementing security measures to safeguard the database;
- Work as part of a project team to coordinate database development and determine project scope and limitations;
- Write and code logical and physical database descriptions and specify identifiers of database to management
system.
EXPERTISE
Software Development : System Development Life Cycle (SDLC) - Object-Oriented Methodologist - Real
Time SoftWare - Client-Server Architecture - Oracle DB development and administration, - WEB development.
Managerial Skills:
Solution Development Life Cycle (SDLC) Requirements gathering and Definition Deployment, & Evaluation
Software Engineering and Development Transition to Support & Decommission ISO 9000
Technical Skills:
Operating System: Windows, Unix, Linux.
Databases: Oracle 8i/9i/10g/11.2g, MySQL, FoxPro, Dbase, Clipper, Clarion
Languages: Oracle PL/SQL, SQL, JAVA, C++, Pascal
Web: XML, XTML, PHP
Tools/ Utilities:
JDeveloper, NetBeans, Enterprise Manager, PL/SQL Developer, Oracle Forms and Report, ADF, APEX, SQL
Plus, SQL Loader, RMAN.
PROFFESIONAL EXPERIENCE
BOLIV Inc. (2010 Present),
Position: Oracle Developer/ Analyst
2
Environment: Oracle 11g/, SQL, PL/SQL, SQL*Loader, Erwin, SQL Developer, SQL Navigator, JDeveloper,
Windows, SQL *Loader and export/import mechanism for data migration for bulk upload.
Responsibilities: Technical lead for the team up to 5 developers
- Support of Case Management Application
Member of the team that setup the project standards for development.
Used Designer for design and database object generation.
Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
- Lead migration of DB tables from Oracle 8i to Oracle 11g and altered tables with new data types.
- Analyzing performance of database objects and mentoring DBA for indexation, schema gathering, partitioning;
explain plan, TK PROF.
- Creation of database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL
in 11g.
- Generating dynamic web-reports using Java, JSF, ADF, HTML.
- Leading Unit testing, System testing and User Acceptance Testing in development environment for result of error
free and smooth migration process and provide quality work for functional users.
- Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
- Utilized SQL*Loader to load flat files into database tables.
- Created SQL*Loader scripts to load data into temporary staging tables.
- Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
- Partitioned tables and indexes for better performance of application
- Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
- Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
- Involved in handling the changes in compiling scripts according to the database changes.
- Developed reports using complex queries as per client request as a part of production support.
- Provided on call support, solved the user issues and made necessary changes.
- Resolving Production severity Issues in time and meeting the SLA.
- Writing high quality and well documented code according to standards.
Atomic Energy of Canada Limited (AECL): 2008 - 2010 (Contract)
http://www.aecl.ca/
Position: PL/SQL Developer/ Technical Lead
Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i; Apex 3.2; Oracle Forms and Reports 9i; Linux
- Development of the MyHR Skills/Sub Skills Tracker System (Web Portal)
- Backend Programming using Oracle 8i, screen designing using Forms 6i and developing reports using Reports
6i.
- Supported the Oracle Human Resources Enhancements Project.
- Implemented Oracle E-Business Suite modules (OTL: Oracle Time and Labour, SSHR: Self-Serve HR, Time
Clock) with a 22 member team.
- Successfully managed as a Technical Lead the implementation to production the 2 modules of SAP Business
suite (SAP CRM and SAP SCM) to support strategic project activities (to track movement and storage of tools
and materials; to monitor work-in-process inventory and control tools location and return to warehouse).
- Developed stored procedures to extract the data from different sources and load it into data warehouse.
- Analyzing the data and Mapping the data requirements developing Stored Procedures, Functions and
Triggers.
- Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
- Maintaining daily batch cycle and providing 24 hour production support.
- Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
OAO Technology Solution: 2005 2007 (Contract)
http://www.oaot.com
3
Position: System Analyst / PL/SQL Developer
Environment: PL/SQL; SQL; SQL*Plus; Oracle 8; Oracle Forms 6i, Unix, Java
Responsibilities: Worked under IBM U.S. and AT&T U.S account to develop, maintain and support one of the
largest telecommunication provisioning and billing system for AT&T U.S.
As a lead developer for a team of up to 10 developers participated in outsourcing activities for 20 + applications
for AT&T US systems (Service Order Processing, Billing, Taxing and Data Exchange, Human Capital
Management Solutions.), adhering to the IBM US development standards and process guidelines, Software
Development Framework (SDF), Best Practices, SQA, SAP SCM, as mandated by AT&T and IBM
- Continuously worked with users to refine processes and business applications.
- Prepared documentation for data base outsourcing and trained offshore team
- Developed automated database interfaces to receive XML messages from the Best Martin Management System.
- Designed and developed PL/SQL packages implementing robust error reporting, high performance, and low
maintenance message handling.
RAO EES of Russia, Moscow (April 1999 June 2005)
http://www.rao-ees.ru
Position: Senior Oracle Developer/System Analyst
Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i, 11g; Apex 3.2; Oracle Forms 6i, 10g; Linux; Windows XP;
TOAD; Oracle Reports 6i, 10g; Oracle Developer; QVCS
- Coordinated physical changes to computer data bases; and codes, tested and implemented Oracle and SQL data
base, applying knowledge of data base management system.
- Coded Oracle and SQL data base descriptions and specified identifiers of Oracle data base to data base
management system and directed others in coding data base descriptions.
- Calculated optimum values for Oracle and SQL data base parameters, such as amount of computer memory to be
used by data base, following manuals and using calculator.
- Specified user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete
data.
- Selected and entered codes of utility program to monitor data base performance, such as distribution of records
and amount of available memory.
- Directed programmers and analysts to make changes to data base management system.
- Reviewed and corrected programs.
- Modified data base programs to increase processing performance, referred to as performance tuning.
- Created template expense reports, enabled descriptive flex fields in the Excel spread sheets, customized
documentation and messages by modifying the standard help files for the self-service expense module.
Customized the Workflow process of expense reports by modifying existing procedures and developing new
procedures in the Web Expense PL/SQL packages.
The 27 Central Scientific Research Institute, Ministry of Defense, Moscow,
(August 1989 March 1999)
Position: Team Lead - Senior Oracle PL/SQL Developer,
Maintain complex information systems for the Ministry of Defense in support of
Monitoring defense industry progress on the Russian Air Force acquisitions.
Performance evaluations of the newly developed aerospace technologies and complexes
Lead a team of 16 developers, assigned, advised and analyzed work.
Performed analysis of multiple broadcast systems' databases and data relations
Performed analysis of application problems, made recommendations and lead development of solutions
Worked with product managers to give work estimates and advised on design.
Audited troubleshooting, fixed, and testing of bug fixes and enhancements within tight deadlines.
Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
EDUCATION AND OTHER PROFESSIONAL TRAINING
2013 Oracle Internet Application Developer 11i Certification in progress
4
2011 APEX 4.0.
2010 Developing applications in JEE, ADF, Weblogic Server.
2010 Oracle Database 11g. Advanced PL/SQL.
2004 XML programming.
2003 Oracle DB Administration.
2000 Programming in JAVA.
1992 Book Publication "Clarion/Clipper The main features in comparison
1984-1989 Bachelor of Science in Math and Computer Science in Kiev High Military Aviation University,
Ukraine
* *Additional information and references upon request
|
