Resume
Sushmita Goswami
379 W SIDE DR #102,
Gaithersburg, MD
Zip Code - 20878
E-Mail - [email protected]
[email protected]
Mob - 7373338223.
Career Objective:-
Establish a challenging career utilizing my inherent qualities, individual excellence, knowledge base & skills for
betterment of organization as well as my future growth keeping company’s interest in forefront.
Total Professional Experience: - 7+ Years
Professional Qualification:-
Professional Certification:-
Academic Qualification:-
Professional Summary:-
SPATIAL BUSINESS INTELLIGENCE CENTER OF EXCELLENCE
DESIGNATION : - Geospatial Data Analyst
Tenure : - April 2016 to June 2017
Job Responsibility:-
PEPSICO – (India Beverages SOMU)
DESIGNATION : - Accounts Executive
Tenure : - Dec. 2010 to May 2014
Job Responsibility:-
Leading two members team for achieving day 2 day activities, coordinate and follow-up with IBM team for getting the outsourced work done on time and coordinating with business unit and marketing unit to ensure business compliances.
Base Business
COLLABRANT INCUBATORS PVT. LTD.
DESIGNATION : - Finance Executive
Tenure : - Nov. 2008 to Sept. 2009
Job Responsibility:-
Assisted the Director Finance and got involved in various Corporate Finance Related Activities of the Company
Exposure of USGAAP and Analysis of Company Financials. Also as a special case, was rewarded by the management for my performance.
ITC LIMITED
DESIGNATION : - Associate (Accounts Dept.)
Tenure : - Oct 2007 to May 2008.
Job Responsibility:–
Involved in the following activities -
Achievement:- Had developed my skills on working with SAP R/3 as end user.
OVERNITE EXPRESS LIMITED
DESIGNATION: - Credit Control Executive (Accounts Dept.)
Tenure : - July 2006 to Aug 2007
Job Responsibility :–
M36 - Other charges collected, M45 - Low rate booking, 6B - Control of unused AWB,
M05 - Market outstanding report.
Achievement :-
Achieved Highest Collection of Market Outstanding Target and been rewarded for the same..
Establish a challenging career utilizing my inherent qualities, individual excellence, knowledge base & skills for
betterment of organization as well as my future growth keeping company’s interest in forefront.
Total Professional Experience: - 7+ Years
Professional Qualification:-
- MSCIS (Master of Science in computer Information Systems) from American College of Commerce and Technology, Virginia.
- M.B.E (Masters in Business Economics) from Institute for Excellence in Higher Education, (I.E.H.E)
Professional Certification:-
- Certification in Spatial Business Intelligence and GIS from ACCT, VA
- Certification of Geo Apps from Udemy (Sept2016).
- Certification of Location Advantage from Udemy (Oct 2016).
- Certification of Earth Imagery at Work from Udemy (Mar 2017).
- Certified Finance Professional in Project Finance from IIBF-IFMR.
Academic Qualification:-
- B.Com with Computer from Shri Satya Sai College, Bhopal
- Higher secondary from St. Joseph’s Convent, Bhopal .
Professional Summary:-
SPATIAL BUSINESS INTELLIGENCE CENTER OF EXCELLENCE
DESIGNATION : - Geospatial Data Analyst
Tenure : - April 2016 to June 2017
Job Responsibility:-
- Completed independent research and scientific analysis on a various projects, utilizing GIS technology and spatial data analysis.
- Created story Maps & participated in GIS Day poster competition.
- Worked with ArcGIS PRO environment (Joined tables, created a calculation field, symbolized using graduated colors, geocoded location data, and used geoprocessing tools to analyze vector & raster data.)
- Worked on 3-D Analysis, Python Scripting and Business Analysis Applications.
- Worked on Network Analysis (Edges and Functions), Raster Analysis and Spatial Analysis (Created feature classes, added fields & domains, worked with metadata, created a web map).
- Designed thematic mapping, chloropleth, heat maps, dot density and geocoded maps.
- Applied spatial queries in geospatial analysis using-Boolean Operators and Spatial Operators.
- Applied spatial joins (Simple Join, Summarized Join and Distance Join).
- Created maps using spatial analysis functions (Clip, Append, Merge, Buffer and Dissolve).
- Applied Map Overlay with attributes (Union and Intersect) and created geoprocessing programs using Model builder. Projects worked on –
- Prediction of 2016 Presidential Election.
- Starting a Small Scale Business in Fairfax County, VA
- Study on Arkansas Obesity.
- Air pollution in Ulaanbaatar, Mongolia.
- ACCT GIS Center
PEPSICO – (India Beverages SOMU)
DESIGNATION : - Accounts Executive
Tenure : - Dec. 2010 to May 2014
Job Responsibility:-
Leading two members team for achieving day 2 day activities, coordinate and follow-up with IBM team for getting the outsourced work done on time and coordinating with business unit and marketing unit to ensure business compliances.
Base Business
- Compliance of following month closing activities (Closing all D&A, G&A, MEM and S&D warehouse provisions by 1st of every month & ensuring provision entries are passed on time)
- Ensuring collation of S&D Master data by 7th of every month.
- Supervising (FPR) for the Bank processes by ensuring -
- All open item in bank reconciliation are addressed in the subsequent months
- All Bank Guarantee drawn in companies favor are renewed within the time limit to avoid AR exposure.
- Managing Fixed costs to come in on AOP (Regular monitoring and review of S&D, G&A and preparing G&A MIS monthly)
- Ensuring Sox and SOP compliances on Vendor and Distributor management (S2C/FA/P2P) applicable to Unit
- Coordinate (FPR) with Auditors & MU office for completion of Indian & Statutory Audits
- Assist unit/UM in AOP – Volume/GR/ST/ED/ROI working
- Ensuring implementation of remediation plan for Internal Audit observations by Q1 and doing a review on sustainability in H2.
- Drive F&F of all closed distributors- calendrise
- Monthly Review of Upfront account and highlighting volume gap on the same by 4th of every month.
- Sharing of GR by Territory on a weekly basis and impact of same on a/c of Mix.
- Monthly review of invoice discount and DB/market audits.
- Developed understanding of Balance Sheet Review & worked on its schedules.
- Good exposer and command on SAP Financial Modules & S&D systems & processes.
- Got PepsiCo spot award for my performance.
- Handled Bangalore unit alone for couple of months during the transition period of finance manager & asst. manager.
COLLABRANT INCUBATORS PVT. LTD.
DESIGNATION : - Finance Executive
Tenure : - Nov. 2008 to Sept. 2009
Job Responsibility:-
Assisted the Director Finance and got involved in various Corporate Finance Related Activities of the Company
- Preparation of Financial Plan.
- Management Information System (MIS).
- Costing and Variance Analysis for Various Clients of Collabrant.
- Raising Short term loans.
- Translation of IFRS accounts to USGAAP for some of the overseas Private Equity and Venture Capital Funds.
- Ratio & Variance Analysis.
- Projected Profitability Analysis.
- Analysis of financials Budget V/s Actual.
Exposure of USGAAP and Analysis of Company Financials. Also as a special case, was rewarded by the management for my performance.
ITC LIMITED
DESIGNATION : - Associate (Accounts Dept.)
Tenure : - Oct 2007 to May 2008.
Job Responsibility:–
Involved in the following activities -
- Banking operations (Related to HDFC, SBI, SBI net Banking & RTGS (through SAP YFF67))
- Freight expenses (Monitor K-3 Shipments, check truck load (through SAP YRV 124) & transportation cost (through SAP YRV126), prepare Under load and Overload Sheet and compared cost.)
- Cash forecasting (By moving average method, record was maintained in portal–SAP enterprise portal 6.0)
- Issuance of F-Form (Issue forms, tally stock from go down files and system records (through SAP YRM313)).
- Blocking and unblocking of stocks (Used MMBE in SAP to view stock available for creating delivery orders and
- Bank charges computation
- Onward freight expenses
- Traveling expenses, Taxi bills & Handling charges
- Closure document preparation & IRR Report
- D&D Certificate updation
- Reports send and referred on regular basis
- Send delivery report after creating delivery orders on daily basis. (through MCTA)
- Update banking status report on monthly basis. (through YRF89, YRF125)
- Refer to ledger balance and turnover of WD’s. (through YSFF08 and YRV12)
- Update and send money requirement sheet.
- Remittance entries (Done expense recovery entries, advance recovery entries, Transit flat entries and vendor
- Create delivery orders (Reliance & Choupal delivery orders, Ideal and Manual delivery orders, TPVS (through
- Preparation of Vouchers (Prepare voucher by following SAP Code–YF89-Enter bill register, YF30-Invoicing through MIRO (When purchase order created), Invoicing through F43/F90(both G/L items and
Achievement:- Had developed my skills on working with SAP R/3 as end user.
OVERNITE EXPRESS LIMITED
DESIGNATION: - Credit Control Executive (Accounts Dept.)
Tenure : - July 2006 to Aug 2007
Job Responsibility :–
- Managing Credit of whole M.P. & Chattisgarh.
- Looking after MIS Reports and send it’s final status to corporate office monthly :-
M36 - Other charges collected, M45 - Low rate booking, 6B - Control of unused AWB,
M05 - Market outstanding report.
- Accounting Entries :-
Achievement :-
Achieved Highest Collection of Market Outstanding Target and been rewarded for the same..
References-
1) Pranshu Goswami,
Sr. Test Lead, Gaithersburg, MD.
Mob - 5129880982.
2) Shubhashish Mukherjee,
Scientist, Birmingham, Alabama.
Mob - 2566178232.
Declaration:-
I hereby declare that, the above mentioned information is correct to the best of my knowledge.