We provide IT Staff Augmentation Services!

Sr. Business Data Analyst Resume

St Louis, MO

SUMMARY:

  • Over 8 years of experience in Business Data Analysis in telecommunication and financial domain with experience in RDBMS & Data warehousing, experience in design, development, implementation and support of enterprise data warehouse.
  • Actively used various requirements gathering techniques like Joint Application Development (JAD) and One - on-one interviews, Facilitated sessions, Questionnaires and Prototyping with Business users and Stake holders to collect accurate requirements to identify the real business need and facilitate the development of a customized solution which delivers maximum cost and usability benefit to the client and company.
  • Full SDLC experience and experience with projects and Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) and Agile Methodology.
  • Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe prototypes and document them using Microsoft Visio.
  • Hands on experience in creating SQL Queries, Stored Procedures, Triggers, Views, Indexes in SQL Server with a strong understanding of data & analytics.
  • Worked efficiently on multiple projects spanning over different releases at the same time.
  • Experienced in performing Business Process Reengineering/Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Strong understanding of Risk Management (credit, operational, market & legal risk), Asset Management, Brokerage and Equity analysis.
  • Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
  • Proficient in Microsoft BI Tools and Tableau to generate reports and dashboards.
  • Successfully implemented module as part of data warehouse solution for the Mutual funds sales reporting.
  • Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD.
  • Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems.
  • To gather requirements used techniques such as interviews, surveys, workshops and JAD sessions with Business teams and IT development.
  • Effective in multitasking and effective management of assignments according to work schedules with strong project management orientation.
  • Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment.
  • Created Requirement-Requirement and Requirement-Test Traceability Matrix (RTM) in HP Quality Center.
  • Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
  • Expert in MS Office Products such as Word, Excel, Project, Power Point, Access, Visio.
  • Conducted various JAD sessions with business users and separately with development, QA teams.

TECHNICAL SKILLS:

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio.

Reqmts. Management Tools: Rational Requisite Pro, Telelogic DOORS

Change Management Tools: Rational Clear Case, Rational Clear Quest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, JAD, RUP, RAD

Testing Tools: Load runner, Test Director, Mercury Quality Centre

Operating Systems: MS Windows Vista/XP/7/8.1,UNIX/LINUX

Languages: SQL, UML, JAVADatabase: Oracle, SQL Server 2000, MS Access

Utility MS Office Suite: Word, Project, Excel, Visio, PowerPoint, Adobe, Visio

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Sr. Business Data Analyst

Responsibilities:

  • Responsible for requirement gathering by conducting personal interviews, developing questionnaire, or role playing to get a better understanding of client business processes and creating requirements traceability matrix for tracking the requirements.
  • Define technical goals and business processes for the ecommerce platform.
  • Conceptualize and define an banking platform that is highly available, highly scalable, with low maintainability and high performance, built using reusable components and optimized
  • Streamline operations and optimize resources for banking platform.
  • Advised Business Units accordingly if certain requirements could not be catered by the new system. To find solutions and workaround.
  • Developed business requirements document (BRD), User stories, User requirements and functional requirements.
  • Requirements management using various techniques like JAD Sessions, document analysis, and prototypes.
  • Used data analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW).
  • Working closely with business stakeholders in understanding their full lifecycles for merchandising, marketing, and email campaigns
  • Communicate with design; development and test team using MS exchange Messaging and Defect Tracking System.
  • Facilitated the design process to plan intuitive workflows, created detailed GUI wireframes and mockups and designed process models, specifications, diagrams, and charts to provide direction to developers.
  • Generate Business Analysis artifacts such as detailed functional requirements, business process flows and Use Cases.
  • Created and maintained Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques.
  • Performed Process Optimization by using Business Process Modeling tools.
  • Worked with subject matter experts (SMEs) internally and externally, and participated with software developers in Scrum team meetings, documenting agile software processes.
  • Worked on Views and Dashboards in Tableau, Managed custom views such as Bar Chart and Table views. Managed dashboards with Views and Tables.
  • Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
  • Integrated an external credit score carding system into internal risk management system by identifying management requirements and implementing automatic information upload.
  • Involved in preparing the change request form, mitigation and risk assessment plan to handle changing requirements.
  • Worked closely with the PMO (Project Management Office) group in defining timelines & schedules for the project. Solid experience with Data Warehouse development and technologies.
  • Used various SSIS tasks such as conditional split, derived column before loading the data into the data warehouse.
  • Deliver requirements under the Agile Scrum SDLC methodology to meet a very fast release schedule.
  • Implemented Data Representation using Visualization Techniques in Tableau using Alteryx (Graphs, Charts etc.).
  • Interacting with other teams through walk-through, teleconferences, meetings, etc. to resolve various issues.
  • Conducting requirement gathering sessions, feasibility studies and Impact Analysis and organizing the software requirements in a structured way using Rational RequisitePro to track development.
  • Work with Compliance and Regulatory operations to follow and monitor different IT process bound by CMS Regulations.
  • Used MS power point presentations for conduction JAD sessions with the stakeholders.
  • Created Artifacts and defined Milestones and iteration plans for Inception and Elaboration phases of SDLC.
  • Managed the milestones and make sure of their completion within the established timeline.

