SUMMARY

• Sr. Business/Systems Analyst with 7+ years of experience in Retail and E - commerce Industry.
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP).
• Has strong experience in Retail Applications, Purchase Order Management and Supply Chain
• 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.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
• Experience in developing Forms & Reports using Oracle Forms & Reports
• Business Process Analysis: Proficient in analyzing Business Requirements, System Requirements, Functional Requirement specification (FRS), Design Documents, Use Case Specifications (Use Cases), UML diagrams, Requirements Traceability Matrix (RTM) and performing Gap Analysis, Impact Analysis, Process Analysis and designing prototypes to design the test flows.
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Actively involved in developing, executing and managing User Acceptance Testing ( UAT )
• 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
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Assisted in preparing and executing Test Cases, and reviewed Test Execution Procedure Document (EPD) document prepared based on the Business Requirement Specifications (URS), Functional Requirement Specifications (FRS) to cover overall quality assurance.
• Experience on Retail / Supply chain domain with strong knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process. Little knowledge on POS and Assortment Planning.
• Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 database.

TECHNICAL SKILLS

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, DoorsErwin Data Modeler 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis

Methodologies: RUP, OOAD, AGILE, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, MySQL, DB2

Content Management Tools: Documentum, Sharepoint, Interwoven, Filenet

Languages: UML (Use case, activity diagram, sequence diagram, data flow diagram, component diagram), C, C++, HTML, Java, XML,SQL, PL/SQL, ASP.NET

Modeling Tools: MS Visio, MS Studio, TrueComp

PROFESSIONAL EXPERIENCE

Confidential, Warminster, PA

Sr. Business/Systems Analyst

Responsibilities:

• Assisted in creating File Maintenance use case inventory.
• Gathered requirements from business users and by going through COBOL programs, legacy use cases, and program specs.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerMart, PL/SQL.
• Acquisition Operations will be responsible for analyzing many areas of the business, including but not limited to: receipts routing, planning, receiving, buying, shipping, inventory management, grading, item number creation and purchase order management
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement document FRD, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects dat support the business requirement and process.
• Managed cutover of master data from existing information system into SAP system. Created and performed program specifications for scripting to extract and prepare data for import into SAP database.
• Identified and retail procedures for emerging retail chain
• Developed documentation for POS Systems including Corporate Policies
• Involved in testing the SOAP messages across the web site and made sure results returned in XML format
• Documented requirements for management reporting out of Clear Quest using Crystal Reports
• Worked on implementing software development projects using methodologies such as Waterfall, Rational Unified Process, and Agile/Scrum.
• Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new Dynamics CRM database
• Worked extensively with SME in understanding and documenting their requirements pertaining to monitoring changes and portraying a trend to maintain and analyze customer needs and many other business areas.
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
• Translated Business processes into Informatica Mappings for building Data marts.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Consolidated the analysis of multiple business lines after the COTS evaluation Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Assured dat all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Gathered requirements for the integration of POS system with the supply chain system

Environment: MS Visio, MS Project, UML, DB2, Agile, MS Dynamics Ax 2009, ATG eCommerce, XML,Microsoft Office Suite, Documentum, Windows NT/XP

Confidential, Deerfield, IL

Business/Systems Analyst

Responsibilities:

• Assisted in creating File Maintenance use case inventory.
• Gathered requirements from business users and by going through COBOL programs, legacy use cases, and program specs.
• Acquisition Operations will be responsible for analyzing many areas of the business, including but not limited to: receipts routing, planning, receiving, buying, shipping, inventory management, grading, item number creation and purchase order management
• Identified and retail procedures for emerging retail chain
• Developed documentation for POS Systems including Corporate Policies
• Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
• Coded the ETL and Business Intelligence Batch and On line PL/SQL Packages.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype and overall system.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created the User Acceptance Test Plan and conducted the user acceptance testing (UAT) for the final confirmation of the project from the Business and SME.
• Supply Chain Analyst will be a key contributor in research and development of the company’s oncological products and growth of the company.
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements
• Work with plant management and team members to establish and enhance business processes withinManhattan WMS, JD Edwards E1,and other supporting systems.
• Preparing BRD, Business Cases, and presentation to the clients, Business Re-engineering proposals.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Involved in designing and developing Data Models and Data Marts dat support the Business Intelligence Data Warehouse.
• Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.
• Designed and developed Use Cases, Work flows and Activity Diagrams using UML
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Involved in loading the data into oracle Applications
• Assured dat all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.

