I have worked as a Data/Business Intelligence Analyst who worked in Retail/Healthcare Analytics for a total of 18 months. Having worked on ETL and Data cleaning, mining, and reporting sales-related data. Built and automated many data processing scripts and written efficient SQL scripts for an end to end report generation. Created SQL schema from the very basics to build a huge database for Higher Account Management.
I have experience in both Application Engineering and Analytics. I have worked as an Application Analyst for 14 months at Accenture. I was responsible for the full lifecycle development of next-generation software, from initial requirement gathering to design, coding, testing, documentation, and implementation. Written automated and semi-automated scripts for data analysis. Participated in all phases of research including data collection, data cleaning, data mining, developing models, and visualizations. I have a strong educational background in both computer science and Information Technology. Apart from this, I have Completed my internship from the Indian Space research Organization (ISRO) where I worked on real satellite data for fault-tolerant autonomy of a Satellite.
-
Experience
• Successfully implemented the Requirement gathering, planning, and implementation of the day to day transaction-level database on AWS RDS and automation of data processing.
• Implemented dashboards for the daily sales and promotion analysis for the business team to drive sales and promotion increasing the sales by 3% and promotions by 5%.
• Worked on creating SQL and ETL scripts for the transactional level data for exploratory analysis. Worked on Tableau for report generation and data pipelining using python(psycopg2).
• Worked on AWS RDS using SQL and Tableau for data pulling and processing the raw data to generate reports for the stakeholders to successfully take a decision to increase customer penetration by 8%.
• Successfully completed the migration of data from RDS to RedShift using Python, S3, and EC2 saving almost 50% of the technology expenses monthly.
• Created schema, database, and respective tables to analyze huge data from the RedShift into PostgreSQL reducing the processing time and increasing the efficiency and speed by 70%.
-
Projects
• Bachelor’s project titled ‘Simulation and design of a fault-tolerant autonomy of a spacecraft’ with research facility under ISRO. Built a data model for Autonomous fault detection, verification, and responding with the correction required. The simulation was performed which lead to 60% fault detection. The reports were generated and analyzed and later presented to ISRO faculty and the university. Research Paper on LEON-3 Based Satellite was also published in IRJET journal 2015.