Data Analyst Engineer

Edward J. Furdyna

*********@*****.***

EXPERIENCE

Independent January 2023 - present

Burlington MA

Free Lance Writer

MBTA – State of Massachusetts May 2022 – January 2023

Boston MA - remote

Data Steward/Data Engineer/BSA

Working on Capital Implementation Project and FY23 project turnover.

Visualization tools for vetting data

Editing and running MS Access Queries, vetting data for FY22 YE and FY23 turnover

Meeting with impacted parties, clients and business units concerning requirement changes from

Year to year

Lincoln Financial Group/Liberty Mutual Boston, MA July 2019 – December 2021

Group Protection – Infosec Div

Data Analyst/Data Steward/BSA/QA Lead

Data Integration and Implementation project between Lincoln Financial Group and Liberty Mutual systems

Risk assessment, analysis of business and data process flows

Analysis and assessment of ETL processes, Informatica process and business rules estimations

Conducting analysis of data between UAT and Dev environments, data lineage, traceability matrix

Defect tracking - facilitating communication between ETL developers and project team

Conducting project team reviews of defect remediation with business owners of concerned applications, products and processes,

Reviewed project exposure to GRC principles,

Visualization tools and dashboards

Validation of IAM (identity and access management) using CyberArk Privileged Account Security

Validating Cyber security standards, ITIL incorporation

Running supporting SQL in conducting validation and verification of application enhancements, conforming data to governance rules, business rules and policies

Reviewing DDL and Data Dictionaries for Data Center accuracy

Working in HP Quality Center for management of Changes and enhancements

Powerpoint and VISIO presentations

Environment: MS Office 365, Notepad, Windows 10, MS PowerPoint, MS SharePoint 2010, Oracle 12c, OSD,

HP ALM (now micro focus quality center), ServiceNow, Excel, power pivot, v-lookup

iRobot Bedford MA February 2019 – July 2019

IT Info Security/IT Audit

Data Analyst/Data Steward/BSA/Security Consultant/QA Analyst

Assessing CVE, VRM, etc.

Risk Management:

oConducting external interviews with third party entities

oConducting internal interviews with business owners of concerned applications, products and processes, corresponding internally with legal representatives regarding contractual obligations

oConducting online, security and industry research, Security Information and Event Mgt

oWorking on Agile Kanban Board – creation and updating of Security Documentation

oPresentations related to security reviews

oWorking in IT Enterprise Information Security assessing third party applications, software and vendors security and common vulnerability exposures, creating and managing projects via Jira Kanban boards tools

oMaintaining integrity with corresponding Agile tickets, reporting structure and a Security Review Library.

oDocumentation consisting of security analysis, risk management and compliance procedures

oDocumentation of ServiceNow considerations in alignment with change management procedures for third party vendor and vendor application implementation and installation

oCoordination between Infosec, Legal, Compliance and Procurement departments in relation to contract specifics

oValidation of IAM (identity and access management) using CyberArk Privileged Account Security

Edward J. Furdyna

*********@*****.***

iRobot Bedford MA (cont’d)

oVulnerability and risk assessments include but are not limited to ISO27001, SOC II, SOX compliance, Privacy Shield,NDA's, MSA's, GDPR, GRC, NIST/CSF(cyber security), DLP, Intrusion Detection, SIEM & Splunk reports, FedRamp, Soc 2 Type 2 certification and report, SAML, SSO compatibility, authentication methods such as 2FA and MFA, company certificates and attestations, research into TPAOs, Written Information Security Policy (WISP), Privacy Policy, Information Breach Policy and Cloud Service implications including Azure and/or AWS, Agile, Kanban board management, IAM management using Okta IAM

Environment: MS Office Professional Plus 2010, Notepad ++, Windows 10, Agile Kanban boards, Atlassian Confluence, MS PowerPoint 2010, MS SharePoint 2010, SharePoint Administrator, SQL, SaaS, Paas, Oracle 11.g, ServiceNow, Unix, FISMA compliancePower BI, ServiceNow, Slack, Excel, Powerpoint, Smartsheet, Jira Kanban boards,

Southern New Hampshire University, Manchester, NH March 2018 – February 2019

BI/Enterprise Information Management department

Data Analyst/Data Steward/BSA

Sr. Technical/Functional BSA

Performing Current State and Future State analysis on ITS Infrastructure for Unify Salesforce installation and

Implementation

Assessing changes and modifications to ServiceNow procedures within new environments

Requirements gathering, documentation consisting of data and business process flows, risk assessment,

project scope and presentations before multiple groups and committees for project approval for underlying applications affected by introduction of Unify Salesforce

QA/SQA – analysis of data streams, input files to final DB destination (STM), business process flows

Working with various stakeholders including ETL developers. Warehouses DBAs, technical resources, business representatives, Information Security, among others

Working closely with PMO, setting milestones, guidelines and timelines, coordination with other projects

Agile methodology, Scrum, Sprints, Epic creation, User Story creation

Reviewed project exposure to GRC principles

Ascertain SOX compliance conforming data to governance rules, business rules and policies

Reviewing DD: and Data Dictionaries for accuracy

Working in HP Quality Center for management of Changes and enhancements

PowerPoint presentations for RFP’s to Executive level review boards

Setting communication standards for requested projects, embedding standards in roadmap

Current state to future state analysis, transition, systems installation and integration, report card and migration status, data lineage and traceability matrix

Environment: SQL Server Environment, MS Office 365, Notepad ++, MS Excel, Windows10, ServiceNow

MS PowerPoint 2010, SQL Server 2014 Management Studio, SSRS, Power BI, ServiceNow,

Excel, power pivot, v-lookups, ITIL standards, vba, creation and presentation of RFPx

Edward J. Furdyna

*********@*****.***

Boston Private Bank/Boston Wealth, Boston MA March 2017 – January 2018

IT Infrastructure department

Data Analyst/Functional & Technical BSA/Vulnerability & Security Analyst – BCDR Project/QA Lead

Working on BC DR Project – Business Continuity Disaster Recovery as well as GRC attributes

Interview IT Area owners concerning vulnerabilities as defined by FDIC and IT Audit

Create and document IT Asset Inventory spanning all areas of IT – Servers, Switches, Routers,

Workstations, laptops, telecommunications, teleconferencing, physical security features, Server

Administration assets – security assessment

Analyze unencrypted protocols and default passwords establishing IAM standards and authorizing

Access and identity management

Create Service Transition framework, roadmap to transition and networking/communication structure

Interview Business and IT owners of assets, software and applications

Create and document IT Asset Provisioning Playbooks – detail onboarding. Provisioning, Re-provisioning

Decommissioning processes and procedures

Project conducted within Sarbanes-Oxley Act compliance & Security Information and Event Mgt

Coordinated project with PMO, Powerpoint presentation and visualizations

Analyzing Unix scripting – Perl scripts

Conducted analysis reviews of incoming data enhancements and software upgrades

QA/SQA – analysis of data streams, input files to final DB destination (STM), business process flows

Validation of inventories and analysis of vulnerabilities via comparison of Qualys reports, Active Directory

and ManageEngine Asset Explorer (Asset and Licensing Management System)

Determined risk exposure for IT assets and remediation and mitigation procedures

Create new IT Change Management Procedures policy and document

Document business and data processes for IT Audit department, Regulatory and Compliance

addressing vulnerability remediation and compliance •

Reviewed project exposure to GRC principles

Review and document incorporating ServiceNow as part of new Change Management Manual, Policies and Procedures.

Create new Change Management Manual incorporating ServiceNow as part of Incident and Change Management policies, traceability matrix

• Ascertain SOX compliance conforming data to governance rules, business rules and policies

Environment: SQL Server Environment, MS Office Professional Plus 2010, Notepad ++, MS Excel, Windows 7,SOAP, MS PowerPoint 2010, SQL Server 2014 Management Studio, SSRS, Agile methodology, Unix xml, xsd, api, Qualys, Active Directory, Shavlik, Code Green, Asset Explorer, ServiceNow, HP ALM Service Manager, Excel, power pivot, v-lookups, ITIL processes and procedures

Edward J. Furdyna

*********@*****.***

The Brattle Group, Cambridge MA August 2016 – March 2017

Legal Dept - CRM Systems - Infosec

Data Steward LexisNexis InterAction CRM/Data Analyst – Research Analyst

Crafted executable task lists for CRM enhancement projects

Enhanced Interaction CRM system via reconfiguring display fields and screens

Performed data cleansing via Data Change Management system and processes embedded in CRM

QA/SQA – analysis of data streams, input files to final DB destination (STM), business process flows

Performed online research in pursuit of excellence in data quality

Conducted analysis reviews of incoming data enhancements and software upgrades

Supported and coordinated quarterly software upgrades and patches

Validation, Verification and Integration of infrastructure, internal and external data sources.

Determined risk exposure for incoming data according to GRC

Coordinated project with PMO

Worked closely with in-house IT support at Brattle Group and external support at Lexis Nexis Enterprise Solutions

Document business and data processes, Agile methodology, Scrum, Sprints, Epic creation, User Story creation

Research analyst in areas of energy, governmental, scientific, academic and cultural concerns

Create user manuals and quick reference sheets

Created end user manual and instructions for Interaction access and functional use

Environment: SQL Server Environment, M MS Office 365, Notepad ++, MS Excel, Windows 7, Excel

MS PowerPoint 2010, MS SharePoint 2010, Cisco Anyconnect Secure Mobility Client, SQL Server 2014

Management Studio, SSRS, Snipper tool, Interaction Windows Client, Interaction Web Client,

Interaction Administrator, LexisNexis, Interaction CRM system, SOAP, xml, xsd, api

State Street Corporation Boston MA September 2015 – May 2016

IBG – SSGA Governance, Compliance and Regulatory _ Infosec

Sr. Business System Analyst/Customer Data Security Analyst

Created customer survey initial point of contact and client interview templates for analytical processes

Enhanced interview process for Business and IT application owners as part of Discovery process

Worked on Federally mandated Watch list project concerning AML (Anti Money Laundering),

and Know Your Customer (KYC) in support of Fircosoft Sanctions Screening

Substantiate data governance

Working with OFAC, PEP, Bank Secrecy Act (BSA) and FEP governance and compliance

Analysis and queries to prevent fraud and ensure cyber security within Infrastructure

Analysis in consideration of Politically Exposed People (PEP) and Financially Exposed People (FEP)

and OFAC and GRC.

Validation, Verification and Integration of internal and external data sources within Regulatory and Compliance areas and high-level process flows/maps

Validation of identity and access management using RSA standards

Project conducted within Sarbanes-Oxley Act compliance

Perform risk exposure and risk mitigation analysis, determine risk mitigation protocols in place

QA data streams and business processes – in transit and at rest – data traveling beyond firewalls and returning

Interviewing both application business owners and application IT owners for sanctions screening

Document business and data process flows including aspects of Business Continuity and Disaster Recovery and present findings to Compliance Division for assessment

Working closely with PMO, setting milestones, guidelines and timelines, coordination with other projects

Conducted interviews with business and IT application owners for over 3500

globally based applications including US based, APAC and EMEA. •

Reviewed project exposure to GRC principles

•Ascertain SOX compliance conforming data to governance rules, business rules and policies

•Working in HP Quality Center for management of Changes and enhancements

Environment: MS Office Professional Plus 2010, Notepad ++, MS Excel and Pivot tables, Windows 7,Excel, IDQ MS PowerPoint 2010, MS SharePoint 2010, Agile Environment, SharePoint Administrator, Oracle 11.g

Edward J. Furdyna

*********@*****.***

State Street Corporation Boston MA April 2015 – September 2015

IBG – SSGA – IT Infosec

Business Analytics and Reporting – Business Intelligence

Sr. BI Business System Analyst/Enterprise Data Analyst

Worked on MARS project, Marketing and Reporting Sales, CRM software product (Salesfocus) (Salesforce version of Tableau) customized for SSGA, hooked into Salesforce architecture and data

MARS is a top Asset Management visualization tool for AUM

Perform metrics analysis and data hygiene, QA, with SQL on internally generated data as well as data supplied via external Vendors Merrill Lynch, Morgan Stanley, Wells Fargo Advisers, Wells Fargo FiNet and Morningstar. All reporting on Exchange Traded Funds, ETF; all Assets Under Management (AUM), traceability matrix

Testing systemic functionality as well as business processes for Assets Under Management (AUM) i.e. populating dashboards and report generation for institutional, internal and external wholesalers and the sales team including National Broker Dealers (NBD), Independent Broker Dealers (IBD), National Accounts (NA), Private Wealth Services (PWS), Registered Investment Advisors (RIA)

Data file formatting and content validation via SQL

In the role of System Administrator prepared environment, privileges and set up for QA users

Project conducted within Sarbane-Oxley Act compliance and GRC considerations

Prepared test data, testing scenarios, testing validations and logs

Bug tracking using JIRA and working with and reporting to ETL developers

Working within Regulatory and Compliance guidelines

Supporting weekly and semiweekly new software releases and software upgrades

Set up and initiated Sales and Wholesaler teams covering all Advisors

Set up channels, territories, boundaries, offices, representatives under firm auspices

Adaptive algorithms, creating advisor splits of commissions and earnings

