James Pinggera

Experience

• 

  The Home Insurance Company

  Feb 1989 - Sept 1998

  Application Developer

  Supported and developed key applications within the company's premiums processing system using COBOL, Assembler & RPGII coding languages along with IMS and VSAM data stores.Developed the organization’s first data mart leveraging Cognos Impromptu and PowerPlay for the user interface, being fed by a multidimensional star schema Oracle database, to analyze insurance claims data to assist the business in managing risk.Implemented a COBOL batch process for loading data into Oracle database. Authored technical documentation and user manuals to facilitate the effective use and support of data mart. Show less

• 

  BNY Mellon

  Sept 1998 - Jan 2024

  Developer Analyst tasked with the creation and support of the Investment Management websites, ensuring seamless functionality and accurate data.Engineered and implemented the Investment Management Document Service, comprising of backend REST API's coded in JAVA, to support Investment Management websites and Seismic sales tool. This innovation automated previously manual document processes, streamlining operations for the Digital and Product Marketing teams.Collaborated with both Crown Peak Content Management System (CMS) and later Adobe Experience Manager CMS teams to import documents and their metadata, enhancing the content delivery on Investment Management websites.Supported and enhanced various REST API’s for Product, User, Fulfillment and Web Components Services, facilitating seamless interactions with the Investment Management websites.Annually awarded selective performance bonuses and recognized with company “WOW Points” by business leaders for delivering exceptional technical support.Repeatedly chosen to conduct training sessions for new team members and application users within the Digital and Product Marketing teams, underscoring expertise, and leadership skills. Show less Served as the lead developer creating distributed financial applications to support the Corporate Accounting department.Developed the Dealer Analytics reporting application, leveraging the Informatica ETL tool for data collection and transformation from multiple sources and Business Objects for financial report generation. This system empowered the business to make quicker and more accurate decisions.Authored backend DB2 SQL queries and stored procedures in support of the Autoserv and Network Level distributed front-end applications, thereby enabling the Accounting team in making informed business decisions.Honored with the prestigious company TOP award as a member of the Transfer Agent Conversion Team. Show less Provide support for the Trades Data Mart, constructed using Cognos Impromptu and Powerplay, fed by a Sybase multidimensional star schema database.Transformed trades reporting batch process, converting from EASYTRIEVE/VSAM to COBOL/DB2. This transformation increased reliability and reduced batch processing time from 14 to under four hours.Reengineered and coded the investments batch processing system in COBOL/DB2, achieving a reduction in execution time and increased code reusability through the integration of sub programs and stored procedures.Awarded multiple Certificates of Appreciation in recognition of providing outstanding service to clients. Show less

  • Senior Specialist Full Stack Developer

    Sept 2018 - Jan 2024

  • Senior Full Stack Developer

    Sept 2006 - Sept 2018

  • Senior Application Developer

    Sept 1998 - Sept 2006
• 

  Stony Brook Medicine

  Jul 2024 - now

  Lead Programmer Analyst

  Provide reports and data analytics to the clinical and administrative leadership from the Stony Brook Cancer Center.