James (Jay) Buckley

Experience

• 

  Massachusetts Supreme Judicial Court

  May 1992 - Sept 1999

  Procedures Clerk

  Serve the needs of the public and Bar. Case management. Serve the directives of the Clerk of Court

• 

  MICROS Systems Inc

  Sept 1999 - Jul 2001

  Sr. System Architect

  Database Systems ArchitectDatavantage Corp (formerly The XBR Company) specializes in security, loss prevention monitoring and customer analysis for Retail organizations. The software would mine through Retail Point of Sale data to identify patterns of employee or customer theft or purchase patterns. • Managed Implementation Specialists. Product field implementation and support of technical issues. • Define and implement standardized installation process and procedures to enable accurate and repeated deployment for the company’s newly released systems. • Engineer ETL solution and job control systems to gather and load daily line item (POS) Transactions into a RDBMS based analytical system.• Performed daily troubleshooting of UNIX, NT, and databases through remote access.• Deploy maintain development and test database system including Oracle, UDB, MSSQL. • Design/Deploy ASP solution including EDI method to collect POS data. Show less

• 

  SAS

  Jul 2001 - Aug 2007

  Sr. Database Systems Engineer

  SAS Institute, Professional Services Department, Wakefield, MA June 2001 - September 2007 Retail BI Reporting Consultant / System Engineer- Retail ReportingSAS is the world’s largest privately held software company. SAS leads in business intelligence and predictive Analytics. • Responsible for the deployment scoping document deliverable, including assumptions and downstream project tasks. • Customize and deliver demonstrations. Onsite product demo. Load customer data and prepare, package, script demos. • Deployment and Administer Retail Consulting Group’s training and development systems including Windows, AIX, SUN Solaris. • Architect solutions on varying platforms. Design systems considering server workload, OS specifics, RAM/CPU, processing window, and user load. • Installing and maintain consultant databases Oracle 9-10, MSSQL 7-2005, DB2 6-8. • Oracle/DB2/MSSQL Schema design, trigger and stored procedure, optimize queries and database access. • Research and provide direction on database architecture including partitioning and fail-over. • Provide direction and methods for optimizing current production databases, Provide advice and support to customer DBAs, and migrate schema from older to newer versions (oracle 8->10, DB2 6-8, MSSQL 2000->2005). • Responsible for full lifecycle of Enterprise SW implementations: pre-sales scoping to layout of system hardware, implementation of data integration and SW, to successful handoff to Support. • Develop methodologies and training materials. • Work in integrated Sales and Services selling team. • Provide initial budget figures for hardware, SW licensing, and resource management.• Professional Services System Engineer. Show less

• 

  Cellsignal Technology

  Feb 2007 - Nov 2010

  Business Intelligence

  Business Intelligence and Reporting EngineerCell Signaling is a 400-employee life science company active in the field of applied systems Biology research, the primary Business intelligence analyst's responsibility is to support all reporting needs. Apply best tool for the specific reporting needs from enterprise, self-service and published reports via Oracle Dashboards or Crystal Reports.Reported to the manager of business systems. The hiring directive was clear:Stabilize the current based reporting system built on Crystal and establish a corporate wide enterprise level BI system. • Extend the system to its fullest ability with enhancements and additional interfaces to decide if it can serve the company’s growth. • Determine feasibility and mange the endeavor to replace Epicor reporting with Oracle ERP/OBIEEin place of Epicor. Converted their legacy based reports to oracle OBIEE.• Support the reporting needs for over 100 sales, marketing and scientist by providing adhoc, dashboard, enterprise reporting and other analysis tools.• Reports supported by MSSQL and Oracle on primarily Linux servers. • Author the BI road map to take the company’s strategy for extending the current reporting system to Oracle OBIEE.• Manage requirements and corrections to the enterprise reporting system and reviewed trends in adhoc reporting that are better served by a new enterprise report.• Model and deploy a royalty tracking system to meet financial liability for patent uses -• Support electronic regulatory filing and fraud prevention systems -Deployed a cross-platform consolidated reporting dashboard suite.• Design and deployed the supporting Crystal Report metadata with focus on template re-usability, Maintained security and access structure.• Beyond the traditional sales and performance report I designed royalty payment report to determine financial liability for patent licenses. Show less

• 

  Datajus Systems

  Nov 2011 - May 2014

  Primary Consultant

  Recent Applicable Database/Reporting Engagements:• Corindus/Workforce Extended (10/6/2013 - 2/6/2013): A small medical device company. Recent ERP installation. Successfully Design and deployed reporting to provide them same access to their data of data as the largest corporations. Design and deploy regulatory and compliance reporting.• Ventura (8/1/2013 -10/01/2013): A European technology incubator. Design, deployed, and populatedan oracle database system to store electric device information and associated support services. • Farsis (6/1/2013 -8/1/2013): Canada based business service company: Construct oracle schema to store used medical devices data and specification to support online store. Constructed reporting tovisualize data captured and to analyze various level of support provided for each item and productgroup. Systml built on mysql, python and tableau_• South Shore Landscaping (12/15/2012 - 4/20/2013) - A medium size light construction firm. Converted their Access database to oracle and supporting reporting with Oracle DBI. • Designed and deployed 6 instances of the Datajus small business and startup turn key BI reporting systems using open source R and tableau.• Deployed 6 ecommerce sites and associated backend inventory system supported by Mysql, MSSQL, and Oracle. Show less

• 

  McKesson

  May 2014 - Sept 2016

  Sr Support Engineer
• 

  Magnitude Software - insightsoftware

  Sept 2016 - now

  Sr Application Engineer