PROFESSIONAL SUMMARY

• 9 years of experience as a Business Analyst with the ability to understand and analyze complex business requirements. Have a detailed and thorough understanding of various domains like Finance, Banking, Pharmacy and Healthcare.
• Expertise in Software development methodologies like Agile, waterfall and Rational unified Process RUP methodologies.
• Experienced in various documents including the System Requirement Specifications SRS , Business requirements document BRD , Use Cases, Functional Specifications FSD , Systems Design Specification SDS , Requirement Traceability Matrix RTM and testing documents.
• Experience working with Autosys job scheduling model and design of detailed work flow for execution.
• Extensive knowledge of Job Information Language JIL and SimCorp Dimension.
• Experienced Professional in creating detailed Use-Case Models, Data Flow Diagrams, Sequence Diagrams, Collaboration diagrams and Activity Diagrams. Expert at creating, tracking and quarrying defects / activities to create reports in Quality Center, Test Director and Rational Clear Quest.
• Facilitated project meetings, reviews, walkthroughs, and customer interviews to gather requirements and relevant information for Business analysis. Generated Requirement Traceability Matrices to ensure that all the requirements were met in each phase of the Software Development Life Cycle.
• Exceptional Problem Solving and Sound Decision Making capabilities, along with the ability to resolve difficult situations. Creative and aggressive self-starter with integrative thinking skills and capable of communicating creative ideas through Graphical Modeling.
• Designed and Maintained Reporting Batches using Autosys.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading ETL and Business Intelligence BI tools.
• Worked on JIRA issue tracking product, bug tracking, issue tracking and project management.
• Expertise in Software Development Life Cycle such as Project Analysis, Requirements, Business System Design, System/Integration testing, UAT Implementation.
• Expertise in writing Test Plans, Test Strategies, Test Data requirements, Business Assurance Strategy, Defect Management process, Test Execution and Test ID Strategies.
• Expertise in communicating with Clients/Users periodically to review the requirements, goals and their expectations and provide test results and project status.
• Excellent experience in Quality Center Management such as RTM, Execution Results Tracking, Defect Management and Reporting.
• Excellent experience in completing the projects in agile methodology with sprints and exposure on automation tools. Excellent problem solving skills with strong technical background and database skills and ability to meet tight deadlines.

TECHNICAL SKILLS:

Methodologies: SDLC, RUP, AGILE, Waterfall.

Modeling Tools: Use Cases, UML, UAT Test plans cases, Ignite XML

Office Tools: Microsoft Office MS Excel, MS Word, MS Power Point, MS Project, MS Outlook , MS SharePoint, MS Visio

Languages: XML, MySQL

Investment Mgmt. SimCorp Dimension

Reporting Tools: Crystal Reports

DBMS: MS Access, SQL Server 2000/2005, MySQL

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr Systems Analyst

Responsibilities:

• Worked as part of the Securities Account Management team: A single securities account platform that provides a simplified architecture, streamlined systems and faster time to market and enables the business to make faster, more flexible and financial decisions.
• Supported execution team in Autosys job execution and analysis of work flow.
• Investigated long running jobs and took required actions to ensure batch completed successfully.
• Updated the Runbook based on logical dependencies to reflect new changes made.
• Verified visio diagrams to ensure all box jobs and dependencies within each work streams were represented correctly.
• Assisted in the strategic planning of executions timelines to meet milestones.
• Responsible for updating and maintaining tracker for daily runs and verifying total runtime.
• Assisted in troubleshooting SimCorp related failures by determining cause/escalating issues.
• Proactively monitored jobs to ensure successful execution.
• Assisted colleagues in bringing them up to speed by executing dry runs in dummy environments.
• Tracked and updated all errors/failures in issue list.
• Ran queries in Toad to check transaction status. Also performed Sanity Check.
• Monitored the workflow log in Informatica in case of an ETL job failure and escalated to support team.

Environment: Autosys, SimCorp Dimension, Informatica, Toad, WinSCP, ClearQuest, BMC Remedy, MS Visio

Confidential

Role: Sr.Business Analyst

Responsibilities:

