SUMMARY:

• Accomplished software developer, business analyst and project lead with over 15 years of diverse information technology experience and extensive business knowledge in Banking, Finance, Insurance and Accounting.
• Worked on projects with consistent implementation success.
• Effective gathering and documentation of business processes to be defined on the project requirements repository.
• Defines, designs, and document business flows and processes on small & medium size projects.
• Identify, analyze, propose and document appropriate solutions for problems and issues that may impact the project.
• Communicate status, solutions and concerns.
• Disseminate information in a timely manner within the team and across functions or teams.
• Establish and maintain relationships within the business and technical groups.
• Facilitate JAD sessions among SME’s, Development management, PMO, QA and business stakeholders
• Data analysis and design skills
• Effective evaluation of business framework as related to the database capabilities and limitations
• Experienced in data and systems migration to new hardware and software platforms
• Experienced in table design and normalization utilizing case and data modeling
• Ability to create SQL scripts and stored procedures on diverse platforms.
• Quality Assurance Engineering
• Solid experience in testing complex multi - platform applications running on separate DB’s: SQL Server, Oracle, ISeries DB2 and Mainframe servers.
• Financial applications knowledge
• MBS Back office trading applications support and maintenance
• Credit Risk Analysis.
• Securities Clearance and Settlement procedures
• FRA’s and IR Swap trades
• Operation and Trading Desk support including night batch support
• Insurance Financial Applications: Voluntary, home, auto and lender placed policies tracking

TECHNICAL TOOLS AND SKILLS:

Databases: ISeries DB2, Oracle 9I, MS SQL Server, MS Access, XML scripting.

Data & Business Analysis tools: Toad Data Modeler, Oracle Workflow, MS Project, MS Visio, MySQL Workbench.

SDLC Models: Waterfall, Agile and RUP Methodologies.

On the IBM ISeries: RPG ILE, RPG Free, CL, native SQL, C#, stored procedures to access WEB front-end servers.

QA testing software: HP Quality Center 11.0, Automation testing tools QTP, Selenium

Project Management: Six Sigma Methodology, Viper, Clarity, MS Project

Oracle: Oracle 11i Financials, Fixed Assets, Order Management, A/R, A/P, Customers and Sales static data setup, Discoverer, Oracle report writer and forms maintenance, ADI fixed assets and data load.

Development platforms: ISeries RDI, MS Visual Studio, MS SQL Server, Toad and Bugzilla for Java.

Fluent in: Spanish and Portuguese

EXPERIENCE:

Confidential, Newbury Park, CA

Senior Programmer / Business Analyst

Responsibilities:

• Works on diverse automobile insurance agency projects on a multi-platform network within the following business areas
• Premium accounting, claims processing, rating, state reporting, and the implementation of a documents- image repository.
• Gathering and documenting business functional requirements
• Development of functional and technical specifications, data models on Visio and MySQL tools
• Forecasting of project resource demands and completion dates
• ISeries, Windows and Web application maintenance and new development analysis
• Design and implementation of new claims, invoice disbursement and debt collection modules
• Subject matter expert on SIS package: Business requirements liaison
• Assigned to complete the IT backlog of user requests
• Assists on maintaining QA test plans, test cases, reviewing unit, integration and UAT test results

Confidential, West Hills, CA

Business Applications Support / QA Lead

Responsibilities:

• Report and integrate QA test results to JAD driven projects, participating on JAD sessions as QA lead
• Support and lead operational quality control team for the lender place insurance system
• Leads full SDLC QA projects assigned to my team: From requirements capture to implementation
• Designs test cases, maintains the test plan on QC tool, reports results, estimates dates in adherence to project plan, QA signoffs published, provides UAT and post production validation support
• Extensive utilization of SQL Server to run scripts and procedures for data validation
• Implementation of QC automated testing from Web Services and ISeries programs using QTP

Confidential

Project Development Support / Business Analyst

Responsibilities:

• Provides business requirements, data model diagrams, requirements documents to the development team to support diverse projects encompassing reporting and insurance tracking from 25(+) Web portals and Web Services.
• Maintenance and enhancements of diverse ISeries personal lines financial accounting programs.
• Assigned to data and applications migration projects from Balboa to Confidential Americas building complex SQL Scripts
• Utilized RPG ILE, RPG Free, Stored Procedures, T-SQL on programming assignments

Confidential, Westlake Village, CA

Senior Developer

Responsibilities:

• Settlement confirmations enhancements: Data transmission issues support
• Whole Loan Trades credit risk reporting enhancements: Import MtM and rates into the ISeries
• Credit Risk Analysis: Integrating new VAR & MTM index calculations.
• Cost of Carry calculations: Program enhancements to provide rates and automated charges to trading desks.
• G/L-Journal Manual Entry System: Integrated to IMPACT G/L and PEOPLESOFT
• IMPACT Package Multi-Entity Multi-Currency migration: Supported programming, testing and documentation.
• Extensive work on interface programs to: Bloomberg, Bank of NY, DTCC.MBSCC- Utilizing FTP, DTC Packages, MQ series and stored procedures
• Bloomberg Securities Price & Coupon downloads. - FITS Modules maintenance.
• Operations and Trading Desk Support: Help desk and night batch remote help as assigned.

Confidential, Jersey City, NJ

Developer-Business Analyst

Responsibilities:

• Utilized RPG ILE, RPG Free, Stored Procedures
• Special projects developed to expand the bank’s proprietary system functionality on the following areas:
• Designed to net MBS trades, scalable to include other fixed income products.
• Application of new risk calculations developed in conjunction with the credit risk group. Netting across groups of trades exposed to new formulae utilizing market values, mark to market comparisons and risk weighted calculations.
• Designed data downloads for analysis of trade information, distributed via FTP to the back office AS400 IFS network.
• Modified custom applications to retrieve trade information from MQ queues via API-based programs.

Confidential, NJ, CA

Developer-Business Analyst

Responsibilities:

• Oracle ERP and CRM implementation:
• Complete implementation of customized Applications:
• As a functional lead, I coordinated various sections of the project.
• Extensive business process analysis applied to integrate legacy functions to Oracle 11i ERP and CRM modularity.
• Set up customers, FM customers, customer relationships, salespeople, sales territories, service technicians and service contracts.
• Define business requirements.
• Provided data analysis from the legacy systems to implement data migrations to ORACLE 11i.
• Data conversion from AS400 to ORACLE 11.5.6 and 11.5.9. Database.
• Conversions and customizing Order Management, Inventory and Oracle Financial Modules.