Summary

• An accomplished Software Engineer with over 20 years of extensive international experience in all phases of the Software Development Life Cycle SDLC, in depth software development and data mining expertise.
• A Highly Motivated, determined and dedicated, reliable and thorough, competent with demonstrated ability t maintain excellent functioning under pressure Thrive in deadline-driven environments.
• I am seeking for a job opportunity at Colorad Denver Metr area in ETL and Database Development, where my unique qualities and Strong experience in Oracle databases - Complex PL/SQLs, Procedures, Functions, Dynamic SQL, Indexes, Partitioning, Tuning with OLAP Data Warehouse and Data Mart as well as OLTP Transactional Databases can be a great contribution t the hiring company.

Summary of Qualifications

• Over 20 years of international experience in all phases of the Software Development Life Cycle -SDLC, including requirements analysis, solution design, programming, development and customization, integration testing, customer training, production rollout and on-going support.
• ETL architecture, development and execution of ETL processes, requirements and standards.
• Application programming in: UNIX scripting, Oracle 11G, PL/SQL complex SQL, SubVersion SVN, JCS and Toad.
• Complex data mining via Oracle, SQL, PL/SQL, SqlPlus, SQL Server, MS Access, DB2, COBOL, VSAM/Index-Seq.
• ORACLE DBA - OCP Certified, Microsoft SQL Server DBA - MCP Certified.
• Complex PL/SQLs, Procedures, Functions, Reports, Dynamic SQL, Indexes, Partitioning, Optimization and Tuning, experience with Oracle databases - Data Warehouse and Data Mart.
• Experience with Oracle Data Warehouse, ERD Changes, Data Migration.
• C 2010 and .NET 4.0 and Object Oriented Programming, Visual Studi 2010.

Quality Assurance - QA, Design Management.

• Demonstrated ability t effectively apply troubleshooting and problem resolution skills in a production environment.
• Leadership of development groups with hands-on problem identification and resolution.
• Excellent problem solving and analytical skills.
• Analyze t improve applications and system performance.
• Strong relationship with customers and strong customer service attitude.
• Strong interpersonal and communication skills.
• Strong focus on creating high quality deliverable.
• Easily adapts t changing priorities.
• Technical Expertise Programming and Development Tools/Languages:
• UNIX scripting, Oracle 11G, PL/SQL, SQL, SubVersion SVN, JCS
• C 2010 / .NET 4.0, COBOL, DYL, SAS, RPG, FORTRAN
• TOAD, BRIO, File-AID/MVS, Oracle Enterprise Manager, Rman - Recovery Manager, Log Miner, Quality Center QA testing tool, WinRunner, Microsoft Visual Studio, Microsoft Office Applications, Microsoft Project, Exceed

Operating Systems:

• SUN/HP/UNIX, MS Windows, IBM MVS-OS/390, VAX/VMS, MS-DOS, IBM Mainframe, IBM 34/36/AS400
• Databases:
• ORACLE, SQL Server, Informix, DB2, Microsoft Access

CONFIDENTIAL

Position: ETL and Database Developer

• Database Developer role, responsible for development, implementation, and testing of data Extraction, Transformation, and Load ETL programs for large marketing database projects Work together with the broader client team t design solutions and implement programs according t the requirements and timelines specified in each statement of work.
• ETL architecture, development and execution of ETL processes, requirements and standards.
• Application programming in: UNIX scripting, Oracle 11G, PL/SQL complex SQL, SubVersion SVN, JCS, Toad.
• Expert in SQL, PL/SQL Programming and Tuning Improve / better the efficiency of the processes.
• Complex PL/SQLs, Procedures, Functions, Dynamic SQL, Indexes, Partitioning, Tuning, experience with Oracle databases - Data Warehouse and Data Mart.
• Development of ETL architecture, design, programming and implementation for marketing database projects.
• Responsible for creating re-useable processes that help implement each solution.
• Works with key stakeholders t understand business requirements and expectations in order t develop appropriate product applications.
• Stays current with latest technologies and best practices in the industry.
• Responsible for performance and tuning of ETL processes.
• Maintains development standards in conjunction with team architects.
• Works with project team t plan, design, develop, and implement application systems and/or enhancements t existing systems t meet current and future needs.
• Conducts appropriate testing of applications t ensure quality Knowledge, Skill, and Ability Requirements.

Accomplishments:

Improve Client Satisfaction:

• Enhance processes in Data Mart / Data Warehouse t work more efficient and much faster applying merge, parallelism, hints, indexes, Cursors with bulk collect and sometimes restructure the SQLs.
• Enhance the SFTP Job t account for all types of failures even if the failure is due t the other end.
• Create a generic procedure t d Directory Cleanups i.e file cleanup.ksh .
• Update Stabilization Project - Research / improve SQLs and processes efficiency and performance in Data Mart / Data Warehouse i.e Change the DW table load t utilize MERGE, etc Enhance selected Framework Jobs t improve performance and time span i.e decrease a major process run time from 6 hours t 1hour , hence eliminate violating the SLA.

