Name: Liju Varghese

Contact No.: 832-***-****

Email Address: bvxhxi@r.postjobfree.com

Current Location: Houston,TX

Visa Status:Citizen

Relocate: No

Availability: Immediately

PROFESSIONAL SUMMARY

• 6 Years of experience as a Business analyst having worked in reputed organizations like Cardinal Health,GE Energy,HP,Sapient,Sprint,Disney World

• Requirements gathering, Business Case Development, Business Framework Analysis, Business Process Re-engineering using UML.

• Project Planning, Project Scheduling, Project Tracking, Risk and Scope Change Management, And Project Reporting

• Query Analysis and Report Generation using Business Explorer, Query Designer, SAP BW, SAP MM,SAP CCS Web Application Designer, SAP Business Objects and Yotta.

• Worked on RDBMS like Oracle 9i, SQL Server, Microsoft Access, SQL,PL-SQL

• Tested applications on Java, JavaScript, VB Script, C, C++,ASP.Net,C#

• Tools/Technologies evaluations, prototyping and recommendations.

• Excellent interpersonal, written and communication skills.

TRAINING/CERTIFICATION:

• BW310 Business Information (BW) Data Warehousing

• BW305 Business Information Warehouse (BW) – Reporting & Analysis

• BW330 SAP BW Modeling, BW350 SAP BW Extraction.

• Formal training in Agile Architecture and Design Patterns.

EDUCATION:

• M.S. (Computer Science)–2005

• B.S. (Computer Science)-2002

• B.S. (Chemistry)-2004

PROJECT DETAILS:

Cardinal Health Houston, TX, USA Jan 2011 – Nov 2011

Lead Business Analyst

Responsibilities:

• Identify problems with current systems and work with managers and end users to determine whether work processes should be changed or the systems should be changed and how

• Write business requirements, programming specifications, and training material

• Designed the Business requirements in MS Visio

• Gathered all the requirements and Projects from the Steering Committee and worked with the IT Technical team

• Provided training to the End Users to validate the requirements.

• Prepared Test Plan and Project Plan for different project

• Worked on the resources for project allocation along with the time estimation

• Create various functional views of the Program’s budget for Finance and Steering Team

• Worked on SDLC like Waterfall model and Spiral Model

• Coordinates and leads JAD sessions and conducts one-on-one requirements interviews

• Includes setting up new team members, solving tool issues, auditing and updating issues, risks, benefits

• Implemented POM and QOM for electric gas utilities for projects like Meter Reading and Reconnect Process

• Data Analysis is done for different reports in SAP CCS and SAP BW using BEXAnalyser

• Create various functional views of the Program’s budget for Finance and Steering Team

• Requirement Gathering and testing done for E-commerce applications

• Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

• Work with Managers for PMO activities and Project Plan.

• Refreshing the systemsforPointofsalesetups for meters in Houston TX,

• Communicate changes in functionality, cost, or timelines to customers

• Data Analytics and Reporting

• Documentation/Use Case Documentation/Function Documentation.

• Prepare special reports and exhibits with directions on Crystal reports

• Reporting done in SAP BW and BEXAnalyser

Environment:SAP CCS, BW,Quality Center, Test Director, Windows, SQLServer,.NET

GE Energy, Houston, TX, USA January 2010 – November 2010

Lead Business Analyst

Responsibilities:

• Develop design solutions and write functional specifications

• Develop, test, implement, and maintain policies, procedures, work instructions, functional specifications, test scripts and training plans

• Write business requirements, programming specifications, and training material

• Perform consolidation of all projects budgets into the Program budget sheet

• Reconcile the General Ledger to the reported projects’ actual cost

• Requirement Gathering and testing done for E-commerce in Oracle applications

• Implemented SAP/PRA Tax module for different Vendors and Suppliers

• Actual and forecast for the Program; reconcile employee and contractor billings

• Worked with store management and vendors to implement new quality process

• Drive the implementation of Oracle MFG products in the organization

• Worked on SDLC like Waterfall model for requirement analysis,Testing and development

• Troubleshoot questions and problems from the user community with Oracle Application issues

• Monitored the Point of Sale for different Vendors and Suppliers for LMS and Aircraft Engines

• Worked with the PMO on multiple projects for budget and project Analysis

• Worked on KRONOS applications for Time Tracking for employees and Workers at Plant.

• Managed the Entire RFP process along with the release plan and Project Plan

• Take Meeting Minutes and notes for every session to cover next steps.

• Designed the Business requirements in MS Visio

• Worked on Loans. Non-accrual loans like Shadow processing,Cash basis.

• Collaborate with development and business liaisons to develop test scripts

• Assist the business liaison with training documentation

• Interface with Oracle Support and log Technical Assistance Requests with Oracle Support as needed.

• Gather system requirements from business users and create functional requirements documents

