Principal Consultant Resume
Reston, VA
SUMMARY:
- Development and customization of data warehousing solutions using database design, ETL mapping, metadata development, multidimensional cube modeling, and report design
- Creation of customized software solutions incorporating all phases of the software development life cycle (SDLC) with emphasis on data modeling, database development, OOP coding, interface design, and integration with legacy ERP systems
- Management of Information Technology teams to achieve maximum results with limited resources
- Consultation with end users and senior management to engineer processes and systems to drive success
TECHNICAL SKILLS:
Languages: PL/SQL, SQL, C#, VB6, VBA, VB.Net, XML, HTML, UNIX Shell Scripting, Java, JavaScript
Databases: Oracle through 12c, SQL Server through 2014, Microsoft Access
Database Productivity: Toad for Oracle, SQL Developer, SQL*Plus, SQL*Loader
Reporting Tools: Cognos through 11.0.8, Crystal Reports
ETL Tools: Oracle Data Integrator through 12.2.1.x, Oracle Warehouse Builder, Pentaho
Other Applications: Confidential Product Suite (Banner, ODS, EDW, SRP, RAP, AP), GERS/Escalate (a Retail POS, ERP system)
Server O/S: RHEL through 7.3, Windows Server through 2012 R2, SunOS/Solaris
Data Governance: Data Cookbook
Collaboration: Jira, Confluence, SharePoint
Methodologies: Agile, Waterfall
PROFESSIONAL EXPERIENCE:
Confidential, Reston, VA
Principal Consultant
Responsibilities:
- Worked with over ninety institutions, domestic and international, to help maximize return on investment in Confidential ’s BI products
- Developed all training curriculum for use with Confidential ’s Cognos and Oracle Data Integrator based products
- Achieved successful outcomes on several long - term development assignments
- Developed a database to support an online volunteer fundraising application for an Ivy League University. The project included a synchronization interface to Confidential ’s Advance application. Surmounted several obstacles, technical and non-technical, to move the system into production while achieving a high level of customer satisfaction.
- Created a custom interface between Confidential ’s Advance and Banner Student and HR systems for a critical project with a major university. This sizeable project required extensive specification development, requiring both analyst and developer skills, to successfully conclude the engagement.
- Awards received: 2011 GEM, 2012 GEM, 2013 Performance (twice), 2016 Cheers (twice)
Confidential, Enfield, CT
Director of Information Technology
Responsibilities:
- Developed and managed an Oracle and Cognos based Business Intelligence platform - projects included:
- Creation of a profitability model which allowed the company to target and reduce in-store discounting - increasing store gross margin by 5%
- A major migration, including both hardware and a Cognos version change, resulting in 100% uptime for the system
- Created a .Net and PL/SQL based system to integrate with extended warranty vendors - saving over $100K per year in warranty costs
- Migrated to new Point-of-Sale system support vendor - reducing fees by 60%
- Developed new PL/SQL based interface between online store and backend system - eliminating dozens of order management hours per week
- Consistently achieved 100% uptime with mission critical Point-of-Sale system
- Successfully managed several outside contractors on multiple projects including:
- Development of a new product information system
- Creation of product and order interfaces for a new website
- Featured presenter at Confidential General Business 2009 Influencer Summit and subject matter expert on Confidential ’s mid-market networking site
Confidential
Senior Systems Analyst/Programmer
Responsibilities:
- Conceived, proposed, designed, coded, and implemented a PL/SQL and Cognos based sales commission system which:
- Eliminated numerous, costly errors caused by the previous system
- Significantly reduced man hours previously spent correcting commission problems
- Increased flexibility when creating sales promotions
- Successfully launched the company’s first e-commerce website, which earned over $1M of revenue in its first year
- Integrated website’s product file with Google Base Product Search - eventually resulting in a 20% contribution to online sales
- Created a PL/SQL and .Net based system to notify customers by email of delivery appointments - providing a strong incentive for customers to provide email addresses
- Developed a PL/SQL and .Net based application to validate email addresses captured by sales associates
Application Development Consultant
Confidential
Responsibilities:
- Automated Purchase to Pay (P2P) and MDF/Co-op collections processes, resulting in:
- Significant productivity increases resulting in a 20% reduction in department headcount
- 25% open vendor receivables reduction
- Dramatic decrease in invoice cost discrepancies
- Built vendor shipment management system which:
- Cut time to receive inventory by over 75% - from hours to minutes
- Reduced redundant communications
- Developed payroll commission system, streamlining sales commission management and yielding a 40% department headcount reduction
- Introduced Business Intelligence to organization through implementation of a Cognos-based reporting system
- Integrated EDI with existing systems, allowing use of purchase order (850), purchase order confirmation (855), advance ship notice (856), and invoice (810) transactions
- Created comprehensive merchandise planning system, enabling buyers - for the first time - to create forecasts, execute buy plans, manage replenishment, and analyze planning impact