PROFESSIONAL SUMMARY:

• Experience with Business Analysis, Software Quality Assurance, and Business Applications over 8 years. Have exquisite knowledge in requirement gathering with remarkable verbal, written and interpersonal skills.
• Effectively involved in a financial domain with strong understanding on investments, equities, derivatives and key finance concepts
• Experience working with technical and business teams Portfolio Managers, Traders, Quant teams, Operations and IT and Change Management to create, interpret and implement financial software systems for a wide range of instruments involving securities specifications, pricing, trading, settlement and portfolio management with Equity, Fixed Income, Swaps and Derivatives.
• Extraordinary associate at linking business and technical needs, worked closely with IT and application managers for gathering requirements.
• Experience in working with SDLC models and Agile Scrum , Prototype Model, RUP, Waterfall and Modified Waterfall.
• Expertise in developing documents for Functional Requirement Specification FRD , Software Requirement Specification SRS , Business Requirement Document BRD , Use-case Specification and Non-functional Requirements.
• Accountable for ensuring user stories to have acceptance criteria.
• Proficiently helped development teams to break down large user stories for execution.
• Advised product owners, scrum masters and teams to improve their ability to create good product backlogs.
• Actively assisted in the acceptance and validation of the stories by testing the delivered stories.
• Ensured that user stories are good, has business values and story points and prepared story boards and wire frames.
• Experience with data modeling, data profiling, metadata management and data mapping techniques.
• Tough knowledge of UML Use Case Diagrams, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, Class Diagrams and experience creating these using MS Visio and Rational Rose
• Well-versed in managing requirements and requirement traceability matrix RTM using Requisite Pro.
• Knowledge on Data warehousing concepts and Extract, Transform and Load ETL .
• Expertise in testing phases through all the levels from developing test plans through test execution.
• Managing the change activities using ClearQuest.
• Experience in writing complex SQL queries DDL and DML and test scripts for data validation, backend testing and data analysis.
• Conducted JRP Joint Requirement Planning and JAD Joint Application Development sessions with end users, development teams. Experience in conducting Scrum meetings.

TECHNICAL EXPERIENCE:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Business Analyst Data Analyst

Description: Rockwell Collins is an aircraft company headquartered in Annapolis. The project is about merging customer records of the two flight systems residing on different databases to provide a single customer data view. The data solution provides a bridge between both the customer records and provides a single view of data to the client.

Responsibilities:

• Conducting meetings with clients of both the systems for understanding the customer records and its attributes.
• Understanding the data of the input files on which merging is performed.
• Conducting data analysis using tools and transformation jobs on kettle to do data profiling and staging.
• Actively participated in technical detail of the data performing ETL.
• Designing high-level architecture and process flow diagrams to explain the flow of data.
• Identifying unique attributes in the data to set up relationships between two systems input files.
• Involved in data cleansing and data profiling and performing transformations to perform data operations
• Loading the data into data bases and performing querying to create views to the data.
• Performing matching component to identify unique data depending upon certain attribute values.
• Reporting data updates to the client for feedback.
• Creating a solution by merging records and providing a single view of customer data.
• Refining the data system of Nexus and Pre-Bill System by establishing a merge link.
• Developed source to target mapping and involved master data management.
• Documented Software Requirement Specification including the Logical Database requirements, performance metrics and software system requirements.
• Worked on java scripts in the Pentaho tool to perform kettle transformation.

Environment/Tools: SQL Server, .NET, Pentaho, MS-Project, Zoho, MS-Visio.

Confidential

Business Analyst and Solution Architect

Description: Minneapolis Public Schools MPS is the school district in Minneapolis. They are the education system collaborated with many in-house and vendor system and also a huge student information system called e-Discovery. The prime objective of this project was to act as a BA and Solution Architect in analyzing over 200 apps and working on them which do not have documentation and performing rationalization of apps that are important to the school and prove excellence in analyzing their purpose.

Responsibilities:

• Learning the existing student information system of MPS and their apps incorporated in the e-Discovery.
• Worked closely with the Executive level, specially the Chief Information Officer and IT Director by conducting weekly stand up meetings for delivering updates.
• Outlining the requirements for the target state which helps the server from overload by merging the apps that perform similar functions
• Examining the technical architecture of the application and documenting them for preparing a report on all the apps MPS uses.
• Conducted JAD sessions with the application developers who worked on the development of in-house apps to understand their functionality
• Proposed a target state for the existing system by merging apps, killing un-used apps and shaping few other apps adding functionalities.
• Responsible for preparing FRD's and SRS for all the in-house applications specially the core student- teacher app called Classroom for Success
• Created flowcharts and data flow diagrams for the enhancement requests for Classroom for Success Application.
• Experience in wearing several hats even as a developer handling the e-helpdesk tickets for major app Classroom for Success.
• Developed a user interface design using Snagit to show the UI design for the development team.
• Worked closely with developers, SAP team for employee data and SSIS team of e-Discovery for Student Data.
• Developed process flow, requirement specification, use case specification, test plan and test strategy coordinating with the business, development and quality assurance team.
• Documented Software Requirement Specification including the Logical Database requirements, performance metrics and software system requirements.
• Acted as data analyst for analyzing the data of the Classroom for Success application and was involved in data profiling to examine statistics of the student attendance information.

