Lawrence Campbell Email & Phone Number

Charlotte, Nc, Us

Mooresville, Nc, Us

Mooresville, Nc, Us

Serves as a Microstrategy Architect and Developer within the Analytics Center of Excellence.Assists with Reporting projects, initiatives, enhancements, and requests from across theenterprise by providing the development of Microstrategy Schema, Reports and Dashboards.Serves as a Subject Matter Expert to the department when addressing and evaluating BusinessIntelligence solutions. Assists Business partners by constructing their Structured Query Language (SQL) to address ad-hoc analysis needs.Interfaces with Database Administrators to fine tune data models and reporting schemas to alignwith Best Practices (Star Schema, Data Denormalization, Batch Aggregation).Collaborates with management on the implementation and communication of current andanticipated changes in policies and procedures within the Reporting environment

Étoy, Vaud, Ch

Served as a Tech lead to a Global implementation of Microstrategy (North America, Latin America, and Europe)Met with Business partners to gather requirements, Lead projects and ensure the deliverabilityof reports and schemas per expectations within an Agile environmentEstablished Project plans as well as expectations between IT and its key business partners for deliverables.Developed all Microstrategy objects including Dashboards, Reports, Filters, Templates,Metrics, Attributes, and Facts.Served as a System Administratoro Managed upgrades and compliances based our Licensing agreements.o Developed Reporting standards, Development Processes, and Life cycles.o Provided training to users in an effort to familiarize themselves with the capabilities of the Microstrategy tool.o Provisioned System security per request.o Troubleshot issueso Assisted the Data Warehouse team with any questions stemming from Data Integrity concerns.Created and served as the leader to the Business Intelligence Competency Center (B.I.C.C. Team)o Designed to provide a level of transparency between the BI Team and key Super users.o The team helped prioritize efforts as well as pinpoint opportunities for enhancements.

Mooresville, Nc, Us

Served as lead to a team of Microstrategy Mobile Developers, On/Offshore, that delivereddashboards/documents via iPad and iPhone mobile devices.Led projects while reporting to Business Partners in an Agile fashion from conception toimplementation.Established development standards and ensured compliance through standard review anddiscussion meetingsServed as a Mobile System AdministratorInterfaced with end users to deploy/migrate packages between environments, Implementedpackage securities and user capabilitiesServed as the primary contact for Business owners when addressing reported errors, issues, orconcerns within the mobile environmentRebranded Microstrategy default “out of the box” DMG as Lowe’s Mobile appCoordinated with Microstrategy Premium Support to acquire updated Microstrategy iOS DMGUsed Xcode and internal Mobile Device Management tool to rebrand DMG and deploy to endusers as Lowe’s “Microstrategy” appServed as a member of the Architecture Team to develop and institute standardsServed as a visualization architect by reviewing dashboards and documents, ensuring that datais presented in a fashion that is easily consumed by End-usersProvided guidance from a technical perspective to ensure performance of dashboards and documentsServed as a member of the Business Intelligence Infrastructure TeamServed in On-Call rotation designed to monitor/support Batch reports delivered across the enterprise from Store Managers to C level Executives, as well as monitored weekend processing Developed Mainframe JCL and Zeke schedules to execute triggers from an Administrator’sperspective.Created Microstrategy objects including, yet not limited to, OLAP Cubes, Datasets, Filters, Prompts,Attributes, Metrics and Facts

New York, Ny, Us

Business Intelligence Team (Cognos)Senior Developer / Cognos System Administrator Developed, tested, debugged, maintained, and supported Cognos Reports and Models per end user requirements o Conferred with Business owners to gather requirements, and ensured the deliverability of reports and models per expectations o Designed and developed tables to guarantee data integrity and reporting performance o Assisted Project manager in estimations regarding efforts and resources o Developed models and reports against multiple databases (Teradata, SQL Server, Oracle, DB2) o Developed standard Reports, Master Detail Reports, and Bursting Reports using Report Studio and Query studio Served as Cognos’ Primary System Administrator o Maintained seven different environments (Prod., QA., Development) spanning multiple platforms and fourteen servers o Interfaced with end users to deploy/migrate packages between environments, and implement package securities and user capabilities o Scheduled the execution of Reports, Jobs, and Views per End user request o Developed and maintained the use of Cognos Triggers for report execution o Served as the primary contact for business owners when addressing reported errors, issues, or concerns o Planed and implemented Fix packs, Upgrades, Installations, and transparent coordination of outages o Successfully migrated from Cognos 8.2 to 8.3 for PCI Compliance o Successfully migrated from Cognos 8.2 (Windows, Distributed Install) to 8.4 (AIX Unix, SingleInstall) o Developed and maintained Audit reports for Middle Management to track Environmental trends o Interfaced with IBM when creating Service requests for support Managed an ETL process used to load data into Teradata from SQL Server via Mainframe and Unix Managed, modified, and maintained Software Development Kit Applications

Bachelor'S Degree, Business Information Systems

Data Analytics Boot Camp, Analytics