FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

Senior Business Data Analyst

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 Senior Business Data Analyst Skills

Below we've compiled a list of the most important skills for a Senior Business Data Analyst. We ranked the top skills based on the percentage of Senior Business Data Analyst resumes they appeared on. For example, 17.9% of Senior Business Data Analyst resumes contained Business Requirements as a skill. Let's find out what skills a Senior Business Data Analyst actually needs in order to be successful in the workplace.

These are the most important skills for a Senior Business Data Analyst:

1. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in Senior Business Data Analyst jobs:
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements.
  • Analyzed business requirements and converted them into System Functional Requirements containing Business Rules and Functional and Non-Functional/ Technical requirements.
  • Analyzed business requirements and functional requirements from clients and writing of Data Dictionary, Preliminary and Final Function.
  • Composed Project Charter, Functional and Business Requirements documentation to support the sourcing of derivatives data.
  • Analyzed the physical data model to validate the business requirements and provide recommendations to the management.
  • Performed data mapping on requirements and developed designs based on the business requirements.
  • Translated business requirements into working Logical and Physical Data Models.
  • Work with Business owners to developed business requirements for projects.
  • Developed test plans, test design specifications and test cases to match business requirements and test software to ensure proper operation.
  • Evaluated and tested the new and modified software application to verify that programs function per both technical and business requirements.
  • Develop business requirements document to include functional requirements, project scope, objectives, dependencies, benefits and risks.
  • Collected Business Requirements and translated them into data needs, defining and documenting the application and business rules.
  • Developed test conditions and test cases based on business requirements, various product lines.
  • Gathered business requirements in the form of Business requirement document (BRD).
  • Facilitate JAD sessions and brainstorming session to define and analyze the business requirements.
  • Defined Project Scope and created Business Requirements Document (BRD).
  • Maintained requirement traceability between business requirements and functional requirements in system functional document.
  • Traced Business Requirements (BRD) to Functional Requirements using Requirements Traceability Matrix.
  • Maintained the traceability matrix until business requirements were signed off.
  • Process reengineering to improve business requirements elicitation to improve quality and development consistent methodology.

Show More

9 Business Requirements Jobs

No jobs at selected location

2. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Senior Business Data Analyst jobs:
  • Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
  • Researched and estimated data warehouse enhancement requests (requirements gathering) and assessed business impact and value.
  • Researched and estimated error correction strategies which enhanced data credibility stored in Data Warehouse.
  • Organized and preserved metadata for multiple Data Warehouses.
  • Designed Data Warehouse Life Cycle using Ralph-Kimball Methodology.
  • Developed the data warehouse model (star schema) for the proposed central model for the Project.
  • Designed and developed reports for the data in the Data Warehouse using Business Objects / excel.
  • Used SQL query to analyze the J&J source systems and existing data warehouse data.
  • Phase I: Integrated 122 data elements into the data warehouse from 15 receivable systems.
  • Experience in Conceptual design, Logical design, physical design of Data Warehouse projects.
  • Implemented and maintained the MDM (Master Data Management) in the data warehouse.
  • Interacted with client teams during various phases of the data warehouse build.
  • Reported bug to BI team while testing/validating data warehouse.
  • Involved in creation of Enterprise Data Warehouse.
  • Involved in data warehouse design.
  • Gathered data from the legacy system (db2) to the present updated system using data warehouse tools such as Informatica.
  • Worked with the developers for creating various DataMarts from data warehouse and generated [drill down] reports using Cognos.
  • Project 1: Client Acquisition Reporting This project implemented new Data Warehouse for the Citibank PWN group.
  • Interacted with the Data Modelling team to understand the designing of the data warehouse and data mart.
  • Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.

Show More

1 Data Warehouse Jobs

No jobs at selected location

3. Test Cases

demand arrow
high Demand
Here's how Test Cases is used in Senior Business Data Analyst jobs:
  • Develop technical and functional documentation including system flows and test cases summary.
  • Collaborated with QA team in reviewing test plans and test cases ensuring that a final application catered to the user requirement.
  • Developed Test cases based on Functional Specifications Documented, * Conducted extensive Manual Testing by retrieving data using SQL queries.
  • Involved in creation of test plan, test scenarios, test cases for unit, system and system integration testing.
  • Created test plans, test cases and test scenarios for multiple projects and conducted and communicating feedback to development teams.
  • Document test cases for web based compliance tool, log defects in the Quality Center, run integration test.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Document test cases and test flush job application process to ensure work orders match to the closest personnel.
  • Designed the test cases, test scripts and coordination of testing activities for various NESS application releases.
  • Created Test cases from scratch by using Business & Functional Requirement Specs, HLD and Wire Frames.
  • Involved in documenting of Test Plan, Test Cases, and Defect Status Report.
  • Created and validated test cases that directly traced back to requirements and business objectives.
  • Created and managed Test Plans, Test Cases, and Test Procedures.
  • Assisted Quality Assurance Testers in preparing System Test Cases and clarified Requirements.
  • Involved in preparing the test plans and test cases.
  • Created test plans, test cases and test scripts for UAT.
  • Performed Regression Testing, Smoke Testing, Integration Testing, and User Acceptance Testing using the Test Cases created in Rally.
  • Analysed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
  • Test cases and identified defects were created and managed in HP ALM (Application Lifecycle Management) tool.
  • Generated Test Status Reports for the Test Cases and validated SQL Queries constructed by SQL Server Database.

Show More

4. Data Dictionary

demand arrow
high Demand
Here's how Data Dictionary is used in Senior Business Data Analyst jobs:
  • Maintained data dictionary by revising and entering definitions.
  • Created a master data dictionary for all GE Capital products by collaborating with all teams within the Enterprise framework.
  • Updated Data Dictionary - metadata, taxonomy, fields, tables, etc - for SDLC 5.10 Release.
  • Validated and revised data map and data dictionary with metadata for the AML Risk Assessment reports.
  • Worked with Business Data Requirements group to create an enterprise wide Data Dictionary through Advantage program.
  • Designed data mapping for source to target system, defined the data dictionary and dependencies.
  • Prepared the data dictionary for knowledge transfer to the development team and future use.
  • Mapped data attributes back to the comprehensive data dictionary for data lineage.
  • Project manager for data mapping, and maintained Data Dictionary.
  • Experience with Metadata tables, Data dictionary and Data Glossary.
  • Created and maintained Data Dictionary and pursued to reach consensus.
  • Created Data Dictionary, ETL Diagrams and Data Mapping.
  • Created Data dictionary using ERWIN modeler.
  • Prepared Data Dictionary/Meta Data of the data elements.
  • Created Data Dictionary, Created ER diagram, data mapping and logical data modelling.

Show More

1 Data Dictionary Jobs

No jobs at selected location

5. User Acceptance

demand arrow
high Demand
Here's how User Acceptance is used in Senior Business Data Analyst jobs:
  • Coordinated User Acceptance Testing/Defect prioritization for incorporating the latest system enhancements.
  • Provided user acceptance guidelines and certified additions to subject area.
  • Prepared documents to conduct user acceptance testing.
  • Created various test cases and test scripts and expected results set for User Acceptance Test based on the requirements and scope.
  • Assisted the QA group in developing and documenting test cases, system testing and User Acceptance Testing.
  • Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
  • Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.
  • Interacted with the users in the User Acceptance testing in the ERMS and the OCS Merger projects.
  • Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
  • Developed, executed and validated user acceptance test plans (UAT) and implementation support.
  • Captured requirements for BI reporting and also worked on user acceptance validation of the reports.
  • Involve in user acceptance testing for the modules and Full Development Life Cycle Implementation.
  • Engaged in system testing during User Acceptance Testing (UAT).
  • Provided business support to conduct User Acceptance Test (UAT).
  • Facilitated user acceptance testing and test strategies with Information Systems Group.
  • Validated User acceptance testing for the data quality rules framed.
  • Defined the scope of testing for user acceptance testing.
  • Participated in user acceptance testing for the UDD application.
  • Worked with the users to do the User Acceptance Testing (UAT).
  • Experience in working with application developers, Technical Architects, Enterprise Architects, DBAs, QA Testers and User Acceptance Testers.

Show More

2 User Acceptance Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Visio