• Coordinates and leads JAD sessions and conducts one-on-one requirements interviews

• Train users on processes relevant to using Oracle applications

• Act in liaison capacity with other departments, divisions and organizations.

Participates in and contributes to all phases of systems development, including requirements, design, development, client training, data conversion, testing and maintenance to achieve the successful development and implementation of the customer's business systems

• Utilize SAP functionality within the Sales and Distribution module and also within the Logistics Execution System, Central Functions, Materials Management, Production Planning, and Financial modules

• Support and develop SAP and other system functions required for Order-to-Cash process that include Sales Forecasting and Demand Planning, Customer and Product Master Data, Customer Order and Order Fulfillment, Pricing Administration, Inventory and Batch Management, and Storage of Finished Goods, Deliveries, Shipping, Customer Billing, Transportation, and Accounts Receivable

Maintain and support the Order-to-Cash Process requires the IS Functional Process Administrator to monitor, track, and coordinate the identification, prioritization, and resolution of SAP and related application support request

• ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation

• Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

• Providing Oracle Support in GL, AP, AR and Cash Management

• Worked with Oracle Support to resolve questions, problems and enhancement requests

• Document operational procedures to completely describe any new processes and procedures

Environment: Oracle Applications,J2EE,Quality Center, Test Director, Windows, SQLServer,.NET

HP, Houston,TX January2009 – August 2009

Senior Business Analyst

Responsibilities:

• Expertise with Reporting tools like SAP Business Objects and Yotta

• Analyze, design, develop and maintain the data warehouse data models for HR and Materials Management

• Design and development of simple to complex data models and ETL Load routines that meet business requirements

• Provide day to day leadership and analysis to define, design, and implement a data quality monitoring strategy

• Implemented Sharepoint for Business Requirements for File system Access

• Develop design solutions and write functional specifications

• Develop, test, implement, and maintain policies, procedures, work instructions, functional specifications, test scripts and training plans

• Includes identification of major deliverables, dependencies, and milestones and the dates .

• Worked on SDLC like Waterfall model for requirement analysis,Testing and development

• Worked with the PMO on multiple projects for budget.Time and project Analysis

• Participate as part of a team in a Data Quality Analyst role to establish and implement a data governance framework

• Identify and collect data required to record and calculate realization of benefits for POS.

• Work with Managers for PMO activities for Project Billing ,resource and duration of Projects.

• Wrote Software product documentation for HP Products for several laptops and Desktop solutions

• Conducted research into application development issues and products

• Analyze, design, develop, implement, and evaluate web-based, blended, and installed computer-based training.

• Participate in technical and business meetings (as required) and maintain minutes, to include issues, actions, and decisions

• Worked on the Post Implementation process once the product went live.

• Develop product documentation and deliverables such User Manuals, Configurations Guides, Technical Architecture Guides, On-Line Help, Training Guides for several laptops and desktops

• Created test cases for UAT

• Writing SQL queries and manipulating large amounts of data

• Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

• Implementing entire software development life cycle (SDLC) including analysis, design, development and testing of software applications

• Responsible for quality and timeliness of operations

• Great customer interfacing skills and customer orientation

• Provide support to Technical Trainers for classroom presentations and technology.

Environment:SAP Business Objects, Yotta,Quality Center, Test Director, Windows, Unix, SQLServer

Disney World, Houston, TX, USA May 2008 – September 2008

Lead Business Analyst

Responsibilities:

• Compile, organize, and review data for use by analysts and management

• Writing SQL/PL-SQL queries and manipulating large amounts of data

• Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

• Provide day to day leadership and analysis to define, design, and implement a data quality monitoring strategy

• Worked with Project Managers on Project Management using tools SAP BW and assisted Project Managers for evaluating the costs of Projects

• Worked on Agile and Scrum methodology

• Documenting use cases with a UML tool

• Develop product documentation and deliverables such User Manuals, Configurations Guides, Technical Architecture Guides, On-Line Help, Training Guides for Disney Products

• Experience with Energy Credit Production Support

• Help customers with enquires – provide advice, styling tips and product knowledge

• Analyze, design, develop and maintain the data warehouse data models

• Project manage milestones and progress on Performance Solutions Action Request items.

• Experience with Enterprise Content Management

• Assist in the documentation of actuarial work products

• Prepare special reports and exhibits with directions on Crystal reports

• Reporting done in SAP BW,SAP R/3 and BEXAnalyser

• May perform a variety of administrative duties for the unit.

• Wrote Test plans and procedures for HP Monitor compatibility display testing

• Implemented website providing real time status on results to HP and US and overseas vendors

• Assist vendors with implementation of fixes needed to resolve monitor issues

• Project Managed BANA Midwest rollouts in 12 major cities with 27 field techs

• Scheduled the training, site surveys, site installs and hiring for the complete project.

• Scheduled and organized weekly Conference calls with HP and field technicians.

