SUMMARY

• Over 8 EIGHT years of professional work experience as a Business Analyst/Business System Analyst in Govt. Administration Criminal Justice , Engineering and Financial sector Banking, Loan, Mortgage .
• Proven success as a Business Analyst and Quality Analyst through the years of providing a well-balanced understanding of business requirements, business relationships and business solutions.
• Strong understanding of the Software Development Life Cycle SDLC including but not limited to stake holder analysis, understanding roles and responsibilities of team members, requirement management gathering, analyzing, detailing and tracking , GAP analysis, configuration and change management, data mapping, development testing of client server and web based applications.
• Strong ability to critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, and abstract up low-level information to general understanding.
• Continuous work experience in various SDLC methodologies such as Rational Unified Process RUP , V-model and Agile Scrum .
• Competent in generating and analyzing documents such as Request for Proposals RFP , Business Requirement Document BRD /Scope Vision document, Functional Requirement Document FRD , Wireframes Mock Up screens , Narrative Use Cases, UML Diagrams Use Case Diagrams, Activity Flow , Business Processing Models BPM , Requirement Tractability Matrix RTM , Test Plan and Test Cases, Training Manual.
• Professional experience in eliciting 'As-Is' and 'To-Be' model by document analysis, interface analysis, prototyping, reverse engineering, observation, survey, interview, brainstorming, requirement workshop, joint application development JAD sessions with good inter-personal skills and conflict resolution expertise by building consensus among high profile stakeholders.
• Proven ability in performing Black - box Testing Sanity/Smoke, Functional, Integration System, Regression, Ad-hoc, System and User Acceptance Testing UAT and Automation Testing.
• Proficient in executing SQL queries against the database to generate ad hoc reports as per business requirements.
• Proficient to understand the relational/multi-dimensional database model and map the Entity-Relationship Models ERM .
• Efficient in prioritizing and managing the defects using the Defect Tracking tools.
• Expert in writing user guide and facilitating training classes for end users, department heads and content managers.
• Proven ability to work on multiple projects and prioritize responsibilities with emphasis on quality. Effective in executing multiple tasks and assignments ahead of schedule.
• Analytical, methodical, and resourceful approach for identifying and documenting root cause and appropriate corrective actions to meet short and long term business requirements.
• Familiar and experienced with RDBMS, Single Sign On SSO , Content Management, Data Migration, Data Conversion, Data loading, Electronic Data Interchange EDI , XML WSDL/web services, Data Mapping, Data Integration, Data Warehouse DW , Business Intelligence BI techniques. Proactive and flexible in learning new skills and technology.
• Client-focused attitude with exceptional interpersonal and oral and written communication skills.
• Ability to collaborate and actively contribute in a strong, positive and multi-cultural dynamic teamwork environment, yet able to work autonomously and take ownership of tasks.

TECHNICAL SKILLS

• SDLC Methodologies Agile, Rational Unified Processing RUP , Waterfall, Rapid Application Development RAD , V-Model
• Requirement Management Tool MS Visio 2010, CaliberRM 10.1, MS Office 2010, Rational Requisite Pro 7.1, Rational DOOR 7.1
• Project Management Tool MS Project 2010, MS Office 2010, Lotus Notes, MS Outlook
• Presentation Tool Prezi, MS PowerPoint 2010 w/ animation
• Testing Software Quick Test Professional QTP , SeleniumHQ 1.0.12, WinRunner
• Bug tracking / Incident Management FogBuz, JIRA, Change Gear, HP Quality Centre 11.0
• Change Management Tools Rational Clear Quest 7.1
• Version Control Tools Rational Clear Case 7.1, MS SharePoint 2010 MOSS 2010
• Databases SQL Server 2008 R2 SSMS, SSIS, SSAS , Microsoft Access 2007 w/ VBA and query building , Oracle 9i/10g, TOAD data modeler
• Web Technologies Microsoft FrontPage, Adobe Dreamweaver
• Operating System Window XP, Window Vista, Window 7
• Programming Languages C, C , HTML, XML, PHP, MySQL
• Business Intelligence BI/BO Tools Reporting Tool/Dash Board Tools IBM Cognos, MS Project, MS Excel vLookup, Pivot Table, VBA macros, OLAP Reporting, Conditional Formatting , Crystal Reports, SQL Server Reporting Services SSRS
• Enterprise Content Management ECM Alfresco 4.2, Documentum
• Web Services Too SoapUI 4.5
• Eng. Design Modeling COMSOL Multiphysics, AutoCAD, LabVIEW, SolidWorks, MATLAB Simulink

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst Quality Analyst