demand arrow
high Demand
Here's how Visio is used in Senior Business Data Analyst jobs:
  • Conduct in-person/ online interview sessions with various stakeholders to solicit their visions/ requirements about the opportunity/ initiative at hand.
  • Work closely with other management personnel, including business partners and other divisions.
  • Interacted with the stakeholders to get a better understanding of client business processes and document project vision with business requirements.
  • Lead Project Manager of the Procurement division internal website rewrite which included vendor relationship portals and buyer data querying.
  • Served as the Senior Business/Technical Project Manager on ALL internal and external IT projects for the Corporate Procurement division.
  • Elicit , execute and administer Change Management/business requirements around data errors and revisions including working with internal departments and vendors.
  • Led the development efforts of a multi-million dollar online procurement analysis application used throughout various divisions and remote production locations.
  • Developed, maintained and presented to executive management the annual multi-million dollar division IT development budget.
  • Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
  • Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
  • Used MS Visio to create and implement Business Process flow diagrams and monitored the flow to successful completion.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
  • Prepared process flow diagrams; sequence diagrams; context diagrams in UML notation using Visio.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
  • Address all web-UI integration points with Cablevision for the Mountain States migration.
  • Used MS-Visio to create Data Flow Diagrams as a Structured Analysis tool.
  • Designed 0-7 level process flow for claims managers using Microsoft Visio.
  • Created use-case models using Visio/ RSA.
  • Modeled the same in MS Visio.
  • Created process, data flow diagrams and wireframes using Visio and Word as well as test plans in Word and Excel.

Show More

7. Sequence Diagrams

demand arrow
high Demand
Here's how Sequence Diagrams is used in Senior Business Data Analyst jobs:
  • Create detailed documentation (Design specification, Data mapping, Data flow and sequence diagrams) and verify data mapping.
  • Analyzed and designed Use Case Diagrams, Class Diagrams, and Sequence Diagrams to depict process flows and PowerPoint presentations.
  • Used Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagrams.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
  • Authored Data Flow diagrams, Sequence diagrams and Business Process models with special detail to Sub-Processes.
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Designed Use Case diagrams, Class diagrams, Activity diagrams, Sequence diagrams.
  • Created Use Cases, State diagrams, Sequence Diagrams and Activity Diagrams.
  • Created Sequence Diagrams and State Diagram.
  • Designed and developed Business Flow Diagrams, Activity Diagrams, Sequence Diagrams, and Object Oriented Models using MS Visio.
  • Analyzed requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using MS Visio.
  • Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.

Show More

8. Data Analysis

demand arrow
high Demand
Here's how Data Analysis is used in Senior Business Data Analyst jobs:
  • Worked towards improving efficiency and productivity in data analysis by analyzing people behavior, studying different aspects involved in data analysis.
  • Performed extensive Requirement Analysis including data analysis and gap analysis.
  • Conducted data analysis on raw data from State Vendors in order to identify unapproved work, duplicate work and unnecessary work.
  • Provide Business as Usual (BAU) support and Production support for the NESS application and perform data analysis.
  • Conducted data analysis between projects residing in different database servers (SQL Server) and documented the results.
  • Improvise the data build packages by doing Risk/Gap Analysis, Requirements Tracing, Data Analysis using SQL queries.
  • Create and use SQL queries and stored procedures for data analysis/validation and applications testing (scenarios).
  • Created detailed data assessment reports and pivot table reports for each system showing all data analysis.
  • Provide data analysis and reporting as needed in support of both state and federal reporting requirements.
  • Perform data analysis on Bank Data Mart projects for Marketing and Client Management Intelligence departments.
  • Created Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
  • Conduct data analysis when necessary in order to determine root cause of data inconsistencies.
  • Employed process and data analysis to model a Customer Information Business System.
  • Worked with Internal modeling team for data analysis and profiling.
  • Demonstrated ability to build a analysis approach, execute data analysis and documented issues in accordance with standards.
  • Performed data analysis tasks within data factory/Lifecycle safety environments.
  • Created permanent formatted SAS data sets and used SAS/BASE and its tools for pre-processing data, data analysis and statistical analysis.
  • Carried out data analysis from existing database and generate new logical data model required for to-be system.
  • Lead data analysis efforts on RBC Centura Bank Anti Money Laundering (AML) regulatory projects.
  • Performed data analysis as required to create adhoc reports.

Show More

5 Data Analysis Jobs

No jobs at selected location

9. ETL

demand arrow
high Demand
Here's how ETL is used in Senior Business Data Analyst jobs:
  • Facilitated/Developed Systems/Data Integration strategy; source system data ETL strategy, data staging, movement and aggregation strategy.
  • Worked with application developers to update logic tables in Oracle Discoverer application and ETL environment.
  • Analyzed and documented differences/Gaps between current ETL processes and potential enhancements.
  • Used SAS Business Intelligence and Data Integration studio for ETL and to schedule and execute jobs on a weekly basis.
  • Designed DataStage/SSIS ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Provided ETL Transformation Rule and mapping for staging tables and to insert the data in all the ODS tables.
  • Researched about data issues in the report and reported them to the team to correct them in ETL.
  • Validated the data sent that was in UODS (ETL process) through manual and automated procedures.
  • Worked closely with ETL Developers and DW Architect to gain in-depth understanding of Data Warehouse.
  • Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
  • Experience with various ETL, data warehousing tools and concepts.
  • Designed and developed ETL process according to the business logic.
  • Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
  • Designed various Informatica ETL load patterns which include SCD Type I, Type II, full load, etc.
  • Claim Center data base Formulated Unit Test Plans, Test Cases to ensure the correctness of ETL process.
  • Lead the JAD, Scrum sessions with the ETL and development teams Web portal and web applications.
  • Worked with the ETL developers on the filtering logics for the source to target mappings.
  • Created ETL architecture, and provided strategy for data cleansing, data quality and dataconsolidation.
  • Perform ETL Informatica Design Strategy for pulling data from ODS to OLAP databases.
  • Respond to ad-hoc client requests in a timely fashion Developed ETL packages using Ethority tool.

Show More

2 ETL Jobs

No jobs at selected location

10. UAT

demand arrow
high Demand
Here's how UAT is used in Senior Business Data Analyst jobs:
  • Analyzed data and evaluated the results and formed conclusions before providing and implementing process.
  • Evaluate existing application products that address client requirements for Identity and Access Management.
  • Evaluated customer approach for computer financial systems.
  • Conducted the GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system.
  • Prepared User Acceptance Test Cases and ensured that all Business and Functional Requirements are adequately covered by the UAT Cases.
  • Participate in Code Reviews, System Testing and UAT followed by production verification, post production testing and support.
  • Worked with the clients on final signing process in the User Acceptance Testing (UAT) stages.
  • Developed and executed test scenarios, test cases using SQL queries for SIT and UAT Testing.
  • Supported Development, QA and UAT teams for any clarifications during development and testing phase.
  • Work closely with operational and IT departments to evaluate and problem solve for new platform.
  • Conducted User Acceptance Testing (UAT) and verified performance, reliability and fault.
  • Build scripts for to validate business rules in QA, UAT & Post production.
  • Performed UAT within the test environment and documented/tracked defects through to resolution.
  • Created Test Scenarios and Test Cases to perform SIT & UAT.
  • Ensured adequate quality controls were in place and consistently performed.
  • Preformed UAT testing on the system.
  • Performed Business Requirements, Functional Specifications, and UAT walkthroughs with the team members and incorporated modifications and obtained Sign-off.
  • Designed new methodology of evaluating subjective theft results utilizing analytical processes.
  • Performed Gap & Risk analysis from As-Is and To-Be documents, to evaluate product features for traceability to functional business requirements.
  • Manage and be responsible for the end-to-end lifecycle from requirements gathering to UAT and delivery to Customers.

Show More

1 UAT Jobs

No jobs at selected location

11. JAD

