SUMMARY:

• 10 years of diversified experience in Business System Analysis, Data Analysis, and Project management.
• Experienced in Data Analysis of various asset classes across different regions and trading systems using reference data, MS Excel and SQL.
• Recent Financial experience in Credit Risk, Compliance risk and regulatory data procuring and mapping for Agile based UI development projects including data migration and mapping for Repo, Sec Lending, PB (Prime Brokerage), OTC Derivatives.
• Extensive experience with Listed Derivatives (Future, Option), Fixed Income (MBS), Investment banking, reconciliations for Credit & Market Risk data for Global Risk Data Management Team.
• Overlooked and updated the PMO deck for all the on - flight Market Risk projects at BOA.
• Dealt & coordinated with front office, middle office, back office and clearing house throughout the trade life cycle.
• Knowledge of Cost & Company Accounting, Ledger, Financial Ratios and Statements.
• Strong knowledge of SDLC methodologies with clear understanding of all the phases from Inception to Deployment.
• Managed projects including responsibility for a project under minimal supervision on enterprise wide projects requiring creative solutions.
• Expertise in handling Change Requests, Impact Analysis on the existing environment.

TECHNICAL SKILLS:

Business Analysis: Complete requirement process, business rules, data flow diagram, flowcharts, business process modeling, Use Case Narratives, Use Case Diagrams, Activity Diagrams etc.

Business Modeling Tools: MS Visio, ERWIN Data Modeling to create wireframes and mockup screens.

Methodologies: SDLC model, Waterfall, RUP, RAD, AGILE, Use Cases, UML, JAD.

Data Analysis: Data cleansing, Data transformations, Data conversions, Data mapping, Data migration, and Data mining.

Data modeling: ER Diagrams, Conceptual, Logical & Physical design, ERWIN, TOAD, Rapid SQL.

Databases: Sybase 12.5, Oracle10g/9i/8i, MySQL, SQL Server Management Studio, Sandra (ODB)

Operating Systems: Windows 7/Vista/XP/2000, UNIX, Linux

PROFFESIONAL EXPERIENCE:

Confidential, NY/ NJ

Sr. Business System Analyst/ RM/ PM

Responsibilities:

• Created and managed project plans (using project libre, MS Project), Jira dashboard, SDLC process and Jira compliance for Agile based Application development and data migration.
• Performed data analysis using MS Excel and SQL to identify and resolve high volume of complex data quality issues from heterogeneous data sources.
• Worked closely with business partners to define strategies for technical solutions, determine requirements, and develop functional designs based on the analysis of line of business needs, objectives and existing systems infrastructure.
• Worked closely with offshore and on-site developers and testers to ensure requirements and functional designs are translated accurately into working technical design, requirements and that test plans and scripts serve customer needs.
• Proposed ideas that work and gain consensus from both the business and technology teams on the solution and enhancing GUI for Critical CSA, resolution terms for Repo, Sec lending, Prime Brokerage, OTC & listed Derivatives.
• Authored documents on Release Process, Confidential, UAT plan and scripts; Jira documents: 1 pagers, milestones, epic, story with acceptance criteria using language and instructions that makes sense and are easy to understand how the changes influence the overall user experience for dev, QA, and users.
• Created mock up for software user interface screens using MS Visio, MS Paint, Snag it, Snip it.
• Executed SQL & Python scripts to generate the reports for data quality and regulatory reporting purposes.
• Managed end to end release process for each sprint e.g. creating release time line from inception to deployment
• Actively coordinated, provided walkthrough, demos and verified functionality with users/QA/ dev during UAT/ downstream testing to acquire formal sign offs for compliance and audit.
• Dealt with Reference Data and Data Quality concepts (completeness, precision, validity, accuracy, consistency, timeliness checks).
• Impact analysis for technology changes in feed file and broker dealer separation project on existing Reg. W Actimize models.
• Lead business requirement gathering and documentation (HLD, LLD) for OTC derivatives and PB (Prime brokerage), for creating Actimize models, reports and alerts for Compliance applications.
• Worked with senior management both on the Technology as well as Business front for OTC derivatives and PB.
• Actively participated in initial phases of the software development cycle viz. Data procurement from source system and client communication, documenting the requirements.
• Coordinated work across various applications, operations or LOBs to maintain or deliver the business solution.
• Provided technical systems and software oversight for modification, implementation, or conversion of business systems.
• Provided oversight and guidance to junior business systems analysts, ETL and development team on data flow.

