Raphael Dupre

Experience

• 

  Wayne State University

  Jan 1996 - Jan 1997

  Graduate Teaching Assistant

  • Sole instructor for two freshmen level computer science laboratories each semester.• Designed lesson plans and graded homework assignments.

• 

  Connect, Inc.

  Aug 1997 - Sept 1998

  Internet Application Engineer

  Programmer for an E-Commerce software provider.• Developed and deployed E-Commerce websites using C++, Perl and HTML.• Testing and debugging web applications.• Installed web servers and Oracle databases.• Trained technical users how to customize and use the applications.

• 

  InterWorld Corp.

  Oct 1998 - Oct 2001

  Senior Consultant

  Provided technical consulting services to global customers in North America and Europe looking for packaged E-Commerce software solutions.• Led technical teams developing and deploying end-to-end E-Commerce solutions.• Wrote stored procedures to interface with customer’s legacy systems by normalizing and loading data from data files and creating data files to send back out via an interface.• Migrated clients to newer releases of the software by seeking out and updating their customizations and database schemas.• Worked on both NT and Solaris operating systems using MSSQL and Oracle databases.• Worked onsite with clients such as: Marks & Spencer, Speedo, Nike, Guess, Verizon and Mattel. Show less

• 

  USDA

  Jun 2003 - Oct 2005

  Database Administrator

  Designed and supported database applications for highly sensitive financial and accounting systems.• Designed, developed, implemented and maintained database applications using Oracle and IDMS databases for payroll processing and data warehousing.• Created and used tools to monitor database space utilization and performance to make certain the system maintained a 99.9% uptime.• Deployed with the Disaster Recovery Team, and was instrumental in rebuilding databases after Hurricane Katrina to enable the Department to resume functioning quickly and seamlessly.• Created backup scripts to run every night and perform security audits to ensure the protection of highly sensitive data.• Maintained database application definitions and made changes to the tables, schemas, and sub-schemas critical to upgrades and new installs.• Held a Certificate of Clearance of level Secret issued by the U.S. Department of Agriculture. Show less

• 

  Sabre Corporation

  Oct 2005 - Dec 2008

  Senior Business Systems Analyst

  Provided business process reengineering and technical consulting services to airlines in Europe, Asia and the Americas, acting as a conduit between global customers and the internal IT development team to identify business requirements, interpret user’s needs, translate them into system requirements, and write business specifications. Led technical teams for system development and implementation.• Implemented real-time automated inventory systems to global customers starting with requirements gathering through system design to technical install.• Increased customer satisfaction by reducing the implementation cycle by automating the process through interfaces and scripts.• Led training and mentoring of overseas technical teams on how to operate and support the product lines which enabled all support duties to be transitioned to a lower cost center, reducing support costs by more than 40%.• Designed and implemented SAS reports to show the value customers were receiving from the implemented system and the dollar amount saved by using our automated system.• Designed datamart tables and reports to support customer business requirements for trending analysis which allowed the customers to better forecast future inventory needs. Show less

• 

  Litton

  Jul 2009 - Nov 2011

  Senior Oracle Developer

  Built new databases and processes to automate dataflow across systems. Designed a system that pulled in, consolidated and loaded data feeds from various sources. Worked as a sole tech liaison between the IT department and accounting/reporting groups.• Worked with business analysts to understanding their data needs and designed and built databases used to make mortgage purchasing decisions.• Built an automated ETL system that produced all data needed for daily decision making used in million dollar purchases.• Controlled weekly production release cycles to insure stability and uptime of system.• Tuned and improved PL/SQL scripts to insure all data was accurately loaded and reports generated first thing each morning so end users could start analyzing the data when they got in. Show less

• 

  JPMorgan Chase

  Nov 2011 - Jul 2012

  Data Management Analyst

  Worked with the Executive Reporting Team to define key requirements and develop reports used in executive decision making. This included streamlining processes, developing ad-hoc database reports, tracking key performance indicators and automating existing processes to run on daily schedules. • Worked as a liaison between Executive Managers and reporting teams to translate business needs to functional specifications to be used in new development.• Facilitated discussions between key stakeholders and recommended process improvements and best practices.• Reduced daily report generation time by 84% by automating the processes using PL/SQL and ETL scripts.• Consolidated reporting efforts between multiple groups by reverse engineering existing logic and architecting one central database repository which eliminated redundancy of work and effort. Show less

• 

  Fidelity Investments

  Jul 2012 - Mar 2024

  Leading projects from initiation to completion and involved in all phases and activities. Work directly with business teams to build requirements for all projects and writing all SDS documents. Architecting solutions with developers to ensure all deliverables are meet. Heavily involved in the QA process by writing use case documents and doing deep dive tests with the QA team. Work hand-in-hand with PM’s to make sure projects are properly scoped and stay on track. • Resurrected a previously failed project by redesigning the system flow and meeting strict performance requirements• Wrote new database views and indexes that created much needed performance headroom so additional functionality could be implemented• Discovered and documented new tools for business users which simplified their campaign life cycle and allowed them to create more robust campaigns• Took leading role to fully document all product line use cases and worked directly with competing vendors to understand which products are capable of meeting our product roadmap• Used Scrum to implement a new mobile platform solution for the product line Show less

  • Principal Scrum Master

    Aug 2018 - Mar 2024

  • Principal Systems Analyst

    Jul 2012 - Aug 2018