We provide IT Staff Augmentation Services!

Business Data Analyst Resume

Charlotte, NC


Methodologies: Agile, Scrum, Waterfall, RUP

Web Application Platform: SharePoint, ADDM, Enterprise Server Technologies, ADDM, BMC Remedy, Adobe Connect, Avaya Conference, Lync

Requirement Tool: Rational Requisite pro

Project Management Tools: MS Project, MS Word, MS Excel, PowerPoint, MS Outlook, MS Visio, Photoshop, MS Office Calendar, MS One Note, Snagit

QA Tools: IBM OPTIM, Business Objects

Database: Oracle, Teradata, SQL Server, Citrix, Mainframe, Windows Server.


Confidential, Charlotte, NC

Business Data Analyst


  • Enterprise wide effort for upgrading the Teradata environment from v13.10 to v14.10 and relocating to the new Data Center.
  • Co - ordinate enterprise wide communications to ensure all applications connecting to Teradata along with both Adhoc and Non-Adhoc users comply with the upgrade and move.
  • Impact analysis to ensure jobs, batch IDs, and legacy aliases are identified.
  • Managed extensive migration from a critical trading floor application (Brass) to a more product user-friendly OMS (Royal Blue Fidessa).
  • Assist app teams with upgrade, IP change to DNS, firewall issues.
  • Schedule pre-migration and post-migration application testing during the outage windows to ensure that application servers are able to connect to the new environment.
  • Shrink the data and file systems storage at a Data Center location, thereby bringing down the cost billed for the storage array.
  • Consolidating multiple arrays into a single array, purging or archiving source data into Optim, reviewing backup and retention cycles across mainframe, DB2, midrange databases and virtual tape libraries.
  • Managed the effort across a team of BAs working on respective applications that owned the data and file systems.


Data Analyst


  • Post merger sun setting of retiring applications after analysis and resolution of dependencies. Process mapping, data retention and archival, reporting, application and infrastructure decommission.
  • Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
  • Created application assessments, infrastructure profiling and Business Requirement documents.
  • Defined business processes, conducted gap analysis, feasibility analysis, and cost-benefit analysis, identified risks and managed the risk acceptance and mitigation process.
  • Created design specifications and mockups based on production issues or bugs that are found by our users on the trading floor.
  • Used SAS/BASE, Macros to develop dynamic SAS programs to extract, validate data for Statistical analysis.
  • Extract raw data from Oracle and loaded the data into SAS datasets Used Macro routines to convert different types of source file (Excel, Word, and Text) to produce SAS reports and graphs.
  • Created UML Diagrams such as Use Case Diagrams, Process Flows (Business and System), Activity Diagrams, Class Diagrams, Sequence Diagrams, Collaboration Diagrams, and Data Flow Diagrams.
  • Authored Technical Specification Design encompassing the application overview, dependencies and resolution plans for the same, database specifications for archival and purging, server optimization/decommission plan, infrastructure components, Storage, backup and Disaster Recovery details, feeds and services, source code and application monitoring.
  • Used my web service expertise in testing web services via SOAP, using the open source testing tool Soap UI
  • Collaborated with the QA team to ensure adequate testing of software, maintained quality procedures, and ensured that appropriate documentation is in place.
  • Analysis of dependencies, data flow, ETLs between Application database (Oracle) and Enterprise Data warehouse (Teradata). Identification and analysis of objects and underlying tables, facilitating the Solution Design for data archival from the data warehouse.
  • Actively monitored critical Data Center infrastructure status, including OOB, networking, HVAC and power infrastructure, responding to outages and degraded service.
  • Supported User Acceptance Testing (UAT) for business clients & production implementations
  • (Successfully worked with Infrastructure/Engineering teams to upgrade the UAT servers)
  • Authored Report Specification Design - Business Objects reporting and access to archived data via query tools.
  • Training and Support for IBM Rational ClearCase, UCM & ClearQuest users.
  • Defined source to target data mappings and translation rules, facilitated SQL queries and creation of views to extract data from databases, verified the XMLs to identify correct data elements are read and retrieved from the databases for generating reports as per the format specified by the SMEs.
  • Authored UAT and other test case documents facilitated UAT with business and application users, conducted QA testing.
  • • Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
  • Created summary report outlining activities completed and cost savings achieved from application retirement.
  • Co-ordinate data center moves with Infrastructure Management, Enterprise Application Management and execution teams.
  • Provided inputs for overall implementation plan, lead deployment of applications/infrastructure and post-production support activities.
  • Conducted UAT training and demos (Business Objects reports and query tools) for BA team and Senior Management representing Business Owners and Business Alignment teams.

Confidential, Northbrook, IL

Sr. Business Analyst


  • Formulated and defined systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements following RUP.
  • Created QA procedures and processes for the team to follow.
  • Performing requirement gathering & analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
  • Collaborating with Subject Matter Experts (SME), project team members (business and technical), to define technology application for the business and system requirements.
  • Identifying opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
  • Developing the project plan with assistance from the management, and included provisions for project scope changes and issues and initiated efforts to make improvements.
  • Involving in creating Business Flow Diagrams, Dataflow diagrams, UML Activity diagrams and use-cases diagrams using MS VISIO.
  • Assisting the technical team in translating application functionality into application architecture.
  • Participating in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.
  • Clarifying QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
  • Organizing meetings to discuss outstanding issues with QA and developers
  • To focus on the people side of change - including changes to business processes, systems and technology, job roles and organization structures.
  • The primary responsibility is creating and implementing change management strategies and plans that maximize employee adoption and usage and minimize resistance.
  • Work to drive faster adoption, higher ultimate utilization and greater proficiency of the changes that impact employees in the organization to increase benefit realization, value creation, and the achievement of results and outcomes.

Confidential, Jacksonville, FL

Business System Analyst


  • Good experience on INFORMATICA Power Center's Metadata Manager for generating DATA LINEAGE
  • Identify, install and configure pre-built plugins in the new website for improving old and creating new functionalities.
  • Worked closely with fixed income research, trading floor and Equity research analysts to help integrate various financial models on MS Excel into the FIDEQ tool.
  • Designed and developed Business objects in C# that were utilized by various services for data access.
  • Worked on Web-services applications, using SOAP UI tool, to create a Web Service Test from SOAP request and validate the response against the database.
  • Improve viewership of web pages by optimizing pages for search engine and analyzed site usage data using Google Analytics.
  • Created custom controllers implementing complex code for retrieval from Salesforce to Visual Force pages.
  • Reviewed and analyzed test cases for multiple investment and banking software platforms covering various asset classes including fixed income, FX, and derivatives
  • Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
  • Gathered and documented business requirements by conducting sessions with clients/users with all lines of businesses like Investment Bank, Private Bank, Commercial Bank, Treasury and Securities.
  • Conduct payment investigations for returned check and electronic payments
  • Utilized corporation developed Agile SDLC methodology. Used Microsoft Office software to perform required job functions.
  • Analyzed the effects of Corporate Action and Assets under Custody on the value of stocks in order to define requirements for the Online TradingModule.
  • Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
  • • Ensure SOAP XML Messages are transmitted correctly from the sender to the receiver end points and the data loaded to the database as mentioned in the source to target mapping document.
  • Responsible for identifying and analyzing various Wires and ACH payment initiation channels that send payment transactions to the Payment processing systems such as ACI Money Transfer System and PEP+. The analysis included all Outbound and Inbound payment flows for Domestic and International payments
  • Supervised all pertinent project management processes: Business processes, User Acceptance Test, Test scripts, Test results, End user training, oversaw documentation.
  • To understand the Retirement Services features to be provided to customers, conducted market surveys with existing customers and documented it for prototypes to depict the same.
  • Liaison between customer and business as usual team, Project Requests, SOW, business & work flow Analysis, Design, Resource Allocation, Executed project Plan.
  • Developed Test cases for the data warehouse in Oracle System.
  • Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality center across multiple teams.
  • Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams.
  • Created various reports to better utilize Salesforce and configure various reports for different user profiles based on the need in the organization.
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Design, quality, SQL and PL/SQL review, making specific recommendations to enhance the performance of PL/SQL packages.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Other areas include enhancements in Portfolio; Account setup, Enterprise Content management, E-delivery and prepared Quick reference guide for CPB clients.
  • Worked in mainframe environment and used SQL to query various reporting databases.
  • Developed Business Process Flow and Business Requirement Document with Visio and Word.

Confidential, Montgomery, AL

Business System Analyst


  • Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
  • Serve as Property & Casualty Insurance SME, reporting to the President, addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACCORD xml standards.
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
  • Gathered requirements and modeled the data warehouse and the underlying transactional database
  • Involved in all stages of testing the Auto & Home Insurance application.
  • Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
  • Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
  • Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
  • Developed expertise with ACORD standard Life, Annuity & Health data model and data collection requirements, form models and archival stipulations.
  • Developed project plans and managed project scope.
  • Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
  • Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
  • Conducted UAT; facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria; documented and reported user feedbacks to management team.
  • UAT testing performed along with call center managers to make sure that application meets their requirements.
  • Responsible for assisting clients in resolving various network and systems management problems using ITIL.
  • Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
  • Performed extensive Requirement analysis and developed use cases and workflows.
  • Provided key input in working with users in defining project and system requirements.
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors.

Hire Now