Data Architect Resume

TECHNICAL SKILLS

Proficient: Python3.7, PL/SQL, AWS, Bash, Jupityer Notebooks, Spyder, Pandas, Sci - Kit Learn, S3

Exposure: Objective C, Java, T-SQL, Talend

Have used: Tableau, SSRS, SSIS, Glue, pySpark, Boto3, CLI

Additional: Microsoft Office, Visio, Erwin, LucidChart, Slack, GitHub, Jira, ArgoUML, Snowflake, DynamoDB

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

Developed predictive models for retail grocery distributors to predict case quantities of orders without personnel stopping at the store twice a week to take inventory.
Used python and Sci-Kit Learn to develop a series of ML models (logistic regression, linear regression and k-means) that provided improved predictive accuracy using time series, promotional and pricing data.
Deployed in on premise Linux servers and aws Fargate with ECS instances.
Designed and coded data pipeline that created time series-based data features that were critical to improving item accuracy predictions by more than 15%.
Coded pipeline in AWS Lambda functions and state machine.
Developed python APIs to take predicted data and load back to on premise Postgres database as the primary data source for Tableau visualizations.
Supported Tableau creators in creating custom data source aggregations for faster drill downs.
Created file upload and download POC in pySpark and Glue.

Confidential

Project Manger /Analyst

Responsibilities:

Developed mobile order entry system for 1100 field sales users across 650 routes that processed over $2 billion a year in on premise and large retailer orders for a large beverage distributor.
The SLA required less than a 2-minute window between an order beginning transmission and visibility to the IBM host.
Developed wireframe layouts and process documentation for mobile app as well as SQLite physical database design and test data for user stories.
Developed multi - tier event-based data architecture between IBM AS400 file hosts to Linux Postgres cloud servers interacting with SQLite mobile databases and 3rd party API’s.
All interfaces except the API’s were bi-directional and asynchronous.
The design resulted in a higher level of reliability as measured by order loss.
Wrote transformation scripts in Postgres PL/SQL functions., with shell calls from Java programs.
Developed detailed specifications for Java programs and provided trouble shooting and debugging to developers using stack traces and logs.
Developed a message broker pattern replication system to back up to hot backup server.
In the event of a failure to connect, the mobile device would attempt to synchronize with the hot backup server in another data center.
The extra cost of developing this system vs. normal replication was to reduce transactional loss window from 5 minutes to 30 seconds.
Responsible for developing data models, UML object interaction and state diagrams.
Developed a web based Master Data Management change request system for field sales personnel.
Responsible for the process design and interfaces with SQL Server instance inside the VPN.
Did logical and physical design and implemented upload and download polling routines in SSIS.

Confidential

Project Manger /Data Analyst

Responsibilities:

Developed and supported a route sales system for independent distributors that supported a “pass through” pricing structure for the national accounts of the nation’s largest bottled water distributor.
The system was developed in java and Oracle.
Supported acquisitions, mobile sales, routing, order picking and finished goods warehouse system for large beverage distributor.
Modified DEX libraries for large national retailer to accommodate “nested” SKU’s where an item is scanned as one item, but the container is returned as another item for the purpose of refunding the customer.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship