SUMMARY

• Over 8 years of experience as an accomplished Analyst in Information Technology.
• Worked as a Business Analyst/Business System Analyst using the iterative Software Development Lifecycle (SDLC) principles of Rational Unified Process (RUP), with extensive experience in the field of business analysis, business modeling, and process re-engineering.
• Extensive experience in portfolio performance measurement and reporting system for mutual funds and securities trading.
• Experienced in software testing which involved development of test cases and test scripts and User Acceptance Testing (UAT) and Master Data Management (MDM) to promote a shared foundation of common data definitions within the organization.
• Extensively worked with Enterprise Content Management and Data models and Meta data definitions for content management.
• Experienced in gathering business requirements for web services in a Service Oriented Architecture (SOA).
• Driving the project by keeping track of the open issues, coordinating efforts within team and ensuring that the project is delivered within its stipulated time frame.
• Leading JAD sessions to facilitate discussions of requirements scope, priority, and dependencies. Work with application architects, developers, testing teams thereby coordinating efforts.
• Expert in using industry standards to uncover the client requirements and identifying the system requirements by creating Use Case Models, Data Flow Models etc.
• Efficient in writing Business requirements document, Usecase Specifications, Functional Specifications, customer requirement Documents and Workflows.
• Created Views, Alerts and Custom Lists in SharePoint.
• Created Sites, Team Sites and Personal sites in SharePoint.
• Integrated Audience based Web Parts, Reminders, SharePoint custom style sheet, Security groups and permissions and Utilized Built in Oracle Packages like UTL_FILE, DBMS_OUTPUT for better debugging.
• Assigned to take over a floundering content management project using the Teamsite architecture and bring it to the point where it could be launched.
• Potential users developed detailed gap requirements to bring the project up to speed including details content data model documentation and application flow.
• Expertise in Manual and Automation Testing with Identifying pertinent master data elements (MDEs) such as entity types, data elements, associations.
• Knowledge of client-server and web based applications, strong database design (SQL) and modeling experience with project management skills with PHP.
• Assessed the current state of the project and through interviews with stake holders and extensively used MS Excel and SQL to create Adhoc reports along with Service Oriented Architecture (SOA).
• Performing data analysis by identifying the different data sources, creating logical data models and establishing relationship between entities.
• Experience in the documentation of specifications, creating step-by step technical and user manuals with illustrations, designing and implementing new processes and technology.
• Strong analytical and problem solving skills for understanding the functional requirements and design of the business application.
• Excellent communication skills, leadership and management abilities and an effective team player.
• Worked closely on generating process Workflows & Design flows as part of the technical design.
• Demonstrated ability to remain flexible, unfazed and on-track in an environment of tight deadlines and high expectations.
• Efficient in translating Business Requirements into Functional and Non-Functional Requirements.
• Strong Subject Matter Expertise in sectors like Banking & Finance.

SKILLS

Business Tools:

Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), ECM, Visio,MS Project, MS Access, MS Office Suite, Visual Paradigm, Doors, Erwin,Data Modeler 4x, Business Object (Crystal Reports), SharePoint Server 2010

Business Skills:

Business Definition Requirements, Content Management Business Process,Analysis, Gap analysis, Use Case Modeling & Gap Analysis, Business,Environment, Market Research Analysis, Interwoven Teamsite and Documentum Technologies

Methodologies: RUP, OOAD, UML & Business/Data Modeling, PHP, Agile MDM

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 8i/9i; SQL Server 7.0 & 2000, SOA, Access 2000, MS SQL Server, DB2

Languages: Visual Basic, C, C++, SQL

UI Design Tools: HTML, MS FrontPage, MS Visio

EXPERIENCE

Confidential 11/11 to 03/12

Business Analyst/PM

Supplier Planning & Integration

Responsibilities:

• Prepared Business Requirements document according to requirement related to Mutual funds conversions and large amount of positions that were moved to different platform.
• Responsible for analysis, design, development, testing and implementation of enterprise content management system and business processes.
• Prepared a spreadsheet after analyzing the results and issues in service fees validation.
• Responsible to run specific and customized SQL queries in brokerage data warehouse Production for the business requirement proposes along with Service Oriented Architecture (SOA).
• Extensively used Excel to create weekly, ad-hoc reports for brokerage data warehouse usage analysis.
• Responsible for strategic direction of the content from individual sites to be migrated on to the Portal.
• Use SQL*Loader utility to upload data files into tables, Export and Import Oracle Utilities to move tables between Schemas.
• Integrated Audience based Web Parts, Reminders, SharePoint custom style sheet, Security groups and permissions.
• Deploying and configure Sites Collections, sites, Workflows and Web Parts.
• Assigned to take over a floundering content management project using the Teamsite architecture and bring it to the point where it could be launched.
• Responsible for entire roll out and user training for content management contribution for each program.
• Developed complex multilevel workflows that will send email notices to the users and approvers using SharePoint Designer.
• Validating monthly invoice following the conversion for each fund family assigned.
• Working with reconciliation team in weekly audits meetings.

Confidential 01/11 to 11/11

Sr. Business Analyst (CONSUMER IT)

Responsibilities:

• Gathered requirements from user stories, BR and SR documents in a fast paced Agile Environment and in a test driven development.
• Ensured parity between the functional groups through simple dialogue during scrum meetings.
• Extensive use of Rally tool for ranking backlogs, estimating size, and grooming items for planning and scheduling.
• Managed and documented requirements from project inception through release.
• Extensively used Excel to create weekly, ad-hoc reports for consumer IT usage analysis.
• Responsible for creating the test cases and generating necessary traffic for end to end verification.
• Active involvement in daily triage calls discussing blocking issues, defects and troubleshooting if and when required.
• Developed collaborative, portal, and Content Management solutions using SPS 2003 by analyzing user requirements and processes.
• Expert in understanding the root cause of the defect and overall impact on validation cycle execution.
• Extensive use of SoapUI for testing using multiple protocols such as SOAP, REST, HTTP and JMS.
• Create and managed SharePoint Lists using SharePoint designer.
• Ability to use Basic Unix commands to validate the logs using PuTTY.
• Monitoring test preparation activities and environment readiness.
• Responsible for daily summary email and escalation of defect analysis.
• Extensive use of Oracle SQL Developer to browse database objects and running SQL statements.
• Designed and implemented basic SQL queries for QA testing and report data validation with SOA.
• Wrote SQL commands and procedures, to check for newly provisioned subscriber data for consistency and update invalid fields with proper value.
• Extensive used of Quality Center for reporting defects after analyzing the results.
• Reviewed test plans and cases with developers for the testing of the project.
• Conducted backend testing and validated the data obtained from source.
• Prepared user guide & support documentations.
• Expanded existing filing resources and trained team on it.
• Participated in the bug review meetings, Updated requirement document as per business user feedback and change in functionality of the application.

Confidential 09/09 to 12/10

Business Analyst

Responsibilities:

• Prepared Business Requirements and Functional Requirements documents according to the business requirements for Account Performance functionality updates related to Mutual funds, Bonds and Securities trading.
• Had an extensive interaction with the offshore teams and various verticals within the organization. Conducted individual and group (JAD) sessions with business and technical units.
• Acted as an interim project manager for a project release. Facilitated daily status call meeting, and lead JAD Sessions involving business, development, and QA teams.
• Analyze client’s personal financial data and situation; provide client centric solutions and recommendations based on the best interest of the client resulting in the sale and/or service as agreed to by the client. Incorporate regular touch-points throughout the year to track the client's progress vs. goal and when appropriate reallocate resources or investments in order to keep the client on track.
• Debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Supported prioritization of initiatives by coordinating with on-site and off-shore team members. Managed the Change request process and analyzed the impact of the change requests on the application in regards to Timelines.
• Manage work/time to optimize client interactions. Includes: preparing for sales calls to clients, placing outbound calls to existing clients/prospects, setting and holding regular (quarterly) meetings with current and prospective clients, gathering and documenting information to ensure compliance requirements are met, facilitation of appropriate business processes and the monitoring of interactions and next steps.
• Acted as a liaison between business area and development team by working with both parties and translating business requirements to use case specifications.
• Designed and developed all Use Cases.
• Developed the project scope and documented it.
• Defined business requirements for a database using Data Modeling technique.
• Performed testing with the testing team manually and by using automated testing tool from Mercury (Test Director and Win Runner).
• Used the guidelines and artifacts of the Agile (Scrum) and laid emphasis on rapid development during the sprint cycles.
• Initiated the UAT (user acceptance testing), client acceptance testing, interface testing and regression testing before the release of the product.

Confidential 09/07 – 08/09

Business Analyst/QA

