| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Contact InformationStreet Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLELinkedIn Profile: Candidate's Name
ProfilePrincipal Information Systems professional with over twenty years of experience in Database Software Development and Systems Integration. Specialized in full life cycle design and development of n-tier database design with a strong understanding of corporate issues and concerns. Expertise in creating, designing, and implementing solutions for diverse environments ranging from microcomputers to mainframes to cloud architectures.Security ClearancePublic Trust Position Level 5C: Investigation completed 6/2001 (Expired)Secret: Investigation completed 10/1995 (Expired)Professional ExperienceIndependent Consultant South FloridaData/Data Warehouse/ETL/BI Architect03/2002 - PresentDesigned and developed conceptual, logical, and physical data models for various clients.Created and maintained data dictionaries and metadata repositories.Ensured data models complied with organizational data standards and best practices.Collaborated with data architects, data engineers, and business analysts to understand data requirements and translate them into data models.Conducted data analysis to support data modeling activities.Implemented and enforced data governance policies to ensure data quality.Optimized data models for performance and scalability.Monitored and tuned database performance.Documented data models, data flows, and data transformations.Architected, designed, built, migrated, and stabilized Data Warehouse and Data Lake platforms.Analyzed raw, structured, and unstructured data to optimize data sets and entities of interest.Ensured alignment between engineering and analytical activities and shared information about datasets and their contents.Developed and optimized queries for product insights, dashboards, and reporting.Reviewed and troubleshooted reported issues and guided code deployment and tooling.Collette Tours Pawtucket, RISenior ETL Developer/DBA04/2023 - 12/2023Developed SSIS pipelines to load data from various sources into SQL Server and Pivotal CRM.Managed SQL Server performance, optimized queries, and administrated SSISDB.Used Atlassian tools for ticketing and documentation, and migrated projects to Bitbucket.MUFG Union Bank NA Raleigh, NCSenior AWS Data Platform Engineer10/2022 - 01/2023Remediated vulnerabilities for business unit sale using Qualys reports.Verified encryption for AWS and On-Prem servers and ensured secure data protocols.Used Atlassian tools Jira, Confluence, and Service Now for ticketing and documentation.BitBucket was used for SCM.American Credit Acceptance Spartanburg, SCSenior ETL/Data Engineer05/2020 - 07/2022Developed SQL-based solutions and assisted in migration to AWS Redshift.Used AWS services like Glue, S3, Lambda, and managed CI/CD processes with CodeCommit.Mentored developers in CI/CD pipeline processes.Used Atlassian tools Jira, Confluence, and Service Now for ticketing and documentation.The original SCM was BitBucket. Migrated from BitBucket to AWS Code Commit to automate the build, code and deploy process.Lambda and Glue were coded using python v3.x and Boto3.Magic Leap Plantation, FLSenior SQL Engineer/DBA10/2019 - 04/2020Developed SQL solutions and managed multiple SQL Server instances.Maintained vendor relationships, identified tools for data modeling and monitoring.Developed models, solutions on AWS, GCP, and implemented graphDB Neo4j.Lambda and Glue were coded with python v3.x and Boto3.Ryder Miami, FLSenior Developer09/2018 - 10/2019Developed and maintained solutions using Netezza, SQL Server, DB2, and Informatica.Performed code and solution reviews and created Source-to-Target-Mappings.Freddie Mac McLean, VASenior Developer03/2016 - 03/2018Developed solutions for Treasury Departments compliance requirements using SQL Server and SSIS.Designed new data dictionary, logical and physical models with ER/Studio for new sampling database.Created new sampling system, managed Data Model, and provided development support.Florida Power & Light Juno Beach, FLETL Developer03/2015 - 12/2015Developed ETL solutions using Informatica and supported data analysis and modeling.Used ER/Win for managing the data model.Momentum Consulting Corporation Miami Lakes, FLBI Architect10/2013 - 12/2014Led multiple data integration and ETL projects for clients, improving data workflows and reporting accuracy.Provided technical leadership and guidance on best practices for data management and integration.Identified and created relationships with tool vendors like Embarcadero and ER/Studio/Developed and implemented solutions using Informatica PowerCenter and other ETL tools.JM FamilyoWas the ETL Architect, Senior ETL Developer, and PL/SQL Developer for the Southeast Toyota Pathway Project.oCreated High Level Design documents to document the ETL strategy for the project.oCreated PL/SQL packages, stored procedures, functions and scripts to facilitate data extraction where use of the ETL tools were not warranted.oWorked with Power Exchange Change Data Capture, laying out infrastructure requirements, configuring dbMover.cfg files for DB2, VSAM, Oracle, and SQL Server tables and files.oParticipated as part of the team to create a fail-over strategy for Power Exchange, Oracle and SQL Server.oUsed Web Services like the Rest API to extract data.RyderoWorked with team from MCC to identify the tasks to support the VA/SAM replacement system.oInterviewed and identified data migration/modernization vendors/partners. Identified In-Com Data Systems as the best of breed for the VA/SAM project.ADToParticipated in the design and scope of the SM2K conversion project.oDocumented meetings with clients and identified tasks and milestones for MCC participation.oWorked with senior management in costing out the project.Nationwide Investments Columbus, OHSenior Informatica Developer01/2013 - 09/2013Developed ETL solutions using Informatica and Agile development methodologies.Cigna Dental Sunrise, FLInformatica Architect/Data Architect03/2011 - 12/2012Analyzed data models, reviewed ETL procedures, and developed solutions in SSIS and Informatica.Updated and maintained the data model with ER/Win.Confidential Client FLSenior PostgreSQL Developer11/2010 - 12/2010Developed database solutions using PL/PGSQL for a startup.Harris Corporation Palm Bay, FLSenior Cognos Report Developer10/2010 - 11/2010Provided database and Cognos expertise for report migration and development.Bayview Financial Coral Gables, FLData Architect/Engineer11/2009 - 10/2010Developed ETL jobs, T-SQL and PL/SQL batches, and BI reports for SQL Server and Oracle platforms.Florida Department of Transportation Boca Raton, FLBusiness Analyst04/2007 - 09/2009Developed ETL scripts, custom reports, and participated in the creation of a new reference architecture.Hospice for the Palm Beaches West Palm Beach, FLSr. PL/SQL Developer10/2006 - 03/2007Supported the IT departments Web Development group in maintaining and enhancing their web-based application system.Developed and maintained the web-based application using Oracle Internet Application Server, Oracle Gateway Services, PL/SQL, the PL/SQL Web Toolkit, and Oracle Reports.Became the main developer supporting the fiscal (accounting) departments remittance processing, patient accounts, adjustments and write-offs and provided technical support to the other developers.EducationWestminster College; New Wilmington, PA 16172-0001; 1980 1983; Bachelor of Arts, AccountingUniversity of Maryland, Baltimore County; 1000 Hilltop Circle; Baltimore, Maryland 21250; 1983 1984; Bachelor of Science, Information Systems ManagementCertificationsMicrosoft Certified Systems Engineer, 1998Microsoft Certified Professional, 1993Certified NetWare Engineer, 1992Oracle OCP Candidate: Passed SQL and PL/SQL exam, 2001AWS Certified Solutions Architect (in progress)AWS Certified Big Data Specialty (in progress)SkillsCloud Platform: AWSAWS Services: Experience with AWS data warehousing services including Redshift, S3, and RDS.Data Warehousing: Expertise in developing and maintaining SQL Server, Oracle, DB2, and Redshift data warehousing solutions.ETL Processes: Extensive experience creating and managing ETL pipelines using tools like Informatica PowerCenter, SSIS, and AWS Glue.Programming Languages: Proficient in Python, PL/SQL, T-SQL, and VBScript.Database Management: Strong background with SQL Server, Oracle, SQL Data Warehouse and Netezza.Reporting Tools: Proficient in Cognos 8 BI Suite, Crystal Reports, SQL Server Reporting Services (SSRS), and Framework Manager.Data Modeling and Development: Experienced in using tools like Embarcadero ER/Studio, ER/Win, Toad for Oracle, Rapid SQL Pro, Visio.SQL Proficiency: Advanced skills in SQL for data querying, optimization, and manipulation.Requirement Gathering: Proven experience in gathering and analyzing requirements for data integration projects.Enterprise Systems: Experience with enterprise systems such as Workday, Jira, Kanban, or Service Now.Project Management: Skilled in using Microsoft Project for project planning and management.Communication Skills: Excellent verbal and written communicationSource Control Management: Experienced in using tools like BitBucket, Code Commit, Git, SVN, and older source code tools.Documentation: Source-to-Target-Mapping, Data Models, Entity-Relationship Diagrams, Data Dictionary, Governance, Data Stewardship, Specifications, and User Requirements. |
