Summary

• Around 8 years of experience as a Business Analyst with in-depth knowledge of business processes in Risk Management, Insurance, Asset Management, Investment Banking, and Financial Services.
• Hands-on expertise spanning across System Analysis, Software validation, Financial Data Analysis, Data Modeling, Business Function specifications, Flow diagrams and GAP analysis.
• Sound knowledge of all Asset classes Equities, Fixed Income, Derivatives, FX , Financial Statements, FP A, Portfolio Analysis, CCAR Comprehensive Capital Analysis Review , Basel I, II III accords, Dodd-Frank regulations, Compliance/Risk Management, Life/Health Insurance.
• Expertise in project assessment, functional analysis, and requirements gathering Converting business requirements into BRD, Functional FRS , Non-functional, User URS and the complete System requirement specifications SRS documents in a Requirements Traceability matrix RTM .
• Creating data models, writing detailed Use Cases with Basic, Alternate, and Exception Scenarios, UML Diagrams, Process Flow Diagram, Wireframe and other elements using iRise, Caliber RM, Caliber RDM, MS Visio, Enterprise Architect and Rational Rose.
• Coordinating JAD sessions and interviews to converge towards a design acceptable to the customer and feasible for the developers.
• Excellent analytical and communication with the ability to interact with all levels of hierarchy including VP's, MD's, Support Managers off-site/on-site, Project Managers Solution Architects.
• Adept in performing various analyses: GAP, Feasibility, and SWOT Analysis.
• Hands on experience in using RUP, Requisite Pro, and Rational and Quality Centre tools.
• Well-versed in SDLC methodologies such as Waterfall, RUP, and Agile SCRUM leveraging across multiple frameworks with thorough understanding of the various phases.
• Strategic development of a Data Warehouse, modeling Transactional Databases, Data Marts and writing queries to sample/select/extract large data sets from disparate data sources using SQL.
• Skilled at implementing QA techniques, creating screen mockups and setting up Test Environments in addition to writing Test Plan and Test Cases.
• Conducted functional walkthrough, performed various System testing such as Regression, Integration, Functional, Smoke and UAT and thereby obtained necessary signoffs and assisted in the development of User Manuals for customers.

Skillset:

MS Visio, MS Access, MS Project, MS SQL Server, PL/SQL, SharePoint, Rational Suite Clear Quest, RequisitePro, Clear Case, Rose , iRise Studio, Cognos Report Net / Framework manager, Query Studio, .NET, Visual Studio, IBM Infosphere Datastage, Caliber RM, Erwin, UML, TOAD, WinRunner, LoadRunner, HP Quality Center, MS office suite, MATLAB, Bloomberg, Advanced Excel and PowerPoint Vlookup, pivot tables, macros, charts, and reporting , Financial modelling and CFA Level II candidate.

Projects Summary:

SUMMARY

SQL/C /C developer in Microsoft stack with team leadership and management experience as well as 15 years of software development expertise.

EXPERIENCE

Confidential

• Innovative purchased Polaris in April 2014 this is the same company as Polaris. Just noting that here as this is a common question.
• Worked on development of the Polaris ILS, running on Windows client/server. Instrumental in multiple phases of development cycle Analysis, Design, Implementation, Testing/Bug Fixing/Documentation . Used C /C in an MFC/.Net environment to design and implement business logic and UI.
• Have worked extensively with SQL language to design and implement database architecture and stored procedures. Have done extensive work with SQL performance tuning and index manipulation.
• Led project involving product analysts, developers, quality assurance, documentation in 2012 to work with eBook vendors to more tightly integrate their software into the Polaris ILS suite of products. Oversaw the integration of 3M eBooks into the Polaris ILS, and built a framework for other eBook vendors to be added easily.
• Managed a team of R D and QA in 2014 during a period of rapid turnover in the business, layoffs, folks placed on transition periods, etc. Made every effort to keep those on the team focused on getting software coded and tested despite the many distractions around a company which had just been acquired and paired down.
• Handled various tasks associated with management of people, and served as the programming liaison to the customer support team so that a high level of customer service could be maintained, while team members stayed focused on completing new software development/testing in a 4 month timeframe.
• Helped guide the team to a successful release of a major version of Polaris software in 2014 using the agile software development methodology. This was already being used in other areas of the company, but it was new to the team. Worked extensively with product management to help mitigate the learning/thought curve associated with 10 years of previous experience writing requirements in word documents as opposed to user stories
• Managed/developed remotely from home in Raleigh NC for over 2 years and visited the Syracuse office regularly. Used IM and video conferencing to do this effectively.
• Worked with development staff in other locations Emeryville, Blacksburg VA on the beginning of a corporate wide software integration strategy covering over 20 different product lines.
• Experienced with RFID technology and integrating into Polaris ILS.
• Completed projects using web services and helped to develop Polaris RESTful API to allow customers to leverage Polaris functionality.
• Been involved with employee mentoring on numerous occasions.
• Have strong rapport with members of the library software customer base have attended numerous User Group meetings and have worked directly with customers on improvements for the Polaris products.

Confidential

