SUMMARY:

• I am highly skilled in Information Technology, consulting and leadership with experience working within all levels of an organization.
• Most recently I have performed as a Senior Business Intelligence lead and developer in Confidential full stack of Business Intelligence. I have expert skills working with Data Warehouses(SQL Server, HaDoop), Extract, Transformations and Loading (ETL) and reporting with tools such as SSIS, SSAS, SSRS, Business Objects, QlikView, QlikSense.
• In addition, I have work with all levels of business users to understand their needs and providing actionable visualizations and analytics. I have also lead teams ranging in size from 3 to 12 people with leadership responsibilities that included project planning, workload prioritization, procuring staff as needed and providing performance feedback to team members.
• I am looking for opportunities to utilize my skills as a Senior Professional working in Confidential Business Intelligence area specializing in providing data driven analytical solutions for Senior level leadership that will provide Confidential insights needed to make data driven decisions

TECHNICAL SKILLS:

Hardware: Compaq, IBM PC, Sun Solaris, IBX, IBM Mainframe

Operating Systems: UNIX, MS - DOS/PC-DOS, Windows NT/2000/2003/XP, MVS

Software: QlikSense, QlikView, Business Objects, DBMoto, Oracle Data Integrator, OBIEE, OBIA, MicroSoft Power BI tools (SSIS, SSRS, SSAS), Cognos Suite of Tools (Cognos Series 7, Cognos 8.0, 8.2 SP2, 8.3, 8.4), MicroStrategy. Hyperion Essbase, SAS, Oracle 8, SQL Plus 8, MS SQL Server, Lotus Notes, IIS, Data Stage, Business Objects. Erwin

Databases: HaDoop, Hawq, Oracle, SQL Server 2005/2012, MySQL, Teradata, UDB, SQL Server 2005/2014, MySQL, Oracle, DB2, IMS/DC

Microsoft Tools: MS Office, MS Project, MS Access

Languages: C++, COBOL, JavaScript, PL/SQL, HTML, Java, SQL, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential

Manager, Business Intelligence

Responsibilities:

• Responsible for maintaining Confidential DBMoto environment to move data from JD Edwards to Confidential Business Intelligence Data Warehouse every 10 minutes.
• Maintain and developed Oracle Data Integrator jobs to transform and load data from Confidential Data Warehouse to various Data marts.
• Extracted data from Confidential Data Warehouse to allow Confidential finance team validate sales performance.
• Created an executive dashboard for Confidential Owner and executive team to be able to monitor Confidential Year over Year and Month over Year performance.
• Upgraded Confidential SQL Sever environment from version 2008 to 2012 and QlikView from v11 to v12.

Confidential

Senior Business Intelligence Lead, Dealer Network Analytics

Responsibilities:

• Area of responsibility include Confidential Dealer Network reporting and analytic environment for FCA, Inc business worldwide
• Responsible for 1 employee and 8 contractors on Confidential Business Intelligence/Analytics team.
• Created a logical data model of Confidential existing SQL Server database and utilized this model to build a physical solution in a ODS data lake.Responsible for moving Confidential Performance Institute Learning Management System data from an external SQL server to an internal Hadoop/Hawq database environment
• Migrated reporting environment from a Business Objects platform to a QlikSense/QlikView platform
• Created an Executive dashboard to allow for Confidential leadership to be able to see how Confidential company was performing and Confidential impact of Performance Institute training, training completion was increased from 52% to 78% between 2016 and 2017 after Confidential dashboard was developed.
• Gathered data and analytic requirements from Vice President, Director, and dealers in Confidential Dealer Network to deliver quality usable analytics to allow for better business decisions

Confidential

Senior Business Intelligence (BI) Lead

Responsibilities:

• Implemented an OBIEE/OBIA environment and worked with vendors to convert existing Webfocus reports.
• Installed Oracle Data Integrator to cleanse data and load it into Confidential BI Data Mart Environment.
• Area of responsibility include Confidential Global business intelligence reporting environment for all areas of Meritor, Inc business worldwide
• Global Project Manager for Confidential Information Solutions area responsible for prioritizing Confidential work request for Confidential BI area.
• Responsible for 3 employees and 4 contractors on Confidential Business Intelligence team.
• Developed an Enterprise Data Model for Meritor, Inc’s various data sources.
• Migrated Confidential business intelligence application from Confidential HP Data Center to Confidential Data Center.
• Developed and implemented a Global Business Intelligence dashboard for Confidential Purchasing department.
• Migrated Confidential Warranty application to Confidential BI environment

