SUMMARY:

• Over 5+ years of professional consulting experience in SAP FICO.& QA Tester
• 3+ years of extensive experience in Quality Assurance testing of SQL, Data, ETL and Business Intelligence processes, Web Based and Client/Server applications.
• Excellent knowledge in implementation of different QA methodologies/policies, strategies and plans in all stages of SDLC.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process. Experience performing all types of testing like smoke, system, integration, regression, and User acceptance retesting.
• Extensive experience performing Root cause analysis on defects and conducting review meetings on defects for open defects.
• Excellent knowledge of defect management and tracking using Quality Center, JIRA and Mission Control Tested various ETL processes developed using ETL tools like Informatica Powercenter, Ab Initio and Datastage.
• 2+ years of professional consulting experience in SAP FICO. Involved in two full life cycle implementation, Upgrade and Production support projects
• Involved in different phases of implementation like AS - IS study, FIT-GAP analysis, TO-BE process, Production support and End-user
• Expertise in configuration and customization of FI modules GL, AP, AR, AA and Travel Management
• Strong working knowledge in Controlling (CCA, IO, PCA, PA, PC) and Project Systems. Good knowledge in FSCM Collections and Dispute Management
• Good experience in cross-functional integration of FI with MM & SD modules with Procure to Pay and Order to Cash cycles
• Experienced in Development methodologies such as ASAP, SDLC, Agile and Waterfall.
• Extensively involved in translating business requirements into functional specifications for developing RICEFW objects
• Thorough understanding of SAP system from business process perspective. Ability to analyze the customer business requirements, needs and objectives and map them to SAP processes, solutions and products that are being implemented

EXPERIENCE:

Confidential, Madison, WI

Sr. QA Tester

Responsibilities:

• Review functional and design specifications to ensure full understanding of individual deliverables.
• Identify test requirements from specifications, map test case requirements and design test coverage plan.
• Develop, document and maintain functional test cases and other test artifacts like the test data, and data validation.
• Defects were tracked and prioritized using HP ALM/Quality Center and analyzed the variation between expected results and actual results.
• Developed complex SQL queries to verify the data loaded into the target tables. Validate the test data using MS access, TOAD, UNIX & MS Excel.
• Tested ETL mappings and worked in source to staging area to validate the Basel II multiple source system data with SQL queries.
• Involved in backend Data warehouse ETL testing with SQL, check the data integrity and referential integrity.
• Coordinated between offshore and onsite team and managed the entire project for testing needs.
• Debugged the SQL-Statements and stored procedures for various business scenarios. Performed extensive data validations against Data Warehouse.
• Logged and tracked defects on a release basis using HP ALM/Quality Center.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Performed transformation and data quality for various data feeds coming from different source systems.
• Tested reports developed by Business Objects Universes for both ad hoc and canned reporting
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Created test cases and tested Business Objects reports using HP Quality Center/ALM.
• Created complex SQL queries for data validation to verify the ETL mapping rules.
• Analyzed the Requirement Traceability Matrix, daily test status reports, weekly defects report, and risk analysis, including regular communications with the business team.
• Tested several reports developed in Business Objects.

Confidential, Minneapolis, MN

QA Tester

Responsibilities:

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM
• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Tested Informatica mappings, and the data from different sources whether it was formatted, Cleansed, summarized, aggregated, transformed and loaded into target database
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level. Prepared sample test data by inserting data into staging tables.
• Prepared all the test scenarios and shared across the team. Involved in testing all the reports that were generated through Business Objects.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend Datamart through SQL and also using excel for data comparison.
• Was involved in running the Informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP Quality Center for all the team members to review.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Confidential

SAP FICO Analyst

Responsibilities:

• Charged with reconciling aging reports and identifying gaps in payments using SAP journal entries.
• Collected $100,000+ in receivables outstanding for more than one year (80% of customers). Liaised with customers and shipping and billing departments to follow up on unsettled payments.
• Resolved AR disputes. In an instance when the customer had paid against the invoice, but the transaction was not posted by accounts payable as they lacked details. Traced back the order starting with the purchase order, shipping, delivery, receipt, bank account and accounts payable to identify the payment and credit it to the customer’s account to resolve the dispute.
• Matched purchase orders to quotes and allocated accounts to respective profits centers.
• Defined the Master Records of Cost Elements (primary and secondary).
• Cost Element Groups, and reconciliation ledger, Cost Centers, Cost Center Groups and Standard Hierarchy.
• Defined Order types to be able to create orders, assigned each order types to a number range and maintained status management, orders settlement, and settlement structure.
• Defined both basic reports and form reports for the business units by profit centers to analyze the profit at customer and product levels.

Confidential, South Carolina

SAP FICO Analyst

Responsibilities:

• Worked on open item accounts using SAP to reconcile and clear aging (>90 days old) pending accounts.
• Resolved AR disputes. Diligently followed up with the customers (sending mails, emails and making telephone calls) to ensure the traceability of all transactions, sales and dispatches resulting in collection of pending payments. Worked closely with other departments to gather details of the sales.
• Prepared and mailed invoices to customers in a timely manner.
• Supported Managing Director and Senior Controller by performing administrative tasks including filing, preparing and mailing letters, photocopying, receiving and making phone calls, arranging staff meetings.
• Customized (client specific) New General Ledger Accounting to perform parallel accounting, Document splitting, allocation, Accounts Receivables.
• Configured house banks, bank accounts, GL structure, posting rules for automatic assignment and automatic payment program (APP) configuration by Bank Chain Functionality.
• Involved in configuring Business Partners and Inter-Company transactions.
• Configured Lock Box accounts that are d in customer master records using BAI2 format and used invoices as a part of remittance information.
• Prepared test plans, test cases, test scenarios and executed all phases of Testing.