Jem (Jamie) Looney Email & Phone Number

Knoxville, Tn, Us

Maryville, Tennessee, Us

ETL Developer II, Scrum Master (2016 to 2017)As Scrum Master, provided structure and agile process to the Business Intelligence (BI) Team which was comprised of ten team members. Primary duty was a ETL (Extract-Transform-Load) Developer using SSIS to extract, encrypt (when necessary), transform and load data into the data warehouse. • Certified Scrum Master for Business Intelligence Team• Encryption of sensitive personal information data on both the customer and the employee data.• Servers: iSeries (Power 8) and SQL Server. • Tools: Microsoft SQL Server Management Studio, iNavigator, SQL Server Integration Services (SSIS), Task Factory (third party tool for SSIS)

Maryville, Tennessee, Us

Led the creation of Clayton’s first data dictionary and kept up to date with our customers’ definitions. I also led the inaugural data warehouse team in researching transactional data and creating tables, views and stored procedures to support the adopted Kimball methodology of the data warehouse.Created our first “New Employee” Wiki to guide and integrate new team members to the position, department and the company.• Project lead and/or Scrum Master• Data modeling and development• Tools: SQL Server data types for easy conversion from DB2 files and SQL Server (multiple versions) to SQL Server tables. • Modeling Methodology: Kimball (de-normalized) and Inmon (normalized)

Maryville, Tennessee, Us

Implemented and maintained Framework packages with Cognos Framework Manager. Created reports for all businesses (production to retail to mortgage to insurance) within Cognos Suite. Updated and created reports within Cognos Impromptu and Cognos PowerPlay. Reports ranged from basic to sophisticated to linked (drillable) reports. Based on my extensive experience with Cognos software, I coached my team in more sophisticated frameworks and reporting. Created training material and implemented courses to new and existing Cognos customers via either web interface or classroom setting. • Designed/created new reporting packages and frameworks• Creation of SQL Server tables, views and stored procedures to support reporting • Technical Writer• Software Instructor

Us

Implemented the first Data Warehouse and engaged in team design meetings and implementation of designed models to Teradata through Informatica. Created manuals, instruction materials and classes that enabled customer base (ranging from IT Professionals to Restaurant employees) to utilize and update their skill sets to create and maintain individual reporting needs. Delivered reports based on customers’ need for reports that were easy to use and understand.• Cognos Administration including framework management and installation guidance• Reporting: Cognos PowerPlay cubes through Cognos Transformer, creating FrameWork Manager package(s) and deploying. • SQL Server Reporting Services (SSRS) • Servers (tools): Oracle (using PL/SQL), SQL Server (SQL Server Management Studio and Hyperion Essbase • Technical Writing• Software Instructor

Consulted for Cognos Corporation and other consulting agencies for training, installation of Cognos products and/or BI reporting for Cognos customers.• Consulting• Technical Writing• Software Instructor

Ca

Certified Instructor for Cognos Tools to include Impromptu, PowerPlay and Transformer. Trained Cognos customers with manuals supplied by Cognos Corporation. Traveled to training centers and companies to train multi-skilled individuals on Windows Personal Computers installed with Cognos tools. Held sessions with students on specific issues within their own company. • Software Instructor• Software Confliction Resolution

Developed education material within the Cognos suite of products. Material was designed to envelop each company’s personal data to familiarize the classroom with their own abilities based on their job function. Travelled throughout eastern United States to provide classes and field questions from employees concerning Cognos products. • Software Instructor• Technical Writer• Ability to train students ranging from novice computer operators to Information Technology professional

Application Developer (1998-1999)Designed and implemented databases with Access and Visual Basic. Utilizing Cognos PowerPlay and Impromptu Reporting tool(s) utilizing data warehouse data. Report generation through Microsoft Access and Crystal Reports. Documented on all projects for easy instruction and development criteria. • Database design• Distribution and Installation• Tools: Microsoft Office, Crystal ReportsUser Support and Education Technician (1997-1998)Solved conflicts, software and hardware errors. Completed setup of new PC’s and configured to departmental guidelines. Wrote and distributed manuals for teaching that centered upon departmental and company policy and/or procedure(s). Developed programs for specific departmental usage. Maintained inventory of software and hardware while tracking computer(s) configuration and location.• Software/Hardware conflict resolution• Help Desk • PC Setup • Technical writing• Technical Instructor