We provide IT Staff Augmentation Services!

Business Systems Analyst/data Analyst Resume

Wellesley, MA

SUMMARY:

  • Over all 7+ years of experience as a Business Systems Analyst in business process modeling, business analysis, business requirement gathering in all phases of software development life cycle methodologies with well - balanced understanding of business relationships.
  • Has comprehensive knowledge of traditional Software Development Life Cycle (SDLC) methodology as well as more recent ones such as Agile .
  • Worked for leading financial and banking clients.
  • Facilitated Joint Application Development (JAD) sessions with Subject Matter Experts (SMEs), UAT, Business User Groups, Top Management Groups and Technical Groups.
  • Demonstrated good communication skills with project steering committee and senior project management to resource the tasks of the project.
  • Demonstrated strong communication skills with internal and external stakeholders, third party vendors (including SIT/UAT), technical and business teams.
  • Lead/Managed several Mainframe enhancement/development projects of varying complexities and implemented them successfully.
  • Expertise in performing structured requirement analysis, Effort estimation (FP & CP), analytical and data analysis, Feasibility Analysis, Risk Analysis, Functional Reviews, Impact Analysis, Design, Test, Implementation, support & process assessments.
  • Experienced in developing project schedule and resource estimates.
  • Strong decision making abilities.

TECHNICAL SKILLS:

Operating Systems: HP-UX, Linux, Windows 95/98/XP/NT, Novell(Micro Focus) Netware, MS-DOS and Sun SolarisReporting: Oracle OBIEE, SAP Business Objects Enterprise Infoview, IBM Cognos, SSRS

ETL Tools: Informatica, Data Migrator, SSIS, Data Stage

Databases: MS SQL Server 2008/2012, IBM DB2, Oracle MySQL, Toad for SQL Server.

Testing Tools: JIRA, PVCS Tracker, HP Quality Center, IBM Clear Quest, BugZero, Beyond Compare

UI Tools: MS Visio, SnagIT and Axure RP

Dashboard: LogiXML, MS Dynamics CRM Dashboard, Key Indicators

Requirements &Project Management Tools: Rational Requisite, JIRA, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Wellesley, MA

Business Systems Analyst/Data Analyst

Responsibilities:

  • Created Impact Analysis documents for all Individual Life and Annuities systems as part of Delaware Deactivation project
  • Built Data requirements document and Data Load Specification documents for adding new fields for New Underwriting application
  • Worked with International Life and Wealth business to add new data to MS Access database and feed down the data into Consolidated Sales database
  • Worked closely with AML/FCRM Compliance technical team to remove all the source systems which no longer require a screening
  • Designed GAP analysis documents for comparing New Individual Life Underwriting data model to existing physical model.
  • Closely work with AML (Anti-Money Laundering)/Compliance team to ensure daily data load is successful for all the systems that are obliged to report
  • Designed the new source system ‘Kane’ on-boarding platform to identify and create functional/Extract documents for AML
  • Designed detailed implementation plans for release for Change tickets, tasks list, systems impacted and contact info
  • Prepared Data Flow Diagrams and Use case models using MS-Visio.
  • Managed requirement changes requests and implemented procedures for test changes.
  • Created master test plan and test cases and coordinated with users for the new system testing.
  • Worked with QA team during the automated testing and preparation of testing reports using HP Quality Center.
  • Held project level testing status meeting to review new defects and status of open defects.

Environment: MS PROJECT, AGILE, PL/SQL, OOAD, MS OFFICE, WINDOWS XP

Confidential, Charlotte NC

Business Analyst

Responsibilities:

  • Providing assessment and solution strategy for Commercial payments processes for SWIFT ISO standards by customizing best industry practices to individual bank’s requirement.
  • Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
  • Extensive experience in developing Use Cases, Creating Screen Mockups, Conducting Gap Analysis and Impact Analysis, Risk Analysis.
  • Performed as-is assessment with a structured approach to determine gaps in existing system (internal + external channels) to enable it for multiple user capabilities.
  • Worked on Automated Clearing House (ACH) network, for processing large volumes of Credit transfer as well as direct debit transactions, for Clearing and settlement of High Value and Low Value payments for SWIFT message standards.
  • Organized JAD sessions with clients, SMEs, Scrum Masters, Product owners, architects and stake holders to better understand the requirements and handle road block situations.
  • Worked on single message as well as bulk file payment generation for Electronic funds transfer (EFT) as well as Wire Transfer and SWIFT processing.
  • Process & Generate different types of payments i.e. MT & MX (PAIN & PACS) formats for SWIFT messages.
  • Analyze the Payments traverse across all the middleware services, External Channels and integrating with end system. Validate the payments in middle ware applications during routing till it reaches the end system successfully to follow process as per Software Development Life Cycle (SDLC).
  • Part of Functional execution of different modules like Message Validations, Enrichment, Posting, Sanction, Accounting, Method Of Payment derivation, Charge computation, Charge collection, Service Cost computation and collection from customers and multiple other modules.

