SUMMARY

• 7+ Years Professional Experience as Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling and Financial Analysis
• Solid experience in Finance Industry, Investment banking, Retail banking, Commercial banking, Credit Cards and Insurance
• Extensive experience in Investment Advisory, Wealth Management Services and Product Management.
• Deep knowledge and experience of Performance Measurement and Reporting in Wealth Management and Portfolio Management. In depth knowledge of Billing procedures and the Accounting processes.
• Comprehensive knowledge of and Solid experience in Software Development Life Cycle (SDLC) Methodologies, Microsoft Solutions Framework (MSF), RUP.
• Strong understanding of project life cycle and SDLC methodologies including RUP,RAD, Waterfall and Agile, familiar with learning management system (LMS) with student accounts, student login activity, certification tracking.
• Involving in the implementation of Workday HCM for various HR modules such as Benefits, Payroll, Recruiting, Time Tracking and Talent Management.
• Expertise on Data/Business Analyst in ETL process, Business Intelligence, business process analysis/modelling, database design and development of Web based and Client based/Server applications.
• Writing complex SQL Queries to test the Data Stage ETL process.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Developing Scope /Vision documentation and Project Plan, identifying and analyzing the key project risks. Developing risk mitigation plan. Interacted with various departments to schedule and organize project meetings, team/group meetings and manage resources to ensure successful delivery.
• Extensive experience in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses
• Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions.
• Collect, analyze, organize and document Business Requirement (BRD).
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting Procedures.
• Knowledge of traceability Matrix Handle requirement Change and handling User Conflicts. Knowledge also of Conceptual designing and Logical designing as well as High level Designs.
• Experience in conducting Test plan, Unit test, System test, and Implementation. Have also done User Acceptance Testing (UAT), SWOT Analysis, Cost Benefit Analysis and ROI analysis.
• Strong hands on ability to use SQL in RDBMS DBMS, (SQL Server, Oracle) for verifying source data preparation and assisting of data design input and trouble - shooting.Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture

TECHNICAL SKILLS

Programming Languages: NET, ASP.NET, Java, SQL, PLSQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, DB2, RDMS, DBMS, Sybase

Application Servers: IBM Websphere, ATG DynamoInternet HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisiteProDocumentum, DOORS, Sharepoint

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOADReporting Tools Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr. Business System Analyst

Responsibilities:

• Leverage strong business knowledge of the investment banking sector to help design viable solutions.
• Responsible for interacting with business heads for designing integrated accounting and business processes.
• Received appreciation from very senior management for the insights provided for designing innovative business solutions.
• Contributing towards Workday HCM roll out on and full implementation which includes configuring Security, Roles, Business Processes, Reports, Data migration.
• Built and pluggedininternal annual data audit tools for LOBs within their BAU process.
• Conducted Functional Analysis and Gap Analysis for designing robust solutions
• Involved in creating Data Flow Diagrams for Database of the Investment Portfolios
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
• Implementing Workflow for Core HR, Compensation, Position and Profile management functionality and changes to existing HR/Payroll business processes for migrating to Workday HCM system.
• Extensive experience in configuring data mapping between different Databases.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
• Created surrogate key tables to map the required dimensions.
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Mapping and tracingSystemwide data gathering fromDBMSwithin the Entities enhancing the systems info and overall performances. Low Level Design detailing the relation between various modules and functions of thesystem.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Organized various UAT sessions and made presentations to the users on the project and the changes implemented.
• Worked on Credit Risk project management for data warehousing, data feed specifications to ensure capital allocation more risk sensitive; wrote high-level functional designs and data mapping specification designs
• Reviewed several test plans and test scenarios with the QC team for each project worked on.
• Successfully conducted Root Cause Analysis to identify the underlying issues and design solutions accordingly.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Conducted JAD sessions to resolve critical issues
• Responsible for creating and reviewing business requirement documentation (BRD), functional specifications (FSD), project schedules and test plans.
• Worked closely with the QA team and reviewed the test scenarios as well as test cases.
• Assisted in development of training materials for new technology and process improvement
• Responsible for Application Documentations and served as a liaison between the business team and the technical team by assisting in identifying, understanding, and documenting their business requirements
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes on the organization and conducted project related presentations.

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .CICS, NET, Oracle, Crystal reports, RUP, UML, SQL, DB2, DBMS,SWOT analysis, COBOL, GAP Analysis, Win Runner

Confidential, Newark, NJ

Business Analyst

Responsibilities:

• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Offered excellent Cash Management Services including Account Reconcilement Services, Automated Clearing House, Balance Reporting Services, Cash Concentration Services and Sweep Accounts to large business customers
• Assist end users and IT staff in the use of data to satisfy informational and reporting requirements and implementing and using SQL and DBMS.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Worked on Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL .
• Created and Documented test cases and test data for Business Users.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Facilitated JAD sessions with end users, development and QA teams.
• Developed the Test plans for quality assurance based on functional requirements.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk.
• Responsible for improved service, reduce coding errors, improve consistency, improve profitability, improve cash flow and reduce facultative placement errors through a front-end reinsurance system.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Assisted in creating wireframes for web interface with the GUI design team.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system.
• Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.

Environment: Oracle, SQL Server, SQL, RDMS, DBMS, Windows, Rational Enterprise suite, MS Office, MS Project.

Confidential, Murrysville, PA

Business Analyst/Data Analyst

Responsibilities:

• Studied and assessed the clients systems and business processes.
• Understood the business and gather requirements from various users.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Established a business Analysis methodology around the RUP (Rational Unified Process).
• Analyzed and re-engineered the lifecycle to ensure that the riskier claims could be easily identified and monitored.
• Assisted in building a business analysis process model.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Performed requirement analysis, went through all the use cases and workflows.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Conducted JAD sessions to resolve critical issues
• Responsible for creating and reviewing business requirement documentation(BRD), functional specifications (FSD), project schedules and test plans
• Developed the test plan, test conditions and test cases based on business requirements, technical specifications and product knowledge
• Helped in migrating from the legacy system to the proposed new process systems
• Worked closely with Internal Auditors to review Compliance requirements and ensured appropriate documentation was in place
• Conducted User Acceptance Testing (UAT) for the new process designed.
• Conducted benchmarking activities to identify best practices. Claim data analysis

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), XML, Java, Unix, C++, COBOL, Mainframe, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Stanford, CT

Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis. 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.
• Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency)
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Developed multiple Functional Requirements defiantion (FRD) documents using the Microsoft standard structure and format (business sections only)
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Rational Enterprise Suite (Rose, ClearCase, ClearQuest), RUP, Visual Basic, MS Project, SQL, SQL Server, Oracle, C#.Net, WebLogic, IPFR MS Visio, Services, HTML, UNIX, DreamWeaver, Adobe Photoshop, Windows Forms, Web Forms, LoadRunner, WinRunner, DOORS, Project Management.