SUMMARY

• Over 8years of experience as a Business Analyst/System Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping, application upgrades, and Business Analysis.
• Expertise in management, sales, marketing, operations, financial planning, supply chain, human resource, E - Commerce and new business development in a growing company.
• Extensive experience in modelling the AS IS and TO BE ecommerce solutions
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modelling, Business Analysis and Testing various methodologies.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Involved in business analysis, system analysis and designspecification, project management, requirement gathering, database design, business modeling, data mapping, OOAD, UI design, software development, validation, and testing.
• Experienced with procurement and acquisition formalities.
• Expertise on Data/Business Analyst in ETL process, business process analysis/modeling, database design and development of Web Based, and Client/Server applications.
• Experience developing web based, internet / intranet and client / server architecture using Java / J2EE technologies.
• Extensively worked on E-commerce platforms like ATG and Hybris.
• Reviewed and proposed to guide lines for vendor management business process.
• Extensive experience in conducting Market Research, Feasibility Studies, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Extensive experience with data modelling and defining the conceptual and logical model of the data warehouse.
• Performs business process design work to create new ways of managing content within the Content Management System (CMS).
• Developed User Stories throughout the Agile Lifecycle as well as created various UML diagrams such as Business Use Case, Activity and State Chart diagrams with tools like Rational Rose and MS Visio.
• Solid experience with SOAP, web services, WSDL and designing/coding/debugging in a web service based
• Gained extensive experience with various tools and platforms such as Rational Quality Manager (RQM), Clear Quest (CQ) and DOORS among others.
• Hands-on experience with Waterfall, RUP, & Agile Scrum methodologies
• Experienced with Manhattan Warehouse Management Systems (WMS) and Order Management System (OMS).
• Experienced in using variousPOSsystems, such as PassportPOSsystem, Target's home grown POSsystem, knowledge of FujitsuPOSsystem, knowledge of SquarePOSsystem.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning,Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS

Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, MS Project, MS Visio, MS Office Suite, Bloomberg,VBA for Excel, SQL, PL/SQL, Java, J2EE, C#, VB.NET, C++/CLI, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX

Databases: Oracle 8i/9i, MS SQL Server, MS Access

Environment: Windows 9x/NT/2000/XP, UNIX (Sun Solaris, AIX, HP-UX), Linux, Mainframe

PROFESSIONAL EXPERIENCE

Confidential, Farmingham, MA

Sr.Business Analyst/System Analyst

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the internal systems.
• Facilitated JAD sessions with the management, developers and analysts from all the dependant systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
• Analyzed the complete Supply Chain, from receiving an order in OMS (Order Management System) and complete processing till final delivery to customer.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the specifications for the product.
• Performed GAP Analysis, designed new business process flows, and documented various business scenarios.
• Responsible for E-commerce website developed in Hybris Platform for new enhancement of existing B2B and B2C applications.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering
• Designed and implemented service-oriented architectures (SOA) suitable for secure, reliable, and high-performance system.
• Proficient in creation of source to target data mapping documents in a data warehouse environment and execute sql queries in a data warehouse environment.
• Experience managing requirements using JIRA, Remedy and HP Quality Center.
• Implemented Web Services (SOAP, UDDI and WSDL) to integrate different applications.
• Gathered requirements for the integration of POS system with the supply chain system
• Worked with UI and UX designers to create prototypes and Website workflow.
• Gathered requirements for the integration of Point-Of-Sale (POS) system with the supply chain system.
• Hands on experience in working on SOA, detailing out web services, data mapping of elements and defining various operations for web services.
• Facilitated JAD sessions with Data management, development team, users and other stakeholders to refine functional requirements.
• Assisted with the BRD for the Point-Of-Sale (POS) implementation project.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Coordinated with UX designer to create storyboards related to user stories
• Facilitated daily stand ups and managed task board with user stories and board
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Created surrogate key tables to map the required dimensions.
• CreatedBusiness Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.

Environment: Rational Rose, PL/SQL, HTML, ETL Informatica, MS Office, MS Visio, EDI, UML, RUP, SCRUM, JIRA, Websphere, SOA, Webservice, MQSeries TIBCO,Agile, SOA, Java, J2EE, MS Office, Oracle, Teradata, Erwin, SoapUI, SOA, SQL Server, MS Project, POS system (Ciao)

Confidential, Minneapolis, MN

Sr. Business System Analyst

Responsibilities:

• Gathered requirements for the integration ofPoint-Of-Sale (POS)system with the supply chain system
• Assisted with the BRD for thePoint-Of-Sale (POS)implementation project.
• Interacted with various cross functional teams in order to establish comprehensive business and functional.
• Analyzed the complete Supply Chain, from receiving an order in OMS (Order Management System) and complete processing till final delivery to customer.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Worked with end users to design business requirements of a Business CRM System and manage B2B processes of distribution across the region.
• Acted as a liaison between IT personnel and company clients to develop and deliver E-commerce websites, software applications, tools, and other solutions while ensuring the operational effectiveness and excellence.
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Gathered requirements for Data Warehousing (DWH) needs across the company.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Worked on projects which used Agile and Waterfall methodologies.
• Support for a major effort to improve the Order Management System (OMS) capabilities of Supply Chain.
• Managed supply chain and procurement of all domestic and national supplies.
• Ensured that the E-commerce Business Unit and clients are aware of the current status of their issues and that any changes in priorities are communicated to all affected individuals.
• Facilitated JAD sessions on regular basis in order to plan, identify, research business rules and needs.
• Followed by creation of Meeting Minutes to convey/communicate plans and decisions, which is reviewed by business and technical SME.
• Created Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
• Conducted, presented and participated in the JAD sessions, code and design reviews sessions with project development teams.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Created source-target data mapping document.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Configured the Data mapping between Oracle, Teradata and SQL Server.
• Kept a track of all QAT and UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved.

