Sr Data Engineer
Resume:
James M. Stricklen, II
Atlanta, GA 30311
Day/Evening Phone: 414-***-**** Email: *********@*******.***
OBJECTIVE: Seeking a position involving database and ETL development, data warehousing and business intelligence
EDUCATION: Upper Iowa University
Bachelor of Science in Management Information Systems
COMPUTER SKILLS: Operating Systems/Platforms: Windows 3.1, - Windows 10, Windows Servers (2000, 2003, 2008, 2012, 2019, 2022), MS Networking for Windows, TCP/IP
Languages: SQL, Transact SQL (T-SQL), Visual Basic, Visual Basic.NET, C#.NET, C++, HTML, ASP.NET
Software: MS Office (97-365), MS Teams, MS Visio, MS Project, MS SQL Server (7,2000, 2005,2008,2012,2014,2016,2017,2019,2022), (Reporting Services (SSRS), Integration Services (SSIS), Management Studio)), Visual Studio (5,6), Visual Studio.NET (2002-2022), MS Team Foundation Server, GIT, Azure DevOps, Symantec Encryption Desktop, Vault, MS SharePoint, Adobe Photoshop, Adobe Acrobat, Information Desktop, Information Desktop Scheduler, Document Direct, Monarch, Internet Applications, E-Mail, etc.
TECHNICAL EXPERIENCE: Acquired Skills:
Designing and developing applications, databases, and reports
Data transfer, manipulation, and extraction (DTS, SSIS, T-SQL, VB.net, C#)
Online Transactional Processing (OLTP)(MS Access, SQL Server, DTS and SSIS)
Working in Agile Environment
Designing and developing websites
Data analysis
Working with Source Control Tools
Creating programs/applications to achieve automation
IT experience in the banking, retail, health care and insurance industries
FTP site setup using IIS
SFTP site setup using JSCAPE
File and data encryption
Software and Hardware installation and repair
Project management
Managing people
Systems Analysis and Design
End-user training
Windows Server Administration
IT Consulting
WORK EXPERIENCE:
February 2023 – Present CVS, Atlanta, GA
Position: Applications Developer
Upgrade Data/SQL Server Project (from 2014 to 2019)
T-SQL development
C# ETL Development
SSIS Package development and migration to latest version
SQL Server configuration
December 2021 – September 2022 Fatbrands, Inc, Beverly Hills, CA
Position: Sr. Data Engineer
Design, develop, data map, and tested extract, transform, load (ETL) and data migration processes, applications, and solutions using SSIS, MS SQL Server, VB.NET, C#, T-SQL, and Web Services/API from many sources to many destinations
T-SQL development
Stored procedure development
Database and data warehouse architecture, design, and development
C# ETL Development
Data Mart development
PowerShell script development
SQL Database development
SSRS Report Development
Azure DevOps Source Control
March 2020 – December 2021 Active Minerals International, Macon, GA
Position: Sr. Database Developer
Design, develop, data map, and tested extract, transform, load (ETL) and data migration processes, applications, and solutions using SSIS, MS SQL Server, VB.NET, C#, T-SQL, and Web Services/API from many sources to many destinations
Stored procedure development
Database and data warehouse design and architecture
Data Mart development
Created and monitored customized database backup/recovery
SQL Database development
SSRS Report Development
MS Teams Collaboration and Communication
Managed 3rd Party Contractors/Developers
Database and IT support using ZenDesk
Database Support and Maintenance
January 2020 – March 2020 Huddle House/Perkins, Atlanta, GA
Position: SQL Database Developer
Design, develop, data map, and tested extract, transform, load (ETL) processes, applications, and solutions using SSIS, MS SQL Server, VB.NET, C#, T-SQL, and Web Services/API from many sources to many destinations
End to End Database development using MS SQL Server, T-SQL
System integration
File encryption development
Stored procedure development
November 2010 – January 2020 HSA Bank, Milwaukee, WI
Position: Applications Developer
Design, develop, data map, and tested extract, transform, load (ETL) processes, applications, and solutions using SSIS, MS SQL Server, VB.NET, C#, T-SQL, and Web Services/API from many sources to many destinations
End to End Database development using MS SQL Server, T-SQL
Application development using VB.NET and C#
Member of pilot Agile/Scrum team for the organization
FTP/SFTP Site setup (IIS)
File/Data encryption and transfer using Symantec encryption desktop, VB.NET, and SSIS
BizTalk development
Implementation Plan writing
Application Deployment
Technical documentation
Utilized Team Foundation Server (TFS) for all source control and work flow
May 2018 – January 2019 Configero, Atlanta, GA
Position: SQL Data Warehouse Developer
Handled all phases of Data Warehouse and SQL database development (SQL Server 2014)
Designed process to automate and load data in numerous formats from users in countries around the world into centralized data store (SSIS 2014)
Analyzed and corrected inefficient queries, ETL and data processes
Prepped data for Salesforce user interaction/manipulation
Requirements gathering
November 2016 – May 2018 Provectus Health Strategies, Atlanta, GA
Position: SQL Server Database Developer
Design, develop, map, and tested extract, transform, load (ETL) processes, applications, and solutions using SSIS, MS SQL Server, VB.NET, and T-SQL, from many sources to many destinations
Coordinated all phases of data implementations from numerous external clients
Data/System integration
End to End Database development using MS SQL Server, T-SQL
Automated/Developed numerous processes using SQL Server, SSIS and VB.NET
Data Cleansing/Manipulation
Data Analytics and research
Data Auditing
FTP/SFTP Site setup (IIS)
May 2010 – November 2010 WageWorks, Mequon, WI
Position: Product Support Engineer
Design, develop, tested extract, transform, load (ETL) processes using SSIS, VB.NET, C#
Research and make technical recommendations on current and
new processes within IT Department
Design and support middle tier solutions using C#
Full life cycle SQL Server database programming, development,
and support
November 2006 – April 2010 DentaQuest, Mequon, WI
Position: IT Consultant/Programmer Analyst II
Make technical recommendations on current and new processes within IT Department
Analyze technical documents
Design, develop, and test processes, databases, and applications (Windows and Web based)
Design and develop Extract, Transform, Load (ETL) processes
Reporting from multiple sources (Excel, SSRS)
November 2004 – November 2006 Kohl’s Corporation, Menomonee Falls, WI
Position: Retail Credit MIS Assistant Manager
Managed a group of information system professionals
(Business Analysts, and MIS Team leads)
Managed a Production Support area
(Scheduling, payroll, attendance, and employee adherence)
Project manager
June 2003 – November 2004 M&I Bank, Brookfield, WI
Position: Information Systems Manager
Managed a group of information system professionals (business/system analysts, IS auditor, and auto dialer technicians)
Presented monthly 52 page booklet summary of retail assets to upper management
Developed Budget control
Presided over various projects
July 2001 – June 2003 M&I Bank, Brookfield, WI
Positions: Systems Analyst, Business Analyst
Analyzed and designed process flow for new programs/applications, systems, and databases
Administered low-level security and rights to file server of entire site
Security Administrator to users in SQL Server 2000
Backup Windows 2000 server administrator
Responsible for reporting on $7 billion in bank assets and $3 billion in 3rd party assets
Downloaded and processed data daily in MS Access and MS SQL Server 2000
Provided analysis on deposit, loan, lease, employee, and customer information data to improve reporting, delinquency, productivity and decision making by management
Developed and maintained new applications in MS Access, MS SQL Server, and Visual Basic for Applications to increase speed, efficiency, accuracy, and security of day to day processes
Trained users on use of new and existing databases and applications
May 2000 – July 2001 M&I Bank, Brookfield, WI
Positions: Loan Collector, Specialty Analyst
Skip tracing for the entire site
Handled all insurance claims on damaged and totaled vehicles and property
Handled credit disputes on loans
Verified insurance on vehicles and property
Collected on delinquent loans and leases
Provided customer service
ORGANIZATION EXPERIENCE: Member of:
Phi Beta Sigma Fraternity, Inc. – Alumni Member, current
References Available Upon Request
Contact this candidate