Data Analysis Engineer

Karishma Sony

Email: ********.****.**@*****.***

Address: Atlanta, GA

Mobile: +1-404-***-****

LinkedIn ID: www.linkedin.com/in/karishmasony

I would like to be a part of an organization where I can use and enhance my knowledge and technical skills for both the organization as well as for myself. Having demonstrated work experience in software development. Having a good knowledge in Web Development with Python, Django and REST APIs. Development. Experienced on working with team.

Organization: People click Techno Solutions Private Limited, Bangalore. (SAP Company) To-Do App

• Created interface using frontend technologies like HTML, CSS, Bootstrap.

• Added CRUD (Create, Read, Update, Delete) operations on it. 1. Organization: LTIMindtree Limited (Client - P&G) Carrier Objective

Work Experience

Designation: Senior Data Engineer

Duration : Dec 2021

Roles:

Proficient in using Pandas,python for efficient data manipulation, transformation, and integration across various platforms and systems.

• Leveraged to accelerate data processing tasks, improving efficiency and performance in data transformations.

• Proficiency in data analysis and visualization tools (e.g., Excel, Power BI, Tableau). Develop and maintain financial reports and dashboards using Power BI.

• Python libraries like pandas, NumPy, and matplotlib for data analysis and visualization; APIs from cloud providers for data extraction.

• Monitors and analyses cloud spending, prepares financial reports, and provides insights into cost optimization.

• Utilized Pandas for in-depth data analysis, including cleaning, filtering, and aggregating large datasets to extract meaningful insights.

• Experience with cloud platforms and their cost management features.

• Utilized Pandas for in-depth data analysis, including cleaning, filtering, and aggregating large datasets to extract meaningful insights.

• Integrated Pandas with BigQuery,Sql and other big data platforms to manage and analyse largescale datasets effectively.

• Designed and implemented data pipelines using Pandas to connect diverse data sources such as BigQuery, SFTP, and cloud storage. Automated data workflows to ensure seamless data flow and consistency.

• Generated detailed reports and visualizations from Pandas data frames to facilitate data-driven decision-making and enhance business insights.

2. Organization: Datasturdy Consulting Pvt Ltd (Client – Myntra) Designation: Python Developer

Duration : June 2021 – Dec 2021

My Roles:

• Data Consistency Analysis: Analysed data inconsistencies using Python and Pandas and pyspark to identify and resolve discrepancies across various data sources. Push/ingest the Data to make it consistent.

• Data Ingestion and Transformation: Utilized Python scripts and Pandas for ingesting and transforming data to ensure consistency and reliability. Collaborated with the Web Application Team and used Python scripts to load the data into AWS Presto Database

• UTR Validation of Sellers: Implemented UTR (Unique Transaction Reference) validation processes using Python and Pandas to verify seller transactions and ensure data accuracy. 3. Organization: Presenova Management Solutions LLP Designation: Python Developer

Duration : October 2020 to April 2021

Project: E-Learning Software

Technologies: Python, Django, REST APIs, MySQL, HTML, CSS, Bootstrap, JavaScript, ReactJS My Roles:

• Created REST APIs for integrating with Frontend Web Pages using python

• Integrated Sending Email functionality in web page using SMTP Server

• Completed Authentication System to Authenticate and Authorize the custom users using OAuth

• Created and Deployed App on Linux platform, with PostgreSQL as the primary database for handling application data and ensuring data integrity.

• Integrated Paytm Payment Gateway, with transaction data and payment logs stored and managed using PostgreSQL for reliable and efficient data handling. 4. Organization: Cautilya Capital Designation: Software Engineer Project: Kite Connect Auto Trade Duration : August 2019 to July 2020

Technologies: Python, Django, REST APIs, MySQL,Bigquery My Roles:

• Worked on Tkinter for UI development.

• API requests and providing results to the users.

• Worked on converting the csv files to a text format using Pandas DataFrame

• Knowledge on Restful Web Services (HTTP Requests, Json) 5. Organization: Insnap Technologies

Designation: Software Engineer

Duration : December 2018 to July 2019

Project-1: Reachstream

Technologies: Python, Angular, MySQL

Description: It is a marketing and sales data platform whose purpose is to provide contacts and details of the company to the client to expand their business and services My Roles:

• Implemented authorization mechanisms using third-party applications such as auth on Linux platforms, integrating securely with existing systems.

• Utilized Jira for tracking and managing defects, with hands-on experience in configuring and using Jira on Linux-based servers.

• Managed and configured end-to-end instances on AWS with Linux-based environments, and wrote automated scripts using Protractor for testing, alongside working with APIs.

• Performed comprehensive automation testing across the entire project using Linux platforms, ensuring robust testing processes and integration within Linux-based CI/CD pipelines Project-2: Test-Reporting Portal

Technologies: Python, Angular, MySQL

Process Type: Agile Scrum Process

Description: It is a Web Based Application designed and developed to view reports. Reports such as functional test report, Back-End and Front-End unit test report, security scan report, Manual test report, SonarQube report and JMeter tests report. All these reports are stored in s3 and we need to display the reports that are stored in s3. These reports helped us in giving brief idea about how the quality of our project is and where can we improve the quality.

My Roles:

• Written Front-end code

• Generated python scripts for few tasks

• Done Automation Testing for whole project.

• Performed E-2-E Automation Testing Using Protractor Framework. Agile Process:

• Attending daily standup meeting.

• Attending sprint planning to take up the user story.

• Every 2 Sprint planning there will be sprint demo meeting following agile Scrum TECHNICAL SKILLS :

Programming:Python,C,HTML,CSS,Restfull API,pandas, Linux server Framework: Django

Databases: MySQL, SQLite, Bigquery, GCP

IDE: Pycharm, Visual Studio

Contact this candidate