SUMMARY:

• Self motivated Business Analyst with more than 9 years of extensive experience in the field of Business Analysis, Quality Assurance, Process Modeling, Data Modeling and Master Data Management. Experience with client server and web based applications. Proficient in requirement analysis and possess an expertise in developing RUP software methodology. Extensive experience in visualizing the design of the system using UML methodology. Excellent analytical skills along with interpersonal, communication and self-organizing skills. Hands-on management experience developed and established through a variety of cross-functional businesses team assignments.
• Strong knowledge in the field of Finance Industry, Insurance Sector, Retail Banking, Investment Banking.
• Well acquainted with all phases of Software Development Life Cycle SDLC methodologies like Agile SCRUM and Waterfall.
• Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification FRS , Design Documents, Use Case Specifications, User Stories, technical documents like MRD, PRD, SRS, ERD and Story boards and Requirements Traceability Matrix RTM .
• Experienced in Master Data Management MDM , ETL processing, Data Integration, Data Warehousing and reporting on management information.
• Change Management and Impact analysis.
• Considerable knowledge in the analysis, design, and implementation of Master Data Management MDM and business processes, using established system analysis, business and system process design, research and implementation methodologies, placement of business controls, data modeling and application development, applying Unified Modeling Language UML .
• Excellent in SQL/PLSQL, Database Procedures, Triggers and Joins.
• Adept at creating and transforming business requirements into Software Requirement Specification SRS and designing business models using Business Intelligence, use case models, workflow models, analysis models, class diagrams, activity diagrams, sequence diagrams, and collaboration diagrams.
• Expertise in writing and executing SQL queries and Data Mapping.
• Solid business, communication, and presentation skills, adept at creating, editing, and coordinating extensive communication networks facilitation of Joint Application Development JAD sessions and interviews, reports, implementation requirements, project status reports, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Acted as liaison between management and development team for requirements. .
• Worked extensively with the development team in application development to ensure that all customer requirements are covered and the solution is on schedule.

Work Summary

Confidential

Sr. Business Analyst

Responsibilities:

• Worked for Version document with SME. Primary Liaison between Business User and Development Team.
• Conducted GAP analysis between current system functionalities and the planned system expectations
• Served as a resident expert of governance policies, key performance indicators KPI
• Facilitated discussions and partnership from each stakeholder in existing policies to optimize processes and maximize organizational efficiency while minimizing risk.
• Extensive experience in all phases of RUP and SDLC processes
• Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions.
• Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modeling and communicating with the technical team for development of the system.
• Represented the Data Governance and Quality Practice Office in key business Initiatives to ensure alignment and consistency within the discipline of Data Quality
• Held regular meetings with the system architects, developers, database developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand
• Deep understanding of Structured System Development Methodologies.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Evaluated Homeowners, Automobile and Umbrella policies for new and renewal business.
• Conducted User Acceptance Testing
• Assisted Project Manager and User managers to conduct Market Research and Feasibility Studies, and to develop Scope/Vision Documents.
• Requirements were gathered from the seven business functions within the Data Management organization.
• Worked on the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Used XML for building and parsing of Application Configuration file.
• Used Castor to create objects from XML documents.
• Create and maintain data model/architecture standards, including master data management MDM
• Developed information cycle diagrams, data flow diagrams, in MS Viso.
• Writing data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents. Able to update Microsoft share point portal with the updated project documentation.
• Created logical data modeling using tools like CA ERwin data modeler
• Able to analyze and Map source to target mappings using client Tool CDMA Code and Data Mapping Application to further develop enterprise data warehouse.
• Applying Master Data Management MDM concepts for data alignment, maximizing analytics and business intelligence promoting corporate objectives and initiatives
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Assisted Project Manager in development and documentation of Project Plan
• Closely worked with SMEs and Identified, researched, analyzed, and defined key issues of the Business flow.
• Collected and documented business processes as well as Business Rules and then translate to the Business Flow Chart
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Analyzed and Documented Business Requirement Document BRD , User Stories, Functional Specification Documentation, and System Requirement Documentation, using UML methodologies
• Designed and developed Use Cases using UML and Business Process Modeling.
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing.
• Developed User Manual and Provided User Training.

Environment: DB2, Oracle, JPA, EJB, JCL, COBOL, OLTP, OLAP, XML, Web Services, Informatica, IDE

ASP.NET, Visual Studio, SQL, Ms Visio, Share Point, Quality Center.

Confidential

Business Analyst / Data Analyst

• Translated business needs and end users specifications into effective and comprehensive/complete business requirements.
• Worked with waterfall and Agile methodologies of Software development Life cycle SDLC to carry out different phases of project including gathering and documenting business requirements.
• Built design requirements for large projects involving line of business, software/hardware developers and the vendors.
• Created Use-Cases, User stories and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes
• Analyzed Business needs clearly and from them documented the business requirement BRDs , Functional FSDs and technical design document
• Participated in the logical and physical design sessions, developed HLD High Level Design documents reports .
• Carried out JAD Joint application development sessions with the line of business for the clarification of the business needs or follow up, getting hold of documentation related to the problem and documented analysis and findings
• Conducted Brainstorming sessions with the team to get as much as information about the existing systems while imputing ideas and coming up with the effective solutions.
• Engaged in Exporting/Importing Data between different data sources.
• Gained Knowledge of ETL Extract, Transform, Load suite while working on Data Mapping
• Performed extensive requirement analysis including data analysis by running look up and gap analysis
• Communicated findings and Status of the project on a regular basis to all levels of management.
• Managed workload of junior business analysts on the team, and monitored milestones and critical dates to identify potential jeopardy of schedule and identified/mitigated risk.
• Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in the process.
• Worked with developers for ETL and Data Warehouse development.
• Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
• Lead the testing initiative - develop test strategy and test plan, conduct integration testing and Facilitated User Acceptance Testing UAT and in developing content and training materials for the stakeholders and the business users.
• Conducted Error Analysis, by doing experiments and making measurements, drawing meaningful conclusions.
• Extensive experience in Gap Analysis of the As-Is and Should-Be process within the organization for implementation of RUP.
• Worked as part of Access management to provision the new systems applications access to the new hires on-boarded.
• Coordinated with line of Business, PMO team and systems access issues resolution team while provisioning systems access to the new hires.
• Gained knowledge of XML and Beyond compare while working on and comparing loans side by side.
• Project management update and controlling to ensure on time delivery

Environment: DB2, ERWIN, JPA, EJB, JCL, COBOL, OLTP, OLAP, XML, Informatica, IDE, Java, J2EE, JIRA

Cristal Reports, SQL, Ms Visio.