Confidential

Senior Business Analyst, Data Management, Analytics and Business Intelligence (BI)

Responsibilities:

• Area of responsibility include Confidential Global Purchasing and Supply Chain (GPSC) organization with specialty in Confidential Purchasing Area.
• Provided Confidential business facing point of contact for projects requested by business staff in GPSC.
• Gathered requirements from Confidential business staff and documented Confidential requirements in a format that Confidential IT staff was able to understand and develop solutions
• Developed user acceptance test cases and coordinated Confidential user testing for business agreement prior to approving solutions to move to production
• Developed requirements and solution for a Joint Venture with PSA
• Developed requirements for an Enterprise Data Warehouse for Confidential GPSC reporting environment that encompassed collecting data from many of Confidential GM applications.
• Developed requirements and solution for Confidential “One Cost Model” being used for GM Purchasing activities

Confidential

Data Warehouse Architect/Business Intelligence (BI) Team Lead

Responsibilities:

• Responsible for 6 member Business Intelligence team consisting of 2 server administrators, 2 Cognos developer, 1 OBIEE developer and an ETL developer
• Delegated assignments to Confidential team.
• Utilized Data Integrator to move data from Data Warehouse to Data Marts that were then used by Cognos and OBIEE.
• Converted 110 Hummingbird queries to Cognos and 15 Hummingbird queries to OBIEE answers
• Developing and modifying Confidential Data Warehouse architecture as needed
• Supported Month End reporting requirements, ensuring Confidential proper databases were updated on schedule
• Evaluated slow running SQL queries and tuned them to improve performance by creating views or indexes
• Evaluated and provided estimates for user enhancement request
• Supported Confidential Business Intelligence environment for GDLS Financial activities

Confidential

Business Intelligence (BI) Analyst

Responsibilities:

• Created OBIEE solutions
• Design and develop a Business Intelligence environment utilizing Microstrategy, SQL Server, PostgreSQL
• Gathering requirements and developing reports for Confidential CFO, COO and VP of Finance.

Confidential

Senior Business Intelligence (BI) Technical Consultant

Responsibilities:

• Team lead 4 person ETL team responsible for Operational Support of Business Intelligence area
• Developed Business Requirements Document, Detail Design Documents, Project Plans
• Assigned and balanced work load for Confidential team
• Provided mentoring in Confidential Cognos and Informatica areas for Confidential team
• Prioritized request from Confidential customers
• Approved timesheets for Confidential team

Confidential

Senior Cognos Consultant/ Business Intelligence (BI) Architect

Responsibilities:

• Migrated from Cognos 8.3 to Cognos 8.4
• Team lead for 3 person team responsible for developing and implementing a BI
• Solution utilizing Cognos 8.3, SQL Server 2005 and ETL
• Developed Confidential architecture design of Confidential reporting environment and worked with
• Confidential infrastructure team to implement Confidential architecture
• SQL administrator for Confidential ChangePoint environment
• Met with Confidential business community on a weekly basis to review new reporting requirements and set delivery dates

Confidential

Decision Support Systems DSS)/Business Intelligence (BI) Team Lead

Responsibilities:

• Migrated from Cognos 7.x to Cognos 8.2 utilizing Confidential BI Team of 2 people. Converted 2,117 users, 1,934 reports and 246 PowerPlay cubes in 12 months
• Recommended solutions to improve performance of Confidential Cognos Reports
• Team lead for 2 person team responsible for Essbase and reporting activities for Confidential Services organization
• Conducted Cognos 8 Report Studio training
• Mentored Confidential development team in Confidential Essbase and Cognos technologies, and provided technology expertise for Essbase and Cognos
• Delegated assignments and tracked progress of assignments
• Developed project plans for major projects
• Met with Confidential business community on a monthly basis to enhance relationships between Confidential business community and Confidential technical team, prioritize requests, address any concerns that Confidential business community has for Confidential BI domain and discuss Confidential strategic direction for Confidential BI domain
• Evaluated new software and practical applications of tools for Confidential DSS team
• Active participant, representing DCFS on an inter-company committee that is committed to harmonizing our BI standards across Confidential DCX organization
• Participated in efforts to optimize Confidential Enterprise Data Warehouse through efforts to clean up Confidential primary indices and Confidential physical data model

Confidential

Senior Cognos Consultant

Responsibilities:

• Assigned, tracked, validated and delivered Cognos Catalogs and reports to different functional departments
• Coordinated support activities including server procurement, deployment and administration

Confidential

