SUMMARY

• Senior Business Analyst with Full SDLC and PLC experience as Business Systems Analyst, Business intelligence analyst, Functional Analyst, Requirements Analyst, Quality Assurance Analyst, Data Modeler, Usability Specialist and Technical Writer.
• Experience in working with clients such as Trading/Securities, Financial, Healthcare, Insurance, Energy, Retail, Ecommerce, and Clinical Domains/Verticals.
• Experience in working with Enterprise Data warehouse (ETL), Data warehousing 2.0, Business Intelligence, Business Analytics, Dashboards, EPM and BI 2.0.
• Experience with BigData, Good Data, Cloud Data, Web Services, Hadoop, NoSQL, Cassandra, MangoDB etc.
• Experience with BI tools such as OBIEE, Hyperion, Micro Strategy, SSRS, SAS BI, Actuate, SAP Crystal Reports etc.
• Worked with ERP/CRM such as Oracle R12 EBS, SAP and Salesforce.com.
• Experience in RAD, UML, RUP, Structured Systems Analysis and Design Method (SSADM).
• Experience in working with custom development & “Off the Shelf” apps configuration and customization.
• Ability to Define explicit and implicit requirements using UML(Use cases and UML diagrams), Use Cases, Case Models, User Interface designs, Current State Analysis, Process Modeling, Data Modeling, Paper Prototyping, GAP Analysis, UI Prototypes, Frameworks, Report Prototypes, Sitemaps, wireframes, “Day in the life of analysis” and copy decks using Rational Rose, Enterprise Architect, iRise, Caliber, HP Quality Center etc.
• Facilitated requirements gathering/JAD Sessions in compliance with AGILE and SCRUM methodologies.
• Ability to understand IIBA and Business Analyst Body of Knowledge (BABOK).
• Ability to research, analyze and translate complex business and technical information to Managers, CIO, Developers and Testers Confidential all verticals & horizontals.
• Experience with vendor management, RFP, RFQ, and RFI Processes.
• Experience with Change Management, Identity management, Issue resolution and Risk management Processes.
• Worked closely with development teams as business subject matter expert during Technical Design, Development, Testing, Deployment and maintenance stages of the project.
• Provided class Diagrams and ERDs in providing the Solution Designing.
• Designed Ecommerce P/Vortals, Client Server applications, Software Usability Analysis for new and existing applications.
• Used user centered approaches in analyzing user personas, information Architecture, Tasks, Scenarios to determine future state recommendations.
• Working experience with all stages of software development such as Legacy Systems, Mainframes, Macintoshes, Client Server systems, Virtualization, Cloud computing, Mobile Cloud, Grid computing, Web 2.0, Social Networking in compliance with RIM, SAAS, PAAS, IAAS, and ASP infrastructure.
• Complete Understanding of web Technologies such as LAMP, Cloud Computing, Flash, Flex, HTML5 etc.
• Working experience with Resource Management, Team Building, Project Plan, Budget Management and Cost Avoidance.
• Worked with SQL, PL/SQL, Joins, Sequences, Stored Procedures, indexes, views, Teradata, Data ware housing, xml, open standards, schema systems, openxml, SOAP, xhtml, tags, elements, attributes etc.
• Experienced in working with Client Facing, End User, in house, Near Shore and off shore development teams.
• Experience with Project Management, Scheduling, Budgeting, Estimates, ROI etc.
• Excellent Communication, Interpersonal, Consulting and facilitation skills.

TECHNICAL SKILLS

BA Tools: UML, OOAD, JAD, RUP, Rational Tools, Clear Case, Visio, ERWIN, Enterprise Architect

QA Tools: QTP, Quality Center, Test Director, JIRA (Incident Management)

Languages: C, C++, VB, ASP, C#, Pro*C, Java, Perl, SQL, PL/SQL

Prototyping: Photoshop, Dreamweaver, Flash, Drupal

Operating Systems: Sun - UNIX, Sun Solaris 5.6, Linux, Windows 95/NT/2000/XP/Vista/7, Macintosh, MS-DOS

Database systems: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000, MS Access, Sybase

Data Modeling: Erwin 4.0, Designer 2000, Star Schema, Snowflake Schema

Business Intelligence: Hyperion, OBIEE, Crystal Reports, Actuate, Clarity

Methodologies: OOAD, Agile, Scrum

SQL Tools: TOAD, SQL*PLUS, PL/SQL

Version Control: PVCS

Project Management: Change Point, Remedy, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Artesia, CA

Business Analyst

Responsibilities:

