SUMMARY

• Experience in Business Analysis, Requirements gathering, Software Design, Testing, Product Configuration and Project Co-ordination with the ability to understand and analyze complex Business Requirements by interacting with business users, assessing their business and information system needs, and designing solutions for complex information systems management.
• Efficient in detailing, validating, and creating Business and Technical Project Documentation in a format that is useful to the business area experts and the technical developers.
• Experienced in co-ordinating resources, prioritizing group activities, establishing schedules to ensure that plans are consistent with overall company objectives.
• Expertise in Post production and Support which includes Training to the end users and preparation of Training Material, End User Manual and Business Process Procedures BPP .
• Experienced in creating Business Requirement Documents BRD , System Requirement Specifications SRS , and Functional Requirement Specifications FRS .
• Expertise in creating High Level Design Documents HLD , Data Flow Diagrams DFD , Class Diagrams, UML Diagrams including Use Cases, Sequence, and Activity Diagrams, Entity Relationship Diagrams, Data Mapping, Logical Data Modeling, Data Integration. Used SQL queries to filter data.
• Practical knowledge of all phases of Software Development Life Cycle SDLC processes and worked on SDLC Methodologies like Waterfall, Spiral, ASAP, Agile, and Rational Unified Process RUP .
• Expertise in designing Business Process Modeling BPM .
• Experience in analyzing, designing, and enhancing E-commerce related application.
• Expertise in Object Oriented Analysis and Design Methodology OOAD .
• Experience in developing multi-tier, scalable, web-enabled business applications and implementation of software applications across operating platforms.
• Good working knowledge of Extraction, Transform and Loading ETL .
• Experience in conducting Joint Application Development JAD sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Experience in designing Master Data Management MDM , CRUD and Business Processes required to run, improve, and transform the business.
• Involved in the testing phase right from the Unit Testing to the User Acceptance Testing UAT . Performed Functional Testing, Regression Testing. Experienced in developing and maintaining overall testing methodology and strategy, documenting Test plans, creating Test cases and executing Test Scripts based on baseline requirements.
• Expert in Manual Testing and well versed with various test management tools like Mercury Quality Center.
• Experience in Version Control System like Microsoft Visual Source Safe, PVCS.
• Proficient in Microsoft Office skills including Word, Excel, PowerPoint, Access, MS Project and MS Visio.
• Efficient in Share Point Server for managing documentation for the project.
• Expertise in all Rational tools including Rational Rose, Rational Clear Quest, Rational RequisitePro, Rational Clear Case.
• Experience in Defect tracking and reporting system.
• Good communication and presentation skills, self-starter, team player and quick learner with strong analytical and problem-solving skills.

Technical Skills:

Professional Experience:

Confidential

Business Systems Analyst

Responsibilities:

• Identify, Analyze, and determine the business requirement for designing the E-Commerce application
• Develop requirement and functional documents including BRD, FRD, High Level Design document
• Design various diagrams describing the business process model BPM , workflow, user stories and use case diagram, target technology environment diagram
• Testing the feature and functionality of the application
• Analyzing UAT specification
• Interacting with technical team to clarify any queries related to the requirement analysis and application design approach
• Research and analyze the rail car industry related facts, market status, potential future scopes, and thus to add value to the existing application requirement and design enhancement
• Analyzing scope for further improvement and feature enhancement of the E-Commerce application

Confidential

Business Systems Analyst

Responsibilities:

• Gathering requirements from Line of Business, application development team, and database developers and writing/updating BRD according to that. Facilitating JAD Joint Application Development sessions for requirement gathering using WebEx
• Identifying and analyzing the current business process As-Is and document the process flow in the form of Business Process Modeling BPM and defining the future state To-Be of the business process as well
• Designing various Process Flow diagram, Activity diagram, etc.
• Understanding and analyzing the Data Warehousing, ETL concepts in order to implement in the BI tool Event Metrics Dashboard
• Designing ER diagram, data flow diagram for integration of several different data models using MS Visio 2010, data model to synchronize existing and target data model for the business model
• Creating functional requirement document FRD , design documents including HLD, LLD, Business and Atomic Use Cases referring to the BRD. Maintaining and updating project materials in Discovery and SharePoint repository
• Conducting meetings for walkthrough of the BRD, Use Case, technology deep dives for the design of the new application and get approval from larger audience for the final design
• Designing Wireframes using wireframe designing tool axure
• Creating Traceability Matrix to map the requirements from BRD to the Use Case to the testing script document
• Interacting and coordinating with Application Development team and Testing Team to clarify their queries related to any requirement mentioned in the Design document and provided support throughout the whole SDLC process of the project

