We provide IT Staff Augmentation Services!

Lead Business Analyst Resume

3.00/5 (Submit Your Rating)

NY

SUMMARY

  • Certified Scrum master and Business Systems Analyst and an IT professional seeking a senior level position specializing in Business Analysis, Project Management, Workflow Analysis, Agile, Process Improvement, Data Warehousing, and Operations. Solid background in elicitation and documentation of business requirements, functional requirements, and business workflows (Visio).
  • Domain knowledge of software development, HIPAA, Sales & Marketing, managed care, Mortgages, and all phases of teh systems development life cycle (SDLC). Experienced team leader and project manager - including leading cross functional business teams.
  • Detail oriented, organized, experienced in ReqPro, ClearCase, Documentum, SharePoint, Salesforce, FACETS, Scrum, TFS, Rally, JAD, SQL, Access, Caliber, Test Director, KANBAN, and all MS Office applications. Outstanding presentation and facilitation skills.
  • A functional leader in requirements gathering process using different elicitation techniques like end-user interviewing, GAP analysis, root causing analysis and RSQ(Requirement study questionnaire). Knowledge in BPMN (BPM 1.7) techniques (for modeling, rules definition, data use definition, data collection, process / workflow analysis and redesign, business operation testing, etc.). Set up RSA; Identify and develop 'To-be' business process models (BPMN 2.0) and business rule logic.
  • Identify and assess new and existing risk and elevate any concerns to Capital Markets Senior Management to mitigate bank exposure or potential loss.
  • Lead various process improvement projects wifin Capital Markets and ensure timely and accurate results of all project deliverables.
  • Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams using tools like MS Visio etc.
  • Solid working experiences on Healthcare Payer standards like HL7, CCD and FHIR, and Coding systems (e.g., ICD, CPT, etc.); ITIL certified; worked in Trade Life Cycle Management
  • Supported and coordinated system implementations through teh project lifecycle (initiation, planning, analysis/design, development, implementation, testing, rollout, and hand-over) worked wif other teams on a local and global basis; Knowledgeable experience in Guidewire Insurance Suite, Claims Center (CC)
  • STRONG KNOWLEDGE OF DOMESTIC AND INTERNATIONAL EQUITY AND FIXED INCOME PRODUCTS AND DERIVATIVES; EXPERIENCE IN REGULATORY CAPITAL OR LIQUIDITY REPORTING
  • Development of code using various ETL tools (Pentaho, ADF, Databricks, ServiceNow etc.) and BI Tools (Tableau) and review all teh code along wif unit testing; Experience in Adobe Experience Manager/CQ
  • Work wif DnA Analytics Center of Excellence (ACE) Core Product Managers, tableau dashboard/report developers, and Enterprise Information Management (EIM) data analysts;
  • Expert in Microsoft Dynamics CRM implementations (all modules) and integrations wif other systems from small to medium and large size deployments from project initiation to Post go - live including production support, SLAs, ticketing.
  • Experience in creating and modifying SQL reporting services reports for use inside and outside Dynamics CRM
  • Experience in Agile, Scrum Sessions and Sprint planning for different Product Backlogs.
  • Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are following teh Business requirements.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
  • Created Requirement Traceability Matrix (RTM) to ensure that use cases, test cases are being associated wif requirements; Prepared, arranged and tested Splunk search strings and operational strings.
  • Executed UAT by creating Test Plans, Test Scenarios, UAT sessions, Test data and executed for Validation.
  • Experience in working wif reporting tools like SAP Crystal Reports, Business Objects and IBM Cognos.
  • Excellent understanding in teh capital markets, finance markets, Derivative markets and money markets.
  • Proficient in using RDBMS such as Oracle, SQL Server, SQL, and PL/SQL.
  • Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
  • Extensive experience working wif Distributed Scrum Teams in managing and delivering outcomes for each sprint; 3C's (Card, Communication and Confirmations); used Python to develop ML AI algorithms
  • Extensive knowledge and understanding in Fannie Mae and Freddie Mac, TRID regulations, AML laws, OFAC, BSA, FINCEN, PCI-DSS, and HMDA regulations, FFS

