We provide IT Staff Augmentation Services!

Senior Data Engineer Resume

Ann Arbor, MI

SUMMARY

  • I has worked in teh Information Technology profession for over 20 years. Currently, my role is as a Senior Applications Manager/Lead for Web and CRM supporting software and databases working with Visual Studio and extensively with SQL Server 2000/ 2005/20 /2016/2017/2019 , CRM 4, 2013.2016 as well as Crystal Reports, SSRS and Telerik reporting tools.
  • I has managed projects and always completed tasks on time. My greatest attribute is my problem solving ability. I has a vast knowledge in Business Intelligence concepts and has teh ability to use teh different software tools used in Business Intelligence.

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Senior Data Engineer

Responsibilities:

  • SSRS Admin 2017
  • Developed SSRS reports
  • Created and Maintained all schedules for SSRS(100+)
  • Setup Automated retry logic for failed schedule reports
  • Setup of relaunch of schedule reports without having to reschedule
  • Wrote Stored Procedure/SQL for SSRS reports
  • Migrated SSRS server from
  • Migrated SSRS server from
  • Vertica Administrator
  • Vertica query writer
  • Vertica Created tables
  • Hooked SSRS to Vertica
  • Wrote Vertica Query’s for Reporting
  • Created Projections in Vertica
  • ETLS from Hadoop to Vertica, using custom ETL

Environment: Visual Studio 2017/2019, Sql Server 2016/2017, SSRS 2016/2019

Confidential, Ann Arbor, MI

Senior Applications Manager/Lead

Responsibilities:

  • Maintainedand developed workflows for CRM for franchise owners
  • Created custom workflows in CRM using VS 2016
  • Created plugins for CRM 2016 via VS 2016
  • Created and maintain Web Service in VS 2016
  • Administrated CRM 2016 for Franchise Mr. Handyman
  • Created and maintain workflows with teh CRM workflow engine.

Environment: Visual Studio 2015, Sql Server 2016, T - SQL

Confidential, Toledo, OH

Senior Applications Manager/Lead

Responsibilities:

  • Maintainedand developed workflows for CRM for Customer Service
  • Project lead on new website for Confidential .com
  • Designed new product database for Confidential .com
  • Project lead for customer apps Confidential developed, Proposal/Wall Charts/ WareWash/ Laundry builders
  • Maintainedand developed SSRS Reports for Customer Service and Executive team
  • Worked with Customer Service and developed an incident process inside CRM to halp manage incidents with our customers.
  • Developed all teh workflows and reports
  • Developed Customer Microsite for our customers
  • Developed report portal with QuickRequest (Iphone App) for customers to manage their inventory of Confidential products.
  • Scan QR codes we used to get an inventory on hand for teh home office to view reports and see wat each location had in inventory.
  • Designed report with quick request so our vendors could do store audits in teh store.
  • When done, teh audit would available real-time for teh home office.
  • Project Lead on upgrade to CRM 4.0 to CRM 2013
  • T-SQL writing storedprocedures, functions, and views
  • SharePointadministration 2007/2010/2013
  • SharePoint Designer 2007/2010/2013

Environment: Visual Studio 2008/2010/2012 , SQL 2005/2008/2012 , T-SQL, SharePoint Designer 2007/2010/2013

Confidential, Toledo, OH

Senior Application/Database Developer

Responsibilities:

  • Maintainedand developed custom Access applications
  • Maintainedand developed Crystal Reports 2008
  • Developed custom inventory system and reporting
  • Developed custom wage survey web applicationand reporting.
  • Teh system imports data from excel file and also has a web form used to input teh data.
  • There is also a view and edit pageso teh data can be edited by teh user.
  • I wrote many reports for teh wage system for analysis purposes.
  • Used Class Apps and wrote custom stored procedures for customer to pre-fill surveys with last survey completedby a member.
  • dis process was automatedand used ETL concept to import teh data.
  • Visual Studio 2008/2010 creating custom web applicationsand Business Intelligence apps and reports.
  • SQL 2005 and 2008 creating databases, tables, and indexes
  • T-SQL writing storedprocedures, functions, and views
  • SharePointadministration 2007/2010
  • SharePoint Designer 2007/2010
  • SharePoint Business Intelligence Center
  • Createdworkflows forSharePoint2007/2010
  • CreatedCRM application inSharePoint2010
  • SSRS created labels, reports anddashboards
  • Sales Force writing custom reports
  • Business Intelligence Development Studio
  • QuickBooks integration with API
  • Report Builder 3.0developeddashboard, drill down reporting and heat maps.

