We provide IT Staff Augmentation Services!

Senior Data Engineer / Dba Resume

5.00/5 (Submit Your Rating)

Moline, IllinoiS

SUMMARY

  • A senior level lead developer / data engineer with analytics, management, and diverse technology experience specializing in SQL Server database design, development, and population.
  • A strong leader with a superior work ethic and a customer focused approach to solving today’s data and software challenges.

TECHNICAL SKILLS

Industry Experience: Financial, Healthcare, Government, Manufacturing, Maritime Shipping, Human Services, Automotive

Development Methodologies: Waterfall, Agile

Development Software: SQL Server Management Studio, Visual Studio, Team Foundation Server, Red Gate Tool Belt, MS Visio, Subversion, TortoiseSVN, Visual Source Safe, Cruise Control, NANT

Development Languages: T - SQL, C#, VB.NET, ASP, ASP.NET, AJAX, HTML, CSS, DHTML, XML, XSLT, JavaScript, MVC, VB Script, Visual Basic 6, JQuery, JSON, LINQ

Databases, ETL, & Reporting Tools: MS SQL Server, MS Access, Oracle, Post-Gres, IBM DB2 SSIS, Informatica, SSRS, Crystal Reports, SSAS, Jaspersoft

Project Management Software: Microsoft Project, Workfront, Jira, Service Desk Plus

Development Frameworks: BIML, .NET Entity Framework, Bootstrap, Splendid CRM

Operating Systems: Windows

PROFESSIONAL EXPERIENCE

Senior Data Engineer / DBA

Confidential, Moline, Illinois

Responsibilities:

  • Architecting, designing,developing, and deploying various SQL Server Databases to support Analytics Data Warehousing activities and Power BI Dashboarding efforts.
  • Designing,developing, and deployingSQL Server Integration Service packages to support Analytics Data Warehouse data pipeline activities and vendor system data integrations
  • Serving as Lead Analytics team Data Engineer providing subject matter expertise and guidance to senior leadership and mentoring junior staff in data modeling, data retrieval, and query performance tuning.
  • Designed, developed, and deployedoperational based SQL Server Reporting Services reports
  • Analyzed and improved previous data warehouse database code and supporting ETL processes

Information Technology Consultant

Confidential, Virginia Beach, VA

Responsibilities:

  • Provided IT Consulting Services to multiple clients
  • Designed, developed and deployedreports in SQL Server Reporting Services
  • Designed,developed, and deployedSQL Server Integration Service packages
  • Designed and developed SSAS solution and star schema database
  • Architected, designed,developed, and deployedvarious SQL Server Databases, .NET web services, .NET web forms applications, and .NET MVC applications.
  • Installed and configured automated build server and source control applications
  • Gathered requirements, performed technical analysis, architected and designed custom solutions, created technical proposals & estimates, and created technical documentation for various client projects
  • Acted as technical lead, mentored junior development staff, and provided guidance to client management staff
  • Participated in build vs buy analysis project and provided technical proposals for custom builds
  • Active participated in projects utilizing both Waterfall and Agile project management methodologies

New Product Development Manager

Confidential, Chesapeake, VA

Responsibilities:

  • Managed multiple teams of developers on various teams. Prepared and performed employee reviews
  • Designed and developed various .NET web forms applications, web services, window services, and SQL databases.
  • Created development standards and procedure for entire IT department and trained staff on standards
  • Worked with deployment teams to document, improve, and streamline deployment process for large enterprise level applications
  • Designed, developed, configured, and deployed new product applications and collaborated with other product development and business teams using AGILE project management methodology

Developer

Confidential, Virginia Beach, VA

Responsibilities:

  • Developed web applications using C#, VB.NET, and SQL Server 2000. Maintain and enhance website. Improved performance of flight planning section of site that used the FAA’s telnet API and added Microsoft Map-Point functionality for locating airports, hotels, etc. Improved failure handling for existing Airport Kiosks.

Consultant

Confidential, Norfolk, VA

Responsibilities:

  • Began upgrade of existing vb4 desktop sales forecasting application to VB.NET.
  • Redesigned this system to work as a web application while adding new functionality as required by the third party client.

Application Support Manager

Confidential, Virginia Beach, VA

Responsibilities:

  • Managed a team 10 developers. Provided support and maintenance for over 80 web-based applications developed in ASP and .NET. Utilized my expert troubleshooting skills to identify enterprise level problems and recommend solutions for applications within the enterprise. Worked closely with Microsoft support teams to identify and resolve complex issues with .NET and IIS. Identify and implement SQL code accessing both an Oracle and SQL Server database in order to increase performance of critical applications.
  • Developed custom ASP applications used by over 4000 automotive websites. Applications included inventory management, inventory display, graphics swapping, event calendar, employment, and site administration shell. Developed custom ASP.NET applications that allow dealers to create and display vehicle rebates and specials. Developed custom ASP.NET applications that displayed statistical vehicle information in a report format using the .NET version of Crystal Reports.

Analyst

Confidential, Virginia Beach, VA

Responsibilities:

  • Developed ASP 3.0 pages for a web based searchable document library. This project used Oracle 8i as a backend database. Co-Project Manager for The Confidential .com. Analyzed requirements, established a project schedule, and designed the SQL Server 7.0 database.
  • Modified the existing access 2000 database that is utilized to gather information remotely and later uploaded to the website. Web site provided functionality for remote users to perform specific administrative tasks based on their system identified position.
  • Worked as a developer to convert several Access 97 database programs to a web based application. One highly secure program is utilized to manage the security clearances of personnel within Titan Systems, while another manages contract information. Utilized ASP 3.0, SQL Server 7, SQL DTS technology, and secure certificates.

Application Programmer

Confidential, Virginia Beach, VA

Responsibilities:

  • Created a VB 6 application that imported data from various sources, checked account number formats, formatted data for transmission to Confidential, and parsed the results returned from the Confidential system. This system processed over 25 million dollars in credit card payments yearly.
  • Later modified the system to process proposal information electronically, an industry first. Responsible for transferring funds to Confidential for disbursement. Responsible for maintaining and modifying the Debt Management System (DMIS) utilized by all customer service representatives. Utilized VB 6 and SQL Server 7 technologies.

We'd love your feedback!