• Research, Feasibility Studies, Data Analysis, System Analysis, Gap Analysis,
• Conducted UAT to confirm that all services were performing as planned during each sprint cycle.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues and reach agreements necessary.
• Responsible for creating documents to transfer servicing notes from HSBC application to TSYS System.
• UML Business Use Cases from requirements, including Use Cases Diagrams, Class Diagrams, State Diagrams, Entity-Relationship diagrams.
• Conducted user interviews, gathered Sequence diagrams using MS Visio
• Analysed business requirements and created WSDL and WADL files to reflect changes in the new framework.
• Experience in UNIX Shell Scripting and Autosys for scheduling the Workflows.
• Documented the mappings used in ETL processes.
• Wrote functional and non-functional specifications for wealth management applications.
• Develop standard operating procedures, business workflow processes, and training manuals.
• Assisted in the production of Change Management deliverables testing documentation, training documents and business process flows .
• Understood the flow of Loan/lease originating accounting processes and captured it in Process Diagrams.
• Helped in writing training manuals, scheduled and trained junior BA's using PowerPoint got it reviewed and approved by the project team and clients.
• Acted as a liaison between the technical group and business users PM, PMA and trader throughout the project cycle.
• Created API's and coordinated with data modelling team over use of existing elements and presented justification in the case of creating new elements. Also presented changes to design review board for approval of API pages.
• Assisted offshore team in understanding requirements through daily scrum calls as per customers' needs.
• Collaborate with ETL team to understand their matching process in order to Design Data Model for Supply Track business, handling the Raw and NPD customers well and to ensure data integrity and quick data retrieval.
• Arranged training modules for new process development and implementation.
• Built the foundation for process implementation in MS-SQL, data integrity procedures and quality control reports using SQL and UNIX Sync.
• Migrated Data from MS Excel to SQL Server Reporting Service using Sort.
• Conducted workflow, process diagram and DTDs and SQL loader utilities.
• GAP analysis by identifying existing technologies, documenting the enhancements
• Used MS Visio to develop Use Cases to meet the end state requirements
• Wrote system requirements specification SRS , Data transformation Document DTD as per the Business requirements and process.
• Performed SQL Queries and PL/SQL stored procedures on the models.
• Acting as the interface and a single point of database to extract data.
• Contact with the customer for his security related, technical issues and for the entire documentations and the written as well as the verbal correspondence
• Involved in UAT, test plans, documentation of test reports etc

Environment: Rational Unified Process RUP , MS Office Suite, TSYS, XML, Autosys, MS Visio, MS Excel, Windows XP/NT, Rational Rose, Clear quest, SQL Server

Confidential

Role: Sr. Business Analyst

Responsibilities:

• Created functional and non-functional requirement documents and technical specification documents and delivered within project timelines by conducting user interviews for requirements gathering, analysis, and design.
• Wrote SQL query to extract data from the tables to validate data flow.
• Provided business analysis for fixed-income security, risk ledger, market risk and credit risk, commodity and financial risk management including complex structured transactions. modeling and analysis for trading strategies and patterns monitoring
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Worked with Fixed Income traders to facilitate technical team with functional aspects of various capital market instruments.
• 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 .
• Developed and configured Autosys JILs scripts to automate all the Perl script jobs.
• Worked on end-to-end ETL process including data Extraction, Transformation and Loading from source systems using Informatica.
• Perform credit risk and Market risk assessments of new customers.
• Worked on CA workload system GUI to manage the Autosys process created.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle SDLC to discuss open issues and resolve them.
• Used SQL queries to transfer data from the server to the web page. Conducted presentations on the progress of the project after ever phase of SDLC based on RUP methodology.
• Skilled at performing GAP analysis, User Acceptance Testing UAT , SWOT analysis, Cost benefit analysis and ROI analysis.
• Met with client groups to determine User Requirements and Goals, thus converting User Requirements and Business Requirements into Functional Requirement Specifications.
• Assisted with Manual and User acceptance testing of the systems UAT , developing and maintaining quality procedures and ensuring that appropriate document is in place.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions and locking issues.
• Worked on ETL processes using Informatica tool to load data from Oracle 9i, DB2 into the target Oracle 9i Datawarehouse.
• Created test data for validation of code using XML.
• Identifying and measuring risk ledger faced and calculating credit risk, making decision on the applications and preventing loss by evaluating credit risk.
• Facilitated UAT and test strategies with developers and testers and performed manual front-end testing to check all the functionalities incorporated with the different modules. Involved in UAT session to test the system with stakeholders.

Environment: RUP, Rational Rose, Rational Clear Case, XML, ETL, Oracle, Autosys, Windows 2000, SQL server, MS Office Suite, UAT,UML

Confidential

Role: Sr. Business Analyst

Responsibilities:

