Professional Profile

JPC Picture A well-rounded proven senior level manager, database architect, software developer, project manager with a MS, MBA, and proven track record on highly successful management teams. Many years of progressively increasing technology and management responsibilities in the information technology, supply chain management services, entertainment, telecommunications, injection molding, healthcare, computer software and education sectors. Goal oriented project manager with experience in leading teams through dramatic change and improvement. Thorough background in information technology, computer software development, Business Intelligence, ERP, customer relationship management (CRM), business management, training and development, forecasting, planning, financial control, and bottom-line attainment.

Significant Achievements

  • Data Warehouse Architect/BI Specialist

    • Implemented and maintains large-scale data warehouses.
    • Environments: DB2, SQL Server 2012/2016, Oracle.
    • Core technologies include QlikView/QlikSense, Microsoft SQL Server (SSIS, SSRS), Cognos (Framework, Data Manager, Transformer, Report Studio, Query Studio)
    • Interacts with business users on regular basis to analyze new requirements.
    • Currently, engages in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various load modules.
    • Hands on experience with various ETL tools such as Cognos Data Manager and SQL Server SSIS.
    • Analyzed existing Cognos Data Manager ETL that took 8 hours every day to finish and streamlined it so that it now takes less than 30 minutes to complete.
    • Evaluated SQL Server 2016 and formulated complete migration plan to move the ETL from Cognos Data Manager to SSIS 2016
    • Streamlined the existing Data Warehouse in SQL 2016: modified table names, column names, indexes, functions, stored procedures, views using Kimball methodologies.
    • Optimizes queries, and indexes to ensure peak performance at all times.
    • Maintains type 1 and 2 dimensions.
    • Creates complex T-SQL/DB2/Oracle queries, stored procedures, and functions that manipulated data in real time in large, highly transactional.

  • Software Engineer

    • Led software teams of several mission critical applications for worldwide clients.
    • Always a crucial member of teams that migrated complete software applications.
    • Developed, deployed and maintained many robust systems
    • Worked with Three-tiered applications.
    • Worked in Oracle JDE Enterprise One 9.0
    • Developed and currently maintains multiple Web based applications using C#/ASP.NET and WCF: Portals, B2B applications.
    • Core technologies: Visual Studio 2010, 2013, 2015, 2017 C#, ASP.NET, C++, WCF, AJAX, Java.

  • Information Technology Management

    • Overhauled entire IT departments.
    • Installed and added new network configurations, setup and added new servers
    • Instituted and added new software
    • Established and documented new procedures for the entire company.
    • Replaced manual processes to a complete computerized system to manage entire operations for the company.

