SUMMARY

• 10+ 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
• Adept at managing all phases of SDLC (waterfall and Agile/Scrum Framework) from requirement gathering to testing and implementation.
• InformaticaServer Manager, Repository Server Manager,Informaticadata quality (IDQ), and Power Exchange.
• Experience in installingInformaticaand configuration in windows and UNIX environment.
• Performance tuning of theInformaticaand Databases.
• Experience in Data Integration, Extraction, Transformation and Loading data from multiple heterogeneous data source systems like Oracle, SQL Server, DB2, Sybase, Teradata, XML and Flat files into Data warehouse by usingInformaticatool.
• Proficiency in usingInformaticaPower Center to design data conversions from wide variety of sources.
• 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.
• Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client - Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
• Proficient in Testing methodologies, Test Matrices and Trace matrix
• Experience in writing automated scripts, designing Test procedures, Manual Test cases And preparing Quality feed back to QA team & manager
• 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, analyse, 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 Dynamo

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum, DOORS, Sharepoint

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD

Reporting 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, Newark, NJ

Business Analyst

Responsibilities:

• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Expertise inPL/SQL(Oracle 9i, Oracle 10g, Oracle 11g) programming like writing Packages, store procedures, functions and Triggers in Oracle
• Performed tuning ofInformaticaMappings for optimum performance.
• Created web service jobs by configuring WSDL in designer and usedInformaticaWeb Services Hub to start theInformaticatasks.
• UsedInformaticaDynamic Deployment groups to deploy theInformaticajobs among different environments (DEV, TEST, QA and PROD)
• Worked with active transformations inInformaticapower center like Filter, Aggregator, Joiner, Rank,
• Router, Sorter, Source qualifier, Java and Update Strategy transformations.
• Reviewed and testedInformaticaETL code and wrote test plans.
• UsedInformaticaWorkflow Manager and Workflow Monitor to schedule and monitor session status.
• Created complexInformaticamappings, reusable objects of Mapplets depending on client requirements
• Oracle PL/SQLcodes for complex transformation to process data to mart layer using various analytical functions, collections, types and cursors
• Oracle PL/SQLprograms, procedures and Packages
• Expertise inInformaticaMater Data Management
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• 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.
• 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.
• 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.
• Expertise inPL/SQL(Oracle 9i, Oracle 10g, Oracle 11g) programming like writing Packages, store procedures, functions and Triggers in Oracle
• Performed tuning ofInformaticaMappings for optimum performance.
• Created web service jobs by configuring WSDL in designer and usedInformaticaWeb Services Hub to start theInformaticatasks.
• UsedInformaticaDynamic Deployment groups to deploy theInformaticajobs among different environments (DEV, TEST, QA and PROD)
• Worked with active transformations inInformaticapower center like Filter, Aggregator, Joiner, Rank,
• Router, Sorter, Source qualifier, Java and Update Strategy transformations.
• Reviewed and testedInformaticaETL code and wrote test plans.
• UsedInformaticaWorkflow Manager and Workflow Monitor to schedule and monitor session status.
• Created complexInformaticamappings, reusable objects of Mapplets depending on client requirements
• Oracle PL/SQLcodes for complex transformation to process data to mart layer using various analytical functions, collections, types and cursors
• Oracle PL/SQLprograms, procedures and Packages
• Expertise inInformaticaMater Data Management
• 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.
• 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.
• 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)
• 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.

Confidential, Tulsa, OK

QA Analyst

Responsibilities:

• Generated Test Cases and Test steps in Quality Center
• Identified software defects using Test Director and communicated to the developers
• Involved in regression testing, Integration, GUI, and Usability Testing for each client modules
• Performed manual, functional and data driven testing
• Interacted with Business teams and Developers for bug tracking.
• Taken part in Requirements and Non Functional Analysis discussions
• Wrote usability test scenarios and created usability test reports
• Extensively developed LoadRunner Scripts.
• Managed the evaluation, recommendation and selection of tools and techniques to improve software quality and efficiency of test processes
• Transferred the existing test cases/scripts from MS EXCEL to Quality Center
• Tested the application by inserting checkpoints and synchronization points in test scripts using Quick Test Professional
• Coordination of work between offshore and onsite for functional test scripts
• Baseline and Alternate solution testing to align the new solution with the existing solution
• Defect Reporting and Tracking
• Writing test cases, creating test data and involved in testing the crystal reports with test database.
• Comparing data values in generated Crystal report using automated test scripts.
• Writing SQL statements and analyzing query performance as it relates to Crystal reporting.
• Backend testing was done using PL/SQL
• Performed Database testing, wrote SQL Queries for Data validation
• Effectively used Quality Center for defect management
• Attended performance meetings and weekly reviews by submitting weekly reports

Environment: Quality Center, Load Runner, QTP, UNIX, Oracle.