demand arrow
high Demand
Here's how JAD is used in Senior Business Data Analyst jobs:
  • Scheduled, managed, elicited and communicated requirements through JAD and requirements sessions.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors.
  • Lead the team of 5 DA's and actively participated in resolving the issues through JAD sessions with various LOB.
  • Conducted Joint Application Development (JAD) sessions and walk in interview with the business users to gather requirements.
  • Facilitated and participated in JAD sessions with the Stakeholders and technology teams and worked as a liaison between them.
  • Gather requirements after JAD sessions with the purpose of defining the functional business, Data and system requirements.
  • Facilitated JAD sessions whenever needed to resolve conflicts and for future task assignment relating to the project.
  • Conducted requirement elicitation techniques such as JAD sessions, Interviews, Questionnaires and brainstorming sessions.
  • Lead as well participated in JAD sessions and interacted with various functional leads and analysts.
  • Conducted JAD sessions to validate the controlled input data and expected results.
  • Conducted JAD sessions gathered business requirements, business rules and business processes.
  • Conducted JAD and brainstorming sessions to gather the business level requirements.
  • Facilitated JAD sessions to confirm understanding of the As-Is Business Process.
  • Included JAD sessions, wire-framing, report specifications and solution prototyping.
  • Conducted Joint Application Development (JAD) sessions with IT groups.
  • Lead scoping and requirement gathering JAD sessions.
  • Conducted JAD sessions and created reports for Budgeting, Finance and Project Management departments of Pima County.
  • Created use cases and flow documents * Coordinated JAD sessions to understand the user requirements and implementation.
  • Elicit and gather business requirements from various stakeholders using JAD and scenario walk-throughs 2.
  • Facilitate workgroup meetings and JAD sessions to gather, verify and approve requirements.

Show More

12. SME

demand arrow
high Demand
Here's how SME is used in Senior Business Data Analyst jobs:
  • Conduct complex data analysis to support the organization's data quality assessment effort; identify issues and recommend solutions for improvement.
  • Identified and implemented contingency plans and performed risk management assessments.
  • Performed assessment of business requirements, mapping with SAP functionality.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Facilitated requirements meeting, JAR/JAD discussions with business users and subject matter experts (SME) to elicit requirements.
  • Helped SME's identify Data abnormalities through data profiling and identifying the root cause of issues through SQL queries.
  • Proposed implementation of the key fields in support model with business justification post interaction with product line business SME.
  • Perform data analysis, assessment and reporting including charts, graphs and tables to support proactive problem solving.
  • Created the Data Assessment and Scoping document to capture the ETL mapping for the new ETL feeds.
  • Performed risk assessment; devised at least a plan of action for each risk found.
  • Involved in current state project assessment, Gap Analysis, and gathering business requirements.
  • Investigate inquiries and provide an accurate assessment to sales and upper corporate management.
  • Provided root cause analysis & recommendations to SME & technology with fixes.
  • Conducted meetings with SME's and analysts on a regular basis to gather requirements and analyze workflows.
  • Interviewed business users, SMEs, end users and gathered requirements for To-Be Systems.
  • Interviewed business SME's to solicit requirements and remediate gaps in business requirements.
  • Clarified and prioritized requirements by conducting brainstorming sessions with the stakeholders and SMEs.
  • Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
  • Created User stories using JIRA after having sessions with the SME'S and then discuss those requirements with the IT team.
  • Determined KPIs for Verizon Wireline Network Analytics by participating in JAD sessions and meetings with domain SMEs.

Show More

13. UML

demand arrow
high Demand
Here's how UML is used in Senior Business Data Analyst jobs:
  • Used UML, for gathering requirements, created Use Case Diagrams, and Use Case Specification document (USD).
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Used UML to produce Use-Cases, use case diagrams and Activity diagrams to explain process flows and functional specifications.
  • Utilized UML methodology or iterative approach like RUP to configure and develop standards, procedures, and process.
  • Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
  • Developed Use Cases/use case diagrams and state chart diagrams using UML wherever needed.
  • Developed UML diagrams like Activity diagrams and Use Case diagrams.
  • Translated Use Cases into Activity Diagrams in UML as appropriate.
  • Developed Use cases and functional specifications and provided UML diagrams.
  • Involved in business process modeling using UML through Rational Rose.
  • Developed Use Case with UML for new product functionality.
  • Prepared the UML Use Cases using Rational Rose.
  • Performed System Analysis and Design using UML.
  • Created Use Case Diagrams, Scenario, Data Flow Diagrams, Activity Diagrams and ER Diagrams using UML in MS Visio.
  • Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
  • Followed the UML based methods using MS Visio to create Business Flow Diagrams and Use Case Diagrams.
  • Created UML diagrams in MS Visio.
  • Improved documentation and customer communication Skills Used Sparx Enterprise Architecture, VBScript, JavaScript, UML

Show More

14. Sharepoint

demand arrow
high Demand
Here's how Sharepoint is used in Senior Business Data Analyst jobs:
  • Developed an automated SharePoint tool for cross-functional delivery schedule management for the project.
  • Conducted requirements gathering interviews with Management and end-users for their SharePoint 2007 implementation.
  • Created and Maintained Project and Corporate Document Management using SharePoint.
  • Maintained documents in IBM FileNet and SharePoint environments.
  • Migrated documents from shared drives to SharePoint environment.
  • Documented all the discussions, stored the requirements and tracked the changes maintaining the updated versions of document on the SharePoint.
  • Created the SharePoint document storage hierarchy and trained the staff on the usage of the document library.
  • Worked on TFS (Team Foundation Server) for managing bugs and SharePoint for document storage.
  • Prepared project plan for building ORACLE database and implementing ETL and constantly updated SharePoint site.
  • Used SharePoint to store document and version control.
  • Used SharePoint to monitor existing project issues.
  • Maintained MS SharePoint sites for all projects.
  • Key Technologies/Skills: Microsoft Office, JIRA, MS SharePoint, DKAN, SDLC, Tableau BI
  • Conducted project management activities and utilized Microsoft SharePoint to control all documents and project deliverables.
  • Used Sharepoint for content management for Business Analysis and Reporting.
  • Managed project documentation/ versioning using MS SharePoint.
  • Created and Maintained the SharePoint 2013 Team sites with latest Documentation available from different Teams.
  • Worked on designing Crystal reports and integrating them into Sharepoint.
  • Use iRise and SharePoint for business requirements.
  • Created SSRS Reports using Report builder Developed several workflows with SharePoint using K2 for streamlining business processes.

Show More

15. QA

demand arrow
average Demand
Here's how QA is used in Senior Business Data Analyst jobs:
  • Contributed to organization's receipt of NCQA Certification.
  • Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing.
  • Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
  • Scheduled meetings with developers, system analyst and QA to collaborate resource allocation and project completion using MS Project.
  • Elicited business and technical requirements, coordinated IT development tasks, directed QA, and trained end-users.
  • Assisted QA in test planning and QA environment setup to ensure maximum test coverage for requirements.
  • Coordinated with the QA Team for testing activities across multiple systems and managed Conversion test execution.
  • Worked daily with development and QA teams across the US, Hungary, India and Canada.
  • Played a QA role writing test plans for testing correctness of ETL processes and database contents.
  • Resolved issues between front-end developers, middle-tier developers, QA team, and provided suggestions/feedback.
  • Verified the Business Scenarios on new builds to allow extended testing by the QA team.
  • Prepared Test plans and assisted the QA team in Unit testing and Integration testing.
  • Designed and implemented SQL queries for QA testing and report / data validation.
  • Organized the Quality Analyst (QA) walk through to explain proposed changes.
  • Promoted to Team Leader, QA Manager then Claims Senior Business Manager.
  • Developed Test plans and mapped them to requirements with QA team.
  • Assisted QA manager to develop test plan and test case.
  • Facilitate technical discussion with development and QA teams.
  • Worked on QA efforts related to new releases.
  • Installed/Configured Auditor in Dev, QA and Prod environments for user activity logging.

Show More

16. Windows XP

demand arrow
average Demand

17. Sdlc

demand arrow
average Demand
Here's how Sdlc is used in Senior Business Data Analyst jobs:
  • Gather and manage Business/ Stakeholder/ functional requirements through the complete SDLC, using iterative project methodology.
  • Worked effectively in Agile development environment as well as SDLC/waterfall environment.
  • Designed and developed Project document templates based on SDLC methodology.
  • Utilized corporation developed Agile SDLC methodology.
  • Established Retail Finance, ILC & CRE model setup in various environments with approvals for various phases in SDLC.
  • Lead JAD sessions and act as the lead facilitator for various projects from start to finish through the SDLC.
  • Developed project schedules, conducted project status meetings and managed resources during all phases of the SDLC.
  • Involved in complete SDLC process, supporting business, developing and testing teams for meeting FAS140 compliance.
  • Model storm data throughout the project's complete Software Development Life Cycle (SDLC) using JIT.
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Developed requirements in accordance with CMS' SDLC and CMMI Level 3 standards.
  • Work with the full SDLC, elicit, analyze and define requirements.
  • Supported the data model design and ETL development at phases of SDLC.
  • Ensured all artifacts complied with corporate SDLC Policies and Guidelines.
  • Gathered Requirements for SDLC Loan Applications process.
  • Implemented Agile and Waterfall methodologies for SDLC.
  • Gathered requirements for the Adapt SDLC Application.
  • Designed and developed project document templates based on SDLC methodology Performed extensive Requirement analysis and developed use cases and workflows.
  • Created and maintained requirements traceability matrix (RTM) and established traceability across all SDLC phases.

