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.

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 Business & Data Analyst Skills

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

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

1. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in Business & Data Analyst jobs:
  • Handled various activities of the project like information gathering, analyzing information gathered, documenting the functional or business requirements.
  • Involved in creating Business Requirements Document (BRD) and refining the business requirements into functional and non-functional requirements.
  • Validated the relationship of application and infrastructure functionality to the core business requirements and processes.
  • Performed functional, regression testing and detailed integration testing in accordance with the business requirements.
  • Interacted with users to gather business requirements and identified technical specifications for development.
  • Translated business requirements into database design modifications to meet client and staff needs.
  • Accumulated business requirements from various business users and translated into business requirements.
  • Conducted Business Requirements, Functional and Technical meetings with Business groups.
  • Participate in the development and design of business requirements.
  • Analyzed the user/business requirements and functional specs documents.
  • Translated business requirements to data designs.
  • Translated Business requirements to functional and technical language with the help of Use cases and UML diagrams for developers.
  • Reviewed High Level, Business Requirements, Technical Requirements, and Detailed Design documents to write and generate reports.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Created and executed detail function Test Scripts and Test cases based on the business requirements.
  • Analyzed and interpreted the business requirements for QA and design teams using IBM DOORS.
  • Created various artifacts as Business Requirements documents for the clients.
  • Analyze the stored procedures to validate the business requirements.
  • Prepared comprehensive Functional Requirements Documents (FRDs) for the project based on business requirements, priorities and scope.
  • Played an active role in gathering, analyzing and writing business requirements documentation (BRD).

Show More

14 Business Requirements Jobs

No jobs at selected location

2. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Business & Data Analyst jobs:
  • Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
  • Identified and documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Identified erroneous and inconsistent data recorded in data warehouse operational systems.
  • Prepared data layouts for migration activities from Store Tables in Oracle to multiple tables in data warehouse using Oracle EBS.
  • Worked on source-to-target data mapping for data warehouse, data profiling and data quality analysis using complex SQL scripts.
  • Worked with QA Team and SME to create data mappings for the back office systems in ETL/data warehouse.
  • Delivered support for processing of data from sources to target data warehouse by documenting detailed ETL mapping processes.
  • Created SQL queries for testing each condition of the requirement against ODS, Data warehouse and Data marts.
  • Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
  • Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
  • Build a data model which integrates Loan IQ Application to centralized Data Warehouse with PeopleSoft integration.
  • Involved in the requirement gathering and analysis for implementing the data warehouse.
  • Involved in analyzing and designing the load routines to Data Warehouse.
  • Defined requirements/ BRD for the banks next generation Enterprise data warehouse adding securitization and derivative products.
  • Involved in requirements gathering, creating FSD,design, enhancement and development of Enterprise Data Warehouse.
  • Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
  • Used Informatica to extract and transform data from various DB2 database to the data warehouse.
  • Load data into data warehouse as per change in regualations to the tax sheltered annuities.
  • Improved numerous reports and processes for the bank s proprietary financial data warehouse.
  • Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and populate Data warehouse.

Show More

6 Data Warehouse Jobs

No jobs at selected location

3. Test Cases

demand arrow
high Demand
Here's how Test Cases is used in Business & Data Analyst jobs:
  • Articulated business and functional requirements into detailed testing scenarios and further translated them into test cases.
  • Involved in creation of test plan, test scenarios, test cases for unit, system and system integration testing.
  • Develop queries using SQL Oracle Development with different test cases to observe how the system handles the unexpected scenarios.
  • Developed and execute test cases for Regulatory Capital and LST reports within the system to identify issues.
  • Developed user test cases and validated test results during user acceptance testing (UAT).
  • Execute different test cases to determine the trigger which causes the data inconsistencies and anomalies.
  • Developed test cases and wrote test plans to help developers locate and fix the defects.
  • Involved in writing Manual Test Cases and Test Scripts for checking the application.
  • Based on the business requirements and rules will prepare test scenarios/test cases.
  • Assisted QA team with Test Plans and in executing Test Cases.
  • Provided input and reviewed the testing scenarios and test cases.
  • Develop test plans and test cases to validate the changes.
  • Developed test plans, test cases and test strategy.
  • Created test scenarios, plans and test cases.
  • Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
  • Worked on HIPAA X 12 transactions 4010 and 5010 EDI Transactions and test cases.
  • Assisted QA team in writing Test Plan, Test Cases.
  • Created Bidirectional Traceability Matrices to link requirements, functional requirements, technical solutions and test cases.
  • Interfaced with business users to prepare and update Business Process Requirements (BPR) Created test cases and test scripts.
  • Reviewed and writtentest cases and test plans along with the QA team.

Show More

4. Sequence Diagrams

demand arrow
high Demand
Here's how Sequence Diagrams is used in Business & Data Analyst jobs:
  • Created use case scenarios and documents work flow and business process with use case diagrams, activity diagrams and sequence diagrams.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
  • Used Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams.
  • Prepared Use Cases, Activity Diagrams, Sequence Diagrams, and Class Diagrams according to the UML methodology.
  • Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams as supplementary specification to support the requirements.
  • Created Mapping Documents from Source to Target, Use Cases, Activity Diagrams, and Sequence Diagrams.
  • Involved in creation of use case diagrams, class diagrams, sequence diagrams and deployment diagrams.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
  • Used UML to create Use Cases, Process Flows, Sequence Diagrams, and Activity Diagrams.
  • Developed sequence diagrams, activity diagrams, class diagrams and swim-lane diagrams for IVR trading.
  • Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams.
  • Developed detail class diagrams and sequence diagrams using Rational Rose.
  • Used UML to create use cases, used case diagrams, classes & sequence diagrams.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD Generated wireframes and prototype for the GUI.
  • Created activity diagrams, use case diagrams and sequence diagrams using MS Visio to view the system from different perspectives.
  • Utilized UML for process modeling and created Use Cases, Activity Diagrams and Sequence diagrams using MS Visio.
  • Created Use Cases, Activity Diagrams, State Chart Diagrams, Sequence Diagrams using MS Visio.
  • Performed extensive Business Process Modeling using Swim-Lane diagrams, Sequence diagrams, Workflow diagrams and Activity diagrams using MS Visio.
  • Followed theUML basedmethods using MicrosoftVisio to createUse Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams.

Show More

5. Visio

demand arrow
high Demand
Here's how Visio is used in Business & Data Analyst jobs:
  • Participated in critical review and revision of existing systems for updates and enhancements.
  • Gather requirements, Elicitation & write functional design specification with minimal supervision.
  • VISA and MasterCard, the software systems like Vision PLUS which are catering to credit card services undergo modifications or addition.
  • Worked closely with the Engineering Department to ensure that the product vision is accomplished through delivering prioritized user stories.
  • Created a vision document to explain user demographics, profiles, environments and requirements.
  • Subject matter expert for division projects.
  • Collaborated with developers and subject matter experts to establish the technical vision and analyzed tradeoffs between usability and performance needs.
  • Developed and maintained all operational and technical flows using Microsoft Visio and Excel.
  • Analyze the system's star schema design through Microsoft Visio to identify the relationship among the fact and dimension tables.
  • Created the product backlog and roadmap based upon the company vision provided by the strategic goals and client needs.
  • Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using UML in MS Visio.
  • Developed additional processing and data models that will be added to existing system using MS Visio.
  • Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
  • Created Business process models, UML diagrams(Use case, activity) using Visio.
  • Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using MS Visio.
  • Designed the system, prepared UML and sequence diagrams using Rational Rose and Visio.
  • Maintained and updated system data flow chart, Visio documents and System documentations.
  • Used MS Visio for Process modeling and Business Process flow diagrams.
  • Created Use case diagrams using MS Visio.
  • Created process flow diagrams in Ms Visio.

Show More

1 Visio Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. User Acceptance

demand arrow
high Demand
Here's how User Acceptance is used in Business & Data Analyst jobs:
  • Facilitated and validated application interface designs and user acceptance tests to obtain good quality control, and fulfill customer requirements.
  • Facilitated user acceptance testing and test strategies with developers and testers.
  • Help with User Acceptance Testing related to existing database applications, as well as new data elements and new applications.
  • Validated all the issues returned from QA team and performed User Acceptance Testing (UAT) on behalf of end-user.
  • Worked extensively with the QA team for designing Test Plan and develop the Test Scripts for the User Acceptance Testing.
  • Facilitated robust Unit, System Integration and User Acceptance Testing and supported the Training phase of the project
  • Designed test plans and defined cases for functional, integration system, and user acceptance testing.
  • Performed Integrated Systems Testing and/or User Acceptance Testing including creation of test documents and evidence.
  • Executed User Acceptance Testing (UAT) for all new reports generated in MicroStrategy.
  • Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
  • Supported the User Acceptance Testing during the implementation phase of the project.
  • Participated in testing software by conducting User Acceptance Testing (UAT).
  • Performed Unit Testing and User Acceptance Testing and documented detailed defects.
  • Conducted workshops for user acceptance testing, training and support.
  • Tested the BI reports and developed user acceptance criteria.
  • Provided technical and procedural support for User Acceptance Testing.
  • Conducted User Acceptance Testing (UAT).
  • Performed user acceptance testing as well.
  • Conducted User Acceptance Testing Reviewed quality with respect to requirements based on reliability, functionality, & performance.
  • Managed sign-off for deliverables (functional and non-functional specifications, change requests, user acceptance testing, and production deployment).

Show More

1 User Acceptance Jobs

No jobs at selected location

7. Data Analysis

demand arrow
high Demand
Here's how Data Analysis is used in Business & Data Analyst jobs:
  • Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
  • Performed data analysis for Human Resources.
  • Applied technical skills in the area of systems and data analysis to provide a high level of detail in requirements documentation.
  • Performed data analysis and report generation by extracting data from various complex data sources using millions of rows of data.
  • Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
  • Performed data analysis in SAS on small business owners' data to identify potential customers to assist marketing team.
  • Bank of New York Mellon needed a dashboard and data analysis tool for managing their fixed income portfolio.
  • Performed data analysis and documented the data findings to present to the business users and senior management.
  • Created data mapping documents and assisted in data analysis, data validation and KRI mapping logic.
  • Performed data analysis for the existing data warehouse and changed the internal schema for performance.
  • Participated in the data analysis and validation of the migrations for the billing department.
  • Performed data analysis & validation by writing complex queries using SQL Server Management Studio.
  • Perform source system data analysis in order to manage source to target data mapping.
  • Conduct data pulls from various sources and perform customized data analysis.
  • Conducted data analysis migrated MS Access databases to SQL Server database.
  • Used Data Analysis techniques such as Data mining and mapping.
  • Performed data profiling on identified data elements and presented the findings of data analysis to business for further requirements refinement.
  • Performed data analysis, ad hoc reports, queries, metrics, charts and graphs in Excel, created PowerPoint content.
  • Provided assistance for quantitative data analysis with health care, biometric and survey data.
  • Created multiple Schemas and views for efficient data analysis.

Show More

15 Data Analysis Jobs

No jobs at selected location

8. UAT

demand arrow
high Demand
Here's how UAT is used in Business & Data Analyst jobs:
  • Conducted statistical analysis to evaluate sources of action and justify business recommendations.
  • Tracked testing issues, maintained test matrix, ran daily status meetings, and met the exit criteria for UAT.
  • Established criteria for Decommissioning out of date websites, as well as performed UAT testing and validation of websites.
  • Test and analyze data in Production and UAT environments to assure data quality, integrity and avoid data redundancy.
  • Evaluated project risks, developed contingency plans and responding to change in risk as the project progresses.
  • Document, consolidate and track the issues identified during UAT and post-production normalization, till closure.
  • Conducted Impact Analysis on systems/Applications, in evaluating the impact of changes on the organization.
  • Assisted the users in performing UAT and prepared test cases for QA team.
  • Performed data review, evaluate, design, implement and maintain company database.
  • Validated UAT test cases and submitted change requests to team of developers.
  • Coordinated with customers to help them through UAT, and pilot testing.
  • Prepare proposals for Business needs requiring the evaluation of different options.
  • Worked with customers to put together UAT scenarios and plans.
  • Evaluate and monitor the performance and efficiency of programs.
  • Manage test team and hosted semiweekly status UAT meetings.
  • Conduct database security evaluations, audits, and reviews.
  • Performed and documented UAT and Prod Val.
  • Coordinated with technical teams for research and evaluation of healthcare and operational problems.
  • Developed Customer Master Data Management, Developed Customer Master User Interface, Assisted team in User Acceptance Testing (UAT).
  • Conducted functional walkthroughs, user acceptance testing (UAT) sessions

Show More

1 UAT Jobs

No jobs at selected location

9. ETL

demand arrow
high Demand
Here's how ETL is used in Business & Data Analyst jobs:
  • Participated in design review sessions with Data Modelers & ETL Developers and recommended specific applied solutions for design problems.
  • Updated ETL policies/processes/procedures to standardize for all loads.
  • Resolved data integration issues by performing root cause analysis of application architecture, ETL, and Java code encapsulated business rules.
  • Mass loaded, and performed ETL on thousands of material masters for SAP Implementation Go-lives at plants being upgraded.
  • Created new ETL process to extract, transform and load data from different sources to data ware house.
  • Prepared the ETL design for the dimension models and defined aggregations, partitions for the data model.
  • Participate in the development and implementation business rules to be used in the ETL.
  • Worked with ETL Team to design the mapping documents for source to data.
  • Demonstrated understanding and experience with ETL, Stored Procedures, and Queries.
  • Gathered Requirements from users, Translated user inputs into ETL design documents.
  • Used technical skills to develop and update solutions to the ETL process.
  • Created necessary repositories to handle the metadata in the ETL process.
  • Develop algorithms in SSIS (ETL) to satisfy reporting requirements.
  • Created the ETL test specifications and test cases.
  • Formalized source-to-target mappings, Extract Transform and Load (ETL) rules, data quality guidelines and metadata.
  • Configured data with Clover ETL to meet the needs of various teams for any pre-processing requests.
  • Design of the Data ware house/ ETL applications, ETL unit testing.
  • Used analytical skills to diagnose problems with ETL process.
  • Designed and developed supply chain reporting utilizing Pentaho Data Integration (PDI) for ETL, Netezza, and MicroStrategy.
  • Used ETL, Informatica designer to design mappings and coding it using reusable mapplets.

Show More

10. JAD

demand arrow
high Demand
Here's how JAD is used in Business & Data Analyst jobs:
  • Conducted meetings/interviews and JAD sessions with stakeholders to collect business requirements, Conducted controlled Brainstorming sessions with project related groups.
  • Facilitated JAD Sessions to develop architectural solution and prioritize the requirements.
  • Conducted JAD sessions to identify Requirements.
  • Facilitated JAD session, documented all the discussions, stored the requirements and tracked the changes maintaining the versions of document.
  • Facilitated Joint Application Design (JAD) Sessions with business users and development team to drive out detailed business requirements.
  • Elicited requirements through interviews, document analysis, workshops (JAD Sessions), surveys, and site visits.
  • Facilitated JAD sessions and conducted gap analysis to identify any change request and risk involved in the business process.
  • Prepared the reports that are possible with the existing data and demonstrated to the managers in the JAD sessions.
  • Facilitated JAD sessions with Enterprise Data Warehousing teams to understand and document the Scope of the initiative.
  • Involved in Conflict Resolution during and after JAD sessions between the Technical team and the Business team.
  • Interacted with end users for requirements study and analysis by JAD (Joint Application Development).
  • Gathered requirements and led joint application development (JAD) sessions with managers and staff.
  • Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
  • Organized and scheduled user interviews, user meetings, group meetings, and JAD sessions.
  • Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Participated in Joint Application Development (JAD) sessions with IT groups.
  • Conducted JAD sessions with stakeholders in coming up with user requirements.
  • Involved in JAD sessions with business users.
  • Facilitated JAD sessions and communicated with stakeholders and developers for requirement gathering and deliverables producing.
  • Conducted JAD sessions to define the project and reduce the time frame required to complete a deliverable.

Show More

1 JAD Jobs

No jobs at selected location

11. UML

demand arrow
high Demand
Here's how UML is used in Business & Data Analyst jobs:
  • Worked with the design team in implementing UML methodologies to design Use Case Diagrams, Data Flow Diagrams and ER Diagrams.
  • Used UML, for gathering requirements, created Use Case Diagrams, and Use Case Specification document (USD).
  • Used UML to produce Use-Cases, Use case diagrams and Activity diagrams to explain process flows and functional specifications.
  • Assisted in evaluating alternatives to determine appropriate solutions by creating Use Cases and UML diagrams for overall system solution.
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Identified and documented business needs and created detailed Use Cases and Use Case Diagrams using UML.
  • Used UML to do object oriented design such as activity diagram and sequence diagram.
  • Created Use Case Diagrams using UML to define the Functional requirements of the application.
  • Used RUP methodology and created UML diagrams to capture analyzed and translated business requirements.
  • Developed and maintained business requirement document (BRD), UML diagrams.
  • Utilized UML methods to create use cases diagrams and activity diagrams.
  • Developed Use cases and functional specifications and provided UML diagrams.
  • Used UML notations for Object Oriented Design and Documentation.
  • Worked on Oracle 9i, UNIX, JAVA, UML.
  • Involved in designing and translating business abstractions to object-oriented class representations using UML diagrams and created Alert Workflow Diagrams.
  • Created various UML diagrams like Use Cases, Flow charts using Ms. Visio for new tutor track proposal.
  • Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
  • Used unified modeling language (UML) use cases to create artifacts for the reporting related deliverables.
  • Designed and developed Use Cases and UML models using Microsoft Visio for the functional requirement document.
  • Designed and developed Use Cases using UML and Business Process Modelling.

Show More

12. Windows XP

demand arrow
high Demand
Here's how Windows XP is used in Business & Data Analyst jobs:
  • Cross work across multiple platforms, like UNIX, Windows XP, and Windows 2000.

Show More

13. QA

demand arrow
high Demand
Here's how QA is used in Business & Data Analyst jobs:
  • Looped in key stakeholders, wrote business requirements, co-ordinate QA/regression testing across all impacted applications.
  • Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
  • Worked as business liaison with developers, business users and QA team to ensure that all the business goals are met.
  • Worked in conjunction with Quality Analysis (QA) team on designing Test Plan, Test Cases and Test Scenarios.
  • Assisted QA team by Reviewing test cases and clarifying requirements to ensure complete coverage of requirements for the mobile platform.
  • Communicated functional requirements with developers and QA in the alpha testing process at the end of each sprint.
  • Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment
  • Worked closely with software developer and QA team to resolve issues and execute the project on time.
  • Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.
  • Tracked defects in HP Quality Center and worked with QA team to resolve defects and defect management.
  • Created process flows, gathered product requirements, and completed QAT successfully with project implementation team.
  • Participated meetings with review teams to continually improve the QA process for application developments.
  • Provided daily status report to conversion QA Team Lead of testing activities progress.
  • Managed and hosted training and education sharing sessions with QA team.
  • Worked on testing phase with QA team using Quality Center.
  • Lead and only QA for the online 245D Dashboard project.
  • Managed all aspects of the QA function.
  • Involved in full QA life cycle.
  • Work with QA to uncover production issues by reviewing code to narrow down problems, bugs, or test Hotfixes.
  • Assisted QA team in creating test scenarios that covers day in a life of patient for Inpatient and Ambulatory workflows.

Show More

14. SME

demand arrow
high Demand
Here's how SME is used in Business & Data Analyst jobs:
  • Gathered requirements from SME for bank-traded fixed income products including mortgage-backed securities, asset-backed securities, equity options and interest-rate swaps.
  • Conducted assessment to ensure data quality and completeness with validation techniques.
  • Analyzed individual health records making recommendations regarding necessary assessments and procedures.
  • Engaged staff from all levels of leadership to perform assessment of customer wants and needs through interviews and careful process analyses.
  • Coordinated with compliance team and SME to include AML compliance, Basel II, and BSA into the project.
  • Created global document templates used across the instrument reference data program for BRD, FRD, gap assessment document.
  • Act as an SME for the Firm's data governance, data lineage, and Enterprise Data Dictionary tools.
  • Conducted impact and gap analysis based on baseline assessment of systems, technical infrastructure, and business process flows.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Developed business Use Cases using UML for new product functionality after conducting requirements elaboration sessions with SME's.
  • Involved in GAP Analysis and Technical Feasibility study with the technical leads and other SME's.
  • Gathered business requirements from SME's and created Logical Data Models which meet the business requirements.
  • Worked with Application SME's researching, documenting and resolving Data issues.
  • Created Business Assessments for long term care & health care sales systems.
  • Gather requirements data for SME sessions.
  • Participated and interacted with business/technical users and subject matter experts (SMEs) to gather new requirements and enhancements required.
  • Serve as a critical resource and liaison between subject matter experts (SME) and technologists throughout the project lifecycle.
  • Conduct GAP Analysis and risk assessment during the project, maintained traceability.
  • Collaborated with the business customers, users and SMEs Created write-ups, Requirements Document and Updated BRS (ETL Specification).
  • Interfaced with SMEs to prepare BPR documents for ongoing projects Validated technical designs created by IT developers against functional specifications.

Show More

15. Sharepoint

demand arrow
average Demand
Here's how Sharepoint is used in Business & Data Analyst jobs:
  • Managed all documentation in Rational RequisitePro and then uploaded them on SharePoint.
  • Served as administrator for SharePoint, including granting/restricting access.
  • Created documentation for reporting, handling QDM mailbox general requests, software licensing, SharePoint site editing, etc.
  • Use of data management software, including heavy use of SharePoint, Access, and other Microsoft Products.
  • Integrated MS Access with SharePoint, linked MS Access tables to SharePoint lists for more efficient data collection.
  • Trained end users how to enter their production data on SharePoint lists and created a user guide.
  • Use of SharePoint to store, organize, share, and access information from almost any device.
  • Organize, publish, and disseminate Reports and Data using SharePoint and Email and other tools.
  • Single point of contact for all changes needed to department's SharePoint design and permissions.
  • Share project process knowledge with the team on the project team's SharePoint site.
  • Developed and managed SharePoint Site, providing end-user training for plant personnel as needed.
  • Managed SharePoint site used for technology content available to ~35k associates.
  • Track caseworker progress, using SharePoint as an aid.
  • Collaborate, share, version project documents using SharePoint.
  • Utilized Microsoft SharePoint 2010 for publication of the reports.
  • Viewed SharePoint Alerts and Lists business documents.
  • Strengthened employee s social interaction and collaboration adopting Smart Analytics for SharePoint.
  • Maintained Governance Content on Sharepoint Site for team, including data repositories and inventory reports.
  • Worked, organized and arranged the company's Sharepoint and DocShare.
  • Use SharePoint, Saleslogix to maintain customer inventory.

Show More

16. Sdlc

demand arrow
average Demand
Here's how Sdlc is used in Business & Data Analyst jobs:
  • Manage the development and enhancement of reporting solutions using SDLC and Agile development methodologies.
  • Designed and developed project document templates based on SDLC methodology.
  • Utilized corporation developed Agile SDLC methodology.
  • Used the guidelines and artifacts of Waterfall model throughout the phases of the System Development Life Cycle (SDLC).
  • Established a business Analysis methodology around the SDLC, helped to develop use cases, project plans and manage scope.
  • Created SDLC documents to assist with the Billing and Revenue Assurance data migration and implementation of website.
  • Created production / analysis report and ensured all artifacts complied with corporate SDLC Policies / guidelines.
  • Managed Projects via SDLC, Gathered requirements, evaluated client requests and recommended solutions when appropriate.
  • Created and maintained the User Stories for the requirements based on the Agile Scrum SDLC.
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Verified to ensure that all artifacts are in compliance with corporate SDLC Policies and guidelines.
  • Assisted Project Manager in creating project charter, project plan using agile methodology for SDLC.
  • Prepared user stories and detailed sprint backlog in accordance to the Agile SDLC Methodology.
  • Designed the business requirement collection approach based on the project scope and SDLC Methodology.
  • Manage Scope and change throughout the SDLC process of the product.
  • Collaborated with the Development and Testing Teams throughout the SDLC.
  • Followed waterfall methodology throughout the SDLC.
  • Track the project status and all the SDLC phases of the project.
  • Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
  • Followed SDLC Life cycle , Change management Work flow for all assigned tasks.

Show More

2 Sdlc Jobs

No jobs at selected location

17. Powerpoint

demand arrow
average Demand
Here's how Powerpoint is used in Business & Data Analyst jobs:
  • Used Microsoft Excel and PowerPoint extensively to complete all other projects required by management.
  • Developed MS PowerPoint presentations for all Contingency Support activities.
  • Handle administrative tasks including preparation of PowerPoint presentations.
  • Assisted in corporate PowerPoint presentations.
  • Monitored and creates monthly operational metrics reports and PowerPoint presentations of new enrollments through liaising with Project Managers for VP.
  • Used Access, Excel, PowerPoint and Word; loaded the budgets in PeopleSoft and sent out budget reports.
  • Extract data from databases utilizing MySQL, T-SQL, Access, and design reports in Excel and PowerPoint.
  • Executed data processing, data analysis, prepare Reports using Excel, Access and PowerPoint.
  • Created monthly newsletters, quarterly reports and training materials using Word, PowerPoint and Publisher.
  • Provided PowerPoint presentations as a visual aid for business users.
  • Created PowerPoint presentations, graphs and charts for management reporting.
  • Created flowcharts in VISIO and progress in presentation in PowerPoint.
  • Create educational pieces in MS Publisher, Excel and PowerPoint.
  • Reduced processing time and improve processing accuracy by transferring existing accounting procedures to flow charts using Microsoft Visio and Microsoft PowerPoint.
  • Excel, PowerPoint, and Access) to manipulate, maintain, and explain data for Management team.
  • Utilized Microsoft applications in Word, Excel, Outlook, PowerPoint, Visio and Project.
  • Used PowerPoint presentations for conducting walkthroughs with the stakeholders.
  • Generate prototypes for online screens using Visio and PowerPoint.
  • Created Use Cases and Data Flow Diagrams in MS Visio Created PowerPoint Presentation for high lever overview of Projects.
  • Created promotional materials specifically tailored for our customers and events using PowerPoint, Word and Nitro Pdf.

Show More

18. Suite

demand arrow
average Demand
Here's how Suite is used in Business & Data Analyst jobs:
  • Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
  • Experienced in data analysis to include requirements gathering, documentation, and C-suite presentation.
  • Designed a reporting suite to maximize client experience while maintaining Microsoft compatibility.
  • Created standard procedural documents on the various processes and tasks ran by the department for the cash management application suite.
  • Developed the first Daily Flash Report for Huntsville Memorial Hospital reviewed by Board Members, C-Suite, and Director Staff.
  • Designed and developed of logic, metrics and reports using primarily the Business Objects suite of applications.
  • Worked on porting of Oracle 11i E-Business Suite applications to different platforms, e.g.
  • Develop online data framework using ADOBE suite.
  • Developed training documentation with Subject Matter Experts (SMEs) for the implementation of the Oracle Business Intelligence Suite applications.
  • Project Lead - Data Migration from SAP to NetSuite ERP System - consolidation of multiple datasets and validation of integrity.
  • Evaluated HIPAA Suite Claim Responder tool to be used for 276/277 transactions as interim solution for a decommissioning claims platform.
  • Coordinated the data migration and implementation for two CRM (Salesforce, NetSuite) systems to the organization.
  • Developed the training schedules, user manuals and trained the end users for using Guidewire Insurance Suite.
  • Involved in development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings.
  • Utilized Microsoft Office Suite, including Outlook, Word, Excel, Access, and Lync.

Show More

3 Suite Jobs

No jobs at selected location

19. XML

demand arrow
average Demand
Here's how XML is used in Business & Data Analyst jobs:
  • Integrated larger XML data payload eliminating additional service calls.
  • Key Achievements: * The use of SQL triggers, packages, tables and procedures and necessary GEL/XML scripts.
  • Have used XML Spy for Data Mapping and Data Modeling for large scale System Integration with Partner Applications.
  • Provided DTD (Document Type Definition) for XML files to be used in the ETL process.
  • Performed Data Analysis by parsing XML, comparing different XML files and running SQL queries.
  • Tested Web Services/SOAP and XML using SOAP UI and Web Inject.
  • Web service validation using Soap UI Tool and XML.
  • Validated defects in XML file for IVR application.
  • Generated XML documents using the XML Output Stage.
  • Created SQL triggers, packages, tables, and stored procedures; wrote GEL / XML scripts.
  • Worked with various kinds of source files like flat files, XML files, GDG files.
  • Created Interface Specifications, mapping documents and data model, XML schemas to be used by various Functional Streams.
  • Experience working with XML application interface developers in order to work on web centric web portal.
  • Designed XMLs for bringing data from Life/70 to Staging area.
  • Created and modified build configuration files including POM.xml.
  • Created XML Datasets using C#.net.
  • Used XML Spy to view XML Schemas and WSDL files.
  • Created and updated the XML schemas which act as middleware between the front end and back end systems.
  • Performed Data mapping (source to target- XML transactional database to Teradata) and data profiling.
  • Prepared XML Schemas and DTDs for integrating data of acquired banks.

Show More

20. Unix

demand arrow
average Demand
Here's how Unix is used in Business & Data Analyst jobs:
  • Modified the UNIX scripts for Testing purpose to check the Rollback mechanism, Restatement window logic, wrapper scripts etc.
  • Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Provided custom modification to client electronic ANSII/UNIX files for import into Smart Mailer (Zip Code collating/mailing utility).
  • Created Auto email Alert in UNIX to send notification to the operations team in case of job failure.
  • Played a lead role in the migration of the marketing data mart to a new UNIX server.
  • Install Oracle 10g databases in UNIX and Windows environments for production, QA, and testing purposes.
  • Worked in development and maintenance of programs in SAS for UNIX in a user support environment.
  • Gathered Requirements, wrote programs and implemented system modifications on UNIX and Windows pharmacy systems.
  • Integrated data from different databases through SAS EG and UNIX server.
  • Tested ETL batch processes using UNIX shell scripting.
  • Worked on Unix Operating system.
  • NET, ASP.NET, UNIX, Business Objects, Test Director, Load Runner.
  • Created Unix Shell scripts and Batch scripts to automate file transfers from Data Warehouse to customer file landing gatewayzone.
  • Developed reports using SQL, SAS on a variety of platforms - Oracle, Unix, Teradata.
  • Monitored the network status, CPU utilization and scheduled jobs in cron using UNIX commands.
  • Worked on Parameterize of all variables, connections at all levels in UNIX.
  • Performed backend testing using SQL queries and analyzed the server performance on UNIX.
  • Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX.
  • Have designed and Developed Several Automation Process/ Scripts (UNIX/C/Scripting/Ksh/My SQL/Oracle SQL) for the Team.
  • Provided the required transformation logic using Teradata queries and performed ad hoc Data analysis through UNIX.

