PROFESSIONAL SUMMARY:

• 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 Confidential, Confidential, and Confidential as well as working with Confidential of MI. and Confidential .
• Active Licensed Real Estate Agent for over 8 years
• Role Base Development (Role Basing)
• Identity Access Management (IAM)
• SAP Business System
• Six Sigma Process
• Expert proficiency (10+ years) in MS Excel: Pivot Tables, V - Lookups, H-Lookups, 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

TECHNICAL SKILLS:

• SAP Enterprise Business System
• MS Access, Oracle, SQL, Web Database Import / Export information systems
• Business Intelligence and Data Warehousing
• Identity and Access Management (IAM)
• Role Based Access Control (RBAC)
• SAS (Statistical Analysis System)
• IBM Security - Identity and Access Management Software
• ActivPlant Factory Information System (FIS)
• Business Intelligence (BI Tools) Software
• Microsoft Office 2007, Office 2010, Office Suite, Visual Basic (VBA) and MAC
• Microsoft Share Point
• Microsoft Access Database Design and Development
• Customer relationship management CRM Software - Agent Business Builder
• Maximo Asset Management
• Graphics/photo imaging software

PROFESSIONAL EXPERIENCE:

Program Manager

Confidential

• Team Leadership
• Project Plan Development
• Financial Management
• Contract Negotiation
• Working knowledge of SAP
• Daily use of Microsoft SQL for reporting
• Create Excel spreadsheets for daily, weekly and monthly program reports
• Client Relationships
• Schedule and Delivery Execution
• Generate presentations for the Executive team using PowerPoint
• Management Reporting and Communication
• Daily use of SharePoint
• Process Development and Improvement
• Successful Program Delivery
• Government Contracting and Government Contract Management

Sr. Business Analyst

Confidential

• Data collection, analysis, and metrics gathering to help clarify and quantify the performance of our operations and our customers (DTE Energy).
• Assist with project management responsibilities.
• Create and manage complex Bedsheets and Dashboards using excel.
• Communicate with the Executive team about historical data, current state and future forecasting.
• Run multiple reports within SAP merging data to present one compliance report.
• Work with Confidential and their operational teams to help improve the efficiency of the program
• Work with the operational teams at Confidential to support strategic decisions through optimized reporting, advanced analytics, and data-mining.
• Translate business needs into analytics/reporting requirements, perform advanced analysis, and translate metrics into actionable opportunities and recommendations that lead to continuous improvement of business performance.
• Act as a bridge between Program Management, Learning Systems Team and the Customer to ensure that performance goals are met in the most efficient way.
• Clear-thinking problem solver to demonstrate an understanding of the training and learning business and synthesize metrics and numbers into practical insights, and communicate those insights with confidence to Executives.
• Use Microsoft Excel’s advanced functions to perform complex interrogation of the data from multiple data sources.
• Lead workshops on the design, development and understanding of the reports provided.
• Identifies opportunities for improving business processes through information systems and/or non-system driver changes; assist in the preparation of proposals to develop new systems and/or operational changes.
• Consults with functional unit management and personnel to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access.
• Acts as a liaison between departmental end-users, technical analysts, information technology analysts, consultants and other organizations in the analysis, design, configuration, testing and maintenance of information systems to ensure optimal operational performance.

Sr. Business Data Analyst - Information Security

Confidential

• Provide analytical support to specific groups of customers on business applications, infrastructure and technology related activities.
• Program management responsibility. Manage budget, timelines and scope.
• 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.

Business Data Analyst / Global Maintenance Coordinator

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
• 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

Professional Realtor / Business Analyst / Owner

Confidential

• Partnered with and contracted by Confidential and other Financial Institutions to manger and develop market trends while performing analysis of foreclosed properties.
• Market real estate for sale through the real estate multi list service (MLS)
• Coordinate strategies for setting sales goals
• Currently represent Confidential, Skyhill Financial, REDC, Integrated Asset Services and Confidential as a Broker to Market foreclosed properties for sale
• Set monthly and yearly goals
• Analyze the real estate market and produce reports using current market data
• Extract data from Realcomp and MLS
• Management a portfolio of REO/Bank Owned properties

Business Solutions Analyst / Ford Launch Coordinator

Confidential, Sterling Heights, MI

• Implementation of ActivPlant for Confidential.
• Project Management
• Troubleshoot ActivPlant issues and problems at Ford - Dearborn Rouge Office Building, correct problem issues as necessary
• Collaborated with Ford Management and other Tier 1 suppliers to complete template screens for ActivPlant
• Read and justify Mechanical Drawings
• Implementation and Development of ActivPlant Intelligent Manufacturing software v4.1 for and Confidential.
• Manage clients and coordinate change throughout my team
• Coordinate project details and timelines to Project Managers
• Manage multiple simultaneous projects located in different states
• Complete development and configuration of ActivPlant Software and Access Database
• Translate logic into data memory map using Excel, Access and VBA
• Analyze Data for production accuracy using Excel
• Provide monthly reports and change reports on request
• Create production database for the plant body shop, paint and trim, and final
• Configuration of Data in ActivPlant (VP Web/VP Admin)
• Configure Kepware Server EX to ActivPlant
• Validation and Data Collection within VP Collector and the OPC
• PLC hardware and Ladder Logic programming
• Design and develop the conveyors and tooling fault database and screens using FIS (Factory Information Systems), ActivPlant