SUMMARY OF EXPERTISE:

• 7+ years of Industry experience as a Business / Data Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
• Experience in writing SQL queries and optimizing the queries in Oracle and SQL Server 2000.
• 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.
• Assisted data analysts to develop logical data models, source data cleansing and data profiling. Essentially applied business rules in the transform phase.
• Developed skills and gathered thorough experience in accounting such as Profit & Loss, Balance Sheet, and Cash Flow Statements
• Having excellent understanding of Financial Accounting. Comprehensive knowledge of balance sheets, G/L ledger, trial balance, income statement.
• Highly skilled in Financial Analysis using Financial Ratio and benchmarking them with Sector, Industry and S & P 500 Averages.
• Hands on experience as an expert user of MS Excel, MS PowerPoint, MS Access, Business Objects.
• Extensive experience in Accounting Reporting Systems on daily, weekly, monthly, quarterly and annually together with various accounting analysis such as variances and reasons for same.
• Proficient in using UML in behavioural, structural and architectural modelling – in creating Use Case, State, Activity, Class and Sequence diagrams using Rational Rose.
• Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Well versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

TECHNICAL SKILLS:

Business Tools : Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case),
MS Visio, MS Project, MS Access, MS Excel,MS Office Suite,
Visual Paradigm, DoorsErwin Data Modeller 4x, Business Object
(Crystal Reports).

Business Skills : Business Definition Requirements, Business Process Analysis,
Gap Analysis, Use Case Modelling & Analysis, Business
Environment and Market Research Analysis.
Methodologies : RUP, OOAD, UML & Business/Data Modeling
Testing Tools : Win Runner, Load Runner, Test Director, Quick Test Pro, PR
Tracker
Operating Systems : Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux
Databases : Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL
Server, DB2
Languages : UML, C, C++, HTML, Java, SQL, PL/SQL, ASP.NET

PROFESSIONAL ACCOMPLISHMENTS:

Confidential,
VA June 2010 – September 2012
Sr. Data Analyst / Business

The Scope of project spanned migration from isolated functional data marts for diverse subject areas to holistically analytical infrastructure. New analytical environment would provideenhanced business intelligence, flexible reporting and scalable architecture. Subject areas encompassed savings, checking, accounts, demographics, statements, loans, investments and program management

Responsibilities:

• Responsible for gathering requirements from the Stakeholders and Process control manager
• Assessed current operational procedures, input and output variables, and security requirements
• Collected technical system requirements during JAD sessions and documented them in the SRS document. In addition, analyzed the System requirements with the help of Use Cases and sequence diagrams
• Translated system requirements into Functional & Supplementary Requirements & technical specifications
• Responsible for creating Vision Document, Use Case Models and managing the documentation process
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Performed query reports and database testing using SQL
• Used Rational Unified Process (RUP) and Rational Rose to create UML Models to design and manage requirements using Rational Requisite Pro throughout the full lifecycle of the project
• Responsible for creating business work flows and processes and creating management reports based on the business rules and the business case analysis
• Used Visual Basic Editor (VBE) for developing and testing Macros in Excel
• Analyzed the system architecture and performed object-oriented analysis and design (validated by Rational)
• 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.
• Documented the dimensional models of ETL system.
• Involved in project co-ordination and reporting using tools as MS-Project and Business Objects respectively
• Worked on MS Excel Macros for creating automatic reports
• Developed business intelligence reports using Business Objects (BO) tool for the updated results to the stake holder
• Responsible for creating Activity diagrams and sequence diagrams to analyze process and system flows and to identify the detailed structure of communication among different actors
• Clarified QA team issues and reviewed test plans and test cases. Participated in test update meetings to review the QA process and Checkpoints

Confidential,
NYC January 2009 - May 2010
Business Analyst / Data Analyst

