Karthik Joshi Email & Phone Number

Melbourne, Australia

✔Gathered client requirements ,developed proof of concepts and analysed data from different sources to build data systems through python architecture(API).✔Implemented program code for ETL (extract transform and load data) in python into Amazon Web Services (AWS) database while ensuring data integrity and accuracy.✔Built processes/programs to improve efficiency in existing data processing and delivered to internal and client models.✔Designed data models in SQL, extracted and… Show more ✔Gathered client requirements ,developed proof of concepts and analysed data from different sources to build data systems through python architecture(API).✔Implemented program code for ETL (extract transform and load data) in python into Amazon Web Services (AWS) database while ensuring data integrity and accuracy.✔Built processes/programs to improve efficiency in existing data processing and delivered to internal and client models.✔Designed data models in SQL, extracted and transformed the data from different sources like QVD, files, Excel, SQLServer, Inline & txt files through python and created Visualizations on highcharts.js , Power BI, Qliksense ,Tableau for multiple clients.✔Maintained technical user manuals on how to run scripts and inline code comments for code readability, and ownership of end user documentation.✔Developed Machine learning algorithms in python to predict/forecast multiple dependent and independent time series.✔Designed use case scenarios and written test scripts using testing guidelines to identify logical errors and debugged the same. Show less

Melbourne, Australia

✔ Applied technical skills of data extraction, manipulation, and analysis to procure data from different database structures and provided solutions to client requests(SQL and MongoDB)✔Used Business Intelligence Reporting Tools like QlikSense/Qlikview, Tableau, and Microsoft Power BI to create KPIs to improve profitability measures and comparative financial analysis.✔Gathered data sources like QVD files, Excel, SQL databases, MongoDB, Inline & txt files in developing… Show more ✔ Applied technical skills of data extraction, manipulation, and analysis to procure data from different database structures and provided solutions to client requests(SQL and MongoDB)✔Used Business Intelligence Reporting Tools like QlikSense/Qlikview, Tableau, and Microsoft Power BI to create KPIs to improve profitability measures and comparative financial analysis.✔Gathered data sources like QVD files, Excel, SQL databases, MongoDB, Inline & txt files in developing the Qlikview/Qliksense Data Models. ✔Created and delivered presentation/demo of BI tools(QlikSense) to multiple clients.✔Utilized PowerBI to show Twitter sentiments and other client-related analytical dashboards which depicts critical KPIs✔Created Tableau Dashboards with interactive sheets, trends, and drill-downs along with level security.✔Developed excel financial reports and automated some of the tasks through Excel-VBA.✔Developed excel workbooks involving Message boxes, forms controls, ActiveX controls and charts for visualizing the outcomes✔Created Views, Stored Procedures involving complex joins and other calculations and automated some of the frequent client requests through PL/SQL blocks.✔Developed a forecasting model in R and Python to predict the inventory and Sales for a particular client. Show less

Melbourne, Australia

✔.Analyzing trends and preparing reports that help in the marketing of EQIS products ✔Developing and maintenance of EQIS website and analyzing visitor-related information for marketing.✔Assisting in MYOB accounting software✔Analyzing customer feedback forms which include 6 questions

Banaglore

✔Developed Executive dashboards in Qlikview/Qliksense for leads and separate dynamic live dashboards for individual medical representatives to assist them in their sales✔Developed Analytical Master Dashboards in Qliksense which helped the client to visualize their efforts and improve patient outcomes.✔Interacted with end-users to collect requirements and acquired the necessary domain knowledge to become a subject matter expert. Trained and provided support to end-users.✔Performed… Show more ✔Developed Executive dashboards in Qlikview/Qliksense for leads and separate dynamic live dashboards for individual medical representatives to assist them in their sales✔Developed Analytical Master Dashboards in Qliksense which helped the client to visualize their efforts and improve patient outcomes.✔Interacted with end-users to collect requirements and acquired the necessary domain knowledge to become a subject matter expert. Trained and provided support to end-users.✔Performed day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting, hotfixes, and report migration.✔Resolved and logged many Priority (P) P1, P2, P3 Incidents on Remedy tool and service now. Automated some of the specific tasks which helped the team to minimize the time in troubleshooting which in turn reduced the cost for the client.✔Prepared a detailed report concerning project specifications and activities. Involved in the ETL design, development, and analysis of the interface using Informatica Power Center tools for cloud-based Veeva on Salesforce.com.✔Extracted data from multiple sources to Staging Area and loaded the data to the Oracle database by ETL process using Informatica Power Center.✔Used SSIS package to populate data from excel to the database, used lookup, derived column, conditional split, Pivot, and UnPivot to achieve the required data.✔Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports, Bar charts, Gauge Charts, Key indicators, etc; using SSRS and have good knowledge of SSAS cube architecture✔Deployed SSIS packages on production and scheduled the packages through jobs✔Used Error handling and Slowly changing dimensions to build Data warehouse and provided suitable data management solutions✔Intense 2 month internal training on Base SAS programming Show less

Bangalore

Project: Design and Characterization of Analog Blocks for Data Acquisition System.✔ Data Acquisition is simply the process of bringing a real-world signal such as voltage or current into the computer for processing, analysis, storage or other data manipulation.✔ Characterized a gain programmable operational amplifier (Miller op-amp) for the given specification✔ Built 256:1 Analog multiplexer for the given specification✔ Designed the A/D convertor for the given specification… Show more Project: Design and Characterization of Analog Blocks for Data Acquisition System.✔ Data Acquisition is simply the process of bringing a real-world signal such as voltage or current into the computer for processing, analysis, storage or other data manipulation.✔ Characterized a gain programmable operational amplifier (Miller op-amp) for the given specification✔ Built 256:1 Analog multiplexer for the given specification✔ Designed the A/D convertor for the given specification Show less

Masters, Data Science

Activities and Societies: ✔Monash Data Science Society - Active conducting competitions such as Datathons( Predicting Property prices).

Bachelor’S Degree, Electronics And Communications Engineering, 8.02

Activities and Societies: ✔Youth Red Cross Society: Created awareness about the rare diseases through campaigns and also organised well.

Puc, Physics, Chemstry , Mathematics, Computer Science, 83.2