PROFESSIONAL SUMMARY

• Business Systems Analyst with over 6 years industry experience and expertise in Business Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis.
• Knowledge of the Software Development Life Cycle (SDLC) phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.
• Experience in creating and executing test plans for functional tests, QA tests, regression tests, smoke tests and UAT using TestLink.
• Experience in facilitating the test process by using bug tracking tool JIRA.
• Well versed in project management tools like MS-Project, Team Foundation Server, and Liquid Planner for status reporting, scheduling and planning.
• Expertise in creating mockups using Balsamiq.
• In depth knowledge in documenting requirements changes using Traceability matrix and Team Foundation Server.
• Hands on expertise with collaborative tools like Sharepoint and Confluence.
• Initiated Agile Scrum in several projects and planned daily scrum meetings.
• Implemented SQL scripts, stored procedures, triggers and indexes for various database operations.
• Deep technical background and solid working knowledge of SQL Server Data warehouse systems.
• Extensively worked on all phases of Data Warehousing project like Data Cleansing, Data modeling for data staging & Data Mart, ETL, Indexing, Quality Assurance, Data updating plan, and Data presentation to business users.
• Created Data Mapping Documents and worked with business to write transformation rules.
• Strong knowledge of SQL and extraction/ transformation/ loading (ETL) process using SQL scripts.
• Well versed in project management tools like MS-Project for status reporting and planning.
• Expert in conducting business reviews, walkthrough sessions and facilitated monthly and weekly meetings/reviews.
• Strong presentation skills and ability to tailor presentations towards different functional areas of business.
• Expert in coordinating work plan between project manager and the client with Microsoft Project.
• Demonstrated an exceptional ability to adapt to new developments in the world of technology and working environment. Ability to prioritize and schedule multiple tasks on a day-to-day basis.