Bug fixes for web based application. HTML, C, Linux programming/OS.

PROGRAMMING LANGUAGES

Extensive experience programming/DB design with TSQL. Extensive experience with C . Worked on and created projects with C . Understanding of XML, HTML, JSON.

PROGRAMMING TOOLS

Microsoft Visual Studio 2010/2013, .NET, SQL Server 2008 R2/12, SQL Profiler, VSS, TFS, SSRS

Business Analyst

Confidential

Responsibilities:

• NAM Region
• Performed Impact, Gap and Scope analysis during different project phases.
• Wrote VBA / Macros to automate testing process in Excel to perform system and regression tests.
• Performed usage modeling by creating Use Cases, User Interface Designs, Prototyping, Screen Flows, and Storyboarding using MS Office and Rational Rose.
• Performed data analysis, and data modeling by utilizing database management and SQL skills.
• Collaborated with the QA and data teams to design test scenarios and test cases to perform system testing, regression testing and maintain traceability matrices for baseline documents.
• Worked closely with project managers to assist them with project plans, budgeting, scope creep, feature creep, feasibility analysis-schedule, strategic benefit analysis and technical, economical and operational feasibility study.
• APAC Region
• Worked extensively with SME's including heads in areas of derivatives, FX options, swaps and futures in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
• Actively involved in Portfolio wide Credit risk functions like risk due to exposures, correlations, VaR due to trade compressions etc., while staying in compliance of Dodd-Frank risk-reforms.
• Organized JAD sessions with stakeholders including Line of Business LOB , Technology, and Operations to document project governance, workflows, high level design processes, user and requirement Specifications in the BRD and FRD.
• Involved in developing test case objectives to ensure accurate depiction and computation of risk of the securities, reported errors to the appropriate team and performed black box testing after the technical team corrected these errors. Performed complete analysis to integrate Risk Analyzer.

Environment: MS Project, MS Office Suite, Rational Requisite Pro, Quality Center, MS SQL Server, and Business Objects.

Confidential

Business Analyst

Responsibilities:

• Involved in creating targeted questionnaires and conducting interviews for project sponsors, stakeholders Data Strategies Operations team, and Ratings Analysis team , clients and business users to gather requirements while proactively communicating with SME's, clients, data architects and management to analyze and prepare business and functional requirements documents.
• Critically evaluated the information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details along with the ability to use the detail to gain an understanding of the end-to-end solution developed and utilized standard templates to accurately and concisely write requirement specifications using Requisite Pro.
• Pro-active in identifying data gaps for the mortgage data received from various sources and resolved them by actively working with business teams.
• Performed analysis on all financial control policies including income statement and balance sheet reporting revolving around structured finance products and automated processes.
• Involved in business process-reengineering to prepare use case documents and utilized MS Visio to create UML diagrams including use case, activity and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the requirements.
• Involved in Feasibility, GAP and Risk Analysis to identify the business critical and high-risk areas of the application that arose from using multiple data gathering sources.
• Studied the Basel III accord. Led the Basel III Data GAP Assessments DGA , created spreadsheets, and analyzed possible scenarios within S P's risk-adjusted capital framework RACF .
• Used SharePoint to stay in sync with all teams and organize meetings to collaborate and track project progress.
• Performed data analysis, data modeling by utilizing database management and SQL skills and corrected measurement errors as part of data reconciliation.
• Expert in impact analysis on how functional requirements impact various systems.
• Facilitated the design process to plan intuitive workflows, created detailed GUI wireframes and mockups and designed process models, specifications, diagrams, and charts to provide direction to developers.
• Performed requirement walkthroughs with the development and QA teams to assist in developing a test plan such that test cases reflect user needs.
• Collaborated with the QA team in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements.

Environment: MS Office Suite, MS Visio, Sharepoint, Rational Requisite Pro, Enterprise Architect, SQL, Informatica, C, SAS, R, MS Vision 6.0, MATLAB, Spotfire, Clear Quest, Qlikview, Erwin, WinRunner, LoadRunner, and HP Quality center.

Confidential

Business Analyst

Responsibilities:

• Served as a subject matter expert for end to end claim processing: First Notice, Assignment, Evaluation, Settlement, Recovery and File Review. Planned and facilitated JAD sessions focused on functional areas of the claim life cycle and created the functional requirements specification FRS from the business requirements.
• Partnered with claim service teams to understand business objectives, technical and integration requirements based on all functional areas of the claim life cycle.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
• Created Business Process Flow, Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Scheduled meetings with developers, SAs System Analyst and testers to collaborate resource allocation and project completion using MS Project.
• Created Mock-up forms in MS Access for better visualization and understanding of the software solution. Regularly worked with the CMA Claim Management Application teams.
• Assisted the SA to document all custom and system modification and notify problems to appropriate software development team for fixes.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
• Authored progress and completion reports which were then submitted to project management on a weekly basis.
• Prepared test cases and test plans and carried out the UAT as per the perspective of the users.

Environment: J2EE technology, Windows 2000 Advanced Server, SharePoint, UNIX / Oracle Platform, MS Visio, Load Runner, Rational Rose, Rational Clear Quest, and Rational Clear Case.