End User and Stakeholder negating for project requirements and hierarchy disposition

Export data to Excel spreadsheets for reporting and metric analysis

Working in six sigma type methodologies (DMAIC); specifically, in conjunction with templates incorporating the process of: Define, Measure, Analyze, Improve and Control.

Environment: Salesforce.com, Salesfocus (Salesforce version of Tableau),, MS Office Professional Plus 2010, Excel, Notepad ++, Windows 7, MS PowerPoint 2010, MS SharePoint 2010, SharePoint Administrator, SQL, SaaS, Paas, ETF, Oracle 11.g, Oracle revenue, Assets Under Management (AUM), KPIs, IDQ

Infogroup / Yesmail Interactive Burlington MA February 2015 – April 2015

Business Analytics and Reporting

Sr. Business System Analyst

Worked on Toys R Us marketing campaign and Implementation Project

Analyze UX – User Experience on applications

Perform systems metrics analysis on internally generated data as well as data supplied via external

Vendors: Adobe Omniture (Web Activity), Epsilon (Credit), Toys R Us, Disney Baby (Partner),

Sitel (Call Center), Synchrony (Bank, Customer Information File) and Hello World

(SMS campaigns) formulating data into reports

Create FRD for Vendor data acquisition; incorporate various data files, formatting, definitions and business rules and data validations

Comparative and Systematic metric analysis via processes; measuring web activity (clicks, navigation, Online access, activity/response), POS transactions and transactions via multiple channels, SMS campaigns, customer lists and activity)

Perform gap analysis on new processes, detailing shortcomings and enhancements

Write and run structured SQL queries for data analysis

Conducted Web analysis and click navigation analysis for User Experience – UX analysis, QA analysis

Interrogate Oracle DB in QA and Development Data Warehouses via SQLqueries

Export data to Excel spreadsheets for reporting and metric analysis, creating scorecards; Single Use coupons, Loyalty and Promotions processes, Loyalty accruals, Loyalty Redemption's, Loyalty Earnings, ECOA processes, transactions, campaign offers, events and promotions

Environment: MS Office Professional Plus 2010, Oracle 11g, SQL Developer 2012, v3.2, VIP Access, CISCO,

Cisco Anyconnect, Cisco Systems VPN Client, Cisco WebEx Connect, Notepad ++, PDF Creator,

MS Visual Studio 2012, Windows 7, MS PowerPoint 2010, MS SharePoint 2010, SOAP, xml, xsd, api

Edward J. Furdyna

*********@*****.***

Best Doctors Inc. – North America Boston MA June 2014 – February 2015

BI Analytics and Reporting Solutions and Support

Sr. BI Business System Analyst

Supported the BD BI team in transition to a Salesforce CRM and EDW environment

Create and Populate BD BI Analytics Server with new documentation as well as revised and reformatted preexisting documentation, links, folders and cross reference mapping

Documenting: business processes, technical policies and procedures for Healthcare and Insurance

QA/SQA – analysis of data streams, input files to final DB destination (STM), business process flows and exposure to GRC

Document and support new iteration of Cisco analytics and Cisco Unified CCX Historical Reports.

Document and support Call Center processes, staging and event metrics

Document reporting requirements in relation to ICD – 10 conversions and CPT process.

Apply new standards and conventions to previously existing documentation

Perform systems metrics analysis on internally generated data as well as data supplied via external

vendors, Zarca and Verisk, incorporating into reports via SQL queries

Define Event and Stage metrics within Case Analysis

Document business and data process flows including aspects of Business Continuity and Disaster Recovery

Comparative and Systematic metric analysis via processes analysis via SQL queries

Design, create and deploy Data and Documentation Archives and new archiving process

Document modifications to ServiceNow incorporating new processes for change and incident management

Agile methodology, Scrum, Sprints, Epic creation, User Story creation

Environment: MS SQL Server 2012, SQL Server Management Studio 2012, SSMS, SSRS, Excel, Powerpoint,

Cisco Unified CCX Historical Reports, Cisco Systems VPN Client, Cisco WebEx Connect,

Notepad ++, PDF Creator, MS Visual Studio 2012, Windows 7, CPT-4, ICD-9, ICD-10, vba,

MS Office 2013, MS Visio 2010, MS Excel 2013 (Power Query, Power View, Power Pivot),

MS PowerPoint 2013, MS SharePoint 2010, Salesforce SaaS Paas, QlikView, Power BI, ServiceNow

Fresenius Medical Care – North America (FMCNA) Waltham MA March 2014 – June 2014