Roles Responsibilities:

• Working on numerous projects based on Agile and RUP methodologies to develop applications based on client's need.
• Successfully engaged in multiple assignments, tasks and analysis simultaneously.
• Working closely with the business users from different agencies using interviews, analysis, JAD sessions, surveys and workflow analysis to identify, categorize and document high level business requirements for inclusion in a business case.
• Supporting design team in the translation of requirements into structured systems design by bridging requirements and design sessions with both business and technical team members.
• Designing various deliverables include system requirement specifications/system use cases, user interface specifications, screen mock-ups, report mockups, business process models and navigational flows, database diagrams.
• Working as a data analyst to perform data mapping, data modeling and data conversion from old version to the new version of the portal application.
• Determining impact of functional requirements on various aspects of existing system to examine integration with other existing applications and lifecycle support implications.
• Developing test plans, test scenarios, test conditions and test scripts and executed functional testing - sanity, retesting and regression testing, web service testing to investigate the defects in the release.
• Assisting project manager in system implementation/deployment/ rollout activities, including all necessary pilots.
• Working as a reporting analyst to generate complex ad hoc reports through SSRS based on the user's need.
• Communicating with system end users to gather system feedback and improve functionality.
• Supporting functional issues in production application by handling user calls/emails.
• Representing project group in the agency wide weekly change control meeting to inform any change in any production applications from our group and also updating group for any upcoming changes by other users.
• Performing all work in accordance with company's quality programs, standards and procedures.
• Maintained safety, security, and privacy standards throughout all areas of responsibility.
• Environment: Java, IBM Websphere, J2EE, XML, SQL Server 2008, Oracle 9i/10g, MS Visio 2010, MS Excel 2010, MS Power Point 2010, Alfresco ECM 4.2, Rational Req Pro, HP Quality Centre, SoapUI 4.5, WebEx conference, SSIS SQL Server Integration System

Confidential

Business System Analyst Reporting Analyst.

Roles Responsibilities:

• Involved in multiple important projects within short duration as a technical business analyst and performed tasks well before desired deadlines.
• Reporting System Migration Consolidation:
• Worked closely with senior database administrator and performed reverse engineering on existing MS Access based reporting system built by automated macros and VBA procedures.
• Performed logical data modeling, data mapping and conversion between MS access DB and SQL DB and documented missing attributes and report work flows in order to migrate Access DB to the SQL server.
• Developed and tested T- SQL/SQL/MDX queries for complex reports in SSMS and generated matrices reports through Report Builder 2.0 SSRS and assisted senior database admin to provide automated subscriptions to the reports to deliver to appropriate business user.
• Mapped missing report attributes in the existing OLAP cube Multidimensional Database by SSMS, SSIS and SSAS and reported them in Pivot Excel tables.
• Database Migration of Client Web Based Application:
• Worked with business users and senior business analyst in order to thoroughly understand the business intelligence needs of executives. Overseen, coordinated, and participated in organizational, operational, and procedural analyses to determine information input, work processes, and desired output.
• Studied BRD and existing end user reports in order to map them with the new SQL DB.
• Communicated with senior database architecture, data warehouse admin and technical developers for effective transfer of the requirements and checked the technical testability and feasibility of the business needs incorporation.
• Performed Gap analysis on MS Access based database and new SQL database and documented functional requirement documents FRS including report layouts, database diagrams for important financial reports for business executives.
• Assisted data warehouse admin and developer to generate these financial reports though SSRS.
• Stayed on top for updated information and provided strong link between business users and technical team in order to keep them on same track with the recent information.
• Change Request for Client Based Application
• Studied the 'As- Is' application and related business documents and interviewed the business user to understand the change request for the application.
• Discussed the feasibility of change requirements with project manager and technical team with regards to time frame of implementation, cost and risks constraints.
• Prepared TRD/FRD including mock up screens, database diagrams, database table dependencies diagrams for change request.

Environment: ASP.Net, XML, SQL Server 2008, SSMS 2008, SQL Report Builder 2.0 SSRS 2008 , SSIS 2008, SSAS 2008, MS Office Suite 2010, MS Visio 2010, MOSS 3.0, Change Gear, Documentum, TOAD data modeler.

Confidential

Lead Business System Analyst.

Roles Responsibilities:

• Based on Agile and Waterfall, project was initiated with intense planning, following with ad-hoc iteration and closed with intense period of inspection and review under the environment of extensive collaboration, facilitation, leadership, coaching, and team building.
• Facilitated scrum planning meetings with stakeholders, subject matter experts SMEs , project managers, software developers, and software testers.
• Ensured the full scope of requirement definition that can be built and tested within the overall project constraints.
• Enlisted loosely coupled requirements from all members and translated the sprint backlog into 'Epic/User Story' - high level description of system behavior.
• Tested the user stories for accuracy and compliance to ensure undisputed acceptance and validation.
• Proficiently helped development team to break down large user stories for better execution.
• Helped the development and testing team to coalesce around the iteration objectives, understanding the requirements at a lower level and bridging the team together to deliver an expected outcome.
• Managed project progress through Burn-Down Chart, monitored milestones and critical dates to identify potential jeopardy of schedule and mitigate any impediments.
• Actively monitored and maintained change request log to avoid 'Scope Creep'. Participated in change control board at the front end when change request was raised. Developed project matrices for weekly evaluation of project status and to account the impact of the change request on the time line.
• Rigorously followed up with business user community on professional grounds to procure business sign off to avoid any delays in project timeline.
• Managed and shared documents with all updated versions also necessary project content through MOSS 3.0 and published project progress status on dashboard every week.
• Developed end user ad hoc reports, custom dashboards, score cards, line, bar and pie Charts for business analysis on important decisions.
• Worked extensively with the QA team for designing test plan and test cases for the UAT.
• Worked closely with QA and developers to clarify/understand functionality, resolve issues and provide feedback to nail down the bugs.
• Performed user demo for End-to-End flow and to ensure look-n-feel.
• Contributed in critical and analytical functional testing.
• Collaborated with the project manager to organize training material and write user manuals.

Environment: IBM Websphere, Java, SQL Server 2008, MS Office Suite, MS Project, MS Visio, HP WinRunner, HP LoadRunner, JIRA Bug Tracker, MOSS 3.0, SSRS 2008.

Confidential

Business System Analyst

Roles Responsibilities:

• Inception Phase:
• Assisted business stake holders to develop initial business case, which included business context, success criteria, revenue projection, risk assessment, market recognition and financial forecast.
• Quantified, qualified and advised on prioritization of business requirements through interviews, surveys, prototyping and observing account managers and UI User Interface of the existing proposal generation system.
• Identified all external entities/actors interacting with the system and define the nature of this interaction by preparing high level use cases.
• Prepared a general vision and level document BRD of the core project requirements, key features, main constraints, context diagrams and business process model.
• Elaboration Phase:
• Assisted system analysts to translate the business needs into system requirements, communicating with the business stakeholders on a non-technical level, and with the system analyst on a more technical level.
• Planned and defined low level business requirements in narrative use case, use case diagrams and activity diagrams.
• Worked on wire frames to create the design of the web-based e-portal application utilizing MS Visio.
• Performed user interface analysis and created prototypes to determine the ideal context and navigation necessary for each web form.
• Conducted JAD sessions with client, management, SMEs, system and business analysts for open and pending issues.
• Assisted the project manager in preparing Work Breakdown Structure WBS /development plan for the overall project, including the coarse-grained project plan, project schedules, milestone tracking, and resource allocation using MS project 2007.
• Regularly worked with the CMA Change Management Application and CDM Content Display Management teams.
• Construction Phase:
• Assisted programmers to resolve issues pertaining to understanding of the requirements.
• Assisted testing lead to develop timelines for project delivery, and managed projects and resources for successful completion of testing.
• Assisted QA team in preparing the test plan and test cases based on business requirements, and technical specifications.
• Integrated RequisitePro with ClearQuest and ClearCase to provide visibility to all the teams and maintain tractability of requirements, use cases and change requests.
• Performed SQL queries for data verification and also performed UAT and assigned problems to appropriate software development team for fixing.
• Transition Phase:
• Prepared user manuals, release notes and training documents as a part of Release Management Program.
• Performed beta testing to validate the new system against user expectations and trained the users and maintenance team.

Environment: COBOL, CICS, Java, Java Script, CORBA, DB2, Unix, IBM Mainframe, Microsoft Office, MS Visio, MS Project 2007, Rational RequisitePro, Rational Rose, Rational ClearCase, Rational ClearQuest, IBM Cognos.

Confidential

Business System Analyst

Roles and Responsibilities:

• Facilitated scrum Agile sessions with clients, SMEs and technical team to record long-term and short-term business needs, priorities, and risks.
• Leveraged knowledge of mobile application features and functions to assess scope and impact on business needs.
• Elicited, analyzed and validated business functional and non-functional requirements to generate detailed Business Requirement document BRD , Functional Requirement Specifications FRS , wireframes, use cases and BPM documents.
• Created a trusting working relationship with end users, business groups, outsourced development team, project management team, testing team and executive management team throughout the SDLC.
• Acted as an IT liaison between client, system analysts, developers and testing staff in the form of day-to-day support of software related business processes/requirements.
• Organized and validated all requirements with technical team to ensure traceability and measurability.
• Assisted the project manager in capturing and reporting project activities/schedules/progress Gantt and PERT charts , roadmap, and issue resolution to the appropriate business stakeholders.
• Reviewed requirement changes and informed project manager about impacts and possible change control need. Documented the new features or the changes made to existing applications and issued release notes.
• Assisted lead tester in creating test plan and test cases, participated in testing, and orchestrated testing activities between IT and the business teams.
• Recognized process or programming inefficiencies, and recommended improvements.
• Provided product expertise to client groups, acting as a resource in understanding how mobile applications perform business and user functions.

Environment: WebMethods, Siebel 7.x, Visual Basic, DB2, J2EE, Microsoft Internet Information Server, Java, RosettaNet PIP standards, XML on a mixed Windows NT and Unix environment, iRise, JIRA, MS Office, MS project, Crystal reports.

Confidential

Quality Analyst

Roles Responsibilities:

• Consulted business analysts, system analysts and testing team for development and implementation of test plans, test cases, test scripts and test data according to the system requirements, solution diagrams, help files, screen mock-ups, use cases and requirement documentation FRS / SRS .
• Performed sanity, functional, integration, system, GUI/Interface, configuration, content, regression, automation and UAT testing End-To-End Testing with the team, under Agile SCRUM and Waterfall work pattern for different projects.
• Performed defect tracking, developed defect summary reports and updated RTM at regular intervals.
• Performed verification and validation of finance charge calculations through POE.
• Tested application security features, including session expiry, book marking, passwords and compatibility across multiple browser types and encryption levels.
• Provided accurate and detailed daily and weekly task reports.
• Participated in defect review board meetings to verify and review various defects logged against the application.
• Assisted QA lead for ensuring successful testing and deployment.
• Performed scalability, performance and load testing using QTP.
• Compiled statistical data and prepare various reports, charts, graphs and/or written summaries for management through SSRS.

Environment: Mainframe 3270, DB2, SQL, Windows XP, MS Office, QTP Mercury Quick Test Professional , Power builder, Java, Oracle 10G, LoadRunner 6.0, SSRS, CaliberRM.

Confidential

Business System Analyst QA

Roles Responsibilities:

• Conducted JAD sessions with management, SMEs, vendors, users and other stakeholders to understand existing business processes and figured out for the ways to streamline business activities and resolve current challenges through the use of technology.
• Organized and elicited high-level requirements for 'Home Page' and 'Sign In' modules through client interviews, document analysis, requirement workshops and critical evaluation of information from multiple sources.
• Along with other BAs, formulated and defined business scope and objectives through research and fact-finding combined with an understanding of industry standards.
• Decomposed and documented high-level information in to low level FRD, RTM, Use Cases and UML documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors.
• Abstracted up low-level information in to a general understandable wire frames and distinguished true needs from end user requests.
• Assisted PM in providing status reports with detailed description of current progress and next action plan.
• Anticipated and identified tradeoff between usability and performance. Provided recommendations and course of action, consistent with the business objectives and functional requirements.
• Insured that business needs were accurately reflected in the IT strategic planning, project management, and annual planning processes.
• Worked with the business team and technical team to understand change request and articulated these requirements into written specifications ensuring that the changes in systems/business processes align to the overall business strategies.
• Ensured that the change requirements were coordinated, understood and incorporated by developers and all questions raised were answered in a timely and accurate fashion.
• Coordinated and supported smoke test activities and UAT via test case authoring, execution and defect disposition.
• Validated test coverage for the specified requirements along with any regression testing for interoperability.
• Defined and updated key documentation material as a part of release management, and provided peer training / coaching assistance for future discussion .

Environment: Siebel 3.0, Oracle, Window NT, Easel, IBM 3270, Cobol, CICS, HALLAPI, Easel GUI, MS Project, MS Office, MS Visio, CaliberRM, Rational ClearQuest.