Uploaded File
add photo
Ashwini
Ashwini.s.kulkarni@gmail.com
719-360-9730
858 Salmon Pond Way
Colorado Springs, CO 80921
Business Analyst/Application Manager
10 years experience W2
0
Recommendations
Average rating
33
Profile views
Summary

  • +9 years of IT experience in various phases of software development including Requirement Analysis & System Design, Project Planning, Data Modelling, Implementation, and Documentation.
  • 4 years of experience working as a Business Application Manager.
  • Worked as a Business Analyst in the Finance domain and HRIS (Human Resources Information Systems).
  • Experience in Data mining and Data Visualization. Built various reports for business management using tools like Optymyze, SSRS, Logi, and Qlik.
  • Implemented Optymyze (SaaS product) for automating the Order Management system (OMS) and Invoicing Processes.
  • Migrated data from non-relational structures like Lotus Notes to SQL and Oracle.
  • Experience in developing applications using JavaScript, MSSQL, Rest APIs, HTML, CSS, XML, XSL, XSLT, PowerShell Scripts, and Java.
  • Integrated Optymyze Product with third-party tools like Intacct, Xero, Concur, and Timely.
  • Implemented Waterfall and Scrum methodologies (Agile) for Project management.
  • Self-Learned Android Development and published an application on Google Play Store.

Experience
Android Developer
Information Technology
Aug 2019 - present

Project: Arithmetic Genius Math Lite

  • Self-Learned Android Development and published an application on Google Play Store. This is a free app to practice Arithmetic Math skills for kids.
  • App Link: https://play.google.com/store/apps/details?id=com.syslogics.arithmeticgeniusmathlite

Achievements:

  • Self-Learned concepts of Android SDK
  • Developed a strong understanding of Object-Oriented Programming.
  • Developed expertise in Java and XML
  • Implemented banner and Interstitial ads through Google Ad-Mob
  • Working on a few other ideas for Android Projects

Skills: Java, Android SDK, XML, Ad-Mob

Android Android SDK Java XML
Remove Skill
Business Application Manager
Information Technology
Nov 2014 - Jul 2019
Philadelphia, PA

Jun 2016 to Jul 2019

Project: Financial Reporting and HRIS reporting

  • Analysed requirements and documented them using UX Design, Share-Point, MSOffice.
  • Automated Financial reporting processes using complex SQL queries and Optymyze products.
  • Analysed and Automated reports like Revenue Report, Future Forecast, Cash Balance, ARR (Annual Recurring Revenue), and Cash Collection.
  • Built Financial reporting protypes in tools like SSRS, Qlik, Tableau to evaluate and select the best suitable tool for the company.
  • Responsible for Data Visualization with SSRM product in Optymyze for various Financial reports.
  • Prepared various reports for Due Diligence process as part of the investor meetings using SSRS, MS Excel, and Optymyze.
  • Integrated Optymyze with Concur for expense data processing using REST APIs.
  • Integrated Optymyze with “ExchangeRateAPI” for Currency Conversion and calculating Exchange Gain/Loss for Foreign Currency clients.
  • Integrated Optymyze with Xero for posting invoices and prepare AP (Accounts Payable), JE (Journal Entry) files.
  • Integrated Optymyze with Microsoft Teams via PowerShell Script to post AR collection information on MS Teams channel.
  • Worked as a Project Manager, managed offshore team, evaluated their performance, managed the hiring process, and trained new recruits.
  • Participated in configuration of Optymyze for sales compensation for internal Sales team. Researched on Territory and Quota Management

Nov 2014 to May 2016

Project: Billing Process Automation

  • Learned the workflow of Financial data from Order to Cash.
  • Analyzed requirements and documented them using MS Office, SharePoint, and UX Design.
  • Data Modelling for mapping data in the non-relational database (Lotus Notes) to the relational database in Optymyze (Oracle).
  • Presented ideas to Finance team for process improvements.
  • Configured processes for Invoice schedules and Revenue allocations.
  • Set up Logi for automating the invoice PDF generation process.
  • Set up PowerShell script for automating the invoice emailing process.
  • Migrated historical data in the Lotus Notes server to the data repository of Optymyze.
  • Worked as a Project Manager, managed offshore team, evaluated their performance, managed the hiring process, and trained new recruits.

