SUMMARY:

• I am an internationally experienced Data and Business/Requirements Analyst (15+ years) with a strong analytical applications development background (15+ years) in the Utilities, Insurance, Transportation, Media and Retail industries. I have a successful track record in the analysis, design (architecture), construction and implementation of Data Delivery (ETL), Data Quality and Data Management/BI solutions including Customer Loyalty, Billing, Analytics, Data Warehouses, Point of Sale and Customer Information Systems.
• I am able to quickly establish effective working relationships with executive level stakeholders (non - technical), SME's and technical/development teams as well as understand business objectives and goals and technology capabilities to develop and deliver these fully integrated solutions.
• Many of my roles have been contract positions or included a remote component, requiring me to be disciplined, highly adaptable, time sensitive, learn new technologies quickly and contribute immediately. A business owner myself I am fully aware of business principles, the necessity of excellence and delivering more than is expected. As an IT professional of more than 30 years I am comfortable in all facets of the traditional SDLC and Waterfall methods but prefer an Agile, test driven environment where iterative delivery and Customer Value are the primary focus.

TECHNICAL SKILLS:

Languages, DBMS’s, ERP Systems and Tools: SQL Server (All versions to 2016), T-SQL, DTS, SSIS, SSRS, SSMS, SAS, ORACLE, PL/SQL, TOAD, Hyperion Essbase, CICS, COBOL and COBOL II, DB2, VSAM, AS400, CSP/AD, Polisy, Total, DL1, Access, FoxPro, Visual Basic, ASP, HTML/CSS, SAP R2 and R3, MIMS 3, Lattice, TechnologyOne, XML (ACORD), Informatica Developer (IDQ) 9.6, FirstLogic, Mastersoft NADIS, Business Objects, Corvu, Crystal Reports, Cognos, Brio, Rational Team Concert (RTC), Xpediter, File-Aid, TSO/ISPF, Endevor, Mantis, Kayako Fusion, DM Pluck, Publicus, DTI Lightening, Google Analytics, DoubleClick, Google Fusion, Erwin, Atlassian (Jira + Confluence), TFS, IBM InfoSphere, MilleniumCO, and all Microsoft Office tools (Word, Excel, PowerPoint, Visio).

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Analyst

Responsibilities:

• In an Agile (SCRUM) environment I was responsible for sitting between the project level team and the ETL development team creating functional deliverables and maintaining Data Lineage. I also assisted in Data Modeling using IBM Infosphere.
• Having full visibility to both source and destination systems I also functioned as a project technical resource and SME.

Confidential

Management Consultant, Data Quality Lead

Responsibilities:

• I was responsible for the Data Quality stream of work for the Massage Envy POS conversion from MilleniumCO to Meevo. This role required me to define and execute the Customer/Profile Data Quality strategy for a 38+ million Retail Client Database (with 19% annual growth) and clean and move that client data from a distributed franchise-based model (1,200 Locations) to a consolidated Amazon Web Services cloud solution.
• The first phase of the Data Quality strategy involved the internal identification and consolidation of duplicate customer records, and the cleaning of key customer data elements to facilitate the generation of a ‘golden’ composite record for migration.
• The role required me to establish working relationships with major Data Quality solution vendors, evaluate their solutions and then select a partner to assist in the CASS/NCOA, rule definition and Name/Address Deduplication process. I also developed a complete end to end data reconciliation module using SQL’s Change Data Capture (CDC) to be implemented for the migration process.
• In addition, I assisted the Data Migration Lead in Data Governance and the definition of Data Migration / Conversion tasks.

Confidential

ETL Developer / Data Migration / Conversion Analyst

Responsibilities:

