• Information Technology Professional with over 15 years of experience specializing in Data Analysis, System Design, Application Development and Configuration, and Project Coordination.
• Extensive experience in the Automotive Industry, working as a supplier or on projects with Ford Motor Co, General Motors, and Daimler Chrysler as well as working with Blue Cross Blue Shield of MI.
• Role Base Development Role Basing .
• Identity and Access Management IAM
• Data Mining
• Expert proficiency 10 years in MS Excel: Pivot Tables, VLookups, HLookups, Data Manipulation, Formulas and merging of files using Excel and Access.
• Excellent troubleshooting, analytical and problem solving skills.
• Implementation and integration of Factory Information Systems FIS .
• Outstanding project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure.
• Exceptional IT technical project planning and implementation, strong customer service attitude, exceptional organizational ability, interpersonal skills and communication skills.
• Proficient at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives.
• Experienced in coordinating, negotiating and motivating resources in support of time line and IT project deliverables.

• Fundamental understanding of project management methodology with ability to lead a project from inception to implementation
• Strong Systems implementation experience
• Microsoft Access Development
• Data analyst and Data Warehousing
• Productivity improvement specialist
• Client relationships and conflict management

Technologies

• MS Access, Oracle, SQL, Web Database Import / Export information systems
• Business Intelligence and Data Warehousing using SQL Server 2012
• Identity and Access Management IAM
• Role Based Access Control RBAC
• SAS Statistical Analysis System
• IBM Security Identity and Access Management Software
• Activ Plant Factory Information System FIS
• Six Sigma Technology
• Business Intelligence BI Tools Software
• SQL Server Reporting Software SSRS and SQL Server Integration Services SSIS
• Microsoft Office 2007, Office 2010, Office Suite, Visual Basic VBA and MAC
• Microsoft Share Point
• Microsoft Access Database Design and Development
• Database reporting software Internet based MLS database software
• Customer relationship management CRM Software Agent Business Builder
• Maximo Asset Management
• Graphics/photo imaging software

Data Analyst Information Security

Confidential

• Provide analytical support to specific groups of customers on business applications, infrastructure and technology related activities.
• Participate in end-to end data analysis and role development for controlling access to the company's key application and LAN systems.
• Role Base Blue Access Identity Access Management Tool IAM .
• Enterprise Data Warehouse concepts and applying query data in a Very Large Database VLDB environment.
• Conduct analysis of the use of business data and user needs to ensure traceability to the business vision.
• Data Mining of large amounts of data to pull together the most accurate information for the Role Base Management Tool Blue Access .
• Ensure the construction of meaningful definitions of identity and access data elements which are clear and accurate and provide governance of such data.
• Work with application developers and operations personnel to support production applications and customer-specific operations.
• Documents functional IAM business data requirements, solicits input from cross-functional business representation.
• Acts as the liaison between business users and IT operations and development to resolve issues and expedite systems enhancement tasks.
• Provide guidance, assistance and coordination on business problems and ensure resolution.
• Converting and migrating data from Legacy System to the new COTS product.
• Analyze program needs and translate them into data warehousing and data mart requirements.
• Define, document, and maintain all data definitions, data sources, business meaning and usage of information.
• Research and resolve business-critical production problems/system amends. Establish data profiling and preventative procedures to improve data quality.
• Create data quality metrics for identifying data related issues.
• Assist in the coaching and training of customers in the use of business intelligence tools to enhance business decision-making capability.
• Collaborate with multiple teams to establish appropriate data access management.
• Work with project teams to understand the business environment in order to manage enterprise-wide information/data support systems.

Global Maintenance Coordinator / Data Analyst

Confidential

• Analyze Global Data using FIS Factory Information Systems
• Create data spreadsheets using Microsoft Excel for monthly FIS global data
• Translate plant data into a power point presentation for corporate review
• Continue to create better ways to present and translate data from FIS to Excel and Power point
• Complete monthly reports and change reports on request from upper management
• Create SQL queries and reports, Transfer Data into Excel
• Six Sigma
• Pivot Tables, VLookups, Data Manipulation and merging of files using Excel and Access
• Generate reports for jobs per hour JPH for 85 plants around the world for all shifts
• Analyze production data for the plant body shop, paint and trim, and final
• Coordinate monthly projects and maintain timelines, report to upper management
• Transfer FIS data using SharePoint, Excel, PowerPoint, Pivot Tables and Visual Basic
• Gather Statistics from FIS, create spreadsheets and design indexes for analysis for presentation to company executives
• Communicate all Data issues and schedules to Project Managers