Lead Business Analyst Resume
NC
SUMMARY
- 10 years of experience as a Business Analyst in writing detailed business/functional/ technical requirements ranging from minor to major developments. Expertise in writing user guide documents for the UI based applications.
- 6+ Years of experience as Lead Business Analyst and managing the team as primary contact to the Business from AML / Fraud IT stand point.
- Successfully executed 3 Major counter Fraud projects as a lead business analyst with through understanding and integral need for early detection in process ofpreventing and mitigating drastic damage
- Extensive strength on BAI and SWIFT Message Formats (MT103, MT110, MT202 etc) for SAM processing with through business knowledge.
- Expertise in managing and executing more than one project at same point, with tight deliverable deadlines.
- Thorough understanding of Software Development and Business analysis methodologies with strong knowledge in different SDLC methodologies like Water Fall, Agile Scrum and RUP Software Development Methodologies.
- Proficiency in interacting with Client and IT Representatives and delivering high - quality and cost-effective solutions that meet the business requirements of the end users.
- Good understanding of Hadoop Architecture and underlying Hadoop framework including Storage Management.
- Experience in analyzingdatausing HiveQL and Used Spark API over Cloudera to perform analytics ondatain Impala
- Experience building Splunk reconcilement Dashboards.
- Expertise in analyzing vendor products to meet the business requirements. Solid experience in providing Clear Choices based on Capabilities and Cost Analysis for each Vendor.
- Thorough participation in Project Initiation with proficiency in conducting Feasibility Studies, providing Cost Benefit-Analysis reports and developing Business Cases to deliver various business solutions.
- Supported Counter-Fraud teams by integrating call center, web and mobile data for real time Fraud event monitoring
- 2 years of experience in successfully adopting and implementing modern Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications
- 3+ years of working experience inBI Tools such as Oracle OBIEE, Cogon’s where by writing report requirements with mockups, mapping, business definitions and validating Usability.
- Extensive understanding on messages generated by Vendor products like Transmit Security, Click to Call, MNO, PinDrop and IVR for Client experience and authentication.
- Expertise in Requirement Elicitation with respect to discovering user requirements by conducting Client Workshops, Joint Application Design (JAD) sessions, Brainstorming sessions and documenting them in terms of preparing the Business Requirement Document (BRD) and Functional Specification Documents (FSD) by capturing User Interface Screen Layouts and presenting various UML diagrams.
- High Aptitude and working experience in performing Structured Query Language (SQL) queries with good performance for the purpose of handling Database Extraction and conducting Data Management, Validation, Mapping, Analysis and Reporting. Had better understanding on stored procedures.
- Expertise in Coordinating bi-weekly inspection and walkthrough meetings and extensive hands on experience in giving presentations using Microsoft power point to make things easy.
- Conducted Gap Analysis with respect to the business rules, user requirements and system process flows as part of the assessment of the current and future application systems.
- Sound Knowledge of Data Modeling with respect to identifying Data Entities, defining Data Attributes and Relationships while validating Data Quality and designing Entity-Relationship diagrams.
- Expertise in designing different prototype and mockup screens using VBA Excel, C#.net Sound knowledge in Microsoft PowerPoint.
- Experience in designing Test Plans, Test Strategies, Test Cases and proficiency in conducting User Acceptance Testing (UAT) of systems and application/bug fixes and development
- Proven Expertise in using Test Management tools ( ALM) to identify, manage and log defects.
- Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
- In depth knowledge in implementing AML rules against Insurance line of business
- Sound business and data knowledge in Whole Life, Term Life and Annuity line of business
- Developed Business Use Cases for Risk Management application
- Extensive knowledge on end to end Insurance applications
- Undergone various trainings on Insurance with respect to Insurance Basics, Claims handling
- In-depth knowledge in AB&C (Anti-Bribery and Commission), KYC (Know your Customer), AML (Anti-Money Laundering) Models and Sanctions screening process. Strong Knowledge on BAI files and SWIFT message Format WIRE, ACH, MI and MT110 data behavior.
- Understanding of U.S Treasuries, Mortgage Backed Securities, Asset Backed Securities, Whole Loan Mortgages, IO PO debt structures, Bond Valuation, Risk Metrics for Bonds including Duration, Convexity, Repurchase Agreements, Commercial Paper
- Strong experience with Credit Risk and analysis of Market Risk, Operational Risk in addition to knowledge in relevant Regulatory Policies
TECHNICAL SKILLS
Operating Systems: Windows 2000/XP/7, UNIX, MS-DOS, Mac-OS
RDBMS: TOAD, MS-SQL Server, Oracle PL/SQL, DB2, Sybase, MS-Access
Languages: SQL, Java, HTML, XML, C, .NET, Visual Basics(VB Script), Oracle PL / SQL
Tools: Actimize, Mantas, PinDrop, Transmit, Hue (Hive/ Impala),Splunk, Spark, Quality Center, Rational Clear Quest, Rational Rose, SQL DBX,PL/SQL, SQL Developer, MS-Office Tools, Cognos, Crystal Reports, Business Objects, MS-Visio, OBIEE, Information Analyzer, ALM (Alias QC)
PROFESSIONAL EXPERIENCE
Confidential, NC
Lead Business Analyst
Responsibilities:
- Acted as a lead BA with through knowledge on counter-Fraud requirements with indepth knowledge on data governance.
- Worked closely with the development teams and project managers to coordinate the work effort and timelines along with business / audit data needs.
- Developed different artifacts like Business Requirements, Data Discoveries and Play Books for data controls
- Played multiple roles for different projects simultaneously to meet highly tight deliverables with no compromise
- Worked closely with Hadoop/ big Data implementation team by providing flat file structure and got to know different key components like Kafka etc
- Documented different data discoveries for projects like Transmit Security integration (OTP, Plan Focus etc), PinDrop, Audit DB and MNO
- Created documentations for Oracle to Hadoop conversion process for all the sources currently exist in Oracle DB
- Extensively worked on Splunk for analyzing the data and also generated some reports in splunk with realtime data for Fraud analytics team
- Through understanding in different complex data formats like XML, Json, comma separated files etc, with expensive in parsing the data
- Utilized MS-Visio to create Screen Mockups and scenario Workflows using UML diagrams
- Coordinated with the QA team to create test scripts and throughout Test Life Cycle and involved in various testing phases where by good knowledge on Oracle and Hive.
- Worked in very tight dead-line for overall project implementation.
- Conducted Solution Validation and authenticated the day-to-day Business Scenarios to be tested as part of User Acceptance Testing in the deployment stage.
Environment: HUE, SQL Developer, MS Office, MS Visio, MS Project Plan, Excel, PowerPoint, Splunk, Data Quality Dash Board, Information Analyzer, JIRA, Serena.
Confidential, NC
Lead Business Analyst
Responsibilities:
- Acted as a lead BA with in-depth regulatory reporting business and data knowledge related to NYDFS
- Worked closely with the different line of business (Source teams) Insurance, Annuity and Retirement that provides the data for our project.
- Developed different artifacts like Business Requirements, Functional specification documents along with Data Mapping from different sources
- Documented reporting and Reconcilement requirements to match the data with Blue Book line items
- Extensively worked on Excel for data analysis, data mapping, Report creation, designed mockups using VBA
- Worked closely with the maintenance team (Prod support) for various day to day activities
- Worked with the Data warehouse and BI teams to come up with a comprehensive design that supports all the BI and Reporting needs
- Extensively used Oracle Queries to conduct Data Analysis, Mapping and Validation to come up with ETL mapping logic for the new infra setup.
- Utilized MS-Visio to create Screen Mockups and scenario Workflows using UML diagrams
- Generated special Report specifications document which consists of report mockups and all technical details along with mapping.
- Coordinated with the QA team to create test scripts and throughout Test Life Cycle and involved in various testing phases where by good knowledge on Oracle.
- Worked in very tight dead-line for overall project implementation.
- Conducted Solution Validation and authenticated the day-to-day Business Scenarios to be tested as part of User Acceptance Testing in the deployment stage.
- Working closely with data modeler in creating the data repository required for NYDFS
- Contributed in the preparation of post-production documents.
Environment: FSDF, SQL Developer, MS Office, MS Visio, MS Project Plan, Excel, PowerPoint, ALM (Quality Center),OBIEE, JIRA, Serena.
Confidential, NC
Lead Business Analyst
Responsibilities:
- Acted as a lead BA with in-depth Actimize and AML data knowledge to represent IT from Actimize data stand point for AML monitoring.
- Worked closely with the different line of business (Source teams) that provides the data for our project. Developed different artifacts like Business Requirements, Specifications documents along with Data Mapping from different sources
- Performed Gap and Data Analysis to help the business in the process of de-commissioning existing old Prime Monitoring process for each source.
- Extensively worked with Life and Annuity Business, IT in the process of acquiring data to meet Actimize needs.
- Extensively worked on Excel for data analysis, data mapping, Report creation, designed mockups using VBA
- Worked closely with the maintenance team (Prod support) for various day to day activities
- Extensively worked on ETL data mapping/ logic to replicate the existing infrastructure
- Worked with the Data warehouse and BI teams to come up with a comprehensive design that supports all the BI and Reporting needs
- Extensively used Oracle Queries to conduct Data Analysis, Mapping and Validation to come up with ETL mapping logic for the new infra setup.
- Utilized MS-Visio to create Screen Mockups and scenario Workflows using UML diagrams
- Generated special Report specifications document which consists of report mockups and all technical details along with mapping.
- Coordinated with the QA team to create test scripts and throughout Test Life Cycle and involved in various testing phases where by good knowledge on Oracle.
- Worked in very tight dead-line for overall project implementation.
- Conducted Solution Validation and authenticated the day-to-day Business Scenarios to be tested as part of User Acceptance Testing in the deployment stage.
- Contributed in the preparation of post-production documents.
Environment: Actimize, SQL Developer, MS Office, MS Visio, MS Project Plan, Excel, PowerPoint, ALM (Quality Center),OBIEE, JIRA, Serena.
Confidential, NY
Lead Business Analyst
Responsibilities:
- Acted as a lead BA / Representative from IT side for Mantas Hong Kong and Shanghai Correspondent Banking Wire Based Transaction Monitoring and served as a liaison between key stakeholders and the technical team. Prepared project plan for all the phases
- As a Lead BA worked directly with Business (I&S CB team) and E&Y (Ernst & Young) to gather requirements and established the expected workflow procedures applicable.
- Worked closely with the upstream teams who provide the data related to HK and SH and prepared large scale Business Requirements, Specifications documents along with Data Mapping from different sources
- Performed Gap and Data Analysis to meet the needs of the “To-Be” state requirements and to provide quality data for Scenarios up and running
- Extensively worked on Excel for data analysis, Report creation, designed mockups using VBA
- Worked closely with the maintenance team (RTB) for various day to day activities
- Created, managed and updated various Scrum-based artifacts to keep track of issues using JIRA
- Extensively worked on ETL data mapping/ logic to replicate the existing infrastructure of Mantas NY for HK and SH CB project
- Worked with the Data warehouse and BI teams to come up with a comprehensive design that supports all the BI and Reporting needs
- Extensively used Oracle Queries to conduct Data Analysis, Mapping and Validation to come up with ETL mapping logic for the new infra setup.
- Utilized MS-Visio to create Screen Mockups and scenario Workflows using UML diagrams
- Generated special Report specifications document which consists of report mockups and all technical details along with mapping.
- Coordinated with the QA team to create test scripts and throughout Test Life Cycle and involved in various testing phases where by good knowledge on Oracle.
- Worked in very tight dead-line for overall project implementation.
- Conducted Solution Validation and authenticated the day-to-day Business Scenarios to be tested as part of User Acceptance Testing in the deployment stage.
- Contributed in the preparation of post-production documents.
Environment: Mantas, TOAD, Oracle, MS Office, MS Visio, MS Project Plan Excel, PowerPoint, ALM (Quality Center),OBIEE, JIRA.
Confidential
Lead Business Analyst
Responsibilities:
- Worked as a Lead BA by directly coordinating with Business (I&S CB team) to gather requirements and have prepared the expected workflow procedures
- Prepared large scale Business Requirements, Specifications documents for all the major implementations
- Performed Gap analysis and Data analysis to meet the needs of the scenario “To-Be” state requirements
- Report creation, designed mockups using VBA
- Maintained User Stories, Product Backlogs, Sprint Backlogs and provided Status Reports and updates on unresolved issues as per the Agile Scrum Methodology
- Was a representative from IT side for Mantas CB FRBNY Remediation program where by served as a liaison between key stakeholders and the technical team
- Worked closely with the maintenance team (RTB) for various day to day activities related to the application
- Created, managed and updated various Scrum-based artifacts to keep track of issues using JIRA
- Participated in several JAD sessions and workshops where MoSCoW Analysis was utilized to prioritize BOW (Book of Work)/ Minor Works and record the user stories
- Maintained Version control, defect tracking and deployment using Clear Quest
- Worked with the Data warehouse and BI teams to come up with a comprehensive design that supports all the BI and Reporting needs
- Wrote Oracle Queries to perform Data Analysis, Mapping and Validation. Involved in validating and analyzing stored procedures
- Utilized MS-Visio to create Screen Mockups and scenario Workflows using UML diagrams
- Involved in post-production activities performing V&V activities
Environment: Mantas, TOAD, MS Office, MS Visio, MS Project Plan Excel, PowerPoint, ALM (Quality Center),OBIEE, JIRA.
Confidential
Business Analyst
Responsibilities:
- Conducted a thorough Feasibility Study and vendor evaluation in the Project Initiation phase which consisted of evaluating different vendor POCs along with rigorous Cost-Benefit Analysis
- Worked closely with different vendors like Actimize, Mantas, Hiperos and Sapiens to understand their system and capabilities.
- Comprehensively involved in collecting Business Requirements by facilitating weekly meetings with Focus Groups
- Worked closely with rest of the Fin Crime Risk monitoring/ management teams (E.g. Actimize SAM, Actimize eRCM) to understand and make the AB&C system integrate with them.
- As a Lead BA assisted the Project Manager in setting up an overall timeline using MS-Project to achieve target milestones for deliverables along with assigning and allocating project resources
- Followed guidelines as per the Waterfall SDM to capture and document the User Requirements in the BRD and translated them into Functional Specifications using Screen Mockups and UML Diagrams including Use Case Diagrams, Sequence Diagrams and Process Flow Charts
- Extensively designed the Entitlement Model and System with respect to establishing the association among respective Users, Roles and corresponding Functions
- Executed SQL Queries to extract data from a central repository to perform data analysis and mapping
- Constructed a comprehensive Requirement Traceability Matrix to validate the coverage of all requirements
- Maintained Version control, defect tracking and deployment using Clear Quest.
- Coordinated with the Quality Assurance team to perform several testing tasks, including the preparation of Test Scenarios, Test Steps and other tasks with respect to Validation. Hands on experience on VB script used in automation.
- Engaged in bi-weekly inspection and walkthrough meetings to validate the progress of testing
- Created a UAT Plan, Training Plan and a Training Script and addressed several deployment concerns in UAT Issue Logs before accommodating necessary modifications prior to UAT Sign-off
Environment: Mantas, Hiperos, Actimize, TOAD, MS Office, MS Visio, MS Project Plan Excel, PowerPoint, ALM (Quality Center),OBIEE, JIRA.
Confidential, MD
Business Analyst
Responsibilities:
- Conducted a thorough Feasibility Study during the Project Initiation phase which consisted of rigorous Cost-Benefit Analysis reports
- Comprehensively involved in collecting Business Requirements by facilitating weekly meetings with Focus Groups
- Worked with Risk Professionals to identify the Project Goals and define the Scope of the Credit Risk Dashboard
- As a Lead BA assisted the Project Manager in setting up an overall timeline using MS-Project to achieve target milestones for deliverables along with assigning and allocating project resources
- Followed guidelines as per the Waterfall SDM to capture and document the User Requirements in the BRD and translated them into Functional Specifications using Screen Mockups and UML Diagrams including Use Case Diagrams, Sequence Diagrams and Process Flow Charts
- Extensively designed the Entitlement Model and System with respect to establishing the association among respective Users, Roles and corresponding Functions
- Executed T-SQL Queries to extract data from a central repository to perform data analysis and generate ad-hoc business reports
- Constructed a comprehensive Requirement Traceability Matrix to validate the coverage of all requirements
- Maintained Version control, defect tracking and deployment using Clear Quest.
- Coordinated with the Quality Assurance team to perform several testing tasks, including the preparation of Test Scenarios, Test Steps and other tasks with respect to Validation. Hands on experience on VB script used in automation.
- Engaged in bi-weekly inspection and walkthrough meetings to validate the progress of testing
- Created a UAT Plan, Training Plan and a Training Script and addressed several deployment concerns in UAT Issue Logs before accommodating necessary modifications prior to UAT Sign-off
Environment: Windows XP/2000, J2EE, UML, Microsoft tools, Rational Clear Quest, PL/SQL, VBA / VB Script, Waterfall, MS-Office, QRM