Show More

21. Informatica

demand arrow
average Demand
Here's how Informatica is used in Business & Data Analyst jobs:
  • Use Informatica Developer to reuse profiling and rule specifications from data stewards across all applications.
  • Assisted in the process of preparation of the document Informatica Transformation Development Standards.
  • Documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
  • Modify and develop new ETL transformations, summary tables, data staging areas based upon redesign activities with Informatica ETL tool.
  • Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
  • Identify anomalies, manage data quality exception records and track data quality targets on an ongoing basis using Informatica Analyst.
  • Keep focus on tight integration overlap and Informatica's newer commitment to MDM with the acquisition of Identity Systems.
  • Designed, created and maintained complex Data Transformation documents to aid in building Informatica Scripts during migration.
  • Worked with Informatica Data Quality (IDQ) for data cleansing, data matching and data conversion.
  • Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed.
  • Performed ETL operations, quality control and data management using SQL and Informatica Data Quality tool.
  • Created Informaticamaps to load data from Sequential files, Flat Files and MS Access.
  • Analyzed the Informatica ETL maps to make sure they meet the Data Requirements.
  • Detailed experience in Customer Account profiling data using the Informatica Analyst tool.
  • Used Informatica tool to transfer the data to the target Database.
  • Tested the ETL Informatica mappings and other ETL processes.
  • Directed an Informatica Migration from version 8.6.1 to 9.5.
  • Facilitated data load and transformation by creating workflows in Informatica.
  • Performed Logical & Physical Data Modeling and delivering Normalized, De-Normalized & Dimensional schemas Delivered Source-to-target mappings and developed Informatica mappings/mapplets.
  • Prepare the documentation and facilitate onsite user training Development environment: Oracle, Teradata, Informatica PowerCenter

Show More

3 Informatica Jobs

No jobs at selected location

22. Pivot Tables

demand arrow
average Demand
Here's how Pivot Tables is used in Business & Data Analyst jobs:
  • Performed dicing and slicing on data using Pivot tables to acquire the churn rate pattern and prepared reports as required.
  • Used Oracle warehousing dimensional databases and Microsoft Access with SQL queries to produce reports, spreadsheets and pivot tables.
  • Used MS Access, MS Excel (Pivot tables), SQL for data analysis and data validation.
  • Used advanced excel features (pivot tables, multiple linked sheets etc) to prepare spreadsheets.
  • Tracked down and analyzed data anomalies by employing Pivot Tables, VLOOKUP, Formulas and Functions
  • Migrated MS Excel data through pivot tables and exports to the new database of record.
  • Performed research on data using pivot tables in excels.
  • Created Pivot tables in Microsoft excel for further analysis.
  • Used Excel functions to generate spreadsheets and pivot tables.
  • Used advanced functions and functions derive summaries and dashboards Created charts, graphs, pivot tables and charts.
  • Involved in creating the pivot tables and bar charts for the schedule fields requiring the obligor financial data.
  • Used Pivot tables and advanced Excel functions to research and analyze KPIs, trends and anomalies.
  • Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP.
  • Have strong excel skill in creating macros, creating pivot tables & complex repots.
  • Developed interactive Pivot tables that matched Employee, Titles, Positions and salary.
  • Created reports using formulas such as Vlookup, goal seek and pivot tables.
  • Organize data in spreadsheets using V-Lookup, Pivot tables and tailor-made dashboards.
  • Analyzed data and created Pivot tables, macros, vlookups, hlookups if then statements in Excel.
  • Advanced Excel Skills and Experience macros, formulas, pivot tables, charts, v-lookup etc.
  • Completed Contract) Used Excel pivot tables to analyze payroll and benefits data.

Show More

5 Pivot Tables Jobs

No jobs at selected location

23. Teradata

demand arrow
average Demand
Here's how Teradata is used in Business & Data Analyst jobs:
  • Performed extensive data modeling; used Teradata database for reporting.
  • Leveraged my relationships and networks to learn more about Teradata and recognized its benefits for use within our team.
  • Generated MBR (Monthly Business reports) for leadership reference via Teradata utility BTEQ and SAS using PROC REPORT.
  • Developed reports based out of 2 different data sources (Teradata and SQL Server) with respective Universe.
  • Analyzed the Data Entity Relationships for Teradata trend analysis and worked on Functional Requirements Document (FRD).
  • Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
  • Created Teradata objects like Databases, Users, Tables, Views and Macros.
  • Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
  • Populated databases for reporting and transferred to Teradata using MRP / ETL practices.
  • Extracted data from Teradata and Oracle and created pivot tables in Excel.
  • Designed, built and modified databases SQL Server 2008 and Teradata.
  • Build and analyze queries from Teradata & Oracle databases using SQL.
  • Key player in introducing the use of Teradata within my team.
  • Used Teradata utilities like MLOAD for multiple loading.
  • Created Teradata objects like Tables and Views.
  • Used Teradata OLAP functions like random, qualifies, top n, CSUM, sample and random.
  • Produced Ad hoc reports by extracting data from enterprise data warehouse repository system using Teradata SQL and SAS EG.
  • Created Actuate and Crystal Reports to analyze data pulled from Teradata stored queries and displayed in Oracle database.
  • Worked on Teradata Queryman to validate the data in warehouse for sanity check.
  • Conduct Analysis to reduce reports runtime against huge Teradata and SQL Server database.

Show More

1 Teradata Jobs

No jobs at selected location

24. Subject Matter

demand arrow
average Demand
Here's how Subject Matter is used in Business & Data Analyst jobs:
  • Gathered business requirement by conducting detailed interviews with business users, stakeholders, and subject matter experts.
  • Document functional requirements and coordinate as primary subject matter expert.
  • Involved facilitating meetings with business analysts and subject matter experts.
  • Organized sprint meetings to engage business associates/Subject Matter Experts, in business planning, business analysis, and product requirements.
  • Conducted JAD sessions between the business users, Developers, testers & Subject Matter Experts to resolve bottlenecks.
  • Coordinated resource requirements and engaged subject matter experts across one or more projects and multiple geographic regions.
  • Elicited business requirements from subject matter experts and translated into user stories using Agile methods and processes.
  • Prepared product backlog working with product owner and other SME (Subject Matter Experts).
  • Communicated professionally with a diverse group, executives, managers, and subject matter experts.
  • Provided subject matter expertise related to technical program knowledge, implementation, testing and risks.
  • Subject Matter Expert on the structure, contents and relationships for several Oracle databases.
  • Provided CranSoft knowledge transfer sessions to Business Systems Analysts and Business subject matter experts.
  • Provided subject matter expertise (SME) for business accounts, sometimes telecommuting.
  • Worked with subject matter experts to define User Acceptance Test cases.
  • Served as a subject matter expert on legacy Merrill Lynch applications.
  • Serve as database subject matter expert for Ambulatory.
  • Initiated walkthroughs and interviews with the Subject Matter Experts (SME) and stakeholders to keep track of user requirements.
  • Involved in the creation and maintenance of the Workflow plans and organizing workshops with Subject Matter Experts.
  • Provided Subject Matter Expertise for processes related to the creation of test data files for automation upload to Celita application.
  • Interviewed Engineersand Subject Matter Experts (SMEs) to understand the current product and analyze User Requirements.

Show More

5 Subject Matter Jobs

No jobs at selected location

25. Project Management

demand arrow
average Demand
Here's how Project Management is used in Business & Data Analyst jobs:
  • Possessed high-level knowledge and proficiency in project management methodologies and tools, resource management practices, and change management techniques.
  • Have arranged for various Team meetings and communicated effectively both with Project Management and Business Users.
  • Reviewed project management plans with project managers and coordinates efforts with stakeholders.
  • Assisted in project management of the procurement of real estate, merchandise, equipment and services while establishing office relocation.
  • Collaborated with IS and Claims to define project direction; develop project plans with technical and project management staff.
  • Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
  • Worked with project management to analyze change requests to determine what is being requested and programming required.
  • Utilized Project Management applications such as RALLY and JIRA to facilitate smooth functioning of all projects.
  • Interact with account management, project management, and clients as appropriate both locally and globally.
  • Created standard project management tools to enable more accurate estimation of project time lines.
  • Reported weekly on status, milestones and project tracking to project management and stakeholders.
  • Provide website project management for the internal commercial product website (McDash Online).
  • Work with project manager to build out plans using project management tool.
  • Project management work for internal audits in legal and foreclosure groups.
  • Provided active involvement in project management, project plans, forecast.
  • Included project management, analysis, design and training activities.
  • Experience working with Defect tracking / project management tool JIRA.
  • Team Management and Co-ordination: Worked with project management to schedule, manage scope and analyze change requests.
  • Project Management experience on 'Assessment Payment History data' to Credit Bureau for Sperlonga.
  • Defined project scope and objectives through internal project management methodologies Encourage Transparency, openness in standups, reviews, and retrospective.

Show More

8 Project Management Jobs

No jobs at selected location

26. BI

demand arrow
average Demand
Here's how BI is used in Business & Data Analyst jobs:
  • Reviewed and analyzed daily eligibility files received from prescription benefit clients.
  • Served as team representative during biannual audits held within the company, which demonstrate the efficiency of standard operating procedures.
  • Enhanced Excel based reporting system by increasing flexibility of the interface and tuning the SQL queries behind the application.
  • Collected, evaluated, tested and reported on system software to determine the feasibility of implementation.
  • Monitor the tool and new IT capabilities, through the post-production normalization phase and report issues.
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI.
  • Provided training to co-workers on daily Eligibility and ORT process.
  • Have been working in billing and payments of insurance.
  • Worked on System Integration (X12 EDI-HIPAA-835) with Health plans eligibility and claim (CPT, ICD 9 codes).
  • Worked on the ICD 9 CM and 10 CM codes for billing purposes.
  • Developed BRD's for new projects in the BI realm.
  • Documented requirements associated change requests with requirements and connected requirements with Use cases in Requisite Pro and created different traceability views.
  • Conducted business support responsibilities, including production monitoring, file maintenance, and ad-hoc reporting.
  • Gathered requirements and implementation for Tableau BI Data Analytics.
  • Designed data flow diagrams Worked closely with the Business Intelligence (BI) team to define standards for report.
  • Create requirements traceability matrix, testing inventory, test scripts and managed UAT testing.
  • Created different Traceability views to maintain the Traceability of the requirements.
  • Prepared Business Specifications, Functional Specifications, Requirement Traceability Matrices (RTM) Organized architectural artifacts using Zachman's framework.
  • Support the advisors capability to switch desktop between multiple languages that are supported by the advisor profile.

