SUMMARY

• More than eight years of experience as an organized, creative and innovative data analyst with experience in application development and skills in documentation, quality assurance and problem solving
• Extensive experience in Business requirement gathering, Business Analysis and Business Process Re - engineering.
• Proficient with industry standard methodologies such as Rational Unified Process (RUP), Object Oriented Analysis and Design (OOAD).
• Proficient in Software Development Life Cycle methodology (SDLC).
• Knowledge of Software Development Life Cycle process which includes RUP, Agile and Waterfall Methodology.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, activity diagrams), and Class Diagrams based on UML methodology using Rational Rose.
• Hands on experience of Data manipulation, performance testing on SQL and MS-Access using SQL scripts.
• Experience with working on Logical, Conceptual and Physical Data Model using Erwin.
• Adept at performing Gap Analysis between “As Is” system and “To Be” system.
• Very proficient in writing ETL Mapping documents and Source to Target Transformations.
• Extensive experience in creating Reporting requirements and reports mapping.
• Well versed in rational tools including Rational Rose, rational suite, clear quest, clear case, MS Visio and Requisite Pro.
• Excellent skills in gathering business requirements, facilitating Joint Application Development (JAD) sessions, developing Use Cases, creating Business Requirements Document (BRD) and Functional Requirement Specification (FRS) documents.
• Experience in conducting Gap analysis, User Acceptance Testing (UAT) and SWOT analysis.
• Involved in conducting Testing and assisted in documenting Test Cases, Test Plans and Test Scenarios.

TECHNICAL SKILLS

Packages: MS Office Suite, Rational Enterprise Suite

Processing Tools: MS Project, Clear Case, Documentum, SharePoint.

Modeling Tools: MS Visio, Rational Rose, Erwin

Requirement: Requisite Pro, DOORS

Defect: Clear Quest, Quality Center, Test Director

Languages: C, C++, Java, J2EE, VB, .NET, VB Script, HTML, XML, SQL, PL/SQL

Databases: Oracle, MS Access, SQL Server, DB2

Operating systems: Windows NT/2000/XP, UNIX.

Reporting Tools: Business Objects, Crystal Reports, Excel

PROFESSIONAL EXPERIENCE

Confidential, DC

Data Analyst

Responsibilities:

• Effectively communicating and collaborating with business users to analyze Confidential ’s National underwriting center’s requirements and deliver the following artifacts as needed: User Stories, Flow diagrams, GUI Interface designs (Mock-up screens).
• Capture requirements by conducting JAD sessions with business partners, SME’S and users.
• Generating adhoc reports for users like weekly/monthly metrics.
• Perform detailed analysis of complex business reporting processes and requirements and propose solutions.
• Responding to and resolving production support requests from users.
• Developing/Modifying database and application components to in corporate new functionality into data warehouse and support changes to upstream and downstream systems.
• Performing and documenting root cause analysis for incident related to billing of loans.
• Working with upstream and downstream applications to ensure incoming and outgoing data feeds are complete and successful.

Environment: MS Access, TOAD, SQL, UNIX, SAS, MS Office, MS Visio, Tableau.

Confidential

Data Analyst

Responsibilities:

• Worked on data modeling to develop Logical Entity relationship.
• Develop test cases to validate the ETL logic to populate dimensions, facts and summary tables from three different reservation systems.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Worked with upstream and downstream applications to ensure incoming/outgoing data feeds are complete and successful.
• Prepare test scenarios for each module to test for data validity and data integrity.
• Generated synthetic data for code validation.
• Enhanced SQL queries for Cognos reporting Purpose.
• Designed wireframe views, design report mockups
• Performed data analysis using analytical queries to check the data used for reporting purposes.
• Developed Business and Functional Requirements, including requirements traceability, categorization and prioritization
• Take regular weekly backups of the existing data.
• Worked in data management performing data analysis, gap analysis, and data mapping.
• Tuned SQL Scripts to load data faster.
• Monitoring the data in the production environment for taking measures to make the data in synchronization.
• Performed unit testing, integration testing, system testing and Documentation related to these phases.
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe prototypes and document them using Microsoft Visio.
• Developed the STTM document to develop the Database structure and tables.
• Perform detail integration testing so that all the modules work in sync with each other.
• Develop various Executive reports using analytical queries and do data validation for detail analysis.