Customer Relation Management (CRM) Specialist

Responsibilities:

• Trained development team on proper methods to create Cognos catalogs and reports
• Supported Confidential CRM Data Warehouse and created marketing data stores including repositories and data marts
• Utilized Cognos tools to design develop and implement Cognos reports
• Reviewed new reporting tools and their application in Confidential current decision support environment

Confidential

Senior Consultant

Responsibilities:

• Trained development team on proper methods to create Cognos catalogs and reports
• Resolved technical problems with Confidential database connection between Cognos and DB2, developed various reports for Genesys, and converted mainframe reports to database files on Confidential AS/400 server
• Accomplishments included Confidential successful resolution of Confidential connectivity problem and training of development team, and converted 600,000 records from Confidential mainframe reports to AS/400 DB2 databases
• Provided a demonstration of Confidential Cognos web tools

Senior Consultant

Confidential

Responsibilities:

• Converted DB2 database to a UDB Data Mart, converted Confidential reporting system from a manual system to an automated reporting system utilizing Confidential UDB Data Mart and Cognos Web reporting tools
• Tuned Confidential Impromptu Web Report Server (IWR) and PowerPlay Enterprise Server (PES) for Confidential testing and production environments, and implemented existing Impromptu and PowerPlay reports on Confidential web server
• Accomplishments included script automation, Cognos PowerCube and Impromptu report development, training, customer demonstrations and management consulting
• Created multiple proofs of concept applications for customers and demonstrated multiple adhoc reporting solutions to management resulting in Confidential approval of project budget and production deployments

Senior Consultant

Confidential

Responsibilities:

• Supported Impromptu Web Report Servers (IWR) and PowerPlay Enterprise Servers (PES) as Confidential administrator of multiple development, testing, and production environments
• Trained team members to support and tune servers, focusing on Confidential improvement of IWR report performance
• Accomplishments included performance tuning, which led to a 75% improvement in report availability
• Installed and evaluated Cognos Upfront and created a formal testing

Confidential

Information Management Systems and Support

Responsibilities:

• Project Leader and technical architect for a 4 person development team for a web-base application
• LAN Administrator for Confidential IMSS LAN
• Accomplishments include Confidential successful development of Confidential application and training Confidential customer for Confidential web based application
• Trained Confidential development team on Netscape Application Builder, Netscape Application Server, Netscape Enterprise Server, COGNOS Impromptu Web Reports, Cognos PowerPlay Enterprise Server, Cognos Impromptu and PowerPlay for Confidential desktop
• Team Leader of a 9 person Research and Development/Analysis and Infrastructure Team for Confidential GLP project
• Accomplishment included Confidential Research of Graphical Reporting tools for Confidential application
• Successfully developed Confidential Proof of Concept for GLP, completed Common Office environment (Coe) certification, and obtained infrastructure Concurrence approval for Confidential GM Operations & Staffs Support SBU for Confidential GLP project

Advanced Systems Engineer

Confidential

Responsibilities:

• Project Leader for 8 projects within PSD and Team Leader for Confidential Visually Integrated Personnel (VIP) 2000 team, which included 12 team members
• Accomplishments include Confidential conversion of COBOL programs to PowerBuilder to enable it to run on a LAN
• Converted GM Salary Payroll form mainframe check printing to Laser check printing
• Developed a Person Subject Area Model for Confidential GM Shared People Systems Integration (SPSI) project
• Participated in Confidential estimation of Confidential SPSI project and ensured that Confidential Data Resource Management (DRM) model standards were followed
• Successfully led Confidential project to convert PSD to a LAN environment with 8 team members
• Led a 2-person team to convert Confidential VIP 2000 batch process from VSAM datasets to DB2 databases
• Led a 10-person team to develop a Grievance and Discipline system for GM
• Led a 4-person team that successfully developed a process to enable Mass Layoffs and Rehires by GM personnel
• Led a 3-person team to enable Bxx transactions to be entered online by GM Personnel system operators
• Coordinated Confidential activities of Confidential VIP 2000 as Confidential team leader, and mentored new team member

Systems Engineer

Confidential

Responsibilities:

• Project Leader for 2 projects with PSD, member of Confidential Technical Awareness
• Team, and Team member of Confidential VIP team
• Participated as a member of Confidential Technical Awareness Team to inform personnel within PSD on new technologies
• Responsible for a project to convert OSAM to VSAM datasets within VIP, and loading non-VIP plants into Confidential VIP FOCUS reporting team
• Implemented many Project Work Orders for VIP