• Worked with Medicare, Medicaid, Duals, Hospice, LTSS, Vision, Dental, Pharmacy and behavioral health benefits.
• Developed solutions for Managed Care in association with state, federal and autonomous apex institutions such as CMS.
• Experience in conducting JAD Sessions, Collecting requirements related to 834, 837, 835, 276, 277, 834, 820, 270, 271 Transactions and developed UI and Business solution design for various healthcare projects.
• Implemented Healthcare Enterprise Core Administration Platforms such as FACETS and Electronic Health Record & Practice Management applications such NEXTGEN.
• Also involved in migrations and customizations of these systems.
• Actively involved in designing the Enterprise data ware house.
• Designed and Developed Self Service hosted Business Intelligence reports.
• Provided usability documents, Software Design Documents (High Level/Low Level), Technical Specification Documents etc.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Customized OBIEE Styles, Skins and Messages as per the client requirements
• Designed MemberHierarchy to generate reports on the Region/Country/Time zone.
• Exposure to RPD Development,, Filters, Prompts using Oracle BI Administration, Oracle BI Answers and dashboards.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Worked on integrating and configuring BI Publisher with OBIEE in multi user environment.
• Configuring iBots to deliver notification alerts, scheduled weekly reports, content based analytics etc.

Environment: OBIEE 11g, BI APPS 7.9.6, SQL Server 2008, SSIS, SSRS, SSAS, SharePoint, OBIEE, NextGen, Facets, Access Express etc.

Confidential, Pasadena, CA

Business Analyst

Responsibilities:

• Implemented large scale healthcare claims processing systems such as Medicare/Medicaid developed with HIPAA standards.
• Analyzed business requirements, suggested most effective database solutions to fulfill those requirements, setting up access methods for data (view, APIs etc), management of Reference data, creation and maintenance of reference / test data scripts. Performed code reviews.
• Created Case Models and UI using iRise and Enterprise Architect.
• Creation of data models(ER Diagrams) for online and warehouse applications (ODS) and work with DBAs to physical data structures.
• As part of Enterprise architecture team, creation of enterprise wide database design standards, processes, database solutions, creation and maintenance of enterprises data models and process models. Creation of reference data management strategy, Enterprise architecture governance strategy, creating business process models.
• Maintaining HIPAA Protocols and maintenance and communication standards and protocols.
• Data model & Data Warehousing experience in Architecture, design, OLAP, DSS and reporting. Infrastructure set up, Analysis, Conceptualization, Design and Development, Mentoring, Discoverer, Star Schema, Snow Flake schema, Slowing Changing Dimensions Type1, Type2, Facts, Dimension tables, Bill Inman and Ralph Kimball approaches, Data marts etc.
• Upgrading 4010 documents to 5010, and familiarity with HIPPA/EDI Standards EDI Health Care Eligibility/Benefit Inquiry documents such as 270, 271, 276, 277, 278, 835, 834, 820, 997
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, dashboards, and star schema modeling.
• Modeled analytics repository (rpd) with logical dimensional modeling using star schema.
• Exposure to OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Modeled Time Comparison and calculation measures in the business model using Time series wizard and modeled slowly changing dimension data.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Designed dashboards by appropriately including guided navigational links and drilldowns.
• Exposure to Mappings, transformations such as Unconnected/Connected lookups, Router, Aggregator, Joiner, Stored Procedures, creating indexes, aggregate tables, materialized views etc.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs.
• Revenues and customer relationship manager to analyze the Forecasted item statistics for different campaigns, Customized pre-built dashboards.
• Designed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Involved in Migration, UAT, Go-Live, and Production Support.

Environment: UNIX (Sun OS 5.9), Oracle Applications R12/11i (GL, AP, AR, PA), OBIEE 10.1.3.4, BI APPS 7.9.6, Seibel Analytics (Financials, Order Management, Project Analytics), Erwin, Pro*C, Visio, SQL Server, MS Office, Team Play, ARIS Business Designer, Rational Suite, Rational Clear Quest, Rational Requisite Pro, Workday HCM, Oracle 10g Database, Oracle Designer (10g or CASE), TOAD, PL/SQL, SQL, Confidential DB2, ZOS, SAS, LoadRunner, Sharepoint, People Soft, Telelogic System Architect (Process Models), MS Office Visio2007, CVS (Source Control), Siemens OAS, OAM, Java, Stored Procedures etc.

Confidential, Baltimore, MD

Business Analyst

Responsibilities:

• Gathered, Documented, Analyzed, Participated, Managed, Validated complex Business requirements & Functional specifications in migrating data from existing SAP ECC 5.5 system to the newly implementing Oracle R12 ERP system.
• Dedicated to Business Analysis, Quality Assurance practices such as agile process, daily scrum, iteration review and planning meetings.
• Worked extensively with SAP Business Objects and Oracle ERP, OBIEE and Hyperion.
• Developed Preliminary project plan, Project work Breakdown Structure (WBS), project timelines, project analysis, impact analysis and risk Analysis on project plans, methodologies, resources and participate actively in their implementation.
• Gathered and validated requirements from Joint Application Development (JAD) sessions with Business Units to ensure Legal and Audit Compliance with Logistics, SCM and Ware House Management modules.
• Created User Interface Prototypes, Business Use Cases, System Interface Documents, Business process design, process flow diagrams, Information Mapping Diagrams, Functional Specification Documents (FSD), Software Requirement Specification Documents (SRS), Software Design Documents (SDD), Input Process Output (IPO), Context (Business and Design), Vision, Traceability matrix, Use case diagrams, Activity diagrams using Rational Unified Process(RUP) artifacts with Agile team SDLC.
• Involved in JAD sessions in implementing Smart Meter & Smart Grid systems.
• Designed Static and Dynamic variables, Initialization blocks for Session variables, which are used for authentication and security.
• Designed Dashboard pages such as AR Balance, Payments Dues, Invoice history and All AR Transactions in Receivables Dashboard using Hyperion and OBIEE with what if analysis.
• Designed and Developed OLAP cubes for the Financial Dashboard such as General Ledger, Payables, Receivables and Profitability etc.

Environment: OBIEE 10.1.3.4, BI APPS 7.9.6/7.9.5 , Toad, Micro Strategy, Infor HCM, EPM System 11, Hyperion Essbase11.1, Hyperion Planning 11.1, Smart View, Analytic Hyperion Reports 11.1, Hyperion Workspace 11, Hyperion web analysis, Hyperion BI+ system 9, Hyperion Financial Management 9.3.1,Hyperion Workspace 9.3.1,Hyeprion Shared services 9.3.1,Oracle 11i, Oracle Data integrator 10.1,Sql server, VBA script, MS-Excel, MS-Access. FDM 9.3.1, MDM, Oracle Financial application, SAS, Microsoft Excel 2000, ColdFusion, Windows 2003 Server, HP-UNIX.

Confidential, Newark, DE

Business Analyst

Responsibilities:

• Made detailed Functional, business and technical analysis and developed web interfaces for ETSF (Electronic Trade Submission & Fulfillment) System. (Products include Equity Trading/ Equity Settlement - including Order Routing, Trade Matching and Confirmation for Stocks, and Trading / Matching strategies - Limit Order, Market Order, Stop Loss Order).
• Immense working knowledge and experience with Equities (Stocks, Warrants, ETF, Equity Linked Notes), Futures(Equity Futures, Index Futures, Commodity Futures, Forex Futures), Options(Equity Options, Index Options), Fixed Income (Municipal Bonds, Munis, Treasury, Repos, Caps and Floors, MBS, ABS,CDO, CMO, CLO, CBO, CDO, Convertibles), Derivatives and Swaps (Interest Rate Futures, Interest Rate Swaps, Equity Swaps, Credit Default Swaps, Total Return Swaps, Credit Linked Notes, Swaptions, VIX), FX (Euro dollar Futures, Cross Currency Swaps, FX Futures, FX forwards, FX Options, Currency Forwards, FX Futures), and Money Market securities, Spots, FRA), Credit Products (Credit Default Swaps, Total Return Swaps, Credit Linked Notes, Collateralized Debt Obligation, Credit Indices/CDX/iTraxx, Caps/Floors and Swaptions, Asset Backed Securities, Floating Rate Notes) for re-engineering Trading/Investments workflow with MS Visio.
• Documented detailed Business Requirements (BRD) for the complete life cycle of the Asset Allocation, Investments/ Trading (Trade Capture/ Blotter, Valuation with FinCad XL, Trade Execution, Deal Management, Margin Management), Operations (Netting, Collateral Management, ISDA Confirmations/ Affirmations, Recovery, Settlement and Reconciliation in Smart Stream)

