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 teh 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 wif client server environment and tools like SQL*Loader, UNIX shell scripts and TOAD.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Knowledge in teh 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 teh long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (multiple) project tasks wif 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 wif a wide variety of people at various levels, foster cooperation and collaboration among individuals in teh work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self starter wif 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 wif senior management of teh Research Group and SMEs and document them.
• Gatheird 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 training 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 wif ATGs eCommerce suite
• Included screenshots in teh documents to help teh discussion in meetings wif users.
• Conducted JAD sessions, initiated scope and discovery meetings.
• Involved in designing and developing Data Models and Data Marts dat support teh 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 wifin teh 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 teh Data Process Models.
• Successfully conducted JAD sessions, which helped synchronize teh different stakeholders on their objectives and helped teh developers to has a clear-cut picture of teh project.
• Has 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 teh Logical and Physical Design sessions and developed Design Documents.
• Worked wif developers to make sure dat they understood teh 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 wif teh Technical Areas in teh research and resolution of System and User Acceptance Testing.
• Worked wif Quality Control Teams to develop Test Plan and Test Cases.
• Worked as a liaison between teh Business and Technology Department.
• Responsible for managing teh migration of teh department’s website using Web Builder and ensuring dat their are no broken links on teh 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 wif stakeholders and management team in gathering various requirements for teh 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 teh Data Process Models.
• Performed Requirement Elicitation and Analysis and conducted JAD sessions for communicating wif Stakeholders and Project directors during Iteration 0. Assisted in preparing User Stories in teh Product Backlog after teh collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype and overall system.
• Discussed requirements wif other members of teh team like teh 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 wif clients to assess needs, identify key challenges, and define project Scope and deliverables.
• Liaised wif 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.
• Gatheird requirements from SMEs and generated reports to help teh business to visualize teh 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 wif 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 teh 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 wif teh account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Owned teh entire reporting process. Interacted wif teh ETL team, developer(s), management, and account holders to get teh 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 teh 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 teh report users, requestors, and teh developers.
• Used MS Project to manage project time lines
• Prepared Need Analysis Documents of teh requirements gatheird through JAD sessions.
• Documented all teh changes in teh initial templates and was responsible for Release Management.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Coordinated wif teh developer, on day-to-day basis, during teh development process.
• Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
• Worked on Report Re-engineering Project and made enhancements to teh system flow.
• Reviewed Stored Procedures for reports and wrote test queries against teh source system (SQL Server) to match teh results wif teh actual report against teh Data mart (Oracle).
• Worked wif ETL team during teh upload process.
• Helped wif Data Mapping between teh data mart and teh Source Systems.
• Worked wif 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 dat were processed.
• Provide analysis support of existing Data and Order to Cash processes, policies and/or system changes.
• 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 wif teh BRD for teh POS implementation project.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Involved in mentoring specific projects in application of teh new SDLC based on teh Agile Unified Process, especially from teh 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 teh Load Testing Process and Methodology. Created meaningful reports for analysis and integrated teh Performance Testing in teh SDLC.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised teh development of User Manuals for customers.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Various versions of teh documents generated during teh project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested teh final application for Usability Testing to verify whether all teh User Requirements were catered to by teh 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 wif internal and external stakeholders to TEMPeffectively arrive at day to day business requirements and also to arrive at teh possible solutions .
• Worked together wif teh business unit and teh IT team and provided domain noledge and support to develop an in-house user friendly software dat was modeled to key teh insurance applications and generate various management reports and exhibit dashboards .
• Performed testing, identified areas of improvement and worked wif developers to arrive at teh expected result.
• Strengtaned teh business relationship wif insurance business partners (Life, Non-Life/P&C, Medical/Health) and Third Party Administrators (TPAs) through TEMPeffective communication and coordination on regular basis for business, revenue and policy servicing .
• Performed planning and strategy as a team for all teh activities to be carried in teh company, broadly covering HR, Accounts, Audit, Sales and Operations as a part of Confidential 's project
• Interacted wif zonal and regional level managers to provide product information and market support.
• Reconciled insurance applications received, recorded, and logged in at teh insurance company.
• Ensured collection of new & renewal business commissions and organized teh database
• Reviewed teh tracking of business- sub-broker, employee, branch, region and zone wise
• Supported in preparation of teh budget and tracked teh actual performance against set targets
• Prepared management reports and analyzed daily, weekly, and monthly MIS to understand teh position of teh business.
• Identified teh areas of concern and reported to teh management about deviations
• Provided claim management services to teh customers, TPA, and insurers for early settlement of claims
• Designed test cases and carried out UAT.