Environment: WinSQL, Netezza, SQL, PL/SQL, UNIX, Cognos Reporting, Excel, MS Visio, MS Office

Confidential, Fredrick MD

Data Analyst

Responsibilities:

• Followed the Unified Process Methodology for iterative design. Worked on creating a hybrid model of RUP and Waterfall methodologies for software development.
• Developed a Requirement Traceability Matrix (RTM) and ensured its timely update.
• Worked with Project manager and other users and created Work flow diagrams using MS Visio/UML.
• Expertise in creating Data Mapping Documents and Source to Target Transformation document.
• Prepared mock up data for Data Validation and Data Integrity Testing in MS Excel.
• Experience with ETL validation and writing requirements to enhance the ETL process.
• Performed data and requirement analysis by writing complex SQL scripts for accuracy of data on reports.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Created Mock Up screens using MS Visio for better visualization and understanding of the software application.
• Held meetings with system architects, developers, quality testers etc. during the entire project.
• Conducted Joint Application Development sessions with Developers, Testing teams and Subject Matter Experts.
• Created presentations and training sessions for new users using MS PowerPoint
• Prepared a schedule and work flow for the development team using MS Project.
• Assisted the organization in performing data compiling, mining and analysis required to evaluate the given data
• Involved in conducting User Acceptance Testing (UAT) with prospective users.
• Played an active role in Production Support and maintenance of the application.
• Conducted status meetings and presided over the Change Control Board meetings to discuss Defect, Enhancement and Database Change tickets.

Environment: Windows, .NET, MS Office, MS Visio, Requisite Pro, UML, Oracle 10g

Confidential, Alexandria

Data /Business Intelligence Analyst

Responsibilities:

• Created Business Use-Case Model and Business use Case specifications after accessing the status and scope of the project and understanding the business processes.
• Analysis of various Business Intelligence tools to discover trends and assess metrics to provide insight regarding meeting growth targets, maximizing revenue, and improve competitive advantage.
• Perform analysis of the given data and draw accurate inferences, in accord with the objectives of the analysis
• Gather data required to conduct analysis from several sources, compile it together in prescribed format and enter the data in several data analysis softwares.
• Produced functional specifications and led weekly JAD meetings with development consultants and business units to discuss outstanding technical issues and deadlines \
• Performed user acceptance testing by preparing test cases and test strategies with developers.
• Performed manual front-end testing to check all functionalities of different modules.
• Worked with Development Engineers to diagnose and isolate defects.

Confidential, New Jersey

Data Quality Analyst

Responsibilities:

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Was involved in the complete SDLC process
• Created business process workflow diagrams (Activity diagrams) for the GAP as-is and to-be process in Visio, Rational Rose.
• Created Business Use-Case Model and Business use Case specifications after accessing the status and scope of the project and understanding the business processes.
• Produced functional specifications and led weekly JAD meetings with development consultants and business units to discuss outstanding technical issues and deadlines
• Created and managed use-case templates and traceability relationships in RequisitePro.
• Managed all the requirements (Business and Application use cases) in RequisitePro, making requirements available to all team members and to maintain traceability between requirements, design and UAT test cases.
• Visualized complex data structures using ERwin and established enterprise-wide standards for managing data
• Prepared Logical Data Models using ERwin that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Managed and controlled change using ClearQuest, associated requirements to specific change request/enhancements/defects and made sure that other teams were following the change requests guidelines.
• Linked business processes to organizational objectives, performed critical path analysis, and identified opportunities for business process improvement.
• Supported with Quality Assurance Analyst with logging the test cases and their results and developed test Status Reports for Stakeholder review.
• Automated testing sessions using WinRunner and logging and maintaining the results via a traceability matrix.
• Updated the issues log with all issues identified during UAT and created defect tickets in ClearQuest for all defects and enhancements identified during UAT.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational ClearQuest.
• Developed and executed SQL queries using TOAD on Oracle database for validating the database tables.
• Reviewed project deliverables for completeness and quality and compliance with established standards.

Environment: MS Word, MS Excel, MS Power Point, MS Project, Windows 2000, ClearQuest, TOAD, UML, MS SQL Server, MS Visio

Confidential, PA

Data Analyst

Responsibilities:

• Performed the role of a liaison between Business Units and Technical Solution Developers.
• Understand and articulate Business Requirements from SME interviews and workshops and translate requirements into Functional Requirement Specifications (FRS).
• Analyzed business needs and created Application Use Case (AUC) documents.
• Involved in development of Business and Technical Requirements in preparation of System Architecture, Information Strategy, and Detailed Design documents for Business Needs and Processes.
• Prepared Logical Process and Data Models that contained set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document Business Data Requirements.
• Provided production support to end users for the web based application.
• Developed Data Flow, Workflow, Process Flow, and Entity Relationship Diagrams in MS Visio.
• Provided Production Support to end users for the web based application
• Developed, maintained and executed manual test cases and test scripts.
• Performed user acceptance testing by preparing test cases and test strategies with developers.
• Performed manual front-end testing to check all functionalities of different modules.
• Worked with Development Engineers to diagnose and isolate defects.
• Performed Defect Tracking and Change Control Procedures using Quality Center
• Involved in the peek review of Test Plans, Test Cases with the QA team to verify implementation of new features and enhancements.
• Developed and executed SQL queries using TOAD on Oracle database for validating the database tables.

Environment: MS Word, MS Excel, MS Power Point, MS Project, Windows 2000, Rational Requisite Pro, TOAD, UML, MS SQL Server, MS Visio

Confidential, PA

Business Analyst

Responsibilities:

• Thoroughly studied the inherent systems to have a clear understanding of the business processes and associated system workflow.
• Conducted Gap analysis to understand new business model and additional functionalities to be incorporated into the new application.
• Conducted JAD sessions for better understanding and refining of requirements in coordination with multiple teams.
• Clarified and prioritized requirements by conducting brainstorming sessions with the stakeholders and SMEs.
• Documented various documents including the Business Requirements Document and the Use Case Specification Documents.
• Used Rational Requisite Pro as requirement gathering tool.
• Identified all use case components including basic, alternate and exception flows.
• Participated in various architectural development sessions to provide technical teams with a better understanding of the requirements.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Gathering business requirements and converting them into functional requirement specifications and user requirement specifications.
• Used Rational Requisite Pro for Requirement Document preparation.
• Carried out detailed and comprehensive business analysis with the RUP methodology.
• Prepared Business Process Models, which included modeling of all activities of the business from conceptual to procedural level.
• Participated in Change control meetings recommending appropriate action after analysis of changing requirements.
• Conducted multiple interviews to clarify requirements in order to identify use cases and document UC Specifications.
• Assisted QA team by Reviewing test cases and clarifying requirements to ensure complete coverage of requirements.
• Provided training to users, and involved in conducting UAT sessions to gain user confidence and approval.

Environment: Windows XP, Rational RequisitePro, Rational ClearQuest, Rational ClearCase, Rational Rose, MS Visio, SharePoint 2007, MS Visio and MS Excel.

Confidential

Data Analyst

Responsibilities:

• Involved with multiple task project assignments, scheduling, and tracking; facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing.
• Involved in creating Data Flow diagrams for the enhanced application.
• Worked extensively on writing Data Mapping Documents and Data Transformation Rules for creating a Data Mart for Reporting Purposes
• Worked with developers to tuned SQL and application and added Indices as required for performance and involved in testing through test scripts and test plans.
• Designed and developed Data Models using ERWIN tool to support business functionality.
• Designed and implemented extensive Data Mapping and Mining Documents for various projects under ISO-9001 requirements to meet strict Quality Assurance standards.
• Worked directly with customers to fine-tune their custom configurations and troubleshoot any problems they encountered.
• Performed expert and ad-hoc testing for limited release.

Environment: MS Word, MS Excel, MS Power Point, MS Project, Windows 2000, TOAD, UML, MS SQL Server, MS Visio