SUMMARY

• Bit more than six years of professional experience as a Business Analyst in Retail/Ecommerce, Supply Chain and Transportation industry.
• Hands - on experience in Manhattan Warehouse Management System
• Multi-year experience in building strategic partnerships and implementing technology integrations with thorough understanding of SDLC, BPM, SOA, Emerging Technologies and On-Site/Off-Shore Business Models.
• Experience in Administration, analysis, design, development, Production Support in SOA Integration Projects SOA 11g PS5 & WebLogic 10.3.6.
• Experience in writing user stories for API's
• Extensive experience with Business-to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios, such as e-procurement
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Experience performing within the Software Development Life Cycle (SDLC), covering Waterfall model, Prototype model, and Incremental model, with a focus of Agile/SCRUM iterative framework.
• Strong exposure Manhattan Enterprise Order Management and Distributed Order Management System
• Experience in planning, analyzing and designing functional requirements for new ecommerce sites and ongoing guidance to the clients to ensure a high quality e-commerce website
• Hands-on experience on Oracle SOA Suite 11g components like BPMN, BPEL, Mediator, Business Rules, BAM etc. Implementations.
• Extensive analysis knowledge of conducting Business Analysis, GAP analysis, Fishbone Analysis, SWOT Analysis, ROI analysis, use case flow chart, communication diagram, activity diagram and sequence diagrams, using MS Visio, Excel and PowerPoint; strong ability of designing and implementing workflow and messaging solutions using SOA EMS, SPOTFIRE and SOA Business Works.
• Solid understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis.
• Highly proficient in working with users to analyze and document business requirements and subsequently use the rational project and design tools to model the requirements. Nevertheless, excellent team player to work in conjunction with business, users, developers, testers and other team members in validation and testing complex scenarios & projects.
• Working knowledge on dimensional modeling, Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, master data management, data migration, staging, cleansing and mining features for data warehouses.
• Functional experience with concentration on Use Case Modeling, Business Process Modeling, Data Modeling, Change Management, Rational Unified Process (RUP) methodology, Agile methodology and Unified Modeling Language (UML).
• Experience working in Oracle, SQL Server-SSIS, and Teradata and DB2 environments.
• Experience in writing Business Requirement Document (BRD), functional specifications Document (FSD) based on user requirements. Strong skills in user research and analysis of the existing systems, with the knowledge of traceability matrix.
• Extensive experience in modeling for OLAP & OLTP systems
• Strong Experience in conducting User Acceptance Testing (UAT), Unit Testing, System Testing and documentation of Test Cases with expertise in developing Test Scripts.
• Experience in working with end users and the SOA team for developing test cases and test plans.
• Extensively used MS Office suite (Word, Excel, Access, Visio and Power Point) & HP PPM for project tracking, project scheduling/management activities, documentation, presentation and used Visio for Workflow diagrams/business processes.

TECHNICAL SKILLS

Methodologies: Agile, Waterfall, Prototype, Iterative, Incremental, RUP, Scrum, UML

Database Tools: SQL*Plus, SQL*Loader, MySQL, Toad

ETL Tools: IBM InfoSphere DataStage, Informatica PowerCenter, and MicrosoftSSIS

Business Tools: MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Doors, Erwin Data Modeler 4x, Business Object (Crystal Reports), MicroStrategy.

Databases: Oracle, MySQL 5.0, IBM DB2 9, MS SQL Server 2005/2008, Teradata v12/13

Integrating Software Product: SOA Integration Manager, SOA Designer, SOA Spotfire, SOA Business Works, SOA Rendezvous, SOA Enterprise Message Service, SOA Adapters, SOA Hawk

Business Skills: Business definition requirements, requirement prioritizing techniques, business process analysis & research, use case modeling & analysis, Manhattan WMS and TMS

