Ray Hogan Email & Phone Number

Branchburg, Nj, Us

This multi-discipline project is to add monitoring of Model Railroad trains in order to alert operational staff when there is a derail. A Raspberry Pi and infrared sensors are used to track train regularity and report to an EC2 server. A web page front end shows current train status. The Raspberry Pi and AWS server both use Ubuntu, the database is SQLite, Python and wsgi is used on the Raspberry Pi and AWS server. Nginx is the web server. The web front end uses Bootstrap, and jQuery. The project also includes a decent amount of electronics including circuit design. The project was also suffering from lots of EMI (Electro-magnetic interference) which has been solved using a cocktail of electronic solutions. On this project, I created the idea, architecture, wrote the code, built the circuits, climbed ladders to install sensors, installed the software infrastructure, modeled the Database.... basically everything except some running of wiring. Cause that's what I do.

Consumer Products.Actively developing or marketing 4, commercial products for license to manufacturers. Create and refine physical prototypes, Develop marketing collateral (Sell sheets), file patents, and contact companies for interest. Products are currently in the Fishing, Houseplant, Hair care and Book accessories industries.App DevelopmentCurrently developing a cross platform mobile App for the sports industry. I'm using Xamarin, C#, JSON, Firebase, Google Fused Location Provider, JSON, MySQL Node.js, Express, Vue.JS, Bootstrap. Expect Beta by End of April 2018.Web Based Charter School Lottery Registration SystemConceived, architected and coded a PHP, MySQL, Bootstrap and jQuery SSAS public-facing system for taking registration information and presenting results of a student application lottery. Includes administrative screens for managing the data, data cleansing tools for detecting duplicate registrations, Duplicate registration detection and per-class statistics. System sends email confirmations to applicants and manages a wait list based on student acceptance/declining. Hosted on AWS Ubuntu.Home Automation with NodeJS - IoT - ArduinoDesigned and built an electronic/software system for acquiring temperature, humidity moisture and other sensor data. This project uses NodeJS running on a Ubuntu Netbook to poll Arduinos with Zigbee mesh network devices and triggers sensor data acquisition. Logs the sensor data to a SQLite database for later replication to a web copy of the database. Charting is done with Google Charts. Xbees are run in API mode and power is managed by entering sleep mode. Byte level messaging in hand coded Javascript.

Family BusinessMarketing:I do all digital marketing, social media, PPC and SEO. I built and maintain the website in Wordpress including some custom theme work. I write, optimize and manage Google Adwords advertisements. Write blog posts, landing pages and other website content and produce/edit videos of acupuncture. Provide operational support of telephones, computers and repairs of offices.

Charlotte, Nc, Us

Working as a composite Agile Product Owner and cross discipline "gap filler" in the Anti-Money Laundering technology area. I collaboratively develop requirements for a Business Intelligence and Analytics project related to AML oversight and administration and work with the team to insure a common vision of the deliverables. Participate in all Agile ceremonies including Scurm of Scrums, Retrospectives, PI Planning etc. Working in a scaled Agile environment (SAFe),

IT Product Manager for internal data collection tools. Worked as a product owner on improving a data entry, UI builder product. Aggregated and synthesized product requirements into user stories and a managed backlog for development in an Agile/Scrum environment using JIRA. Personally coded a Prototype Business Rules Engine in Python running on Microservices.

Yorba Linda, Ca, Us

Solutions architect on the presales side. Model customer data, produce proof-of-concepts, develop slide decks and deliver technical presentations to prospective clients. Company was intending to expand to the east coast and changed strategy.Built 10 advanced reports for a Major Bank in Cognos 10.2.2 against OLAP and relational data for regulatory review of Allowance for Credit Loss (ACL) reporting with amounts exceeding $1T. Ideation, architecture and UI design of a Cognos 10 report performance assessment and diagnostics tool.

New York, New York, Us

