SUMMARY

• Business Analyst with 8+ years of hands - on experience in the fields of Finance and Banking with clear understanding of Business Analysis
• Demonstrated proficiency in areas of Project management, stress testing, risk Management, technical and analytical support, evaluating Data Sources, translating Requirements and gathering business requirements, change management and the leadership of teams to implement technology and Analysis of Financial Impact on Operations
• Have experience in creating and updating compliance procedures and training material for capital markets business units.

TECHNICAL SKILLS

• MS office Suite
• JIRA
• Informatica
• CCAR
• SDLC
• BRD/FRD
• ORACLE SQL server
• OFSAA Model
• Finance and accounting
• Gap analysis
• SQL and databases
• Workflow analysis
• Data mapping
• Excel (Macro)

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Responsibilities:

• Worked on OFSAA model to support the Database for use by CDD (Customer Due Diligence) and Financial Crimes team.
• Worked on Data mining, ad hoc reporting, daily, monthly and quarterly reporting
• Created documentation for Change Requests and Business Requirement documents to formally implement changes requested by stakeholders in GLIMMER.
• Extracted the data from database and provide data analysis using SQL to the business user based on the requirements.
• Prepared process flow diagrams depicting “AS-IS” and “To-Be” state.
• Performing GAP Analysis and Impact Analysis before making any change in the database requested by stakeholders.
• Worked with Data Warehousing; responsible for data mapping activities including maintaining mapping documentation and quality testing after production releases pertaining to assigned projects.
• Worked in an agile environment with 2-week sprint cycles in JIRA 2.0
• Creating Test cases and executing them in ORACLE SQL SERVER for every change in the database before implementing the change.
• Performing Postproduction Validation for the changes made as per the requirements.
• Presenting the results to upper management using MS Suite including EXCEL, POWERPOINT etc.

Sr. Business Analyst

Confidential - Austin, TX

Responsibilities:

• Maintained risk management documentation to support compliance with regulatory requirements and stress testing models.
• Supported company’s risk appetite by establishing counterparty limits and daily monitored risk exposure for Capital Market counterparties.
• CCAR Regulatory Reporting and CCAR Stress Testing for Banking Balance Sheet Asset management.
• Worked on Data mining, ad hoc reporting, daily, monthly and quarterly reporting
• Created documentation for Change Requests and Business Requirement documents to formally implement changes requested by stakeholders.
• Extracted the data from database and provide data analysis using SQL to the business user based on the requirements.
• Prepared process flow diagrams depicting “AS-IS” and “To-Be” state.
• Worked on documentation skills of SDLC artifacts like BRD, FSD.
• Managing cross line of Businesses from regulatory reporting prospective.
• Worked with Data Warehousing; responsible for data mapping activities including maintaining mapping documentation and quality testing after production releases pertaining to assigned projects.
• Worked in an agile environment with 2-week sprint cycles
• Creating and maintaining the database using SQL and Excel

Business Analyst

Confidential - Atlanta, GA

Responsibilities:

• Collaborate with stakeholders to discuss the feasibility, profitability, and risk of the project and Assist to develop project plan using Agile Methodology
• Generated requirements for Capital Markets-Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions and Trading Model within the scope of both the Front and Middle Office.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile and used SQL to query the database and performed data analysis.
• Gather detailed business requirements and deliver detailed business functional requirements.
• Delivered ad hoc financial reports for business managers, streamlined existing reports and managed special projects
• Documented Data Mappings, Transformations, and Informatica sessions as per the business requirement.
• Effectively utilized available data to identify risks and provide practical risk management solutions.
• Identified Use cases from the requirements and wrote Use Case Specifications and Created business process workflow diagrams.

Business Analyst

Confidential

Responsibilities:

• Worked on Data Analysis, Source to Target Mapping, FRD, Report Specification Document, System Requirement Specification and weekly defect status reports.
• Maintained agile process documentation and agile tools.
• Followed the Agile methodology for elicitation and representation of requirements based on interaction with the business process owner, SME's and the development team. Participated in daily scrum.
• Conducted JAD sessions during the various stages of upgrading the matching system and discuss the current system preference.
• Performed Data Mapping and Data profiling to map various source systems to the new Target source system.
• Collect the functional requirements from the users and provide Technical implementation details using Axiom Controller View tool.
• Executed test scripts to test the ETL logic in SQL server

Business Analyst

Confidential - Detroit, MI

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements.
• Involved in the meeting with Business process owners, SME (subject matter experts), Finance, Sales Audit and Marketing Team for Requirements gathering in Definition Stage.
• Designed and created logical Data warehouse models to support strategic decisions.
• Responsible for translating BRD into functional specifications and test plans.