Summary:

• Proficient in facilitating User Acceptance Testing UAT with the SME's or clients.
• Experience in creation of artifacts and management of various roles specified by the Agile Methodology.
• Solid background in Software Development Life Cycles such as the Agile, Waterfall, RUP and other iterative methodologies.
• Familiar with SOX Compliances and Basel II standards. Worked on data analysis of Mantas - Anti-Money Laundering AML Compliance data and supported user requirements.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting
• Experience in designing and developing reports using Microsoft Reporting Services MSRS , Crystal Reports, MS Access, and Data View web part
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Experienced with data mapping using SAS for collecting the data, cleansing it and maintaining it in company's data warehouse and generating reports.
• Strong experience in Requirements elicitation techniques such as conducting user interviews and JAD sessions
• Ability to gather Technical and Functional requirements from both technical and non technical audiences using a broad array of tools and techniques.
• Business Analyst with over Seven years of major experience in the financial domain.
• Diverse experience in working with Banking, Pharmacy and Telecom environments.
• Effective in executing multiple tasks and assignments ahead of schedule.
• Reputation for dedicated teamwork, high energy, work ethics and commitment with capability to handle new technologies and situations. A Team player, result-oriented, fast learner, excellent communication skills with strong analytical capability.
• Process/Model Tools : MS Word,Excel,Powerpoint,Visio, Snagit, Agile Methodology, Scrum, Rational Unified Process RUP , Rational Rose, Rational RequisitePro,Rational Clear Case, UML, Remedy, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, MS Office2000 2003Tools.
• Reporting Tools : Crystal Reports and SQL Reporting Services.
• Test Tools : Test Director, Win Runner, Regression Test, Load Runner

Operating System : Unix, Windows NT/2000, Windows XP. Languages and tools : Java, J2EE, Dotnet, IBM mainframes, Webservices Web2.0 , Sharepoint, HTML, Databases : Oracle,SQL Server 2000,2005, My SQL. Professional Experience:

Confidential

Business Analyst

The project entailed developing end-to-end solutions with all functionalities enhanced as per client specifications. Agents and clients wanted to execute a variety of transactions on the web, ranging from basic account opening and querying to placement of orders, redemptions and executing other transactions straight through. The solution enabled the client to track and profile the customers in order to deliver superior personalized service and stay ahead of competition. The end result was a completely prioritized, and user-friendly, real-time listing of mutual funds, equities, fixed income, portfolios, options, annuities, IPOs and other asset classes to be broadcast over the web and Bloomberg terminals.

Responsibilities:

• Involved in major projects for the improvements of all the major components of SmartWorks including single sign-on features enhancement, brokerage alert system, on-line account opening, OSJ approvals, on-line commission center, brokerage tools, and compliance reporting.
• Responsible for creating the Business Process Model for the Global New Account Opening utilizing the BPM methodology and notations.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes.
• Responsible for creating the Roles and Responsibilities as part of the New Account Opening project and mapping them to the appropriate business unit
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Gathered data from the legacy system db2 to the present updated system using data warehouse tools such as Informatica
• Involved in strategic projects
• Performed extensive Requirement Analysis including data analysis and gap analysis
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Worked on data modeling and produced data mapping and data definition documentation
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system.
• Conducted JAD sessions to resolve critical issues
• Played a key role in the planning, testing, and implementation of system enhancements and conversions

Environment: Windows, MS Office MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio , .NET, Oracle, Crystal reports, IBM Mainframes, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner

Confidential

Business Analyst

Responsibilities:

• Interacted with Cash Management Division and Compliance Office to review the AML Anti Money Laundering requirements and provide Positive Pay service to reduce check fraud
• Updating the internal anti-money laundering software by monitoring anti-money laundering AML activity
• Implemented Scrum as a part of agile methodology for work management and part of The Team in the Framework.

• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Worked on data modelling and produced data mapping and data definition documentation
• Responsible for physical/logical data modeling metadata documentation user documentation and production specs.
• Created DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse.
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used Microsoft Office suit to develop the documents such as Visio for creating wireframes, Word,Excel and Power Point for creation of Business Requirement documents.
• Also Used SnagIt for editing of the Screen shots and in Jad sessions for screen sharing and presentations.

• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis Created source table definitions in the DataStage Repository by studying the data sources.

• Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.

• Prepared the UML Use Cases using Rational Rose.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
• Reviewed Test Plans that contains test scripts, test cases, test data and expected results for the User Acceptance testing.

Environment: Java, J2EE, IBM Mainframe, Webservices web2.0 , Windows 2000/XP, Agile, UML, Visio, SnagIT, Rational Suite Rational Requisite Pro, Clear Quest, Rational Clear Case, Rational Soda HP-Mercury Test Director, MS-Office 2003, Oracle/SQL Server 2000, UAT.

