SUMMARY:

• Over 8 years experience as Business Analyst, Data analyst having domain experience in various financial services applications.
• Experienced with the procedures of Banking, Investment Banking & Regulatory Compliances - Anti-Money Laundering (AML), Bank Secrecy Act (BSA), Office of Foreign Assets Control (OFAC) Guidance, Customer Identification Program (KYC/CIP), Basel II Accords, Dodd-Frank Act
• Excellent Financial Product knowledge in capital market, equity, Fixed Income (CDs, Treasury Bonds, Corporate Bond, Municipal Bond, Money Market) Structured securities, Derivatives: Futures, Forwards, Options, SWAP (interest rate swap, currency swap), fixed and variable rate instruments, and derivatives end to end trading cycles, securities clearance and settlement process.
• Experienced in Cash Management/Treasury products and electronic banking. Strong Understanding of Wealth Management and Risk Management. Have also good understanding of different products like Mutual Funds, Life Insurance, and Retirement Plans.
• Experienced documenting Business Requirements Document (BRD), developing UAT Plan, maintaining Traceability Matrix and assisting in post implementation activities.
• Extensive experience in working in SDLC for various methodologies, including RUP, Agile including Test-driven development (TDD).
• Highly experienced in performing Feasibility Studies, Impact analysis, GAP analysis and Risk Analysis. Expertise in creating Use Cases, Use Case Diagrams, Class Diagrams and Sequence Flows using MS Visio and UML concepts.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Deep understanding of database management systems, data warehousing concepts, BI technologies and data mining. Skilled in data warehouse design using Star Schema rollout for fact and dimension tables. Experienced conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Expert in application development with full lifecycle implementation of large data warehouses, including project Scope, Requirements Gathering, Star Schema Design, Snowflake Schema, data modeling and ODS. Expertise in creating dimensional models and creating ETL specifications.
• Expertise in Core Documentation, Data Analysis and Process Analysis, Design, Development and testing phases.
• Experienced in report design, table/query design and automation utilizing VBA modules. Proficient in writing Excel Macros, Pivot tables, Graphs, Charts and VBA routines.
• Proficient in writing and executing SQL queries as well as database testing analysis. Solid understanding of OO programming concepts.
• Extensive experience in Smoke Testing, Regression Testing, Functional Testing, Integration Testing, System testing, End to End testing, and User Acceptance Testing. Experience in Manual, SOAP UI (Oracle Enterprise for web service testing) and Automated testing using HP QTP.
• Organized professional with excellent verbal and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles in minimum time and little .

TECHNICAL SKILLS:

• MS Project, Excel, Access, Visio
• PowerPoint, Rational Rose, SharePoint
• DOORS, HP QTP, SQL, XMLHTML
• HP Quality Center, Team track
• Rational Clear case, SVN
• Oracle, SQL server
• Teradata Windows
• UNIX, Waterfall, Agile
• RUP, Cognos, Informatica, Rally. VBA, Ab Initio, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Sr. Business Analyst/Scrum Master

Responsibilities:

• Prepared Functional Requirement Documents (FRD’s) after the collection of Business requirements from business users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Involved in reports UI prototype / wireframes design during the process of requirements gathering from the stakeholders. Created and reviewed User Requirements Document, Use Cases, and FRD.
• Conducted JAD (Joint Application Development) sessions and gather business requirements, analyze and prioritize requirements
• Writing the SQL queries in Oracle SQL Developer for data analysis and data profiling for creating requirements.
• Created mapping documents for processing various data feeds in XML, Flat files and other formats from systems such as MANTAS, NESS, etc. Created ETL specifications for feed processing into KYC data warehouse.
• Interacted with compliance officers for requirements gathering and partner teams for preparation of interface control documents.
• Developed report layouts for Suspicious Activity and Pattern analysis under AML regulations
• Gathered and prioritized requirements, developed business scenarios to check how the system would work with the roles and processes of the departments, and developed acceptance criteria. Maintained requirements in SharePoint and used it for creating tasks and tracking action items and issues.
• Evaluated business process requirements to ensure proper system configuration (i.e. identifying key decisions, process changes, pain points, interface issues, considerations.)
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM). Created Project Plans for multiple projects and allocated resources accordingly.
• Developed UML diagrams like Use Cases Diagram, Activity Diagram, Sequence Diagram, Class Diagram and Coloration Diagram on scenarios for validating Entity Data and verification of customer records: legal name, address, business purpose, legitimacy and analysis of transaction activity.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments. Performed Gap/Impact Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Created Report using VBA, macros, and pivot table. Also done budgetary reports, which shows resource wise cost forecast and Actual.
• Facilitated User Acceptance Testing (UAT) along with the Subject matter experts (SME’s).
• Involved in reviews and preparation of test plans, test cases and conducted functional testing, integration testing, andsystem testing.

