PROFFESSIONAL PROFILE

• A Business Analyst/ Data Analyst of 8 years experience in Banking industry with solid understanding of Business Process Flows, Case Tools, and Business Analysis.
• Excellent knowledge of Software Development Life Cycle SDLC , Iterative Software Development Life Cycle Process as per Rational Unified Process RUP .
• Extensive experience in developing data warehouseing and BI solutions
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Strong Knowledge of SDLC methodologies including RUP, Waterfall, Prototype and RAD.
• Experience in conducting Joint Application Development JAD and Rapid Application Development RAD sessions to converge early towards a design acceptable to the.customer and feasible for the developers and to limit a project's exposure to the forces of change.
• Excellent skills in writing Business requirements document BRD , Use Case Specifications, Functional Specifications FRD , Systems Design Specification, Workflow and diagramming skills for drawing UML diagrams such as State Transition diagrams, Activity diagrams, Class diagrams and Sequence diagrams, Data Flow Diagrams DFD , Requirement Tractability Matrix.
• Excellent skills in Business Intelligence, Data Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading ETL .
• Proficient in creating Use Cases.
• Strong knowledge in Equities, Stocks Trading Cycle, Portfolio Analysis, Wealth management, Asset management, Bonds, MBS, CMBS, Derivatives Options, Forwards, Futures and Swaps
• Strong experience in different Mutual Funds like Money Market Funds, Income and Growth Funds
• Knowledge of the Credit Risk Management concepts.
• Strong knowledge of Mortgage Industry.
• Experience in conducting, Gap Analysis GAP , User Acceptance Testing UAT , SWOT analysis, Cost benefit analysis and ROI analysis.

Confidential

Sr. Business/Data Analyst

Project Responsibilities

• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Provided Business Requirement Documentation BRD for the customers after thorough market and technology research and by analyzing current market trends.
• Content types, managed metadata, master pages and page layouts.
• Developed data warehouse and BI solutions for the Retail Credit Risk Management Division working closely with the project manager and business analysts to architect, develop, and test database implementations according to documented business requirements and coding standards.
• Develop, maintain and publish project plan scheduled project deliverables using Niku/Clarity resource database as well as MS Project.
• Involved in Inception phase of SDLC process in SCRUM methodology to gather requirements by writing user stories.
• Perform Source-to-Target Data Mapping Data Lineage Analysis and documentation using the Enterprise Metadata Repository.
• Communicate with Customer Service on ACORD Forms design and other technical problems
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked on profiling the data for understanding the data and ETL specification document.
• Overlooked product development across stages of SDLC
• Gathered requirements, organized team meetings requirements from business users, generated business process models, use-case models, and created business requirements document BRD functional requirements document FRD .
• Analysis, Design, development and customization of Reports and Dashboards in OBIEE and regular client interaction.
• Involved in development documentation of Software Requirements Specification SRS using Borland Caliber RM. Reverse-engineer several databases, such as research, business, and clinical in order to extract metadata to leverage it for ETL design and reporting.
• Worked with technical teams to collect requirements and publish SDLC documents.
• Executed SQL and PL/SQL queries on the DB2 Database.
• Worked through the SDLC to ensure successful implementation of new ERP systems.
• Conducted interviews with key business users to collect requirement and business process information.
• Involved in the performance tuning of the DataStage Jobs and SQL queries.
• Facilitated JAD sessions and conducted peer review meetings periodically to keep track of projects milestones.
• Developed UML diagrams such as activity and other flows to document and present to business users using MS Visio.
• Successfully used Remote Data Access technology in the coding to integrate the SQL CE and SQL 2000 databases

Environment: Rational Suite Rose, Requisite Pro , Windows XP/NT, ASP.Net, Oracle. MS SQL Server, JSP, XML, MS Office Suite, MS Visio, WinRunner, SAS, VBA Macros.

Confidential

Sr. Business Analyst / Data Analyst

Responsibilities:

• 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.
• Used Metacenter tool to extract Metadata for Cognos reports.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• 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
• Created SDLC documentation for a Documentum-based document management system migration and enhancement project.
• Developed project plans and managed project scope.
• Conducted internal and final DFD reviews with the ETL team EIS , Data Quality, Metadata Management team, data architects, businessand application data stewards.
• 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
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL. Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Created site taxonomies and term stores for Managed Metadata Service consumption.
• Handled change request and change management and project management using Clarity Project.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line including the business plan, products, and process and revenue streams.
• 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.
• Designed and developed Project document templates based on SDLC methodology
• 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: MS Office MS Word, MS Excel, MS PowerPoint, MS Visio , MS-Project, SWOT analysis, SQL, XML, Flat Files.

Confidential

Business Data Analyst

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams. Played a leading role in the effort to rollout new Retek modules such as RDF to the organization and to upgrade existing modules as new versions were released.
• Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director.
• Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
• Responsible for writing Test cases to cover overall quality assurance using Test Director
• Performed initial manual testing of the application as part of sanity testing
• Performed various tests such as positive, negative to check business functionality manually
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Collaborated with the development team to enforce the implementation of requirements throughout the entire coding cycle and managed change request using Rational Clear Quest.
• Developed business process models in RUP to document existing and future business processe.
• Troubleshot the designed jobs using the DataStage Debugger.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.

Environment:

SQL Server, Rational Test Manager, XML Spy, Data Stage, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, Erwin, Mercury TestDirector , Agile, Waterfall, MS Access, SDLC, RUP, UML, UAT, XML.