Projects

Earthquakes data stories
Business:
Analyze data that contains historical earthquakes from Romania and the World. Analyzed earthquakes attributes include: time, geographical location, power, depth, type, administrative area (counties, countries, continents).
Responsibilities:
– Import geographical data from shapefiles into MS SQL Spatial database and use geo queries
– Ask data and discovery data stories: build reports, visualize geospatial data with Google BigQuery Geo Viz, build document based on data stories and earthquakes concepts

Personal & CV presentation site
Business:
Web site with various views of personal presentation: biography, cv, media, contact. Link: mihaiadam.com
Responsibilities:
– Develop Proof of Concept for WordPress: install WordPress locally (WAMP) and deploy application in Amazon cloud using Elastic Beanstalk + MySQL RDS managed by cloud
– Add DNS records in Amazon Route 53 to publish the site in internet; Manage site in Amazon AWS using Elastic Beanstalk, EC2, EBS, RDS, SNS
– Manage site at hosting provider using cPanel; request and install SSL certificate for site; add subdomains for mihaiadam.com
– Configure AWS CloudFront to work as CDN for site
– Analyse Amazon logs and Apache access logs using Tableau, Talend ETL and Elastic Stack (Elasticsearch and Kibana)

Employers’ jobs
Business:
Transfer employers data related to jobs offers from excel file into a Microsoft SQL database. Some of the business entities from the project are: Company, Position, Interview, Event, Communication Channel, CV.
Responsibilities:
– Develop Proof of Concept for Talend ETL
– Design database of around 15 tables
– Migrate MS SQL database into Amazon Cloud Aurora database using MS SQL Linked Server and Amazon Schema Conversion Tool

Applications Maintenance
Business:
Applications developed from scratch are further developed for defects and change requests.

Data validation tool
Business:
An accountancy data validation tool. It reads data that came from a source system in csv files, display the data in WEB interface for analysis, corrections, validation, and sends data into another target system using csv files.

Projects management system
Business:
Large application whose purpose is to implement a management system for the flavors projects. A project for a flavor is a business opportunity raised by a customer which results in the development of one or several new formula or in the rework of an existing one.

Centralized security management
Business:
Application that manage the security on database data for multiple applications. User rights are granted on specific values for some types of data (security dimensions).

Fragrance management
Business:
Application that manages fragrances, and communicates with other applications from the organization using SOA approach. SOA implemented with Web Services and ETL modules
Responsibilities:
– coordinate built of standard specifications for custom Service Oriented Architecture
– coordinate Proof of Concept for Web Service framework

Market survey tool
Business:
Application stores surveys data regarding the fragrances and raw materials for fragrances, which are the candidates of the survey. It also offers the possibility to advance search through surveys data

Data quality issues
Business:
Application that collects the data quality issues in other external systems and offers to the user the possibility to fix them. Information comes from other systems into application database.

Predictive algorithms management
Business:
User maintains basic data used for the predictive algorithms that runs in other systems. Data from other systems are imported into application database, so that it can be enriched by those responsible for algorithm maintenance. All algorithms receive as input, a list of fragrance ingredients and their concentrations.

Access rights management
Business:
Application that mange some security accounts that give access rights to all applications in the organization. The system handles the flow of approval for the access rights and also it stores the access rights. The creation and approval flow of the rights is modeled as a process, using the JBoss Business Process Management framework.
Responsibilities:
– Develop Proof of Concept for jBPM; Design and develop jBPM process
– Develop proof of concept for application based on Spring and Struts2

Label printing tool
Business:
Application for managing label printing for some products. The labels are used at the delivery phase, when the delivery companies have to know where to deliver the products.

Project management tool
Business:
Application provides a management tool to manage the projects in the day to day activity. This day to day activity includes the task follow-up, the technical follow-up, budget follow-up and information centralization.

Sales projections and budgets
Business:
This is an application that calculates and manages sales projections and year budgets (from sales). The results are presented customized, depending on each user options.
Responsibilities:
– develop from scratch Oracle PL/SQL procedure to calculate budgets

Customers & Products management
Business:
Application that manage customers and products. Business entities are defined as combinations between distributors, customers, products, countries, salespersons, invoices, etc

Profitability calculator
Business:
Application calculates the profitability for several axis of analysis: customer, geography and some other business entities that are related to company products. The input data comes from human resources department (salaries), financial department (costs) and each department’ monthly activity reports. After the calculations, the information is exported to other systems for reporting.
Responsibilities:
– Database Designer build Conceptual Data Model, Physical Data Model for the business entities with Power Designer tool

Core Telecom
Business:
Application that manages telecom business internals: collection of the call data records, rating and routing the phone calls, interconnection with other carriers, maintain PINs inventory.
Responsibilities:
– Training for core telecom knowledge at the Nobel United States branch
– Working at the Nobel United States branch
– Maintain and develop change requests in WEB application using Java & Oracle

Retails Sales
Business:
Online retail store where customer could buy cards, which are used to make calls to more destinations.
Responsibilities:
– Maintain and develop change requests in WEB application using Java & Oracle

Prepaid Services
Business:
A prepaid phone service that offers many features to company’s customers: rechargeable PINs, automatic recharging, automatic number identification.
Responsibilities:
– Maintain and develop change requests in WEB application using Java & Oracle

