PROFESSIONAL SUMMARY:

• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• 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
• Experience working as Joint Application Development JAD facilitator and meetings coordinator with excellent interpersonal skills.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Experience in the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Informatica Power Center.
• Seven years of professional experience as a Business Analyst in Finance and Insurance domain.
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Strong experience in RUP Business modeling process.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, Perl 5.0, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Design and review of various documents including the Software Requirement Specifications SRS , Business requirements document BRD , Use Case Specifications, Functional Specifications FSD , Systems Design Specification SDS , Requirement Traceability Matrix RTM and testing documents
• Highly effective management and organizational skills with ability to prioritize.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.
• Software/Hardware:
• Rational Rose Enterprise Suite, Rational Requisite Pro, MS Visio, Test Director, Test Manager, Rational Clear Quest, PVCS Tracker, MS Office, MS Project, MS Publisher, Rational Robot, Performance Studio, Mercury Win Runner, Load Runner, Korn Shell Script, C/C , Java 2, Netezza, Teradata, SQL, PL/SQL, VB, Shell Script, Html, Crystal Reports, Micro strategy, Visual Basic, Access, Excel, MS-SQL Server, Oracle, Sybase, SQL Plus, UNIX Solaris/Linux , MS-DOS, Windows 95/ 98/ 00/NT/XP, MS FrontPage, Dream weaver

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Business Analyst

Worked as a Business Analyst for Confidential for their Internet Channel Refresh program. Internet Channel constituted of five 4 platforms viz. Confidential their open site, Application Platform for submitting application for a product online, Money Movement Online Banking Platform for online transactions. The existing application RIB was interfaced to Hogan Core Banking System which served as back end or SOR System of Record . The new application would be introduced to the users in different phases. Deposit Products would be rolled out in the first phase and Credit Products in the second and so on. As part of the project, Business Requirements were captured in the form of High Level Design document, To be Process flows, Detailed Business Requirements, Business Use Cases, System Use Cases, Traceability Matrix, and Non Functional Requirements. The Project was involved in Data Warehousing which was developed to integrate operational systems into one central database structure. Informational queries can be obtained from the Data Warehouse that identifies customer behaviour patterns.

Responsibilities:

• Created Business Requirement Document BRD , Functional Requirement Specification FRS document, User Requirement Specification URS and Change Request CR document for system application development.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Involved in writing Job Automation process i.e. writing shell scripts using Korn shell, as scheduled daily, weekly, monthly, and sending these jobs to clients email-ids.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Worked on data modelling and produced data mapping and data definition documentation
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process' and revenue streams aimed towards problem solving.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Developed the systems implementation project management plan with milestones and steps from procurement of vendors to project implementation and maintenance.
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, AbInitio Graphs and Teradata scripts
• Modify existing Informatica mappings to utilize Power Exchange sources and Oracle and Netezza targets.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Providing Data Quality support in the process of migration of the fact and dimension tables from Oracle to Netezza platform.
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Creation of the data mart from existing Operational data Store and other sources.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Performed analysis on enterprise data/report integration provided functional specification to development team to build Enterprise Reporting Systems.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Develop direct mail and email marketing initiatives using Unica Affinium Campaign and SQL.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Assisted in development of training materials for new technology and process improvements

Environment: Windows, MS Office MS Word, MS Excel, MS Powerpoint, MS Visio , .NET, Oracle, Crystal reports, RUP, UML, Visual Basic, SQL, SWOT analysis, Netezza, Win Runner

Confidential

Role: Data Warehouse Business Analyst

Confidential is one of the world's largest life insurance and pension groups, and a strong provider of investment products. The InfoShare Enterprise Data Warehouse was developed to integrate Confidential operational systems into one central database structure. Informational queries can be obtained from the Data Warehouse that identifies customer behaviour patterns. This customer data helps Aegon to better understand and respond to customer's needs. The same Enterprise Data warehouse is used by the NOW portal to get quick information of policy holder and policy details, intended for use by the employees internally.

Responsibilities:

• Addressed all aspects of credit card business.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Gathered requirements from JAD/JAR sections with developers and business clinets.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Handled change request and change management and project management using Clarity Project.
• Performed Informatica Administrator functions like Creating Users, Folders and giving permissions on the folders to the Users etc. Involved in creation of Effective Test Data and Unit Test cases to ensure the successful execution of the data loading processes.
• Managed the database using SQL and Unicas Affinium Campaign to execute queries against large data sets in an Oracle environment to generate lead lists for new and recurring marketing campaigns based on the documented business requirements.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, Visual Basic, Oracle, Teradata, UNIX, Rose, MS office, Cognos, MS Word, MS Excel, MS Visio, SAS, LoadRunner, WinRunner

Confidential

Role: Business Analyst

This project was to offer a sophisticated set of online tools for effective cash management by the back office. The application provides instant transaction originations, customized reports, automatic balance alerts and fraud control are few of the features that can give the company an unprecedented level of control, freedom and flexibility in managing cash. The application also provides basic features such as Balance Reporting, Detail Transaction Reporting, Balance Alerts, Account-to-Account Transfers, link to Fed window as well as Allfirst trust Co which provides customized custody processing and Securities trading solutions for both corporate and individual clients, ACH Origination, Wire Transfers, link to General Ledger.

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Involved in Risk Assessment for each project.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Created functional requirement documents for the impacting projects that were agreed upon to be implemented in the current release.
• Instrumental in helping create the Netezza universe for Business Objects reports.
• Owned the entire reporting process. Interacted with the ETL team, developer s , management, and account holders to get the requirements, document them, design templates, and write specifications.
• Designed and developed Project document templates based on SDLC methodology
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Generated data cubes for analysis purposes using excel functionality and created several reports in Cognos report studio.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Performed White Box testing by using Expediter tool and updated some of the PROCs , JCLs and SAS programs in the Test region. Submitted batch JCLs in order to create output datasets for verification.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations if any .
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Worked with developers to execute functional testing and user acceptance tests for UNIX, NT based data replication products as well as application replication products.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Reviewed test results and coordinated with testing and development team to correct the issues.
• Developed timelines for project delivery, and managed projects/resources

Environment: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, SAS, VBScript, C . Cognos, Netezza, DOORS, C , NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Confidential

Role: Business Systems Analyst

Credit Suisse, the second largest Swiss bank, operates in three segments: Investment Banking, Private Banking, and Asset Management. Personal Banking involves opening and maintenance of checking, savings, recurring deposit accounts and personal loans. The web-banking project was developed in .NET environment. It is an online banking application that enables customers to access their checking and savings accounts, and credit card account using the Internet.

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Followed solely RUP methodologies during the course of the project.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Attending Client Meetings Project Steering Committee Meetings and Project Management Committee Meetings.
• Coded the Korn Shell Sripts for pushing and pulling data to and from the Server, Merging the files and placing it in the server etc.
• 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
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Helped with Data Mapping between the data mart and the Source Systems.
• Designed conceptual and logical data models of Data Warehouse and tables.

• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.

• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Managed Scope and change throughout the SDLC process of the product.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Suggested measures and recommendations to improve the current application performance.

Environment: Rational Enterprise Suite Rose, RequisitePro, ClearCase, ClearQuest , XML, Java, Unix, C , J2EE, JSP, Oracle, DB2, Sybase, MS Office, Teradata, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro