SUMMARY:

• Over all more than 7+ years of professional experience as a Business Analyst in Retail Domain.
• Extensive experience in ATG and in POS (Point of Sale)
• 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 business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Deep understanding of enterprise data warehouses.
• Hand on experience of Jira and Oracle OSB / SOA experience
• Strong experience in RUP Business Modeling process.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using MS Visio and IBM’s Rational Rose.
• Well versed with client server environment and tools like SQL*Loader, UNIX shell scripts and TOAD.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• 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).
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS:

Operating System: Win 95/98/NT/2000/XP/Vista/7, UNIX

Languages: Python, SQL, HTML, PHP

Software/Database: MS-Access, Oracle PL/SQL, ASP.NET, SQL Server,DB2

Web technologies: HTML,XML, Adobe Dreamweaver, MS-Visual Web Developer

MS Office Suite: MS Word, MS Excel, MS PowerPoint

Web protocols: HTTP, TCP/IP, FTP

Modeling tools: MS-Visio, Rational Rose

Project Management Tools: MS-Project

Methodologies: SDLC, Object Oriented Analysis and Design (OOAD), Rational Unified Process (RUP), Unified Modeling Language (UML), Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE:

Confidential - Atlanta, GA

Business Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
• Gathered requirements to customize ATG provided solutions, services, and ongoing guidance to power a more relevant and personal e-commerce.
• Usage of ATG platform including repositories and RQL to build an e-commerce site. professional experience in Design and Development of software solutions by using SOA, EAI Web services technologies
• Prepared user manual for merchandising team on managing commerce assets through ATG BCC (Business Control Centre).
• 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
• Included screenshots in the documents to help the discussion in meetings with users.
• Conducted JAD sessions, initiated scope and discovery meetings.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Implemented and customized Clarity and WorkBench.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Extensively use Microsoft Project or similar tools such as Open Workbench to document project plans.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Analysed business requirements and segregated them into high level and low level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• 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.
• Have been working on exploring different software systems and databases in order to design a possible solution and identifying vital data points/elements.
• Created UML models and visual artifacts like DFD, Flowchart, and Process Flow diagrams.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Worked with developers to make sure that they understood the Use Cases.
• Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Worked as a liaison between the Business and Technology Department.
• Responsible for managing the migration of the department’s website using Web Builder and ensuring that there are no broken links on the intranet.

Environment: UML, JAD, Mercury Quality Center, Load Runner, Oracle 8i/9i/10g. MS-Office Suite (Word, Excel, PowerPoint, Visio, MS Project)

Confidential - Richmond, VA

Sr. Business Analyst

Responsibilities:

• Worked with stakeholders and management team in gathering various requirements for the project.
• Involved in creating mapping specifications during ETL process.
• Written Use Cases, designed detailed logical class and activity diagrams, other high-level process flows
• Analyzed business requirements and segregated them into high level and low level Use Cases, Activity Diagrams, State Chart Diagrams using Rational Rose according to UML standard thus defining the Data Process Models.
• Performed Requirement Elicitation and Analysis and conducted JAD sessions for communicating with Stakeholders and Project directors during Iteration 0. Assisted in preparing User Stories in the Product Backlog after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Discussed requirements with other members of the team like the Application developers, Project Manager and Data Base Administrators.
• Used OBIEE for modeling and reporting purposes.
• Created a new risk and regulatory reporting system to deliver accurate and timely reports through a central data warehouse and Axiom's Regulatory Reporting System
• Designed detailed logical class, use case, activity diagrams and other high-level process flows.
• Interacted with clients to assess needs, identify key challenges, and define project Scope and deliverables.
• Liaised with teams in Business, Team Leads and PMs in global offices for various operations.
• Participated in daily SCRUM meetings in an agile environment, retrospective meetings for issues, in corporate suggestions, decisions in code development.
• Gathered requirements from SMEs and generated reports to help the business to visualize the design.
• Interpreted customer business needs and translate them into application requirements.
• Created reports to help users track cash flows by business areas/department.
• Worked in a Scrum Agile process with 2 week iterations and was involved in Sprint/Release planning.
• Prioritized project efforts, develop project plans, process flows, UML Model and Use Cases.
• Maintained and update digital reports and dashboards based on client requirements.
• Identified and prepared business requirements- gap analysis
• Developed Project management plan which included background including “constraints” and “assumptions, business process, success measures, roles, & responsibilities, project plan for schedule/timelines and resource utilization.
• Reported status, milestones, and project plan tracking to project management and project owners on a weekly basis. Used MS Visio for flow-charts, process model of the application.

Environment: RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, VBA, MS Office suite, MS Visio, MS Project.

Confidential - Shoreview, MN

Business Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• 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.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
• Designed and developed all Use Cases and UML models using MS Visio.
• Facility planner using Clarity and Open Workbench (OWB) for the scheduling and tracking of all projects and online capture of actual and subsequent posting of hours to Clarity
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case
• Conducted RAD sessions for the report users, requestors, and the developers.
• Used MS Project to manage project time lines
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Documented all the changes in the initial templates and was responsible for Release Management.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Coordinated with the developer, on day-to-day basis, during the development process.
• Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
• Worked on Report Re-engineering Project and made enhancements to the system flow.
• 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).
• Worked with ETL team during the upload process.
• Helped with Data Mapping between the data mart and the Source Systems.
• Worked with SQL queries using MS Access for data manipulations.
• Enhanced communication lines between executives, managers, and peers

Environment: MS Visio, SQL, HTML, XML, Mercury Quality Center, RUP, UML, MS Office Suite.

Confidential - Dublin, CA

Business Analyst

Responsibilities:

• Daily duties included giving batch total breakdowns for credit cards that were processed.
• Provided accounting support and assisted on reconciling their monthly credit card statement totals.
• Conducted user interviews and documented business and functional requirements.
• Developed documentation for POS Systems including Corporate Policies.
• Assisted with the BRD for the POS implementation project.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability Testing to verify whether all the User Requirements were catered to by the application.

Environment: MS Project, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, VBA, MS Office suite, MS Visio, Windows XP Professional, XML, MS Access, MS Excel

Confidential

Business Analyst

Responsibilities:

• As a Business Analyst, communicated with internal and external stakeholders to effectively arrive at day to day business requirements and also to arrive at the possible solutions .
• Worked together with the business unit and the IT team and provided domain knowledge and support to develop an in-house user friendly software that was modeled to key the insurance applications and generate various management reports and exhibit dashboards .
• Performed testing, identified areas of improvement and worked with developers to arrive at the expected result.
• Strengthened the business relationship with insurance business partners (Life, Non-Life/P&C, Medical/Health) and Third Party Administrators (TPAs) through effective communication and coordination on regular basis for business, revenue and policy servicing .
• Performed planning and strategy as a team for all the activities to be carried in the company, broadly covering HR, Accounts, Audit, Sales and Operations as a part of Karvy's project
• Interacted with zonal and regional level managers to provide product information and market support.
• Reconciled insurance applications received, recorded, and logged in at the insurance company.
• Ensured collection of new & renewal business commissions and organized the database
• Reviewed the tracking of business- sub-broker, employee, branch, region and zone wise
• Supported in preparation of the budget and tracked the actual performance against set targets
• Prepared management reports and analyzed daily, weekly, and monthly MIS to understand the position of the business.
• Identified the areas of concern and reported to the management about deviations
• Provided claim management services to the customers, TPA, and insurers for early settlement of claims
• Designed test cases and carried out UAT.

Tools: & Technologies: Microsoft Visio, VBA,, Microsoft Excel, Microsoft Word,JavaScript, SQL, SQL Server 2K, UNIX