Balkanic power reserve market
Business:
Power reserve market application where the participants buy and sell power reserve. This market has the purpose to offer safety supply of energy. If one of the participant countries happened to be in a power energy deficit, he would rely on the reserve that he bought from other countries in the power reserve market.
Responsibilities:
– Business Analyst gather information from business people
– Database Designer build Physical Data Model for the business entities with Power Designer tool
– System Architect build application architecture and detailed application design
– Analyst Programmer build Java&Oracle WEB application using Java server
– Conference presentation of the WEB application

Romanian energy market
Business:
Migration of existing energy market transactional system to a web-based five-tier-architecture. The system used to make a match among the offers and the requests of the market participants, and establish the quantities and prices for each of the participants in the energy market. The participants were the institutions that produce and consume energy at the national scale.
Responsibilities:
– Business Analyst gather information from business people
– Database Designer build Physical Data Model for the business entities with Power Designer tool
– System Architect build application architecture and detailed application design
– Analyst Programmer build Java&Oracle WEB application using Java server

Encrypted messenger
Business:
This is a messenger application (server/clients). It has emoticons and possibility to talk to more people at the same time. The users can keep their private keys in files on a removable disk.
Communication is encrypted with symmetric key (Blowfish), login into server is made with private/public key pair (RSA);

Amazon AWS Mail
Business:
Emails received by Amazon SES in inbox contact@mihaiadam.com, are forwarded to inbox mihaiadam544@gmail.com and taken into Thunderbird mail client on localhost.
Responsibilities:
– The Java application (lambda function) uses AWS SDK and is deployed in AWS Lambda service. The emails received by AWS SES are stored in AWS S3. When lambda function receive notifications from S3, take the emails from S3, and forward them to another inbox, using SES. EML files from S3 are taken into Thunderbird mail client, on localhost, using AWS CLI from Windows batch script.
– Configure AWS services: add DNS records in Amazon Route 53 to route emails for contact@mihaiadam.com inbox; configure SES to receive emails and store them in S3; configure S3 bucket to notify Lambda function; configure Lambda function to communicate with other cloud services; configure IAM security role for the Lambda function; use CloudWatch and SNS to see Lambda function logs and notifications;

Expo companies info

Code:
Github code with AWS SDK usage
Business:
Upload scanned promotional documents, from different exhibitions, into Amazon Cloud. Extract text from scanned documents, and insert it into a database, using Amazon AWS managed services: S3, Textract, Comprehend, Lambda and Aurora. To find insights and relationships in extracted text, the application uses regular expressions and AWS Comprehend built-in machine learning algorithms.
Responsibilities:
– Analyse business for structure of promotional documents and build Physical Data Model of the database.
– Develop Proof of Concept for AWS Lambda service. The Java application (lambda function) uses AWS SDK. The scanned documents are uploaded in S3. Textract takes the picture from S3 and extracts the text using machine-learning algorithms.
– Configure AWS services: S3; Lambda; IAM; Aurora; VPC; SQS; CloudFront CDN

Search face
Business:
Application performs face recognition using AWS Rekognition built-in machine learning algorithms. User uploads his picture and searchable pictures in S3. In a web browser, the user enters application URL including password, and are displayed the user picture and all pictures where user was found.
Responsibilities:
– Develop Proof of Concept for AWS Rekognition service. Develop Proof of Concept for AWS Lambda Internal Extension: the Event Logger. The Java application (lambda functions) uses AWS SDK and is deployed in AWS Lambda service.
– Configure AWS services: S3; Lambda; IAM; DynamoDB

From Unstructured to Structured Data
Application:
From unstructured to structured data
Business:
Unstructured data are the pictures that I took in my travels and exhibitions. AWS AI Rekognition, Comprehend and Translate Services are used, in Java Lambda functions, to extract information from the pictures, and output structured data as JSON in DynamoDB database. Lambda also categorize pictures, and adds in DynamoDB S3 tags, that are used to tag S3 pictures. JSON data and tags from DynamoDB are migrated to MySQL, using Talend ETL, and queried to build a web report.
Responsibilities:
– Develop Proof of Concept for Rekognition Service, Comprehend Service, Translate Service, Security Token Service for cross-accounts communication
– Configure AWS services: S3 to notify Lambda functions; Lambda to add the functions with parameters and layers; DynamoDB NoSQL database to store the JSON response of the AI services (raw & aggregated data), and to synchronize tags to be processed at once for one picture; DynamoDB Stream to communicate insert events to Lambda; DAX in-memory cache service purpose-built for DynamoDB; SNS to distribute and filter events; IAM for application Roles; VPC for DAX usage.

Replay Events
Business:
This application generates events in AWS environment. It is a technical application without a business result. It is used in other applications to simulate the events triggered by AWS inside AWS. The JSON events generated, trigger main application as if it would be triggered by AWS cloud in normal application run (events replay). Object keys that are set into generated JSON messages are taken from S3, and the data for those keys from DynamoDB. Use-cases where this events replayer could be used are: new modules of existing applications, errors for some of the keys when adding application data.
Responsibilities:
– Configure AWS services: Lambda to add the functions with parameters and start the replay using Test feature; SQS to distribute events.