SUMMARY

• Business Analyst with 7+ years of diverse IT experience in Financial and Insurance Services, Consumer Risk and Credit Analytics.
• Good understanding of various fixed income, annuities, mutual funds, pension funds, tax - deferred and after-tax annuities, IRAs, brokerage accounts, and Asset management.
• Expert in documenting functional specification for business process improvement and automation, data modeling, and system architecture.
• Proficient in transforming business requirements into functional specifications, focusing on workflow analysis and design, business process reengineering, UI design, portal design, and process flow modeling.
• Highly skillful in conducting/coordinating requirements gathering session (RGS), Joint Application Development (JAD) sessions, and brain-storming sessions with subject matter experts (SME).
• Extensive experience in producing UML data models, creating Behavioral diagrams (Activity diagram, and Sequence diagram) and Structure diagrams (Class diagram and Data flow diagram).
• Expert in preparing Business Requirement Document (BRD), Functional Requirement Document (FRD), Use Case Document (UCD), and Test Case Document (TCD).
• Working knowledge in writingSQLquery for identifying databases involved in the application development.
• Worked with leading IT Insurance, Healthcare, Retail, Mortgage and Banking Clients during my tenure asBusinessAnalyst/ RequirementsAnalyst.
• Knowledge ofAS400Power MHS, Foresight EDI Validator, Ultra Edit and interface/outboards operations, SQL within SAS Enterprise Guide.
• Intuitive understanding of business processes and efficient in performing GAP analysis, SWOT analysis, Root-Cause Analysis, and Impact Analysis.
• Strong knowledge of SDLC including Waterfall and Agile methodologies.
• Proven ability in defining, preparing, and documenting entire Testing Life Cycle (TLC), and User Acceptance Test (UAT) plan.
• History of excellence in Data Modeling, Data warehousing, Data Analysis, Quantitative analysis, Reporting processes, Data Migration, Creating Dashboards, and End-user Training.
• Strong business acumen, strategic thinking, communication, interpersonal and presentation skills, adept at creating, editing, and coordinating extensive communication networks.
• Creative and Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

Operating Systems: WINDOWS XP/ 2000/ 2007/ VISTA

Databases: MS-Access, MySQL, Oracle, SQL Server, Sybase, Teradata, OLAP

Data Modeling Tools: UML 2.0, Power Designer 16.0, PeopleSoft 9.2, Rational Rose, MS Visio, Gliffy

Office Suites: MS Word, MS Excel, MS Access, MS PowerPoint, MS OneNote, MS Projects

Communication Tools: MS Outlook, Lotus Notes

Document Management Tools: SharePoint, Clear Case

Defect Tracking Tools: Silk Central, JIRA, Quality Central

Business Intelligence Tools: Hyperion, Business Objects, AS400, Cognos

Messaging: IBM MQ Messaging,SWIFTMessaging (SWIFTAlliance Access,SWIFTAlliance Gateway), SIDE Reporting & Viewer (Eastnets), Unix Shell Scripting, SQL Oracle, MSSQL

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Business System Analyst

Responsibilities:

• Gathered business requirements, analyzed business process, collected data from various sources, analyzed data, and monitored performance.
• Translated business requirements to functional requirements and technical specifications with help of Data flow diagrams (DFD) for developers.
• Attendedagileiteration sessions and present a report on the status of various TFS tasks for the iteration
• Analyzed research data withUXteam, generated insights about user goals, needs and pain points using affinity diagrams.
• Facilitated brainstorming sessions with Product andUXteams in concept generation and feature ideation. Executed end-to-endUXdesign for multiple departments: Product, Marketing, Enterprise, e-Commerce, and cross-channel publication.
• Responded and took action to address issues initiated from the User Stories, category and pricing leadership; this includedretailchanges, new items, discontinued items, scanning problems, reporting and other miscellaneous request.
• Manipulated, cleansed, and processed data using Excel, Access, and SQL; Wrote SQL queries for data extractions.
• Analyzed economic data using statistical tools like SAS, SPSS to ensure data quality.
• Provided all requirements gathering support for theagileteam.
• Produced Requirements traceability matrices (RTM) to support the application development, and control changes on requirements.
• Executed database queries inSQL, worked with XMLs & performed E2E verifications for mobile message services.
• Running database & writingSQLqueries.
• Created user stories for all bank owned development including changes toAS400and middleware components.
• Performed GAP analysis for new application requirements and prioritized them based on the business needs to identify critical features required for each release.
• Assisted the Quality assurance (QA) team in writing, executing the Test plans and Test cases.
• Ensured that the test cases, test script, and test scenarios covered all the points mentioned in the business requirement document (BRD) and functional specification (FRD).
• Worked on post production validation (PPV) to ensure that all the enhancements worked smoothly.
• Assisted business users with User Acceptance Testing (UAT) and received sign-offs on the new application.

