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
