Alan Keller Email and Phone Number

Java, database developer for Big Data/Identity Management group.

Responsible for modeling, maintenance and support of Exception Management databases, which includes Trade Exceptions, Positions, Inquiries and Configuration Management models. Responsible for all ETL processes, archiving processes, stored procedures and queries utilized by the XM and Dashboard applications. Other duties include data analysis/reconciliations, configuration management and ad-hoc reporting.§ Database – Oracle 10g, PL-SQL, Talend§ Web - HTML, XML… Show more Responsible for modeling, maintenance and support of Exception Management databases, which includes Trade Exceptions, Positions, Inquiries and Configuration Management models. Responsible for all ETL processes, archiving processes, stored procedures and queries utilized by the XM and Dashboard applications. Other duties include data analysis/reconciliations, configuration management and ad-hoc reporting.§ Database – Oracle 10g, PL-SQL, Talend§ Web - HTML, XML, JavaScript, FusionCharts§ Dashboards – Provide real-time metrics on Inquiries, Exceptions and User performance. Also provide valuable testing tools to provide ad-hoc reconciliations during development, data migration and testing phases.§ Seg Deficits – Developed processing that provides day over day comparisons to user community with comprehensive analysis for present day processing Show less

Responsible for the development of java servlet and backend processing for BlueSheet Query Tool, which was an analytical application used to identify and invstigate insider trading. Some of the features included were Dynamic SQL generation, Caching/Paging, Output to Excel/PDF formats for reporting needs.Resopnsible for support and applying enhancements to Risk Assessment and Compliance projects under the realm of the Market Surveillance group. These applications provided analytical… Show more Responsible for the development of java servlet and backend processing for BlueSheet Query Tool, which was an analytical application used to identify and invstigate insider trading. Some of the features included were Dynamic SQL generation, Caching/Paging, Output to Excel/PDF formats for reporting needs.Resopnsible for support and applying enhancements to Risk Assessment and Compliance projects under the realm of the Market Surveillance group. These applications provided analytical reporting to user community to identify risks and challenge in business practices..§ GUI - VB, C#, Java, Spring MVC Framework, EJB, Eclipse, WAS 6.0§ Database - Sybase, Oracle 10g, T-SQL, PL-SQL§ Web - HTML, XML, XSLT§ Scripting - UNIX/AIX, Perl, JavaScript Show less

Website development for small businesses. Developed application to maintain several sports fantasy leagues, which consisted of an Access database and Visual Basic program that provided ETL processing and then generated static HTML pages. Eventually this project was then converted to a Java/MySQL based applicaton.§ HTML, Java, VB, Access, Excel, MySQL

Responsible for maintenance/support of the Product and Pricing database environments. In addition to maintenance/support, these duties included database modeling, ETL processess, stored procedures, reporting tools, data analysis, configuration management and replication strategies. Also responsible for most DBA duties.Responsible for the total migration of the Product and Pricing database system from Sybase to DB2, which included all of the above duties.Responsible for… Show more Responsible for maintenance/support of the Product and Pricing database environments. In addition to maintenance/support, these duties included database modeling, ETL processess, stored procedures, reporting tools, data analysis, configuration management and replication strategies. Also responsible for most DBA duties.Responsible for the total migration of the Product and Pricing database system from Sybase to DB2, which included all of the above duties.Responsible for maintenance and support of several analytical projects that used the above databases as their data source.§ GUI - Visual Basic, C, Cobol§ Database - Sybase, DB2, T-SQL, SQL, MS Access, Brio, OmniServer, Lotus Approach§ DBA - Sybase, OmniServer, DB2§ Web - HTML, XML, JavaScript§ Scripting - Perl, UNIX/AIX, VMS§ Reporting - SQR, Crystal Reports, MS Excel, Lotus 123§ Config Mgmt - SCCS, CMS, Continuus, SE Select Show less

Responsible for developing report processess for the LIBRA Billing database and provided analytical analysis to business community.Responsible for data modeling, replication strategies, triggers, stored procedures, ETL processess for the Product and Service and TNC Data Capture database environments..Responsible for backend development and reporting processes for the Product & Service Catalog. Also was involved with development of the GUI application.§ GUI - C… Show more Responsible for developing report processess for the LIBRA Billing database and provided analytical analysis to business community.Responsible for data modeling, replication strategies, triggers, stored procedures, ETL processess for the Product and Service and TNC Data Capture database environments..Responsible for backend development and reporting processes for the Product & Service Catalog. Also was involved with development of the GUI application.§ GUI - C, C++§ Database - Sybase, MS Excel (VBA), SQL, SQR, WebSQL§ Web - HTML§ Scripting, UNIX/AIX, Perl, JavaScript Show less

Created desktop applications to assist Relocation Specialists with tax and financial calculations.Responsible for developing SAS queries/reports.Responsible for the maintenance/support of DataEase and FoxPro tax/financial databases.§ SAS, MS Query, MS Access, MS Excel, VBA, DataEase, FoxPro

Developed bar code driven Calibration and Metrology Databases. Designed multi-media database for the Igor I. Sikorsky Archives. Prepared obsolete computers for donation too needy school systems.§ MS Access, Visual Fortran, Borland Pascal w/ TurboVision

As a member of the UB Cooperative Education Program, I was assigned to Sikorsky Aircraft as a Software Engineer which evolved into a fulltime position. My responsibilities were as follows:Assisted Simulation Labs, designed Audio Patch Panel and Time Code System for Facilities Lab, developed Source Code Control System for SUN Platform, developed simulation software components.Maintained configuration management database, developed Software Tracking and Cost Account databases… Show more As a member of the UB Cooperative Education Program, I was assigned to Sikorsky Aircraft as a Software Engineer which evolved into a fulltime position. My responsibilities were as follows:Assisted Simulation Labs, designed Audio Patch Panel and Time Code System for Facilities Lab, developed Source Code Control System for SUN Platform, developed simulation software components.Maintained configuration management database, developed Software Tracking and Cost Account databases, spreadsheet and presentation graphics work.§ Fortran, UNIX, C, MacDraw Pro, MS Excel, MS Word, 4th Dimension Show less

As a member of the UB Cooperative Education Program, I was assigned to Norden Systems as a Research Engineer. My responsibilities were as follows: Assistant to Radiation Test Engineer; maintained radiation test databases, translating radiation test data, preparated parts for radiation tests, researched part information, created test reports, presentation graphics work.§ Lotus 123, dBase 3, MS Excel, MS Word

As a member of the UB Cooperative Education Program, I was assigned to IBM as a Field Engineer. My responsibilities were as follows: Diagnosing, repairing, and upgrading IBM PC's, printers, plotters, and miscellaneous system hardware; maintained an inventory of parts; produced regular reports to the National Repair Division.

As a member of the UB Cooperative Education Program, I was assigned to IBM as a Computer Operator and Junior Field Engineer. My responsibilities were as follows:Printing daily reports, checks, invoices on specialized network printers; 6670 system support; system backups; HW/SW inventory for Hamden site (Lotus 123); VM/PC HW/SW problem determination; customer assistance Hotline; Maintenance of system printers, tape drives; Resolved networking issues; Presentation graphics work (MS… Show more As a member of the UB Cooperative Education Program, I was assigned to IBM as a Computer Operator and Junior Field Engineer. My responsibilities were as follows:Printing daily reports, checks, invoices on specialized network printers; 6670 system support; system backups; HW/SW inventory for Hamden site (Lotus 123); VM/PC HW/SW problem determination; customer assistance Hotline; Maintenance of system printers, tape drives; Resolved networking issues; Presentation graphics work (MS PowerPoint) Show less