SUMMARY

• Over 8+ years of experience in Business/ Business Systems, Process Analysis and Process Re - engineering, creating Business and functional requirements (BRDs and FRDs), process flows, and Use Case/ Stories’ documentation in Auto-insurance, Un-Employment Benefits, Supply Chain Management, and Banking, using IT Business Analytics, Modeling, and SDLC.
• Experience with Onsite/Offshore co-ordination model
• Business Process Modeling (BPM), Use Case modeling using UML, Data Modeling, Project Management, Change Management, Software Training, Software Development methodologies, QA testing and Systems Testing, troubleshooting of client server and web-based systems.
• Experience on both Agile and Waterfall Software development methodology.
• Responsibilities carried out as Business Analyst, Systems Analyst, and Team Lead; on Business side as well as IT side.
• Managed program and project efforts for Logistics and E-Commerce, POS, Supply Chain, CMS, and Web based applications, business strategy and web site content.
• Strong knowledge in P&C, Personal Lines & Commercial Line Insurance and Online Banking
• Subject matter expertise in Securities and Capital Markets, Risk Management (Market and Credit), Fixed Income and Derivatives, Credit Derivatives Market, Emerging Market, Equity Market, Fixed Income Market and Money Market
• Good Understanding of different phase of Trade Lifecycle such as Account Set-up, Trade Order Generation, and Trade Order Execution, Order Settlement etc...
• Vast Insurance business knowledge with project experience in various LOB’s such as Personal (Auto, Dwelling, Home owner) and Commercial (Commercial Auto, Workers Compensation, Commercial Property, General Liability, Business Owners Policy (BOP), Commercial Package Policy (CPP).
• Strong domain knowledge in Banking and Finance. Good understanding of basic principles of financial markets and instruments (Equity Derivatives, Cash Equities (Domestic and International), Fixed Income, FX, Derivatives (FX Options, OTC Options, Swaps, Forwards, Futures, Market Link Investments, Deposits, Repos, CDS), Mutual funds, NAV, fund accounting
• Immense knowledge in Health care operations, Interfaces, Reports, Letters and system Migrations, Health Administration - Claims processing (auto adjudication), Claims pricing and testing, HIPAA, enrollment, Medicare, Medicaid, CDHP.
• In-depth knowledge in the Investment Banking Industry, Project Finance, Credit Card Industry, Mortgage Loan Origination, Loan Servicing, Treasury Services (ACH, Wire Transfers etc.), Brokerage Services, Commercial Banking, Retail Banking, Asset Wealth Management, Cash Management, Capital Market and Credit Risk Fundamentals.
• Hands on experience in creating SQL Queries, Stored Procedures, Triggers, Views, Indexes in SQL Server with a strong understanding of data & analytics.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), High Level Design Document (HLD), Requirement Traceability Matrix (RTM) and testing documents.
• Excellent Understanding of Data warehousing concepts - Data marts, Star, Snowflake, Fact, fact less, Dimensions, Hierarchy, Measures, cubes Etc
• Hands on experience in Data Warehouse and Business Intelligence tools Informatica, Business Objects and Cognos
• Worked efficiently on multiple projects spanning over different releases at the same time
• Proven track record in requirement gathering & analysis, data collection, analysis and evaluation in Information Systems issues, analytical problem solving and decision making, communication and inter-personal skills with ability to interact with individuals at all levels.
• Transformed business requirements into functional specifications, focusing on workflow analysis and design, business process re-engineering, user interface - UI design, and process flow modeling.
• Expert in MS Office Products such as Word, Excel, Project, Power Point, Access, Visio.
• Conducted various JAD sessions with business users and separately with development, QA teams.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Testing Applications: Rational Test Manager, HP/Mercury QTP, HPQC

Suites: SharePoint, MS Project, MS-Office (Word, Excel, Power Point, Outlook, Adobe Photoshop)

Reporting Tools: Cognos, Business Objects and Crystal Reports

Requirement Tools: Rational Requisite Pro, Rational Clear-Quest, DOORS

Business Modeling Tools: Rational Rose, Enterprise Architect, Visual Paradigm, Microsoft Visio

Databases: Oracle, DB2, UDB, SQL SERVER, MS ACCESS, Oracle, Mainframe

Methodologies: Agile, Scrum, Waterfall, JAD UML, RUP, BPMN

PROFESSIONAL EXPERIENCE

Confidential -Des Moines, IA

Sr. Business Analyst

Responsibilities:

• Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
• Interacted with Fixed Income business heads to finalize the Business Requirements for the application.
• Wrote SQL statements to extract data from the Tables
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Assisted with project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Conducted interviews with various business users to collect requirement and business process information using MS Visio, Requisite pro.
• Conduct extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and Compliance issues
• PerformedDatamapping, data mining, data analysis, logicaldatamodeling, created class diagrams and ER diagrams and used SQL queries to filterdata
• Used SQL for data extraction and data analysis
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture Execution and reporting requirements for the user interface.
• Conducted project due diligence and created testing document to meet Sarbanes-Oxley and other Compliance requirements
• Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
• Involved with the trading activities of Credit Derivatives, Credit default swaps, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Designed and developed project document templates based on SDLC methodology
• Gained understanding of the Asset management requirements for risk analytics and developed the equity reference data mappings and equity reference data dictionaries considering the source system and Confidential system equity reference data.
• Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Designed and developed all Use Cases and UML models using Rational and Visio
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Executed Regression and IST sceneries in the Quality Center
• Assisted in system and User Acceptance Testing, performed client presentations.
• Assured that all Artifacts are in Compliance with corporate AGILE Policies and guidelines.

Environment: Windows, Oracle, SQL, MS Visio, HTML, PHP, MS Access, UML, Quality Center, WebLogic, Requisite pro, Rational ClearQuest.

Confidential - Minneapolis, MN

Sr. Business / Systems Analyst

Responsibilities:

• Document management system was utilized in the access control and management of the requirement specifications produced in this role.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Created best-practice requirements deliverables, such as use cases, system process flows and context diagrams
• Gathered requirements, developed Process Model and detailed Business Policies.
• Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
• Followed the RUP methodology for the entire SDLC.
• Documented the FRDs and BRDs for Ecommerce project using Rational Requisite Pro.
• These specifications included UML-based use case models and activity diagrams, and usability analysis/user interface
• Coordinated in store operations and administration including scheduling, reports, inventory, and customer service
• Documented the Process Flows for B2C and B2B in the High Level Requirements Document
• Analyzed the business capabilities and IT applications for retail - Commercial, Space-Range & Display, Vendor purchasing, Store Ordering, Distribution and Store Operations
• Managed requirement activities using an iterative and incremental methodology such as Agile using User stories and Acceptance Criteria.
• Conducted Gap Analysis for the system considering AS IS and TO BE features.
• Supported retail business processes and functionalities including POS application and systems; merchandise processes, such as allocation, goods receiving, store transfers, return to vendor.
• Monitored activities and implemented strategic sales tactics through visual merchandising
• Responsible for writing and implementation of the test plan, and various test cases.
• Develop user manuals, presentations and training manuals as per project specifications and timelines.
• Created the Traceability Matrix to ensure that all the user stories are being tested and covered in the testing plan.
• Conducted UAT sessions to approval.
• Proficient in writing good SQL queries.
• Initiated, proposed and implemented critical analytical and technical turnkey solutions extensively increasing the quantitative and qualitative value of the application.
• Provided overall project management to multiple projects successfully completing them on-schedule and on-budget.
• Build and managed a cohesive team to meet deliverables per project / track assigned.
• Provided customer support as required to meet service level agreements.
• Prepared the Business Workflow using MS-Visio with input, output, and Pre and Post conditions.

Environment: s: SharePoint, MS Office, MS Project, SharePoint 2010, Informatica, MS Visio, Agile, Quality Center, SQL, SQL Server.

Confidential - New York, NY

Sr. Business Systems Analyst

Responsibilities:

• Responsibilities include analysis, design, development, testing and implementation for the application. Responsible for coordinating internal and external groups for merger project including development, testing, implementation, status reporting to PMO, release management, change management and control of project.
• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting
• Implemented and Used SWIFT messaging system to test the flow of messages from and into the new system and was also involved in ETL process
• Responsible for scheduling tasks and assigning tasks to the developers and task managers as per the project plan.
• Responsible for Collecting, understanding, and transmitting the business requirements for the project, and translating these into functional specifications and detailed test plans.
• Develop, plan and implement identified PMO processes and supporting tools, including staff training.
• Conducted proof-of-concept workshop drafted Use-cases, process workflows and designed the framework for match and merge.
• Performed financial research and present findings to senior management on business issues primarily related to current or new rules and regulations by providing analytical / statistical support.
• Responsible for fund Level portfolio analysis in an account for private clients.
• Managed process improvement, automation and integration of this reporting tool and recommend modifications / improvements to different financial modules and processes.
• Established Agile methodology for the project execution.
• Built, grew and led teams in agile environment
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Created test cases and scenarios for Unit, Regression, Integration as well as Back-end, GUI and System testing.
• Responsible for creating diagrams and work flow processes using RUP and Rational Rose. Also created Swim lanes diagrams.
• Conduct annual Gap Analysis to determine the effectiveness and deficiencies in existing PMO process.
• Worked on JAD (Joint Application Design) as per the technical specifications of the application.

Environment: Microsoft Office Suite, Windows NT/XP, Oracle, SQL, SQL Server, Agile, Recon, Base camp, Clarity, Visio.

Confidential, TX

System Analyst

Responsibilities:

• Gathered requirements interacting with Underwriters of Ocean Marine, Property, Auto, Other Liability etc and Claims Adjusters to create Business Requirement Documents (BRD).
• Developed business requirements for General Liability, Cargo War, Marine Cargo, Property, Surety and Commercial Automobile.
• Gathered requirements for Premium Processing System (PPS) interacting with subject matter experts and Underwriters.
• Developed Functional Requirements for Premium Processing System (PPS).
• Created business process diagrams for AS IS and TO BE systems in Claims.
• Created use case diagrams for Premium Processing System and incorporated them in use cases.
• Review RFP responses and estimates from multiple vendors offering Policy Admin (PAS), Claims & Billing modules in support of accounting, claims and underwriting departments
• Developed Business Request Documents for Policy Administration and Claims.
• Created Functional Requirements for different transactions of a policy from New Business, Endorsements, Cancellation, Reinstatement, and Renewal to Extended Reporting.
• Gathered Business and Functional Requirements and elicited them in the form of Use Cases and other requirements Documents by interacting with Underwriters.
• Developed Claims, Claims Authority Limits and Claims Relinking Requirements.
• Developed Requirements for Taxes, Fees and Surcharges for different states.
• Identified various rating risk Factors as per a pre-defined set of rules and created process and data flow diagram
• Worked with the actuarial group to update and communicate rating changes/requirements
• Developed test scenarios for homeowners and automobile incorporating different rating factor for different statues.
• Created Business Requirements Specifications for Limits and Deductibles for different lines of business.
• Complied requirements for different Business Rules for the company such as Writing Companies, Regional Offices, Surplus Lines Brokers etc.
• Wrote Change Requests for different LOBs.
• Extensively used MS Visio for UML diagrams which was crucial in the developed phase.
• Documented and managed all requirements with Rational Requisite Pro - Requirement management tool.
• Worked to regulate flexibility of the application’s features during development to help in customization of the product onsite at the client organization.
• Played a pivotal role in facilitating JAD sessions to develop detailed solutions and to verify the application development process.
• Conducted GAP analysis on fields required for rating a policy across systems.
• Used Share Point of versioning of the documentation and requirements.
• Participated in Walkthroughs to QA team.
• Used Quality Center as a bug reporting tool.
• Involved in Bi-Weekly Triage to analyze priority and severity of defects logged on Quality Center.

Environment: RUP, Quality Center, Oracle, UML, MS Visio, XML, Rational Requisite Pro, MS Project

Confidential, New York, NY

Business Data Analyst

Responsibilities:

• Gathered requirements from business users and analyzed them using Rational RequisitePro
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Documented functional specifications to automate the loan approval process for home Mortgage (online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review)
• Acquired in-depth knowledge of the banking industry (Mortgage, Assets, and Accounts Receivables/Accounts Payables etc)
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system
• Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design (OOD) using Rational Rose according to the UML methodology
• Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, Activity), using MS Visio
• Involved in testing all the data elements in RSIs Mortgage Account Inquiry Service, which is called by CCW to obtain Mortgage loan data from MSP
• Worked on mapping of MSP Webservices to Enterprise Interface Partners and coordinated with FIS on MSP
• Sketched diagrams of proposed and existing systems using Visio
• Implemented the entire Agile Methodology of application development with its various workflows, artifacts, and activities
• Acted as a liaison between business users and system development team during development process
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro
• Supported IT & Risk Management in Business Continuity Planning for Item Processing department
• Developed and maintained the project plan using MS Project
• Conducted interviews with clients for the purpose of gathering product requirements and understanding the client workflow
• Gained thorough understanding of Cash Management, Liquidity Positions and Liquidity Ratios
• Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing
• Tracked changes using Rational ClearQuest
• Assisted QA lead in developing quality procedures and ensuring that appropriate documentation is in place
• Conducted User Acceptance Testing (UAT)
• Participated in developing of Training Materials for the new technology and User Training
• Worked effectively with Project Manager in handling the whole project

