PROFESSIONAL SUMMARY:

Confidential is a data analyst with more than 15 years in the Information Technology Industry. He has strong skills in: Microsoft Excel, Microsoft Access, Visual Basic automation, T - SQL, statistics, and providing user oriented reports. He has strong experience in data capture and analysis via industry standard and purpose built tools. Confidential has a Bachelor of Business Administration with a focus in Computer Science/ Business Management.

SKILLS AND ABILITIES:

Operating Systems: MSDos, Windows (XP, 2007, 2008), Server NT/2000, SQL Server 2012

Word processing: Microsoft Word, Adobe PDF

Spreadsheets: Microsoft Excel and Lotus

Databases: SQL, ETL, Microsoft Access

Languages: SQL, VBA - Microsoft Office

Network: TCP/IP, LAN Administration, Network design, Nortel Phone/Voicemail system, SharePoint

Other Software: Microsoft Project, Microsoft PowerPoint, Cerner’s Ascent Capture/Image processing system

Web Development: HTML, JavaScript, XML, Macromedia Flash, ColdFusion, Adobe Dreamweaver

Business: Quality Assurance, Management, Personnel Training, Team Lead, Project Management

EXPERIENCE:

Confidential, Dearborn, MI

Visual Basic Developer

Responsibilities:

• Create routines for ETL based on third party flat files and XML messages.
• Project manage data retrieval from SQL servers for online dashboards.
• Develop stored procedures for web based tools for automotive dealership tools.
• Design financial based tools in Excel and Access 2010.
• Redesign current tools for upgrade into Excel and Access 2010.
• Make use of Visual Basic in Microsoft Office for tools.
• Provide financial reporting tools for the client.
• Create documentation for user based tools.
• Converted Microsoft Excel and Access VBA from for more robust functioning.
• Quality Assure software tools.
• Converted Microsoft Excel and Access VBA from for more robust functioning.
• Provide User Acceptance Testing (UAT) for the client s financial tools.
• Provide feedback from testing and building tools.
• Create store procedures to capture user requested data for reporting.
• Developed tools that took reporting times from hours to minutes.
• Provided procedures that reduced the work time or a project from a day to minutes.
• Created Stored Procedures in Microsoft SQL Server for data retrieval.
• Developed SQL Queries for data capture in reporting financial information tools
• Participated in meetings to develop financial tools built within Microsoft Office.

Confidential, Detroit, MI

Data Management Specialist / Analyst

Responsibilities:

• Reduced ad hoc reporting turn - around times through VBA and T-SQL standardization.
• Made use of Project Management methodologies to create corporate wide reports and reporting tools.
• Provided customer oriented self-service web reporting tools via ColdFusion, JavaScript, and T-SQL.
• Created dashboards in Microsoft Access, Microsoft Excel, and ColdFusion.
• Successfully developed PivotCharts and Analytic views within Excel and Microsoft Access.
• Developed reliable data capture and return from a SharePoint location into Microsoft Excel and Microsoft Access.
• Worked within SQL server environment creating queries and data capture routines.
• Provided test cases, routines, and documentation for products developed by the team.
• Discussed, planned, and completed UAT for products developed by the team.
• Lead JAD sessions for projects to determine requirements, time, expected results, development scope
• Communicated with Information Security personnel to obtain access to systems for tools.
• Followed System Development Methodology (SDM) for maintaining tool lifecycle.
• Maintained change control logs for projects.
• Tracked projects within Microsoft Project and Excel.
• Delivered requirements to team members for projects
• Set the project timeline based on the requirements from the client
• Created report designs and finished reports in Cognos.
• Successfully transitioned legacy Microsoft Access and Excel tools to web versions or improved functionality.
• Developed error handling routines for reporting systems.
• Produced training documentation for report tool use.
• Created Technical documents for tools.
• Adhered to Service Level Agreement (SLA) requirements.
• Created Key Performance Indicators (KPI) dashboards.
• Provided in person and over-the-telephone training for reporting tools.
• Developed tables and views within the SQL server based on client requirements.
• Made use of Agile methodologies to ensure efficient and responsive tools.
• Captured data and design cues from Crystal Reports for display in Microsoft Office.

Confidential, Detroit, MI

Data Management Specialist/ Data Analyst

Responsibilities:

• Create databases as tools for data reporting and manipulation
• Administer databases used in reporting
• Interact with various Confidential system databases and record storage for data capture
• Work with SQL servers performing queries and data capture
• Lead the data management team in streamlining all process across all databases and reporting engines.
• Work with transferring Microsoft Access designed tools into SQL Server functions and tables.
• Work with converting Microsoft Access designed tool into Web based interactive items.
• Develop automated routines in Excel and Access to reduce reporting time
• Develop various Excel charts for management level reporting
• Tracked projects within Microsoft Excel and Access
• Maintained project timelines based on the project requirements.
• Developed and delivered requirements to team members based on client meetings
• Create automated tools to reduce the number of reporting errors
• Interface with third party software vendors to develop a strategy for future reporting aspects
• Work within the Citrix environment
• Perform daily reporting for clients
• Work with Ascent Cerner/CIS to develop reporting tools for client
• Through Agile methodologies, build tools that can be modified on the fly

Confidential, Brighton/Romulus, MI

Information Support Specialist

Responsibilities:

• Windows 98/NT/XP/2000/2003 network.
• Train personnel in computer use - hardware and software.
• Perform necessary computer technical support - hardware and software.
• Create/Install imaged software.
• Contracted to United States Department of Agriculture.
• Install and configure network devices and hardware.
• Configure email software - Lotus Notes.
• Support Lotus SameTime Instant Messaging Service.
• Create software to reduce personnel s use of daily paper use - Microsoft Access used.
• Performed Quality Assurance Processes on hardware/software.
• Project Managed New Office Setup and Current Office Updates.
• Provided Guidance for Software/Hardware Purchases.
• Made use of various remote software tools for administration of clients.
• Supported all client software use.
• Supported client Internet software use.
• Provided direction/testing on new backup strategy.
• SAP data analysis study - used in a study to determine if SAP would be useful on the project.

Confidential, Dearborn, MI

Quality Assurance Software Engineer

Responsibilities:

• Performed Quality Assurance testing on specific web sites for the client.
• Created testing documentation for training/verification of the client's products sites.
• Create XML messages based on a specific Standard and Schema for client web sites/tools.
• Develop documentation for appropriate XML message creation, testing procedures, and training.
• Determined if client tool was function to specification.
• Identified test data requirements and set up data as needed in the database
• Created/wrote automated test scripts utilizing Mercury Test Suite (certified).
• Identified areas of concern, defined the scope of the defects, and created supporting documentation.
• Provided UAT testing support for Confidential Company s internal applications.
• Created XML and XSL Schemas for test purposes.
• Identified defects, issues and concerns encountered during UAT testing
• Created testing documents: plans, scripts, and cases.
• Participated in reviewing upcoming requirements for the impact to UAT.
• Implemented test scripts and creation of related test data.
• Maintained defect reports and status during test cycles.
• Reported on testing status during UAT test cycles.
• Worked with the client during test cycle.
• Worked within the 6 - SIGMA Metrics for reporting.
• Created a 200-page training document used by the clients, the team, and additional third parties.
• Responsible for Error/Bug tracking and reporting in Mercury Web Defect Manager.