Data Engineer Integration

Monty Suggs

Phone – 832-***-**** Email – *****.******@*****.***

PROFESSIONAL SUMMARY

Solution-driven Data Engineer with 12 years of proven success utilizing ETL data management tools. Proficient at large-scale data ETL with strong analysis, problem-solving, and decision-making skills. Seeking to use proven real-time data integration, processes, and production techniques in an evolving and cohesive environment.

SKILLS SET

●ETL (Extract, Transform, Load)

●JIRA project mgt.

●SSIS Integration tool

●Data integration

●Database Administration

●Informatica Tools

●Oracle Database scripting

●Script debugging

●Optimizing Batch jobs

●Pro-tunning SQL scripts

●Star Schema

●Excel power user

●SQL Plus scripting

●Snow-flake schema

●Agile environments

PROFESSIONAL EXPERIENCE

Appddiction Studio, LLP 2024 to Present

Database Administrator

Govt-Project GFM- Airforce

Global Force Management (GFM)

●Managed and optimized database operations to enhance efficiency and data integrity.

●Executed data migrations across various cloud database instances, ensuring seamless transitions.

●Successfully upgraded Oracle databases from version 19C to 21C, enhancing system performance and capabilities.

●Configured and deployed RDS instances within AWS cloud environments, streamlining database management.

●Authored and maintained Jira stories/topics to document and manage database changes.

●Revised and updated database policies to promote database normalization and compliance.

●Provided daily updates and reports to the Project Management Office, keeping stakeholders informed.

FEMA - Crisis Management Services (CMS)

●Cloud RDS Implementation Engineer: Conducted thorough database analysis and pre-migration preparations.

●Migration Advisor: Designed comprehensive migration plans and communicated strategies to stakeholders and project management teams.

●Database Management: Oversaw the migration of on-premise data to AWS cloud instances, ensuring data integrity and minimal downtime.

Accenture Federal Services, LLP 2022 to 2024

Data Analyst Operations Analyst

●Correlated complex financial datasets into high-level visuals and communications for nationwide distribution.

●Created various Visual Dashboards in Power BI for various financial and operational departments.

●Developed and implemented department-wide quality control measures.

●Performed in-depth data validation on data from worldwide suppliers.

●Maintained communication with the Sales Lead Manager, Department Leads, and internal clients.

●Administered data inventory management practices and developed new strategies on demand.

●Performed daily operations reports on performance and recommended actionable improvements.

●Created procedures and protocols for functional operations standards and requirements.

●Communicated and coordinated with employees (including the executive operations team) and vendors.

●Presented data models to the business team for review.

●Assisted the operations manager in developing and planning operational leadership meetings.

●Performed detailed data validation spanning multiple sales opportunities.

•Recommend new procedures for increasing the efficiency of day-to-day operations.

•Proficiency with Microsoft Excel and other productivity applications and platforms.

•Onboarded and trained new employees to ensure adherence to standard operating procedures.

Monty Suggs

Accenture Technology, LLP 2019 to 2022

ETL Developer Migration Engineer

●Proficient in the integration of various data sources with multiple relational databases like Oracle11g/Oracle10g/9i, Microsoft SQL Server, DB2, Teradata, ODS, and Data Marts.

●Transform and migrate data from CalSAWS and CalACES legacy systems to Leader Replacement System (LRS) the largest system of its kind nationwide.

●Design, build, manage, and optimize data structures like data transformation, data models, schemas, metadata, data quality, and workload management.

●Proficient skill set with various ETL tools including Oracle, SQL Plus, SSIS, DataStage, PostgreSQL, MySQL, and Microsoft SQL Server.

●SSIS integration tool, to migrate flat files from different sources to the target location.

●Created a Master Orchestration process used to upload SQL query packages into Jenkins via pipeline plug-ins.

●Perform root cause analysis and provide feedback to the county administrators.

●Excelled in multiple projects such as research, extraction, conversion, brainstorming, documentation, and troubleshooting in an agile team environment comprised of multi-tier management.

●Research, document, and migrate ETL processes to populate the data warehouse.

●Performance tuning of SQL queries to reduce production times; most notable reduction of time by 75% of > 2 million records.

Remarkable Technology Group, LLC 2014 to 2019

Informatica Developer / ETL Developer

●Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.

●Created mappings to load target data using Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters, and Sequence transformations.

●Established reusable, auditable, and high-quality ETL queries that could be leveraged across all data warehouse layers.

●SSIS integration tool, to migrate files from different sources to the target location.

●Developed Oracle views to identify incremental changes for full extract data sources.

●Coded, assessed, and implemented ETL mappings and SQL scripts in the Oracle environment to build and maintain ETL processes.

●Extensive in Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with project scope, Analysis, requirements gathering, and data modeling.

UPS, LLC / UPS FREIGHT, LLC 1995 to 2014

Data Analyst Manager

●Operations Manager UPS Freight LLC. From 2006-2014

●Operations Manager UPS LLC. From 1995-2006

●Performed database analysis for reduction and proofing before transfer and loading in the new repository.

●Managed a team of seven analysts to provide data analytics for the logistics department.

●Created multiple processes that provided database input error reductions, redundancy, and overlapping issues, increasing input time by 30%.

●Improved user interface time and comprehension using workflow processes, resulting in new operational procedures.

EDUCATION

●MS. Data Analytics, Expected 2027

●University of Houston, B.A. Information and Communications Technology

AWARDS

●Migration team Leaders for the life cycle of the project

●Early or on-time deliverables (5 months consecutive)

●80% production success on conversion implementation data

●Data Input Conversion for Supply Chain, Project of The Year

●Most innovative U.S. users of business technology (InformationWeek 500)

SECURITY CLEARANCE

Public Trust (Current)

United States Army, Veteran: Honorable Discharge

REFERENCES

Upon request

Contact this candidate