As a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping and Translating Requirements into Specifications. Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables), Proficient in Microsoft Word, Power Point, Access. I have also worked as an Accounts payable/Payroll Clerk in Luggage Industries. Process and Verify all the Vendor Invoices and Credit Memo. Filed Monthly Sales Tax and Property Tax includes Business License for each location. Also Process all the payroll related documents quarterly. I also have processed high volumes of insurance documents. I had extensive experience in Applied Insurance System. I am an experienced, motivated and hardworking individual open for any position offering challenges. My developed strengths include accuracy and attention to detail. Strong work standards and the ability to work well within a team environment with Positive attitude.
Quick Books, MAS 200, Basic Sage 50
Billing, Credit, Matching and Coding Invoices
Filing Systems for Check, Invoice and Annual Reports
Month end closing. XP/Vista, Windows 7 and Windows 8
Excel, Word, Power Point, Outlook and Quick Books
SQL, SharePoint, Microsoft Visio, Agile, UML, BRD, FRD, Use Case
Typing: 45wpm, 10 key by touch
IT proficient (Hardware installation, Programming)
Business Analyst03/2016 to 04/2016Best Buy Corporation Vastek GroupRichfield, MN
Working with business stake holder to better understand their needs and present solutions using structured SDLC approach.
Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
Documented the user requirements Analyzed and prioritized them and converted them as system requirements.
Analyzed data and created class diagrams and ER diagrams for designing databases.
Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
Created Mock-up forms in MS word for better visualization and understanding of the software solution.
Create and finalize Data Dictionary to be used by BA and developers teams.
Create Use Cases, prepare User Stories to be used by BRD, FRD.
HR / Payroll Clerk09/2009 to 03/2016Peninsula Luggage IncWalnut, CA
Process Monthly Sales Tax and Property Tax for more than 13 States.
Pay monthly and quarterly sales and use tax returns for states.
Apply Monthly sales transaction on various state approved website.
Manage tax calendar and ensure that deadlines are complied with.
Prepare and maintain tax records.
Process bi-weekly multi-state payroll for approx.
Update, collect and import hours on electronic time keeping system.
Make all necessary changes to employee records.
Process new hires, terminations, and all employee data changes include vacation hours, commissions, bonus pay, child support and garnishments.
Handle Employment Verifications.
Maintain Employee files include employee records and personal data.
Also handle other HR and Payroll related issues.
Perform various special projects as assigned includes Workers Compensation, Liability Insurance and Chargeback for more than 31 store.
Verify and monitor payments and expenditure.
Reconcile vendors account daily basis.
All the invoice and memos reviewed and matched with packing slip, researched and resolved invoice discrepancy with the store.
Also request for POD to various trucking Company.
Maintain and update vendors / suppliers files.
Also performs month end account analysis.
Review any outstanding Invoices for Payments monthly basis.
Maintained and monitored all the Accounts payable issues.
Customer Accounting Support08/2005 to 02/2009Nationwide InsuranceYorba Linda, CA
Eastwood Insurance purchase by Nationwide in 2007 Worked on commission statements, balances and reconciled financial data.
Also process financial reports.
Processed payments and check requests for accounts payable.
Resolved issues concerning policies, procedures and endorsements.
In-depth knowledge of insurance policies, procedures and strategies.
Reviewed all financial data for completeness and mathematical accuracy.
Assisted supervisor with work assignments and reporting absence/vacation.
Coordinated other associates throughout the department and checked their work in absence of supervisor.
Assist special projects and reports as requested by controller.
Support month-end close process.
Also helped in collections and underwriting departments as needed.
Sales Executive & Operation04/2001 to 06/2005Federal India Trading CompanyAhmedabad, India, Gujarat
Worked with CPA on companys final balance sheets and auditing.
Worked on daily banking and share correspondence transactions.
Added to the database and created spread sheets and reports utilizing in Word and Excel.
Prepared for year-end processing and sent to auditors.
Also worked as a sales representative, dealing in Laboratory Testing equipment.
Marketing the products throughout the country.
Demonstrated the products during the exhibition throughout the country.
Bachelor of Science: Business Administration2012DeVry UniversityPomona, CABusiness Administration
Bachelor of Science: Accounting / Auditing2004Gujarat UniversityAhmedabad, IndiaAccounting / Auditing
10 key by touch, Accounting, Accounts payable, Agile, approach, auditing, BA, balance sheets, banking, Basic, Billing, bi, Hardware installation, controller, CPA, Credit, Data Dictionary, databases, database, designing, Filing, financial, financial reports, forms, HR, Insurance, Laboratory Testing, Marketing, Excel, Outlook, Power Point, SharePoint, Microsoft Visio, Windows 7, Windows 8, Word, MS word, Month end closing, Payroll, policies, Coding, Programming, Quick Books, reporting, Sage, Sales, SDLC, spread sheets, SQL, Stories, structured, supervisor, Tax, tax returns, Typing, 45wpm, underwriting, UML, Vista, website, year-end, Annual Reports