Environment: MS Office Suite, MS Visio 2010, MS project, Axure 7.0, .NET, MS SharePoint 2010, Clarity.

Confidential

Business Systems Analyst

Responsibilities:

• Gathering requirements from Line of Business, application development team, and database developers and writing/updating BRD according to that. Facilitating JAD Joint Application Development sessions for requirement gathering using WebEx
• Creating HLD, LLD, Business and Atomic Use Cases referring to the BRD Maintaining use case tracker, design configuration file in excel document and updating it in Discovery and SharePoint repository
• Conducting meetings for walkthrough of the BRD, Use Case, playbacks of the design of the new application and get approval from larger audience for the final design. Attending meetings to understand Change Control for any change request in the business requirement
• Creating Traceability Matrix to map the requirements from BRD to the Use Case
• Data mapping for mapping table fields from existing underwriting application's SQL database tables to the future state SQL table in PEGA CRM application and maintaining Data Dictionary in Excel spreadsheet for tables, fields and field values
• Analyzing SQL scripts, stored procedures to understand and find derived fields, rules, and business logic
• Maintaining Excel spreadsheet to track record of data stored for Analytical and Reporting purpose BIX Extract in PEGA application
• Writing SQL queries to pull data from tables, views, and analyze data
• Defect tracking in Quality Center and resolving defect issues related to use cases and any functional requirement
• Interacting with Application Development team and Testing Team to clarify their queries related to any requirement mentioned in the Design documents
• Designing Data Flow diagrams for integration of several different data models using MS Visio 2010
• Designing Mock Ups for the User Interface of the intended new application using MS Visio 2010

Environment: SQL Server Management Studio 2008, MS Office Suite, MS Visio 2010, .NET, MS SharePoint, Discovery, Clarity, Quality Center.

Confidential

Responsibilities:

• Worked closely with SMEs in understanding and documenting their requirements related to loan servicing and maintaining, risk associated with handling customer data and NPI Non Public Information , risk mitigation measures e.g. proper authentication, sign-on process, encryption, etc. , identifying database backup plans e.g. taping DB on yearly basis Or more frequent like monthly or everyday for different DB instances for both non-transactional and transactional data.
• Analyzed requirements and prepare documents such as Business Requirements Document BRD , System Requirements Document SRD , High Level Design Document HLD and Low Level Design Document LLD , Use case.
• Involved with the QA team for the functional testing and Integration Testing SIT and CIT efforts, and in the UAT User Acceptance Testing as well. Worked with developers in the process of Unit testing.
• Updated traceability matrix for any change requirements in BRD and HLD/LLD
• Involved in creating and modeling the AS IS diagrams and TO BE system accomplishing using the GAP Analysis technique.
• Conducted presentations on the progress of the project after every phase of SDLC based on Agile Methodology.
• Used SQL queries to filter data. Analyzed .sql scripts, stored procedures, functions to perform ETL and understand the functionality of the process.
• Analyzed front end code to understand business logic applied for various validation requirements.
• Updated documents in the repository like Discovery site for project charters, Business Case update, application control plan, Project scope, impact, constraint, assumptions, and any dependency.
• Maintained project time tracking in Clarity.

Environment: SQL Server 2008, MS Office Suite, MS Visio 2010, MS project, .NET, MS SharePoint 2010, Discovery, Clarity.

Confidential

Business Technical Analyst

Responsibilities:

• Worked closely with SMEs in understanding and documenting service change requirements SCR pertaining to loan origination, loan accounting, and loan servicing, maintaining and analyzing customers accounting books and many other business Areas.
• Conducted one on one interviews, sent out questionnaires and requirements gathering sessions with the business users.
• Analyzed requirements and prepared documents such as Business Requirements Document BRD and System Requirements Document SRD , High and Low Level Design Documents HLD, LLD .
• Studied and worked on the Databases and programs and applications involved with the support of the system.
• Involved with the QA team for the functional testing and Integration Testing efforts, and in the UAT User Acceptance Testing as well.
• Worked with developers as needed for Unit Testing.
• Implemented Object oriented Analysis and design OOAD methodology to analyze the requirements. Also involved in logical Data modeling applying Business rules. Involved in database infrastructure designing.
• Involved in creating and modeling the AS IS diagrams and TO BE system accomplishing using the GAP Analysis technique.
• Conducted presentations on the progress of the project after every phase of SDLC based on Waterfall Methodology.
• Designed Entity Relationship ER Diagrams, Data Flow Diagrams DFD , Data Mapping, Data Modeling, Data Integration. Used SQL queries to filter data.
• Experience using Team Foundation Server TFS .
• Analyzed .sql scripts, stored procedures, functions to come up with design solutions.
• Worked closely with the support team of the application to provide solutions to various issues related to everyday transactions and jobs.
• Co-ordinate with Development team, QA team, and Support team both at onsite and offshore throughout the designing phase and deployment in production.
• Used Clarity to maintain work and project related record.
• Maintaining documents in SharePoint site, and their Discovery and Wiki sites as well.

Environment: SQL Server 2008, VS/TFS 2012, MS Office Suite, MS Visio 2010, MS project, .NET, HTML, MS SharePoint, Quality Center.

Confidential

Business Analyst/QA Analyst contract

Responsibilities:

• Involved with the Business user community Inventory Control, Retail store, Online store, and Loss Prevention to elicit requirements and identify the basic need of the users.
• Conducted one on one interviews, sent out questionnaires and requirements gathering sessions with the users. Facilitated JAD Joint Application Development sessions.
• Created the AS IS and TO BE diagrams accomplishing the GAP Analysis technique.
• Developed the detailed Functional Requirements document FRD based on the user requirements and specifications. Defined system requirement to Use Case Scenario using the UML MS Visio .
• Created Class Diagrams to describe the structure of a system.
• Made use of Business Process Modelling BPM , Process Flow diagram, Storyboard and Requirements Traceability Matrix based on final business requirements and enhancements.
• Proficiently utilized Object Oriented Analysis and design methodologies OOAD to employ the use case for requirements, design, implementation, testing stages.
• Presented Business Flow models and conducted walkthroughs for Requirements Board and documented feedback for further enhancements.
• Studied and worked on the Databases and programs and applications involved with the development of the new system. Analyzed requirement for feature enhancement of the E-Commerce site.
• Developed technical design Document by translating user requirements into functional requirements.
• Used Clarity PPM Project portfolio Management document management and Change management tool to get the requirements approval and change approvals done.
• Used SharePoint to efficiently communicate the FRD, Technical Design Document and other Integration Testing related documents for easy access to the team.
• Started work on laying out the training plans for the Users and help them write the Training Manuals.
• Helped QA team to develop test scenarios, test plan, test conditions and test cases for testing.
• Conducted functional testing, Integration testing and User Acceptance Testing UAT .

Environment: IBM Web sphere Modeler, UML MS Office Suite, MS Visio, Rational Rose, MS project, JAVA, HTML, SQL 2008, MS SharePoint, Test Director 7.1.

Confidential

Business Systems Analyst/QA Analyst contract

Responsibilities:

• Worked closely with SMEs in understanding and documenting their requirements pertaining to credit card related operations. Designed documents including BRD and FRD.
• Created new user-interface designs, mock-ups, wireframes and prototypes.
• Worked on Agile and SCRUM methodologies for fast completion of projects.
• Conducted GAP analysis to gather new functionality requirements.
• Analyzed requirement document by identifying ambiguous, incomplete and incorrect requirements. Helped in developing attribute matrix and functionality traceability matrix.
• Participated in QA testing UAT, Black Box, and Regression and deployment ensuring minimal defects.
• Facilitated discussions, presentations and preparation of the burn out charts, resource allocation, and estimated the schedule of project timelines using MS Project.
• Analyzed business requirements into high level and low level Use Cases and created Data Flow Diagrams, Activity Diagrams, Sequence Diagrams and Entity Relationship ER Diagrams in MS-Visio.
• Conducted JAD sessions with management, SME, vendors, user and external agencies and other stakeholders for open and pending issues.
• Aggregated and Analyzed test metrics weekly from the Clear Quest defects database that reflected the current status of the test execution and the state of the defects, and communicated weekly status report to Project Manager.
• Extensively used MS- Access and SQL to analyze data scenarios and data mapping.
• Managed and controlled change requests/defects using Clear Quest and made sure members in the team followed the change guidelines.

Environment: UML, IBM Web sphere Modeler, MS Office Suite, scrum Agile implementation, IBM Rational Software Modeler, JAVA, J2EE, JSP, HTML, SQL server 2000, Oracle 11i, SharePoint, Test Director.

Confidential

Business/Data Analyst contract

Responsibilities:

• Profiled customer indicative and demographic data from three major Lines of businesses LOB to determine data quality, usability and applicability to Customer Management Repository CMR by surveying CMR products to understand and study them well.
• Gathered business requirements by conducting JAD sessions and used the same to prepare Business Requirements BRD and Functional Requirement Documents FRD .
• Incorporated Rational Unified Process RUP to create BRD specifications using MS Visio and MS Word. Performed GAP Analysis to identify deficiencies in the current system.
• Created Use Cases, Process Maps, and Source to Target mapping to make developers understand the requirements and also translated Business requirements and functional specifications into program specifications and database change requirements to the technical teams.
• Implemented Six Sigma Business Management strategies.
• Maintained an Access database for Data Dictionary, and generated cross functional reports.
• Interfaced with LOB and Quality Assurance QA testers to assist in developing Test Cases and resolving testing issues. Performed Defect analysis followed by the process quality testing.
• Analyzed complex SQL scripts used to extract and transform data from corporate warehouse to develop Final Reports and key findings in Excel spreadsheets.
• Facilitated User Acceptance Testing UAT and test strategies with Information Systems Group.
• Drafted Requirement Traceability Matrix RTM to track down the testing phases and determine the responsibility of the testers.
• Performed CMR Oracle Database Maintenance activities like Code Table maintenance and Migration.
• Involved in System Development by creating Data Mapping, Data Dictionary and Code Table Standard templates using MS Excel for process, configuration control and tracking.

Environment: SAP, Rational Suite RUP, UML with Rational Rose, Rational Requisite Pro, Clear Quest, Rational Robot, Clear Case, MS-Visio.

Confidential

Senior Business Analyst/QA Analyst/Data Analyst

Responsibilities:

• Conducted detailed Requirement gathering, Gap Analysis, Impact Analysis by interacting with client, and business users. Interviewed users in order to understand their business processes and proposed IT system and accordingly designed the SRD, FRD, and BRD using MS Word, MS Excel, Telelogic DOORS Dynamic Object Oriented Requirements System .
• Acquired a strong understanding of Laboratory Management System LIMS .
• Conducted JAD sessions and produced Data Audit Document, created Data Standards, Naming Conventions, and Source-to-Target Data Mapping Document.
• Created specifications for data extraction, cleansing, validation and population using automated Decision Stream scripts.
• Designed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOAD Object Oriented Analysis and Design using UML. Designed Business Process Modeling BPM . Used MS Visio to depict process flow and make ER Diagrams. Created PowerPoint presentations.
• Involved in designing data mappings, data models. Created Data Flow Diagrams DFD and documented the ETL high level and low-level design approach. Used Informatica Power Center.
• Worked with DBA teams to structure data model and physical database design.
• Experience in designing GUI and storyboarding with regards to the UI flow.
• Assigned tasks among development team and supervised the progress of the project by simultaneously interacting with clients and the technical team following Agile Methodology. Worked as a team member in designing Web Site.
• Used SQL queries for organizing and abstracting data from MS Access, Oracle data bases. Created reports, forms on Ms Access.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for Stress Testing and UAT. Performed Manual Testing.
• Performed Technical Writing which included preparing Procedure Manual, Training Material, User Manual, Newsletter, white paper, Project announcement, Online Help and web content writing.