• I was hired by Confidential to complete additional client Data Analysis and ETL conversions into their CIS platform using custom built T-SQL scripts through the SSIS platform. The position required a detailed understanding of multiple utility management and billing solutions and required me to evaluate transformation tasks including mapping / cleansing / consolidation processes and the understanding (and implementation) of a variety of unique business rules and legislative regulations pertaining to the individual utility organizations.
• Supported utility services included water and irrigation, sewer / drainage, refuse collection. Clients I was responsible for converting included Hillsborough (NC), ZephyrHills (FL) and Copperas Cove (TX).
• I developed data analysis and evaluation documents to facilitate client consultation sessions including issues logs, mapping templates and modelling documents.
• From October to April this position became an out-of-hours remote contract.

Confidential

Senior Data Analyst / Senior Consultant

Responsibilities:

• Data source analysis to build a Data Dictionary. Use of Informatica Developer to build workflows for Data Quality processing and designed detailed SQL scripts to extract and match data elements between two legacy systems to identify potential survivorship issues to be addressed during conversion.
• Confidential 's goal was to build a data stream through 2 systems and an XML interface to an Operational Data Store and reporting Data Warehouse where data from source legacy systems was merged to deliver a consolidated 'golden' record.
• One of my primary roles was data comparison between SIRIS and WINS to identify where data was inconsistent, had been dropped or was being consolidated.

Confidential

Information Integration Analyst

Responsibilities:

• At Confidential I was assigned to several initiatives under the Project Data Reset umbrella including Attribute Optimization, Merchant MMX Enhancements, Global Store, Global Rebuy (DTC), and TRIP where I performed the role of Integration Analyst/Lead for the Information Management team.
• The role required me to assume responsibility for key Information Management deliverables including Data Quality Plan's, BRD's, Current/Future State documents, Migration and Integration Plans and Impact Analysis documents, Functional Specifications and Data Mapping spreadsheets.
• My last function was as part of a small team of Information Analysts/Architects redesigning the Common Product Structure which serves as the Confidential backbone for Product Line Planning and Merchandising, to drive greater efficiency and provide the foundation for a single vision of the truth. Confidential has over 200 Product based systems that were in need of severe consolidation and this role served as the precursor to this massive project.

Confidential

Solutions Business Analyst / Senior Data Analyst

Responsibilities:

• I was placed on assignment by Envision at Confidential as a Solutions Business and Senior Data Analyst for the RAPID Project, the discovery, profiling, mapping and XML ETL analysis (Using the ACORD XML Framework) of Insurance Policy data from several core AS400 DB2/COBOL systems to a single or 'master' view Operational Data Store. The ODS was to become the precursor to an enterprise Data Warehouse.
• The Agile based environment utilized both SQL Server 2012 and Informatica's PowerCenter in its profiling, mapping and cleansing process. This project required significant business interaction and business analysis to understand client requirements and objectives and to identify data sources that would meet those requirements. The establishment of a Data Governance team to assist the Data Analyst team in the creation of an effective MDM strategy was also a key component of this data project.
• As a Solutions Business Analyst part of my role within the Agile team space was the formulation of development processes and pathways to integration completion that included the design of system and process models to aid in the migration/conversion of legacy data. Through interviewing SME's, users and project stakeholders I was a primary Business Analyst for the determination of developmental strategy based on solution design.

Confidential

Data Analyst / ETL and Migration Analyst

Responsibilities:

• Three months after leaving Global Water I was hired for a 3+3 month out-of-hours contract to perform the Data Analysis, and ETL development for the city of Cedar Hill conversion. This remote position required the data profiling and mapping of Cedar Hill utility data for migration to the CIS Infinity application using custom built T-SQL scripts through the SSIS platform.

Confidential

Data Analyst / Data Conversion Analyst

Responsibilities:

• I was hired by GWR to undertake Data Analysis in the Confidential utility billing system. As the company rapidly expanded and Confidential was released, data issues became apparent that required remediation. This process involved the identification of incorrect migration processes, invalid data elements and broken data chains/links/integrity that prevented correct billing.
• With the company’s growth I became responsible for the data analysis for the Thames Water project bid. This involved designing a Conversion and Reversion strategy including project timelines, data mapping and data modeling, Interface and migration specifications for a 12+ million customer utility, the sixth largest water utility in the world.
• After an initial 6 month contract I became the only full time conversion analyst and was responsible for all ETL design, development and execution in SQL Server for new clients and conversion of existing clients from Confidential to CIS Infinity. As a core implementation team resource my job involved the complete analysis and conversion of customer data and the resolution of post-implementation issues with business and financial analysts.

