We provide IT Staff Augmentation Services!

Sap Bw/bi/bods/hana Consultant Resume

Houston, Tx

SUMMARY:

  • Achieve a challenging position in the area of Enterprise Resource Planning (SAP FI/CO, MM, SD BI - BW, HANA), where my analytical, academic and professional skills can be used to the benefit of the organization as well as my career growth
  • Have good working knowledge in using MS office (MS Word, Power Point and Excel).
  • Ability to work with Accounting Software like QuickBooks, Quicken and Peachtree
  • Have good team spirit, goal oriented and high interpersonal skills

TECHNICAL SKILLS:

Data Warehouse: SAP BW 3.5, 3.1C and SAP BI 7.0, BW 7.3 & BW 7.4ERP: SAP ECC 6.0, R/3 4.6C/ 4.6B/ 4.5B

Programming Languages: C, C++,ABAP

OLAP reporting tools: SAP Business Explorer (BEx) Analyzer, BEx Browser,, BOBI.

Reporting: SAP Business Objects (Crystal Reports, webi & Dashboards), Lumira

Data base: Oracle 9i, MS Access, SAP HANA SPS 09/10 1.x

Operating Systems: Windows 95/98/2000/XP and Windows/NT

Other Tools: Visio, MS-Office

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX,

SAP BW/BI/BODS/HANA Consultant

Responsibilities:

  • Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer.
  • Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
  • Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
  • Designed and build of BW object and business object report and resolved defects.
  • Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
  • Worked on Generic Extractors to meet the reporting requirement.
  • Extracted data from the LO Cockpit from source system.
  • Integrated BO with SAP ECC and SAP BI 7.0 to build Universes.
  • Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies .
  • Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based )
  • Involved working with content models, attributes and measures, hierarchies.
  • Worked in the BODS 4.2 for ETL Extraction, Transformation Loading data from different source system.
  • Configured the data services to connect the sap R/3, BI and CRM.
  • Created job, work flow and Data flow.
  • Worked on the Data Quality, Address cleanse transformations for cleansing the Data.
  • Created reports to evaluate open items by due date for accounts receivable through BEX Analyzer.
  • Developed Reports using Query Designer, BEX Analyzer, WEB, Lumira and IDT.
  • Created and Maintained Universes on OLAP Databases. Created Universe Pre-defined filters, Dimension objects and calculated measures in OLAP universe.
  • Worked on deployment of WEBI reports.
  • Involved in using job sever in creation of batch jobs and also involved in performance tuning at source, transformation, and target level.
  • Exported the universe to the repository to making resources available to the users.

Confidential, Houston TX

SAP FI/CO Functional consultant

Responsibilities:

  • Analyzing the existing system for As Is study gathered functional requirements through user workshops, gap analysis for filling the gaps between exact and legacy systems, and closed the gaps by providing appropriate solutions.
  • Configured all Business Transactions for Accounts Receivable, and Accounts Payable, including the Payment Program Configuration and Automatic Check Payment Advice and Payment Analysis Printing, clearing of Vendor and Customer Open Items, Bank Master Data, House Banks for Payment Program, Credit Management, Periodic Processing, and Correspondence.
  • Setting up House Banks, Lockbox accounts, and re-defining parameters for partial payment clearing.
  • Configured new Dunning Procedures, Interest Calculation and Customer Statements.
  • Worked with other functional teams to ensure that account determination met all requirements on both an account and a field status level.
  • Worked closely with SD for Cross Modular financial integration with Accounts Receivable.

Confidential Houston TX

SAP FI-AP, AR, MM

Responsibilities:

  • Configured and maintained Chart of Accounts, customized Account Groups, Field Status Groups, Posting Keys, Document Types, Number Ranges, Fiscal Year Variants, Posting Periods and created New GL Account master records.
  • Defined posting period variant, open and close posting period, document number ranges, document types, tolerance ranges, line item controls.
  • Work on Customer/Vendor Master Records.
  • Create Tolerance Limits as per business requirement for Over Payments and Under Payments, Reason Codes in Customer Accounts.
  • Calculate Interest and Payment Terms as per Customers Needs, Check Void Reasons, and Payment Advices.
  • Maintain Automatic Payment Program, Check Management, GL Account Assignments, Clearing, GR/IR, and Down Payment.
  • Provided configuration support in MM Integration for Account Determination, Material Movement Setup.
  • Working on material management team, assist to create purchase order, purchase requisition and requisition for quotation.
  • Work on Customer/Vendor Master Records.
  • Create NCT for NONC material on SAP.
  • Working on material management team, assist to create purchase order, purchase requisition and requisition for quotation.
  • Assembled the computer and nodes.
  • Tested the units and parts to make sure all the units/parts working properly.
  • Extensive work in Transfer Requests, Transfer Orders, Stock Movements & Put away Strategy.
  • Scrap inventory and analysis of causes/reasons leading to reduced scrap percentages.
  • Cycle counting and analysis of reasons for discrepancies. Implemented changes to procedures

