SUMMARY

• Over 7+ Years Professional Experience as Business Analyst in Retail Environment.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Excellent in Developing and evaluating business process Models.
• Proven success as a data analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Knowledge in the Informatica/ 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 UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a data analysis methodology for application functionality designs using IBM’s Rational Rose.
• 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
• Proven success as a data analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• 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).
• Professional experience in data analysis, operations management and development, design, documentation and testing.
• 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.
• Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
• Advised management on improvement strategies, Competitive & Profitability Analysis.
• Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.

TECHNICAL SKILLS

Software/Hardware: OOAD (OOA/OOD), RUP, UML, SDLC, Waterfall, QA, WAP, CVS, TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA, DB2. ATG, Windows 98/2000/XP, basic UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, Project, Visio, Adobe Photoshop, Flash, Rational- Rational Rose, Rational XDE, DOORS, Cobol,RequisitePro, CaliberRM, Cognos, Crystal Reports, various NIKU products, .Net, C, C++, Sharepoint, Docushare, BASIC, Intermediate level-Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Sr Data Mapper & Business Analyst

Responsibilities:

• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Developed Interface Control Documentation, Functional Specification Documentation, High Level Testing Plan, etc
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Worked on data modeling and produced data mapping and data definition documentation
• Developed business intelligence reports using Business Objects (BO) tool for the updated results to the stake holder
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Was involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• UAT testing performed along with Soap UI application meets mapping requirements.
• Came up with test cases from the requirements, validated/exercised those test cases in form of integration and regression tests. Used Test Director to map the requirements with test cases (automated/manual), used QTP for automated testing.
• Conducted JAD sessions with management, provider, vendors, users and other stakeholders for open and pending issues for.
• Create mapping documents and technical design documentation for the data models, data flow control process, metadata management.
• Worked on exporting data using Teradata and import or exporting to the Athena Semantics.
• Analyzed the data collected and process maps to determine the root causes and create canonical.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Interfaced between Business new product builders and System platform builders.

Environment: Ignite XML spy, software Ag- web method 8.2 developer and designer, ANZO mapping, RUP, UAT, GAD (Gap Analysis Document), MS Visio, MS Office, Java, J2EE technology, .NET, ASP.NET, SQL Server, NIKU, Windows 2000 Advanced Server, UNIX / Oracle Platform

Confidential, Bentonville, AK

Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked on development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Provided Business Requirement Documentation (BRD) for the customers after thorough market and technology research and by analyzing current market trends.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Aligned requirement documentation with use of UML for object oriented software development (OOD).
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Created job schedules to automate the ETL process.
• Developing Business Objects reports based on report Design documents (RRD) Effort estimation and providing it to the client.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and enterprise data warehouse.
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.

Environment: Java, J2EE technology, .NET, ASP.NET, SQL Server, UNIX / Oracle Platform, NIKU, MS Visio, MS Outlook, MS project, MS Dynamics, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro

Confidential, Hudson, OH

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Conducted extensive requirement analysis using Rational requisite pro
• Thoroughly studied the requirements for the process re-engineering
• Worked on 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
• Analyzed Business Requirement Documentation and Functional Specification Documentation using UML methodologies.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Responsible for creating Report Design Documents (RRD) and Test Plans for unit testing.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Designed the universes by creating the Business Objects data model.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Environment: Microsoft Word, Excel, Outlook, MS Visio, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Cognos, Sybase, VBScript, C#. DOORS, Java, C++, NET, ASP.NET, Business Objects

Confidential, Framingham, MA

Business Analyst

Responsibilities:

• Acted as a liaison between underwriters who have a business problem and developers to create automated solutions.
• Involved in all phases of the Iterative approach of the SDLC from Inception to Transition.
• Responsible to import the parts of the existing reports using Business Objects Live Office to develop the required reports in Microsoft Excel and Word.
• Working in Documents Management System to track and store images of paper documents.
• Propose process improvements to documentation and technical writing procedures.
• Gathered, documented, and communicated business requirements into systems design documentation using Business-Modeling concepts.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the db2 database.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Involved in designing business use case scenarios, use case realizations diagrams, and workflow charts for documenting the requirements.
• Monthly and quarterly management meetings with travel liaison for consistent communication.
• Database of individual traveler personal profiles for efficiency and accuracy with each reservation
• Interacted with representatives in supplying information, reporting defects, and obtaining information for specifications and implementation of the requirements.
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the Entity relationships between the data elements to analyze and document business data requirements.
• Involved in User Acceptance Testing (UAT) and Test Execution.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, SQL, SQL Server, MS Visio, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot