Data Microsoft Office
Resume:
Yefim
Schwartz
Owings Mills, MD ***17
********@*****.***
www.linkedin.com/pub/yefim-schwartz/a5/570/313
PREVIOUS CLIENTS
CMS – Centers for Medicare and Medicaid Services
State Departments of Natural Resources
Department of Agriculture
Department of Energy
Department of Social Services
Pharmaceutical Companies
KEY ACHIEVEMENTS
Business growth and ROI: Increased number of company contracts from 3 to 20
Core product integration:
Engineered a scalable and reusable system that met a
wide spectrum of client needs allowing business to achieve monopoly in the niche market
Automation & Efficiency:
Developed a dynamic Extract-Transfer-Load (ETL) process to enable prioritization, create automation and improve
efficiency of operations
User experience portfolio:
Piloted and integrated a unique suite of tools that improved the digital and interactive user experience
“Customers
don’t expect you
to be perfect.
They do expect you
to fix things when
they go wrong.”
~ Donald Porter
REFERENCES
Available upon request
SENIOR PL/SQL DEVELOPER/ANALYST
A results-oriented and strategically focused leader who enjoys identifying opportunities to complex system challenges and developing unique business solutions. Skilled in all phases of the software development lifecycle with 20+ years of IT experience. An expert in translating business requirements into detailed technical specifications, and highly focused on quality, usability, security and scalability of business solutions.
CORE EXPERTISE
PL/SQL objects Development
Data Analysis
Data Modeling
Service-Oriented Architecture
Application Development
Release Management
Software Development Lifecycle (SDLC)
Troubleshooting
Senior Management Consulting
Project Management
Team Building & Leadership
Quality Assurance (QA) & User Acceptance Testing (UAT) Support
Configuration Management
Creative Problem Solving
SQL Queries Tuning
EXPERIENCE
Senior PL/SQL Developer/Analyst, CSC Inc. / CSRA Inc.
Columbia, MD 2015 -Present
Provided the most effective solutions for various tasks and problems associated with DECC HQR program base following deep analysis of business requirements and troubleshooting. As a Subject Matter Expert (SME) trained other team members and management on best practices and advanced strategies for problem resolution in Oracle database programming and reports preparation.
Accomplishments:
Using software development knowledge and Agile Methodologies to develop and implement an automated dynamic Extract-Transfer-Load (ETL) process that enabled prioritization of external file records based on date comparison logic that worked efficiently across multiple programs.
Designed a Data Synchronization process allowing for synchronization, consistent formatting, and storage of data submissions received from multiple sources in different formats.
Strategically improved efficiency and processing time of various In-patient Quality Reports (IQR) and Out-patient Quality Reports (OQR) through modernization techniques. Created new and modified existing Oracle packages, procedures, and views.
Proposed and developed a data warehousing solution for ETL processing of Large Data using Fast Refreshing Materialized Views and table partitioning.
Created advanced queries for data models and sophisticated template data arraignments for complex reports. Assisted Business Intelligence (BI) team and OBIEE developers in reports preparation.
Worked closely with Java developers to troubleshoot problems, analyzed code and find the most optimal resolution.
Participated in all phases of Software Development Lifecycle (SDLC) from analyzing/correcting requirements to peer reviewing and preparing for testing and sprint releases.
Created new Oracle tables, and views and PL/SQL packages, functions and procedures.
Modified based on new requirements and maintained existing packages and procedures.
Utilized ref cursors to return data from procedures and functions for reporting purposes and bulk data transfer from one process to another.
Optimized for faster execution long processing queries (5-7hrs) into queries processing (7-10mins).
Programmer Lead, Active Network Inc.
Clarksburg, MD 2007 - 2014
Advanced through several promotions and as a Subject Matter Expert (SME), often advised senior managers on enterprise system architecture and engineering best practices for strategic business initiatives involving expansion of core client base, system enhancements, and redesign.
Accomplishments:
Developed and implemented a trend setting Call Center application for several Park reservation systems for State Departments of Natural Resources.
Designed Cyber Security Protection mechanisms for personalized and sensitive user data.
Orchestrated development of a user experience portfolio that increased customer responsiveness and self service capabilities; portfolio suite included tools such as:
Site Swapping tool - enabling transfer of reservations between multiple sites.
Multi Reservation Processing and Group Reservations allowing for processing of cancellations, tax exemptions and discounts.
Waiting Lists Processing - permitting clients to place reservations in a waiting list until inventory is available. Once available, orders are automatically processed by the system.
Messaging System - enabling real time alerts and faster response to customer reservations.
Drove all phases of enterprise integration and process improvements to successful completion, including client reservation availability initiatives (e.g. Oracle & Power Builder complex modules, WebLogic clustering, data replication), system fail-safe and recovery options.
Engineered an advanced Audit Tracking System that streamlined capture and display of dynamic content and historical user data
Developed Oracle PL/SQL types and packages for dynamic support of various business rules and processes. Implemented the same dynamic system behavior for all calls received from Call Center, Public Web, Field and Accounting applications.
Senior Software Engineer, InfoSpherix Inc.
Beltsville, MD 2000 - 2007
As a team lead oversaw research, design, development, documentation, testing and rollout of enterprise application.
Accomplishments
Mentored a team of programmers in Agile SDLC and best practices of software development and implementation.
Designed software solutions driving continuous improvement to business processes, systems and workflow.
Developed customer focused point of service (POS) system solutions with an emphasis on payments, order processing and cancellations, fulfillment, tax calculations, operations dashboard, back office reporting, customer account management, merchant platform and e-commerce website development.
Utilized Oracle Enterprise Manager and Erwin tools to design and develop Oracle database schema including tables, views, PL/SQL procedures, functions and packages. These assets were used to gather, store and process Park Reservation data collected from and requested by all modules of the system written in ColdFusion and PowerBuilder.
Created procedures that returned data in ref cursors and appropriate data feeds for PowerBuilder datawindows and ColdFusion reports.
Created Clinical Trial Management Software (CTMS) with robust features for enrollment management, monitoring, patient database, scheduling and recruitment management PowerBuilder as an application tool and Oracle PL/SQL procedures for data processing.
Programmer Analyst, TechSource Inc.
Washington, DC 2000 - 2000
Participated in development for several new projects for Department of Agriculture
Utilized PowerBuilder, Oracle and MS SQL Server for applications and reports development
Maintained applications developed by other team members, provided user support, and researched/resolved user problems.
Programmer, Z Inc.
Washington, DC 1996 - 1999
Participated in several projects for Department of Energy
Utilized PowerBuilder, Oracle, MS Access, Visual Basic, Crystal Reports for development and maintenance of various applications
Designed an application to analyze and store “Import Oil Data”, received from different sources, in the Oracle database.
Utilized Dynamic SQL for DDL statements in PL/SQL procedures to assign users temporary access to sensitive data for security purposes.
EDUCATION
Kharkov State University
Master of Science Plus in Mathematics and Computer Science
TECHNICAL SKILLS
Programming Languages: SQL, Oracle PL/SQL, PowerScript, ColdFusion, JavaScript, HTML, XML
Databases: Oracle, SQL Server, Sybase, Relational database design and normalization
Development Tools: PL/SQL Developer, OBIEE, PowerBuilder 11, SQL Navigator 6.5, ERWIN, Oracle SQL Plus, Eclipse, Fiddler Web Debugger, MS Visual Studio, Crystal Reports, Visual Basic, JIRA, Microsoft Office, Tortoise SVN, SharePoint
Operating Systems: Windows NT/XP/7/10, Linux
Contact this candidate