Environment: MS Visio, DB2, MS Project, UML, Agile, ATG eCommerce, Crystal Reports, Microsoft Office Suite, Documentum, Windows NT/XP

Confidential, Bensalem, PA

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.
• Coordinates oversight of proper cash handling and financial transactions, including contract and purchase order management, accounts payable, accounts receivable, payroll, grants, revenue recording/uploading;
• Responsible for providing analytical support to Sales Support/marketing and internal sales group clients of WMS.
• Followed Agile (XP) Methodology for the release.
• Performed extensive Requirement Analysis including data analysis and gap analysis
• Prepared UAT Materials UAT Test Cases to include various steps involved for UAT and to has proper coverage of requirements
• Conversion of existing website to ATG software client moved from custom built application to ATGs eCommerce suite
• Work as Business Analyst for the project to build a MS SQL data warehouse for complex wide profitability reporting.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Responsible for scheduling meetings with users, SME’s and stakeholders to identify problems resolve issues and improve the process to ensure a stable and accurate solution.
• Assisted with the BRD for the POS implementation project.
• Performed gap analysis from existing Open Systems software system to SAP.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Involved in testing the POS system
• Work under direct supervision to perform Supply Chain activities for assigned product portfolio to optimize inventory, minimize cost, and set and achieve customer service goals.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Conducted JAD sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions, trade and custodial data.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Analyzed user stories to develop acceptance test criteria in collaboration with product owners.
• Query the database using SQL Advantage for testing and verification purposes.
• UAT testing performed along with call center managers to make sure dat application meets their requirements.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process

Environment: Microsoft Office Suite, DB2, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Biztalk, Sybase, XML, Crystal Reports, VBScript, C#. DOORS, C++, NET, Agile/Scrum, Business Objects, TestDirector, LoadRunner

Confidential, Indianapolis, IN

Business/Systems Analyst

Responsibilities:

• Prior supply chain/ERP/WMS solutions. Food Service preferred.
• Performed Functional, GUI, Regression, System Integration, User Acceptance, Configuration and content testing for web-based ECommerce application and Content Management System.
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Tested application security features, including session expiry, book marking, passwords and compatibility across multiple browser types and encryption levels.
• Conducted UAT to confirm dat all derivative products can be successfully processed through stages of the trade life cycle
• Tested application security features, including session expiry, book marking, passwords and compatibility across multiple browser types and encryption levels.
• Assisted with the BRD for the POS implementation project.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Schedule SMEs for Business Process Validation Meetings
• Imported Sources and Targets, Created Mappings and developed Transformations using Informatica PowerMart designer.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Worked with Product Owners to identify current processes and created Business Process Flow diagrams.
• Designed and implemented basic SQL queries for testing and report/data validation
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.

Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, MS Word, MS Excel, MS Access, Agile/Scrum,MS Project, Java, MS Power Point,, ASP.NET, SQL Server, Windows 2000

Confidential, Hoffman Estates, IL

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.
• Coordinates oversight of proper cash handling and financial transactions, including contract and purchase order management, accounts payable, accounts receivable, payroll, grants, revenue recording/uploading;
• Responsible for providing analytical support to Sales Support/marketing and internal sales group clients of WMS.
• Followed Agile (XP) Methodology for the release.
• Performed extensive Requirement Analysis including data analysis and gap analysis
• Conversion of existing website to ATG software client moved from custom built application to ATGs eCommerce suite
• Work as Business Analyst for the project to build a MS SQL data warehouse for complex wide profitability reporting.
• Work under direct supervision to perform Supply Chain activities for assigned product portfolio to optimize inventory, minimize cost, and set and achieve customer service goals.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Analyzed user stories to develop acceptance test criteria in collaboration with product owners.
• Query the database using SQL Advantage for testing and verification purposes.
• Documented Business Process Requirements with Use Cases and facilitated JAD sessions to define AS IS and TO BE IT processes for the TIERS project a conversion from Unisys COBOL to client/server.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype and overall system.

Environment: Microsoft Office Suite, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Biztalk, Sybase, VBScript, C#. DOORS, C++, NET, Agile/Scrum, Business Objects, TestDirector, LoadRunner