Environment: SDLC, Agile Methodology, UML, Oracle, MS Project, MS Office.

Confidential, Westlake, LA

Systems Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Facilitated JAD Sessions and gathered Business Requirements
• Facilitating workshops, JAR/JAD sessions, during the inception of the new web based application for the Portfolio Information. Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Conducted user interviews, gathered Requirements, analyzed the Requirements
• Custom tools upgrade client had created marketing, merchandising, promotion and product tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Designed and developed project document templates based on SDLC methodology.
• Participated in various stages of data and requirement analysis for project needs.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.
• Used JAD sessions, and one-on-one meetings to identify business and System Requirements, and documented using Use Case Modelling, Process Flow diagrams and documentation.
• Developed business requirement specification documents as well as high-level project plan.
• Worked with Jira for defect management. Carried out UAT by developing test plans, test scenarios, test cases, and test data to be used in testing based on business and user requirements, technical specifications of the product.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts.
• Documented and delivered Functional Specification Document to the project team.
• Created new and modified existing reports using the Actuate Developer Workbench and integrated it with Siebel.
• Participated in the logical and physical design sessions, assisted and developed high and low level design documents.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Used CSS, HTML and Javascript for GUI front end designing and validations.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project

Environment: Quality Center, JDA MM, Oracle, Java, J2EE, MS SQL Server, CICS, Mainframe, DB2

