Charles Stephenson Email & Phone Number

Richardson, Texas, United States

• • Support for Experlogix Enhanced system functionality and user experience by creating new menus and modifying processes in Experlogix, leading to a 20% reduction in data processing time.• Admin support for ServiceNow and used for ticket incidents and request. • IT Support for Dynamics AX 2009, Service Now and Scribe Server ETL process• Created ad hoc reports from Dynamics AX 2009 SQL Server database writing SQL queriesused to Fix problems and decrease worker work load.• Created reports in Power BI, CRM365, ServiceNow and Analyzer; created and modified SOP for systems.• Created business process flowcharts for supported systems.• Project worked on data transfer for SAP S/4/HANA upgrade from Dynamics AX 2009For several company divisions worldwide.• Used Jira to track changes and update to systems.

Plano, Texas, United States

• Contract at PepsiCo’s Business Intelligence Services group using Scrum methodology to ServiceNow tool and creating Data Warehouse.• Business Objects subject matter expert for team.• Creating and managing all Universes, Webi Reports and Xcelsus Dashboards from Data Warehouse using Business Objects 4.2.• Creating ad hoc reports and new universes, Webi Reports, Tableau Dash Boards and Power BI Dash Boards from other Data Warehouse and other business tools used by Company.• Responsible for the entire reporting process, and dashboard / scorecards creation lifecycle, key performance indicators (KPIs), including gathering client business requirements, report automation through (Power BI / Excel), entity relationship linkage (ETL), creation, design, testing, and delivery in Business platform. • Worked with main clients and business leaders to identify analytical requirements. • Developed complex reports using primarily MS Access, MS Excel, SQL.• Great experience with data mining, utilizing Access databases and Excel, including pivot tables, VLOOKUP’s, formulas, and Access Macros, along with data aggregation techniques

Plano, Tx

• • Contract at PepsiCo’s Business Intelligence Services group using Scrum methodology to create Data Warehouse from HP Service Manager Program and then converted to ServiceNow tool and recreated Data Warehouse.• Business Objects subject matter expert for team.• Creating and managing all Universes, Webi Reports, Explorer Reports and Xcelsus Dashboards from new Data Warehouse using Business Objects 4.0 and 4.2.• Creating ad hoc reports and new universes, Webi Reports, Tableau Dash Boards from other business tools used by Company.• Help support Business Intelligence team with problems with previous reports that have been created and help with old reports created with Crystal Reports.• Applied SQL, Excel, and Access knowledge to reporting tasks.• Created MS Access macros to streamline processes for reporting purposes.• Developed complex reports using primarily MS Access, MS Excel, SQL.• Great experience with data mining, utilizing Access databases and Excel, including pivot tables, VLOOKUP’s, formulas, and Access Macros, along with data aggregation techniques.• Demonstrated experience with data processing, and showed an advanced technical knowledge and expertise with Microsoft Products, especially PowerPoint, and Excel, and with tools such as: pivot tables, formulas, vlookup, hlookup, merging data, checking for duplicates, etc.• Collected & executed complex data analysis & reporting for management, as needed for client.

Amarillo, Texas Area

• Supported IT at facility that manufactured aircraft for US military also assisted a project that modified Data Warehouse using an Oracle database, Business Objects Data Services ETL, Business Objects XII. Modified ETL, Data warehouse and Universes to use new data sources cutting over to SAP and Kronos from mainframe programs. Also assisted on a project that upgraded reporting tool to Business Objects 4.0.• Created and modified reports using Webi, Crystal Reports and Xcelsius reports. Also used Qlikview to create dashboards. • Used PL SQL Developer to extract data for ad hoc report requests.• Trained site personnel on use of Business Objects 4.0 and how to create reports using the Business Objects Webi reports and how to use different universes. • Primary support for data warehouse, universes, ETL and reports to fix problems and make modifications.

Washington D.C. Metro Area

• Supported project for Dept of Labor changed the front end tool from Oracle Discoverer to SAP Business Objects XII, created the Universes, Webi reports to replace 5 of Data marts also created all 15 Xcelsius dashboards and 2 Crystal Reports that was not available in the Discoverer tool. Also created one new Data mart using Oracle10g database, Oracle Warehouse Builder10gR2, SAP Business Objects.• Support activities that include; designing Performing Extraction Transform Load (ETL) process, data mapping, work flow and report dissemination using Oracle Warehouse Builder10gR2.• Support development activities that include: staging tables, Dimensions, fact tables, target tables, indexes, procedures, triggers and packages in Oracle10g database using Toad.• Support data warehouse sub-systems that collect data from various agency programs and initiatives.

Richardson, Tx

• Forecasted 12-month resource requirements with 95% accuracy each month for installation, integration, field engineering, and engineering resources by state for cellular switching, data and cell site products for the United States area by getting data from multiple sources using SQL queries, Transact SQL and Visual Basic macros in a Access database, created standards to calculate hours needed to do work. Ensured availability of appropriate number of resources for future projects by having monthly meetings with resource managers with charts and data displayed in Excel and PowerPoint slides.• Reorganized MS SQL database for job assignments and milestone dates through implementing the enterprise manager; authored special reports writing SQL queries intended to decrease resources required to do this work using web interface. Created and maintained data warehouse for Plexus tool that scheduled and tracked work on all US projects.• Created and maintained a Excel 90-day schedule Report Tool pulling data from multiple databases using Transact SQL, SQL queries and macros in Access and Excel, demonstrating all projects for every product line in US; the tool helped the allocation of resources to projects to ensure on time completion and reduce travel costs by showing key milestones, budget, manpower requirements also showed on map of US where project located and home base of field personnel.

Bs, Electronics, Computer Programming

As, Electronics