Data Architect Business Analyst

Lavanya

Business Analyst

Email: ********.******@*****.***

Mobile: +1-901-***-****

PROFESSIONAL SUMMARY:

Over 9+ years of all-encompassing experience as a Business Analyst and maintaining a frontline leadership role in all the phases of System Development Life Cycle (SDLC).

Strong experience in coordinating Joint Application Development (JAD) sessions and interviews to converge towards a design acceptable to the customer and feasible for the developers.

Proficient in developing project developing plans, tracking progress, managing budgets and analysing workloads.

Effective in working with business stakeholders, VP's, MD's, Support Managers both off-site and on-site, Senior Project Managers, Project Managers and Solution Architects.

Proficient in creating business Requirement Documents (BRD), Functional Requirement Specification (FRS) documents, User Requirement Specifications (URS) documents, Use Case Diagrams, Activity Diagrams and Sequence diagrams using MS Visio and Rational Rose.

Excellent Analytical skills to understand the business process and Functionality, Requirements and translate them to System Requirement Specification documents.

Expert in Software Development Life Cycle processes including Waterfall, Agile and Extreme programming.

Excellent wire frame designing skill for the development of user-friendly User Interface Design.

Exceptional communication skills, result oriented professional who combines formal education with experience gained from research and professional opportunities.

Analytical, methodical and resourceful approach to problem solving, identifying root causes and providing corrective actions to meet short and long-term business, financial and system requirements.

Excellent knowledge of ETL cycle for extracting information from the source, transforming it in to the useful data according to operational needs and loading it in to the data warehouse or database.

Experience with Business Analysis documentation techniques for workflow, data design and GUI screen design.

Adept in performing Gap Analysis, Feasibility Analysis and SWOT Analysis to check the compatibility of the existing system infrastructure with new business requirements.

Strong knowledge of writing SQL queries as well as creates, update and modify database table.

TECHNICAL SKILLS:

UML, RUP, Waterfall, Agile, Extreme Programming, Sequence diagrams, Object collaboration diagram, Class diagram, Activity diagram, Requirements Gathering, Business Definition Requirements, Business Processes Research, Analysis, documentation, Use Cases, JAD Sessions, Mainframes, Rational Requisite Pro, SQL, ERWIN, MS Word, MS Excel, MS Visio, MS PowerPoint, .Net, Win runner, Load runner, MS Office Suite, MS Project, Rational Clear Case.

EDUCATION:

Masters – MCA (computer applications) from Osmania University

Bachelor – BCA (computer applications) from Osmania University

PROFESSIONAL EXPERIENCE:

Disney/LTI Oct 2021 – Till Date

Sr. Business Analyst

Responsibilities:

Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Erwin.

Re-engineered processes for the Accounts Receivable and Accounts Payable groups.

Provided key initiatives in working with users in defining project and system requirements.

Was involved in General Ledger revaluation and translation automation.

Conducted JAD sessions with Financial Representatives, Managers of Annuity division to elicit requirements both through face-to-face interactions and through virtual team (web-conference) environment identifying business needs and documenting precise Business Requirement Document (BRD).

Functioned as the primary liaison between the business line, operations and the technical areas throughout the project cycle.

Prepared Work Flow Diagrams and Use Cases of As-Is business processes and the To-be processes for the Annuity division, while performing gap analysis between the two Gathered high-level requirement for all the external projects in a release.

Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.

Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.

Designed and developed use cases, activity diagrams and sequence diagrams using UML.

Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.

Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.

Developed test plans with QA team and helped to develop test cases for system testing, integration testing and performance testing.

Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.

Analysis of business requirements and system requirements of the client and also for Property and casualty modules.

Environment: Windows XP/2000, MS-SQL Server, MS Office Suite, Visual Studio, MS-Project, RUP.

Accenture, India May 2010 – April 2015

Business System Analyst/Data Analyst

Responsibilities:

Identified, designed and drove business processes and system improvements that will enhance business performance.

Lead business analyst for the corporate and commercial banking migration of Siebel from HI to Open UI platform.

Participated in the testing of the UAT environment setup and deployment process.

Mentored junior business analysts on functional, regression and User acceptance testing.

Created functional acceptance test design specifications and test case specification for the UAT team.

Recorded defects and ensured accuracy of user raised defects in the UAT environment.

Used Cognos query studio for creating custom and adhoc reports.

Performed Gap analysis for migration to the Marklogic reference portfolio project.

Elicited requirements from users through user stories, incorporated these user stories as requirements in the Sprint Backlog and further expanded them into tasks for each sprint.

Worked closely with the product owner to prioritize the user requirements during and after each sprint

Provided the detailed inputs to the Scrum Master about the tasks completed and assisted in the creation of the Sprint BurnDown Chart

Used various SQL commands such as create, delete, update, left joins, right joins and full joins to update the database and retrieve data for analysis

Designed and developed use cases, activity diagrams, collaboration diagrams and sequence diagrams, using MS Visio

Utilized strong curiosity to understand as-is processes and created vision for future highly efficient and effective processes.

Translated conceptual user requirements into functional requirements in a clear manner that is comprehensible to data architect/project team.

Lead Business analysis activities for the corporate and commercial banking migration of Siebel from HI to Open UI platform.

Created process models, specifications, use-cases, diagrams, and charts to provide direction to data architect and/or the project team.

Created, retrieved, updated and deleted data using MySQL5 queries.

Managed and tracked the status of requirements throughout the project lifecycle, and enforced proper change request management procedures, redefining as necessary, to ensure proper scope control.

Create business process and application flow diagrams supporting business and technical requirements, interpreted business rules and requirements for the team.

Created wireframes and mockup screens depicting the future state of the system

Executed project management office/program management office (PMO) functional tasks including preparing meeting agenda, organizing/conducting meetings, creating meeting minutes and following up with workstream leads.

Determined frequency and content of status reports from the project team, analyzed results, and troubleshot problem areas

Worked with IT management to develop business cases for new projects.

Created Test strategy document, test cases and test scripts for multiple projects, followed by lessons learned document.

Environment: MS Office, Visio, My SQL 5, MS Project, Quality Center, Waterfall,

Contact this candidate