Show More

18. Subject Matter

demand arrow
average Demand
Here's how Subject Matter is used in Senior Business Data Analyst jobs:
  • Conducted JRP sessions to engage Subject Matter Experts in business planning, business analysis and business requirement definitions.
  • Served as a Subject Matter Expertise for multifamily secondary mortgage data.
  • Subject matter expert on quality improvements for product/affiliated service lines.
  • Involved Subject Matter Experts in requirements planning/gathering sessions.
  • Applied subject matter knowledge to review, process, and evaluate data to develop trends, patterns, and profiles.
  • Served as the subject matter expert and primary point of contact for external clients for the Medicare Health Support pilot.
  • Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.
  • Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
  • Partnered with the department subject matter experts to create and coordinate over 250 project requests each year.
  • Worked as Subject Matter Expert for 2 data domains in Fidelity and answered all Data related questions.
  • Worked with Compliance, Subject Matter Experts and Data Owners to create user acceptance test scenarios.
  • Served as a mentor/trainer for new Business Analysts, Subject Matter Experts and Data Stewards.
  • Served as the subject matter expert in Service Catalog Requests, Service Now ticketing systems.
  • Formed and led the data quality review committee consisting of subject matter experts.
  • Subject matter expert for Medicare Part B for the data analysis team.
  • Subject matter expert for integrating HR Processes with HR reporting application.
  • Acted as client and vendor data subject matter expert.
  • Identified and developed Process Flow Diagrams for various business processes and validated the flows with Subject Matter Experts (SMEs).
  • Identified, through elicitation of cross service line subject matter experts, the Global Analytics big data use cases pipeline.
  • Contract Assignment Oversee the acquisition, analysis, strategy and dissemination of subject matter knowledge.

Show More

19. Informatica

demand arrow
average Demand
Here's how Informatica is used in Senior Business Data Analyst jobs:
  • Performed Data Analysis and developed Data Mapping documents for ETL Informatica projects.
  • Prepared a handbook of standards and Documented standards for Informatica code development.
  • Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
  • Used existing Informatica PowerCenter Package ETL mappings to reverse engineer the Basel Data Warehouse Commercial Loans Origination System's data feeds.
  • Communicated with Informatica (ETL) developers in order to figure out where and why a data discrepancy exists.
  • Provided direction to Informatica ETL developers on the business rules to be used for transforming data.
  • Research and Identify Customer and Address merge with in the Informatica system.
  • Experience in copying the data from different RDBMS systems using Informatica.
  • Developed ETL mappings using Informatica to load data into data warehouse.
  • Used UNIX scripts for scheduling and executing Informatica work flows.
  • Profiled the data using Informatica Data Quality (IDQ).
  • Use Informatica PowerCenter to move data MDM into the hubs.
  • Monitored the Informatica workflows using Power Center monitor.
  • Design and build Informatica mappings/workflows.
  • Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.
  • Created ETL using Informatica by applying best practices and error handling process.
  • Work on formulating the ETL rules using Informatica and Ab Initio.
  • Created Transformations like Lookup, Joiner, Rank in Informatica designer.
  • Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
  • Develop complex ETL mappings using Informatica Powercenter and sessions using Informatica workflow.

Show More

20. XML

demand arrow
average Demand
Here's how XML is used in Senior Business Data Analyst jobs:
  • Performed GAP analysis of System Integration solution wise for migration CPC with XML and UML for file feed and file transformation.
  • Performed Data Analysis tasks on warehouses from several sources like Oracle, XML etc and generated various reports and documents.
  • Analyzed existing processes, Extracted XML/COBOL files, for successful FACETS implementation and integration with other proprietary tools/application.
  • Create MS Access databases and reporting from XML and SQL to Excel and VISIO displays.
  • Design and develop the data load process using XML Style sheets and ACORD.
  • Used a converter to open a flat file as an XML document.
  • Generated XML documents using the XML Output Stage.
  • Used Castor to create objects from XML documents.
  • Confirm and Map SWIFT and XML messages for trades based of Securities, Cash & FX.
  • Loaded an EDI file in convert-to-xml.
  • Worked with 8 distributors to enable dataflow to Toro via XML transactions to eliminate EDI costs.
  • Experience validating XData created by Xengine for data mapping of X-12 to XML format and in turn to TRLog format.

Show More

21. Toad

demand arrow
average Demand
Here's how Toad is used in Senior Business Data Analyst jobs:
  • Retrieved and manipulated the data in Unit environment using Toad for Oracle and Toad for Data Analysts.
  • Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
  • Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
  • Extracted files from Toad(Query Tool) to use as input into an Access database.
  • Queried Oracle and SQL server databases for data analysis using TOAD and SQL Server Management Studio.
  • Defined the duplication of data and columns between tables using TOAD and SQL.
  • Extract data from warehouse with help of TOAD, SQL and SQL Server.
  • Run the SQL queries using TOAD and SQL Navigator.
  • Use Toad for Data Analyst for running the required complex SQLs for ETL testing in different DWH systems and data mart.
  • Worked on data quality tickets, performed analysis and provided solutions for issues on EDW and other databases using Toad and Informatica
  • Use Toad and HP SQL Editor to write Database queries to pull Data Sets Business Intelligence Model and design architecture experience.
  • Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.

Show More

22. Suite

demand arrow
average Demand
Here's how Suite is used in Senior Business Data Analyst jobs:
  • Experienced facilitating the design and configuration of NetSuite, developing reports on SSAS & SSRS on SQL Server (2005/2008/2008R2).
  • Determined what tools and methods were needed/best suited for customer data migration.

Show More

23. Pl/Sql

demand arrow
average Demand
Here's how Pl/Sql is used in Senior Business Data Analyst jobs:
  • Involved in performing extensive Back-End Testing by writing SQL queries and PL/SQL stored procedures to extract the data from SQL Database.
  • Executed SQL queries, PL/SQL stored procedures, triggers on back end as a part of data analysis and data validation.
  • Created and Maintained Oracle Databases, using Modules, Reports, Queries and PL/SQL, for Call Center.
  • Created PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic.
  • Developed and enhanced the PL/SQL stored procedures for reporting purpose reducing the execution time by 25%.
  • Provided PL/SQL queries to developer as source queries to identify the data provided logic to assign.
  • Created and maintained Data Dictionary and PL/SQL querying on Staging, Data warehouse and Data Marts.
  • Developed, tested and implemented new PL/SQL Packages, Functions and Stored Procedures, Triggers etc.
  • Use of Dynamic SQL and EXECUTE_IMMEDIATE functionality to perform DDL in PL/SQL blocks and procedures.
  • Developed PL/SQL modules to do data conversion and cleansing from SQL server to Oracle 9i.
  • Prepared SQL & PL/SQL Queries to validate the data in both source and target databases.
  • Developed a number of complex PL/SQL packages, stored procedures, triggers and functions.
  • Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
  • Created Custom Reports and PL/SQL Queries using Inner and Outer Joins.
  • Used PL/SQL and SQL*Loader to load data into Oracle database.
  • Created test scripts for all the test cases in PL/SQL.
  • Worked on various PL/SQL procedures and Sql codes to generate Test cases.
  • Utilized and created new PL/SQL and Essbase reporting to derive statistics, trends and analysis data.

Show More

24. Project Management

