Data Analyst and IT Coordinator
Amazing Solar (Australia)
• Generating actionable insights, analytics and business intelligence reports from sales data to guide and support on
the sales process, performance and required improvements to managers and team leaders.
• Making presentable and analyzable data visualization using excel pivots, charts, BI tool tableau and with python using
libraries like pandas, matplotlib, seaborn, numpy.
• Used SQL to extract data sets from CRM and other sources and used Python to load that data sets to analyze and create
reports for employee performance and for management-level reporting.
• Worked with sales and marketing teams to understand analytical needs, identified KPIs and delivered insight/forecasts
to decision-makers based on sales trends.
• Used Python scripts/programs to integrate Gmail and NOCRM.io using zapier. Python program to extract, load and filter
data to pass on the next step in zapier.
• Managing GSuite business edition and IT System Integrations – ZOHO ONE (CRM, Lead management, Inventory, Books and
Finance, Team communication, analytics report, Team Drive, Business Automation and workflow).
Data/Business Analyst
Gami Publication (India)
• Transformed company's all paper-based data into digital format in IT system to increase the company's efficiency.
• Facilitate monthly meetings with distributors, retailers, sales and marketing, IT team to understand the market
problems and requirements to find a potential solution.
• Gather and confirm solution requirements by working with internal stakeholder and Sales Department to create business
models for individual distributors according to market need based on the regions and territory based on company data.
• Worked closely with IT team on a software development project for the automatic paper generating system for exams with
user login system.
• Introduced business workflow automation that reduced redundancy of work, enhanced the workflow and saved 50% IT work
time for an entire business.
• Managed company's website, database and all other software tools and suggested improvements if required.
Software Engineer Intern
CompIndia Technologies (India)
• Web Application Development with Database Integration using MySQL and MSSQL with ASP.Net framework 4.5 C# in Visual
Studio.
• CMS portal development for photography companies with multiple user login systems to manage company’s and their
customer’s profiles. Individual company admin can create their customer’s account and upload photos and videos for the
customer to access online.
• Build web services mobile app including android and iOS both in a way that customer can see their profile online as
well. Further, customer can select any professional image and can order it for photo frame printing.
• Worked on live project in a fast-paced agile environment to ensure delivery of project before deadline with high
quality.
• Prepared and deployed web services using C# in XML, JSON format for login systems in the web portal and mobile
application. Handled web services for communicating with other applications and to display the data, fetched from
database in mobile and web app.
• Integrated Text Message Gateway API integration in the CMS system with sending SMS in a single click
• Created and managed databases like MySQL and MSSQL for website portal as well as mobile application backend.
• Used SQL language for ETL process to extract data from the database, stored in data warehouse and assisted in the data
mining process.