Environment/Tools: MVC, .NET, MS-PROJECT, MS-OFFICE, Snagit, SQL Server 2008, MS-Visio.

Confidential

Sr. Business Analyst

Description: Fannie Mae is a multi-national Corp holding banking and financial services. It is the major provider of financial services in investment banking. Risk Profiler measures the effectiveness of company's risk management strategies of single family and entire life cycle of a loan maintained via Loan IQ. Acted as a lead BA with responsibilities of the project that include gathering business requirements by conducting meetings and interviews and developing reports daily, weekly, quarterly and annually to improve business decisions.

Responsibilities:

• Stacked business requirements, generating workflow diagrams, statements of work and functional design documentation.
• Constructed and developed data flow diagrams and business process models using Microsoft Visio.
• Analyzed Use cases from functional requirements, composed Use Case Specifications and designed business process workflow diagrams Activity diagrams, Sequence diagrams, Collaboration diagrams in MS Visio.
• Communicated with stake holders, information architecture and technology teams conducting JRP sessions
• Verified movement of data occurs correctly and is performed as per the Mapping Spec/ Use Case.
• Designed and Maintained Project Templates, Use Case Project Templates, FSD Templates and Requirement Types.
• Prepared custom reports, data analysis and performed the SQL queries and verified them on MS Access
• Scripted SQL queries on the backend database to query the MySQL.
• Actively participated with the front end developers for gathering and analyzing needs of User Requirement.
• Designed User Interface designs as a mock up screen for visual communication and data flow to the end users.
• Worked with Loan IQ product suite for increased efficiency, reduce operational risk and maintain streamlined and controlled process.
• UAT Functional 'User Acceptance Testing', UAT Regression and Implementation Phase.
• Look up to the end users and developers to ensure user satisfaction and if any change in management.
• Developed process flow, requirement specification, use case specification, test plan and test strategy coordinating with the business, development and quality assurance team.
• Provided a fine, clear and brief documentation on the requirement management plans, functional requirements, test plans and test cases using Test Manager

Environment/Tools: MS Project/Visio/Access, SnagIt, UML, Agile, Oracle 10g, SQL, Flash 4.0, Quality Center

Confidential

Business System Analyst

Description: StreetSmartPro was existing trading application of Schwab and StreetSmartEdge was an enhanced application, intended to address the problems users had with StreetSmartPro. We worked with StreetSmartPro's BAs, Developers and Customer Support to get an understanding of existing features, the desired new features and to prioritize those features .It was a large application and was very challenging. Each BA took ownership of a particular tool in the application. I owned accounts tool and balance bar tool.

Responsibilities:

• Inter communication with existing application team for understanding the existing features and prioritize features to gather requirements.
• Worked with more than one development teams since I worked on two tools and acted as Subject Matter Expert SME for the tools I owned.
• Managed and supervise teams of consultants and was accountable for the successful delivery of tasks on IBM MDM projects
• Set Customer best practices expectations revolving around MDM.
• Advise IBM MDM usage and design to best fit customer business process requirements
• Used AGILE format to baseline the prior release requirements.
• Performed Gap Analysis, Impact Analysis to check compatibility of the existing application with new business requirements and suggested methods to overcome them.
• Prioritizing the scope of project through the iteration plan, by understanding the client requirements.
• Proposed creative features for trading applications for its better looking user interface and easy access.
• Generated project reports using MS-Project.
• Performed test cases at the end of three iterations performing UAT.
• Management of time constraints efficiently and meeting the project deadlines.
• Efficiently recorded incomplete features for later releases.
• Ensuring the test cases run met with user need regarding the aspect of the functional, User Interface, Performance, Usability and Security requirements.
• Worked on Oracle platform for querying SQL to extract data.

Environment/Tools: MS Project, MS Visio, SnagIt, Agile, Gap Analysis, Impact Analysis, SQL, IBM MDM,WPF/.NET framework

Confidential

Business/Data Analyst

Description: Confidential is a multi-national financial services corporation. It is a leading service provider in the area of finance. The IT division of the corp. manages implementation of IT Infrastructure. This project was to create a single integrated service system with relevant interface to accommodate the user needs to transform people, technologies and process of the company with single source for data, upgrading the long term and income products which are used annually such as Life Insurance, Fixed Income, Variable Income, Long-term and Disability Income Product.

