SUMMARY

• Qualified professional with Eight years of extensive experience in the field of Business Analysis, working with the technical staff to implement management and staff's business requirements into the software application in data warehouse and e-commerce environments.
• Worked with various customers to understand and translate business use cases and/or requirements into data models and serve as an expert resource on matters of data architecture to business and IT resources in all phases of data warehouse and data mart development, implementation and support.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Advanced analytical and project management skills with excellent problem solving capacity, throughout SDLC.
• Utilizing Agile/ SCRUM and PMI Project Management Institute methodologies to monitor steer and develop project objectives.
• Coordinating activities with project manager and various other teams using MS Project.
• Worked in all the phases of the Data Warehousing life cycle for Data Warehouses and Data Marts.
• Extensive knowledge with Teradata Load Utilities, Fast Export, Fast Load, Multiload, BTEQ, and Tpump. Coded complex scripts for the Teradata Utilities and fine-tuned the queries to enhance performance.
• Experience in troubleshooting of Data stage jobs and addressing production issues like performance tuning and enhancement.
• Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for adhoc purpose to extract data for several business users on scheduled basis.
• In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Experience in scheduling and running jobs using control-M
• Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
• Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
• Performed UAT and exposure to User Certification Testing UCT and Operational Readiness Testing ORT
• Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment. Impeccable customer service skills
• Proven success as a data analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Extensively used rational tools for UML, tracking and reporting and applied the Rational Unified Process in all areas of a software development life cycle.
• Excellent communication, facilitation and mentoring skills.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs.

Tools Used:

DISCIPLINES

Business Analysis, Business Architecture, Data Mapping, Data Modeling, Requirements Gathering, Functional Specification Design, Testing Test Cases Manual Testing Automated Testing tools , Quality Assurance QA , Documenting Process Flow, Process Re-Engineering, Process Mapping, Business Contingency/ Business Continuity Planning BCP , GAP Analysis, SDLC

Confidential

Sr. Business Analyst

Responsibilities:

The project involved implementing an Ecommerce application, which dealt with complete control over stock levels and inventory tracking and distribution of goods to its various distributors. The users were the distributors, who could check for the availability of goods to be distributed to the retail outlets and place orders using their credit cards.

Responsibilities:

• Interacted with business heads to finalize the Business Requirements for the application.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• 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.
• Used the requirement attributes priority, effort, and risk as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Also performed the Data Analysis and Data Mapping for different source system including Mainframe system
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• 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.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Prepared UAT Materials, including the UAT Process, UAT Test document that would include step-by step process for UAT as well as all the tests that would cover all requirements.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Was involved n the creation of new E-Commerce Products Arrival Notices and Customized Reporting
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Collected and processed quantitative and qualitative data analysis.
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Prepared and documented System Requirements and workflows for the Content Management Application tool.
• Checked Business Readiness and determined activities of flow.
• Performed Unit Testing and User Acceptance Testing and documented detailed defects.
• Wrote Procedure Manuals and was responsible for continuity preparedness.
• Managed various tests, stored test information, reviewed and analyzed test results.
• Conducted presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
• Employed Rational Clear Quest for effective Change Management Requirements Creep and bug tracking during the testing lifecycle.

Confidential

DWA/ Lead Business Analyst

Project: GSM

Responsibilities:

• Worked closely with Business end-users and developers for detailed understanding of the opportunities for improvements of systems in order to gather Requirements and prepare a comprehensive set of documents to define the specifications and business value of the system.
• Verified the current state documents by the Business and IT group in the respective meetings.
• Analyzed IT and Process Gaps on the identified Current state for all channels and transactions.
• Identified Metrics for Future state opportunities/Recommendations.
• Documented the business process through Business Requirement Document and Functional Requirement Specification Document
• Involved in working with Market research team, IT team, data management team with data analysis and reporting.
• Lead the project and worked as Business Analyst to support the COO specifically around business and marketing operations.
• Mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Involved in unit testing, system testing and integration testing.
• Involved in tuning initiatives to achieve efficiencies in load process.
• Performed high level data validations using SQL assistant to resolve defects.
• Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions
• Analyzed existing PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Considering both the business requirements and the factors to create NUSI, analyzed appropriate NUSI for smooth fast and easy access of data.
• Gathered and mapped requirements to Oracle System in order for users to test system through CRP sessions, Gap Analysis, Testing and Key User Training.
• Documentation of Current Process, Future Process, Application Setup BP40, BP80 and BR100 .
• Part of bulk data load from multiple data source ORACLE 8i, legacy systems to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
• Used BTEQ and SQL Assistant Query man front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS and verify data loaded.
• Performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes

Confidential

Sr. Business Analyst/ Data Warehouse Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Carry out users acceptance test, design test scripts, go-live activities and post-implementation support.
• Gather and map business requirements, Gap Analysis, Documentation as per AIM Methodology RD-20, RD 50, BR100, BR10, and BR30.
• Created, reviewed and maintained detail Functional Documents like MD50s, MD120s and BR100.
• 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.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing documentation
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• 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.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Performance Tuning Worked on TD performance enhancement projects by identifying the potential set of columns based on the data demographics, collecting stats and changing the SQL to use Primary and Secondary indexes in queries and TD load scripts.
• Was part of 24/7 production support team
• Interacted with business users, MSI reporting team to resolve data issues.
• ETL - Used TD utilities like Fast Load, Multi Load, Fast Export and BTEQ extensively and conversant with diagnosing and fixing load related issues.
• Worked along with support team for Teradata Data Warehouse
• Used Unix shell scripts extensively to invoke Teradata utilities. Part of 24/7 support. Involved in minor enhancement projects. Worked with users and help solve their issues.