We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Waltham, MA

Summary

10+ years progressive experience working with large scale Oracle based data warehouse environments including Customer Relationship Management and Campaign Marketing. Performing in the role of Sr Business Systems Analyst, Sr Data Analyst, Sr Systems Analyst, SQA as well as IT Marketing Analyst and IT Financial Analyst. Broad experience working with dimensional models and Star Schema architecture with Object oriented data structures as well as large RDB's, OLAP and OLTP. Functional experience meeting with varied business clients, project stakeholders and end users. Conducted presentations in varied formats and conducted project meetings to facilitate identification of business requirements, data requirements to satisfy BRD's and creation of Functional Specifications. 10+ years experience working with SQL and SQL tools such as Hyperion Intelligence Designer and BI reporting tools such as Rational ClearQuest. Application experience spanning Financial, Banking, Retail, Health Care, Insurance, Software Development, Utilities, Higher Education and Telecommunications. In depth experience in documentation, including: Gap analysis, Functional specifications, Business Requirements Definitions, Data Requirements Definitions, System Design Specifications, Technical System Design, and Data Modeling, among others. MS Office experience including Powerpoint presentations and extensive use of MS Excel for project, milestone and task estimations. MS Visio used in data modeling. Project experience in converting business requirements into systems specifications, including workflows, data process flows, conceptual data models and varied data and business reports. 10+ years experience in data extraction and mapping, data quality, data profiling, data hygiene and data cleansing, data validation, meta data analysis, marketing data analysis and end user liaison. Broad experience setting up, performing and supporting UAT and SIT as well as coordinating testing phases within a project. Testing Warehouse environment interfaces, ETL processes and interfaces as part of a QA team and individual contributor. Setting up Sharepoint sites in a BI environment.

EXPERIENCE

Confidential Waltham MA

Sr Business System Analyst/Sharepoint Administrator

  • Working as part of the BI team in a multidimensional 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)
  • 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
  • Design, create and deploy metadata repository and associated documentation
  • 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
  • Design, create and deploy documentation with embedded links to SAP infrastructure including Guides to Hierarchy and Hierarchal 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,

MS Office 2010, MS Visio 2010, MS Excel 2010, MS PowerPoint 2010

Confidential

Sr Business Systems Analyst/Data Analyst

  • Working with Data Integration and Implementation teams performing data analysis, data validation and verification in support of Medical device software creation
  • Working with VA Hospitals/VISNS where medical devices are implemented
  • Supporting Quarterly releases of software enhancements along with upgrades to business processes
  • Working with third party vendors supplying inbound data and determining data gaps, data profiling, data modeling and extract process enhancements
  • Working with wireframes to visually support the business rules and interaction requirements.
  • Working with Data Integration and Implementation teams performing data analysis, data validation and verification in support of Medical device software creation
  • Supporting Quarterly releases of software enhancements along with upgrades to business processes
  • Working with third party vendors supplying inbound data and determining data gaps, data profiling, data modeling and extract process enhancements
  • Performing production support, requirements gathering, assisting in construct of business and data requirements, logical and physical system architecture creation, data mapping, ETL requirements definition.
  • Working with Big Data concepts including value pairings, HL7 messaging via VISTA VA systems
  • Working with XML files and associated XSD schema files
  • Testing ETL processes, data delivery and system's requirements both data validation and system's verifications
  • Federal Government Security clearance - Secret

Environment: XML and XSD (xml schema) processing, XLST (EXtensible Stylesheet Language), Agile Environment, MacBook Pro, MySql Workbench, MS Office 2010, TextWrangler, Sublime Text, Excel, and UNIX environment.

Confidential Waltham MA

Sr Systems Analyst/BSA/Data Analyst

  • Working with Developers and Business stakeholders on various projects determining data points
  • and processes needed for fulfillment – including gap analysis and business requirements
  • Supporting 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 and crafted test result reports
  • Performing: 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

Environment: Oracle 11.g Windows 7 on notebooks, Agile methodology, OBIEE, MS Office 2010, Visio, Excel.