FMS BI Solutions and Support

Sr BI Business System Analyst Sharepoint Administrator

Worked as part of the BI team in a multidimensional Healthcare environment

Design, create and deploy FMS BI Reference Sharepoint site on FMC4ME internal intranet

Populate FMS BI Sharepoint site with new documentation as well as revised and reformatted preexisting documentation, links, folders and cross reference mapping

Documenting: business processes, technical policies and procedures, BOBJ (business objects) and KPI's

Documenting: Financial solutions in the area of the General Ledger, Balance Sheet, P&L

Documenting: Metadata and Master Data, Medical procedures and terminology relating to Hemodialysis

Working with Metadata governance

Coordinated projects with PMO

Design, create and deploy metadata repository and associated documentation

Used Open Archival Information System (OAIS) as referential storage model

Design, create and deploy Audit Log, Document naming standards and conventions

Apply new standards and conventions to previously existing documentation

Design, create and deploy Data and Documentation Archives and new archiving process

Run Bex Analyzer queries, extracting data and sql queries

Design, create and deploy documentation with embedded links to SAP infrastructure including Guides to Hierarchy and Hierarchical Characteristic creation and usage

Environment: SAP BW 7.2, SAP BI 7.2, SAP NetWeaver 7.2, SAP BEx 7.3 Oracle 11g, Windows 7, CPT-4,

ICD-9, ICD-10, MS Office 2010, MS Visio 2010, MS Excel 2010, MS PowerPoint 2010,

MS SharePoint 2010, Agile Environment, OAIS data architecture, KPI metrics

Edward J. Furdyna

*********@*****.***

RGI-INFORMATICS Boston MA April 2013 – February 2014

Sr BI Business Systems Analyst

Worked with Big Data Integration and Implementation teams performing data analysis, data validation and verification in support of Medical device software creation for Healthcare

Worked with VA Hospitals/VISNS where medical devices are implemented within Federal Regulatory

auspices

Supported Quarterly releases of software enhancements along with upgrades to business processes

Worked with wire frames to visually support the business rules and interaction requirements.

Worked with Data Integration and Implementation teams performing data analysis, data validation and verification in support of Medical device software creation

Worked with third party vendors supplying inbound data and determining data gaps, data profiling, data modeling and extract process enhancements – Draeger and Vista among others

Performed production support, requirements gathering, assisting in construct of business and data requirements, logical and physical system architecture creation, data mapping, ETL requirements definition using MySql Workbench created queries

Project coordination via PMO

Worked with Big Data concepts including value name pairings, HL7 messaging via VISTA, Drager and VA systems

Worked with XML files and associated XSD schema files, Java Script Object Notation JSON

Testing ETL processes, data delivery and system's requirements both data validation and system's verifications

Document business and data process flows including aspects of Business Continuity and Disaster Recovery

Federal Government Security clearance - Secret

Environment: XML and XSD (XML schema) processing, XLST (EXtensible Stylesheet Language), CSS,

HL7 messaging, Agile Environment, MacBook Pro, MySql Workbench, MS Office 2010, TextWrangler, Sublime Text, Excel, and UNIX environment, Big Data concepts, MS Access,

HTML, DHTML, PHI, HIPAA, EMR, Power BI

DS SolidWorks Waltham MA June 2012 – February 2013

Sr BI Business Systems Analyst

Worked with Developers and Business stakeholders on various projects determining data points

and processes needed for fulfillment – including gap analysis and business requirements

Supported Quarterly releases of software enhancements along with upgrades to business processes

Worked in role of QA, UAT & SIT IT support preparing and creating test requirements and test scenarios, test scripts, test case, ran SQL queries and crafted test result reports

OBIEE environment incorporating business logic, object and business rules

MDM methodology applied to Master Data file, Nexus table, linking tables

Running SQL queries to extract data verifying data and processing in an MDM environment

Including business rules applications

Performed: production support, requirements gathering, assisting in construct of business and data requirements, data and gap analysis, data profiling, logical and physical data model creation, data mapping, ETL requirements definition and ETL process testing and validation

Created and deployed documentation of SharePoint sites

Environment: Oracle 11.g Windows 7 on notebooks, agile methodology, OBIEE, vba

Hyperion Intelligence Designer MS Office 2010, MS Visio, MS Excel, MS SharePoint 2010

Edward J. Furdyna

*********@*****.***

RBS Citizens Bank Cranston, RI February 2012 – May 2012

Sr BSA