Confidential

Business Analyst

Responsibilities:

• Performed Requirements Management involving elicitation, analysis, validation, communication, planning and documentation and as a result, identified and understood the business objectives and the impact of the proposed solution on the current operations.
• Involved in designing various screens such as Portfolio selection based on date, kind of securities, Ratings, performance etc. and performing sensitivity analysis with changes in the parameters.
• Hands on experience with SunGard Integrity SAAS to support the Global Treasury Workstation implementation.
• Organized JAD sessions with stakeholders including Line of Business LOB , Technology, and Operations to document project governance, workflows, high level design processes, user and requirement Specifications in the BRD and FRD.
• Involved in developing test case objectives to ensure accurate depiction and computation of risk of the securities, reported errors to the appropriate team and performed black box testing after the technical team corrected these errors. Performed complete analysis to integrate Risk Analyzer.
• Performed Impact, Gap and Scope analysis during different project phases.
• Performed usage modeling by creating Use Cases, User Interface Designs, Prototyping, Screen Flows, and Storyboarding using MS Office and Rational Rose.
• Assisted in change management, issue resolution and troubleshooting for change in requirements.
• Performed Data Analysis and Data Mappings for Operational and Enterprise Data Warehouse.
• Collaborated with the QA and data teams to design test scenarios and test cases to perform system testing, regression testing and maintain traceability matrices for baseline documents.
• Complied with QA processes and methodologies and ensured the entry and exit criterion for the different phases accompanied with formal sign-offs.

Environment: MS Project, MS Office Suite, Rational Requisite Pro, Rational Rose, SunGard, Bloomberg, Oracle 10g, IBM Mainframe, Quality Center, MS SQL Server, and Business Objects.

Confidential

Business Analyst

Responsibilities:

• Assisted Project Manager in maintaining and monitoring project progress and status using MS Project, providing high level estimates of efforts for analysis, implementation and support of application, estimating delivery schedule and resource allocation.
• Identified and documented business needs created detailed Use Cases using UML Collaborated with production team to identify map existing processes, identify system gaps and developed functional requirements documentation FRD to support overall strategy, goals and objectives.
• Expert in using iRise simulation tool to create text documents, spreadsheets, flow diagrams, static screenshots and wireframes to communicate clearly between business and IT stakeholders.
• Strong understanding of Front, Middle and Back Office Operations analyzed and proposed enhancements, including automation to improve processing of security settlements for Operations.
• Involved in Prime Brokerage Technology quality assurance analysis, testing and supported UAT.
• Worked on requirements gathering, Internal and External Client reporting, testing and quality assurance for Prime Brokerage applications for trading fixed income, equities, Options, Swaps, REPO, ABS, CDS and MBS products etc.
• Efficiently used prime brokerage application- Excalibur, which is a trade entry and trade management application that services hedge fund clients.
• Thorough understanding of the trade lifecycle and work flow of the securities trading industry and middle to back office derivative hedge fund accounting processes.
• Assisted Project Manager by conducting research and analysis, and accurately defining user requirements and processes needs for the business solutions of Market risk and Credit risk Management and their support teams.
• Strong experience with Derivatives i.e. SWAPs, Options, and Futures
• Collaborated with project manager to define project scope, risks and determined appropriate methodologies to apply based on Scope/Vision documents, and developed project time lines for on-time delivery based on SDLC methodology.
• Wrote SQL Queries extensively against different databases, generated different reports and analyzed the data them as per the company requirement.
• Conducted UAT, documented and reported user feedbacks to management team, and developed training materials for different end users and assisted in User Training for the new system.

Environment: Windows XP, MS-SQL Server, MS Office Suite, iRise Studio, Visual Studio, MS-Project, HTML, XML, Rational Request Pro, Test Director, MS Visio, XML, Bloomberg, and Crystal reports.

Confidential

Business Analyst

Responsibilities:

• Conducted the current state analysis of AXA policy admin systems and Customer information file database and documented the process.
• Involved in gathering, analyzing and prioritizing business and functional requirements specifications for Customer Data Discretionary project using tools and techniques of AXA's System Development Life Cycle.
• Participated actively in AXA BRD inspections to satisfy the Champions defined standards and methodologies from the AXA Equitable Software Development Life Cycle SDLC , CMMi and other compliance SOX, SEC, and FINRA programs.
• Developed subproject/work stream BRDs for Customer Data project and worked proactively and cohesively with other work streams to ensure complete project coverage.
• Conducted Business requirement documents review with project team and stake holders to get sign offs published and communicated them to various other IT and business teams to follow up on project dependencies.
• Documented the functional characteristics and specifications of the system in collaboration with project team and worked with Business experts for signoff.
• Worked with Data governance team to establish Governance council with data stewards and enterprise governance policies.
• Actively supported the goals and activities of the AXA's Business Analysis Center of Excellence.

Hardware / Software: IBM infosphere product suite, MS Visio, MS Office Suite, MS Project, UML, Windows XP, Quality center.