Confidential

Sr QA Analyst/Data Analyst

  • Developed QA, UAT and SIT procedures in HP Quality Center. Set up Test Lab and Defect tracking.
  • 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.
  • Interrogation of database for statistical reporting (Oracle 11g)
  • Ran statistical SAS reports.
  • 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, Agile approach, HP Quality Center 9.2, SAS 9.2, WinSql Professional 9.2, MS Office 2007, Visio, Excel, Putty (Unix Access).

Confidentia

Beverly, MA
Sr Business Systems Analyst/Sr QA Analyst/IT Marketing Analyst/Data Analyst

  • 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 system and application specification documents.
  • Worked within the marketing Data Warehouse preparing reports for end users
  • Created SQL scripts and data base queries. 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
  • Supported gift card processing and promotional codes processing across all OB brands and third party vendors including MarketLive
  • Worked with eCommerce department and multichannel data processing procedures including
  • data process flows to cloud based marketing solutions
  • Worked in role of QA, 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
  • 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.

Environment: Oracle 11.g Windows 7, MarketLive, Endeavor change management system, Cognos 7, SAS Enterprise Guide, Visio, Excel, Waterfall approach, Commercial-Ware on AS400 Mainframe, Excel

Confidentia

Sr Business Systems Analyst/SA/QA/IT Marketing Analyst/Data Analyst

  • Worked on multiple database development and reporting projects with emphasis on Hyperion
  • Intelligence Designer/Brio on an Oracle 10g environment within the CWE Data Warehouse, a CRM Database
  • Constructed business and data requirements, data and gap analysis
  • Created and enhanced reports and reporting processes for divergent business units
  • Performed data profiling, data analysis, data mapping, logical and physical data model creation 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 scripts, use cases, expected result criteria and reports utilizing HP tools
  • in testing Warehouse environments, schema relationships, business processes, business rules and data flow process
  • Created Business requirements, Data requirements and System Design Specifications after meeting with clients and business stakeholders
  • Created and enhanced existing ETL procedures and business rules
  • Analytical and problem solving methodologies supporting the Customer Warehouse Environment(CWE) and Campaign Management DataBase(CMDB), in their daily processes and functionality
  • Support of other functional areas such as: Finance, Security, Governance, Risk and Compliance, 529 funds and cgf
  • Designed and created table architecture in conjunction with the DBA, Star Schema approach with Object oriented data structures
  • Designed, modified, and enhanced existing reports as well as creating production and ad hoc user reports, utilizing BI tool Hyperion Intelligence Designer (v8.3)
  • Created and ran SQL queries against Oracle Databases in a dimensional model based on star schema design creating new reports and enhancing existing reports including pivot reports.
  • Managed Change Management and Incident tickets via HP Service Center and Pace change
  • management system
  • Worked on Informix to Oracle database conversion project.
  • Managed configurations via Rational Clearcase
  • Utilized Agile and Waterfall Project methodologies and participated in RAD, JAD project sessions
  • Projects:
  • Created Sub-segmentation for Fidelity’s Household class of customers
  • Created restructured Marketing Service Program Code system
  • Created Point of Entry relationship process for retail customers
  • Interactive Messaging project in support of Fidelity.com included creating ETL processes and feeds data from various sources including Customer profile database in Customer Warehouse
  • Remediation of Insight In-Bound Call Processing system.
  • Installed and Supported MetaCenter, MetaData Repository by DAG

Environment: Windows XP,, Oracle 11.g Windows 7 on notebooks, Endeavor change management system, OS/390, MVS JCL, ab initio scripting, Korn, Unix scripting, Perl Scripting, Siebel data management, Hyperion Intelligence Designer, TOAD, AQT, Rational ClearQuest, Informix, Siebel systems, Visio, MS Project, Excel, Rational Requisite Pro, Excel, Data Modeler, Sharepoint, MetaCenter MetaData Repository by DAG, Agile and Waterfall approach, RAD & JAD sessions

Confidentia

Boston MA

