We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

New York, NY

SUMMARY:

  • Over 10+ Years of Information Technology experience in analysis, design, development and implementation of software applications, data analysis, Business systems requirements and Data Warehousing in Top Financial organizations & Insurance industries.
  • Extensive experience in designing and implementing process improvement strategies resulting in measurable achievements.
  • Effective collaborator with executive management and mentor and coach to juniors. Good communication, leadership, and relationship building skills.
  • Strong exposure working as cross technology expert who can support various platform teams.
  • Experienced in gathering business reporting requirements, implementing business & Technology reports and applying data warehousing techniques in financial industry using Oracle and Microsoft SQL Server for OLTP and OLAP based databases.
  • Experienced with data mapping, conversions, data integrity issues and integration of data sourced from various legacy systems and their impact on business models.
  • Good knowledge on various financial products (Derivatives, Repos, Fixed Income, Loans and etc.)
  • Strong business analysis skills and a thorough understanding of analysis deliverables. Developed, analyzed, streamlined and documented new and existing business processes. This included defining the inputs/outputs to each process, the key transformation steps of the process and the exceptions/ discrepancies within the process.
  • Proficient in creating Business Requirement Documents (BRD) and Functional requirement documents (FRD) in accordance with standard SDLC business practices.
  • Experienced with projects executed using Agile methodologies.
  • Articulate requirements to technical teams in a variety of ways, including via logical diagrams, Technical specification documents, use cases, data samples, and work flows.
  • Experienced in resolving complex data management issues and foresee data associated impacts and provide solution in order to avoid emergency fixes that impact business.
  • Hands on with Data modeling (Conceptual & Logical), ER diagrams, and Process flows and experienced with Metadata Organization and Data analytics initiatives.
  • Experienced in writing Functional / Technical documentations / ETL requirement docs for developers and other project team members.
  • Experienced working with various downstream consumers and upstream teams for data specific needs.
  • Hands on with complex reporting analysis and generating ad hoc reports using Business Objects reporting tool. Possess good experience in solving complex problems, team coordination, motivation as well as the ability to communicate effectively across cultural barriers. Possess good relationship with customers, Works great under pressure, and takes initiative, Very cooperative & hard working, Very comfortable with deadlines, Creative and Self Motivated.

TECHNICAL SKILLS:

  • Oracle 9i
  • 10g, MS SQL Server 2005
  • Netezza Database
  • Mercury Quality Center
  • Quest Toad, Share point
  • SQL Navigator, PL/SQL
  • MS Visio
  • MS Excel 2007
  • MS Power point
  • Clear Case version Manager
  • Business Object Reports XII
  • Quest Toad
  • Conceptual/Logical/Physical Modeling
  • MS Access
  • Advance Query Tool (AQT) and Trillium Software.

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst, New York, NY

Responsibilities:

  • Provide Pre - Project impact assessment by assessing the proposed changes, evaluate the feasibility of proposal and provide effort estimation to the business and IT stakeholders.
  • Analyze current business processes; manage Data Requirements & Process Requirements to implement new functionality through out the life of project cycle.
  • Responsible to Create Functional Documents / Technical Specifications / Data and Process flow diagrams.
  • Ensure that Testing team executes Test Plans for regression testing and integration testing and defects are logged in Quality Centre.
  • Collaborate with Global teams (SGP, LON, IND) during the Testing and development phases, also responsible for getting signoff from Stakeholders on requirements documents.
  • Work with development and testing counterparts on the technical build aspects and provide walk thru of functional specification document to ensure that they understand requirements.
  • Collaborate with downstream and upstream user groups on the project artifacts and sign offs.
  • Engage in Project management tasks including effort estimates, pilot project plan and resource man-days.
  • Manage UAT cycles in totality and resolved issues raised by the business users during UAT testing.
  • Analyze and build the reconciliation logic for front office trading data (trade / positions / contracts) with respective Sub-ledgers and General ledger.
  • Assist Project manager in the project management tasks. E.g. Prepare meeting minutes, running the working group calls (end-to-end), highlight risks during the project and weekly project status reports.
  • Experiences with various products including Fixed Income (Bonds, MUNI, CORP), Derivatives, Equity, Repos, Loan/Deposits Options/swaps/forwards and FX.
  • Hands on with Oracle SQL. MS SQL medium to complex queries.
  • Responsible for achieving sign-off from the key stakeholders, against the requirements specifications.
  • Support Data feeds for Credit Risk Reporting, Regulatory systems and Treasury for COB financial reports/Exposures in case of any data anomalies.
  • Provide functional analysis for business initiated TDB projects, delivering functional requirement specifications by the agreed timeline ensuring that traceability matrices are used and reviewed with TDB testing team on all projects.
  • Participated in Front Office Led Projects (Artemis), Legal & Regulatory Mandatory Projects (US FCAP Sub ledger Remediation program, Arrow, EMIR Article 39).