Environment: MS Office (Word, Excel, Access, PowerPoint), Teradata, SQL, JIRA, SAS, SPSS, MS Outlook.

Confidential, New York, NY

Business/System Analyst

Responsibilities:

• Conducted brainstorming sessions with business users and SMEs to gather business requirements; additionally, facilitated Joint Requirements Planning (JRP) sessions to better understand the business domain, requirements, and project scope.
• Create, analyze and present sales comparison,retailmanagement, movement, Inventory and margin impact reports to optimize profitability and evaluate effectiveness of marketing programs.
• Facilitated data mapping exercises to understand data flow, compliance, and regulatory requirements with respect to liability balances (BASEL II, US GAAP, and IFRS, SOX).
• Documented business requirements and functional specifications with mockups to explain in detail the business implications and impacts.
• Coordinated with documenting processes usedagilemethodology to write theBusiness Requirements documents and designed Functional specifications.
• Created sequence diagrams and dataflow diagrams using UML to facilitate better understanding of the process.
• Interacted closely with designers and software developers to understand application functionality, facilitate data migration, as well as updated them about end-user sentiments.
• Involved in preparation of test plans and test strategy documents and documented entire testing processes, test cases, and test results.
• Attended JAD sessions to understand the impact on other lines of business.
• Conducted feasibility analysis for automation of reports and inclusion into the dashboard.
• Conducted training sessions to train business users in using the PEARL (Business Objects) reporting application.
• Worked on the post implementation support while the application was in production.

Environment: MS Office (Word, Excel, Access, PowerPoint), Hyperion, Business Objects, UML, RUP, MS Outlook, Quality Central.

Confidential, Washington, DC

Business/System Analyst

Responsibilities:

• Interacted with SMEs, securities traders, and business users to gather requirements and understand the business process. Conducted controlled brain-storming sessions with project focus groups.
• Involved in gathering and synthesizing business requirements and translated them into functional requirements to be used as input for design specifications.
• Mastered knowledge of securities lending business (including trading in equities, fixed income products) in order to document business requirements accurately. Also gained expertise with security reference data in investment management.
• Utilized SDLC Agile Scrum methodology for overall project management and implementation.
• Acted as liaison between the SME’s and the technical teams; handled scheduling, resource planning and allocation matters, as well as conducted status meetings and compiled reports.
• Extensively worked on documenting user requirement specifications and business process; additionally assisted in developing system requirements.
• Implement weekly reports utilizing Oracle Analysis studio and ad-hocSQLqueries.
• Designed data flow diagrams and data process models to present a better view of the system that enabled the technical team to identify key processes.
• Contributed to customization, enhancement, update, and changing functionalities of the reports using Cognos.
• Carried out specific data processing and statistical techniques using SAS/ SQL.
• Worked on Bloomberg terminal to update daily security values for NAV calculations.

Environment: MS Office (Word, Excel, Access, PowerPoint), SQL, Bloomberg, Cognos, RUP, MS Outlook.

Confidential, San Diego, CA

Business/System Analyst

Responsibilities:

• Collaborate with system analysts, software engineers/ architects, and the business users to develop both high-level and detailed application models that meet the business needs.
• Provide overall business systems analysis and design support; including system testing.
• Studied and assessed the clients systems and business processes.
• Developed project plans and managed scope.
• Set-up and maintenance of agent information within theAS400with accuracy
• Used Rose and Visio to model the process using the UML to create Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Used SQL queries to filter data within the SQL Server.
• Worked with different Subject Matter Experts (SME’s) to define and gather requirements for Life and Annuity Insurance.
• Transformed XML data to various types of documents.
• Involved in converting the User requirements into business requirements, functional requirements and also created business process models from the requirement specifications.
• Worked with user groups to provide training, resolve questions, assess user needs and recommend changes.
• Developed status reports and other project communications.
• Provided key input in working with users in defining project and system requirements.
• Performed functional testing and User Acceptance Testing (UAT).
• Developed user guide for the Policy Quotes and Claim functions and also part of the team reviewing the system document for production support.
• Primarily acted as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Environment: MS Visio, UML, MS Excel, RUP, MS PowerPoint, Rational Requisite Pro, Quality Center, SQL