Confidential, Hartford, CT

Business Systems Analyst

Responsibilities:

• Gathered Requirements from Users, Technical Team and Sales Executives.
• Interviewed end users (Underwriters and Agents) for gathering requirements.
• Gathered transactional information from the High Level Management and Technology Department.
• Prepared AS-IS PMS (Policy Management System) and to identify current functionalities for Quote, Submit and Issuance of Insurance Policies and TO-BE documentation.
• Conducted Various Research work on user enhancements.
• Review RFP responses and estimates from multiple vendors offering Policy Administration system (PAS), Claims & Billing modules in support of accounting, claims and underwriting departments
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Developed future-state high and low level process maps, new business rules, and application requirements collaborating with SME’s, stakeholders, and end-users
• Performed requirement sessions with Business users.
• Converted Business specifications in Functional Specifications.
• Identified opportunities for business process improvement and initiate efforts to make improvements.
• Eliciting and documenting user requirements for underwriting pricing/rating and submissions
• Responsible for requirement gathering of Policy rating process, endorsement and cancellation
• Identified various rating risk Factors as per a pre-defined set of rules and created process and data flow diagram
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Performed Business Process Modeling using Visio and customer data analysis.
• Conducted gap analyses to derive requirements for existing system enhancements.
• Design and develop the data load process using XML Style sheets and ACORD.
• Wrote test cases for functionality and interface validation.
• Prepared Test Plans and guidance for Assisting QA Team and its methodologies.
• Interacted with management, system analysts and technical developers for setting project goals.
• Created different Traceability views to maintain the Traceability of the requirements.
• Analyzed operating procedures and policies on an ongoing basis and recommended and implemented improvement plans where appropriate.
• Involved in UAT testing.
• Used Quality Center documentation management and defect tracking.
• Participated in Triage Meetings, weekly status meetings with IT and business people

