SUMMARY

• 7 years of Industry experience as a Business/Data Analyst with solid understanding of Data warehousing, Data Modeling, Evaluating Data Sources, Application Design. Deep understanding of enterprise data warehouses.
• In depth knowledge of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile and RUP.
• Extensive experience in configuring data mapping between different Databases, Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D). Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).Strong Knowledge and experience using Teradata.
• Experience in designing and developing Data Warehouse applications using ETL.
• Extensive experience in configuring data mapping between different Databases.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, VB, VB.NET, C#.NET, ASP.NET, Java, SQL, PL/ SQL

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Databases: MS - Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

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

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS),SQL navigator

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh

Business System Analyst

Responsibilities:

• Interface with the client as part of the Requirements Engineering team to finalize the project scope. Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Collect business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Identified as well as document data sources and transformation rules required to populate and maintain data warehouse content
• Create Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Document requirements, prepare use cases, assist with design decisions, produce process flows and document functional specifications.
• Responsible for Leading the Business Process Reengineering effort and for the SRS (Software Requirements specifications) documentation of the build out of the FWA dashboard and for client reporting.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations.
• Worked closely with project manager in handling whole project.
• Relieved pressure off the PM by maintaining artifacts and portions of the project binder.
• Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Run the SQL queries using TOAD
• 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.
• Maintains proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
• Provide evaluation and proposed solution documents to assist other team members with solution.
• Working with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Provide reviews and feedback for the test results.

Environment: Oracle 10g, TOAD, UML, Microsoft Office Suite, Microsoft Visio, Lotus Notes, IBM Clarity PPM.

Confidential, FL

Business Analyst

Responsibilities:

• Directly responsible for the design of high performance, globally delivered SOA based software solutions currently implemented and operating in a commercial environment.
• Used Enterprise Architect 8.0 for writing complex processes in to uses cases and generating activity diagrams.
• Creating the GUI designs using the Axure pro 5.6.
• Work with internal and (on occasion) external users to review, analyze and evaluate business needs.
• Define software requirements to meet the needs of internal clients and their constituents.
• Coordinate Requirements Gathering and Analysis sessions
• Document Requirements, prepare use cases, assist with design decisions, produce process flows, and document functional specifications.
• Assists in the collection and consolidation of required information and data.
• Provide evaluation and proposed solution documents to assist other team members with solution.
• Working with the offshore team with regards to development to meet the client needs.
• Technical Recommendation and Testing.
• Led JRP sessions and JAD sessions with end user community ensuring that the software addressed all business needs and also conducted Rapid Application Development sessions (RAD).
• Worked closely with the UI/front end design team to model the screens, which met user, defined requirements and also company standards.
• Provide User Acceptance Testing activities to ensure high-quality software deliverables.
• Provides recommendations for test plans.
• Provided reviews and feedback for all test results.
• Experience in business process re-engineering or process improvement involving broad-based information systems.

Environment: Microsoft Office Suite, Microsoft Visio,SDLC, UML

Confidential, Providence, RI

Business Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Assessed Credit Risk strategies with various internal credit tools and implemented Basel II strategies to augment Credit availability.
• Managed all the requirements in RequisitePro, making requirements available to all team members.
• Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Involved in testing the conversion of the application into web application using XML web services.
• Developed DRM (Debt Rating Model) in accordance with Basel II to ascertain ORR (Obligor's Risk Rating) in order to manage credit risk by determining one year probability of default by obligors.
• Rollout of Basel II risk-based Credit capital calculations in the Risk Cache for FX, Metals, credit Derivatives and Swaps products.
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Responsible for identifying and documenting business rules and creating detailed Use Case Diagrams, Activity Diagrams.
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Performed manual testing in parts of the projects as required
• Involved in Risk-Management Process, whereby identified critical areas of business risk and modified the business process to reduce the same.
• Maintained a dashboard on the Project website to keep track of the change request submitted and categorized them as active, approved, deferred or rejected.
• Contributed in the team that built the security mechanism for accessing the web.
• Developed Quality Assurance documentation, streamlined processes and reported technical problems to technical teams.
• Run the SQL queries using TOAD and SQL Navigator
• Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• 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.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.

Environment: Microsoft Office Suite, Microsoft Visio, DB2,SDLC, UML, Project Management, Sql, SQL server, quality center

Confidential, Plano,TX

Business Analyst

Responsibilities:

• Create Data Flow/data Lineage Diagrams (DFD/DLD) to depict the source-to-Target Mapping and Data Lineage Analysis.
• Identify/document Data Quality Controls review Business Rules Spreadsheet (BRS) and attend project release meetings.
• Completed requirements analysis for Loan Origination System (LOS) project and Compliance Engine project. Documented the same in the form of Requirements documents and Use Cases.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyse and document the Business Data Requirements.
• Perform data profiling to analyse and to support devising data quality controls (valid value ranges, relationships between data elements, business rules & reasonability checks).
• Reverse Engineered databases to understand the relationship between already existing tables.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used XML for building and parsing of Application Configuration file.
• Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Tracked UAT issues/bugs and prepared reports.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, management, SME (Subject Matter Expert), stakeholders, lenders, underwriters.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Wrote Teradata scripts for data manipulation, data inserting millions of records into tables.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), Visual Basic, SQL, SQL Server, Oracle, C#.Net, XML, Teradata, UNIX, OLAP, UAT.

Confidential, Madison, WI

Businss/Data Analyst

Responsibilities:

• Gathered information required for designing the new data elements by attending the requirement sessions
• Perform Source-to-Target Data Mapping, Data Lineage Analysis and documentation using the Metadata Repository (MDR) and the business rule spreadsheet (BRS) from the Corporate Data Warehouse (CDW) and the Integrated Operational Data Store (IODS) for financially reported Critical Data Elements (CDEs)
• Designed the dimensional Data Model of the data warehouse
• Worked as a member of the Data lineage Team in the Enterprise Data Program division to create the Data Functional Design Documents.
• Supported new business requirements by making changes in the Conceptual model.
• Responsible for making changes in existing logical and physical data models using ERwin, to support newly provided services.
• Understanding of the processes and activities of loan origination and closers.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Designed script to perform Data validation by using Teradata SQL Assistant, SQL scripts.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Responsible for creating mapping documents required for the ETL team.
• Played a major role in identifying the source and target elements implementing SQL queries.
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• Reviewed and analyzed existing data models.
• Responsible for enhancing existing Logical and Physical data models to accommodate the new data requirements.
• Organized Joint Application Development (JAD) sessions with data steward and ETL teams while having walkthroughs for mapping documents.

Environment: Windows NT 4.0, UNIX, Teradata, Oracle, SQL Server 2000, ERWin, JAD, Sequential Files