SUMMARY

• Over 8+ years of experience as a Business Analyst with a solid understanding of Business Requirement gathering, Business Process Flow, Business Process Modeling and Business Analysis.
• Excellent experience in the business analysis and application development field with a commitment towards perfection in work entrusted upon and seeking professional excellence in all endeavor assisted by the right opportunity.f
• Strong analytical and logical skills combined with experience in various cycles of software development including development, testing, implementation and maintenance of applications.
• Proficient in facilitating large meetings to help define vision, scope, requirements, design, and risk mitigation plans.
• Full understanding of the SDLC: requirement analysis and business specification, development, enhancement, quality assurance, testing including developing Test Cases and Test Scripts. Experienced in conducting User Acceptance Testing (UAT)
• Excellent skills in Business Analysis, Data Analysis, Gap Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Well - versed in the documentation of, Business Requirements Documentation (BRD), Functional Specification Documentation (FSD), Current-State and Future-State Process Models, Performance Indicators.
• Exposure to Client/Server, Web Application developmental tools and Software development and design. Process/tools including Java, Oracle, SQL Server, MS Visual Basic, JavaScript, HTML, Microsoft Projecttools, Reporting tools, XML, Agile andf Rational Unified Process (RUP)
• Experience in solving complex problems, team coordination and motivation skills as well as the ability to communicate successfully across cultural barriers.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming, and Joint Application Development (JAD) sessions.
• Expert knowledge in with various capital market instruments and securities including Equities, Fixed Income Instruments, Risk Management (Credit and Market Risk)
• Expert at Risk Management by Risk Identification, Impact Assessment, Prioritization Analysis, Risk Tracking and Mitigation with monitoring of whole.
• Experience in various modules of AML such as KYC, Entity Resolution, Compliance Reporting, and Transaction Monitoring.
• Vast experience in performing SDLC tasks - Requirement gathering, Analysis, and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low-Level Design documents etc.
• Conducted GAPanalysis to capture functionalities of existing systems and analysis requirements of the proposed system followed various SDLC methodologies which include AGILEScrum, AGILE Extreme Programming, Rational Unified Process (RUP), Iterative, and Incremental and Waterfall models to execute the proposed requirements.
• Experienced in working with a Testing team, participated in writing Test Plan, Test Cases, Test Scenarios, RTM, Test Reports, and conducting various forms of testing, which include Integration Testing, Smoke Testing, Regression Testing.
• Lead JAD sessions with corporate tax department and all source system SME's and prepared FRS for FATCA Reporting project.
• Experience in Automation tools like Rational RequisitePro and Quick TestPro.
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying performance issues due to inefficient Database Administration.
• Strong knowledge of HL7, HIX (Health Insurance Exchange), EMR/EHR, Health Care Reform, and Patient Protection and Affordable Care Act (PPACA) and Facets.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Solid Experience in developing Scope/Vision Documentation and Project Plan.
• Excellent writing skills in generating, Project Charter, Project Plan, Business Requirements documents, Use Case Specifications Test Plan, Credit Risk Management Plan Liquidity risk assessment, and Publishing Regular Reports with status and metrics.

TECHNICAL SKILLS

Project Methodologies: RUP, OOAD, UML & Business/Data Modeling, ER modeling.

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Caliber RM, Enterprise Architect

Application Software: MS MSOffice suite, Rational Suite, MS Project.

Modeling tools: UML, MS Visio Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, User stories, JAD/JRP Sessions, Gap Analysis, Root Cause Analysis

Requirements Artifacts: BRD, SRS, Activity diagrams, Test cases, test plans, use cases, Use case diagrams, RTM

Quality Management: Dev Track, Bugzilla, Jira, Quick Test Professional

Defect Tracking Tools: Rational Clear Quest, Quality Center

Languages: C#, Java, HTML, .NET, XML

Web dev tools: Dreamweaver, FrontPage.

Databases: MS SQL server, Oracle 11g/12c, Oracle Clinical, MS Access

Methodologies: SDLC (Waterfall, Agile, Scrum), Six Sigma, RUP

Testing Tools: Test Director, Quality Center, Quick Test Pro, Load Runner

Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office

BI/ETL: Tools Informatica, SSIS, OBIEE 11g, Informatica Power Center, SQL * Loader

Operating System: Windows, Linux, Unix, Mac, Solaris.

Documents & Processes: SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process

PROFESSIONAL EXPERIENCE

Confidential, NJ

Business Analyst

Responsibilities:

• Reviewed, implemented, and maintained policies and procedures to ensure compliance with all federal (including FCRA, Fair Lending, OCC, and CFPB) and agency requirements.
• Develop a deep knowledge of the function including key driver goals, short- and long-term functional road-maps, key personnel, etc.
• Extensively involved in migrating the fields of financial instruments such as Fixed Income, Derivatives Securitized Products such as MBS on Trading Platform.
• The assisted development team in understanding various financial products and help them grasp the technicalities of Derivatives Analysis, Credit Derivatives and Fixed Income Securities, CVA/DVA.
• Performed SQL queries using TOADsoftware. Wrote SQL statements to extract data from the Tables
• Prepared for GAP Analysis; identified and documented improving areas to meet capital markets requirement regulations.
• Created test cases and provide testing along with coordinating UAT.
• Constant interaction with Capital Market business users for job shadowing, understanding certain issues which I need to deal with for completing Proof of Concept and BRD.
• Helped with Data Mapping between the data mart and the Source Systems.
• Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.
• Used MS Excel/Access VBA SQL to send system generated e-mails, manage and report embedded Excel documents.
• Built macros for updating customer orders in MS Excel Application.
• Responsible for taking requirements from business users, understanding Business Needs by scheduling a meeting on a regular basis.
• Involved in creating the Project templates, use case specifications, Change request form, functional specification documents, and Business Requirement documents.
• Mentor teams to effectively use agile ceremonies like sprint planning, daily stand-ups, and retrospectives and sprint reviews to provide working outcomes in every sprint.
• Designed and analyzed Business Process Model, HIVE Use Case model and test procedures based on agile methodology.
• Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, activity diagrams, sequence diagrams, object-oriented models using MS Visio.
• Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
• Conducted data mapping to collect and show relations between data from dashboard function to the ODS table on the PeopleSoft database, represented this mapping using ERDs, and Process Modeling DFD's on MS Visio.
• Proactively prepared scenario analysis of different product mix and identified the areas of improvement and solutions to meet the customer needs.
• Organized JAD sessions to flush out requirements, performed Use Case and workflow analysis, outlined business rules, and developed domain object models.
• Utilized Management Information Software (MIS) and Financial Accounting Software (FAS) that ensured daily balancing of accounts and vendor reconciliation.
• Designed, Developed and Supported Extraction Transformation and Load (ETL) Processes using Informatica Power Center 9.5 for data migration from source systems into the ICD 10 Data warehouse.
• Data mapping the data in the new system to match the table columns of the old system/ data warehouse.
• Acting as the single point of application engineering accountability for MDM project/program managers on assigned engagements.
• Support the global MDM team to ensure all regions are following the global process and achieving data quality metrics through regular meetings.
• Develop SQL and SSIS ETL business intelligence solutions, data wrangling, Hive, migrate disparate source data into a centralized data mart structure for HEDIS and SSRSreporting, SSIS flat file processing, advanced SSIS features for data mapping, data conversion.
• Designed stored procedures, triggers, and other SQL scripts to automate complex business rules and processes.
• Preparation and maintenance of Master Data Management (MDM) Process Guide.
• Studied existing KYC/CIP system and prepared test data for CDD and EDD based on inputs.
• Conducted multiple gap analysis against Basel II, II.5 and III rules. Validated the Basel II framework, including internal rating systems (PD, LGD, EAD models) and RWA calculation.
• Determination of customer's risk in terms of propensity to commit money laundering, terrorist finance, or identity theft.
• Subject matter expert for HL7, CDA, and FHIR interoperability standards.
• Subject matter expert on interoperability standards including Fast Healthcare Interoperability Resources (FHIR), Consolidated Clinical Document Architecture (C-CDA), HL7, ICD9/ICD10 coding systems.
• Determine the rules and workflows that define and monitor the process of creating, modifying, storing and deleting data for the Master Data Solution and audit data to ensure it is in accordance with the Master Data Governance program.
• Collaborate with business stakeholders to develop and document policies and procedures surrounding Data Governance.
• Develop best practices, standards, and methodologies to assist in the implementation and execution of Data Governance.
• Managed the project schedule and scope to ensure the project is delivered on time with high quality.
• Involved in Defect Reporting, Defect Tracking and in Preparation of Defect Report using HPQC.
• Wrote SQL queries to understand data relations and variances from other source systems.

Environment: SQL, TOAD, GAP, BRD, FATCA, Adobe Dreamweaver, HPQC, CIP, RWA, HP ALM Quality Center, MS Visio, BRD.

Confidential

Business Analyst

Responsibilities:

• Designs and develops the logical and physical data models to support the Data Marts and the DataWarehouse
• Reviewed the data model and reporting requirements for CognosReports with the Data warehouse/ETL and Reporting team.
• Involved in business process re-engineering, including gathering and documenting requirements, documenting workflows and developing specifications for the programmers
• Implemented and maintaining a successful billing process to ensure timely and accurate billing monthly.
• Build and manage the TGS partner team to ensure convergence and strategic partnering with each functional partner team
• Used Excel VBA/Macros, MS Access and SQL queries to make reports in different styles and then distributed them as PowerPoint slides to various level of management
• Meet with technical and business staff to document requirements and current processes for the data warehouse solution
• Managed all capital expense appropriations and budgets associated with data warehouse and Business Intelligence projects.
• Supervises a collection of activities and resources across data governance, quality, and lineage subject areas.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Review clinical data in the Cerner System to promote timely, relevant, accurate and consistent information use.
• Primary owner to develop / enhance the process to audit & measure the efficiency and quality of the MDM maintenance process.
• Guiding the application engineering team to translate Application Architecture deliverables into more detailed Solution Design Documents and the resulting build deliverables including significant amount of hands-on coding and code reviews.
• Performed testing for Medicare, Medicaid, and X-Over claims for the Medicaid Management Information System (MMIS).
• Assist in migration of MS Access Databases 2007 to SQL Server 2008 by using Import wizard and SSIS Packages in SQL Server.
• Developed macros for financial reports.
• Created macros for calculation of equity interest.8
• Development of Macros and Formulas in Excel 2007.
• Developed Test scripts for testing EDI transactions to run in different environments.
• Managed Electronic Document Management System (EDMS) for automating R&D and Regulatory document repositories for submissions to the FDA.
• Serve as subject matter expert and provide technical training on each of: FHIR, CDA, HL7, and medical terminology sets including SNOMED-CT, ICD-10cm, and CPT4.
• Interacted with the Development team to help write technical specifications to describe Functional Requirement Documents (FRD), Business Requirement Documents (BRD), design specifications and module specifications.
• Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Excel/Access/VBA.
• Implemented recommendations from the Basel Committee on Banking Supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel II
• Carried adjustment in operations of values of Credits, Debits, i.e. CVA/DVA, Fixed income security, and credit derivatives. a multi-organization effort to bring Fast Healthcare Interoperability Resources (FHIR) to full standard.
• Monitor performance and pricing levels of existing holdings relative to expectations and economic trends
• Analyze historical GSE loan level information and summarize frequencies / severities / losses by cohort and combine with other data sources to help risk takers understand drivers of frequency, severity, and final losses of GSE risk transfer
• Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on progress, issues, and deliverables of the project.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel, and Flat Files.
• Data mapping the data in the new system to match the table columns of the old system/ data warehouse.
• Develop SQL and SSIS ETLbusinessintelligence solutions, data wrangling, migrate disparate source data into a centralized data mart structure for HEDIS and SSRSreporting, SSIS flat file processing, advanced SSIS features for data mapping, data conversion.
• Designed stored procedures, triggers, and other SQL scripts to automate complex business rules and processes.
• Wrote, Reviewed and approved test plans, scenarios, scripts, and procedures.
• Performed Data mapping, logical data Modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Involved in Designing data models for Data warehouse supporting data from multiple sources in real time.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files to target OracleData Warehouse database.
• Apply medical necessity guidelines, determine coverage, complete eligibility coverage, and apply all cost containment measures to assist in the claim adjudication process
• Working in the Enterprise BusinessIntelligenceServices group, analyzing issues and new requests for the Enterprise Data Warehouse.
• Defined the duplication of data and columns between tables using TOAD and SQL.

Environment: : ETL, MS SQL, HEDIS, Oracle, Flat Files, XML Files, FRD, SSRS, SSIS, TOAD, SQL, CVA/DVA.