Environment: MS Office, MS Visio, MS Outlook, Agile/Scrum, Visual Basic, HTML, MS Project, Web Services, Java, Excel, IBM Rational Rose, SQL, Business Intelligence (BI)- Tableau, OBIEE, IBM Requisite Pro, IBM Websphere Commerce, Microsoft Exchange, etc.

Confidential - Dallas, TX

Data warehouse/ Business Data Analyst

Responsibilities:

  • Involved in the complete SDLC- (System Development Life Cycle) from Requirement gathering to actual delivery of the Extracts which include all the loan origination and servicing data across.
  • Responsible for conceptualizing end to end DWBI based solutions based on customer needs.
  • Responsible for establishing new procedures, Service Level Agreements (SLA's) for the Third Party vendor.
  • Involved in the upgrade of Data warehousing and business intelligence (DWBI) tools.
  • Used the SQL to migrate all data to one database before uploading it into the Knowledge Base.
  • Interacted with Business users and vendors to design a new SOA-based system that would cater to an ever-increasing market need for interchangeable service modules.
  • Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
  • Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category.
  • Worked closely with a project team for gathering business requirements and interacted with business users to translate business requirements into technical specifications.
  • Analysed data using SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
  • Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
  • Involved in gathering requirements for creating web services supporting the SOA effort.
  • Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
  • Worked with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues.
  • Involved in creating logical and physical model of the database using MS Visio, MS SQL Server.
  • Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
  • Strong hands on experience using Teradata utilities and scripting.
  • Created Stories in Tableau containing various worksheets and Dashboards.
  • Interacted with fixed income business heads to finalize the Business Requirements for the Risk Management process.
  • Executed SQL queries against the Sybase and Oracle databases for data quality analysis.
  • Scheduled meetings with developers, System Analysts and testers for the preparation of UAT and make the test material ready keeping in mind, the scope of the project.
  • Worked with web services integration and worked on exporting data using Teradata.
  • Required data was exported to an excel sheet which was then provided to the Business Intelligence team for their analysis purposes.
  • Proficient in data extraction, transformation and visualization tasks using SQL and Tableau desktop
  • Collaborated with Quality Assurance Analyst in Automated and manual testing for other phase of the project.

Environment : MS Office, MS Visio, MS Outlook, Visual Basic, Agile, HTML, MS Project, Web Services, Java, Excel, Macros, Teradata, Data warehouse, IBM Rational Rose, Oracle 12g, SQL, Tableau, OBIEE, IBM Requisite Pro, IBM Websphere Commerce etc.

Confidential, Minneapolis, MN

Business/ Data Analyst

Responsibilities:

  • Writing the detailed user needs, Gathered business, functional requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using UML and Rational tools.
  • Carried out queries from customer data base using SQL.
  • Worked extensively with the users and with different levels of management to identify requirements, use cases and to develop functional specifications
  • Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
  • Reviewed functional specifications prepared by vendors, ensured all the new enhancement requirement is captured in functional specification.
  • Gathered requirements and modeled the data warehouse and the underlying transactional database.
  • Understanding the store procedure and backend packets structure to determine the input / output structure for the web services.
  • Performed AML/CFT regulatory compliance controls over customers’ transactions.
  • Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
  • Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
  • Experience in performance analysis, Teradata SQL optimization, detailed design, and application support, tuning and optimizing bad queries and handling database maintenance.
  • Created Documentation - Analysis reporting, architectural presentations, infrastructure specifications, strategy planning, risk analysis, contingency plans for company executives.
  • Used Agile Development methodology throughout Project Life Cycle
  • Performed Business Process Modeling using Visio. Performed customer data analysis.
  • Used different in house software to track data flow, system interactions, system defects, service requests and responses.

Environment: Microsoft Project, .Net, MS Visio, Data warehouse, Teradata, MS Office, MS Exchange, Clarity, Microsoft Project, PL/SQL, UML and Data Stage.

Confidential, PA

Business Analyst

Responsibilities:

  • Met with client groups to determine user requirements and goals at requirement elicitation stage using water fall methodology. Utilized Agile Methodology to configure and develop process, standards, and procedures
  • Conducted Surveys and Brainstorming sessions with SMEs for requirement gathering.
  • Gained experience on Credit card processing transactions, including order verification and chargeback processing on Automated Clearing House (ACH).
  • Communicated with customers and credit card companies during the verification and validation process in a professional and sensitive manner
  • Extensively used Rational Requisite Pro for reviewing and analyzing the requirements.
  • Performed Gap Analysis of the As-Is and Should-Be process within the organization for implementation of RUP.
  • Performed Data Mapping of the entire module and performed complete analysis to integrate Risk Analyzer with the online processing tool.
  • Expertise in Performance Management and Financial analysis.
  • Used guidelines and artifacts of RUP to strategize the Implementation of the Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle (SDLC).
  • Exported/ Imported data to and from Excel spread sheets and Access.
  • Documented project processes and procedures and version controlled them using Rational ClearCase.
  • Responsible for integration and of data warehouse and reporting with other systems.
  • Created Artifacts and defined Milestones and iteration plans for Inception and Elaboration phases of SDLC.

Environment: MS SQL Server, MS-Access, RUP, XML, Six Sigma, CMM, Rational Enterprise Suite

Hire Now