Career History with Achievements

  • Data Warehouse Architect,
    Wesco Aircraft,
    Valencia, CA
    2006 to Present
    • Wesco Aircraft is the world’s leading distributor and provider of comprehensive supply chain management services to the global aerospace industry, based on annual sales. The company’s services range from traditional distribution to the management of supplier relationships, quality assurance, kitting, just-in-time delivery and point-of-use inventory management. The company believes it offers one of the world’s broadest portfolios of aerospace products, including chemical, electrical and C-class hardware.
    • Participates in the Analysis/Development/Maintenance for the company worldwide projects.
    • Data Warehouse Architect for the hardware division. Migrated the BI Tools from Cognos to Qlikview. All development done in Cognos Data Manager/Framework/Transformer was overhauled and revamped using SSIS 2016 and QlikView.
    • Ongoing development of databases that reside in Oracle, DB2 and MS SQL 2008, MS SQL 2012, MS SQL 2014 and MS SQL 2016.
    • Constant tuning of indexes, creating new Functions, Stored Procedures and Views.
    • Creates complex T-SQL, DB2 and Oracle queries, stored procedures, and functions that manipulate JDE Data.
    • Ongoing development of mission-critical SSIS Packages that update data in JDE, migrate data from DB2 to SQL, email raw data as well PKI’s for Finance/Accounting/Warehouse.
    • Participates in the Analysis/Development of the customized JD Edwards (JDE) 9.
    • Continuous Web development using Visual Studio .NET 2017, 2015, 2013, 2010, C# as well as VB. Technologies used: WCF, AJAX, XML, HTML, CSS, JQuery, Java. Using .NET Framework 4.6, 4.5, 3.5 and 2.0

  • Consultant,
    JPC Enterprises-Migration Solutions,
    2001 to 2006
    • Participated in the Analysis/Development of software, using the latest technologies such as .NET, VB6, ASP, HTML, MS SQL, DB2, Sybase, Reporting Services and Crystal Reports. Created front-end applications (Windows Forms) in .NET using VB and many classes written in C#. These applications worked with a DB2 and MS SQL backend. Developed SQL views, stored procedures and functions in MS SQL that interacted with .NET applications and Crystal Reports.
    • Vast experience with MS SQL 2000 and 2005: T-SQL, Stored Procedures, Functions, Views and Triggers. Also used DTS and later Business Intelligence Development Studio to access data from other databases such as DB2 and Sybase.
    • Used VB .NET with the 2.0 Framework in conjunction with CSLA Robert Lhotka’s framework using N-Tier and Object Oriented concepts and used code generators to speed-up the development process.
    • Worked for Disney Corporation ( as a consultant from August 2005 through June 2006. Worked in large, enterprise scale applications over $50 million dollars, involved a conversion from PowerBuilder/Sybase to Java/DB2. The data was moved into a SQL Server database using t-sql prior to being pushed into DB2 via ADO.NET. Responsibilities included creating views, tables, stored procedures and functions in VB.NET and C# classes.
    • Worked through Jaguar Consulting ( for companies such as: NBA, WNBA, Major League Baseball, Hallmark, National Geographic, NBC Enterprises, Liz Claiborne, Chorion, MGM, Lions Gate Entertainment and others. Project involved maintaining and modifying a robust, 3-tier “Rights Management Application”, with several web-based pieces. The application was used for tracking inventory, handling accounting and royalties, etc. and the primary technologies were VB, ASP, Sybase, Reporting Services, Crystal Reports and T-SQL.
    • Ongoing modifications, over 2 years, to an overhauled old system that used Gupta into a .NET, MS SQL system using .NET remoting. This company keeps track of the shipments of chemicals that are shipped around the globe.
    • Created 2 applications that replaced manual registration processes into automatic and computerized systems using .NET and MS SQL for a non-profit organization. Used barcode technologies and Crystal Reports .NET.

  • Instructor Information Technology,
    Learning Tree University Chatsworth Campus
    Chatsworth, CA
    2000 to 2002

    • Instructor for Microsoft Visual C++, Instructor for Programming in C, Language Basics, Instructor for Programming in C, Advanced Techniques.

  • Director of Information Technology,
    CyberRep (Formerly 800 Direct)
    Canoga Park, CA,
    1998 to 2001

    • CyberRep is a B2B electronic customer relationship management organization that leverages Fortune 1000 clients' ability to maximize lifetime customer value by acquiring, maintaining and enhancing relationships.
    • Managed IT for the California region comprised of 2 Telecenters with over 400 workstations. The IT department is formed by a team of 12 individuals that develop and maintain mission critical applications for over 30 clients.
    • Established needs and researched new technologies that could give CyberRep an edge among the many Call Centers around the country, and led the IT team in the implementation of the technologies.
    • Led the software development of several mission critical programs and scripts for current and new customers. Using Visual Basic 6.0, Visual FoxPro, HTML, Java, and Microsoft SQL to migrate all legacy systems written in Clipper and the Advantage Client/Server backend.

  • Manager Information Systems,
    Molding Corporation of America
    Burbank, CA,
    1992 to 1998

    • Company that is dedicated to the custom injection molding of quality parts in polymeric materials. Three sites with approximately 300 employees.
    • Overhauled the entire IT department: Installed and added new computers, set up and added new servers, instituted and added new software, established and documented new procedures for the entire company.
    • Replaced a complete manual process to a complete computerized system to manage the entire operations for the company.
    • Formed and headed a team in the development and implementation of a complete MRPII system.

  • Consultant, Analyst/Programmer
    Summit Health, Ltd. (Merged with Ornda 1994 and now Tenent)
    Burbank, CA,
    1989 to 1991

    • Company that managed 12 hospitals around the country and several nursing homes.
    • Developed several accounting and health-related programs utilizing RPG and Clipper.

Education / Certification

  • M.B.A. in Business, M.S. in Computer Science, B.A. in Biology. California State University of Northridge, CA
  • Qlikview: Developer, Advanced Topics.
  • Cognos: Data Manager, Framework, Transformer.
  • JDE Programming and Training.
  • Professional Development Courses including management, production, HR and finance.