Environment: Cognos, RUP, Quality Center, Oracle, UML, Acord, MS Visio, XML, MS Project, SQL

Confidential, Bensenvile, IL

Systems Analyst

Responsibilities:

• Analyzed the existing process and specific business rule logic will be applied in the ACP model.
• Created the T-SQL scripts for demonstrating the prototypes and for verifying the result sets
• Collected information and requirements about different Entities and attributes from FDS.
• Completed GAP analysis in detail on all entities in CCL for a source system.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Configured the Data mapping between Sybase and SQL Server 2005.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Extensively worked with T-SQL queries
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Provided data modeling support for numerous strategic application development projects.
• Documented the meeting minutes with issues of about discussed and solutions resolved.
• Completed the documentation of Claims Scenario's for the source system.
• Presented the mapping document with all business logic applied for the system to Project Manager.
• Gathered information and documented on Conceptual design and Technical design for phase III systems.
• Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
• Created the test cases for all the Use Cases using EA tool.
• Created test scripts for all the test cases in PL/SQL.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.

Environment: Quality Center, QTP, TOAD, SQL Developer, VB6.0, UNIX, HTML, XML, Oracle, Windows NT.

NSL Financial Group, Atlanta, GA

Business Analyst

NSL Financial Group is a full service insurance agency that offers auto, home, business, health, life insurance as well as many other insurance services.

Responsibilities:

• Performed overall business analysis and impact study to document the business lines.
• Involved in general functions to be supported by the project, enabling the client to validate cost and resource assumptions regarding the system.
• Supervised and managed projects from inception to implementation.
• Ensured that project management methodology was followed throughout the project lifecycle.
• Worked with Business Systems Analysts, Managers, IT professionals and Senior Management to ensure that projects scope and objectives are properly defined.
• Ensured the delivery of expected efficiency gains, revenue enhancements, increased customer-service levels and/strategic advantages.
• Participated in the development of project documents including: design specifications, use cases, project plans, status reports, etc. using established methodology.
• Prepared detailed implementation plan for the Project that included defining roles, responsibilities and milestones.
• Performed standard Management tasks including Performance Reviews, work assignment, and counseling.
• Led/participated in meetings at the operational and project level.
• Provided continuous feedback on project status; offering constructive options to ensure project tracks to original expectations.
• Identified resources and/or scheduling conflicts; change in project scope; function as an escalation point to keep all parties aware of overall project impact, facilitating management decisions at the earliest possible time.
• Assisted with the development of metric measurement and reporting to identify Change Management trends along with recommendations to remedy trending issues.
• Identified business risks and recommended options to business stakeholders for them to make sound business decisions.
• Translated Technology issues into business terms that can be understood by business managers.
• Developed overall aggregate planning to support aggressive growth targets.
• Developed and implement streamlined processes and key KPIs (Key Performance Indicators) to reduce cost and increase customer loyalty.
• Worked with business clients and other infrastructure groups to resolve business and systems issues

Environment: UML, Rational Rose, Rational Clear Case, MS Word, MS Excel, MS Visio, MS Project, MS Office

Nexstar Broadcasting Group, Inc, Irving, TX

Business Systems Analyst

Nexstar Broadcasting Group is a leading diversified media company that leverages localism to bring new services and value to consumers and advertisers through its traditional media, e-MEDIA, digital and mobile media platforms. Nexstar owns and operates programs in 64 television stations and related digital multicast signals reaching 38 markets or approximately 11.1% of all U.S. television households.

Responsibilities:

• Acted as a liaison between the business team and the technical team.
• Gathered requirements through elaboration workshops with SMEs, PM, and business experts (agents).
• Documented clear, concise detailed Business Requirement Specification (BRS), System Requirements Specification (SRS) documents and user documentation in accordance to guidelines and standard for developers to interpret, design and develop the application with minimum guidance.
• Developed wireframes and screenshots to get a thorough understanding of the Billing page, Claims Info page, Insured information page etc.
• Followed RAD methodology to develop and create prototypes for customer review and feedback.
• Conducted meetings, interviews and used questionnaires and survey methods to collect feedbacks and reviews.
• Performed Gap Analysis for the modules in production, and to get a better understanding of the features to be automated.
• Involved in the creation and maintenance of the workflow plans and artifacts.
• Developed business level and system level use cases to transfer knowledge to the technical team about the workflow/administration, policy tracking management and automation, internal and external communication features etc.
• Worked with the UI team to create the User Interface screenshots to be presented to the Business.
• Involved in walkthroughs and meetings with development team to discuss require, mts related issues.
• Examined, analyzed and modelled test plans, use cases & test modules and manuals for unit, integration, system, load (using Load Runner) and UAT testing.
• Assisted in creating test cases that included the functional aspect of the business process and also to validate the interfaces with the other systems and data conversion from the legacy system (mainframe).
• Developed diagrams in MS Visio to visually determine the proper structure, key elements and optimal design for database and to aid efficient creation of tables and stored procedures.

Environment: RAD methodology, UML, MS SQL server, MS Word, MS Excel, MS Visio, MS Project, MS Office..

UBS Financial, Weehawken, NJ

Business Analyst / Data Analyst

Worked as Business analyst with the projects in developing ACH, EFT, Credit card, and Debit card processing applications

Responsibilities:

• Worked as Business analyst with the projects in developing ACH, EFT, Credit card, and Debit card processing applications.
• Used RUP SDLC methodology in developing many systems including EFT and Credit Card and Debit Card processing system.
• Worked as senior Business Analyst in the project that built a Data Mart (DM) to be used to market and promote UBS Credit cards. This project was built using Informatica technology. SCRUM (AGILE) SDLC methodology was followed in building this Data Mart.
• Analyzed, profiled and scrubbed source data for EDW project.
• Assisted Database Administrators in understanding the requirement so that they could model the database that could produce all the information required to produce the BI reports.
• Designed screen and Built online customer information reconciliation system in order to remedy the discrepancies in customer data between UBS and its Credit/Debit card processing vendor (FDR). This required data to be fed to FDR system multiple times a day.
• Used Waterfall methodology and Agile SDLC methodologies like SCRUM, RUP in building users' required systems.
• Performed requirement gathering, prepared Business Requirement Document and Functional Requirement Document and took active part in analysis and design.
• Designed and managed Workshops in order to mitigate any confusion about system requirements, data base design and other system related issues.
• Worked as a Business Analyst in the project which built data reconciliation system between UBS and First Data (FDR). This system would identify any information inconsistency between UBS and its credit card transaction processing company FDR. Waterfall SDLC methodology was used to build this system
• Worked as Business Analyst for the project at UBS, which built an Enterprise Data warehouse for various reporting, data mining.
• Worked as business analyst in data base conversion project where data was converted from DB2 to ORACLE. This project required data analysis, data mapping, and data transformation. During the period through both the old and new.
• Developed and maintained applications for processing of Mutual fund transactions.
• Wrote SQL queries to extract, analyze and modify data in preparation of building Data Mart.
• Participated in conversion of main client data base from MODEL 204 to DB2. Project involved data analysis and profiling in order to eliminate any unnecessary and unusable data before it was converted to the new system. Process also required data to be mapped from the old to the new system.
• Prepared dataflow diagrams using Visio.
• Strived to make business processes more efficient by modifying and improving those.
• Worked as Sr. Business Analyst for the migration project that moved data from legacy systems like DB2 to Oracle.
• Participated in data base and application conversion at UBS whenever UBS would acquire a new company or had a contract to service client data base belonging to smaller brokerage firms

Environment: HTML, SQL, Windows, Manual Testing and MS Office

Health Net, AZ

Business Systems Analyst

I worked prominently on the Claim Adjudication System to build the pricing logic for the pharmacy claims of the members with more than one prescription drug plans. As a part of this project, the company was able to save substantial amount of money on the prescription drugs that were covered by third party plans (e.g. Medicare Part 'D')

Responsibilities:

• Modified and used Project Templates to gather the requirements and carry on the project.
• Facilitated the requirement gathering work sessions with stakeholders, SME's and Business owners to understand and in corporate the potential requirements in the BRD.
• Managed content of website by gathering information and integrating data from other departments.
• Coordinated the project team for JAD and BRD Sessions.
• Contributed in implementation of transition in accordance with HIPAA standards.
• Created 837(P, I, D) claims, and maintained data mapping documents in reference to HIPAA transactions primarily 837(P, I, D), 835, 270/271, 276/277 and 278.
• Worked on 837 and 835 projects, including syntax and business rules for X12 HIPAA 4010 and 5010 validation for loops, segments, elements, qualifiers and code sets.
• Perform ed System testing, Regression testing and UAT for several claim types and test scenarios.
• Compared and validated 5010 system test results with 4010 results for the same test scenarios.
• Executed Step-down testing from to validate the EDIFECS results.
• Created X12's for 4010 and 5010 standards to meet test scenarios.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed.
• Coordinated activities between business unit and technical staff, developed new methods, policies, and procedures to meet the business needs.
• Analyzed and translated business requirements into system specifications utilizing UML and Agile methodology.
• Prepared Functional Requirement Specifications (FRS) employing Use case scenarios, sequence diagrams, class diagrams.
• Identified and clearly defined functional issues and supported IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle.
• Documented the Requirement Traceability Matrix for tracing the Test Cases and requirements.
• Documented and assisted the QA Team with the Test Plan.
• Developed Data Conversion Strategy using ETL functions for converting data from the existing site to the new site.
• Assisted Project Manager to complete the project approval process.

Environment: Windows XP, UNIX, JAVA, Oracle, Test Director, Agile, JIRA, SQL, Web Services, XML, Ms Excel, HTML