demand arrow
average Demand
Here's how Project Management is used in Senior Business Data Analyst jobs:
  • Provided technical engineering support and project management for the design, engineering and development of Visa merchant profile system.
  • Provided project manager regular status updates and assisted the overall project management taking initiative.
  • Project management of projects and business specifications.
  • Assigned tasks monitored and tracked progress of process to provide status update reports to the project management on a weekly basis.
  • Identified and continuously acted to improve individual and team knowledge of new technologies, business processes and project management skills.
  • Updated project management guidelines within organization to improve ability to meet time lines, budgets and objectives.
  • Collaborated well on all projects with Data Architects, Developers, System Integration Testers and Project Management.
  • Well versed in project management tools like MS Project for project planning, Project scheduling.
  • Reviewed and challenged discrepancies with Project Management and Display Planning to prevent pricing errors.
  • Track and document project processes, manage resources, and develop/maintain project management data.
  • Worked with the Project Management in the creation of project estimates.
  • Maintained and updated key project management artifacts using Share Point.
  • Provided daily defect reports from QC to Project Management.
  • Project management for all new software development.
  • Project Management: Manage vendors by providing business rules and requirements that will ensure continuous data integrity.
  • Provided project management activities including project planning, project schedules, project risks, deliverables, tasks, and milestones.

Show More

3 Project Management Jobs

No jobs at selected location

25. Scrum

demand arrow
average Demand
Here's how Scrum is used in Senior Business Data Analyst jobs:
  • Acted as the Scrum Master for a pilot Agile project, and also as a Product Owner on another reporting project.
  • Worked in an Agile team using Scrum methodology and participated in backlog prioritization with product owner and Scrum master.
  • Served as liaison between the scrum team and the client, earning their confidence with reliable follow-through.
  • Led weekly scrums with area leads, monitoring efforts of over 30 IT and BA resources.
  • Involved in daily scrum meeting for daily status updates of the project and the issues.
  • Acted as Scrum Master for an Agile project implementing a new Credit Risk scoring application.
  • Elicited Business requirements and business needs as part of an Agile Scrum team.
  • Used Scrum Work Pro and Microsoft Office software to perform required job functions.
  • Identify any problems and informing the Scrum Master, scheduling team meetings.
  • Ensured consistent application of scrum methodologies across the team.
  • Participated in Daily Scrums to report the daily work status
  • Participated on the daily scrum meeting to report status.
  • Documented artifacts required for each cycle in Agile/Scrum.
  • Used AGILE SCRUM process for project implementation.
  • Collected user stores to support scrum development.
  • Facilitated communication and interfaced with various multi-disciplinary Scrum teams in New York, London, Toronto & Chennai.
  • Participated in daily scrum standup meetings to provide status for assigned work, raising any issues/ impediments.
  • Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
  • Designed both a physical and logical model for the EDW/Data-Marts Managed scrum meetings and client relationships.
  • Used Agile/Scrum methodology for Software Development Lifecycle (SDLC) using HP Agile Manager tool.

Show More

26. BI

demand arrow
average Demand
Here's how BI is used in Senior Business Data Analyst jobs:
  • Gathered business requirements and conducted feasibility analysis
  • Created and performed automated (SQL-based) report scrubbing to improve operational efficiency to define requirements and executing to delivery.
  • Demonstrate verbal and written communication skills and the ability to interact with cross-functional professionals across the Organization.
  • Develop reporting platforms for billing software for interfacing with accounting department.
  • Generated trade data concepts matrix published to application owners bi-weekly.
  • Assessed Credit Risk strategies with various internal credit tools and implemented Basel II strategies to augment Credit availability.
  • Managed the process for integrating the Dimensions (TO BE) to ensure Report Flexibility at the run-time.
  • Created Process documents and work flow for the different billing options for the web based billing application.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Improved metrics and data used annually to drive focus / accountability for store payroll and capital investments.
  • Gathered Health Care Reform billing requirements in the form of concise and effective User Stories.
  • Provided support towards resolution of issues and enhancement projects for the Global Billing System.
  • Uncovered $4.7MM in savings from physician prescribing patterns of Provider-based Drugs.
  • Provided Production Support to Independent Blue Cross, Philadelphia Billing issues.
  • Convert database billing into Excel for daily tracking of cash flow.
  • Design and maintain customer billing software.
  • Design, development, implementation and roll-out of Microstrategy BI applications.
  • Documented data quality and traceability documents for each source interface.
  • Project Profile: Citi is one of the largest & biggest Retail banking and investment banking company in the whole world.
  • Created and managed Project Charter, Change Control Requests (CCRs) and managed Traceability matrix.

Show More

9 BI Jobs

No jobs at selected location

27. RUP

demand arrow
average Demand
Here's how RUP is used in Senior Business Data Analyst jobs:
  • Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.
  • Conducted user interviews, gathered requirements and analyzed the requirements using Rational Rose & Requisite Pro - RUP.
  • Examined, analyzed and modeled Test plans Use Case Model cases & Test procedures based on RUP methodology.
  • Prioritized project efforts, developed project plans, process flows, Use Cases and SRS using RUP.
  • Involved in creating Business Processes and Modeling Diagrams using Rational Unified Process (RUP).
  • Managed Master Data track to a successful implementation of Oracle R12 with no business interruptions.
  • Used Rational Unified Process (RUP) for streamlining the team's development activities.
  • Drafted the Business Requirements and collection approach based on the project scope and RUP.
  • Developed business process models in RUP to document existing and future business processes.
  • Utilized RUP to configure and develop process, standards, and procedures.
  • Followed the RUP methodology for the entire SDLC.
  • Involved in RUP Business Modeling process.
  • Involved in Standardizing content across platforms and media Utilized RUP to configure and develop process, standards, and procedures.

Show More

28. Unix

demand arrow
average Demand
Here's how Unix is used in Senior Business Data Analyst jobs:
  • Involved in writing Unix Shell Scripts for automation to ensure that data captured and stored in database is correct and accurate.
  • Coordinate migration of BO reports using an internal process and load BIAR files to UNIX locations using WINSCP.
  • Developed UNIX shell scripts to perform nightly refresh of the Reporting database from Production databases.
  • Developed UNIX Shell scripts to create automated action events and send notifications in control-m.
  • Created daily and monthly reports using SQL and UNIX for Business Analysis.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Executed UNIX Shell scripts to enable and disable the environments.
  • Developed UNIX Shell scripts to automate repetitive database processes.
  • Assisted with production support in a UNIX environment.
  • Pinged Servers in unix environment while checking health of servers while performing root cause analysis for OOR DR test case execution.

Show More

29. Jira

demand arrow
average Demand
Here's how Jira is used in Senior Business Data Analyst jobs:
  • Changed the format of extracted JIRA issues and made it presentable to the clients so that they can prioritize the issue.
  • Managed and Organized schedules, deadlines, Task Review meetings, Project Status, Defect tracking using JIRA.
  • Utilized JIRA for tracking Agile development, (issue and task tracking, prioritization and sprint planning).
  • Gathered and maintained requirements, software documentation, and meeting notes in JIRA.
  • Created and troubleshoot defect tickets in JIRA before assigning them to developers.
  • Used JIRA and Quality center for managing all defects.
  • Used JIRA for proprietary issue tracking purpose.
  • Used JIRA to track defects and issues.
  • Used Jira Agile for management of team projects.

Show More

30. SAS

demand arrow
low Demand
Here's how SAS is used in Senior Business Data Analyst jobs:
  • Created Source to target Mapping Matrix for the ETL developers in loading the data to Dimensions and Fact Tables using SAS.
  • Developed T-SQL queries and SAS programs on the data that was collected, depending on the needs of the client.
  • Created complex and reusable SAS macros to create tables, listings and graphs for submissions to higher management.
  • Queried Microsoft SQL server to obtain raw data and used SAS macro to manipulate and format the data.
  • Performed UAT testing using SAS, SQL, to perform data consistency test on the data migrated.
  • Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
  • Developed user friendly SQL and SAS programs to generate campaign waterfall exclusion report.
  • Program using SAS and VBA to drive data analysis tools.
  • Have coded SAS modules as part of Data Analysis.
  • Debugged SAS code during development of Business Objects Reports.
  • Performed Data Analysis using SAS Base and SAS SQL.
  • Created SAS Views from Oracle database tables.
  • Extracted data from disparate sources by SAS/ACCESS.
  • Issue research was performed using MS Access, SAS Enterprise Guide, and SQL.
  • Compared expected and actual results using SAS in UAT environment to execute UAT backend testing.
  • Assisted users with SAS problems, tools, and techniques for improving process efficiencies.
  • Processed large datasets using SAS/SQL applications for weekly and monthly membership offer selection processes.
  • Performed risk analysis, reviewed data analytics and created reports using SAS.
  • Created and manipulated datasets using SAS, Access, and Excel.
  • Designed various weekly analytics deliverables that provided detailed insights into the performance of my team by leveraging SQL and SAS programming.

