TERESA HIDALGO-FITZGERALD

GOOGLE CLOUD CERTIFIED

Austin, Texas 413-***-**** adwni0@r.postjobfree.com linkedin.com/in/tfitzge134/ github.com/tfitzge134

TECHNICAL SKILLS

PROFESSIONAL SUMMARY:

•Extensive experience in AWS and Google Cloud Technologies.

•Over 10 years of SQL database experience, ETL, DDL and DML and scripts for Data Migration.

•Created Architecture from Scratch using AWS technologies.

•Experience with AWS Lambda/

•Experience with AWS Connect, Direct connect, VPC creation.

•Experience with HTPP, UDP, DNS and other protocols.

•Good knowledge of Google Architectures and Analytics, including GCP Cloud Run, Cloud functions, App Engine, BigQuery, Pub/Sub and more.

•Over ten years of experience in Databases PostgreSQL, MySQL

•Experience with NoSQL databases as Casandra and mongoDB.

•Good knowledge of JavaScript and node.js.

Experience in developing multi-tier enterprise level web applications using various J2EE technologies including JSP, Servlets, Spring, EJB, JDBC, Java Multi-threading API, ORM tools like Hibernate.

•Experience in developing application using Spring Framework that uses features of IOC, Spring MVC, Spring JDBC, Spring Batch, Spring Security and AOP features.

Good Experience in implementing several object-oriented design patterns such as Model View Controller (MVC) frameworks, Front Controller.

•Experience on Apache Kafka, AWS Kafka, Confluent Kafka, and Google Pub/Sub.

•Extensive experience in AWS DevOps, CI/CD pipelines using Jenkins and Liquibase.

•Experience in developing and deploying applications through Tomcat and application servers.

•Extensive experience working with SQL and no SQL databases, as PostgreSQL, SQL, Athena, DynamoDB, BigQuery, MongoDB

•Good knowledge of GIT and Jira.

•Experienced CICD in Gitlab CI and Jenkins for CI and for End-to-End automation for all build and CD.

•Good knowledge of Kinesis, Google Pub/Sub and Apache Kafka asynchronous messaging systems.

•Developed applications using Core Java, JDBC, Hibernate, Java Beans, EJB, spring, spring boot, Web Services.

•Experience in implementing a 'serverless' architecture using API Gateway, Lambda, and Dynamo DB.

•Experience in Citrix virtualization.

•Experience on UNIX, Linux commands and Deployment of Applications in Server using File Zilla and ability to work effectively.

Good in communicating with clients, customers, managers, and other teams in the enterprise at all levels.

TECHNICAL SKILLS:

Programming Languages:

Java 8, PL/SQL, SQL

Java

Version 8, 11

Spring Boot

2.00

JAVA Enterprise Technologies:

Servlets 2.5/2.4, Spring Security, Spring JDBC, Spring Integration, Spring Batch, SOAP, and RESTful Web Services, Hibernate 4.2. JDBC 3.0/2.0, JPA, EJB 3.0, typescript, Angular 10,

Spring Data, Spring Boot, Spring Framework

JavaScript:

Angular JS 4.x/2.x/1, TypeScript

CI/CD technologies

Jenkins, Liquibase

Frameworks:

Spring 3.x/2.x,

Application Servers:

Tomcat JBoss7.x/5.x

Databases:

SQL. PostgreSQL, Athena, Cassandra, MongoDB, DynamoDB, BigQuery

Web Technologies

HTML5, XML, JSON, CSS3, JSP 2.2/2.1, JSTL 1.2, Bootstrap.

Operating Systems

Windows Variants, Unix, Linux, Mac OS

Design Patterns:

Front Controller, Singleton, Observer, DTO, DAO, MVC, Factory, Abstract Factory, Business Delegate.

Design Methodologies:

Agile, Waterfall, Scrum, Test Driven.

Cloud platforms

AWS, Google Cloud

Cloud Technologies

EC2, Cloud Formation, S3, RDS, Athena, Lambda, Step Functions

PROFESSIONAL EXPERIENCE

07/2021 to present Infosys Cloud Data Architect Remote

Infosys Internal Project

•Created a dashboard for analytics using Apache Superset for the AWS and Google SuperSet Project.

•Created datasets and tables for BigQuery

•Created rds. tab le in AWS.

•Used Cloud Watch logs to get resources inputs.

•Used CSS templates to customize dashboard.

•Clean data to be consumed by BigQuery.

Verizon Java Project

•Attended daily ceremonies.

•Created scripts using java.

AT&T Project

•Using AWS Kafka created Topics, Consumer and Producers

•Attended daily ceremonies.

•Use AWS Cloud Watch for Monitoring

Verizon Project

•Implemented Security using Blackbuck and Fortify

•Determined security risks and followed up with teams regarding impact and resolution.

Google 2022 Cloud Workshop Participant.

•Created a cloud architecture using pub/sub, Cloud Run, BigQuery, Cloud Scheduler and Data Studio.