Responsibilities:

• Analyzed software specifications to gain better understanding of the application and prepared test cases that provide a detailed list of conditions under which the system will be tested.
• Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct effort.
• Used strong technical ability and established quality standards to verify and validate assigned s/w products, components, or function sets throughout their development cycles.
• Defined and performed the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Created Test Plans, Test Cases and Test Scripts for the modules of the application under test (AUT) using Quality Center.
• Conducted parameterization of Test scripts to execute Data Driven tests.
• Provided the management with test metrics, reports and schedules as necessary and participated in the design walkthroughs and meetings.
• Developed test cases and Test scripts for System, Integration and UAT Testing.
• Validated various HIPPA rule implementation.
• Tested inbound and outbound EDI business flow.
• Created and enhanced VB scripts for regression testing with verification checkpoints available in Quick Test Pro.
• Automated Test scenarios for GUI, Functionality, Boundary, Security and Regression Testing using Quick Test Pro.
• Updated and managed multiple scripts using Object Shared Repository.
• Documented the daily Defects Status with the help of Test.
• Extensive coding in SQL for the data analysis, Data integrity and Data mart validation.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL*Plus.
• Performed User Acceptance Testing (UAT) on the application before release.
• Worked on the continuous improvement of QA Process by reviewing and evaluating existing practices with standard testing guidelines.

Confidential 08/05 - 08/07

Business Analyst

Responsibilities:

• Conducted Gap Analysis to determine deltas between existing system and proposed online loan processing system that would facilitate enhancement.
• Performed Business Impact Analysis, feasibility analysis of proposed projects, processes and solutions.
• Conducted business risk analysis to identify the qualifying standards for mortgage applicants and developed effective risk mitigation strategies.
• Analyzed various steps in the loan lifecycle and constructed the system that identifies and monitors the riskier loans and Created Sites, Team Sites and Personal sites in SharePoint.
• Developed system requirements specifications encompassing Functional and Non-Functional requirements.
• Developed user-interface prototypes of enhanced loan processing features using MS Visio to facilitate interactive discussions with stakeholders and user interface design engineers.
• Managed and documented requirements from project inception through release.
• Analyzed and prioritized key reports for day to day servicing needs for loan monitoring processing and Inspection.
• Designed and implemented basic SQL queries for QA testing and report / data validation.
• Participated in the bug review meetings, Updated requirement document as per business user feedback and change in functionality of the application.
• Externalized business rules to Quick Rules to facilitate flexible enforcement of qualification standards for loan applications through integration with back end systems and design of orchestration workflows.
• Assisted client in developing content and training materials; recommended enhancements and identified new business requirements.

Confidential 01/04 – 07/05

Business Analyst

Responsibilities:

• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Collected and documented business processes as well as business rules.
• Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
• Collaborated with development architect and the business to develop both high-level and detailed application architecture to meet the business needs.
• Documented and delivered Functional Specification Document to the project team.
• Participated in the logical and physical design sessions, developed design documents.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Responsible for the day-to-day administration and support for SharePoint Server Production, Test and Development environments.
• Created site Collections, Sites, sub-sites, lists, libraries etc.
• Managed security and permissions on web applications.
• Created master pages, templates, page layouts using SharePoint Designer 2010.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.
• Developed test scenarios and implemented test plan. Providing key input in working with users in defining project and system requirements.
• Conducted project relate presentations.

Confidential 03/03 – 12/03

Business Analyst

Responsibilities:

• Participated in full Project Life Cycle, including gathering user requirements, screen and report design, implementation, roll out and ongoing support.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements and Non Functional Requirements using Rational RequisitePro.
• Followed UML based methods using Rational Rose to prepare Use Cases, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams.
• Prepared Requirements Traceability using Rational RequisitePro.
• Worked with the UI team to create screenshots to be presented to the Business unit.
• Conducted walkthroughs with developers and QA Analysts.
• Worked with users to develop User Acceptance Test plan.
• Attended meetings with clients, management team, and developers to discuss major defects found during Testing, Enhancement issues, and Future design modifications.
• Used SQL queries to create the test data bed selecting geographical credit card users from the existing credit card customers.
• Involved in drafting a Vision document for the intended system.
• Conducted User Acceptance Testing on the application resolved issues from the participants, prepared and submitted Test Analysis Reports.
• Worked with a fellow team member to train the user on the application.

EDUCATION