Manager Sql Server

Jyoti Bastola

*** ****** ****.*******.**.***** • 832-***-**** • *****.*******@*****.***

• Performance Driven, Self Starter and Creative Thinker with proven record of leadership and team-work in initiating,

managing and delivering challenging dead-line driven assignments.

• Highly Analytical, Detail-oriented individual with natural problem-solving skills.

• Four years of Professional experience across many areas within the field of accounting and financial operations.

EDUCATION

Truman State University, Kirksville, Missouri

• Successfully passed all CPA tests, pursuing license May 2009 -

Nov 2009

• Master’s Degree in Accounting (GPA: 3.9/4.0) Aug 2008 – Dec 2009

• Bachelor of Science in Accounting and Finance (Major GPA: 3.5/4.0) Jan 2003 - May 2007

EXPERIENCE

Senior Accountant Jan 2010 - Present

Pinnacle Technical Resources, Inc. Dallas, Texas

• Currently responsible for managing all personnel and processes in Accounts Receivable and Accounts Payable.

• Perform complex data analyses, forecasting and providing financial reports to senior and executive management.

• Complete audits of several accounts as well as inter-company transactions and closing accounting periods monthly,

quarterly and yearly.

• Create financial statements in accordance with U.S. GAAP and presenting to senior management and executives.

• Work with external auditors as well bank auditors in year-end and interim audit, providing requested documentation

and researching items in question.

• Collaborate with upper management in decision-making; initiating, executing and reviewing process improvements;

hiring, training and mentoring new team members.

• Lead the team in transitioning several new multi-million dollar client projects by managing the financial and

operational aspects of the business and ensuring timely delivery of promised results, regardless of any challenges.

• Act as the primary contact person for questions, issues and problem solving in and across departments.

Accountant Jan 2009 – Dec

2009

Pinnacle Technical Resources, Inc. Dallas, Texas

• Observed handling of accounting related processes, made recommendations to director on increasing efficiency and

automating processes in order to reduce human error.

• Self-started several auditing processes in A/R and A/P and Payroll such as ones testing for completeness, vouching

and accuracy of revenue and cost recognition.

• Created audit processes to test for compliance with client-supplier contractual terms as well as compliance with

Federal and State rules.

• Initiated and improved Treasury management process by generating cash flow forecasts based on historical data and

future expectations for the bank-loan management process.

• Generated cost and time savings by automating several processes across finance and operation departments by

building Excel Spreadsheets, Access database with VB programming and writing queries and reports in SQL server.

• Co-led development of company’s proprietary software in expense-reimbursement module by

providing/researching/testing and implementing user requirements on the expense reimbursement portal.

• Presented and trained Accounting and Operations team members in SQL server reporting, using Microsoft Access

DB and Excel spreadsheets.

• Processed payments to suppliers, resolved vendor related questions and performed audits of several accounts.

Junior Accountant May 2007 – Dec 2008

Pinnacle Technical Resources, Inc. Dallas, Texas

• Progressive experience from Payroll function to Accounts Receivable to Accounts Payable function.

• Executed payroll for 1100+ consultants, conducted payroll audits and resolved payroll-related issues.

• Invoiced and managed successful collection efforts on multi-million dollar clients and projects.

• Booked payments from clients, performed payment reconciliation, answered billing/payment questions and reported

to management.

• Booked invoices and vouchers and created journal entries under the supervision of accounting manager.

Budget Manager of International Student Office Aug 2005 - May 2007

Truman State University, Kirksville, Missouri

• Handled purchase orders and receiving reports, requested payments and made deposits for the office.

• Assisted in closing the accounting period by providing necessary documentation and submitting monthly reports to the

Accounting office.

• Tracked office expenses and allocation/re-allocation of funds.

• Assisted the Department Head in creating budget for the next fiscal period by analyzing historic data.

ACTIVITIES

President of International Club, Truman State University May 2005 - May 2006

• Planned and organized campus events such as the International Dinner and Idol, recognized as best events on campus.

• Led an executive board of eight and a group of 50+ international students in meetings and addressed related issues.

• Presented organizational events to the School Board of Directors in order to raise funds.

• Headed up several events on campus in efforts to promote diversity.

Campus and Faculty Relations Chair of Delta Sigma Pi, Truman State University May 2005 - May 2006

• Promoted professional and social activities around campus through advertising efforts.

• Improved faculty relations with the chapter by organizing faculty luncheons and breakfasts.

• Organized round-table discussions on business issues.

• Submitted articles to the fraternity’s newsletter and business division newsletter.

HONORS

• Outstanding Performance Award at Pinnacle for surpassing client delivery expectations

2009

• Beta Gamma Sigma Honor Fraternity Member for outstanding scholastic records

2009

•

• Outstanding Service Employee Award at Pinnacle Technical Resources, Inc.

2008

• Who’s Who Recognition for academic achievement, character, leadership and services

2007

• Excellence in Diversity Award for various leadership roles and events throughout the year

2006

• Vice President’s Honorary Scholarship for outstanding academic record at Truman State University

2003-2006

• International Excellence Scholarship for academic records and involvement in school

2003-2004

COMPUTER SKILLS

• Very Proficient in Microsoft Excel, Intermediate level with Access with good exposure to Visual Basic modeling.

• Proficient in QuickBooks and Microsoft Solomon.

• Self taught in SQL server reporting language, ability to write complex queries.

•

Contact this candidate