Show More

19 BI Jobs

No jobs at selected location

27. Pl/Sql

demand arrow
average Demand
Here's how Pl/Sql is used in Business & Data Analyst jobs:
  • Participated in testing of procedures and data, utilizing PL/SQL, to ensure integrity and quality of data in data warehouse.
  • Involved in performing extensive Back-End Testing by writing SQL queries and PL/SQL stored procedures to extract the data from SQL Database.
  • Created database objects like tables, views, procedures, packages using Oracle tools like PL/SQL developer and SQL* Plus.
  • Implemented an in-house solution to report out on complex data quality rules for master data using Oracle PL/SQL and procedures.
  • Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
  • Created PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic.
  • Developed and modified database procedures, functions, packages to enhance and improve functionality using PL/SQL.
  • Created views and stored procedures for Reports using complex SQL, PL/SQL, T-SQL.
  • Risk analysis and reporting using MS Excel, crystal reports and PL/SQL, SQL.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Developed PL/SQL programs, stored procedures for data loading and data validations.
  • Developed Crystal Reports from Epic Clarity database (Oracle) using PL/SQL.
  • Prepared test Data sets and performed data testing using the PL/SQL scripts.
  • Traced ASP and PL/SQL code to determine cause of reported problems.
  • Validated enhancements using Oracle SQL Developer, SQL, PL/SQL queries.
  • Developed PL/SQL procedures for processing business logic in the database.
  • Maintained & enhanced financial database applications in Oracle using PL/SQL.
  • Executed SQL queries, PL/SQL stored procedures, triggers on backend as a part of data analysis and data validation.
  • Performed Backend testing by using PL/SQL queries to test the integrity of the application.
  • Increased ROI by creating compelling sales pitches with metrics with Experian Hitwise and SQL, PL/SQL.

Show More

28. RUP

demand arrow
average Demand
Here's how RUP is used in Business & Data Analyst jobs:
  • Created requests and conducted testing for custom system implementations needed for successful transition without claim interruptions.
  • Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications.
  • Incorporated RUP methodology to create Business Requirement Document Specifications.
  • Established a business analysis methodology around the RUP.
  • Implemented RUP within the different groups involved in the project to configure and develop process, standards, and procedures.
  • Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
  • Established RUP (Rational Unified Process) methodology and provided assistance in developing Use cases and project plans.
  • Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
  • Involved in creation of a Loan Origination System using RUP for the Capital One Mortgage/Loan Services division.
  • Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
  • Participated in pilot sessions on the use of RUP's RequisitePro, ClearQuest, and ClearCase.
  • Used Rational Unified Process (RUP) for streamlining the team's development activities.
  • Implemented RUP recommended visual models to draft business requirements by using Use Cases.
  • Developed business process models in RUP to document existing and future business processes.
  • Followed the adaptive RUP framework for the whole Project life cycle.
  • Ensured compliance to the Rational Unified Process (RUP) methodology.
  • Implemented the Rational Unified Process (RUP) methodology of iterative software development with its various workflows, artifacts and activities.
  • Key Highlights: Ensured all clients switching to or from Express Scripts would not experience interruption in prescription service.
  • Discussed solutions with directors and supervisors to prevent past issues that interrupted client service.
  • Established a RUP (Rational Unified Process) centric business analysis methodology.

Show More

1 RUP Jobs

No jobs at selected location

29. Ssis

demand arrow
average Demand
Here's how Ssis is used in Business & Data Analyst jobs:
  • Assist Management with preparation of financial and business analysis forecast to support and influence the organization's initiatives.
  • Assisted with client interviews to inquire business specifications thereby executing systems study and preparation of design documents.
  • Assist with developing and implementing data mining and warehousing programs.
  • Partnered with business and technical areas on large complex projects to help resolve issues and to assist in data needs.
  • Assisted in Data Stage Server jobs to load data from sequential files, flat files and MS Access.
  • Worked with the technical teams to resolve queries and assist them in creating Technical Design Documents.
  • Assisted in planning and foreseeing sales, account, and industry specific sales activities.
  • Assisted the users in UAT testing by providing test scenarios and test data.
  • Assisted in creation and execution of test plans for integration and system tests.
  • Assisted in development of data formatting and cleaning criteria from various data sources.
  • Assisted in updating and maintaining the Sprint Backlog and Burn-Down Charts.
  • Assist with set up and implementation of agencies in prep environment.
  • Assisted in testing reports that were developed using COGNOS.
  • Assisted with external partner and client relationships.
  • Assist applications to correctly test their impacts.
  • Assisted in designing and development of health related analytical products for overall enterprise.
  • Assisted in maintaining the project plan & schedule using MS Project and ensured on-time and high quality deliverables to the client.
  • Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
  • Provided postproduction support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans.
  • Assisted the data architect with designing and architecting the ETL process.

Show More

30. Rational Requisite Pro

demand arrow
low Demand
Here's how Rational Requisite Pro is used in Business & Data Analyst jobs:
  • Led the requirements gathering phase for the project and created Business Requirements and Functional Design Specification documents using Rational Requisite Pro.
  • Conducted JAD (Joint Application Development) sessions, gathered business requirements, analyzed and prioritized requirements using Rational Requisite Pro.
  • Facilitated collection of functional requirements from system users and preparation of business requirement documents using Rational Requisite Pro.
  • Employed Rational Requisite Pro to manage all the high level requirements and translate business requirements into functional requirements.
  • Worked extensively in Rational Requisite Pro to organize and catalog requirements, documents, and use-case documents.
  • Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
  • Documented business requirements for system issues and enhancements using Rational Requisite Pro.
  • Tagged requirements using Rational Requisite Pro.
  • Document, analyze and define the user and system requirements and use Rational Requisite Pro to manage the requirements.
  • Coordinated with all Allstate agents to gather requirements for the application and managed them using Rational Requisite Pro.
  • Identified, organized, and documented the changing requirements for the application using Rational Requisite Pro.
  • Created the functional requirements through the use of the existing templates and Rational Requisite Pro.
  • Used Doors, Rational Requisite Pro, & Rally for Requirements Documentation and management.
  • Communicated with team members and client using Rational Rose and Rational Requisite Pro.
  • Manage requirement with the help of Rational Requisite Pro.
  • Used Rational Requisite Pro for managing the requirements.
  • Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
  • Managed change of the requirements and associated requirements to other requirements for traceability using Rational Requisite Pro.
  • Maintained traceability matrix using Rational Requisite Pro for the current business processes and proposed changes.
  • Prepared RTM(Required Traceability Matrix) using Rational Requisite Pro.

Show More

31. Toad

demand arrow
low Demand
Here's how Toad is used in Business & Data Analyst jobs:
  • Write SQL to query database using TOAD and SQL Servers for verification and validation and perform database restore from site backups.
  • Utilized Oracle Discoverer, Toad, Microsoft Access, Microsoft Excel, Microsoft Project, Microsoft Word extensively.
  • Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
  • Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
  • Assisted performing End-to-End testing, and complex database testing using Toad / Oracle.
  • Prepared test Data and performed Data Testing using the SQL queries in TOAD.
  • Create test cases and SQL scripts, execute and validate results in TOAD.
  • Defined the duplication of data and columns between tables using TOAD and SQL.
  • Validate the result using PL SQL in Oracle SQL Developer and TOAD.
  • Performed Oracle 10g database object creation & validation w/TOAD & SQL Server.
  • Used TOAD to validate the data in the SQL server data warehouse.
  • Used tools such as Hp quality center, Rational Requisite and Toad.
  • Conducted Data Analysis by creating SQL Queries using Toad.
  • Create Oracle indexes for Lawson developers using Toad software.
  • Worked on enhancing and monitoring SQL Queries using TOAD.
  • Used Toad to verify data.
  • Run the SQL queries using TOAD and SQL Navigator.
  • Conducted data reverse mapping utilizing the TOAD, Siebel (SQL, PL/SQL server) for Oracle systems.
  • Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
  • Performed report validation writing sql queries using TOAD on an Oracle database.

Show More

32. Ssrs

demand arrow
low Demand
Here's how Ssrs is used in Business & Data Analyst jobs:
  • Produced reports (including Ad-Hoc) using Access, Excel, MS SQL/SSRS for internal/external customers posted them on SharePoint site.
  • Rebuild the Numbers Summary SSRS Report and supporting procedures to include Health Factor Type as a drop down within Health groups.
  • Gathered requirements from the users, Created BRD documents, and developed base SQL and creating Crystal and SSRS Reports.
  • Worked closely with internal customers analyzing problems and created and maintained reports using SSRS Reports and SQL server.
  • Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
  • Outlined the model summary, its performance and predictive power and created reports for management using SSRS.
  • Maintained Report Manager and Reporting Server for SSRS to manage routine report production for clients.
  • Customized reporting tools like SSRS to generate different report layouts to satisfy clients' needs.
  • Designed, developed and deployed reports in MS SQL Server environment using SSRS.
  • Generate reports of transactions using SQL Server Reporting Services (SSRS).
  • Published and monitored various reports - Excel, SSRS.
  • Designed, deployed and maintained SSRS reports.
  • Designed and developed report models with SSRS.
  • Used T-SQL to write and edit queries in Microsoft SQL Server 2012 and SSRS.
  • Created Parameterized reports and report serving architecture by using SSRS.
  • Supported in generating detailed reports regarding testing, defects and rejects outcomes using report generator, file comparator SSRS.
  • Created, developed and improved the reporting dashboards (with KPIs) through SSRS and Excel OLAP Pivot table.
  • Authored complex stored procedures used in ad-hoc and subscription based SSRS reports.
  • Created ad-hoc reports per client request using SSRS 2016.
  • Generated parameterized/Drilldown reports using SQL Server Reporting Services (SSRS) 2008.

Show More

33. SAS