Responsibilities:

• Conducted meetings and interviews with business associates to gather requirements.
• Devise and price fixed and variable pricing instruments and assist business.
• Solve problems and issues assisting customer care.
• Leading members by conducted JAD sessions to engage Subject Matter Experts in business planning, business analysis and business requirement definitions.
• Gathered information regarding business problems by leading research.
• Experience in ad-hoc queries to retrieve data from the data base using SQL.
• Providing information by analyzing and translating information to IT teams and management.
• Designed Use-Case, Active and Sequence diagrams using Unified Modeling Language UML methodologies.
• Worked with the development team to assure business requirements are met.
• Tracking and managing changes in business requirements and scope of project.
• Worked as a Lead for six business analysts.
• Effective communication with business customers, upper management, technology specialists and vendors.
• Re-engineered business process and built detailed maps for future business process.
• Designed Business Use cases and Functional Requirement Specification.
• Experience with Data Extraction, Transformation and Loading ETL , query enhancement and managing data relationship with IT teams.
• Managed Traceability matrix for business, functional and use case requirements.
• Created test plans and User Acceptance Test UAT procedures.
• Determine opportunities for modifying business process and problem resolution and proposed for its changes.

Environment/Tools: Requirements Analysis, UML, Use Case Analysis, MS Visio, Rational Rose, Requisite pro, SQL, ETL, .Net, PeopleSoft CRM, CRYSTAL, SIEBLE, CMMI Standards.

Confidential

Business System Analyst

Description: This project was about working on Integration Projects, TOCS Synergy. Manpower forecast plays a critical role in operating efficiently to hand over satisfactory aircrafts on-schedule and to advance allotment of manpower resources. Manpower forecasting is a tool of SCO and this project is to modify the screens, reports and background processing for Manpower Forecast to accommodate subsidiary.

Responsibilities:

• Involved in Requirement gathering, analysis of the requirements from the user.
• Interacted with the Business Users to analyze the business process and gathered the requirements, made necessary changes to Business Object schema objects to fulfill their reporting and business needs.
• Preparing business requirements documentation including business rules, workflow diagrams and activity diagrams.
• Worked closely with designers and developers, and determined solutions by balancing the business needs and technical aspects.
• Designed and Developed Use cases and worked on Rational Unified Process of Software Development Life Cycle SDLC .
• Created Data Flow Diagrams and Process flow diagrams by using MS-Visio.
• Worked extensively with MS-Visio to present processes graphically created the AS-IS and TO-BE process flows.
• Participated in the Test phases including development of Test Plan, Test scenarios, expected results and testing execution.
• Helped QA Team by executing Functional, Integration and System level test cases.
• Generated UAT User Acceptance Test test cases and made them executed by users.
• Prepared Requirements Trace Matrix report and test reports.
• Involved in Project plan and scheduling.
• Involved in Configuration Management process and worked with ClearCase tool.
• Used ClearQuest tool to add change requests

Environment/Tools: Requirements Analysis, MS-Visio, UML, RUP, Use Case Analysis, MS Visio, MS- Project, Requisite Pro, ClearCase and ClearQuest, .NET

Confidential

Business Analyst, App Developer

Description: This project is about creating an app which will manage our day-day expenses by storing all the expenses transactions, getting the reminders about the un-cleared bills. Apart from personal expenses this application will help a user to calculate how long it will take to become debt free and how much he will have to pay interest by making the minimum monthly payments. The user can also crunch the numbers using any fixed payment of his choice.

Responsibilities:

• Participated in discussions, conducted meetings and gathered requirements from the senior management.
• Devised the functional and non-functional requirements of the project and used Modified Waterfall Model.
• Developed Use case, Activity and Sequence diagrams to define the Business Process Model and Data Process Model.
• Documented Business Requirement Specification and high level project plan.
• Designed overall UML diagrams for the project
• Designed a user interface and created a database using SQL.
• Documented Software Requirement Specification including the Logical Database requirements, performance metrics and software system requirements.
• Programming the underlying code of the application using JAVA.
• Performed testing such as black box, white box, security and compatibility.
• Performed User Acceptance Testing to deal with business requirements if properly met.
• Co-Ordinated with on-site and off-site development and support teams.
• Proposed future enhancements that can be made to the project.
• Developed mobile app for functioning.
• Monitored the performance of the application and collecting feedback from users.

Environment/Tools: JAVA, Android SDK, Eclipse, Tomcat Server, MySQL, White Box Testing, Black box Testing, Regression Testing, UML, MS-Visio.