Confidential, Houston TX

Tax Associate

Responsibilities:

  • Check data input or verify totals on forms prepared by others to detect errors in arithmetic, data entry, and procedures.
  • Compute taxes owed or overpaid, and complete entries on forms, following tax form instructions and tax tables.
  • Interview clients to obtain additional information on taxable income and deductible expenses and allowances.
  • Prepare and assist in preparing simple to complex tax returns for individuals or small businesses.
  • Review financial records such as income statements and documentation of expenditures in order to determine forms needed to prepare tax returns.
  • Use all appropriate adjustments, deductions, and credits to keep clients' taxes to a minimum.
  • Calculate form preparation fees according to return complexity and processing time required.
  • Consult tax law handbooks and bulletins in order to determine procedures for preparation of atypical returns.
  • Furnish taxpayers with sufficient information and advice in order to ensure correct tax form completion.

Confidential, Houston TX

Supervisor

Responsibilities:

  • Prepared financial reports and statements, and oversaw day-to - day activities of the accounts payable/ receivable department.
  • Maintain policies and structure of all company procedures required for startup company.
  • Reconciled financial discrepancies by collecting and analyzing account information.
  • Complete and maintain accounts payables and accounts receivable.

Confidential, New Orleans LA

Accounts Assistant

Responsibilities:

  • Make entries of the financial transactions by compiling and analyzing account information.
  • File and maintain a record of various supporting documents sent and received by the organization for reconciliation purposes
  • Receive sales and purchase reports and note the amount of sales / purchase returns by recording the corresponding entries. Also, compute the amount of goods in stock and add it to the assets accounts
  • Prepare and send notices to debtors for remittance of bills.
  • Assist in designing and implementing internal budget control measures and send report about its effectiveness.

Confidential

Accounts Manager

Responsibilities:

  • Recorded Business Transaction, Prepared Balance Sheet, Income Statement, Control Merchandise Inventory, Record Account Payable, Account Receivable and Handle variety of Additional accounting challenges.
  • Handled collections of Aged Accounts Receivable and Coordinated Collections and Payments to maximize Holding Period.
  • Prepared requisition for Overpayment Refund Checks. Investigated Premium Posting Errors.
  • Prepared Quarterly Reports. Prepared Bank Reconciliation Statement.

Confidential

Accounts Manager

Responsibilities:

  • Examined and verified record of financial statement, inventories, tenders, and quotations.
  • Verified the accuracy of accounting procedures and related regulations.
  • Prepared reports of financial status of specific data.
  • Analyzed deficiencies in control and detection of errors.
  • Implemented transaction from paper to a fully integrated computer accounting system.
  • Managed accounting department of 4 people, regularly set and met productivity and quality control goals, created and refined a wide variety of quarterly accounting reports.

Confidential

Accounts Manager

Responsibilities:

  • Controlled and detected of errors in business transaction. Prepared balance sheet, profit and loss accounts, control stock inventory, record account payable, account receivable and handle variety of additional accounting challenges.
  • Managed collections of accounts receivable and coordinated collection and payments to maximize holding period.
  • Prepared requisition for overpayment refund checks. Investigated premium posting errors.
  • Prepared quarterly reports and bank reconciliation statement.

Confidential

Audit Trainee

Responsibilities:

  • Planned, performed and documented audits according to the internal audit standards (IAS).
  • Evaluated Generally accepted accounting principle (GAAP) to determine their efficiency and effectiveness.
  • During the tenure of my training period I have had an opportunity to finalize the audit of governmental organization, Manufacturing, Construction, Hotel Industry, and Investment Banking, Shipping services, Colleges and Telecommunication companies.
  • Formed basic structure of accounting, auditing business income, income statement, bank balance, balance sheet, merchandise inventory, accounts payable, accounts receivable, long term receivable affiliated, product liability, warranties, plant assets and related expenses, current liabilities, retained earnings, dividends, treasury stocks, commitment, contingencies, shareholders, long terms liabilities and short terms liabilities.
  • Ensured all steps of the audit program were completed.

Hire Now