Sr Systems Analyst

  • Worked on Web Server Migration team, assist in creating Test Plan and Test cases and scripts for Application and Server Testing.
  • Testing Responsibilities included testing MLI Foresight Application and Illustrations for Term Life and Annuities products.
  • Responsible for Defect reporting and tracking as well as UI testing, Server Connectivity and Network Configurations.
  • Utilized MS Project, Mercury Test Director and Mercury Quicktest Pro 8.2 in Windows XP environment.
  • Worked on ITAC (Inforce Tracking and Communication System) QA Project team.
  • Assist in creating Test Plan, Test Scripts and Test Cases as well as executing Test cases and Test Scripts.
  • Testing responsibilities included testing web based triggers, Default Field Validations, Field Process Validations, Cross Field Validations and System Process Validations for the ITAC System.
  • Responsible for Defect reporting and tracking as well as UI testing, utilizing MS Project, Mercury Quicktest Pro 8.2 and Mercury Test Director in Windows XP environment.

Confidentia

Boston MA
Senior Systems Analyst/Marketing Analyst/SAS Developer/BSA

  • Worked on DB2 Marketing Data Warehouse team.
  • Worked on DB2 to Teradata database conversion project.
  • Created DB2 tables for client reporting.
  • Using SAS 8.0, was Responsible for all demographic and statistical monthly regulatory reports to FCC covering New York, New England and all Mid-Atlantic states.
  • Created and ran SQL scripts for clients as well as ad hoc reporting
  • Responsible for producing monthly demographic regulatory reports for Verizon’s Mid-Atlantic States, New York & New England territories to the FCC.
  • Performed requirements gathering and creation of use cases.
  • Created test scripts, test cases and conducted testing in support of project implementation.
  • Created vb scripts, SQL queries.

Environment: OS/390, MVS JCL, DB2, SPUFI, QMF, SQL, SAS 8.0, SYNCSORT, COBOL, COBOL 2, MS Excel spreadsheets, FTP processes, Powerpoint, Network Data Mover (NDM), Excel, Endevor. As part of the DB2 to Teradata transition team responsibilities include: Data Modeling, Data Mapping, Running SQL queries on both platforms, bug reporting, tracking and resolution.

Confidentia

Westwood MA
Senior Systems Analyst/Developer

  • Application support and development for the MCH (Multi Currency Horizon) System.
  • Worked on Electronic Data Repository (EDR) team.
  • Converted Datacom DB to DB2 and wrote PLI programs to depipe files and load databases.
  • Worked on Physical Data Modeling (PDM) document and mapping database fields from Datacom to DB2. Created vb scripts, SQL queries.
  • Worked with Automated test tool Dii TraceIT. COBOL and PL1 coding involved in conversion.

Environment: OS/390, MVS JCL, CICS, DATACOM and DB2 as Mainframe DataBase, VB, SQL, PL1, MS Access, MS Excel, Rexx, Network Data Mover (NDM), Compuware,Changeman and Oracle 8i.

MAINFRAME ENVIRONMENT:

Languages &

Software:

SQL, QMF, FOCUS, SPUFI, BASIC, REXX, COBOL, COBOL II, COBOL 370/LE COBOL, PL1,

SAS 8.0, CLISTS, MICRO-FOCUS COBOL, OLM, OLQ, ADSO, ADSA, ADSG, IDDM, CICS

Databases:

DB2, IMS, IDMS/R, FOCUS, DATACOM

Files:

VSAM, GDG’s, GSAM

Op. Systems:

OS/390, MVS/ESA/XA (TSO/E/ISPF) VM/ESA (CMS) (JCL), OS/VS, DOS/VSE, VMS, ROSCOE

Machines:

IBM ES9000 (ENTERPRISE SERIES), IBM 3081, IBM 4381, Various PC Workstations, HP, VAX, IBM AS400, OS/390

LAN’s:

BANYAN VINES, NOVELL, ETHERNET, JUMBONET

Tools:

DYL280 II, Synchsort, IDCAMS, IEBGENER, PANVALET, EASYTRIEVE +

Hire Now