Advanced Cognos 10.2 Report development. Custom application creation in .NET (C# and VB.NET), Cognos training. Build significantly complex reports for IT Infrastructure.... Incident, problem and change management. These reports typically were multi-query reports that implemented a complex query strategy. The underlying data was from ServiceNow. The ServiceNow database is an Object-relational design and had several design implementations that produced reporting challenges. Notably was columns with comma separated foreign keys.Netbackup Reporting Portal - Application - Primary developerThis .NET/PERL web application reduced the time to configure a backup from 30 minutes to less than two. Notable also was that the process went from group assisted to self-serve/self diagnostic. The portal did a battery of connectivity and configuration tests for a given host and reported readiness for configuring backups. If all tests passed, the backup was configured under full automation. A UI highlight and my innovation was to perform all tests and present the current state of each in one session. Also gathered application usage information for later application enhancement.ModelingDid relational and OLAP modeling with Framework Manager including aliases, avoiding reporting traps and other modeling challenges. Built cubes using SSAS and Cognos TransformerCognos Training. Trained over 700 Citi employees mostly virtually/hands on in Beginning and Advanced Cognos reporting. Cost savings of greater than $200K. Taught about 40 non-departmental Citi employees in NYC and Tampa the 3-day classes saving that organization $40K vs an IBM quote.Run lunch & learns to greater than 1,000 attendees in ServiceNow reporting.Managed External Vendor relationship for a data feed project.Consult with other groups and external vendors on implementing data feeds into their systems, using a home grown feed mechanism. Write complex custom SQL in support of the feeds.

Somerset, New Jersey , Us

This was a classic consulting company. I was assigned to Coach in NYC. Here I built advanced Cognos Reports and database solutions for product management and distribution. Designed a star schema and worked with offshore developers to create the ETL to report on distribution details from a commercial distribution management system. Enhanced several Cognos Reports with Javascript.The underlying database was an object oriented database.We built an interface that produced an XML output via a web call and Cognos consumed the XML file as a source.Managed 2 Junior Cognos Developers and guided offshore team to fulfill requirements.Interviewed technical candidates (including a few fraudulent ones) .Working with XML in Cognos had one significant challenge ... investigating the queried data. When troubleshooting report problems, one often runs SQL queries against the underlying database to determine if the problem is in the report or the data. Doing this was impossible because the underlying Database was Object oriented. To solve this problem, I built a tool to parse the XML and insert the rows into an Oracle database so SQL could be run on the same data consumed by the report.

Ca

Taught customer facing hands on classes in all aspects of Cognos Business Intelligence tools. Beginning and advanced reporting, beginning and advanced modeling, OLAP cube creation, Server Maintenance. Highly rated instructor. My core skill is in not teaching from the book but instead teaching what you should do with Cognos, not what you can do (as the manuals often did). Beyond my official duties and self-initiated, I conceived built several process improvement systems related to training. Training Manual Inventory Management System (Web based - PHP ,SQL Server)I noticed that most had a significant inventory of unused and dated training manuals.The idea for this system came about when I saw an admin discarding hundreds of dated manuals to clear space in the training room. So I built a PHP based web application where individual offices could maintain their inventory of manuals per class and central admin could check the inventory before sending manuals to cover a particular class at a particular location. $25+ per manual and 25 training locations was the spark I needed to conceptualize the application. This system saved approximately $50,000 per year in printing, shipping and waste. Particularly costly manuals included on demand printing at Kinkos and cross border overnight shipping. All eliminated.Unified Certificate Printing. All Certificate printing was done locally after the class.Here again, a process problem. I noticed that different offices used different names of classes, had alignment problems, used different fonts and sizes etc. Sometimes there were alignment problems. Basically unprofessional. So I conceived and built a web-based system that allowed admins to past in a list of attendees and pick a class, and the code would essentially mail-merge the data into a rendered PDF for consistent look and feel. One interesting part of the system invoked font size reduction for exceptionally long student names.

Full entrepreneurial experience including class Sales, Marketing, class schedules and content, demonstrations and public speaking. Taught hundreds of students from age 5 to 60.

Princeton, Nj, Us

Created one-off technical solutions for Genetic researchers. Devices were cross-discipline and included custom software, hardware, and circuit-level electronic designs. Created a sleep-deprivation generator, physical location to brain activity correlation device, cross application instrument automation macros, Low-level MAC graphics programming in C, Video Processing, robotic motion control, Motor control and more.

Highly reviewed instructor teaching people web development leading up to the Dot Com collapse. Ran classes of 18 people, many with no technical background in learning Hand coded HTML, CSS, Website construction, PERL, Dynamic content creation, Server setup, Visual Basic. Sent in to several "disaster Classes" to recover potential lost income and damaged reputation (and succeeded)

Dallas, Tx, Us

Telephone Switch development (Merlin). Wrote a digital protocol dis-assembler for switch and handset development in C. This software/hardware solution sniffed messaging between the switch and handset and decoded the bit-level messages and then translated them into readable messages for diagnostics and troubleshooting.

Assisted integrated circuit design engineers in producing CMOS RAM, ROM, EPROM, and other devices. Circuit level troubleshooting (under microscope), automated circuit analysis, technical data collection, assembly language test programming (1802 CPU), and other engineering related tasks.

Master’S Of Science, Information Systems

Bachelor Of Science (Bs), Electrical And Electronics Engineering - Minor Computer Science