Developed QA, UAT and SIT procedures in HP Quality Center. Set up Test Lab and Defect tracking, testing PCC and Credit Card data flows.

Conducted in-depth testing of data and process flows, tracking defects and assigning resolution tasks.

Created test scenarios, test scripts, test case and crafted test result reports

Working on project establishing Credit Reporting/Marketing Database for Credit Bureau Division in conjunction with Epsilon multichannel marketing data service provider.

Production Support of third-party vendors and internal processes

Support of many different credit portfolios from external sources (i.e. Auto, Mortgage, etc.)

Created SQL scripts and data base queries within bank regulatory and compliance protocols

Interrogation of database for statistical reporting (Oracle 11g)

Ran statistical SQL and SAS reports.

Analyzing Unix scripting – Perl scripts & Kornshell

Project conducted within Sarbanes-Oxley Act compliance

Attended project meetings, coordinating with external vendors.

Assisted on creation of data modeling and data mapping requirements

Environment: Oracle 11.g Windows 7 on notebooks, UNIX, agile approach, HP ALM Micro Focus- Quality Center 9.2, SAS 9.2, WinSql Professional 9.2, MS Office 2007, Visio, Excel, Putty (UNIX Access), Agile,

Orchard Brands Beverly, MA June 2010 – December 2011

Sr BSA/QA Lead/ Data Analyst/Data Steward

Worked across all 7 brands of Orchard Brands and their external IT departments, spanning the continental US, for the Corporate Marketing Division as Senior Business Systems Analyst performing: production support, requirements gathering, assisting in construct of business and data requirements, data and gap analysis, data profiling, data mapping, logical and physical data model creation and data model diagrams against data in the Data Warehouse

Prepared functional specs including infrastructure, system and application specification documents.

Worked within the marketing Data Warehouse preparing reports for end users

Created SQL scripts and database queries in Cognos. Worked on several projects pertaining to creation of Consolidated Marketing Data Base containing marketing and customer data for all brands of Orchard Brands Corporate structure

Enhanced existing business logic including business objects (product lines, credit lines)

Ran statistical SAS reports

Analysis and queries to prevent fraud and ensure cyber security

Supported gift card processing, PCC, Credit Card and promotional codes processing across all OB brands and third-party vendors including MarketLive, Now Kibo.

Worked with eCommerce department and multichannel data processing procedures including

data process flows from POS to cloud based marketing solutions

QA Lead working with UAT & SIT IT support preparing and creating test requirements and testing various processes including order entry processing, file transmissions across platforms and servers, data validation, data hygiene and data cleansing, inventory and planning and product management. Document business and data process flows including aspects of Business Continuity and Disaster Recovery

Created test scenarios, test scripts, test case and crafted test result reports

Production Support of third-party vendors including New Business Ventures sub system, both web, call center and direct mail channels. Supported customers and clients by providing help desk support and analyzing issues for problem resolution.

Edward J. Furdyna

*********@*****.***

Orchard Brands Beverly, MA June 2010 – December 20

Environment: Oracle 11.g, Oracle GL, AP, AR, P&P, Windows 7, MarketLive (now Kibo Commerce), OMS, Endeavor change management system, Cognos 7, SAS Enterprise Guide, Visio, Excel, Waterfall approach, PCI, Commercial-Ware on AS400 Mainframe, MS Excel, MS SharePoint, Point of Sale flows, Credit Card transactions PCI, POS,HP ALM (now micro focus quality center),, Excel, power pivot, v-lookups

Fidelity Investments, Boston MA/Smithfield RI August 2005 – January 2010

Data Analysis and Architecture Division

Sr BSA, Customer Data Steward of Customer Profile DB in CWE Warehouse

Worked on multiple database development and reporting projects with emphasis on Hyperion

Intelligence Designer/Brio in an Oracle 10g environment within the CWE Data Warehouse, a

CRM Database

Analyzing Unix scripting – Perl scripts

Constructed business and data requirements, data and gap analysis using MDM approach, utilizing Nexus table as Master file, Data steward of Customer Master (Customer Profile) including Book of Records, ETF and investments products

MDM methodology applied to Master Data file, Nexus table, linking tables

Running SQL queries to extract data in order to verify data and processing in an MDM environment

Created and enhanced reports and reporting processes for divergent business units

Performed data profiling, data analysis, data mapping, logical and physical data model creation, business continuity, disaster recovery and data model diagrams

Contributed to various projects through all phases of SDLC while maintaining a solutions-oriented perspective; assist PM as project coordinator

Created QA test

Contact this candidate