• Designed and organized a functional test lab for testing any type of software or hardware on a wide range of operating systems and computers for Digital blue Testing for different cameras and camcorders of Disney Products

• Utilize and maintain spreadsheet, mainframe, and other technical applications used in the actuarial ratemaking process

Environment: Quality Center, Test Director, QTP, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,MS Access

Western Union Money Transfer, New Delhi, India January2006 – July 2007

Business Analyst

Responsibilities:

• Worked on Project Management using different tools and assisted Project Managers for evaluating the costs of Projects and evaluated Time Tracking tools

• Monitor and execute ETL routines and design, develop, and support OLAP solutions

• Work with programmers to make sure requirements are understood

• Developed Test Plan/Scenarios and create Test Cases from the Requirement

• Documentation/Use Case Documentation/Function Documentation.

• Prepare special reports and exhibits with directions on Crystal reports

• Reporting done in SAP BW and BexAnalyser

• Strong understanding of database structures, theories, principles and practices

• Designing, installing, configuring and supporting database servers

• Hands on troubleshooting and database tuning experience

• Execute Test cases to cover both positive and negative functionality as well as back

Environment:Quality Center, Test Director, QTP, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,Access

Sprint, New Delhi, India September 2006 – December 2006

Business Analyst

Responsibilities:

• Identify problems with current systems and work with managers and end users to determine whether work processes should be changed or the systems should be changed and how

• Write business requirements, programming specifications, and training material

• Writing SQL/PL-SQL queries and manipulating large amounts of data

• Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

• Data Analytics and Reporting

• Expertise with Reporting tools like SAP Business Objects and SAP Business Object universe for Incident and Interaction management

• Analyze, design, develop and maintain the data warehouse data models

• Design and development of simple to complex data models and ETL Load routines that meet business requirements

• Monitored the Point of Sale for different Vendors and Suppliers for Hospital Management System

• Worked on Project Management using different tools and assisted Project Managers for evaluating the costs of Projects and evaluated Time Tracking tools.

Environment:Quality Center, Test Director, QTP, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,Access

Indian Oil, New Delhi, India August 2005 – August 2006 Senior Business Analyst

Responsibilities:

• Analyze, design, develop and maintain the data warehouse data models

• Design and development of simple to complex data models and ETL Load routines that meet business requirements

• Worked on ERP Systems for Data Warehousing,Data Modeling and Reporting in SAP BW

• Documenting use cases with a UML tool

• Reporting done in SAP BW and BEXAnalyser

• Assisted multi-disciplinary teams on operational and maintenance trouble-shooting.

• Monitored utility system behavior for adverse trends to allow fast response to potential threats.

• Identified & implemented specific projects and plant changes to improve the safety, reliability, integrity, efficiency, operability and capacity of the utility systems.

• Unix and Shell Scripting

• Provided process & operational inputs into the technical safety & operability reviews, training operators, maintenance activities, and performance test-runs.

• Participated in incident investigations and problem solving for the utility systems.

• Examine and analyze underwriting information for impact on actuarial analysis for pricing

• Extract, reconcile, and manipulate data to provide to actuarial staff for use in actuarial analysis

• Analyze, design, develop, implement, and evaluate web-based, blended, and installed computer-based training.

• Prepare special reports and exhibits with directions

• Provide support to Technical Trainers for classroom presentations and technology.

• Done Data Analysis in Excel and Access

• Geographic and economic analysis

Environment:Quality Center, Test Director, QTP, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,Access

Max Hospital, New Delhi, India June 2003 – July 2005

Senior Business Analyst

Responsibilities:

• Preparation of credit applications, including new transactions, annual reviews, renewals, temporary extensions, and waivers and amendments

• Worked on EMR for Billing Hospital Management Applications

• Liaison with Risk for all credit-related issues

• Preparation of Global Limit Requests

• Worked on Mortgage Loans,Mortgage default payments and Credit Card billings

• Expertise with Reporting tools like SAP Business Objects and SAP Business Object universe

• Implemented SAP/PRA Tax module for different Vendors and Suppliers

• Worked on Deposits accounts like Deposits Checking accounts,Saving Accounts

• Implemented Sharepoint for Business Requirements for File system Access

• Review of documentation for syndicated transactions and for trading lines requests

• Preparation of Watch List reports and representation of the client relationship in Watch List meetings

• Requirement Gathering and testing done for E-commerce in Oracle applications

• Worked with store management and vendors to implement a new process

• Develop design solutions and write functional specifications

• Develop, test, implement, and maintain policies, procedures, work instructions, functional specifications, test scripts and training plans

• Develop product documentation and deliverables such User Manuals, Configurations Guides, Technical Architecture Guides, On-Line Help, Training Guides for oil companies

• Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents.

Environment:Quality Center, Test Director, QTP, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,Access

References will be available on request.

Contact this candidate