demand arrow
low Demand
Here's how SAS is used in Business & Data Analyst jobs:
  • Experience in documenting and Implementing Disaster Recovery Plans.
  • Documented comprehensive backup plan and disaster recovery strategies.
  • Participated in the logical and physical design sessions, conducted disaster recovery planning (DRP), and developed design documents.
  • Advanced SAS Programming employing Macros Used macros and arrays to analyze daily data of foreign exchange quote log ratios.
  • Experience in SAS and SQL queries to retrieve and validate data, prepared for data mapping document.
  • Created input data sets and analyzed the data by creating graphs using the SAS/GRAPH facility.
  • Developed approaches for analyzing business problems using statistics and data modeling tools in SAS.
  • Automated and streamlined repetitive processes using mainframe SAS, saving thousands of manual hours.
  • Produced models in SAS Enterprise Minor for predicting failures and identifying fraud claims.
  • Developed SAS macros for data cleaning, reporting and to support routing processing.
  • Delivered root cause analysis by Text Mining tool in SAS Enterprise Miner.
  • Used SAS JMP to perform regression analysis on large volume of data.
  • Developed SAS programs for statistical analyses and data displays.
  • Worked as a backup SAS Administrator.
  • Developed backend calculations required to produce volatility and correlation matrix using SAS.
  • Updated existing and developed new UNIX SAS scripts that use Proc SQL to access existing Oracle based TRAX, FALCON database.
  • Transform data to build quality reports/dashboards in Tableau, Pentaho, SSAS Cube, Excel for 5 Support organizations.
  • Develop new and modify existing reports in SAS, Cognos, MS Access and Crystal Reports.
  • Report generation using many SAS proc statements, SAS/MACROS, and data null steps.
  • Created SAS Customized report using the Data_null_ technique.

Show More

1 SAS Jobs

No jobs at selected location

34. Scrum

demand arrow
low Demand
Here's how Scrum is used in Business & Data Analyst jobs:
  • Worked in agile/scrum methodology for better and rapid delivery of the business solutions.
  • Developed user stories in an Agile/Scrum environment.
  • Attended Daily Scrum Meetings with team members and clients and performed the role of Scribe for all the sprints.
  • Facilitated sprint planning, review, retrospective and daily scrum meetings, documented acceptance criteria, definition of done.
  • Worked in the Agile methodology using SCRUM to analyze requirements, and design and unit test the system.
  • Managed Daily Scrum, backlog refinement, sprint planning, sprint demonstrations, and retrospective meetings.
  • Followed daily scrum meetings, monthly iterations, iteration planning meetings and story boarding.
  • Participated in daily SCRUM work meeting /stand-up meeting and weekly Sprint project progress meetings.
  • Participated in Agile Scrum planning meeting and provide status on daily stand up meetings.
  • Experienced in the use of agile approaches, including Test-Driven Development and Scrum.
  • Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle.
  • Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
  • Used MsProject to gather the requirements and update them over each Scrum Meeting.
  • Participated and contributed in Daily Scrum, Sprint meeting and sprint review meetings.
  • Used ScrumWork Pro and Microsoft Office software to perform required job functions.
  • Utilized Agile Scrum methodology and aggressively worked on every stages of SDLC.
  • Conduct SCRUM AGILE training sessions to junior analysts and cross-functional teams.
  • Work with Agile Scrum teams to help resolve issues and conflicts.
  • Provide status during stand-up or scrum meetings.
  • Prepare the user stories, technical documentation and prioritize the tasks and work thru SCRUM/Agile process.

Show More

2 Scrum Jobs

No jobs at selected location

35. Management System

demand arrow
low Demand
Here's how Management System is used in Business & Data Analyst jobs:
  • Analyze data and build requirements for conversions/implementations of outsourced and co -sourced data management systems for Fortune 500 companies.
  • Managed an internally developed Content Management System for posting Client and Deal related content across BankNET.
  • Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.
  • Utilized enterprise-wide requirements definition and management systems and methodologies required (RSA).
  • Used MicroStrategy to develop Dashboards and Tools for web-based trading management system.
  • Worked with Access Management/Inventory Management system for managing user profiles.
  • Designed and developed data management system using MySQL.
  • Worked on design and development of Relational Database Management System (RDBMS) and reduce the redundancy by data normalization.
  • Used Maven dependency management system to deploy snapshot and release artifacts to Nexus to share artifacts across projects and environments.
  • Ensured that all production changes were fully documented, supportable and captured in the Enterprise configuration management system.
  • Assisted in the development of a Web Content Management System that increased project collaboration for the business users.
  • Involved in Gap Analysis and ROI analysis of existing policy management system with the Enterprise system.
  • Used PIP package management system, to install and manage various required software packages used.
  • Generated functional requirements for The Business Information Management Systems (BIMS) of the Complex.
  • Identify performance issues in the Transaction Management system and coordinate with the support group.
  • Project: Portfolio Management System The project was involved in the re-engineering Portfolio Management System.
  • Worked on modification of Fortracs default management system to allow for HAFA and other legal changes.
  • Utilized SQL scripting to scrub the Joint Adjudication Management System (JPAS) Sybase database.
  • Build & amend curriculum in Blackboard & iLearn Plateau Learning Management Systems.
  • Order Management System Designed workflow documentation and functional specifications for the Sell Side Order Management Systems.

Show More

36. Cognos

demand arrow
low Demand
Here's how Cognos is used in Business & Data Analyst jobs:
  • Developed scope documents, financial projections, budgeting and analysis for the project using IBM Cognos10.
  • Used COGNOS to create reports and communicated these reports to senior management and stakeholders.
  • Develop reports using SAS and COGNOS Report Studio.
  • Designed reports and data sets for COGNOS reporting.
  • Identify the technical needs of the organization and accordingly develop Cognos based applications and software.
  • Analyzed, prioritized and managed the requirements for enhancing existing reports developed with Cognos.
  • Provided technical and functional consulting to corporate and divisional users for Cognos.
  • Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
  • Provided analysis reports to Engineers for R & D projects using Excel, Cognos and Oracle ERP Module.
  • Used Access and Cognos to reverse engineer reports in support of a new data strategy project.
  • Worked with the Cognos developer to format and outline the report as per the user requirements.
  • Created ad-hoc reports utilizing Excel, Access, COGNOS BI and other tools.
  • Assisted ETL development done using Data Stage and report development using Cognos.
  • Worked with Cognos team to verify the format of report.
  • Used IBM Cognos to model relational data and run reports.
  • Create numerous data trending Cognos reports for product analysis.
  • Created and maintained Cognos packages in Framework Manager.
  • Provided accurate statistical reports using Excel and Cognos to Directors of cross-functional teams.
  • Provide ad-hoc reporting, analysis of data, and recommendations Using ORACLE, Microsoft Excel, Cognos products and databases.
  • Designed production rollout process for Cognos applications Promoted packages to production using Import/Export utility.

Show More

37. Traceability Matrix

demand arrow
low Demand
Here's how Traceability Matrix is used in Business & Data Analyst jobs:
  • Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
  • Communicated client s business requirements by constructing Requirements Traceability Matrix, Use cases and reports.
  • Traced business requirements, design specifications, and test cases using Requirement Traceability Matrix.
  • Maintain Traceability Matrix between Business Requirements Design components, Business Rules and Test cases.
  • Conducted Gap Analysis and thereby created Traceability Matrix between Requirements and Test Cases.
  • Analyze the various processes and document the logic involved using requirements traceability matrix.
  • Managed and monitored requirements by developing Requirement Traceability Matrix (RTM).
  • Developed and maintained Test Matrix and Traceability Matrix.
  • Maintained Traceability Matrix in Excel.
  • Maintain Requirement Traceability Matrix to ensure that all the specifications are been tested and the application is bug free.
  • Developed the traceability matrix to track back the test cases for every requirement and check the expected results.
  • Developed Requirement Traceability Matrix (RTM) to view the coverage of Business Requirements till Test cases.
  • Prepared test cases, test plans, test strategies, traceability matrix for QA team.
  • Developed traceability matrix for visibility from FSD, BRD to Test case and defects.
  • Created and maintained the Requirements Traceability Matrix (RTM).
  • Created Testing Artifacts, Test Strategy and Traceability Matrix.
  • Maintained Requirement Traceability Matrix (RTM) Proactively anticipated problems and provided solutions and suggested alternatives.
  • Tracked the requirements delivery progress using Requirements Traceability Matrix.
  • Imported, managed and tagged requirement documents, and designed project deliverables (Traceability Matrix) using various tools.
  • Created different Traceability views to maintain the requirements using the Requirements Traceability Matrix (RTM).

Show More

38. VBA

demand arrow
low Demand
Here's how VBA is used in Business & Data Analyst jobs:
  • Performed time series modeling to predict future prices of commodities for futures and OTC derivatives in Excel VBA add in creation.
  • Performed complex SQL ETL data analysis using ACL, VBA and databases to identify audit risks and developed reports for management.
  • Leveraged VBA / Macro / advanced formulas / PivotTables in Excel to build reporting solutions for a number of teams.
  • Create and updated VBA macros to automatically update Excel workbooks, encompassing class and program modules and external data queries.
  • Analyzed and automated the monthly report generation procedure using Excel VBA, reducing delivery time by 75%.
  • Analyzed Oracle source and target databases with Access via queries, reports, forms, and VBA code.
  • Developed stand-alone Access database systems, which involved using VBA and existing excel files to import data.
  • Analyzed cost to connect metrics, automated expense analysis tool for projections using Excel & VBA.
  • Improved a data issue tracking system with a data validation VBA macro.
  • Created VBA macros in Excel to boost various teams' productivity.
  • Run Macros in VBA in mapping Templates.
  • Created VBA Macros in Excel.
  • Analyzed user enrollment and ticketing data in Excel with Vlookups, Pivot tables, Charts and VBA code.
  • Developed Excel 5 VBA App to check daily bond prices of various contributors for price anomalies.
  • Designed and Developed CEVA Guaranteed Service eQuote application using MS Access 2003, VBA and Excel.
  • Analyzed data in Excel with VLookups, Pivot Tables, Macros, and VBA code.
  • Automated manual processes and created prototypes for one of the process workflow using VBA.
  • Optimized script/algorithm to reduce run-time for existing VBA tools for application to large datasets.
  • Debugged VBA macros for MS Excel and MS Access from unformatted VBA and SQL old code without any existing comments.
  • Developed Excel 5 VBA App DDE data from the Reuters Terminal for "GovPX bond prices".

Show More

39. Data Integrity