Environment: MS PROJECT, AGILE, PL/SQL, OOAD, MS OFFICE, WINDOWS XP

Confidential, Cleveland OH

Business Analyst

Responsibilities:

  • Created use case diagrams, flowcharts and process models, by documenting business work flows both by text and by activity diagrams.
  • Interacting with Business team on daily basis to understand the Client business needs and basic requirements of customer, and henceforth put the use cases in to Business Functional Document.
  • Developing functional specifications for business process refinement, data modeling, system Architecture and conducting feasibility study.
  • Creating Business process diagrams of existing systems, the underlying data and use cases associated with those systems, the problems and limitations associated with both, and the available methods of resolving the identified business issues
  • Co-ordinated with development and business team for successful rollout of the project.
  • Have good understanding of Testing, SDLC concepts and have very good testing experience with knowledge of various steps involved in end to end testing of applications.
  • Handled Cost and price computation for the services being rendered to the customers and collect the service charge for Payments processed using SWIFT protocol.
  • Perform Product Testing as well as Integrated Product testing of the REST & JMS services, being developed for Client business needs.
  • Developed questionnaires and organized meetings, emphasizing the scope of the project, to provide key initiatives in working with users in defining project and system requirements.
  • Had worked on SOAPUI Tool for testing & defect tracking process using Quality Center (QC).

Environment: MS PROJECT, AGILE, PL/SQL, OOAD, MS OFFICE, WINDOWS XP

Confidential

Business Analyst

Responsibilities:

  • Defined project scope, goals, and deliverables to build websites
  • Joined client meetings to learn about development of project scopes, including reviewing business priorities, analyzing options, and risks and costs
  • Developed complete implementation/project plans to develop websites and associated communications documents.
  • Gathered Business-User requirements, understanding the requirements in discussion with stake holders and product managers
  • Developed and delivered progress reports, proposals, requirements documentation, and presentations with stakeholders, Developers and Managers.
  • Participated in Code reviews and Quality Assurance
  • Joined client meetings to learn about development of project scopes, including reviewing business priorities, analyzing options, and risks and costs
  • Conducted UAT Testing
  • Continually managed project expectations with team members.
  • Ensured to meet all project timelines and deadlines.
  • Joined client meetings to learn about development of project scopes, including reviewing business priorities, analyzing options, and risks and costs
  • Prepared site update reports for submission to management on a regular basis

Environment: MS PROJECT, AGILE, PL/SQL, OOAD, MS OFFICE, WINDOWS XP

Confidential

Data/Business Solution Specialist

Responsibilities:

  • Developed Tableau visualizations and dashboards using Tableau Desktop
  • Wrote custom SQL queries to pull the required data in to Tableau
  • Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions
  • Created pivot tables and modify spreadsheets to achieve analytical goals, also created pivot tables and charts using worksheet data and external resources, modifying pivot tables, sorting items and group data, and refreshing and formatted pivot tables
  • Created Business Requirement documents (BRD) and Functional Requirement documents, while maintaining the Requirement Traceability Matrix (RTM) related document
  • Conducted UAT testing with the cross-functional business teams to ensure the system was aligned with the vision of the business team
  • Created Unit Test Cases and documented the Unit Test results
  • Assigned pass or fail status, while managing UAT testing results
  • Created and tested user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories
  • Documented, coached, and elicited business requirements from subject matter experts by writing user stories resulting in a clearer, more detailed and more complete understanding of project deliverables
  • Created product backlogs, Sprint backlogs and managed user stories
  • Gathered requirements for business definitions, while facilitating JAD/JAR sessions with stakeholders to refine functional requirement
  • Responsible for documenting workflows and results of Business Analysis into Business Requirement Document (BRD), while obtaining sign-off from the client on specifications
  • Coordinated with business clients to analyze business requirements while recommending and designing technological improvements to business processes and operational procedures
  • Determined the content of status reports from the team, analyzed results, and trouble shooted problem areas.
  • Developed best practices for project execution and management.
  • Assisted team in performing data compiling, mining and analysis required to evaluate the given data

Environment: MS PROJECT, AGILE, PL/SQL, OOAD, MS OFFICE, WINDOWS XP

Hire Now