Environment: MS SharePoint, SOA, UML, Java, UNIX, Clear case, HTML, XML, XSD, Erwin, Business Objects.

Confidential, NJ

Sr.Business Analyst/Scrum Master

Responsibilities:

• Preparation of overview documents for various initiation channels.
• Gathered and analyzed the requirements for new reports (scheduled/ad-hoc reports) and dashboards for asset management. Worked with IT team to create scheduled automated reporting for standard and frequently used reports.
• Identified functional changes/upgrades to database and application modules to service new instruments/benchmarks. Working with technology teams for the integration, validation and of data across systems end to end.
• Produced UML Activity diagrams with defined swim lanes using MS Visio as part of process analysis. Created and reviewed User Requirements Document, Use Cases, and Functional Requirements Document.
• Written Complex and simple Sql queries to analyze the data.
• Gathered and prioritized requirements, developed business scenarios to check how the system would work with the roles and processes of the departments, and developed acceptance criteria.
• Designed and coded application components in an agile environment utilizing a test driven development approach.
• Maintained requirements in SharePoint, and for testing we used HP QTP.
• WroteETL specificationsfor all the development tasks, to better evolve the ETL design.
• Worked on Master Data Management by the Data warehouse techniques while maintaining the operational data and the Master data separately.
• Worked on BI tools implementation where the data is retrieved from Data warehouse.
• Created Project Plans for multiple projects and allocated resources accordingly.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Designed the test plans and test scripts based on the user requirement specification and conducted UAT, Integration testing, Functional testing.
• Conversant with XML documents and syntax- worked with multiple xml file and system response outputs.

Environment: C, C++, Java, Micro Strategy, BI Tools, Oracle, UML, MS Word, UNIX, Windows XP, SQL, VB.NET, VB, HTML, XML, Cognos

Confidential, NJ

Business Analyst

Responsibilities:

• Identified the key business Metrics and met regularly with key business personnel and IS analysts to determine business needs and to document requirements.
• Gathered details on the business process, technical architecture, software systems and servers employed in the client location.
• Understood fixed income, equities & derivatives trading cycles, securities clearance and settlement process. Conducted market analysis and feasibility studies, and developed the project plan.
• Organized and scheduled user interviews, user meetings, group meetings, and JAD sessions. Performed a detail research on their existing financial transaction processing and reporting methodologies.
• Collected, analyzed and documented user requirements and created business requirements document and functional specification documents. Modeled and reviewed all current operational data structures and recommend optimizations and reconfigurations to Data Architects for implementation.
• Designed and Developed MDM and started Data governance initiative. Defined best practices, policies and procedures regarding Metadata Management, Data Profiling, Data quality, data storage and archiving, disaster recovery, security and data dictionary metadata standards.
• Participated in the development and maintenance of, and adherence to, corporate data architecture, data management standards and conventions, data dictionaries and data element-naming standards.
• Provided leadership and guidance for database architecture design and strategy to ensure quality deliverables across the entire IS organization.
• Documented detailed functional and technical specifications based on agreed solutions.
• Supported development of the business solution as part of the technical team. Worked with DBA to support migration of applications from Development to Test to Production
• Recommended and evaluate new tools and methodologies and written complex sql queries to analyze and create reports.
• Worked with management to identify issues and risks that may have an effect on quality or delivery from a technical, business and end-user perspective.
• Evaluated and estimated the work effort required to meet a desired deliverable.
• Provided status reporting on work assignments and alert IS management to deviations from plan. Ensure completed work meets with all IS best practices and policies.
• Performed administration, maintenance and configuration changes to existing applications where appropriate and be willing to support mission critical 24x7 applications.
• Interacted with account management, project management, and clients as appropriate both locally and globally.
• Involved in writing and reviewing test plans, test cases and conducting functional testing.