Confidential

Business Analyst

Responsibilities:

• Managed risk-based audits, due diligence and governance of new initiatives and compliance AML Anti-Money Laundering , SOX, Basel, GLBA, PCI programs to mitigate risks
• Implemented Actimize Anti-Money Laundering AML system to monitor suspicious transactions and enhance regulatory compliance.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Developed data cleansing and data auditing procedures to clean external data and provide audit logs of rejected data.
• Created dynamic data cleansing modules to identify duplicate student data using rules from a rules table in the database.
• Using UNIX console commands to check database has been connected the other functionalities.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Performing Gap Analysis to increase the efficiency and compatibility of existing systems and simple add on's with new business requirements.
• Documented the requirements in Rational Requisite Pro.
• Participated in providing analysis to track the activity of the average employee and customer with the front-end
• Perform Business Process Modeling using Visio. Perform customer data analysis.
• Identify research, investigate, analyze, define and document business processes.
• Worked on Oracle e business application suite tools like Depot Repair, Field Service, iSupport to streamline repair processes and business functions.
• Exclusively used SQL, T-SQL for designing modifying and maintaining the SQL Server Tables, Views and Stored Procedures accordingly

Environment: Windows 2000/XP, Enterprise Architect, Agile, UML, Java, Ajax, Visio, Rational Suite Rational Requisite Pro, Rational Clear Case , Oracle/SQL Server 2000, Crystal Reports 9.0, Mercury Test Director, Regression Test, Load Runner and Quick Test Pro, MS-Office 2003.

Confidential

Business Analyst

Responsibilities:

• Conducted working sessions with Business and technology teams to capture requirements for Deposit products like Savings, Checking, CD, CAA, and Package Accounts, Internal money movement Single Immediate Transfers, Single Future Transfers, Recurring Transfers etc.
• Conducted Gap Analysis of As Is To Be State for new Online Banking and Money Movement Platform.
• Created Testing Requirements Document TRDs and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
• Interacted with the testing team while developing the functional test cases and regression test cases.
• Designed Document Flow Diagrams DFD's , Entity Relationship Diagrams ERD's , and web page mock ups using modeling tools.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Tested access control of Siebel call center application by logging using different user ID s and verified views based on responsibilities.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
• Interacted with customers in call center environment to validate fraud claims
• Developed a thorough knowledge and maturity in all the phases of SDLC and familiar with industry standard best practices frameworks such as RUP Rational Unified Process , AGILE Lean
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT User Acceptance Testing
• Came up with test cases from the requirements, validated/exercised those test cases in form of integration and regression tests. Used Test Director to map the requirements with test cases automated/manual , used QTP for automated testing.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Used Agile methodology of development to improve customer satisfaction by rapid continuous delivery of S/W
• Participated in test planning, writing test cases/scripts within PEGA PRPC and correct the responses according to the erroneous outcomes.
• Design and Architecture using BEA Weblogic's latest features like Portal, Page Flow, Process Control, Java Control and Web-Services using Weblogic development IDE Workshop on Oracle database
• Conducted workshops for Use Case writing with User experience groups .
• Worked as Track Lead for the Money Movement Platform. Responsibilities included creation and maintenance of Requirement Artifacts and maintenance of Issue tracker on the program management site through SharePoint and other collaboration tools.
• Created Use cases for the various functionalities of Deposit Products.
• Troubleshooting and analysis of hardware and software failures for various UNIX servers core dump and log file analysis .
• Conducted training for new team member for the Project

Environment: MS Office Suite 2007, MS Visio 2007, SQL, Agile/Scrum, Java, HTML, XML, WinRunner, Load Runner, Mercury Quality Center 9.0, Unix, RUP, UML

Confidential

Business Analyst

Responsibilities:

• Used the Agile methodology guidelines to carry out every step of the business modeling process.
• Lead discussions and JAD Sessions to gather business requirements and discuss possible solutions documenting them into a Business Requirements Document and translating into Software Requirement Specifications SRS .
• Identifying and designing new account opening screens to be used for a re-designed front- end system.
• Understanding and developing requirements and use cases for account opening maintenance and reporting for new accounts on private banking and trust application, platform service, Integration and Implementation.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Organized workshops with Subject Matter Experts SME to obtain domain level information.
• Identified and documented business processes to define high-level model.
• Documented use cases, created use case diagrams that described the behavior of the system and modeled them in Rational Rose.
• Performed analysis of business requirements and interpreted transformation rules for all target data objects.
• Exclusively used SQL, T-SQL for designing modifying and maintaining the SQL Server Tables, Views and Stored Procedures accordingly.

Environment: Agile methodology, Rational Suite Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, Rational Rose , Oracle, MS Project, MS office suite, SQL Server 2000.