Profile Summary

Software Developer specializing in data analysis and data visualization with experience in developing Business Intelligence applications. Good knowledge of Python programming, writing advanced SQL queries and designing BI reports and dashboards. Experience of working on Oracle, SQL Server databases and Linux operating system.

Work Experience

Easynet Ltd.(2012-2014)

Data warehouse and Business Intelligence Developer

The role involved understanding data requirements from users, data mapping from different sources, development of ETL applications on Oracle database, designing critical Reports/Dashboards and Linux scripting. Responsibilities include maintenance and development of data warehouse applications, development of reports for the departments of Inventory, Sales, Billing, Service Delivery, Finance, and Customer Review.

Achievements

  • Completed the development of the Datawarehouse application for Service Assurance team to include near-real-time data. This enabled the team managers to assign tickets more effectively based on priority and monitor team performance.
  • Helped to establish better Customer relations by developing several reports on Customer interaction and service delivery analysis.
  • Automated reports for the monthly customer review thereby removing manual data collation done by Service Delivery managers.
  • Implemented data marts for the billing team to collect additional costs that might have incurred.
  • Enabled an easy review of the sales performance of each product after its launch by designing Sales Dashboards. The managers were able to quickly review the performance of their sales teams and the sales of each product.

Tata Consultancy Services (2007 - 2011)

Systems Engineer

Worked on several projects for clients in manufacturing, retail, and telecom. Programming in C, Linux scripting for telecoms project. Implemented system for retail client using Java. Development of data warehouse applications for Product Support, Supplier Management, Marketing, Finance, Pricing, Warranty, Materials and Operations using database SQL stored procedures. Development of BI reports using SAP Business Objects and Crystal reports. Other projects worked include the development of Payroll system for deputed employees to the US.

Achievements

  • Obtained hand over of several BI reports from another organization and quickly resolved existing issues.
  • Efficient handling and maintenance of critical Pricing and Warranty applications.
  • Enhanced the functionality of the database applications by deploying several design changes.
  • Detailed Documentation was created, and user training provided successfully on application functionality.
  • Successful development of the payroll application which reduced manual work being done by the HR team and BA team. The application was successful in automation and provided flexibility when any pay or leave component was to be changed.

Technical Skills

  • Excellent data analysis skills with experience of working on Oracle database, advanced SQL querying,
  • Development of ETL Data warehouse applications
  • Design of BI reports and dashboards using Business Objects, Crystal Reports, WebFOCUS and Tableau
  • Programming skills with knowledge of Python programming, using Python for data analysis and data visualization. Also beginning to extend this knowledge by building machine learning models using scikit-learn

Transferable Skills

  • Good team working ability by effectively collaborating and working together to achieve common goals. Experience of working with onsite and offshore teams through effective communication and building strong team rapport.
  • Excellent data analytical skills with experience in developing applications for data extraction, data cleaning and transformation. I have also performed well in my previous roles by using this skill to build business intelligent reports/dashboards which have enabled users in better decision making.
  • Effective communication with stakeholders of the project to understand the requirements, to gain knowledge of interacting systems with appropriate teams involved, with users of the application to resolve issues and integrate new functionalities.

Return to Tech

Having taken time away from the tech industry to raise a family, I have been acquiring new skills through online learning since I am very much passionate about coding and developing applications. I enjoy working in an analytical environment, using my problem-solving skills to develop applications that are of greater value and benefit to the organization. Being able to provide such solutions also gives me a sense of accomplishment.