Lead Business Analyst - Consultant, New York, NY

Responsibilities:

  • Implemented a firm wide cross-product trade surveillance application ‘IRIS’ for Trading Desk heads to attest/monitor day by day trade modifications and corresponding economic value swings in compliance.
  • Partner with Middle Office, Markets Risk, and technology to implement process/data improvements to reduce manual trade modifications; facilitate the gathering of weekly root-cause commentary to identify Remediation opportunities; report bi-weekly results by creating customized Remediation tracking rules using Excel and Business Objects.
  • Face-off with Operations Line managers and stakeholders as a member of the central Performance Measurement & Analysis team to gather business requirements and understand full Business intelligence reporting needs and demands.
  • Develop and manage data specifications spanned to various metrics which are aligned to internal processes and systems information
  • Facilitate meetings with front office /middle office desk supervisors, Market Risk managers and subject matter experts to breakdown source data analysis associated to the KRIs (key risk indicators)
  • Performed gap analysis, data analysis during the feed onboarding process, Worked with Data warehouse partners to ensure all the data validation rules are implemented as per business requirement, worked closely with ETL team in the data enrichment /normalization processes.
  • Run the Work group calls for the projects assigned to me.
  • Responsible for training and demo of the application modules prior to the go live date.
  • Created and maintaining a data management document that comprises the extraction logic, business rules on the feeds and requirement changes along with data flow diagrams for all the on boarded feeds of Front office & Middle Office booking systems.
  • Manage the Business Requirements gathering, Technical Feed Mapping, ETL & Dashboard integration, and issues tracking. On boarded four Front Office and Middle Office systems PRIMO, ZEUS, TES, and TMS, TPS IRIS, CASH, OASYS, IMACE.
  • Responsible to provide solution of various businesses needs at a global level to deliver a consolidated web-based client reporting platform spanning across various asset classes e.g. FX, OTC, Equity, Fixed Income, Credit & Derivatives.
  • Create, review and enhance global Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs).
  • Understands appropriate processes and systems working with the Line and IT to ensure development of data feed logic is aligned with requirements.
  • Manage the QAT and UAT cycles in totality and resolved issues raised by the business users during UAT testing.
  • Responsible for post-production release check outs to ensure that Enhancements/new features of the application are working as expected. I co-ordinate with release management team in the process of RFC approvals for Production release.
  • Develop and execute test plans that ensure business requirements have been met.
  • Create test scripts including specific test cases and expected results to ensure proper implementation in Production Libraries.
  • Ensure deliverables are being met on a timely basis.
  • Define business rules to enrich, transform and normalize data across multiple systems.
  • Experienced with Business Objects XII for Business intelligence reports using Universe & customized SQL.

IT Business Analyst - Consultant, New York, NY

