ETL application architecture, design, and implementation for high-performance data integration projects.➢ TD Bank – Solutions Architect •Engaged in a Solution Architecture role focusing on various projects and applications in support of Anti-Money Laundering and Risk Management •Architected US data integration into Enterprise Customer Risk Ranking system •Defined architectural direction for Currency Transaction Reporting, OFAC sanctions screening, 314a screening, and Anti-Money Laundering applications within the bank. •Assist in defining technical requirements for new projects related to AML and Risk •Produced architectural blueprints which define the architectural decisions and direction for projects.➢ Idaho Power – ETL Design Lead • Coordinated ETL design for 9 on-shore designers and 15 off-shore developers • Helped to architect and design enterprise data warehouse, integrating data from various sources including SQL Server data marts and SAP CRM system➢ TD Bank – Project Deployment Manager • Coordinate all project deployment-related activities to promote code between various testing environments and to production • Work with technical team leads to develop project runbooks and timelines; used these to compile an overall project deployment plan • Facilitate execution of deployment plan involving business stakeholders, technology and development leads➢ Barclays Wealth – Senior ETL Applications Developer • Developed Informatica mappings to integrate multiple source systems • Aided in creating and maintaining data model for warehouse using ER/Studio • Created DB2, Oracle, and SQL Server stored procedures, tables, and UNIX scripts designed to validate the performance and quality of data being processed by all ETL applications. • Coordinated with offshore teams in UK, Singapore, and India for testing and production support

479th Chemical Battalion, HHDFort Totten, NY

ETL design and development of complex, high-performance applications supporting information delivery projects. Specializing in creating solutions using Ab Initio and Informatica.➢ ACE Insurance – Worked with to identify conversion roadmap of their legacy mainframe data repository into a DB2-based system including: • Creating data model for DB2 database tables• Determining resource requirements for the transfer of > 1TB of data into DB2• Reconciling 300+ COBOL copybook formats to read mainframe flatfile• Performance testing and optimization of DB2 SQL, indexes and partitioning schemes• Design and development of Informatica mappings to process 40+ years of mainframe data into DB2• Developed 20+ Informatica ETL mappings to convert transactional, flatfile mainframe data into a relational data model• Wrote AutoSys schedules and UNIX shell scripts to automate process of moving and manipulating mainframe flatfiles on Solaris filesystem for pre- and post-ETL processing of data files • Worked closely with IBM DBA’s to implement performance improvements to DB2 environment

➢ Wachovia – Responsible for complete project lifecycle to analyze the cost metrics of ATM/Debit Card transactions.• Worked closely with business analysts to gather requirements for the ETL application, and created high-level and detail-level technical designs for Ab Initio workflows• Developed ETL applications, created test cases, sample data sets and verified results with client business analysts• Successfully created ETL application to efficiently process > 10 million transactions daily• Wrote AutoSys scheduling scripts to integrate ETL application into existing ETL framework, providing end-to-end automation of ETL process.Acquired by Hewlett-Packard in March 2007

Supporting Apple Account Executive through building brand awareness, implementing marketing plans and driving institutional sales.