Confidential

Web Enterprise Manager / Digital Editor

Responsibilities:

• This role was split between digital editing and strategic web and analytics management for one of Confidential ' daily regional newspapers, and supporting web-based and IT components for corporate-wide and localized marketing initiatives.
• Given the responsibility of promoting web performance and engagement I developed online promotional material, undertook web analysis, deconstructed web and advertising analytics and acted as a Business/ IT resource for in-house and corporate digital projects.
• I was given an ever-increasing number of responsibilities as the organization morphed to adapt to the digital revolution, the last being Web Editor which gave me full online editorial control over some of Swift’s key digital publishing assets. In addition, I was editor for an in-house regional wine magazine that required me to perform journalism duties and write articles for the magazine on the Umpqua Valley wine industry.
• I established digital marketing procedures that involved data capture and retention, consolidation and marketing utilizing non-formalized data from disparate systems. Coming from a pure IT background I had the knowledge and understanding to leverage all of the company’s back-end systems in order to maximize the data’s usefulness and value. In addition, I captured data from various Social Media platforms and email repositories to enhance analytical reporting.
• I also performed first tier help desk support for Swift Digital, the digital arm of Confidential and was on a rotational callout for corporate internet issues.

Confidential

Project Lead / Senior Business Analyst / Data Analyst / Data Consultant

Responsibilities:

• Given a 3-month launch timeline I was responsible for all high-level data analysis, database architecture, mapping and system functional design, requirements gathering, liaising with Office Depot senior management (Executive level) and running a team of contract developers. Project components included web interface, call center support environment, and data warehouse extraction and transformation processes. As a result of the project’s success I led the same project team 12 months later to significantly expand the system and roll new functionality into it.
• As a Project Manager and Consultant with Data Direct I was responsible for project planning, recruiting and managing project teams, developing business relationships and ensuring schedules were adhered to, and client expectations were met. Along with requirements gathering I was also responsible for project design through testing and implementation to staff mentoring, client and support. My role included performing data quality audits and consulting on data warehouse design and data conversions.
• I also wrote project proposals, statements of work and provided strategic IT direction to the business as well as its clients. Data Direct was originally established in 1989 as a data conversion and hygiene bureau and most of the projects in my time there involved business analysis, project design, and data analysis specifically in cross-platform data management.

Confidential

IT Recruitment Specialist

Responsibilities:

• IT and Technical Recruiting Specialist. Executive leadership relationship building, candidate interviewing and project/resource evaluation.

Confidential

Project Leader / Data Conversion Analyst

Responsibilities:

• Managed a conversion team for SUNCORP's CIS. Hired and managed a small team of developers for the intra-company merger from 14 legacy systems (banking, insurance, investments). Metadata dictionary and data mapping.

Confidential

Business Analyst / Data Architect / Data Analyst

Responsibilities:

• Requirements gathering for SAP/R2 Data Warehouse, comprising Supply and Maintenance modules. Expanded to Human Resources and Logistics. ETL design for data extraction using SAS, SQL Server, DTS and T-SQL.

Confidential

Business Analyst / Data Architect / Data Analyst

Responsibilities:

• Retailer established through deregulation. Performed data extraction and conversion (including data scrubbing) and GIS enrichment) from FACOM mainframe to Oracle Data Warehouse and CIS platform.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Designed and developed the predictive analytics Metrics Analysis and Reporting System (MARS) using NT, Comshare Decision, Access 2, Excel, Essbase and ORACLE Financials for Confidential . Established BI portal.

Confidential

Decision Support Analyst / Team Leader

Responsibilities:

• Led an exploratory Data Analysis project across all state electricity commission assets prior to industry deregulation to establish a comprehensive picture of data flow, establish ownership, and create a data fracture plan for deregulation.