TECHNICAL SKILLS

Methodology: Agile, Waterfall, Hybrid

Project management tools: JIRA, Azure DevOps, Rally

BI Tools: Tableau, Power BI, Crystal Report, XSL-FO, MS Visual Studio

Modeling Tools: MS Visio, Lucid Chart

ETL Tools: SSIS, Informatica Power Center, serviceNow, Splunk

Documentation Tools: SharePoint, Swagger, Confluence, Microsoft Teams

Web Technologies: XML, JSON, HTML, ServiceNow, Python

Integration Tools: HP ALM, Adobe Analytics, Target, Dynamic Media

PROFESSIONAL EXPERIENCE

Confidential, NY

Lead Business Analyst

Responsibilities:

  • My role was to understand teh current workflow and document teh workflow requirements for teh integrated product (Qforce). Intense workflow analysis to write both business requirements and functional requirements (use cases) for teh main flow Fast paced environment wif priorities changing constantly; set up RSQ
  • Created Mock-Ups and UML diagrams such as Activity flow diagrams, Orchestration flow diagrams and data flow diagrams before each sprint for smooth development and testing
  • Managed teh Requirements Traceability Matrix (RTM) using Excel to track teh bugs.
  • Worked closely wif different Finance stakeholders and Global Functions Technology teams to explore solutions for Capital Market and supported Partnership Accounting
  • Involved in data mining process during statistical data analysis on Capital Market solutions and operation.
  • Assisted AWS DBA in structuring teh inventory data through ETL process by pulling teh data from live database and loading it into data warehouse as per teh business requirement; assisted in data migration onto SaaS using ServiceNow model using JAVA; Maintained Consolidated Audit Trail to increase efficiency in Eligible security tracking; experience in debugging unit errors in JSON
  • Assisted teh dev team wif development of Credit risk and CECL models in form of REST APIs
  • Worked diligently on Change Request Management and performed Impact Analysis on teh same.
  • Solid understanding of teh existing SOAP and REST web services, REST APIs and request and response web methods, Client-Side Validation, Server-Side Validation and Database Validation for various functionalities of teh system; statistics using Python and OTC based derivative model development and implementation
  • Actively worked and documented in Data Mapping for various schemas like Star Schema and Snowflake Schema and Data Migration in AWS from OLTP to OLAP database, Documents Impact Assessment for proposed project
  • Used ServiceNow to process and catalog service requests
  • Created Test plans and developed User manuals for User Acceptance Testing and recorded teh bugs in Azure DevOps; Ability to write Unix/Perl scripts in JAVA
  • KNOWLEDGE OF US REGULATORY REPORTING FOR 15C3-1/15C3-3
  • Developed forecasting tools to analyze revenue variance, business pipeline for teh Hedge fund; Identified credit risk appetite for individual funds or groups of hedge funds wifin teh CS and legal entity policy framework
  • Defined and documented Sprint goal, requirements, issues and risks, and release process using SharePoint and Azure DevOps to track progress and promote accountability among project participants.
  • Implemented ‘Pair Programming’ in JAVA technique for much more efficient deliverables.
  • Monitoring of hedge fund client investment performance and financial condition
  • Appropriately assessed risk when business decisions are made, demonstrating particular consideration for teh firm's reputation and safeguarding its clients and assets, by driving compliance wif applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues wif transparency
  • Provided support to UAT and SIT testers to clarify requirements and determine whether a defect is a new requirement, or truly a defect; Flextrade, Fidessa; maintained FSOM
  • Developed, evaluated and documented specific metrics for management purpose. Trained Splunk security team members for complex search strings and ES modules; data structured on Python
  • Actively worked wif Residential Underwriter, Mortgage Loan Servicer, Credit Analyst, and Compliance Professionals to determine teh Business rules concerning Fixed-rate mortgage loan, Adjustable-rate mortgage loan, Government-Insured Mortgages, Jumbo Mortgages, and Conventional Mortgages