Environment: Business Objects, Erwin, Visio, Oracle 9i, teradata, UNIX (Sun OS 5.9), PeopleSoft¸ RUP, UML, Windows 2000/2003/XP, MS Project, Word, Excel, PowerPoint, Rational Rose, Requisite Pro, Java script, Ajax, ColdFusion, Lamp, HTML etc

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Produced High level Design and Low Level Design of solutions detailing exact functional and technical requirements against respective needs detailing exact Configuration / Database changes required to address various business functionalities and changes.
• Customized eCommunications, eChannel and eSales application for Order Management and Service Management application to in corporate unique business rules of online business and interactions with backend systems.
• Customization includes creating new or modifying the existing/vanilla business components, applets, business services, workflows.
• Designed and driven the implementation of common validation business services, which are reused in various channels of the business Web, eCommunications, and XML BB channels.
• EAI, Web Services, MQ and MS SQL scripts were used to communicate with other systems for order progression and processing.
• Created a detailedproject planwith well defined tasks, milestones, signoffs & specifications.
• Identified risks and defined appropriate mitigation strategies.
• Monitored weekly status to track the Target Vs Achieved performance.

Environment: Siebel Analytics, UNIX (Sun OS 5.9), Erwin, Pro*C, Visio, MS Office, Team Play, ARIS Business Designer, Rational Suite, Rational Clear Quest, Rational Requisite Pro, Oracle 10g Database, Oracle Designer (10g or CASE), TOAD, PL/SQL, SQL, Confidential DB2, ZOS, Unix, Telelogic System Architect (Process Models), MS Office Visio2007, CVS (Source Control), Java, Stored Procedures etc.

Confidential, Manhattan, NY

Business Analyst

Responsibilities:

• Project to test and validate the brokerage system components affected by changes of requiring to support valid short transactions and short positions on Confidential Type 2 margin accounts
• All the components including Accel trading platform, Fidessa OMS, Wash Manager, Intact agent, BPSA SOD and Real time agent, Portfolio Manager (for rebate processing and interest calculation), RBC Prime blotter processor, RBC Prime trade entry GUI, Prime transaction and validation manager, Anvil Rebate system, Axiom RiskMonitor system, Utopia Collateral & Margining system, Prime report manager, Advent P&L manager, PB Direct, are validated and tested affected by consolidating short transactions in ADP type 2 accounts, BNYM Workbench
• Wrote use cases for unit testing of trades flow for BPSA (ADP through Intact), Trade Entry screenand SODbatch
• Prepared project plans, work breakdown structure, schedule, cost and other project related documents including requirement traceability matrix.
• Conducted JAD sessions with treasury product and ACH SMEs, vendors, users, PMO and other stakeholders and monitoring for open requirements and pending issues.
• Restructured business workflows to enhance applications’ capability to meet business needs.
• Managed a team of associates for software development and QA in .Net based web technology leveraging agile scrum development methodology.
• Oversaw offshore shared technology resources for release and implementation activities.

Environment: Micro strategy, Erwin, Oracle 9i, UNIX (Sun OS 5.9), Unix, Windows XP, RUP, UML, Windows 2000, MS Project, Visio, Word, Excel, PowerPoint, Rational Rose, Requisite Pro

Confidential, Poughkeepsie, New York

Business Analyst

Responsibilities:

• Developed and maintained Point of Sale terminal applications, user interfaces according to end client specifications.
• Worked with Systems Analysts who in turn certify all new applications and equipment.
• Provided 4th-Level technical support for product troubleshooting.
• Facilitated JAD session with external clients and internal development teams, in order to develop artifacts to support the development and implementation of Enterprise Architecture, Business Transformation and systems development.
• Used Business Applications Oriented Modeling (BAOM) approach to define artifacts, which include UML Use Cases and UML Diagrams (Use Case, State, Activity), Business Process Models, Data Models(Class Diagrams), Data Dictionaries, Report Prototypes, Functional Requirements, Non- Functional Requirements, Gap Analysis, UI Wireframes, UI Specifications, Site Maps, “day in the life of “ analysis, and Copy Decks.
• Reservation application analysis and development, Release Management, enhancements, Troubleshooting, testing, configuration, implementation, Joint Application Development (JAD), Walkthroughs and Review meetings with Project Manager, QA Engineers and Development team.
• Used PVCS Dimensions Process Modeler for adding users and roles into Oracle database.
• Used Tivoli Information Management for z/OS to report, track, monitor and resolve problems detected in the data processing environment.
• Documented all system changes and request for user access using Change Management Forms in the SharePoint document library.
• Worked in various ERP implementations for Confidential clients.
• Worked with development and support teams to implement SAP, Oracle Financials and PeopleSoft for Confidential retail clients.

Environment: VC++, C++, RUP, UML, VISIO, Oracle, DB2, SAP, Visual Basic, Java, ASP, C#, PVCS Dimensions, UNIX, Windows XP, z/OS, Tivoli.