PROFILE

Analytical, talented and accomplished Business Analyst with over 8 years of diversified experience, is seeking a Business Analyst position which will utilize and incorporate my current skills and experience, as well as expand them to assist the organization in being successful

SUMMARY

• Excellent technical writing skills to create Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Cases Specifications.
• Skilled in Object Oriented Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Unified Modeling Language UML using MS Visio and Rational Rose.
• Proficient in GAP analysis, by seeking clarity in understanding 'as-is' state and collecting requirements to determine 'to-be' state.
• Comprehensive knowledge of SDLC Methodologies like Waterfall and RUP.
• Excellent Business writing skills in writing Business requirements document BRD's , Use Case specifications, Functional Specifications, Test cases, Test plans, GAP analysis, Traceability Matrix, Workflows and Unified Modeling Language UML diagrams such as Activity diagrams, Collaboration Diagrams, Data Flow Diagrams, Class diagrams and Sequence diagrams in M.S Visio.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements
• Thorough knowledge of Data Analysis, Data Migration, Data Integration, ER Modeling, Dashboards, SQL, PL/SQL, Excel, Business Processes, Business Requirements gathering, Process Flows, and related technical processes
• Expertise in implementing complex Business rules by creating robust mappings, maplets, and reusable transformations using Informatica Power Center and Power Mart.
• Experience in writing test cases for Informatica mappings Worked on Oracle R12 financials applications, Fixed Assets, and General Ledger modules.
• Created Development/Reporting output through SharePoint to customer business units.
• Worked with multiple lines of business to manage application teams and develop an extensive Knowledge of Sharepoint Portals, Data Warehouse, Business Objects, OLAP for BI, KPI dashboards, Financial and Project Management reporting.
• SME on Order Management Module from Oracle for booking new orders and managing customers and existing orders
• Strong experience with project management tools such as MS Project for status reporting and project planning

TECHNICAL AND SOFT SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

The E-Commerce Enhancement project is an Agile Driven project that adds and incorporates new business rules, which translates to the business requirements, to the new release of the web based E-Commerce Application. I was Release and Change Manager for the scheduled deployment of this application.

Responsibilities:

• Conceptualized and defined an ecommerce platform that is highly available, highly scalable, with low maintainability and high performance, built using reusable components and optimized
• Helped develop and propose Oracle EBS OMS-centric processes, policies, and standards
• Expert knowledge of Oracle EBS Order Management System components, API's, and related Interfaces
• Identified the features of taxation in the Order Management application.
• Carried out scheduling of the procurement proposals using the lead times for the materials/components using PeopleSoft SCM
• Began quoting and ordering in CSCC Cisco Service Contract Center - Cisco Services Quoting Ordering
• Created estimates and quotes in Cisco Quoting and Ordering
• Scheduled the procurement proposals using delivery lead times for the materials/components
• Utilized the PeopleSoft SCM module master data, configurations and transactions to complete the Procure to Pay process.
• Followed top down leveled technique for building the Business Process Models.
• Written advanced SQL queries to test the database backend.
• Used SQL queries to extract data from MySQL database including testing and production for data validation and data analysis
• Developed reports using IBM Cognos Dashboards
• Enhanced the existing cognos applications and improve its reliability and efficiency
• Played a major role in a system wide infrastructure upgrade for the Unix environment.
• Troubleshooting Unix issues/Configuring the Unix hosts in a secure environment.
• Database application support running on the Unix servers User support and administration for Unix servers.
• Developed and implemented Incident Management, Problem Management, and Configuration tools and processes across the enterprise.
• Created data models and business process models using Rational Rose.
• Implemented current ticket tracking system Remedy ARS System .
• Continually worked with Remedy Development team to customize system which enables team to better track, log and work issues
• Foundation Data Acquisition in Asset, Change, Incident and Problem Management.

Environment: PeopleSoft SCM, Oracle 11i, Agile, Informatica, Sterling/Yantra OMS, IBM DB2, Syncsort, Erwin 4.0, Business Objects 5.x, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL, VSAM Files, TSO, MVS, ISPF, JCL, XML, XSLT, XSD, XML Spy.

Business Analyst, Order Management System

The project was to implement an order management solution which would enable them to centrally store, collaborate and create multiple versions of the same orders/content effortlessly, and to distribute orders to different shipping stores to balance the workload and ensure efficient order deployment.

Responsibilities:

• Communicated and collaborated with stakeholders to elicit, gather and analyze high-level business requirements
• Responsible for providing technical and functional expertise and direction for the Oracle EBS OMS Order Management System delivery.
• Implemented the Inventory Management subcomponent of PeopleSoft SCM
• Update project schedules and make sure that projects are on target by managing hourly and financial updates.
• Plan future application release deployments to Production Environment.
• Create the Release calendar for the applications
• Resolved issues, queries or problems in relation to application of Cognos technology for BI
• Developed install plans, notified users of system maintenance and associated downtime, issued release notes.
• Worked with cross functional teams to implement the workflows and approval groups for problem and incident management.
• Created a patch release format allowing customer support to know which patches had been applied to any system.
• Used MS Project to create business plan and also worked on business case analysis
• Elicited detailed business requirements using a variety of techniques like interviews, document analysis, business process workflows, prototypes, storyboards and use case scenarios
• Sequenced the activities that were performed in the Order Management phase.
• Incident Management Process SME/owner and managed Remedy change procedures and models
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document
• Experienced at determining the level of data quality in the current system by identifying errors such as incorrect data, data truncation issues, unmapped parameters etc.
• Analyzed data from web analytics tools to create customized reports calculating key performance indicators, metrics, and trends

Environment: MS Project, Microsoft Content Management Server, Informatica, Oracle EBS OM, MS Office SharePoint Server 2007, MS Office, MS Visio, ASP.NET, Rational Requisite Pro

Business Analyst

Confidential Licensing is an Inventor's marketing and representation firm representing over 700 inventions having highest licensing ratio in US. The company wanted to streamline their large scale data that was initially stored in excel spreadsheet and MS access tables and migrate to an Oracle database. The project involved creation of forecasts and performance metrics as a tool for comparison. All this was performed for the under development online retailing program of the company

• Responsibilities:
• Accumulate data from Sales, Marketing and Finance for performing data analysis to prepare reports for Marketing VP
• Performed Data Migration from legacy spreadsheet tables to Oracle, and Data Mapping for easy and faster access to information
• Created high level process flows and various workflow diagrams for the base product using UML
• Created feasible possible solutions to the Gaps between the current product and clients base requirements
• Created data mapping documents between the current database for the product and all the client side database and identified all the extra data variables needed for the project
• Created Test Data and tested SQL database referential integrity and unique constraints
• Created various design documents User interfaces for the project according to the client's requirement using MS Visio
• Created an engineering specification design document identifying each field on the User Interface UI and their mapping back to the database as an input to the developers
• Conducted internal review meeting within the functional team and captured all the necessary changes and implemented them
• Conducted various meetings with the technical and data architect to verify various functional and business changes requested in the current product
• Identified and documented Issues, risks, and gaps, and their descriptions and impact, and provided recommendations and alternatives. Analyzed and covered gaps in training, and published the relevant documentation
• Created various use cases, test scripts, main flows, alternative flows based on the User Interface
• Created various Help documents for the current product and conducted various presentation for the client

Environment: Quality Center, Windows NT Server, SQL, MS Word, MS Excel, MS Access, MS Project, MS Visio, Requisite Pro, SQL Server, Informatica Power Center 6.1

Business/Data Analyst,

Being nation's largest department store, brand awareness and presentation is the key to Walgreens' customer satisfaction initiative. Emails generated by the current system were unable to fulfill these business needs. This project involved enhancing the current web server and email system to significantly reduce internal operations time and ensure that customers receive all data/information relating to their orders in an attractive and brand-appropriate manner as well as receive their orders on time.

Responsibilities:

• Contributed ideas towards building the company's core business and marketing plan implemented them into the business and functional requirements of the platform
• Conducted SWOT ANALYSIS before devising marketing plans
• Conducted Joint development sessions with the IT team and the business users
• Conducted feasibility analysis in correlation with the Developer to ensure the project was in scope with the timeline defined in the Project Plan.
• Maintain Remedy training environment
• Data analyst duties including prepping spreadsheets for Remedy data loads
• Built Incident and Request Management Models in Test Remedy environment and had it approved for implementation
• Remedy process and module setup for team based on ITIL best practices
• Worked on designing the wire frame and web page mock up for the shoe catalog system online
• Performed Gap Analysis to determine the company's present performance and plan future developments created functional prototypes based on this analysis
• Validate the ETL Informatica mappings, SQL queries and different ETL transformation.
• Used the ETL functionality of SSIS to retrieve/send the MetaData from/to the heterogeneous sources.
• Prepared Data modeling and Data Mapping document for data elements and data cleansing that were used for Current and New system.
• Conducted data modeling to map legacy system's data fields to the new platform
• Conducted detailed data analysis using MS-Access to understand the current database structure with a view of creating the Data Dictionary
• Conducted JAD sessions with resolve issues and documented the minutes of the meeting.
• Help define or assist with developing Sterling OMS implementation best practices
• Reviewed use cases and other technical documents with IT project staff to ensure business requirements are adequately reflected in Business Requirement Specifications.
• Managed UAT and beta testing cycles and provided post-production support managing defect tickets and RFCs
• Handled scope creep and incorporated the relevant changes in features effectively
• Devised extensive E-mail marketing campaigns regularly kept a track of positive feedback

Environment: MS Visio, RUP, Rational Rose, Windows XP, Web 2.0, AJAX, Microsoft office