• Methodologies: ITIL V3, RUP, SDLC, Agile, SCRUM
• Languages: C, C++, Java, SQL, HTML, and XML
• Databases: Oracle 8i, MS SQL server, MS Access`````````
• Project Mgmt, Design & Case tools: MS Project, Team Foundation Server, Visio, Rational Rose, RequisitePro, Clearcase, ClearQuest, Ab Initio, Balsamiq
• Quality Management: Six Sigma, TQM, JIT and Lean Manufacturing
• Reporting Tools: Crystal Reports
• General: MS-Office (Word, Excel and PowerPoint), SharePoint

Bachelors in Management Studies

Project Description: PRJ294 Prometheus was a project that included development of a website to provide medical record information to its members. It was based on the lines of the PDMP’s across different states especially the OHIO prescription monitoring program. The website would provide its user access too medical records contained in the PDMP databases across the US.

Responsibilities:

• Started out the project in its planning phase using the Agile methodology and facilitated a weekend long meeting with the client and the team to collect business user stories.
• Reviewed business user stories and created several Excel and Word files to document the business process, user stories and algorithm required for Iteration 1.
• Used UML to create sequence and use case diagram in Microsoft Visio.
• Created Balsamiq mockups of various types and sizes for the website and also created a signoff document listing name, description and functionalities of each screen page for client sign-off.
• Maintained documents and collaborated with the team by extensive use of SharePoint.
• Conducted and facilitated technical requirements meeting with the developers on the team to gear up for Iteration 2.
• Managed the team and tasks as well as schedule using Team Foundation Server.

Project Description: The scope of project BI Fast Track was to build UI screens for Live Nation Ticket Master clients using Oracle Business Intelligence Enterprise Edition software.

Responsibilities:

• Responsibilities as a Business Analyst included regularly updating the Test Plan and uploading on Confluence for sharing with the team and management.
• Worked as a Business Analyst as well as a Test Lead and developed quality test cases, test scripts and test plans in TestLink, based on product requirements, functional and technical design.
• Maintained project documents and shared important links and tutorials, etc with the team using Sharepoint.
• Collaborated and provided support to the team by creating project announcements, team member tasks and alerts using Sharepoint.
• Executed functional tests in the QA environment prior to the QAT process and logged tickets for bugs detected.
• Facilitated the QA Test process by assigning test cases to the QA test plan in various builds, assigned test cases to the QA testers, and established contact with the testers.
• Facilitated the QAT process by providing guidance and support to the QA testers with test tools, test scripts and the execution process.
• Maintained constant communication with the testers by assisting the Project Manager in conducting Daily Bug Review meetings during and after the QA Test process.
• Created test scripts for regression tests, smoke tests and UAT using TestLink.
• Provided Test Status by creating a Bug Summary Report and a Test Progress Summary spreadsheet on a daily basis during the QAT process.
• Created, assigned, and maintained tickets in JIRA for bugs and defects.
• Participated in Data Validation process in QAT by developing spreadsheets with data from the reports in QA.

Environment: Sharepoint, Confluence, JIRA, TestLink, RUP, OBIEE, Clarity

Project Description: The scope of the project, Pearl River Migration was to upgrade and rewrite codes involved in the applications of various programs under the client. Database applications and programs from client Blue Hill were converted from assembly codes to C++ by accessing the codes, analyzing them, gathering requirements, creating HLD and finally setting up for conversion.

Responsibilities:

• Involved in various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements using Rational Requisite Pro.
• Worked as a Business Analyst as well as an Assistant Project Manager to guide the team through the conversion process employing SDLC models, Iterative model, RUP concepts, Agile Model and UML.
• Collaborated with team across regions from various facilities of the company to gather business requirements by leading bi-weekly meetings and created status reports and presentations for the same.
• Facilitating JAD session follow-up for Project Plan updates, gained consensus for User Acceptance Testing requirements.
• Created and maintained the process documents for the project to be used for collaboration with developers, project manager, etc on SharePoint.
• Executed daily SCRUM and Sprint planning.
• Created and maintained data mapping documents.
• Participated in SCRUM meetings and worked closely with the Subject Matter Expert and the Project Manager.
• Used MS Word, MS Excel, MS Access, MS Project, MS Visio for documentation and analysis reports among other project management and reporting tools.
• Organized project tasks, managed team workflow and project scheduling using Team Foundation Server.
• Involved in various stages of code conversion in Workbench including Development, Testing, Stage and Production.
• Initiated GAP analysis by analyzing as-is and to-be conditions for the project at the beginning of the conversion process.
• Created test cases, test plans and performed ETL using Ab Initio.
• Documented the mapping used in ETL processes.
• Sharing and managing assembly codesand data files for their conversion in C++.

Environment: C++, Visio2003, TFS, SharePoint, Workbench, Rational Requisite Pro, Ab Initio Windows NT and UNIX.

Project Description: The scope of the project was to develop Installment Loan Processing System (ILPS) specially to support the loan application processing needs. It employs a workflow to control and monitor the various work steps in the loan processing. Typical work steps in the application workflow include: Application origination, Duplication check, Watch list check, Credit scoring, Application form printing, internal credit check, loan repayment history etc. It also gives the loan officer a complete overview of the transaction at the point of service.

Responsibilities:

• Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager to get a better understanding of the Business Processes. Analyzed and optimized the process.
• Evaluated solutions for business problems/bottlenecks and evaluated alternate methods to increase efficiency and improve control. Analyzed and documented information system requirements and the corresponding impact on business processes.
• Designed and developed Use cases, Activity Diagrams, Sequence Diagrams using UML and Business process modeling.
• Maintained the Requirements Traceability Matrix (RTM) across the deliverables of a project.
• Analyzed business requirements to develop functional and detail design specifications of the application.
• Managed the workflow process using SDLC methodology and Iterations.
• Conducted Joint Requirements Planning (JRP) Sessions as a Facilitator to gather requirements from the group.
• Documenting the objectives, constraints and scope of the system.
• Used the Office Suite extensively which included MS Word, MS Excel, MS Access, MS Project, MS Visio for various documentation and analysis reports.
• Defined project milestones, schedules, monitored progress and updated plans using MS Project.
• Led and conducted Joint Application Development (JAD) sessions and well experienced in interacting with individuals at all levels.
• Consulted with users, resolved problem to meet specific technical and business needs.
• Validation and Verification accountability for all the deliverables of s/w development projects.
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervised the development of User Manuals for customers.
• Developed data warehouse reporting requirements and created data mapping documents.
• Worked with Project Manager in coordinating all aspects of project such as initiation, planning including budgeting, scheduling, task assignment and tracking, Change management status reporting and risk management.
• Prepared reports and presentations for weekly management meeting to update senior Ministry staff on project deliverables, progression and timelines.
• Trained team members with project knowledge and business processes.
• Worked with QA’s to develop Test Plans and Test cases, detected bugs in the system, prepared the Defect reports using Test Director and interacted with developers for Debugging.

Environment: UML, Agile, Oracle, PL/SQL, Visio2003, Visual Basic, MS Office Suite, QTP, Windows NT and UNIX.