SUMMARY

• A talented and accomplished technology development leader focused on implementation software development and delivery with over 18 years of progressive experience in custom development of large - scale information systems.
• Expertise in system development life cycle, from conceptualization and requirements determination, application design, development, testing, implementation, and post-production support. Experience in the Financial, Banking, Healthcare and Educational sector industries.
• Highly experienced in supporting back-end and font-end applications in a fast-paced, results oriented business environment.
• Extensive experience leading enterprise projects utilizing a solid background in software engineering, business application solutions, and operations management.
• Possess highly proficient communication skills effective at managing and building professional relationships with professionals and non-professionals at all levels.

AREAS OF EXPERTISE:

• Software Development
• Database Design and Administration
• ETL
• Data Warehousing
• Data Modeling
• Performance Tuning
• Data Architecture
• Project Management
• Team Leadership
• Strategic Planning/Analysis
• Technology Implementation
• Cost/Benefit Analysis
• Quality Assurance Methodology
• Process Improvement
• Project Planning
• Communication Skills
• Presentation Skills
• Requirements, specification and Design documentation review
• Agile Scrum Methodology

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, T/SQL, Java, .NET, VB 6.0, HTML, ASP, Shell, Perl

Databases: ORACLE 7/8/9i/10g/11g, MS SQL Server, MS Access, MySQL

Development Tools: Toad, Oracle Enterprise Manager (OEM), Oracle Financials, MS Visual Studios, Designer 2000, Brio, Oracle Developer, Oracle Reports, PVCS, HP Quality Center and ALM, Crystal Reports, MS Project, SCT Banner

ETL: Data Stage, DataHub Informatica Power Center, Warehouse BuilderSQL Data Replication

Applications: MKS Integrity Client, Project Database, MS Visual Source Safe 6.0

Control: M, PVCS, AppWorx, SSH Secure Shell, Telnet, UltraEdit

Operating Systems: Windows (all versions), MS DOS, Sun Solaris (UNIX), Linux, MAC

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FLORIDA

Consultant

Responsibilities:

• Responsible for design, development and testing of new Sensitivity Risk System application.
• Provided Change and Release Management support. Prepared deployment scripts, executed and supported continuous project migrations into higher environments.
• Provided support with Data Analysis and Data Modeling for Oracle databases using Toad Data Modeler.
• Designed and created Oracle database structures and scripts using SQL and PL/SQL. Wrote queries in Oracle for data extraction, analysis and testing. Provided support for both Test and Production environments.
• Developed, modified and enhance data architecture using DataHub Informatica Power Center.
• Conducted Performance Review of Oracle Database for business critical applications with Senior Leadership team.
• Performed root cause analysis on failures. Resolved performance tuning related issues and queries.
• Lead code review sessions, provided guidance and training sessions on data architecture and best practices.
• Formulated suggestions for defining, prioritizing, and completing projects on schedule and within budget.
• Participated in defects meetings with development and business teams to prioritize defects and estimate target deployment schedule.
• Created functional and technical design documentation for Sensitivity Risk System application.
• Worked with the testing group to facilitate the verification of applications for accuracy and consistency.
• Provided support to onshore/offshore development and testing teams.
• Developed and implemented quality processes and standard operating procedures by introducing metrics and documentation.
• Implemented best SDLC in daily operations. Increased efficiency through change release cycles, improved code quality, established best development practices and entire software development lifecycle.

Environment: HP, Oracle 11G, PL/SQL, SQL Server, TOAD, TOAD Data Modeler, R-SQL, SQL Developer, IBM DataStage, DataHub Informatica Power Center, DataMart, Project Database, Windows, UNIX, Linux, Beyond Compare, Microsoft Office

Confidential, Tampa, FLORIDA

Senior Database Developer, Lead

Responsibilities:

• Developed and implemented quality processes and standard operating procedures by introducing metrics and documentation. Produced status reports, progress statistics, and business-oriented metrics, cost savings comparisons, and financial analysis.
• Developed an integrated billing warehouse; worked with the business owners to gathered requirements, designed tables for the warehouse, created the Informatica ETL’s to extract the data from a database and load into the data warehouse.
• Lead creation of the process that loads Oracle tables from flat files using DataHub Informatica ETL’s on daily basis, including error handling routine, reporting and daily operation support. Conducted defect triage meetings, performing impact analysis, determining root cause and estimating target deployment schedule.
• Build out the VAR test environment on Oracle10G database. Worked extensively with stakeholders, business analysts, Product Owners, DBAs and technical administrators to gather specifications and system requirements.
• Played key role in conversion project; analyzed, developed and supervised conversion of 44K merchants into Oracle 10G database.
• Lead development of Mobile Application project; worked closely with stakeholders, business analysts, Product Owners, DBAs and Technical Administrators in converting the business requirements for the Mobile App to technical specs that can be used by developers and by 3rd party contractors.
• Researched and evaluated alternative resolutions and recommendations with the most efficient and cost effective solution for database and system design.
• Supported statements generation process to over 500K merchants; coordinated and setup nightly processing along with troubleshooting production problems.
• Created databases, tables, packages, stored procedures, functions and triggers in the Oracle 11G environment using PL/SQL. Created data types, scripts, triggers, indexes, table spaces, etc for deployment to Oracle 10G database.
• Provided an DataHub Informatica version of existing programs: analyzed business logic, created process flow diagrams, workflows, sessions, parameter files, shell scripts.
• Troubleshot, fixed and implemented bug fixes and enhancements within tight deadlines; experienced in Tuning SQL statements using Explain Plan, SQL TKPROF, Hints.
• Worked with the testing group to facilitate the verification of applications for accuracy and consistency.
• Extensively used UNIX environment to run jobs, Shell scripts, load data. Created/modified/executed shell scripts to accommodate new requirements and for testing purposes.
• Experienced using Control-M scheduling tool; created new and modified existing Control-M jobs.
• Worked inter-departmentally with QA, System Administration, DBAs and Product Owners.
• Participated in daily Agile scrum meetings, estimated work effort, drove code reviews.

Environment: Oracle 11G, PL/SQL, SQL Loader, SQL*Plus, TOAD, ERWIN, OEM, UltraEdit, VSS, Control-M, Informatica Power Center 9.1/9.5.1, Mart 7.1/6.2/5.1. , Project Database, Windows XP/7, UNIX/Sun OS, Linux, Extra X-treme(UNIX)Agile Scrum Work, MKS Integrity Client.

Confidential, Tampa, FLORIDA

Banner Consulting Lead

Responsibilities:

• Converted USF Legacy system to the new Banner system; converted Oracle forms into Internet Native Banner; modified forms using Oracle Developer.
• Developed technical specification documents based on analyzing business rules and internal customers’ requirements.
• Modified USF Electronic Data Exchange System (Transcripts) using PL/SQL.
• Troubleshot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan and TKPROF.
• Performed analysis on Improvement of processes and workflows, Tuning and Query Optimizations
• Kept track of project progress, reported to upper management; provided analysis and statistical reports for current/completed projects.
• Created Project documentations, technical specifications documents; analyzed business workflows, business rules and system requirements.
• Created Test Plan and Test Strategies for Banner Upgrade project.
• Participated and conducted meetings with internal staff, vendors and multiple internal departments for project requirements, modifications and upgrades.
• Maintained Data Warehouse, created complex queries and reports.
• Provided support to Banner Financial application written in C#.
• Created AppWorx Modules, Chains, and Data types.

Environment: Oracle 10g, PL/SQL, SQL Loader, SQL*Plus, PL/SQL Developer, Developer 9i, C#, Banner 7.2OEM, Windows NT/2000, UNIX/Sun OS 5.6, Brio