• Gathered requirements, defined specifications by interviewing the business user group. Agile software methodology was implemented on this assignment.
• Created business use case, functional FRS and technical specifications for trading system.
• Analyzed the Capital Market businesses to understand the architecture of the various processes and participated in a strategic decision making process about what applications needs to be decommissioned to reduce the cost.
• Performed in software testing which involved development of test cases and test scripts and User Acceptance Testing UAT .
• Created XML block additions and modifications based on business rules and workflow modifications to capture and manage client policy and underwriting data required to issue policy for a prospective insured.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Defined and elicited the Business rules for consumers, small businesses, private, platinum, wealth management.
• Experience working on Liquidity Deposit, Analysis and/or Loan Systems required.
• Manage daily cash books, bank account transfers, Liquidity deposits, reimbursements, reconciliations and fraud controls.
• Worked on mainly market risk, risk ledger and some credit Bank- wide credit risk done in a separate database aggregating various systems output.
• Wrote test scripts for unit and integration testing and coordinated internal and external user acceptance testing UAT
• Interacted with the fixed income investment broker officers and understood their need in fixed income trading on behalf of the clients.
• Wrote test scripts for unit and integration testing and coordinated internal and external user acceptance testing UAT
• Analyze credit data and financial statements to determine the degree of risk involved in extending credit risk or lending money..
• Besides routine responsibilities of credit analysis, measuring risk factors, validating customer's financials. I also worked on various projects relating to red flag reports.
• Wrote test cases and test scripts for the User Acceptance Testing. Also, performed some parts of testing.

Environment: UML, Use Case Analysis, MS Office - MS Word, MS Excel, MS Power Point, MS Visio, XML, Rational Rose, ETL, Rational Clear Quest, SQL, UAT.

Confidential

Role: Business Analyst

Responsibilities:

• Implemented an integrated RUP solution with complete line of traceability for all the artifacts of web development projects.
• Involved in the development of test cases for the Informatica mappings and update processes.
• Involved in the creation and maintenance of the Workflow plans and artifacts
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
• Prepare test plans and test cases for User acceptance testing UAT
• Conducted SWOT Analysis for better market understanding and fool proof project implementation
• Familiar with Data extraction, Data Migration and Data conversion using ETL tools from application front-end with SQL databases as Source.
• Documented Requirement Traceability Matrix RTM for requirement elicitation and linkup to deliverables
• Worked with the individual sub-project managers to translate these into PRDs Product Requirement Documents for the development teams
• Examined, analyzed and model Test plans, Use Case Model cases Test procedures based on RUP methodology
• Designed and developed Quality Assurance standard and processes to all levels of project team
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements
• Performed UAT and logged test results according to the test plans using Test Director

Environment: Microsoft Office, UAT, Rational Requisite, Informatica, RUP, RUP, UML, SQL, Test Director.

Confidential

Role: Business Analyst

Responsibilities:

• Worked with internal product management teams to include this functionality in the product release cycle
• Interacted with the SMEs to prepare BPR documents for the ongoing projects and business process flows
• Developed requirements documents for Cyber lab Filter packs and requirements to incorporate certain modules of Bio analytical data from Thermo sampler LIMS and Electronic Lab Notebook to the Cyber lab in a GLP regulated environment
• Incorporated appropriate metrics at gates, and formalized roles and responsibility charting. RACI- Responsibility, Accountable, Consulted, Informed
• Established an enterprise-wide model to bring continuous improvement in product forecasts across different product launches/regions.
• Developed use cases, use case specs and models, work flow diagrams, process flows, Activity and sequence diagrams.
• Assisted project managers to manage scope, schedule, and cost benefit analysis for the project between various stakeholder groups and within the project team, in order to resolve conflicts.
• Coordinated project communications including status, risks, issues, escalation, etc.

Environment: SDLC, Agile, Scrum, UML, Rational Requisite Pro, Clear Case, UAT, MS Visio, XML, HTML, Microsoft Office.

Confidential

Role: Business Analyst

Responsibilities:

• Worked with Business Analyst in translating business requirements into Functional Requirements and to Detailed Design and review all deliverables,
• Coordinated and communicate tasks with developers and ensure that development is performed as per requirements.
• Prepared Technical specification document and provided technical guidance to the team
• Performed data analysis and data mapping from source system to target systems
• Wrote complex SQL scripts to load data extract into Analytical Data Warehouse using PL/SQL packages, procedures, functions, triggers, views, dynamic SQL, and reference cursors.
• Preparing Requirement for Unit Testing, Functional Testing , E2E testing and Performance
• Manage Test Executions and Defect Management
• Preparing Traceability Matrix and manage throughout the project
• Responsible for production support 24/7 to fix any production issue within stipulated time frame

Environment: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Access, Rational Requisite, RUP, Oracle.