Improve Quality:

• Created new jobs and Fixed defects in existing jobs for Data Mart / Data Warehouse using Toad, Unix, SubVersion, JCS while maintaining high quality and performance efficiency t meet client requirements.
• Enhance and tune SQLs t gain performance i.e apply the use of a CURSOR using FETCH cursor records BULK COLLECT INT .
• Investigate and correct the BSAs Complex Testing and Validation SQLs, enable them t approve out products faster and smoother.
• Increase Profit through increased efficiencies
• Modify jobs t meet client requirements, Enhance, tune SQLs t gain performance i.e decrease run time from 6 hours t 1.14 Minute .

CONFIDENTIAL

Position: Co-Owner and founder of MRS Retail LLC

• Established MRS Retail LLC - a family owned company, featuring On-Line Stores with three Production websites offering Martial Arts supplies, Quality Board Games Home Decoration Products
• Search Engine Marketing and Optimization
• Relationship with customers, and suppliers
• Development tools used are: Zen Cart open source, PHP, XML, MySQL

CONFIDENTIAL

Position: Software Expert

• Finance and Procurement Systems Division at National Business Center Contract position with SofTec and RTL.
• Design Reports, Programming, Maintain software of FFS - Federal Financial System on IBM Mainframe.
• Expert in SQL, PL/SQL Programming and Tuning Improve / better the efficiency of the processes.
• Complex PL/SQLs, Procedures, Functions, Reports, Dynamic SQL, Indexes, Tuning, experience with Oracle Data Warehouse and huge databases.
• Programming, Perform complex data mining and ad hoc reports with COBOL, VSAM, File-AID/MVS, ORACLE, TOAD, BRIO, SQL, PL/SQL and Microsoft Access DB.
• Analyze and perform conversion of jobs / programs from DYL280 and SAS t COBOL on IBM Mainframe.
• Developed and automated reports - saving NBC and its clients thousands of dollars in manual report preparation Expertise was very valuable in NBC's major project with the deployment of the Financial Business Management System FBMS Provided help with data cleansing, developing queries t gather statistical data for NBC's metric reporting.

CONFIDENTIAL

• Developed and automated reports - saving NBC and its clients thousands of dollars in manual report preparation Expertise was very valuable in NBC's major project with the deployment of the Financial Business Management System FBMS Provided help with data cleansing, developing queries t gather statistical data for NBC's metric reporting.
• Redesigned and Reprogrammed an old legacy system tracking the costs of the Airplanes - Current Year versus Previous Year This was done on PL/SQL on the ORACLE Data-Warehouse.
• Designed Reports, Programmed, Maintained software of FFS - Federal Financial System through Complex PL/SQL, Procedures, Functions, Reports, Dynamic SQL, Indexes.
• Tuned and Optimized existing as well as new SQL, PL/SQL programs anonymous blocks as well as stored procedures t Improve / better the efficiency of the processes.

CONFIDENTIAL

Position: Software Expert

Senior Subject Matter Expert Denver ,

• Various positions at Israel Development Center and at relocations t various Amdocs customer sites at the US and Australia - Melbourne AUS , Troy MI , Atlanta GA , Tel Aviv ISR , Denver C .
• Software Design, Development, Programming, Implementation in integrated environments
• Develop Database Integration Jobs using UNIX, COBOL, ORACLE, TOAD, SQL, SqlPlus, PL/SQL
• Complex PL/SQLs, Procedures, Functions, Reports, Dynamic SQL, Indexes, Tuning, experience with Oracle Data Warehouse and huge databases, ERD Changes, Data Migration
• Perform complex data mining and ad hoc reports in Batch and Online modes
• Support the client relevant applications, Infrastructure, Database and Operational projects in Production, User Acceptance Test and Test environments
• Programming and Support the client relevant Batch and Online Client/Server applications with UNIX, COBOL, ORACLE, TOAD, SQL, PL/SQL, Informix, DB2
• Analyze computer operations, usage t assess completeness, accuracy, validity, and system efficiency
• Troubleshoot and resolve problems in a production environment
• Liaison with client staff concerning software issues and customer training
• Plan future enhancements and software upgrades/releases
• Manage train supervise teams of programmers in software development
• Manage train supervise teams of test designers and testers
• Design test rules, test cases and test scripts, system test integrated environments
• Perform defect tracking

CONFIDENTIAL

Israel Position: Designer and System Programmer, Team Leader 1-

• Design and program financial systems on MS-DOS, IBM Mainframe, IBM 34/36/AS400
• Perform complex data mining and ad hoc reports COBOL / RPG and VSAM files as well as DB2
• Analyze and direct the conversion from IBM-36 t IBM AS/400 and IBM PC systems
• Analyze t improve applications and system performance
• Managerial Experience
• QA Senior Team Leader 5-10 subordinates
• Development Senior Team Leader 1-5 subordinates