demand arrow
low Demand
Here's how Data Integrity is used in Business & Data Analyst jobs:
  • Managed Quality Assurance for processing of financial data from various resources to ensure data quality and maintain data integrity.
  • Communicated opportunities and enhancements to improve data integrity, database structures, data processing, and data retrieval tools.
  • Ensured data integrity and data consistency across products/projects while also conducting analyses and creating reports.
  • Formatted and cleaned internal and external data, ensuring data integrity and duplication removal.
  • Diagnosed data exceptions and recommended controls to ensure data integrity and accuracy.
  • Validate data integrity in production by running regression scripts and analyze results.
  • Analyzed customer data, verified data integrity issues.
  • Audited, corrected and maintained data integrity.
  • Resulted in resolution long-experienced data integrity issues.
  • Analyzed and mapped data structures do insure data integrity and duplication error prior to data conversions.
  • Monitor SQL Server data warehouse for data integrity issues and correct as needed.
  • Created processes to ensure data integrity between the source and target systems.
  • Maintain data integrity across the reporting systems to ensure correct data holdings.
  • Extracted data from SFTP access maintaining and protecting data integrity.
  • Solved data integrity issues on daily basis.
  • Optimized SQL queries performance and data integrity.
  • Implemented SQL queries and generate reports to ensure database data integrity and meets user requirements.
  • Contributed to improving data integrity through the creation of security audits and processes for Peoplesoft.
  • Provide ad hoc queries via SQL for reporting, trouble shooting and data integrity.
  • Maintain data integrity across all modules (i.e.

Show More

40. Web Application

demand arrow
low Demand
Here's how Web Application is used in Business & Data Analyst jobs:
  • Developed web application utilizing CranSoft Software to effectively report data cleansing progress.
  • Web application was leveraged daily by key business stakeholders.
  • Involved in designing and creating web application for customers and windows application for the internal employees to view and manage accounts.
  • Managed a database web application used to update live inventory to two e-commerce web stores on Amazon and Yahoo Shopping platforms.
  • Created, tested, and scheduled SQL Server DTS packages for ETL process to provide web applications with data.
  • Developed PL/SQL stored procedures and functions to support access to the Oracle database from the web application.
  • Led development of the project, a mobile and web application from concept through to post-launch.
  • Developed custom web application for internal quality audits of agents' parts and service dispatches.
  • Provided data to ASP.NET web applications from data definition, ETL to QA.
  • Provide maintenance and development of bug fixes for existing web applications.
  • Involved in testing different interfaces and web application for FACETS.
  • Worked on the web application requirements related to COTS.
  • Train users on web application for accessing reports.
  • Worked on web application for the customer portal.
  • Provided web application client support.
  • Developed database standards for global deployment security and business recovery Provided performance guidelines and analyzed database metrics for Web Applications
  • Gathered requirements and specification for analytics, business intelligence tool and web applications.
  • Led the requirements elicitation and analysis for Web application project.
  • Provided insights on website visitors and performance of web applications using Google Analytics and Adobe Site Catalyst analytics.
  • Develop and evolve the consumer-facing, multi-channel roadmap for desktop, mobile and mobile web applications.

Show More

41. DB2

demand arrow
low Demand
Here's how DB2 is used in Business & Data Analyst jobs:
  • Developed automated DB2 queries to validate referential integrity for scheduled Information Warehouse extracts.
  • Involved in Data Analysis of Life-Insurance application INGENIUM/Life-70 for designing of Data Mart Fact & Dimension tables on Windows UDB/DB2 platform.
  • Played a very influential role in the IBM DB2 database design meeting with the database administrators from both companies.
  • Installed DB2 v9.1 on the Data Admin node along with 4 data nodes (Balanced Configuration Units).
  • Worked as business analyst in data base conversion project where data was converted from DB2 to ORACLE.
  • Modified existing data loads using DB2 and SQL to complete data extraction in a timelier manner.
  • Migrated Data from existing data warehouse in SQL server to DB2 UDB using ETL tools.
  • Managed the Bonus Compensation system (COOL:GEN/DB2) for the TI software business.
  • Queried the DB2 database in Mainframes for the Proper validating the claims into the Database.
  • Developed SQL queries to extract data for validating the test data in DB2 tables.
  • Updated and modified existing current Data models using MS ACCESS, DB2 and SQL.
  • Use DB2 Control Center to verify that the database development requests have been completed.
  • Participated in conversion of main client data base from MODEL 204 to DB2.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in DB2, and MS Access.
  • Source of the Information is captured from the Ingenium DB2 environment and stored on UDB-DB2 on windows, using ETL process.
  • Use SQL for Querying the DB2 database in UNIX environment Write SQL queries and validate the data.
  • Used MS-Query, Quest Central and DB2 Command Center and Brio query database tools for data validation.
  • Performed ETL data loads from flat files, DB2, Teradata, SQL Server etc.
  • Extracted data from multi-platform systems using DataStage and loaded into DB2 databases.
  • Installed DB2 ESE v9.1 on dev / QA, PT and production.

Show More

42. Data Migration

demand arrow
low Demand
Here's how Data Migration is used in Business & Data Analyst jobs:
  • Identified business rules for data migration and Perform data administration through data models and metadata.
  • Develop mappings to enable data migration, application integration.
  • Perform data migration audit, reconciliation and exception reporting.
  • Coordinated data migration/testing and resolution of database/application issues.
  • Developed and executed data migration plans.
  • Verified and validated data migration effort by sample or aggregate value checks at the target taking into account the business requirements.
  • Performed development of the T-SQL stored procedures, SQL reports and scheduled jobs, DTS/ SSIS data migration jobs.
  • Assisted in Data migration to and deployment new database software/server in Business Unit ERP locally and overseas.
  • Prepare data migration plans including migration risk, milestones, quality and business sign-off details.
  • Work across multiple functional projects to understand data usage and implications for data migration.
  • Manage assigned risks and monitor potential impacts as part of the data migration plan.
  • Planned and executed data migration of old files into new shared file system.
  • Research data models and table requirements for data migration and data upload.
  • Identified the issues during data migration and worked for defect resolution.
  • Assist in designing, planning and managing the data migration process.
  • Work with customers in gathering business requirements for data migration needs.
  • Implemented and executed the testing plan, Data migration schema.
  • Support the implementation of Microsoft AX ERP Coordinate data migration from legacy systems to Microsoft AX ERP.
  • Performed data migrations/loads and regular systems maintenance to the Pledge Maker database and performed data quality checks.
  • Develop best practice, processes, and standards for effectively carrying out data migration activities.

Show More

3 Data Migration Jobs

No jobs at selected location

43. CRM

demand arrow
low Demand
Here's how CRM is used in Business & Data Analyst jobs:
  • Report generating and Analysis of reports for month end using Excel to generate data exported via the CRM's.
  • Performed business analyst tasks in an agile scrum project environment for the initial implementation of a CRM Cloud solution.
  • Received an award for the seamless transition to the new CRM application by the director of corporate sales/marketing practices.
  • Develop robust CRM database dash board and metrics module to help drive client service support future business initiatives.
  • Performed gap analysis on the client's requirements and the functionality within Microsoft Dynamics CRM.
  • Assessed the pros and cons of the conversion process of the RE to ECRM migration.
  • Worked on supporting the CRM production environment and resolving the issues for CRM production environment.
  • Researched IFS CRM module and lead the analysis of tool with selected end users.
  • Worked on Electronic health record system as a CRM web based application.
  • Input and/or correct data in LexisNexis InterAction CRM software for client.
  • Assisted Microsoft CRM and SharePoint testing, implementation and training.
  • Managed MS Dynamics CRM data migration and marketing/sales leads reporting.
  • Develop CRM database and solutions to create automations for subscription marketing and to measure subscription business performance.
  • Helped manage technology resources through use of custom-built solution and Salesforce CRM application
  • Analyzed complex operations data, ranging from CRM data, to product transaction volumes from the company's databases.
  • Worked closely with Harte-Hanks and other external vendors to launch java campaigns to calculate the CRM scorings.
  • Create training manuals for Siebel CRM, DMS, and Crystal Enterprise functions within my position.
  • Utilized Siebel Oracle CRM for managing customer support and service requests.
  • Worked on CRM Software, and in-house workflow management tools.
  • Migrated in-house systems to Blackbaud Websphere CRM to achieve interdepartmental data sharing and workflow.

Show More

1 CRM Jobs

No jobs at selected location

44. Html

demand arrow
low Demand
Here's how Html is used in Business & Data Analyst jobs:
  • Develop customized agents utilizing HTML and JavaScript to extract pertinent and accurate information from internet pages.
  • Incorporated Excel, PowerPoint, Keynote, and HTML5 Animation technologies to present current development status and results to clients.
  • Created sites, sub sites, ASPX pages, and links using SharePoint Server 2007 and HTML editor.
  • Created static and dynamic prototypes using HTML and CSS for better visualization and understanding of the software solution.
  • Default Report output is HTML and provided the options of WORD & EXCEL formats using SAS/ODS statements.
  • Designed and developed the UI of the website using HTML5, AJAX, CSS and JavaScript.
  • Collaborated with Web developer aiding with complex scripting logic using Python, JavaScript and HTML.
  • Designed Web based Data Repository page for internal employees using HTML and MS Front Page.
  • Designed the website's layout with HTML and CSS, with additional help from Bootstrap.
  • Monitored and analyzed the development of cascading style sheets in HTML at front end.
  • Designed and developed User Interface with ASP.NET and HTML.
  • Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
  • Formatted HTML, RTF, PDF reports, using SAS- Output Delivery System (SAS/ODS).
  • Code XML, HTML files.
  • Coded front-end using HTML5 Created sales data reports using work item query in Microsoft Excel.
  • Develop and Design Stamford-Reuters Intranet Web Pages using HTML.
  • Create and maintain HTML, Java or ASP.Net codes.
  • Front end programming includes: ASP.NET Ajax, .NET Framework, Telerik controls, JavaScript and HTML.
  • Developed the workflow to produce the output for the user in Pega Systems using html.
  • Prototyped some of the important pages using Dreamweaver and HTML for UI designer.

Show More

45. Source Systems

demand arrow
low Demand
Here's how Source Systems is used in Business & Data Analyst jobs:
  • Performed initial data profiling and analysis of data from legacy source systems.
  • Maintained operational relationships with the source systems.
  • Prepared data mapping document from Source Systems to destination source system and defined the Business rules to populate the data.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Understand the business intelligence of data warehousing environments and the data flow from the source systems to the target systems.
  • Created the data mapping document involving source to target mapping for tables in Data ware house from source systems.
  • Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS.
  • Conducted detailed Requirement and Gap Analysis sessions with various source systems SME and prepared Source System Understanding documents.
  • Designed and developed several mappings to load data from Source systems to ODS and then to Data Mart.
  • Participated in Data profiling, Data cleansing on different source systems to check data quality.
  • Used SQL query to analyze the Pfizer source systems and existing data warehouse data.
  • Audit various source systems (HR/Finance, Student Information) to ensure data integrity.
  • Developed Complex T-SQL Queries, stored procedures to fetch data from source systems.
  • Played a key role understanding various source systems for Target state Project.
  • Coordinated data quality and data feed issues with CitiGLand NACB source systems.
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Perform data profiling in the source systems that are required for financing.
  • Validated data across source systems and data warehouse.
  • Involved in Data mapping for the source systems.
  • Mined data from numerous source systems.

Show More

46. Clear Quest

demand arrow
low Demand
Here's how Clear Quest is used in Business & Data Analyst jobs:
  • Managed and controlled change using Clear Quest, associated requirements to specific change request/enhancements/defects within the change requests guidelines.
  • Performed defect management using Rational Clear Quest.
  • Gathered requirements from users of the Clear Quest (CQ) tool for any Enhancements or change requests for any defects.
  • Provided test execution statistics and matrix using Rational Functional Tester, Requisite Pro, Clear Case and Clear Quest.
  • Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
  • Conducted Defect Tracking and Change Control Procedures using Rational Clear Quest and Remedy.
  • Submitted change requests and worked with change request records in Clear Quest.
  • Participated in entering, tracking system defects in Rational Clear Quest.
  • Utilized Rational Clear Quest to track changes requests throughout the process.
  • Managed Change / Incident Management using Rational Clear Quest.
  • Documented business requirements and Changes required for rollouts using Rational Clear Quest.
  • Carried out defect tracking using Clear Quest Identifying and establishing retirement plan account identifiers for the Customer Profile System.
  • Employed Rational Clear Quest for effective Change Management (Requirements Creep) and bug tracking during the testing lifecycle.
  • Monitored and managed Team/ Group mailbox Monitoring requests and creating tickets using Clear Quest for the team.

Show More

47. Technical Specifications

demand arrow
low Demand
Here's how Technical Specifications is used in Business & Data Analyst jobs:
  • Developed detailed technical specifications for ETL & reporting in collaboration with data warehouse architect and senior ETL and business intelligence developers.
  • Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
  • Developed various technical specifications for enhancements and corrections to the existing application, updated SOP versions.
  • Gathered and articulated Business Requirements from User Interviews and Synthesis those requirements into technical specifications.
  • Interact with Business Users to gather user requirement and transforming them into technical specifications.
  • Created detailed functional and technical specifications after analyzing various transaction and user profiles.
  • Analyzed business requirements and developed detailed functional and technical specifications for development teams.
  • Participate in meetings at client locations, Develop Business requirements and Technical specifications
  • Document detailed functional and technical specifications based on agreed solutions.
  • Created Technical specifications for the Business Objects Reporting applications.
  • Translated the business requirements into technical specifications.
  • Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
  • Involved in the design and development of technical specifications using design patterns and OO methodology.
  • Performed analysis of the technical specifications of AS IS and TO BE process.
  • Interpret and analyzes Medicare Part C/D and MMP Required Reporting Technical Specifications.
  • Review technical specifications, QA test cases.
  • Interacted with Development Teams and Managers to analyse business needs and developed technical specifications.
  • Presented and provided technical specifications, QA test plans, status reports and budget and timeline estimates.
  • Created business flow diagrams of HEDIS Measure Technical Specifications as a model for database design.
  • Included functional and technical specifications, workflow diagrams, data flow diagrams, use cases, and UI wireframe diagrams.

Show More

48. Jira

demand arrow
low Demand
Here's how Jira is used in Business & Data Analyst jobs:
  • Worked with JIRA entering User Stories into respective epics, tasks and assisted with prioritizing stories for sprints.
  • Managed and Organized schedules, deadlines, Task Review meetings, Project Status, Defect tracking using JIRA.
  • Conducted Monthly Business Prioritization Meetings with the stakeholders identify JIRA cards to be scheduled for the upcoming release.
  • Used JIRA as a tracking and ticketing tool to organize programs, projects, epics and stories.
  • Analyzed and provided reports by extracting data from SharePoint, Excel and JIRA for the PMO.
  • Worked in JIRA for tracking user stories & user incidents/problem tickets as well as enhancements.
  • Used JIRA to document requirements, create versions, assign tasks and generate reports.
  • Tracked the effort using JIRA and used SCRUM methodology to deliver the output.
  • Carried out regression testing to track the status of open JIRA item.
  • Documented User Story using JIRA to detail the business need.
  • Experience in defect and change management reporting: JIRA.
  • Reviewed systems and procedures for change control using JIRA.
  • Implement new 3rd party application JIRA Project Management.
  • Check and log risks using JIRA.
  • Helped various teams for setting up JIRA Boards (Scrum Board, Kanban Board) for their project.
  • Experience with the Atlassian JIRA and Confluence, Microsoft TFS and Rationale Quality Manager (RQM)
  • Determine data feed errors and create Jira and Service Desk tickets to engineers with corrective actions.
  • Developed various user story using JIRA tool to perform Sprint and release based on timeline.
  • Support testing of JIRA items that are reported ie.
  • logged the defect/bugs on JIRA Consulted and advised Presbyterian Health Plan Managers, regarding Go No Go sessions.

Show More

49. Waterfall

demand arrow
low Demand
Here's how Waterfall is used in Business & Data Analyst jobs:
  • Experience with Prototype development, data modeling, and both iterative/agile and waterfall systems development processes.
  • Handled projects in Agile methodology and Waterfall methodology.
  • Experience with Waterfall methodology for software development.
  • Gathered requirements using the Waterfall methodology.
  • Used Waterfall methodology and Agile SDLC methodologies like SCRUM, RUP in building users' required systems.
  • Acted as a liaison between different departments to gather and manage requirements in a Waterfall environment.
  • Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Worked on the Go To Market Business Capabilities team supporting ACT Waterfall programs.
  • Experience with both traditional Waterfall SDLC and Agile / Lean methodologies.
  • Work on both agile Scrum and Waterfall methodologies.
  • Implemented Agile and Waterfall methodologies for SDLC.
  • Experienced in both Waterfall and Agile methodology.
  • Customized upto 3 waterfall lifecycle projects into Agile methodology resulting in timely delivery of projects.

Show More

50. SQL

demand arrow
low Demand
Here's how SQL is used in Business & Data Analyst jobs:
  • Provided solution analysis, SQL/Data Modeling, and MicroStrategy development.
  • Utilized querying relational databases (T-SQL) and Microsoft SQL Server Integration Services to pull and integrate data from various sources.
  • Implemented data access, storage, and validation routines on the database server using SQL and business rules.
  • Worked with SQL Server and developed and ran SQL queries for data selection, cleansing and data mapping.
  • Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.
  • Worked on data profiling and analyze data in the database SQL Server by running SQL queries.
  • Extract the reports from database using SQL into Excel with the help of Excel Macros.
  • Audited, modified and amended data using T-SQL commands, hand-editing and bulk imports.
  • Experience in writing SQL queries, Joins, procedures using Oracle and MySQL.
  • Utilized SQL queries to access data stored in the database for analysis.
  • Generate reports using SQL Server Reporting Tool and Asset Recovery Tracking Application.
  • Created SQL*Loader scripts to load legacy data into Oracle staging tables.
  • Worked with SQL queries to extract and validate data from databases.
  • Write programs in SQL, to extract and transform data.
  • Performed numerous data pulling requests using SQL for analysis.
  • Used SQL to write and edit queries in MS Access.
  • Executed ad hoc reports with SSMS (SQL Server) and MS Access for advanced analysis of data and report generation.
  • Create analytics and reports using SQL and Excel for Sales Metrics and Customer Care metrics.
  • Write ad-hoc SQL queries as needed.
  • Functioned as Lead Developer and created the New and Changes Items tool via SQL / Data Modeling and MicroStrategy development.

Show More

52 SQL Jobs

No jobs at selected location

Business & Data Analyst Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Business & Data Analyst

Business Requirements

24.8%

Data Warehouse

18.8%

Test Cases

7.3%

Sequence Diagrams

4.6%

Visio

4.6%

User Acceptance

4.5%

Data Analysis

4.4%

UAT

3.6%

ETL

3.6%

JAD

3.0%

UML

2.8%

Windows XP

2.5%

QA

2.5%

SME

2.5%

Sharepoint

2.4%

Sdlc

1.9%

Powerpoint

1.6%

Suite

1.6%

XML

1.5%

Unix

1.5%
Show More

Typical Skill-Sets Required For A Business & Data Analyst

Rank Skill
1 Business Requirements 18.6%
2 Data Warehouse 14.1%
3 Test Cases 5.4%
4 Sequence Diagrams 3.5%
5 Visio 3.4%
6 User Acceptance 3.4%
7 Data Analysis 3.3%
8 UAT 2.7%
9 ETL 2.7%
10 JAD 2.2%
11 UML 2.1%
12 Windows XP 1.9%
13 QA 1.9%
14 SME 1.8%
15 Sharepoint 1.8%
16 Sdlc 1.4%
17 Powerpoint 1.2%
18 Suite 1.2%
19 XML 1.2%
20 Unix 1.1%
21 Informatica 1.1%
22 Pivot Tables 1.1%
23 Teradata 1.0%
24 Subject Matter 1.0%
25 Project Management 1.0%
26 BI 1.0%
27 Pl/Sql 1.0%
28 RUP 0.9%
29 Ssis 0.9%
30 Rational Requisite Pro 0.9%
31 Toad 0.9%
32 Ssrs 0.9%
33 SAS 0.9%
34 Scrum 0.9%
35 Management System 0.8%
36 Cognos 0.8%
37 Traceability Matrix 0.8%
38 VBA 0.8%
39 Data Integrity 0.8%
40 Web Application 0.8%
41 DB2 0.8%
42 Data Migration 0.8%
43 CRM 0.8%
44 Html 0.7%
45 Source Systems 0.7%
46 Clear Quest 0.7%
47 Technical Specifications 0.6%
48 Jira 0.6%
49 Waterfall 0.6%
50 SQL 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

39,348 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.