EXECUTIVE SUMMARY:

• Customer - focused Senior Software Engineer with extensive experience designing innovative applications and achieving high customer satisfaction.
• Extensive experience in Application Development in all phases of software development and support in Oracle PL/SQL and experienced in Business Intelligence including Business Objects and Informatica Power Center.
• Skilled C#, .NET development, data migration, and data analysis.
• Proficient in both analytical and problem solving skills resulting in on-time software development cycles and timely customer needs assessment and response.

TECHNICAL EXPERTISE:

Computer Languages: Oracle PL/SQL, C, C#

Business Intelligence: Business Objects XIR2

Data Integration: Informatica Powercenter (ETL)

Operating Systems: UNIX Solaris, Linux, Windows

Web Development: ASP.NET, Ajax, Java Script, XML, MS Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential

Database Analyst

Responsibilities:

• Database Planning and Analysis for all types of commercial payments
• Perform Data requirements and Data Model reviews
• Prepare and review data flow diagrams
• Database SME for Payments Database Core Project Tech team meetings
• Developed Global Payments Monitor report to monitor transactions
• Prepare Database comparisons using Excel to determine overlaps in database tables and data elements
• Prepare Global Payment Reports by Company and User for Management, generating multiple SQL queries into the Global Payments database
• Data Analysis report generation for Management review using Excel
• Provide development and production support for Oracle Stored Procedures using Oracle PL/SQL
• Provide technical support for database performance (Oracle PL/SQL tuning)
• Oracle PL/SQL database stored procedures code reviews

Data Integration Technical Lead

Confidential, Tempe, AZ

Responsibilities:

• Data Mapping review and oversight for Data Mart team, Data Modeling and relationship diagrams
• Review Data Integration project timelines
• FIS Profile Data Extracts - Subject Matter Expert
• Review all Informatica ETL Test plans for financial systems including PeopleSoft and Data warehouse teams
• Sample test data planning and requirements gathering from multiple data teams
• Subject Matter Expert for all system and user defined definition tables
• Account Origination - Data Integration Management
• New bank application reporting requirements reviews and documentation
• Gather Data requirements from all downstream systems for testing preparation
• Subject Matter Expert all data integration for the Confidential project - including data flow diagrams
• Approve technical design documentation for all data integration for Confidential Project
• System Integration environment management

Confidential

Senior Systems Analyst, Phoenix, AZ

Responsibilities:

• Developed Pricing Tool Data Integraton System - data conversion mapping from mainframe to web interface using Informatica Power Center mapping and workflows
• Developed and maintained Inventory feeds to supplier sites (including FTP data transfers)
• Informatica System Admin tasks which included SOX Audit reporting and system status
• Maintained eCommerce Part and pricing data integration
• Cross trained several team members on Informatica Power Center and Oracle PL/SQL
• Managed change requests for the middleware data integration team, including scheduling production code deployments.
• Data Migration sourcing from Web Methods messaging queue (XML Format)
• Oracle PL/SQL code development including stored procedures and database triggers
• On-Call support to maintain over 700 Informatica production workflows (Informatica Power Center, DX/DT, and B2B)

Confidential

Senior Software Engineer, Scottsdale, AZ

Responsibilities:

• Managed data migration for application upgrades by providing project plans and providing status updates to management. Also worked closely with the vendor and team Database Analyst for the development and testing coordination of migration and application upgrade testing.
• Provided data migration analysis and validation documentation to management using Oracle PL/SQL expertise for data comparisons to ensure accuracy of business rules and integrity of data. Documentation to be used for data validation auditing and data quality assessment.
• Analyzed, reviewed, and approved vendor provided data mappings.
• Developed multiple data mappings for several data migration projects.
• Assisted with design and development first financial data mart for the business organization reporting against an Oracle database using Informatica Power Center.
• Managed iBASEt Solumina Manufacturing software, application interfaces, and application customizations including user interfaces and software configuration. Application support in Oracle PL/SQL.
• Developed multiple Oracle PL/SQL application customizations for shop floor manufacturing software including automated serial buyoff transaction processing.
• Documented design and unit test cases for all software development as well as formal review of project requirements, system test plans and user acceptance.
• Worked extensively with Oracle PL/SQL for validating and troubleshooting multiple data migration projects and day to day resolution of data issues.
• Managed and supported Business Objects XIR2 reporting application including multiple software upgrades. Troubleshooting report issues using Oracle PL/SQL.
• Developed a data migration process using Informatica Power Center for asset management software upgrade from legacy mainframe application to and Oracle database.
• Developed data conversion from Microsoft Excel and XML formats to Oracle database using Informatica ETL.

Confidential

Project Manager, Technical Lead and Senior Software Developer, Phoenix, AZ

Responsibilities:

• Managed point of sale system requirements, design, and software development of retail application for over 500 automotive part retail stores.
• Designed and developed labor scheduling custom application in C programming language.
• Promoted from Software Developer to Senior Software Developer to Technical Lead to Project Manager during tenure.