Bank of America Corporation provides a wide range of financial services. The Group's financial services include consumer and business banking, commercial banking, middle-market lending, asset-based lending, leasing, cash management, trade finance and government banking. Bank of America needed a more responsive IT infrastructure and responsive paradigm that will allow rapid application development, easy to use online access to data and data inconsistencies caused due to the bulky mainframe system. This is a migration and conversion project for Credit card services. This project was developed to integrate the various processes into one and get the best of Real-Time processing and enterprise architecture.

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Complete study of the in-house requirements for the data warehouse. Analysed 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.
• 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.
• 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.
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Built reports and report models using SSRS to enable end user report builder usage.
• Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
• In this project all the existing Crystal Reports are converted to MSRS reports.
• Created various reports such as ad-hoc reports, drill-down, drill-through, and parameterized reports using Reporting Services (SSRS) for internal teams.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• Assisted with development of strategy for managing SharePoint permissions in conjunction with Active Directory and future implementation of Identity Lifecycle Management functionality
• 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.
• Prepared user manual and performed user acceptance testing.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Helped with Data Mapping between the data mart and the Source Systems.
• Developed Project Iteration plans using functions andmacros.
• 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

Confidential,
MD July 2007 - December 2008
Business Analyst / Data

Advertising.com is AOL’s online marketing division and the project aimed at developing a Search engine management tool (SEMT), that would aid in effectively placing advertisements on Yahoo and Google Search Engines and also automatically calculating the bids so as to place the right advertisements in the right slot at the right time of the day. The project aimed at marketing advertisement orders received from the Advertiser and maximizing the return on Investment (ROI) for the advertiser as well as the publisher

Responsibilities:

• Involved in all phases of software development life cycle (SDLC) in RUP framework.
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
• Worked on preparation of online marketing templates, brochures, data analysis, PDF file generation for insertion into brochures.
• Responsible for maintaining the comprehensive online marketing definitions and manipulation of different details of the coding environment.
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Extensively interacted with both user group and development team.
• Managed and tracked change control process of requirements and design changes. Documented the changes, issues and their impact on the system design and delivery.
• Provided documentation such as requirements management plans, functional requirements, test plans and test cases.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Assisted PM with project planning, estimating, budgeting, resource allocation, collaboration and time capture using CA Clarity Project Manager
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology using Rational Rose
• Involved in developing the Banner Campaign
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stakeholders and document analysis. Performed user interviews.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Created test cases and test scripts
• Conducted User Acceptance Testing (UAT), Unit testing and System testing

Confidential,
ME October 2005 – June 2007

• Business Analyst

Project Scope: The client used an MS-Excel spread sheet based system for risk analysis, disbursement and managing its loan portfolio. The work assigned was to move from this manual, labor-intensive process to an automated and integrated system for its real estate portfolio, which could encompass the entire life cycle of a loan. The new system would have to address all aspects of the loan lifecycle, starting from identifying a deal right up to loan closure.
Responsibilities:

• Performed Requirement Gathering & Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
• Worked as a Data Analyst in order to gather requirements and reaching each and every deadline well ahead of the time line. Methods employed were in compliance with IIBA standards.
• Evaluate customer Income statement, Balance Sheet, perform financial analysis including cash flow statements, evaluate attainability of cost and profit objectives via alternate strategies.
• Participated with leads to develop the prototypes and improvise the user interface with the system.
• Reconciled gain/loss accounts to the general ledger.
• Developed the project plan with assistance from the management, and included provisions for project scope changes and issues and initiated efforts to make improvements.
• Manually generated reconciliation reports using MS Excel and Access.
• Conducted project kick off meetings with team members to explain roles / responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.
• Responsible for creating Use Cases, Business Process Modeling and Work Flow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
• Involved in analysis for wide range of Six Sigma and Web-based initiatives, including user requirements.
• Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
• Developed, designed and executed test cases for systems testing and User Interface Acceptance testing
• Coordinated with data architects and ETL team to understand/drill down on the datamart requirements. Came up with the plan to roll out datamart development efforts in different phases, coordinated efforts to analyze the datamart requirements between teams
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.

BSc. Computer Science, Confidential,
MBA, Confidential,