SUMMARY

• 7+ years of professional experience as a Business/System Analyst in Finance/Banking/Healthcare and Retail domain.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• Strong experience in RUP Business modeling process.
• Expertise in UML (class diagrams, object diagrams, Confidential Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Well versed wif client server environment and tools like SQL Loader, UNIX shell scripts and TOAD
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Proven success as a business analyst through teh years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Met wif various HMO, PPO, Medicaid/Medicare, and Tricare / Campus Representatives discussing benefits of contracts on behalf of facilities or appeals from denials and compliance issues.
• Hands on knowledge of various Health Care standards/requirements like HL7, CCHIT, Meaningful Use & Stimulus Program, HITSP, PQRI, HIE, CQM, EHR, DICOM, ISO, IEEE.
• During teh transition, all types of testing was performed on different types of benefits and various healthcare plans offered by GHI Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for teh Web Applications
• Performed impact analysis for deadliness of ICD-10 conversion.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.

TECHNICAL SKILLS

• OOAD (OOA/OOD)
• RUP
• UML
• SDLC
• Waterfall
• QA
• WAP
• CVS
• TEAMMATE
• MS Access
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• DB2. Windows basic UNIX
• HTML basic DHTML basic XML
• MS Office Suite-Excel Macros
• Project
• Visio
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Rational XDE
• DOORS
• Cobol
• RequisitePro
• Websphere
• CaliberRM
• VB.Net Crystal Reports various NIKU products
• C
• C++
• J2EE
• Sharepoint
• Docushare
• BASIC
• Intermediate level-Visual Basic.

PROFESSIONAL EXPERIENCE

Confidential, San Franscisco, CA

Business Analyst

Responsibilities:

• Gathered Business Requirements. Interacted wif teh Users, Designers and Developers, Project Manager and SME’s to get a better understanding of teh Business Processes, and Analyzed and optimized teh process.
• Utilized Commercial Lending banking application and was responsible for teh design and process flow of teh system.
• Worked wif front office and back office teams in teh LOS side, alos was invloved working wif credit analyst in determining teh requiremnts for LOS.
• Analyzed requirements for loan request, loan process, member services, processing and portfolio management.
• Worked on sharepoint implemetation for teh loan system.
• Worked wif different modules for Pre Approval, Application, Pricing, Processing, and Closing of teh Loan.
• Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations
• Worked extensively wif Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
• Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
• Held and attended presentations and meetings to coordinate efforts among all teh groups, leading teh inception phase.
• Performed GUI Test, System Test, web design implementation, User Acceptance Test (UAT), Compatibility Test and Performance Test.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Prepared Business Requirement Document and tan converted business requirements into Functional Requirements Specification and Technical Specification using Rational RequisitePro.
• Identified Use Cases from teh requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Web Page Mock-Ups using Rational Rose and MS Visio and thus defining teh Business Process Model and Data Process Model.
• Performed manual testing on Admin, Authorization, Closing and Funding modules of teh Loan Origination System. Formulated a Test Plan and Test Cases that comprehensively tested these critical aspects of teh loan life-cycle.
• Creating and maintaining teh Traceability Matrix of scripts that needed remediation as part of teh data conversion effort.
• Validated XML schema and inserted check points for various tags in XML.
• Involved in assisting teh development of functional requirements, static testing teh applications by preparing and developing teh Test Plans and Test Rules, editing and writing Test Cases, Test Scenarios and Test Scripts.
• Executed teh test cases manually for various job submissions in batch processing by using teh Quality Center.
• Did teh regression testing using pre-existing test cases besides integration testing of various modules of teh application.
• Prepared Functional and Behavioral document that describe teh detail design of teh application.
• Used teh Unified Change Management (UCM) tool, Rational ClearQuest to maintain and track teh stakeholders requested enhancements and changes.

Environment: RUP, Rational Requisite Pro, IBM Rational, J2EE, Clear case, Sharepoint Clear Quest, Data warehouse, UML, Oracle, SQL Server, Unix, XML, MS Project.

Confidential, Chicago,IL

Business Systems Analyst

Responsibilities:

• Conducted weekly meetings for deciding teh Policies and Procedures to be followed while constructing new sites.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all teh impacting projects and updated teh documents based on recommendations (if any
• Involved in teh full HIPAA compliance lifecycle from Confidential analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.me.D) to identify key data set elements for designated record set. Interacted wif Claims, Payments and Enrollment hence analyzing and documenting related business processes.
• Coordinated testing for contract set-up, enrollment and claims processing for four new managed care contracts for Medicaid mental and physical health providers.
• Involved in intensive system level testing of analyzing teh HL-7 messages coming out and in of EPIC Bridges.
• Responsible for teh mainframes that receive teh HL-7 message in pre-approved format from teh middleware as disclosed in teh documentation.
• Researched and documented data variances reported by managed care contractors
• Reverse engineered processes where no documentation for system existed.
• Defined test cases for provider updates from legacy flat-file system to FACETS database system.
• Forecasted for aspects of project management, including Resource Planning, Work Flow, and Timeline Management. Analyzed Project Risks during execution phase & took corrective actions based on teh Mitigation plan
• Centers for Medicare & Medicaid Services (CMS) to perform Medicare entitlement data exchanges for our FEP Members (Federal Employee Program).
• Consulted wif healthcare third-party Administrator Company to develop conversion specifications for member, enrollment, and authorizations.
• Understand backlog tracking, burn down metrics, velocity, and task definition
• Well versed in working in Matrix organization & Functional organization
• Reviewed extensive SQL Queries wif complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.

Environment: Windows, Oracle, SQL, Websphere, Sharepoint, Microsoft Office suite, Microsoft Visio, Clear Quest, Rational Unified Process (RUP), RequisitePro, Clear Case, UML, SAS

Confidential, New York, NY

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed teh feasibility of their needs by coordinating wif teh project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• Prepared Business Requirement Documents (BRD’s) after teh collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into teh Data Marts.
• Collaborated wif Basel II team on credit risk and market risk analysis and issue resolution.
• Communicated teh implementation of teh new calculation framework of Risk Weight Asset under Basel II
• Prepared for Confidential Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Gathered requirements for credit risk, operational risk and market risk management
• Worked closely wif. Standardised Approach and Foundation IRB (Internal Ratings Based) Approach for Credit Risk
• Involved in putting together QRM (Quantitative Risk Management) models for risk-weighted calculations
• Worked wif Disclosure requirements as per Pillar 3
• Gathered architecture specifications for second pillar dealing wif teh regulatory response
• me was responsible for indexing of teh tables in that data warehouse.
• Reverse Engineered teh existing ODS in to Erwin.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured teh Data mapping between Oracle and SQL Server 2005.
• Tested Performance & Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• Manage Scope and change throughout teh SDLC process of teh product.
• Used Data warehousing for Data Profiling to examine teh data available in an existing database.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagr ams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in teh Documents.
• Assisted to develop teh Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Sharepoint, Oracle, SQL, SQL Server, Sybase, IBM Websphere Business Process Modeller, MIS-IP, ACORD, XML, Business Objects, TestDirector

Confidential, New York

Business Analyst

Responsibilities:

• Helped Project Manger in project design and project plan using teh RUP Methodology.
• Involved in project management using MS Project.
• Performed daily in-depth analysis of critical stakeholder accounts experiencing product issues to proactively identify andtriageincidents for defect assignment.
• Advised on capturing teh additional data requests from teh ODS Performed business process mapping for new requirements.
• Involved in Business Intelligence reports development efforts by working closely wif Microstrategy, Teradata, and ETL teams.
• Expert Variant Configuration skills wif excellent integration skills to Sales and Distribution (SAP SD), Materials Management (SAP MM) and Production Planning (SAP PP) wif rollouts and implementations.
• Experienced in SQL, PL/SQL, HANA SQL Script, Stored Procedures.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Experience wif Data Analysis using Oracle as a backend and TOAD as teh querying interface.
• Extracted data from Oracle database wif MS Access, and performed SQL query, data analysis and verification.
• Performed extensive Requirement Analysis including data analysis and Confidential analysis.
• Advanced ad-hoc and standard report development, including data analysis through teh use of Oracle Discover, Business Objects, TOAD, Erwin, Excel, Access, SAS, SPSS, SQL, and Oracle Reports.
• Worked wif Data Warehouse in teh development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Skilled in Data Quality, Master Data Management, Business Systems Analysis, Data Governance Framework, Business Intelligence, Data Warehousing, Data flow analysis, Process flow analysis and mapping, Data Profiling, Data Mining, Data Integrity.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh Oracle database.
• Designed, developed and tested data mart prototype (SQL), ETL process (SSIS) and OLAP cube (SSAS) for Computer Maintenance Management System (CMMS).
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Conducted JAD sessions wif supply chain management and development team to brainstorm Point of Sale (POS) and Inventory Management and Order Management System (IOMS).
• Responsible for implementing supply chain and operations solutions in teh exploration & production lines.
• Escalated unresolved issues toJDASupport and published ideas in Supply Chain Ideas community.
• Supported teh supply chain activities including teh warehouse management (Manhattan WMOS), RF devices - (StayLinked and Avalanche).
• Created workflows on populating metadata for existing and new GIS Data, Minimum metadata required by vendors. Change Control Process - Led teh Change Control Process for changes submitted for teh BRD once teh document was submitted to IT department.
• Worked closely wif teh Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support teh business requirement and process.
• Used teh DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Used MS Visio to create Business Flow Diagrams and Work Flow Diagrams
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams using Object Oriented Design (OOD) concepts and UML using Rational Requisite Pro.
• Worked wif an information architect to create and develop wireframes and mock-up screens for teh UI.
• Tracked defects using JIRA and assisted QA teams to resolve defects.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.

Environment: Windows, Oracle, MS Access, Rational Rose, Requisite Pro, Clear Quest, RUP, UML, MS Visio, Test Director