09 2021 to Dec 2021 University of Texas AWS Architect

•Created a Read Only Proxy for Athena DB

03 2021 to July 2021 Revature Full Stack Java Engineer

Project Cosmogram

•Utilized Maven automation tool to build the project's dependencies automatically.

•Worked with Hibernate mapping tools to build Cosmogram to map the database.

•Created Cosmogram's deployment process for the cloud using AWS technologies.

•Worked with the front-end to ensure the endpoints were working properly.

Tested the RDS connections between host and clients.

•Updated and installed on EC2 required software for the deployment. Established the AWS AIM permissions for our team to access the AWS console.

•Attached the S3 full control policy to the S3Cosmogram role to leverage communications between S3 and EC2.

•Built a GitHub branch to implement source control.

Project Registry

•Worked with Lombok technologies to create the Iteration model Refactored the old IterationServices code to design the

IterationServices.

•Built unit test using junit4 for the Service controller and the IterationServices.

Tested API using postman.

•Utilized Maven automation tool to build the project's dependencies automatically.

•Used GitHub as Source Control

•Collaborated in the build of microservices for the Tracking Systems. Environment / Technologies.

04 2020 to 09 2020 Artistory AWS Architect Consultant Remote

AWS Architecture Project

•Created AWS Inventory of current Architecture and recommended best practice.

•Modified current Cognito code to use authentication token Using AWS pipelines and GitHub integration built a production, staging and development environment.

•Created alarms to notify issues. Created autoscaling group. Created a four stage ci/cd pipeline using CodeCommit, CodeDeploy and Pipeline, lambda. Configured manual approval for deployment.

•Implemented and architecture recovery and backup strategy.

•Built deployment branching strategy.

•Setup Alert and Alarm to notify for changes in configuration. Software Engineer Trainee at General Assembly Immersive, Software Engineer Trainee

12 2019 to 03 2020 Black Diamond LLC AWS Architect

Miso Application Project

•Developed cloud native data solutions for startup within the energy industry.

•Created Lambdas to extract raw data and upload to S3 buckets.

• Partitioned data in S3 to maximize the efficiency of Athena queries. Designed AWS Glue jobs to update Athena tables on scheduled uploads to S3 buckets.

•Built Athena queries and schemas for business intelligence analysis.

•Utilized lambda glue for the ETL process.

12 2019- 03/2020 General Assembly Immersive, Software Engineer Trainee Austin, Tx

•Created Miso Db final Project using node.js and CSS.

2013 - 07/2019 Kaman Corporation SQL Developer Bloomfield, CT

Data Conversion/Data Migration Project

●SQL/Postgres Developer for Kaman KDGB Distribution Division.

●Created over 500 complex scripts (stored procedures, views, tables, CTE and more)

●Handled migration of over 5,000,000 rows of data to SQL Server.

●Mapped over 5,000 fields from legacy ERP system to SQL Server 2014/2016.

●Built complex queries, functions, and stored procedures.

●Maintained database persistence, clustered and non-clustered indexes for Big Data tables.

●Troubleshooted SSRS Reports issues finding proper solution.

●Created stored procedure parser to search and delete bad string characters among 130 tables.

●Six years of ETL experience. Extracted, Transformed and Load data to destination tables.

●Created and maintained SSIS packages (Microsoft Integration Services).

●Converted and migrated data from different database sources.

●Created relational model schemas for KDGD databases.

●Installed Pro2SQL in Development environment.

2013 ESPN Business Analyst Bristol, CT

●Gathered business requirements, analyzed data, and cleaned data for big data database.

●Created complex views to diagnose data issues.

2001 - 2011 Hampden County District Attorney IT Administrator Springfield, MA

●Developed over 300 complex queries and Stored Procedures using SQL server 2000 and 2005.

●Managed and administrated an SQL database over a 150+ network with four sites.

●Implemented backup and disaster recovery.

●Administered active directory.

●Landesk implementation.

●Installed complex software as Lawson, Landesk Crystal Report and SQL server.

●Implemented Citrix virtualization.

●Administered a network consisting of over 500 computers while maintaining employer’s intranet.

●Used SSAS Mdx queries to extract even that occurred in a hierarchy within the DataMart.

●Designed complex queries and stored procedures.

●Troubleshooted and supported Cisco routers and switches.

●Constructed the SSRS and Crystal Report system, creating over 200 reports.

●Implemented automation systems for the Westfield District Court’s Summons Process.

●Built the Video Evidence Tracking Systems.

●Integrated Hampden County District Court and Hampden County Police Department databases.

EDUCATION

2021.

General Assembly.

Immersive JavaScript Boot Camp

2013

SetFocus Academy

Advanced Business Intelligence Immersive

2001

Westfield University

Bachelor of Science in Computer Information Systems

PROFESSIONAL CERTIFICATIONS

Google Cloud Professional Architect

AWS Certified Solutions Architect

Google Certified Cloud Engineer

AWS Certified Cloud Practitioner

●

Contact this candidate