Environment: JSP, Oracle 10g, Java, J2EE, HTML, XML, Weblogic, Clear Case, Clear Quest, Agile, Rational Rose, JAD, MS SharePoint, MS Visio, UML, MS Project, SQL, MS Access, MS Excel and MS Word, IntelliJ IDEA.

Confidential

Business Analyst/QA Analyst/Application Developer and Technical Support /Technical Writer/

Responsibilities:

• Performed detailed requirements gathering, business analysis, validation of requirements, functional requirements and process flow design. Designed BRD, FRD, HLD. Used Waterfall Methodology.
• Prepared graphical depictions of use cases Activity Diagrams, System Context Diagrams, Sequence Diagrams, Use Case Diagrams, Wire Frames, etc. using MS Visio following UML guideline.
• Experience in Digital Asset Management System and Enterprise Content Management
• Reviewed project documentation for clarity/completeness and potential domain or function impact. Worked in a team to design company web site.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms ETL , integrating and loading data into Data Warehouse DW database.
• Involved in setting up different configuration environment for Compatibility Testing and Manual Testing for newly implemented features. Created User Acceptance Test Plan UAT .
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Utilized Object Oriented Analysis and design methodologies OOAD to employ the use case for requirements, design, implementation, and testing stages.
• Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, and summarized bug information in priority sequence, recommended viability of release for production.
• Involved in Defect Tracking and prioritizing the defects and writing requirements to resolve them.
• Conducted JAD sessions with management, Subject Matter Experts SME , Users, and other Stakeholders to resolve open and pending issues.
• Performed Data Mapping, data modeling, created ER Diagrams and used SQL queries to filter data.
• Knowledge of Search Engine Optimization SEO , and working with Meta Data.
• Created Admin Guide, User Manual, Online Help, Captivate movies, Power Point presentation, Web site content, Release Notes, Brochures for Sales Marketing team.
• Prepared Procedure writing for SAP integration, QuickBooks integration to the CRM application. Provided Customer Support.

Environment: RUP, UAT, GAD Gap Analysis Document , MS Visio, MS Office, Java, J2EE technology, SQL Server, Windows 2000 Advanced Server, Oracle Platform.

Confidential

Business Analyst/QA Analyst/Software Developer/Technical Writer.

Responsibilities:

• Interacted with Business Users and conducted user interviews with relevant business Units and developers for requirement clarification and brainstorming.
• Created Business Requirement Document BRD and Functional Requirement Document FRD . Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro. Designed Request for Proposal RFP , and Scope of Work SOW .
• Designed High Level and Low Level Use Cases, Activity Diagrams, State Chart Diagrams using MS Visio following UML methodology.
• Prepared Business Process Modelling BPM , Process Flow Diagrams, Activity Diagrams using MS Visio and Rational Rose.
• Created Workflow models, Information and Business Rule Models, Object Models during the analysis using Rational tools.
• Conducted JAD sessions to develop architectural solution.
• Worked closely with the users and the development team to support the development process, including clarifying requirements with the business and resolving issues that surface during the stages of the software development lifecycle SDLC .
• Wrote PL/SQL statement and Stored Procedures in SQL for extracting as well as writing data.
• Created test scripts for all the test cases in PL/SQL.
• Managed daily and weekly meeting with the development and testing team for status review and to relay any changed requirements.
• Documented, edited, proofread various reports required during the software development and prepared presentations of various design reviews.
• Conducted User Acceptance Testing UAT and collaborated with the QA team to develop test plans, test scenarios, test cases to be used in testing based on business requirements, technical specifications and product knowledge.
• Completed time estimates for all technical items, assigned work, and monitored developers' progress and produced timely status reports for upper management.
• Worked as a team member to write Java code for developing and enhancing features of the software application School Management System and Retail Management System.
• Prepared User Guide and Online Help.

Environment: Windows XP, MS Office Suite, MS SharePoint, Test Director, MS Visio, Oracle, HTML, XML, JSP, Java/J2EE, Java Script, MS-Project.