| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEEXPERIENCEIndependent January 2023 - presentBurlington MAFree Lance WriterMBTA State of Massachusetts May 2022 January 2023Boston MA - remoteData Steward/Data Engineer/BSAWorking on Capital Implementation Project and FY23 project turnover.Visualization tools for vetting dataEditing and running MS Access Queries, vetting data for FY22 YE and FY23 turnoverMeeting with impacted parties, clients and business units concerning requirement changes fromYear to yearLincoln Financial Group/Liberty Mutual Boston, MA July 2019 December 2021Group Protection Infosec DivData Analyst/Data Steward/BSA/QA LeadData Integration and Implementation project between Lincoln Financial Group and Liberty Mutual systemsRisk assessment, analysis of business and data process flowsAnalysis and assessment of ETL processes, Informatica process and business rules estimationsConducting analysis of data between UAT and Dev environments, data lineage, traceability matrixDefect tracking - facilitating communication between ETL developers and project teamConducting project team reviews of defect remediation with business owners of concerned applications, products and processes,Reviewed project exposure to GRC principles,Visualization tools and dashboardsValidation of IAM (identity and access management) using CyberArk Privileged Account SecurityValidating Cyber security standards, ITIL incorporationRunning supporting SQL in conducting validation and verification of application enhancements, conforming data to governance rules, business rules and policiesReviewing DDL and Data Dictionaries for Data Center accuracyWorking in HP Quality Center for management of Changes and enhancementsPowerpoint and VISIO presentationsEnvironment: 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-lookupiRobot Bedford MA February 2019 July 2019IT Info Security/IT AuditData Analyst/Data Steward/BSA/Security Consultant/QA AnalystAssessing CVE, VRM, etc.Risk Management:oConducting external interviews with third party entitiesoConducting internal interviews with business owners of concerned applications, products and processes, corresponding internally with legal representatives regarding contractual obligationsoConducting online, security and industry research, Security Information and Event MgtoWorking on Agile Kanban Board creation and updating of Security DocumentationoPresentations related to security reviewsoWorking 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 toolsoMaintaining integrity with corresponding Agile tickets, reporting structure and a Security Review Library.oDocumentation consisting of security analysis, risk management and compliance proceduresoDocumentation of ServiceNow considerations in alignment with change management procedures for third party vendor and vendor application implementation and installationoCoordination between Infosec, Legal, Compliance and Procurement departments in relation to contract specificsoValidation of IAM (identity and access management) using CyberArk Privileged Account SecurityCandidate's Name
EMAIL AVAILABLEiRobot Bedford MA (contd)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 IAMEnvironment: 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 2019BI/Enterprise Information Management departmentData Analyst/Data Steward/BSASr. Technical/Functional BSAPerforming Current State and Future State analysis on ITS Infrastructure for Unify Salesforce installation andImplementationAssessing changes and modifications to ServiceNow procedures within new environmentsRequirements 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 SalesforceQA/SQA analysis of data streams, input files to final DB destination (STM), business process flowsWorking with various stakeholders including ETL developers. Warehouses DBAs, technical resources, business representatives, Information Security, among othersWorking closely with PMO, setting milestones, guidelines and timelines, coordination with other projectsAgile methodology, Scrum, Sprints, Epic creation, User Story creationReviewed project exposure to GRC principlesAscertain SOX compliance conforming data to governance rules, business rules and policiesReviewing DD: and Data Dictionaries for accuracyWorking in HP Quality Center for management of Changes and enhancementsPowerPoint presentations for RFPs to Executive level review boardsSetting communication standards for requested projects, embedding standards in roadmapCurrent state to future state analysis, transition, systems installation and integration, report card and migration status, data lineage and traceability matrixEnvironment: SQL Server Environment, MS Office 365, Notepad ++, MS Excel, Windows10, ServiceNowMS PowerPoint 2010, SQL Server 2014 Management Studio, SSRS, Power BI, ServiceNow,Excel, power pivot, v-lookups, ITIL standards, vba, creation and presentation of RFPxCandidate's Name
EMAIL AVAILABLEBoston Private Bank/Boston Wealth, Boston MA March 2017 January 2018IT Infrastructure departmentData Analyst/Functional & Technical BSA/Vulnerability & Security Analyst BCDR Project/QA LeadWorking on BC DR Project Business Continuity Disaster Recovery as well as GRC attributesInterview IT Area owners concerning vulnerabilities as defined by FDIC and IT AuditCreate and document IT Asset Inventory spanning all areas of IT Servers, Switches, Routers,Workstations, laptops, telecommunications, teleconferencing, physical security features, ServerAdministration assets security assessmentAnalyze unencrypted protocols and default passwords establishing IAM standards and authorizingAccess and identity managementCreate Service Transition framework, roadmap to transition and networking/communication structureInterview Business and IT owners of assets, software and applicationsCreate and document IT Asset Provisioning Playbooks detail onboarding. Provisioning, Re-provisioningDecommissioning processes and proceduresProject conducted within Sarbanes-Oxley Act compliance & Security Information and Event MgtCoordinated project with PMO, Powerpoint presentation and visualizationsAnalyzing Unix scripting Perl scriptsConducted analysis reviews of incoming data enhancements and software upgradesQA/SQA analysis of data streams, input files to final DB destination (STM), business process flowsValidation of inventories and analysis of vulnerabilities via comparison of Qualys reports, Active Directoryand ManageEngine Asset Explorer (Asset and Licensing Management System)Determined risk exposure for IT assets and remediation and mitigation proceduresCreate new IT Change Management Procedures policy and documentDocument business and data processes for IT Audit department, Regulatory and Complianceaddressing vulnerability remediation and compliance
Reviewed project exposure to GRC principlesReview 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 policiesEnvironment: 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 proceduresCandidate's Name
EMAIL AVAILABLEThe Brattle Group, Cambridge MA August 2016 March 2017Legal Dept - CRM Systems - InfosecData Steward LexisNexis InterAction CRM/Data Analyst Research AnalystCrafted executable task lists for CRM enhancement projectsEnhanced Interaction CRM system via reconfiguring display fields and screensPerformed data cleansing via Data Change Management system and processes embedded in CRMQA/SQA analysis of data streams, input files to final DB destination (STM), business process flowsPerformed online research in pursuit of excellence in data qualityConducted analysis reviews of incoming data enhancements and software upgradesSupported and coordinated quarterly software upgrades and patchesValidation, Verification and Integration of infrastructure, internal and external data sources.Determined risk exposure for incoming data according to GRCCoordinated project with PMOWorked closely with in-house IT support at Brattle Group and external support at Lexis Nexis Enterprise SolutionsDocument business and data processes, Agile methodology, Scrum, Sprints, Epic creation, User Story creationResearch analyst in areas of energy, governmental, scientific, academic and cultural concernsCreate user manuals and quick reference sheetsCreated end user manual and instructions for Interaction access and functional useEnvironment: SQL Server Environment, M MS Office 365, Notepad ++, MS Excel, Windows 7, ExcelMS PowerPoint 2010, MS SharePoint 2010, Cisco Anyconnect Secure Mobility Client, SQL Server 2014Management Studio, SSRS, Snipper tool, Interaction Windows Client, Interaction Web Client,Interaction Administrator, LexisNexis, Interaction CRM system, SOAP, xml, xsd, apiState Street Corporation Boston MA September 2015 May 2016IBG SSGA Governance, Compliance and Regulatory _ InfosecSr. Business System Analyst/Customer Data Security AnalystCreated customer survey initial point of contact and client interview templates for analytical processesEnhanced interview process for Business and IT application owners as part of Discovery processWorked on Federally mandated Watch list project concerning AML (Anti Money Laundering),and Know Your Customer (KYC) in support of Fircosoft Sanctions ScreeningSubstantiate data governanceWorking with OFAC, PEP, Bank Secrecy Act (BSA) and FEP governance and complianceAnalysis and queries to prevent fraud and ensure cyber security within InfrastructureAnalysis 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/mapsValidation of identity and access management using RSA standardsProject conducted within Sarbanes-Oxley Act compliancePerform risk exposure and risk mitigation analysis, determine risk mitigation protocols in placeQA data streams and business processes in transit and at rest data traveling beyond firewalls and returningInterviewing both application business owners and application IT owners for sanctions screeningDocument business and data process flows including aspects of Business Continuity and Disaster Recovery and present findings to Compliance Division for assessmentWorking closely with PMO, setting milestones, guidelines and timelines, coordination with other projectsConducted interviews with business and IT application owners for over 3500globally based applications including US based, APAC and EMEA.
Reviewed project exposure to GRC principlesAscertain SOX compliance conforming data to governance rules, business rules and policiesWorking in HP Quality Center for management of Changes and enhancementsEnvironment: 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.gCandidate's Name
EMAIL AVAILABLEState Street Corporation Boston MA April 2015 September 2015IBG SSGA IT InfosecBusiness Analytics and Reporting Business IntelligenceSr. BI Business System Analyst/Enterprise Data AnalystWorked on MARS project, Marketing and Reporting Sales, CRM software product (Salesfocus) (Salesforce version of Tableau) customized for SSGA, hooked into Salesforce architecture and dataMARS is a top Asset Management visualization tool for AUMPerform 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 matrixTesting 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 SQLIn the role of System Administrator prepared environment, privileges and set up for QA usersProject conducted within Sarbane-Oxley Act compliance and GRC considerationsPrepared test data, testing scenarios, testing validations and logsBug tracking using JIRA and working with and reporting to ETL developersWorking within Regulatory and Compliance guidelinesSupporting weekly and semiweekly new software releases and software upgradesSet up and initiated Sales and Wholesaler teams covering all AdvisorsSet up channels, territories, boundaries, offices, representatives under firm auspicesAdaptive algorithms, creating advisor splits of commissions and earningsEnd User and Stakeholder negating for project requirements and hierarchy dispositionExport data to Excel spreadsheets for reporting and metric analysisWorking 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, IDQInfogroup / Yesmail Interactive Burlington MA February 2015 April 2015Business Analytics and ReportingSr. Business System AnalystWorked on Toys R Us marketing campaign and Implementation ProjectAnalyze UX User Experience on applicationsPerform systems metrics analysis on internally generated data as well as data supplied via externalVendors: 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 reportsCreate FRD for Vendor data acquisition; incorporate various data files, formatting, definitions and business rules and data validationsComparative 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 enhancementsWrite and run structured SQL queries for data analysisConducted Web analysis and click navigation analysis for User Experience UX analysis, QA analysisInterrogate Oracle DB in QA and Development Data Warehouses via SQLqueriesExport 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 promotionsEnvironment: 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, apiCandidate's Name
EMAIL AVAILABLEBest Doctors Inc. North America Boston MA June 2014 February 2015BI Analytics and Reporting Solutions and SupportSr. BI Business System AnalystSupported the BD BI team in transition to a Salesforce CRM and EDW environmentCreate and Populate BD BI Analytics Server with new documentation as well as revised and reformatted preexisting documentation, links, folders and cross reference mappingDocumenting: business processes, technical policies and procedures for Healthcare and InsuranceQA/SQA analysis of data streams, input files to final DB destination (STM), business process flows and exposure to GRCDocument and support new iteration of Cisco analytics and Cisco Unified CCX Historical Reports.Document and support Call Center processes, staging and event metricsDocument reporting requirements in relation to ICD 10 conversions and CPT process.Apply new standards and conventions to previously existing documentationPerform systems metrics analysis on internally generated data as well as data supplied via externalvendors, Zarca and Verisk, incorporating into reports via SQL queriesDefine Event and Stage metrics within Case AnalysisDocument business and data process flows including aspects of Business Continuity and Disaster RecoveryComparative and Systematic metric analysis via processes analysis via SQL queriesDesign, create and deploy Data and Documentation Archives and new archiving processDocument modifications to ServiceNow incorporating new processes for change and incident managementAgile methodology, Scrum, Sprints, Epic creation, User Story creationEnvironment: 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, ServiceNowFresenius Medical Care North America (FMCNA) Waltham MA March 2014 June 2014FMS BI Solutions and SupportSr BI Business System Analyst Sharepoint AdministratorWorked as part of the BI team in a multidimensional Healthcare environmentDesign, create and deploy FMS BI Reference Sharepoint site on FMC4ME internal intranetPopulate FMS BI Sharepoint site with new documentation as well as revised and reformatted preexisting documentation, links, folders and cross reference mappingDocumenting: business processes, technical policies and procedures, BOBJ (business objects) and KPI'sDocumenting: Financial solutions in the area of the General Ledger, Balance Sheet, P&LDocumenting: Metadata and Master Data, Medical procedures and terminology relating to HemodialysisWorking with Metadata governanceCoordinated projects with PMODesign, create and deploy metadata repository and associated documentationUsed Open Archival Information System (OAIS) as referential storage modelDesign, create and deploy Audit Log, Document naming standards and conventionsApply new standards and conventions to previously existing documentationDesign, create and deploy Data and Documentation Archives and new archiving processRun Bex Analyzer queries, extracting data and sql queriesDesign, create and deploy documentation with embedded links to SAP infrastructure including Guides to Hierarchy and Hierarchical Characteristic creation and usageEnvironment: 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 metricsCandidate's Name
EMAIL AVAILABLERGI-INFORMATICS Boston MA April 2013 February 2014Sr BI Business Systems AnalystWorked with Big Data Integration and Implementation teams performing data analysis, data validation and verification in support of Medical device software creation for HealthcareWorked with VA Hospitals/VISNS where medical devices are implemented within Federal RegulatoryauspicesSupported Quarterly releases of software enhancements along with upgrades to business processesWorked 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 creationWorked with third party vendors supplying inbound data and determining data gaps, data profiling, data modeling and extract process enhancements Draeger and Vista among othersPerformed 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 queriesProject coordination via PMOWorked with Big Data concepts including value name pairings, HL7 messaging via VISTA, Drager and VA systemsWorked with XML files and associated XSD schema files, Java Script Object Notation JSONTesting ETL processes, data delivery and system's requirements both data validation and system's verificationsDocument business and data process flows including aspects of Business Continuity and Disaster RecoveryFederal Government Security clearance - SecretEnvironment: 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 BIDS SolidWorks Waltham MA June 2012 February 2013Sr BI Business Systems AnalystWorked with Developers and Business stakeholders on various projects determining data pointsand processes needed for fulfillment including gap analysis and business requirementsSupported Quarterly releases of software enhancements along with upgrades to business processesWorked 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 reportsOBIEE environment incorporating business logic, object and business rulesMDM methodology applied to Master Data file, Nexus table, linking tablesRunning SQL queries to extract data verifying data and processing in an MDM environmentIncluding business rules applicationsPerformed: 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 validationCreated and deployed documentation of SharePoint sitesEnvironment: Oracle 11.g Windows 7 on notebooks, agile methodology, OBIEE, vbaHyperion Intelligence Designer MS Office 2010, MS Visio, MS Excel, MS SharePoint 2010Candidate's Name
EMAIL AVAILABLERBS Citizens Bank Cranston, RI February 2012 May 2012Sr BSADeveloped 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 reportsWorking 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 processesSupport 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 protocolsInterrogation of database for statistical reporting (Oracle 11g)Ran statistical SQL and SAS reports.Analyzing Unix scripting Perl scripts & KornshellProject conducted within Sarbanes-Oxley Act complianceAttended project meetings, coordinating with external vendors.Assisted on creation of data modeling and data mapping requirementsEnvironment: 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 2011Sr BSA/QA Lead/ Data Analyst/Data StewardWorked 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 WarehousePrepared functional specs including infrastructure, system and application specification documents.Worked within the marketing Data Warehouse preparing reports for end usersCreated 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 structureEnhanced existing business logic including business objects (product lines, credit lines)Ran statistical SAS reportsAnalysis and queries to prevent fraud and ensure cyber securitySupported 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 includingdata process flows from POS to cloud based marketing solutionsQA 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 RecoveryCreated test scenarios, test scripts, test case and crafted test result reportsProduction 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.Candidate's Name
EMAIL AVAILABLEOrchard Brands Beverly, MA June 2010 December 20Environment: 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-lookupsFidelity Investments, Boston MA/Smithfield RI August 2005 January 2010Data Analysis and Architecture DivisionSr BSA, Customer Data Steward of Customer Profile DB in CWE WarehouseWorked on multiple database development and reporting projects with emphasis on HyperionIntelligence Designer/Brio in an Oracle 10g environment within the CWE Data Warehouse, aCRM DatabaseAnalyzing Unix scripting Perl scriptsConstructed 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 productsMDM methodology applied to Master Data file, Nexus table, linking tablesRunning SQL queries to extract data in order to verify data and processing in an MDM environmentCreated and enhanced reports and reporting processes for divergent business unitsPerformed data profiling, data analysis, data mapping, logical and physical data model creation, business continuity, disaster recovery and data model diagramsContributed to various projects through all phases of SDLC while maintaining a solutions-oriented perspective; assist PM as project coordinatorCreated QA test |