Show More

31. DB2

demand arrow
low Demand
Here's how DB2 is used in Senior Business Data Analyst jobs:
  • Used RAPIDSQL to run queries on the corporate data warehouse (db2) and test the quality of the data.
  • Prepared data mapping documents for all DB2 tables and table elements and defined source to target flow.
  • Extract, Transform and Load DB2 data onto SQL Server using ETL tool Data stage.
  • Perform SQL scripts/queries in DB2/SQL-Server to convert data, maintain integrity, consistency.
  • Extracted data from multiple sources like DB2, SQL server and Oracle.
  • Analyzed data issues surrounding both DB2 and UDB database build functions.
  • Write clear and accurate technical and business specifications Work with DB2 and mainframe to implement contract s and problem solving.
  • Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
  • Supported testing team by analyzing and validating SQL scripts in DB2 and Sybase databases.
  • Pulled the data from various sources Teradata, MS SQL Server, DB2.
  • Retail Casualwear Data Warehouse - A DB2/ Cobol II system to track and provide analytics to the sales and marketing teams.

Show More

32. Powerpoint

demand arrow
low Demand
Here's how Powerpoint is used in Senior Business Data Analyst jobs:
  • Build demo presentation PowerPoints to facilitate understanding of data, requirements and resulting development.
  • Developed PowerPoint presentations for senior management.
  • Organized weekly Project Status and Task Review meetings, created PowerPoint presentations and project updates using MS Project for management review.
  • Generate reports and presentation for AON central and regional management using Excel, VBA, PowerPoint.
  • Created user manuals, PowerPoint presentations, operations manuals and conducted end-user training as needed.
  • Created a Rebate Flow Diagram in MS PowerPoint.
  • Facilitated meetings to understand business processes and translated to business requirements and present them as a MS Powerpoint presentation.

Show More

2 Powerpoint Jobs

No jobs at selected location

33. Web Application

demand arrow
low Demand
Here's how Web Application is used in Senior Business Data Analyst jobs:
  • Worked on formulating requirements for the Marketing Web application to cater to the need of the marketing and sales team.
  • Accomplished system integration, regression, performance and end-to-end testing of client/server and web applications.
  • Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
  • Web portal and web applications.
  • Developed functional design documents relating to the new workflows to be built into the ICAT collections and recovery web application.
  • Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
  • Documented and transitioned working model to permanent employees.Anheuser Busch Discovered and mapped source of field data on web application to reports.

Show More

34. Teradata

demand arrow
low Demand
Here's how Teradata is used in Senior Business Data Analyst jobs:
  • Worked on exporting data using Teradata.
  • Worked with data modelers and assist them in verifying and validating the relationships between tables using Teradata SQL assistant.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
  • Validated reports in Teradata and MS PDW by writing complex SQL queries and reporting discrepancies, if any.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Experience writing and executing complex SQL queries within Teradata SQL Assistant for data mining and data orchestration.
  • Sound understanding of Teradata concepts, constraints and rules that affect performance from a BO perspective.
  • Worked with Data Architects to discuss around DDL for table creation and view creations within Teradata.
  • Performed Data Analysis and Data validation by writing SQL queries using SQL assistant on Teradata.
  • Performed data migration from Teradata to MS PDW.
  • Ensured appropriate BO integration requirements for access of information on Teradata using Teradata recommended views.
  • Developed SQL, BTEQ (Teradata) queries for Extracting data from production database and built data structures, reports.
  • Design and maintain SQL Views in the Teradata environment, leveraging the Teradata SQL Assistant tool as per requirements.
  • Managed the implementation of new hierarchy design into enterprise data warehouse(Teradata) Worked on exporting data using Teradata.
  • Create Teradata tables, Views, Macros and analyzed various Teradata tables for UPI's and Monitor the same.
  • Created reports using GUI layer of AbInitio,DENODO tool on top of Teradata ETLdata bases and performed UAT testing.

Show More

35. Source Systems

demand arrow
low Demand
Here's how Source Systems is used in Senior Business Data Analyst jobs:
  • Involved in source to target data mapping from different source systems to OTM as part of the data quality check process.
  • Attended the change data management control board meetings for accommodating the enhancements to the warehouse based on the source systems upgrade.
  • Worked with data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
  • Created Requirements Documents for source systems to target data warehouse mappings to the Basel Lending Data Mart.
  • Mapped Data Lineage for various source systems, right from data origination to results area.
  • Created Data Mapping between the Source Systems, Staging Tables, and the Target System.
  • Analyzed the different source systems data needed to be pulled in for the reporting requirement.
  • Define the list codes and code conversions between the source systems and the data mart.
  • Walked through the Logical Data Models of all source systems for data quality analysis.
  • Created the ETL data mapping documents between source systems and the target data warehouse.
  • Identified various facts and dimensions from source systems to used for data modeling.
  • Played a key role understanding various source systems for Target state Project.
  • Analyzed OLTP source systems research the tables required for reporting purposes.
  • Worked with the source systems to meet the requirements.
  • Worked with Various source systems to reconcile the data.
  • Phase II: Integrated remaining source systems.
  • Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi source systems.
  • Worked on establishing the mapping for various Wholesale, Retails, TSYS, Equity, WMS and Securitization Source systems.
  • Analyze data in various applications, mapping the data between various source systems and ensuring the accurate importing of data system.
  • Architected MDM solution for customer information across various source systems Implemented E2E data flows and stewardship program for a MDM initiative.

Show More

36. Traceability Matrix

demand arrow
low Demand
Here's how Traceability Matrix is used in Senior Business Data Analyst jobs:
  • Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
  • Managed Traceability matrix to trace Business Requirements, Functional Requirements and Use Cases.
  • Created functional traceability matrix and functional documents for the applications.
  • Prepared requirement traceability matrix for tracking the project updates.
  • Used traceability matrix to understand the relationships.
  • Traced Requirements using Requirement Traceability Matrix.
  • Logged all the requirements in Rational RequisitePro tool for tracking purposes and also prepared Requirement Traceability Matrix (RTM) document.
  • Worked closely with QA team and Developer to establish traceability matrix to ensure the completeness of the enrollment procedure.
  • Prepared data mapping documents, data dictionaries, log of data refresh times and traceability matrix.
  • Participated in writing Test Plan, Test Strategy, Test Cases, and Traceability Matrix.
  • Performed Requirement Traceability Matrix to map the requirements with Test Cases and performed Gap Analysis.
  • Established UAT success criteria, used traceability matrix to allocate requirements in test cases.
  • Worked on building Requirement Traceability Matrix (RTM) to track the requirement coverage.
  • Create traceability matrix and test scripts and test plans.
  • Documented Requirement Traceability Matrix in Excel sheet for traceability of requirements through test cases.
  • Created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE' system.
  • Prepared and maintained requirements traceability matrix (RTM) throughout the project lifecycle.

Show More

37. HP Quality

demand arrow
low Demand
Here's how HP Quality is used in Senior Business Data Analyst jobs:
  • Test Plans, test scripts, acceptance criteria, test cases, performance testing, HP quality center.
  • Recorded results, logged and tracked defects to completion using HP Quality Center (ALM) 12.
  • Tracked and worked on project defects in HP Quality Center and prioritized enhancement and change requests.
  • Participated in UAT and worked with HP Quality Center for bug and defect tracking.
  • Certified with our HP Quality Center software for all testing requirements.
  • Used HP Quality Center to store Test Cases and Test Scripts.
  • Logged defects and tracked them in HP Quality Center.

Show More

38. Cognos

demand arrow
low Demand
Here's how Cognos is used in Senior Business Data Analyst jobs:
  • Documented the evaluation of various reporting tools like Cognos/Business Objects, made recommendations about the product depending on the reporting requirements.
  • Compile, analyze, and publish financial and/or operational results using Cognos BI tools as well as ASP.net web reports.
  • Involved in Data analysis using OLAP tools and Cognos reporting tasks to generate quarterly, yearly reports.
  • Assisted in integrating Cognos data into the active archives to make it readily accessible.
  • Involved in Development, testing, deployment and Scheduling of Cognos reports.
  • Designed and tested self serve reports in Cognos for sales staff.
  • Extract and maintain data using Cognos Reporting tool.
  • Utilized Cognos (Reporting Tool)
  • Created User Acceptance Test Plan and coordinated UAT for the site redesign project Used Cognos BI for operational reporting.
  • Worked on creating and updating UDW Cognos customer and product YTD reports and generated reports using Cognos.
  • Completed Cognos 7 to Cognos 8 platform and report migration, successfully migrating 20 plus operational reports.
  • Create Ad-hoc reports, Dashboard and Scorecards for end users using Cognos Reporting tool.
  • Prepared data mapping documents to build the new data mart and Cognos/Tableau/Qlik Sense reporting.
  • Deployed Cognos 8 Created and developed data and tool training curriculum.
  • Worked on Cognos Workspace advanced creating complex dashboards.
  • Check the Data Mappings in Production environment and Cognos Datamart Packages which is in line with the ILog Business Processing rules.
  • Process Cognos reports using Report studio 10.2 Created data mapping and wireframes for Tableau front end.