Achievements:

  • Saved time and efforts up to 90% in Financial reports processing.
  • Improved data quality of reports and achieved the accuracy of 100%.
  • Worked Remotely with offshore team, Stakeholders in Philadelphia, and CFO in California.
  • Developed a strong understanding of various financial reports.
  • Developed expertise in Project Management with an Agile approach.
  • Automated the billing process to save time and manual efforts by 80%.
  • Developed expertise in Logi and PowerShell Script.
  • Developed a strong aptitude in data modeling and system design.
  • Developed expertise in REST APIs, Java, MS Excel.
  • Developed a strong aptitude in data mining and data visualization.
  • Developed expertise in reporting tools Qlik, SSRS, and Tableau.

Skills: Project Management, Agile Methodology, Lotus notes, Optymyze, MS Excel, Logi, PowerShell Script, Web Services, REST APIs, SSRS, Qlik, Tableau

SaaS Microsoft Excel Project Management SQL SSRS Agile Methodology Stakeholder Engagement MS SharePoint System Design WebServices Tableau REST PowerShell Oracle Lotus Notes Java Data Visualization Data Modeling Data Mining
Remove Skill
Senior Business Application Developer
Information Technology
Feb 2006 - Feb 2008
  • Developed the web application to manage the recruitment process from the submission of job profiles till hiring candidates.
  • Developed the Time-off application to handle leave balance and pay-outs to employees.
  • Developed the Time-tracking application to record time spent against various tasks.
  • Designed and developed the Client Evaluation system.
  • Maintained the Employee survey and Travel-expense tracking applications.
  • Led the team to build new applications and maintain existing applications.
  • Provided technical support as and when needed.
  • Automated the Invoice emailing process using Lotus notes.
  • Maintained the backup repository for HR and Finance data in the SQL server.
  • Maintained reports in the SQL server with complex queries on backed up data.
  • Integrated the Support site system (Developed in Lotus Notes) with JIRA (Issue Tracking Tool).
  • Developed the process for Invoice PDF generation using XML-XSL-XSLT.
  • Guided team to build reports in Fusion Charts and Jasper Reports.

Achievements:

  • Developed strong leadership skills and Project management expertise.
  • Developed an understanding of HRIS Functions and Finance Operations.
  • Developed extensive technical skills in Lotus notes Web Applications.
  • Mastered skills in XML-XSL, XSLT in PDF generation which saved Invoice-mailing cost by 90%.
  • Developed expertise in DTS and SQL queries which reduced reporting time by 80%.
  • Received Reward and Recognition from the customer (HR department) for Ownership shown in immediate response and fix-up for Survey application.

Skills: Lotus notes, XML, XSL, SQL, Fusion Chart, Jasper Reports

Jasper Reports Java JavaScript Project Management Salesforce SQL SQL Server XML XSL XSLT Lotus Notes Database Backups
Remove Skill
Software Developer
Banking/Financial
Dec 2003 - Jan 2006
  • Maintained web application that was designed to enter deals information.
  • Automated the process for extracting data on a large scale.
  • Maintained the user interface for dashboards.
  • Worked on changes in reports to view the current acquisition pipeline.
  • Provided Manual Testing, Unit Testing, Integrated Testing.
  • Completed training in Project Management.

Achievements:

  • Developed technical skills in Lotus notes and MS Excel.
  • Developed various testing skills.
  • Completed Six Sigma Green Belt Certification.
  • Automated data extraction process which resulted in time-saving by 90%.
  • Completed training for “Project Leadership”.

Skills: Lotus Notes, MS Excel, Software Testing

Project Management Lotus Notes Manual Testing Microsoft Excel Software Testing Unit Testing
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Electronics
K. J. Somaiya Institute Of Engineering and Information Technology 2003
Record has not been verified.
Certifications
Sun Java Certified Professional
Six Sigma Green Belt Certified
Skills
Lotus Notes
2019
8
Project Management
2019
8
Java
2021
7
Microsoft Excel
2019
6
SQL
2019
6
Agile Methodology
2019
4
Data Mining
2019
4
Data Modeling
2019
4
Data Visualization
2019
4
MS SharePoint
2019
4
Oracle
2019
4
PowerShell
2019
4
REST
2019
4
SaaS
2019
4
SSRS
2019
4
Stakeholder Engagement
2019
4
System Design
2019
4
Tableau
2019
4
WebServices
2019
4
Database Backups
2008
2
Jasper Reports
2008
2
JavaScript
2008
2
Manual Testing
2006
2
Salesforce
2008
2
Software Testing
2006
2
SQL Server
2008
2
Unit Testing
2006
2
XML
2021
2
XSL
2008
2
XSLT
2008
2
Auditing
2016
1
Business Analysis
2020
1
Contract Management
2016
1
Process Improvement
2016
1
Analysis
0
1
Android
2021
1
Android SDK
2021
1
CSS
0
1
HTML
0
1
Project Planning
0
1
Scrum
0
1
Waterfall
0
1