As part of the Software development team in functionapps as Data Analyst, key role: to Interact withClient for Business Objectives, Defining Data pipeline & Development of required ETL functions, Definingdata schemas for storage, Building the transformation function logics as per the client deliverables,designing the visual analysis data flow in the form of dashboards, Working with multiple team internally toget the delivery done.Development of shell scripts to create data… Show more As part of the Software development team in functionapps as Data Analyst, key role: to Interact withClient for Business Objectives, Defining Data pipeline & Development of required ETL functions, Definingdata schemas for storage, Building the transformation function logics as per the client deliverables,designing the visual analysis data flow in the form of dashboards, Working with multiple team internally toget the delivery done.Development of shell scripts to create data pipe line from various data sources. Like MS SQL tables,Restful APIs with Applications, Integration through message queues and some other sourcesData cleanup and transformation scripts/program development (shell scripts or python programs) likeDate format conversion, select column filtering, keyword based data validation etcDevelopment of Data Processing libraries in SQL for data manipulationData Validation and Audit functions using SQL scripts or python or JavaAdditionally, Defining & Integrating PowerBI in the visualization layerKey responsibility at the visualization layer was to define the analysis work flow with temporal or nontemporal analysis, Geographical analysis, creating cohorts or other specific types of charts, drill downwork flow for deep analysis, correlational analysis data schema and logic definitionDevelopment of Health monitoring agents for system & database performance KPI measurementCoordinating with DBA for database performance as data scales over period of timeHandled projects with clients in cross vertical domains like Hospitals (EyeQ), Telecom Service Provider(Airtel), FinTech (SnD)Reduced daily total business summary report generation time by 3x, resulting in more efficient and timelyreporting processes by automating organization’s business look through.Developed and implemented multithreaded microservice in Java to enable quick data processing,resulting in a 30% increase in portal performance. Show less

Development of Data pipe line from Social media platforms using SMTP adapter or APIs providedProject specific adapter development like agents to measure RTT, Jitter, Packet loss, DNS resolution timeetc for Data network health analysisSNMP GET/TRAP adapters for SNMP based solar power generation and consumption analysis.Developed centralized data Logger platform in Python to receive logs from client side and stream it usingreal time streaming service Kafka. Developed Kafka… Show more Development of Data pipe line from Social media platforms using SMTP adapter or APIs providedProject specific adapter development like agents to measure RTT, Jitter, Packet loss, DNS resolution timeetc for Data network health analysisSNMP GET/TRAP adapters for SNMP based solar power generation and consumption analysis.Developed centralized data Logger platform in Python to receive logs from client side and stream it usingreal time streaming service Kafka. Developed Kafka client APIs in Python to interact with Kafka engineand store logs in required files.Added features in API to filter logs and transform data before storing permanently in file or DB.Reduced ~0.06% of global CPU usage and 15% of disk I/O operations from redirecting the logs fromapplication server to a different server. Show less

Working on SOAP web services To develop a message handler module in Java to add a new message in the project. Handling included decoding JASON message, Validating the received fields as per the expected set of values inserting into the DB, processing the response and sending it to the client.

IMSI decoding Module It consisted of developing a client server architecture along with understanding the message protocol used. Understanding the structure of IMSI, developing the IMSI decoding module to find the operator of IMSI and hence bulk uploading data for the particular in the database using efficient algorithms.