Show More

39. Technical Specifications

demand arrow
low Demand
Here's how Technical Specifications is used in Senior Business Data Analyst jobs:
  • Understand and articulate business requirements from user interviews and then translate requirements into functional and technical specifications.
  • Converted Business Requirements into Functional Requirements Specification Document and Technical Specifications using Rational Requisite.
  • Created Detailed Functional and Technical Specifications based on the high level requirements.
  • Assisted Technical team with creating technical specifications based on functional requirements.
  • Generated the technical specifications for various client reports.
  • Reviewed Business Requirement documents and technical specifications.
  • Developed functional and technical specifications.
  • Created all technical specifications for the bank's FFIEC 101 reports for the change from Basel II to Basel III Advanced.
  • Conducted regular review of the Function and Technical Specifications to reflect the latest changes and enhancements to the product owner.
  • Created all technical specifications (data source to target mapping format) for the Bank's Pillar 3 Reports.
  • Created Technical specifications documents based on the functional design document for the ETL coding to build the Data Mart.
  • Involved in creating the design and technical specifications for the ETL process of the project.
  • Worked with different functional groups to arrive at the common business and technical specifications.

Show More

40. Ssrs

demand arrow
low Demand
Here's how Ssrs is used in Senior Business Data Analyst jobs:
  • Gathered reporting requirements / specifications for report design in SSRS and performed data reconciliation.
  • Develop reports in SSRS to pull data from Basel II database to do data analysis on various aspects of a project.
  • Developed and presented Business Intelligence reports and product demos to the team using SSRS (SQL Server Reporting Services).
  • Developed multiple reports using MS SQL Server Report Service (SSRS) and linking to production database tables.
  • Maintained Report Manager and Reporting Server for SSRS to manage routine report production for clients.
  • Identified, added report parameters and created reports based on the requirements using SSRS 2008.
  • Automated multiple reports using SSIS, SSRS and identified various loan reporting error buckets.
  • Create business requirements for Development Team in order to build reports in SSRS.
  • Configured and maintained the report manager and report server for SSRS.
  • Author SQL code through SSRS and integrated data through SSIS.
  • Created user defined functions in SSRS using VB script.
  • Used various kinds of Data sets with SSRS.
  • Manage one Developer on creating SSRS reports.
  • Create and deploy reports using SSRS.
  • Worked closely with SSRS developers.
  • Created SSRS report specifications for complete asset management analytics.
  • Created, maintained & scheduled various reports in Oracle Roast like Tabular Reports, Matrix Reports & Parameterized Reports using SSRS.
  • Produce ad-hoc reports using T-SQL / SSRS / Data Warehouse.
  • Created ad-hoc reports per client request using SSRS.

Show More

41. Reference Data

demand arrow
low Demand
Here's how Reference Data is used in Senior Business Data Analyst jobs:
  • Integrated vendor market and security reference data into the Global Reference Database and other trading/reference databases.
  • Used Erwin to create Logical and Physical data model, Relationships and Schema for centralized reference data Hub (RDH).
  • Worked on reference data, source to target data mappings, functional elements, report layouts and prototypes.
  • Manage and perform data quality and stewardship activities to ensure data held within reference database is accurate.
  • Worked with business partners to keep reference data in sync with new CDD and WLF feeds.
  • Worked gathering various reference data for this project including Accounts, Clients, Securities and Products.
  • Coordinated reference data issues with the Enterprise Reference Data group for remediation and update.
  • Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes.
  • Established shared set of mnemonics and modeled the reference data to support it.
  • Processed Reference Data from systems holding gold copy as per their published schedule.
  • Project 1 Profile: Security & Client/ Legal Entity account Reference data reconciliation.
  • Designed ODS data model and model for HRA reference data.
  • Defined reference data, data mapping and business rules through case analysis, functional decomposition and workflow analysis.
  • Liaisoned between clinical and development teams to establish enterprise reference data standards and conform external code sets to enterprise values.
  • Centralized several classes of Reference Data in RDH, including Book, Department, FX, Counterparty and Human Resources.
  • Played pivotal role in the construction of CDL Redesign data model; created UI mockups for reference data.

Show More

42. Ssis

demand arrow
low Demand
Here's how Ssis is used in Senior Business Data Analyst jobs:
  • Assisted Project Managers to define, document and seek approval for LOE from different groups in each phase of the project.
  • Assist the organization with respect to the data transparency, data control and data dissemination by creating data policies and procedures.
  • Worked closely with IT for enhancements, data loader and assisted in the development and documentation of daily operational procedures.
  • Assist the project manager and account managers, by working with several clients of BearingPoint to resolve billing issues.
  • Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
  • Assisted the SME's in UAT execution and supported QA team for defect tracking and resolution.
  • Assisted in writing efficient and effective Test Plans, Test Strategy and User Acceptance Testing.
  • Assisted in transitioning of Washington Mutual Bank-credit card products to JP Morgan Chase platform.
  • Assisted the SME's in UAT execution and led defect tracking and resolution.
  • Provided assistance to users on the user acceptance testing on various projects.
  • Assisted and trained the business analysts on the newly implemented RUP process.
  • Created UAT Cases and assisted in the creation of UAT scripts.
  • Assisted in presenting reports and analysis to help guide the management.
  • Assisted ETL team for analysis in fixing the ETL defects.
  • Assisted in Black Box and Regression Testing.
  • Assisted manager with identifying consultants to onboard.
  • Assisted DBA for creating Data Dictionary for Database Entities including Tables, Indices, Views, Triggers, Constraints etc.
  • Worked with Teradata SQL assistant to run SQL queries to cross reference results obtained from the BO Universe.
  • Assisted in pulling together all the disparate databases into one sharable database for the ATLAS project.
  • Assisted in modeling the AS-IS and TO-BE business workflow.

Show More

43. SQL

demand arrow
low Demand
Here's how SQL is used in Senior Business Data Analyst jobs:
  • Researched client and internal data integrity issues using SQL database queries, Business Objects reporting, and other forms of analysis.
  • Converted, cleaned and scrubbed data from Access to MS SQL and Oracle while increasing performance.
  • Used and developed SQL queries to acquire or modify data from SQL database and access database.
  • Conducted performance tuning of sources, targets, mappings and SQL queries in the transformations.
  • Designed relational and NoSQL databases and implemented it in AWS through Python s API.
  • Prepared documented SQL queries for the Production Website and validated the same.
  • Conducted data profiling using SQL and designed data models, normalization flows.
  • Experienced reading and interpreting SQL commands.
  • Performed database testing using SQL.
  • Performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data.
  • Used various debugging techniques to debug the mappings with Debugger (in PC Designer), SQL queries, filters etc.
  • Used analytical techniques (Graph Analysis, Path and Pattern Analysis, Text Analysis, SQL Analysis, etc.)
  • Created SQL queries to test the data transformation logics, duplicate checks, population count and the table structures.
  • Conducted SQL Testing using complex SQL queries like Joins, Update, Insert and other SQL scripts.
  • Performed SQL Testing, Data Manipulation, Data Integration, and Server Validation using SQL Server.
  • Created Ad hoc reports related to the invoice back log using SQL queries.
  • Created reports using complex SQL /Custom sql in WEBI.
  • Worked extensively on Web Forms, User Controls, and Custom Controls using C#.Net and ASP.Net with SQL Server.
  • Develop process around account lookup using Excel, Fuzzy logic excel addon, 11g, and SQL developer.
  • Create jobs and schedule running in SQL 2008R for monthly, daily, weekly etc.. as requested.

Show More

14 SQL Jobs

No jobs at selected location

44. Business Units

