• Over 10+ years of experience in the IT industry with 7+ years focused on ETL solutions, Data Quality and Exception Management. • Work closely with Partners, Managing Directors and business users to design data solutions.• Involve in every phase of SDLC from analysis, design, development, implementation and post production support for applications.• Design and develop data integration processes using flat files, Oracle, MS SQL Server, Sybase, and AS400 databases.• Informatica admin experience with installing/upgrading Informatica on Windows 2012 server, repository backup/restore, BCP implementation, and setting up user security via admin console.• Automate processes that allow users to drop files for loading or trigger files to initiate workflows using Windows batch scripts. • Successfully manage ETL project between three different regions (EMEA, ASIA and US) with ability to work across different time zones in an effective manner• Develop Data Warehouse process from Oracle system to Sybase IQ. Process comprised of over 30 + mappings, multiple workflows, Sybase BCP load stored procedure, Star Schema.• Develop complex Informatica mapping to capture data changes from operational source systems into data warehouse and data marts.• Develop exception process that allows users to define business rules and receive daily report emails of all failed exceptions.• Assist in data modeling to read from Informatica metadata to display process status, run time, record counts and error messages.• Schedule workflows using Informatica Workflow property, MS Task Scheduler and Autosys.• Responsible for performance tuning of legacy jobs. In some cases, processes resulted in a performance increased performance by 85% using advanced Informatica settings.• Solely responsible for managing Informatica platform for several years. This was the largest ETL platform for the department containing multiple business critical processes.

• Worked with business units to gather report requirements and outlined details of deliverable.• Provided insights on report design and enhancements.• Worked collaboratively with developers and business users throughout project development.• Performed unit testing and outlined test plan before coordination with business users for UAT.• Provided on-going support to business after deployment of reports.• Updated business data stored in database as requested using Oracle DML scripts.

• Created Microsoft Access application to import/export client data in excel/text format into SQL tables• MS SQL 2000 – created views/stored procedures/triggers for specific projects• Interacted with Directors, Managers, Project Analysts, and Clients to design/program features for projects• Monitored SQL and Access processes daily for any errors• Provided on-call support for urgent data requests at night and holidays for clients• Meet with clients to discuss new projects or enhancements to current applications• Analyzed flow charts of client and business unit processes• Documented specifications of all projects for IT development• Performed UAT for completed projects before allowing deployment