Environment: QuickBooks, Access ( ), Crystal Reports 2008, Visual Studio 2008/2010, SQL 2005 and 2008, T-SQL, SharePoint Designer 2007/2010

Confidential, Ann Arbor, MI

Application Developer

Responsibilities:

  • Web portals for reporting tools usingTelerikcontrols
  • Maintain and developed custom Access ( ) applications
  • Maintainedand developed Crystal Reportsfor business reports, graphs and Business Intelligence analysis
  • Reporting services
  • CRM Dynamics 4.0 administration and development
  • SQL 2005 and 2008 creating databases, tables, and indexes
  • T-SQL writing storedprocedures, functions, and viewsfor Business Intelligence processes
  • Visual Studio 2005 and 2010 creating custom web applications
  • Developed three web portals that usedTelerikGraph control to measure metrics on sales, leads, closed leads andaveragesales.
  • Teh portals consisted of reports and graph control. Teh user could change key metric indicators on teh page to see results.
  • Automated royalty report process, used ETL process between databases to load data and check data integrity into teh main data warehouse.
  • dis took about 20 manual labor hours out of teh process.
  • Developed web portal so franchises could track their incoming phone calls.
  • Imported XML file from vender of call information into teh data warehouse

Environment: Visual Studio 2005/2010, T-SQL, CRM Dynamics 4.0, SQL 2005 and 2008

Confidential, Ann Arbor, MI

Development Team Reports

Responsibilities:

  • Developed custom and canned reports for desktop and Internet
  • Visual Basic Versions 3/4/5/6,VB.NETand Access 97 and above
  • SQL Server 2000, SQL
  • Crystal Reports developer versions 9/10/11
  • Created reports with XML

Environment: Visual Basic Versions 3/4/5/6,VB.NET and Access 97, SQL Server 2000, SQL, XML

Confidential, Dundee, MI

MIS Manager

Responsibilities:

  • Network (oneCiscorouter with 14Ciscoswitches)
  • Run and terminate network cables
  • ROLM phone switch and voicemail
  • SPECTRALINK mobile phone system
  • RF network with 24Ciscoaccess points
  • 52 RF guns running Windows CE
  • 52 registers running Windows 2000 and WIN DSS
  • 2 Windows2000 servers
  • NovellServer runningNetwareversion 6
  • GroupWiseServer
  • 20 DELL PCs operating on teh Windows 2000 environment
  • Local client support for AS400 users
  • Has worked with XP/NT 2000/NT 4, Windows 95/98/ME

Environment: Cisco router, Cisco switches, ROLM, SPECTRALINK mobile phone, Windows CE, Windows 2000, WIN DSS, Novell, Netware version 6, XP/NT 2000/NT 4, Windows 95/98/ME, GroupWise

Confidential, Toledo, OH

Plant Floor Programmer/Server Administrator/ Desktop Support

Responsibilities:

  • Wrote and developed plant floor client server test system
  • Administrated GUPTA database server
  • Developed custom reports using Visual Basic Versions 3/4/5/6
  • Plant floor application server NT 4
  • Lotus Notes administrator
  • Windows NT 4 domain controller server - 400 users
  • Problem solving and third level support technician
  • Hardware replacement

Environment: GUPTA database, Visual Basic Versions 3/4/5/6, NT 4, Lotus Notes

Hire Now