SUMMARY:

• Engineered a scalable and reusable system that met a wide spectrum of client needs allowing business to achieve monopoly in the niche market
• Developed a dynamic Extract - Transfer-Load (ETL) process to enable prioritization, create automation and improve efficiency of operations
• 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 12+ 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:

Service-Oriented Architecture

Application Development

Senior Management Consulting

Release Management

Software Development Lifecycle (SDLC)

B2B Integrations

Project Management

Team Building & Leadership

Quality Assurance (QA) & User Acceptance Testing (UAT) Support

Configuration Management

Creative Problem Solving

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

EXPERIENCE:

Senior PL/SQL Developer/Analyst

Confidential, Columbia, MD

Responsibilities:

• 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.
• 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.

PL/SQL Programmer Lead

Confidential, Clarksburg, MD

Responsibilities:

• 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.
• Developed and implemented a trend setting Call Center application for several Park reservation systems for Confidential .
• 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

Senior Software Engineer

Confidential, Beltsville, MD

Responsibilities:

• As a team lead oversaw research, design, development, documentation, testing and rollout of enterprise application.
• 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, fulfilment, tax calculations, operations dashboard, back office reporting, customer account management, merchant platform and e - commerce website development.
• Created Clinical Trial Management Software (CTMS) with robust features for enrolment management, monitoring, patient database, scheduling and recruitment management.