Environment: MS Office (MS Project, MS Visio, MS Excel, MS Word, MS Access) JIRA, Sybase, Sandra ODB, Python, Share Point.

Confidential, NJ

Sr. System Analyst

Responsibilities:

• Requirement elicitation from internal business partners to capture the global requirements across all the programs.
• Use MS Excel for data analysis, data reconciliation and data mapping.
• Data analysis using excel, and SQL.
• Handled change requests, performing gap analysis, impact analysis using Excel & comparison tools like Compare It.
• Created Workshop presentations to educate business users on how to check out, edit and check in the documents from Share point to fill the requirement Traceability Matrices for each program using MS Excel and SharePoint.
• Authored functional specifications for development team k/s Workbooks.
• During the development phase learnt the granular details of business, created test plans, and gathered knowledge on testing configuration, captured change requests, and acquired the sign offs.
• Pre & post migration configuration testing for Item authoring UI.
• Based on my performance I was moved to onboarding & production support team to train the new resources, on critical projects, was assigned as peer reviewer on one of the projects.
• Performed smoke/ thorough end to end/ integration and regression testing before a program is on boarded and administered.
• Facilitated the Beta Testing, D2D, Operational trials before launch integrated with downstream systems.
• Authored documents to automate manual testing processes and operations guide.
• Supporting Maintenance and resolving the prod issues for 3 programs, and migration of old data from legacy to new system for 4 programs, along with contributing to the UAT testing of new GUI following agile Development.

Environment: Java, Oracle, SQL Developer, Share Point, REST, SOAP UI for web services, XML, Compare It, MS Office

Confidential, NY/NJ

Sr. Business System Analyst/ PM

Responsibilities:

• Involved in Credit & Market Risk data reconciliation for Confidential .
• Overlooked and updated the PMO deck for all the on flight Credit & Market Risk projects to track the progress.
• Preliminary Analysis of the data to identify breaks between the risk system and sub ledger for a particular COB date using Excel.
• Effective and prompt data load requests to load the data in different environments specifying the details.
• Wrote SQL queries to check the population, matches and breaks (at book/ Position level) of the data amidst Risk and MO files’ data tables.
• Performed Data Mapping of the entire module across FO Risk System and Sub ledger.
• Created and updated Project Plans in MS Project to keep a track for defining and managing development tasks.
• Coordinated within and across on site and offshore development teams, and BAs.
• Pursued and coordinated with Risk managers, MO controllers globally.
• Created the Proof of Concept (POC), Functional Specification Documents for various break analysis reports for Repo, Equity derivatives, mortgages, Muni bonds.
• Created Requirement Traceability Matrix using Excel. FRD Walkthroughs and knowledge transfer to Development and DVA (QA) team onsite and offshore.
• Authored Feed Source document for different schemas to guide ETL team and procedure documents for business users which acted as an important instrument for UAT testing.
• Worked with cross - functional teams to understand the business and run the show.
• Extensive participation in Error Review Meetings to assure compliance of artifacts with business and federal govt. policies and guidelines.
• Coordinated and prioritized defects and enhancements /system requests based on requirements allowing sufficient time frame to ensure accuracy and consider deadlines.
• Performed Sanity Testing to test the basic functionality of the application.
• Created test cases for user acceptance testing.
• Produced and managed documentation for release activities to support Problem Resolution and Post-Release Analysis.
• Impact Analysis of changes made to the existing logic of data extraction.
• Loaded data from source feed to required destination.
• Actively participate in Knowledge Sharing Board activities.

Environment: MS Project, MS Visio, MS Excel, MS Word, MS Access, JIRA, SQL Server MS, Share Point.

Confidential, Chicago, IL