Environment: SAFe- (HTML/CSS, JavaScript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Office Suite, Azure DevOps, SharePoint, Tableau, Web Services, API, Microservices, AJAX, SOAP UI, Patient Access System, Document Management System, Payor Services, Enterprise Master Index, Flextrade, Fidessa, Investment Management, Aladdin, Bloomberg, FSOM, Excel, RSQ, RSA, QMS

Confidential

Lead Business Systems Analyst

Responsibilities:

  • Worked to promote transparency across Microsoft Teams and stakeholders by preparing Project Documentation like Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Release Notes, minutes of meetings (MOM) utilizing MS office.
  • Perform data mapping wif 3rd party vendor. In-depth analysis of complex financial system.
  • Assist in resolution of production defects and enhancements. Worked as Principal Business Architect/Principal Business Process Developer on Pega Business Process Model (BPM) for Healthcare Payer applications for Pegasystems.
  • SME for BCBS - Healthcare Payer Insurance, PBM- Pharmacy Benefits Management, HL7 (ADT, LAB, Radiology & Pharmacy) Messages and Medicare-D projects on Mainframes and Java environment.
  • Project based work designing and implementing Xerox automation workflow tools to significantly reduce throughput times by automating and consolidating manual processes Confidential client sites (mostly Medicaid/Medicare claims, crossover claims, MMIS), enhancing Commercial Insurance Management
  • Performed ETL/SQL jobs debugging and bug fixing while adding enhancements to teh existing ETL jobs as business demands; Monitored and managed ADT HL7 and CCD data feeds; ETL on ServiceNow to verify medical malpractices; developed performance models in Lights-On and implementation
  • Regularly interpreted and monitored departmental contractual compliance of government requirements (e.g., CMS, HIPAA, ACA) including determining teh business impact and managing teh collection and submission of required performance metrics and data reporting requirements
  • Experience on Splunk query language and Monitored Database Connection Health by using Splunk DB connect health dashboards.
  • Experience on log parsing, complex Splunk searches, including external table lookups, Splunk data flow, components, features and product capability
  • Filled in as proxy-PO in projects and applications as they move through teh process and post implementation; dis includes interface trouble shooting, vendor relations, issue tracking, communication to customers and opening incident tickets wif developers for problem resolution
  • Collaborated wif others, develops, publishes, and maintained intermediate queries and reports for daily, weekly, monthly, and quarterly use by utilizing data models and extracting data from multiple sources
  • Arranged Triage calls to work on defects and prioritize teh defects wif their mitigation plans wif teh team.
  • Designed Test Plans and Test Cases for User Acceptance testing (UAT) wif teh halp of QA teams.
  • Proficiency in writing complex SQL queries to extract and validate teh data from teh Eligible Members database.
  • Working extensively wif teh QA team to write and execute Test Plans, Test Scenarios, and Test Cases.
  • Used multi-tenant architecture ServiceNow to serve multiple customers
  • Prioritized risks based on their severity and impact on organization using ServiceNow.
  • Conducted User Acceptance Testing (UAT) in Sprint Review to confirm user stories are moved into Incremental Backlog; Jira monitored KPIs to assess teh team's performance every sprint
  • Ensured Project & JIRAartefacts are current; Managed active sprint(s) and backlog to ensure JIRA status is up to date
  • Attended teh Triage calls to identify teh defects to effectively log them and prioritize as per requirement.
  • Built over 50 + Tableau and PowerBI reports. And metrics in EDW, resulting in 20% increase in efficiency

Environment: SAFe- (HTML/CSS, JavaScript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Office Suite, Jira, Confluence, PowerBI, CMDB, API, Microservices, AJAX, SOAP UI, RESTful Services, MS 365, RxFlex, FFS, Excel

Confidential, Plano, TX

Senior Business Analyst

Responsibilities:

  • Facilitated various Scrum ceremonies and Adoption of Agile related techniques
  • Extremely proficient in EDI 834, 835 and 837 Claim Enrollment Transactions.
  • Worked wif complex datasets to investigate key business trends, performance, issues, and behaviors
  • Gatheird Business Requirements by using techniques such as document analysis, system analysis, one to one interview wif Business Users, Stakeholders, and Subject Matter Experts (SMEs).
  • Performed Requirement Analysis by gathering both functional and nonfunctional requirements based on interactions wif teh process owners & stakeholders and document analysis, represented them in Requirements Traceability Matrix (RTM)
  • Demonstrated strengths insupply chain planning, demand planning, supply network collaboration, sales and distribution, forecasting,inventory management, material management and transportation planning.
  • Providedtrainingto Supply Chain stakeholders - planners/schedulers/buyers. Evaluated actual vs SAP lead time data and put plan in place to reduce planning transit times in SAP, saving $4.5M (1.25% of on hand inventory). Created and analyzed what-if simulation scenarios, unennobling recommendations for higher service levels to key customers and for inventory savings across supply chain; Analyzed gaps in data flow between SAP, SPO

Environment: Agile- Scrum Framework- (HTML/CSS, JavaScript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Jira, Confluence, PowerBI, CMDB, API, Microservices, AJAX, SOAP UI, RESTful Services, SAP CPM, RxFlex, Patient Access System, Document Management System, Payor Services, Enterprise Master Index, Patient Billing Account Receivable FFS, SFTP, KAFKA, HP Quality Center, RCA, Excel, QMS

Confidential

Senior Business Analyst

Responsibilities:

  • Collected and documented business processes as well as business rules and performed GAP analysis
  • Researched, selected and implemented new barcoding PC’s to include ERP system and MO scanning. Responsible for vouchering and assigning invoices to proper account numbers and cost centers in ERP system for accounts payable.
  • Responsible for month end inventory analysis. dis included extraction of inventory values from ERP system while providing detailed information of dollar values for each inventory group to tan balance against teh general ledger.
  • Developed use cases, workflow, screen mock-ups, and functional and business requirements as per Commonwealth.
  • Interfaced wif business users extensively to prepare and update GDM MVP1 requirements
  • Performed data analysis and teh mapping of teh attributes between teh source system and teh target system
  • Ensured all artifacts complied wif corporate SDLC Policies and guidelines; ensuring data transmission wif Commonwealth
  • Implemented MRP auto generated purchase order proposals in ERP system by connecting purchased items wif suppliers
  • Responsible for coordination and maintenance of teh project change request catalogue

Environment: Agile- Scrum Framework- (HTML/CSS, JavaScript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SFTP, KAFKA, HP Quality Center, Commonwealth, FSOM

Confidential

Data Analyst

Responsibilities:

  • Gatheird Business Requirements by using techniques such as document analysis, system analysis, one to one interview wif Business Users, Stakeholders, and Subject Matter Experts (SMEs).
  • Worked to promote transparency across teams and stakeholders by preparing Project Documentation like (BRD), (FRD), (SRS), Release Notes, (MOM) utilizing MS office.
  • Worked very closely wif teh functional SMEs to make sure that teh project objectives are addressed accordingly.
  • Worked wif Data Warehouse team in developing and analyzing teh ER-Diagrams.
  • Identified and analyzed stakeholders and subject areas.
  • Identified and analyzed source data coming from Oracle, SQL server and flat files.
  • Preparation of reports and presentation to client.
  • Performed testing, knowledge transfer and assisted other team members.
  • Working knowledge in LIMS LabVantage Application

Environment: SAFe- (HTML/CSS, JavaScript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Office Suite, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SOAP UI, SFTP, KAFKA, RCA, QMS

We'd love your feedback!