Responsibilities:

  • Gathered the requirement by discussing with the business people and translated their requirements into data flows, detail technical specifications.
  • Created Business & Functional requirement documents for the data warehouse environment projects. Most of them are front office migration projects. I was also responsible for providing the technical specs to the ETL and Development teams.
  • I am involved in the enhancement of UI design as well.
  • Worked with Credit Valuation Analytics (CVA) team on credit limit monitoring ensuring counterparty limits/exposure do not exceed.
  • Performed Pre & Post migration comparison on the data migrating from one system to multiple systems or vice versa. I am also involved in the production checkouts of the impacted reconciliations when migration & Patch goes live.
  • Involved in the automation / development of Credit Risk & Collateral Risk reconciliations where Collateral recons require thorough understanding of agreement derivation for a combination of Legal Entity & counterparty.
  • On the other side I have created reconciliation FRD from the scratch which is truly based on the requirements gathered from a different group and our analysis of data. The reconciliation process encompasses to reconcile the key trade attributes like counterparty, Mark to Market, Notional, trade population matching and few others.
  • Performed data reconciliation between Bank of America and Merrill Lunch data feeds for various products including Fixed Income Derivatives, Equity, structured repos, Options/swaps/forwards and commodities across trading systems, identified & investigated breaks and their appropriate reasons of breaks. I was involved in the migrations encompassing the Trading systems Murex, OpenLink & Winfits, GCDB, Vmaster, Sierra, Aurora, Vienna for financial products FX Forwards, Bonds, swaps, rates and repos respectively.
  • Ensured that Trade population is accurate between the Risk data repository & Sub ledger systems and there are no breaks on trade population, mark to market value, notional and counterparty. Feed from Risk data repository is made available to Credit Risk System (Credit Studio) for calculation of credit risk and counterparty exposures.
  • Responsible for Process and activity flows, business process models & requirements traceability matrices for project support and analysis and recommended the most efficient and cost effective solution for system design.
  • Prioritized Issues, risks evolved during the Project scope and documented assumptions and constraints for overall project in order to avoid any future gaps.
  • Experienced interacting with Business users and other cross functional teams, proposed solutions to their problems by foreseeing data associated impacts and served as a liaison for upstream data vendors and project team.
  • Interacted with global teams located in London, Hong Kong and India.
  • Responsible to perform the BA sanity checks after the reconciliations run in the production on weekly basis.
  • Managed the Front office migration patches in totality from Development to Production implementation, Resolve QA issues, and Sanity checks in the QA/UAT environments of the UI reports and data consistency in reference tables. Supported the UAT testing cycles and take ownership of any issues discovered in the UAT.
  • Responsible to Design screen mockups / wireframes for UI application enhancements and bug fixes and created a metadata for screen to data filed mapping along with business definitions and source system information.
  • Worked with ETL & development teams and DBA team to in corporate the incoming data feeds into Bank of America systems and prepared Functional specification, requirement documents, Technical ETL mapping based on ETL design.
  • Identified test scenarios, writing and executing test scripts, and reporting overall testing results and coordinated with various internal teams to understand the project and establish a feasible testing plan by work with QA team.
  • Responsible for testing critical business scenarios where business knowledge is essential by collaborating with QA on backend (SQL queries) and through application as well.
  • Responsible to create source to target mapping and transformation rules for entire Risk data warehouse attributes and maintained data dictionary for other supporting teams.
  • Responsible for tracking/ logging/testing/implementing issues in Quality center and triaged QC defects by partnering with IT and business for rapid resolution

Technical Business Analyst - Consultant, Hartford, Connecticut

RESPONSIBILITIES:

  • Experienced in gathering requirements from user stories in the WAR room and capture requirements for the scope of each iteration.
  • Created Logical representations of database requirements by MS Visio and worked with Data Modeling team for physical model implementation.
  • Responsible to produce various functional documents for project needs via user stories/use cases, data flows, logical data models, corresponding ETL and BI requirements along with the technical specification documents.
  • Experienced in testing reporting requirements where business knowledge is essential to test certain functionalities of an application (also includes manual backend testing by SQL)
  • Successfully created data mapping for various source legacy systems that were finally loaded in target tables and conversions used by developers.
  • Root cause analysis of data inconsistency and bad/missing data issues.
  • Coordinated with cross-functional teams to achieve data management tasks.
  • Designed, coordinated and lead feasibility studies, concept formulation, development, implementation, operation, and maintenance of various systems, equipment, and procedures.
  • Assisted End users and testing team (QA) to help understanding the processes and testing the systems.
  • Wrote complex SQL queries to extract aggregate data, classifications, hierarchies via multiple table joins and inline queries.
  • Prepared Trace ability Matrices, which mapped the business requirements to the functional specifications and the testing scenarios.
  • Tracked entire database objects created for LYNC application using MS Access forms and tables.
  • Coordinated with core development, System testing, Quality testing and Performance testing teams offshore and onsite.
  • Worked with 60 team members including onsite and offshore at the peak time of project cycle.
  • Lead the offshore team and prioritized the workload as per the iteration requirement.

Hire Now