Sr. Business Analyst

Responsibilities:

• Developed strategic partnerships with the business units to develop a concrete knowledge base of the business line; including the business plan, products, and process stream.
• Elicitation and Analysis of requirements through interviews, surveys, by creating prototypes, wireframes and mockup screens, and observations of account managers and UI (User Interface) of the existing system.
• Developed the Business Process Workflow Diagram.
• Created the project templates for Use Case specification, Business Requirement Documents, Functional Specification Documents, Requirement Traceability Matrix, Change request form and Defect status form.
• Collaborated with the design team to assist them in designing the database using Erwin.
• Worked with cross - functional teams for building the use cases.
• Extensive participation in Error Review Meetings to assure compliance of artifacts with SDLC Policies and guidelines.
• Coordinated and prioritized defects and enhancements /system requests based on requirements allowing sufficient time frame to ensure accuracy and consider deadlines.
• Performed Smoke (Sanity) Testing to test the basic functionality of the application.
• Created test plan and test cases for user acceptance testing.
• Wrote SQL queries through Rapid SQL to check the population of the data in various data tables.
• Performed Data Migration and Mapping of the entire module and complete analysis to integrate.
• Produced and managed documentation on release activities to support Problem Resolution and Post-Release Analysis.
• Assisted Project Manager in keeping a track of development.

Environment: MS Excel, MS Word, MS PowerPoint, Erwin, Java, JIRA, Sybase, Rapid SQL, UML, Share Point.

Confidential, MA

Sr. Business Analyst

Responsibilities:

• Prepared, analyzed as Is Process Flow and Designed the to Be Process Flow of existing architecture and performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the change in the proposed system.
• Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the business from the conceptual to procedural level.
• Led client facilitation meetings to gather Interface and Business Process Requirements from Subject Matter Experts of implementing them into Business Requirement Document ( Confidential ).
• Collected and documented the business processes and business rules, translated the Business and User needs into System requirements. Provided key input in working with users in defining project and system requirements.
• Responsible for capturing the functional requirements using User Stories in Agile Methodology for each and iteration.
• Prepared Textual Use Cases, Activity Diagrams, and Business Flow Diagrams using MS Visio.
• Responsible for conducting the Daily Scrum meeting, and estimating timelines against the deliverables for each iteration.
• Closely work with front office, clearing house, back office and product development team to resolve clearing issues.
• Created Power Point Presentation of project & Fitnesse overview using MS Power Point for higher management.
• Worked with SQL queries using the Embarcadero Rapid SQL tool.
• Introduced Agile based Fitnesse framework to the project for UAT and regression testing which reduced external component integration testing as well as saved testing time.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Developed and maintained Fitnesse MS Excel test scenarios.
• Assisted in testing applications and reported bugs to development team. Streamlined and coordinated the bug and defect tracking and rectification effort, on a tool name JIRA.
• Interacting with the stakeholders to get an overview of client business processes and upstream dependency.
• Elicited and acquired reporting requirements through user interviews and Brainstorming sessions. Analyzed the Requirements and created the Business Requirements Document ( Confidential ) and Functional Specifications document (FSD).
• Created Reporting process work flow diagrams (Activity Flow diagrams).
• Created UI prototype and wire frames using MS Visio collaborated with development team in identifying elements from user’s perspective.
• Involved in understanding the existing procedures for getting the data from Risk, Accounting, P/L and custodian systems.
• Participated and strongly contributed in creating various enterprise reports to support Risk Analysis, Profit/Loss, Available Position, Asset Management- Risks and Returns, Financial Derivatives, Portfolio Analysis and Margin Requirement.
• Managed reporting data requirements, application features & bug tracking using JIRA.
• Made presentation demos to clients and conducted UAT (User Acceptance Testing).
• Wrote SQL queries through Rapid SQL to check the population of the data in various data source.
• Conducted weekly status report and milestones with upper management to indicate the progress of the application.

Environment: MS Excel, MS Word, PowerPoint, Java, JSP/Servlet, Spring, JIRA, Sybase, Web Services, Rapid SQL, RV