Environment: Oracle, Ab Initio, J2EE, Tibco, MS Word, UNIX, Windows XP, SQL and XML.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Managed business requirements for the project to move the credit risk-reporting batch to publish counterparty exposure limits earlier as part of an FSA compliance requirement.
• Responsible for understanding design and structure of different data marts. Also involved in writing ad-hoc queries for data mining and producing data mapping documents.
• Developed business process models in RUP to document existing and future business processes. Developed manual test scripts using HP Quality Center for performing Regression testing.
• Was responsible for creating and reviewing business requirements, functional specifications, documentation and test plans. Performed testing and recorded results in HP Quality center.
• Involved in GAP analysis around the identification of business rules, business and system process flow, user administration, requirements and assumptions. Conducted user interviews, gathering requirements, analyzing the requirements.
• Co-authored business requirements document with the business users. Extracted, discussed, and refined high level business requirements from business users and team members. Maintained requirements in DOORS.
• Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML. Coordinated activities between business unit and technical staff.

Environment: J2EE, UNIX, SQL, HTML, Excel, MS Project, RUP, MS PPT, Rational Rose, Doors

Confidential, NY

Business Analyst

Responsibilities:

• Understood current reconciliation process of AMEX from business perspective. Interacted with client to understand requirements and preparation of various deliverable documents required for meeting SOX compliance.
• Interacted with multiple teams across geographies to understand potential impact of rolling out across multiple regions. Gathered business and functional requirements and analyzing those requirements, generating workflow process and necessary documents for the project.
• Developed User requirement specification and functional requirement specifications and use case diagrams using UML to depict the system functionality in accordance with Rational Unified Process (RUP) methodology.
• Prioritized the requirements gathered from financial specialists, business users, domain experts through interviews, JAD sessions.
• Created and maintained the Requirement Traceability Matrix (RTM) between the requirements and other products such as design documents and test plans.
• Developed Analysis Model that includes entity classes, use case diagram, sequence diagrams, object collaboration diagram that provide the development team a view of the requirements for Construction phase activity.
• Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships, Developed Use Case specifications with flow of events, pre conditions and post conditions.
• Verification and sign-off business requirements with various stakeholders. Participated in various meetings and interacted with the analysts, and developers to discuss Enhancement and Modification Request issues.
• Interacted with analysts, system staff and developers and served as a system support liaison by monitoring and resolving errors. Participated in weekly meetings with the management team and walkthroughs.
• Involved in documentation as to how to maintain and run scripts for future enhancements.

Environment: RUP, UML, Rational Rose, J2EE, UNIX, SQL, HTML

Confidential, NJ

Business Analyst

Responsibilities:

• Knowledge transfer to team and creation of understanding document.
• Preparation of functional documents and review of design documents.
• Testing support for SEPA Credit Transfer work requests.
• Testing scenario preparation for SEPA Direct Debit design documents.
• Conducted Banking domain sessions for Technical Employees; sessions include generic payment, Swift and SEPA concepts.
• Prepared Use Cases, Process Flows, Activity Diagrams.
• Created ISO mapping documents and Interface Control Documents for SEPA messages.
• Member of the team for manual testing.

Environment: J2EE, QC, XML, Oracle, MQ, SQL, HTML, XML, MS Word, UNIX, Windows XP