Dennis Johnston Email & Phone Number

Work with internal customers, vendors and data integration on ETL design, build, testingData mapping, SQL, Informatica, Excel, Data flow diagrams, project management, QA, requirements gathering; translating business requirements into technical specifications and vice versa

Investigated and resolved errors preventing accounts from billing on premium group billing application back-end using SQL Navigator, utilizing membership and client database applications, and making necessary database fixesSpearheaded training of personnel in India on group billing and upstream/downstream applications, through preparing and delivering of customer lifecycle presentation, development of training plan, conducting daily training sessions, development of KPIs, and relationship building

Canonsburg, Pennsylvania, Us

Worked on various IT integration projects for a global pharmaceutical companyLed application discovery: gathered user requirements, mapped requirements to capabilities; socialized findings with various stakeholders, made disposition recommendations, and organized application demonstrations when appropriateInstrumental in maintaining the integrity of application inventories employed by various concurrent projects: worked closely with integration and architecture on identifying stakeholders, and developing disposition strategies (using architecture diagrams, decision trees); instrumental in building cross-project and cross-program teams to share knowledge, and maintain disposition strategy alignmentPrepared required SDLC project documentation: identified project scope, key stakeholders, timelines; rationalized data from capability structure with user requirements and functional specifications to draft use casesDeveloped business process flow diagrams for use in fit-gap workshops

Pittsburgh, Pennsylvania, Us

Prepared month-end financial reports and executed journal entries for all billing issues that arose in the OEM marketThe “go-to” person for resolving issues arising from the billing department, third-party vendors (value-add services), and tax department (primarily EU VAT tax issues)Worked closely with corporate accounting in reconciling ledger accounts and loading forecasts, utilizing both ERP and consolidation softwareInitiated purchase orders, investigated invoices placed on hold (no three-way match), and worked with vendors and buyers on corrective action

Pittsburgh, Pennsylvania, Us

Performed month-end internal financial reporting for 14 offices, 500 attorneys, and 500 administrative staff at a national law firm, with annual revenue of ~$250 millionDeveloped financial reports in Business Objects, which involved universe analysis, query building and joining, standardizing report design, creating formulas within reports, and performing minor modification to SQL behind queries as neededStreamlined month-end close process from 10 days to 2 days, through efficiencies gained by recreating manual Excel reports in Business ObjectsParticipated in Business Objects 2009 implementation and 2012 upgrade:Worked closely with subject matter experts in billing, collections, and business intelligence departments in requirements gathering, testing, and sign-offsInterpreted user requests to get at the underlying needs of the department, and to offer solutions that would exceed expectationsParticipated in weekly status meetings to track, prioritize and resolve incidentsMaintained and troubleshot security access, and provided functionality supportUtilized report bursting technology to ensure timely and accurate information appeared on our dashboard, eventually eliminating system downtimeCreated master test plan matrix of all reports, queries, and source universes; performed testing on ~150 different financial reports, modifying or recreating reports as needed; identified specific universe issues, and escalated as needed to the Senior Business Analyst or design teamDeveloped training materials; trained end-users (attorneys, billing, collections, accounting, and human resources) on use of new reporting software; troubleshot user issues as needed, often walking them through the process of accessing data

E-Business

Cinema Studies

Bachelor Of Arts (Ba)