demand arrow
low Demand
Here's how Business Units is used in Senior Business Data Analyst jobs:
  • Coordinated with various Commercial and Business units in order to support reporting and analysis for new product implementations.
  • Worked with business units to ensure organizational and team effectiveness and to help manage change initiatives.
  • Liaised with key stakeholders across different business units and levels to understand business requirements for key $12 billion project.
  • Performed initial contract reviews, coordinated edits and negotiated issues with Legal, Technology and Business units.
  • Gathered, analyzed, scoped complex systems requests from various business units identifying ROI and TOC.
  • Act as a liaison between the business units, QA and the technology teams.
  • Resolved data anomaly issues for various business units doing User Acceptance Testing.
  • Document technical & functional requirements, use-cases, conceptual designs, and data analytics for multiple business units within the organization.
  • Created an implementation plan to remediate gaps across all business units.
  • Developed complex adhoc reports for senior management team and various business units to enhance operational efficiencies.

Show More

1 Business Units Jobs

No jobs at selected location

45. User Interface

demand arrow
low Demand
Here's how User Interface is used in Senior Business Data Analyst jobs:
  • Assisted in the development of multimedia components and design user interface for Linux based open mobile communication device software platform.
  • Created UI mock ups and PoC's for the Public facing user interface and the adverse event Reporting form.

Show More

46. EDI

demand arrow
low Demand
Here's how EDI is used in Senior Business Data Analyst jobs:
  • Developed gap analysis document, logical and physical design and remediation plan.
  • Provided consultation and in-depth analysis on Worker Compensation Medical Claims data.
  • Used data mining techniques to find the customer segment; performed predictive modeling to understand customer needs and customer behavior.
  • Recommended a revised packaging process that will increase efficiency in processing times and provide considerable costs savings for Con Edison.
  • Team Lead of 20+ * Delivered BI projects with a high level of predictability, quality and client satisfaction.
  • Design a database to store different parts of an electrical system that needs to be inspected by Con Edison.
  • Managed the Retiree Drug Subsidy Program for all clients, while working closely with Center for Medicare Services.
  • Involved in requirement gathering and testing of consumer web portal for the enrollment of Medicare members.
  • Worked on the various projects like Special Care group requirements, CMS Medicaid/ CHIP requirements.
  • Provided data for HEDIS reporting (for performance measuring of patient care).
  • Coordinated and prepared yearly Strategic Plan, which included medium and long-term goals.
  • Validated EDI Claim Process according to HIPAA compliance.
  • Developed several Test Scripts for testing EDI transactions.
  • Supported Medicare Part D Business.
  • Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare).
  • Maintained end to end traceability from source system (Mainframe) to intermediate environments to metadata tracking layer.
  • Developed Price Indices for 3 medical service areas that enable comparison of medical service costs to national benchmarks.
  • processed Medical claim for client s who participate in the High Deductible Health Plan program.
  • Track and remediate data errors to ensure quality controls are in place.
  • KEY ACCOMPLISHMENTS: Managed EDI conversion from Cleo/Qualedi to Delta ECS .

Show More

47. Html

demand arrow
low Demand
Here's how Html is used in Senior Business Data Analyst jobs:
  • Hand coded HTML, CSS and JavaScript classes for a variety of AJAX widgets.
  • Created Erwin reports in HTML, RTF format depending upon the requirement.
  • Developed design for Retrieve form for Data Capture via XML, XForm and XHTML.
  • Developed the workflow to produce the output for the user in Pega Systems using html.

Show More

48. FRD

demand arrow
low Demand
Here's how FRD is used in Senior Business Data Analyst jobs:
  • Designed detailed FRD according to BRD and Basel regulatory requirements using Power Designer.
  • Prepared Software Requirement Specifications (SRS) and was involved in the preparation of the Functional Requirements Document (FRD).
  • Developed FRD, Detail Design Document and UI document for the Website.
  • Documented business and functional requirements (BRD/FRD).
  • Created and standardized the templates for BRD, FRD, SRD and Minutes of the meeting.
  • Organize and facilitate project related meetings, prioritize tasks, write BFRD and traceability documents.
  • Performed business analysis and created detailed BRD/FRD and workflows for partner on-boarding system.
  • Create functional documents such as BRD, FRD, Traceability matrix etc.
  • Conducted FRD review sessions with the dev team.
  • Gathered and documented high level business requirements to prepare BRDs and FRDs.
  • Assisted in preparing BRDs, FRDs, and Test Cases.

Show More

49. CRM

demand arrow
low Demand
Here's how CRM is used in Senior Business Data Analyst jobs:
  • Managed and supported with Master Data in SAP/R3 functions in CRM, Customer Master, SD and MM Modules.
  • Used CRM on demand for accessing information on the business policies and procedures.
  • Worked on testing the Commercial AGS, PLDM, CDM MCCO, SMLT, IMED and Case Management and TLCRM-ODS reports.
  • Project: MS Dynamics CRM - FCFP
  • Worked with CDC TouchPoint CRM team to implement enhancements and manage ad hoc data loads to and from the system.
  • Supported all phases of testing for the Account Management System (eCRM) including upgrades and releases.
  • Maintained Xceed s CRM application; was the subject matter expert.
  • Worked on CRM Software, and in-house workflow management tools.
  • Helped with transition from CDC Touchpoint CRM system to Salesforce.

Show More

3 CRM Jobs

No jobs at selected location

50. Rational Requisite Pro

demand arrow
low Demand
Here's how Rational Requisite Pro is used in Senior Business Data Analyst jobs:
  • Worked extensively in Rational Requisite Pro to organize and catalog requirements, documents, and use-case documents.
  • Conducted extensive requirement analysis using rational requisite pro.
  • Used Rational Requisite Pro to document stakeholders' requests, software requirements specifications and traced it to use cases.
  • Involved in requirement gathering using Rational Requisite Pro, which included interviews, brainstorms and meetings with stakeholders.
  • Identified, organized, and documented the changing requirements for the application using Rational Requisite Pro.
  • Used Rational Requisite Pro and Clear Quest to trace Functional, Business and Data Requirements.
  • Prepared Requirement Traceability Matrix using Rational Requisite Pro.

Show More

Senior Business Data Analyst Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior Business Data Analyst

Business Requirements

23.6%

Data Warehouse

13.5%

Test Cases

8.2%

Data Dictionary

5.3%

User Acceptance

5.1%

Visio

4.9%

Sequence Diagrams

4.5%

Data Analysis

4.1%

ETL

3.9%

UAT

3.8%

JAD

3.0%

SME

2.8%

UML

2.6%

Sharepoint

2.5%

QA

2.4%

Windows XP

2.3%

Sdlc

2.0%

Subject Matter

1.8%

Informatica

1.8%

XML

1.8%
Show More

Typical Skill-Sets Required For A Senior Business Data Analyst

Rank Skill
1 Business Requirements 17.9%
2 Data Warehouse 10.2%
3 Test Cases 6.2%
4 Data Dictionary 4.0%
5 User Acceptance 3.8%
6 Visio 3.7%
7 Sequence Diagrams 3.4%
8 Data Analysis 3.1%
9 ETL 3.0%
10 UAT 2.9%
11 JAD 2.3%
12 SME 2.1%
13 UML 2.0%
14 Sharepoint 1.9%
15 QA 1.8%
16 Windows XP 1.7%
17 Sdlc 1.5%
18 Subject Matter 1.4%
19 Informatica 1.3%
20 XML 1.3%
21 Toad 1.2%
22 Suite 1.2%
23 Pl/Sql 1.1%
24 Project Management 1.1%
25 Scrum 1.1%
26 BI 1.0%
27 RUP 1.0%
28 Unix 1.0%
29 Jira 0.9%
30 SAS 0.9%
31 DB2 0.9%
32 Powerpoint 0.9%
33 Web Application 0.9%
34 Teradata 0.8%
35 Source Systems 0.8%
36 Traceability Matrix 0.8%
37 HP Quality 0.8%
38 Cognos 0.8%
39 Technical Specifications 0.7%
40 Ssrs 0.7%
41 Reference Data 0.7%
42 Ssis 0.7%
43 SQL 0.6%
44 Business Units 0.6%
45 User Interface 0.6%
46 EDI 0.5%
47 Html 0.5%
48 FRD 0.5%
49 CRM 0.5%
50 Rational Requisite Pro 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

31,200 Senior Business Data Analyst Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.