MS Products: MS Access, MS Project, MS Visio, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Installed and configured Manhattan OMS Suite involved in multiple OMS upgrades.
• Facilitated four internal training sessions for new project team members on client's business processes and utilization of Manhattan's supply chain solutions
• Worked with the Business partners to come up with feasible solutions for both the development of system enhancements and the API enhancements.
• Interacted with the client and the technical team for requirement gathering and translation of Business Requirements to Technical specifications.
• Extensively used Informatica to load OLTP data into the Staging Area and Data Warehouse using mappings and transformations such as Aggregator, Lookup, Expression, Joiner, Source Qualifier, Filter and Sequence Generator.
• Conducted requirement elicitation using various techniques, analyzed client requirements, generated workflow processes to identify the system, operational requirements, and proposed enhancements.
• Documented workflows and results of business analysis to obtain sign-off from client on specifications.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Utilizes Manhattan's Warehouse Management System (WMS) and Transportation Lifecycle Management (TLM) software for scheduling, track performance metrics, reporting, production, and to execute daily operations
• Created Screen mock up to illustrate new requirements and alignment around project scope using MS Visio.
• Managed documented System Requirements and Requirements Traceability Matrix using Rational RequisitePro.
• Used Manhattan Transportation management system (TMS) that can manage all the transportation management activities occurring throughout supply chain network of H&M
• Design of interfaces (Batch Files, API's and Single Sign On).
• Responsibilities included Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing.
• Identified trends, anomalies and events that can impact H&M’s supply chain
• Created detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test.
• Worked at different stages of the Software Development Life Cycle (SDLC) with business users, developers, and stakeholders.
• Performed Data extraction, Data Migration and Data conversion using ETL tools from application front-end with Oracle databases and data warehouse.
• Participated in all phases of the Rational Unified Process (RUP) methodology, to develop the project.
• Created data mapping templates and aided the development team to reduce the bandwidth of the project.
• Aided the SOA team to understand the system and develop effective test plans, by conducting sessions
• Assisted use of Manhattan WMS (which is a Supply Chain Process platform) that automate and optimise every touch point in distribution operations and supply chain network—from inventory and slotting to labour and billing.
• Corrected and updated the Requirements Traceability Matrix after completion of the UAT testing phase.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Conducted brainstorming interviews, meetings and requirement discovery & analysis workshop (RDAW) sessions during the process of requirement gathering, and support the team with product backlog grooming activities; conducted feasibility check of the backlog items, used two requirement prioritizing technique, MoSCoW method and Need-Based technique.
• Participates in the design, implementation and distribution of operating procedures for supply chain applications (Manhattan Order Management).
• Utilized SOA implementation for consolidation of enterprise system integration.
• Provide ETL logic to pull the data from Guidewire application database to ODS layer and into Guidewire data marts and Data warehouse .
• Participated in API design code reviews, and developed test plans.
• Created and Designed logical database schema for data warehouse (Teradata) environment to prepare for ETL.
• Implemented customized fault handing fame work for SOA and OSB environments.
• Worked on installing and configuring various third party applications like Aprimo 8.7 (Tera Data), Business Objects, Crystal Reports
• Optimize order fulfillment with Distributed Order Management (DOM)
• Conducted business process analysis to better understand the scope of the project and find the bottleneck and inefficiency of the process using MS Word and MS Visio, provided appropriate scope of work for technical team to develop the design.
• Prepared functional designs employing use case scenarios, sequence diagrams.
• Involved in extracting customer information data, and converted data types and integrated data from multiple sources to target destinations by creating routings using SOA EMS and generated various XML schemas as per the mapping involved in the process flows from the integration perspective.
• Executed queries and running store process in SOA BusinessWorks with Oracle Database 11g; worked on the database and used MySQL to write simple SQL queries.
• Implemented ETL Processes and developed complex SQL queries involving extremely large tables using DataStage.
• Performed efficient time management using burn down chart to track the task schedules and created reports and dashboards in Spotfire Client and implying best practices.
• Building API in XML based on the requirements.
• Performed Tuning by analyzing and comparing the turnaround times between SQL and Tableau.
• Involved Design and development of Tableau visualization solutions and Strong experience in BI reporting including Spotfire.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Involved in effective making utilization of Distributed Order Management approach that made the inventory in our supply chain more productive.
• Worked on Tableau 7.x/8.x (Desktop, Server, Mobile, and Public), MicroStrategy, and SSRS and End to end experience in designing and deploying data visualizations using Tableau.
• Involved in Agile Software Methodologies- Scrum and Kanban and Scaled Agile Framework (SAFe) Practice.

Confidential, Broomfield, CO

Business Analyst

Responsibilities:

• Managed project schedules and system implementation in Agile Scrum Methodology and participated in regular Scrum Meetings and reviewing Sprints and Release Planning meetings.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Assisted and worked closely with Scrum Master and Product Owners to review Sprint progress and managed the project key performance indicators (KPIs) and confirm project risks.
• Automated all operational functions for web operations and used AppDynamics for Application Performance Management and Adobe Analytics for performing analytics.
• Implement data warehouse that integrates different data sources including IBMDB2system.
• Elicited business requirements from business users for adding customized features to the software.
• Converted business requirements into functional requirements and designed business models using Unified Modeling Language (UML) diagrams such as Use Cases, Sequence diagrams, Activity diagrams
• Review technical design documents and addressing any development issues and regular communication with technical design, SOA and developers for software development progress.
• Created wireframes for explaining skeletal framework of webpage and visual end to end flow and used SharePoint for accessing, storing and sharing information and dashboards for identifying KPIs.
• Conducted JAD sessions for communicating with project managers, senior managers and stakeholders.
• Involved in gathering, analyzing and documenting business requirements and data specifications and created Use case diagrams and business process workflow diagrams including Activity and Sequence Diagrams using MS Visio.
• Provided SOA support and developed test plans, test cases to analyze and detect bugs in the system and managed Change Request to organize and maintain user requirements.
• Understanding the mappings and logics built in Informatica to extract and load the data from Oracle ERP (OLTP) system to the Data warehouse (OLAP) system.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Pulled campaign lists for various marketing programs using Multi-Channel Campaign Management (Aprimo MCM), SQL and SSAS.
• Perform data mining, data validation, and create tables within Monarch Pro, Excel, and Access.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Create table structures in IBM Cognos Framework Manager from different sources (Oracle, SQL)
• Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
• Modified the PL-SQL procedures for implementing complex business rules.
• Developed the test scripts using SQL for the unit testing.
• Understanding of API connections and data warehouse's for improved data accessibility, report enhancement and automation implementation.
• Involved in the entire project of migrating reports and cubes from Cognos 7 to Cognos 8.3 and creating project documentation for future use
• Worked with financial executives to design and develop financial reports/budgets. Built database and ETL (transform and load) process in SQL Server (SSIS).
• Involved in dimensional database design for the data warehouse. Created logical and physical data models using Erwin.