Environment: Microsoft Office SharePoint 2007, SAP SCM, SAP CRM, Rational Requisite Pro, MS Office, Oracle apps 11i,Hybris, Teradata, Erwin, Agile, Java, TIBCO, J2EE, Scrum, SoapUI, SOA, SQL Server, MS Project, MS FrontPage 2003, MS Access, EDI, Documentum 2.0., UML.

Confidential, Portsmouth, NH

Business Analyst

Responsibilities:

• Interacted closely with End users from Underwriting&Claims teams and SMEs to understand and gather the business needs and requirements.
• Maintained a problem tracking document tool calledRemedy which monitored all incominghelp desk ticketsincluding customer assistant, break fixes, required modifications and elective enhancements.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Wrote Business Request 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 the business requirement collection approach based on the project scope and SDLC methodology.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Involved in creating Stored Procedures for the claims application.
• Track and manage all Change Requests, using Rational ClearQuest.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Implement and maintain Property&Casualty(e.g. bug-fix, data integration, version release) systems of assigned customers.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Documented and delivered Functional Specification Document to the project team.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment: Guidewire Claim Center, Policy Center, Billing Center, Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Project, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner.

Confidential, Stamford CT

Business Analyst

Responsibilities:

• Gathering Requirements and design of technical specification documents. Document the business requirements for the Cognos BI reports.
• Derive Cognosreport requirements from already existing report templates.
• Interacting with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Identified Use cases from the requirements and wrote Use Case Specifications
• Created business process workflow diagrams (Activity diagrams) in Rational Rose
• Assisted in finalization of risk rating algorithm for investment products based on various risk sensitivities and attributes.
• Prepared Data Flow diagrams using Visio and managed change requests liaison with Business and Development team during project implementation of Investment Product Risk (IPR).
• Coordinated SIT and UAT of Investment Product Risk system implementation and provided clarifications to testing and QA team.
• Preparing efforts estimate for Volcker rules in collaboration with compliance, derivatives and investment desk, business risk office and PMO team.
• Engaged with Risk Analytics team and gathered various macroeconomic time series reference data requirement for Economic Capital requirement calculations.
• Involved in replication of data from MQ Series using Distributed Transaction Stage (DTS) to populate DB2 UDB.
• Leverages checkpoint/restart where applicable.
• Supports real time data integration and end-to- end metadata management
• Used Informatica Power Center Designer and Workflow manager to create mappings, sessions and workflows to run the logic embedded in the mappings.
• Developed PL/SQL programs, stored procedures for data migration, data loading and data validations.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Worked on Workflow Groups, Work Policies, Workflow Process and Business Services.
• Involved in reviewing and discussing Test Plan with other team associates.
• Performed Functional, Regression and User acceptance testing.
• Tested Dimensional Hierarchies, Level Based Measures in Business Model and

Environment: Cognos 8 BI, Rational Rose, Rational RequisitePro,DataStage Enterprise edition Paralell extender 8.1.1(Designer, Manager, Administrator, Director), Quality Stage 7.5, ETLInformatica, Oracle 11g, PL/SQL, SQL Loader, SQL Reports, Teradata, DB2, Cognos 8 BI, MS Office, MS Visio, MS Access, MS Word, MS PowerPoint, MS Excel, ERWIN.

Confidential, Baltimore, MD

Systems Analyst

Responsibilities:

• Worked with the core team to design business requirement collection approach based on the project scope and SDLC Methodology.
• Designed and developed Project document templates based on SDLC methodology
• Work closely with Business Owners and Stakeholders to outline Business Requirements.
• Work with System analyst and IS teams to understand the flow of data.
• Reviewed and analyzed data from various sources.
• Facilitate risk management workshops, recording risk and assigning risk for mitigation.
• Research and resolve system issues and perform application testing as necessary. Produce metrics reports from data derived from database as necessary for the project.
• Identified gaps and performed gap analysis with respect to CMS requirements
• Responsible for implementing supply chain and operations solutions.
• Product creation and supply chain groups worked together to address critical dependencies between processes like demand, supply, tooling and warehousing.
• Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
• Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Rational ClearCase was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking and Mercury Test Director for Test Case Management.
• Developed XML Schemas and DOM parser for all the XML documents used for data transfer and also developed XSLT code for them.
• Also performed test automation by QTP, evaluation of the test results to determine compliance with test plans and established business processes.
• Was involved in maintaining and cleaning up of the regression test case database i.e. identifying the redundant or irrelevant test cases and deleting them from the database so that the software certification process is expedited.
• Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend the most efficient solution for system design.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.

Environment: Windows XP, Business Objects, XML Schemas, Zachman Framework, MS Excel, Word, Casewise Corporate Modeller, power point, SQL, PL/SQl, DB2, SAS database