Summary
Overview
Work History
Education
Skills
References
Projects
Timeline
Generic

Krishna Rajesh Sarang

Jersey City

Summary

Software Engineering and Data Analyst professional almost 2 years of experience in analyzing data for driving business solutions. Project management skills and ability to identify processes that can be automated to save time and improve efficiency. Have good working knowledge in all SQL - DDL, DML, DCL, TCL commands. Experience in Business Intelligence, Data Modeling/Warehousing concepts. Advanced Microsoft Excel skills for data analysis & experience using complex formulae and functions Charts & Power Pivot, in addition to VB Script. Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filters and creating Dashboards for Key Performance Indicators. Exposure to cloud environments Amazon Web Services (AWS) and Azure. Major experience in Visual Studio to develop desktop applications for business, inventory application for business as well as WEB based product. Knowledge of the Software Development Life Cycle (SDLC) methodologies like Agile and Waterfall. Experience Gathering, Cleaning, and Visualizing Data from various data sources through Python, R. Generated statistical, and predictive analytics and generated reports and graphs with Python, Excel. Worked with python libraries like Matplotlib, NumPy, SciPy and Pandas in python and dplyr, tidyr, ggplot, plotly, and highcharter in R programming for data analysis. Worked under Senior Developers as helping hand to get into field and get idea of Software Development. Experience in successfully working in teams to achieve Project targets and Deadlines. Excellent team player with ability to work independently, with strong analytical and communication skills.

Overview

7
7
years of professional experience

Work History

Data Analyst

Winsor group of Consulting
New York
01.2023 - Current
  • As data analyst and being part of technical team, main aim is to provide the technical support for the project which can eventually reduce manpower and man hours for more productivity.
  • Attending the Sprints and noting down the points of the sprint meeting to get the story your part in process and making sure the work is done from your end.
  • Building demo websites to present in bi-weekly meetings to give the layout of product which gets better after every meeting which shows the continuous progress in the project and reflects consistency.
  • Automating the couple of reviewing and Disclosure process which was costing lot of human hours by using Power automate and incorporating other technologies like PYTHON to provide the outer layer in the process.
  • Using PYTHON libraries for better optimization
  • Collecting data points and presenting reports. To make sure we can improve by presenting heuristic analysis and individual performance analysis.
  • Managing a couple of applications from statement of purpose to rolling out the application with hyper care.
  • Managing the SQL database to make sure every data is flowing in a secure manner and there is no data loss happening.
  • Migrating the legacy database to AWS cloud. Using AWS for cloud computing and using the S3 bucket for database.
  • Using Machine learning techniques and algorithms for optimization of smaller tasks can save up some time for other important and time-consuming work.
  • Used Caspio with CRM system to develop easy coded small systems. It is integrated with SQL Sever for data flow.
  • Used external API to connect Caspio system with SQL for scalability.
  • SQL query is used to optimize data interaction with Caspio system and query is used to import or export data between Caspio and SQL database.
  • Used FTP to manage file transfer in secure way.
  • Used FTP script to automate file transfer.
  • Performed some FTP administrative activities like new user creation and troubleshooting on Windows system.
  • Generated automation flow with the integration of Microsoft 365 with PowerApps for NYCHA Lead Abatement Program.
  • Used Sharepoint to store all automation flows.
  • Deployment of flows into system and performed all admin level tasks like giving access of flow to special group of people from different department.
  • Generated automated reports on Sharepoint on weekly basis.
  • Using service now and Jira to handle errors or any incidents that are raised while using the system.
  • Environment: Power Automate, Flows, D365, PYTHON, HTML, CSS, VB.NET, Salesforce, Tableau, Power BI, Linux, Excel, Google Colab, IoT, Neural Networks |DNN|CNN|RNN|LSTM, Backpropagation, NLP.

Software Developer

OM Software
SURAT
01.2018 - 01.2019
  • As Software Developer main goal is to build product most efficient way possible.
  • Apart from that understanding the requirements of the client is important considering the fact that they don’t come from IT background, so it is optimal to deliver product with east User Interface.
  • Worker on few technologies like VB.NET, ASP.NET, C#, php.NET to polish the technical skills.
  • For data management, data storage and to maintain flow of data worked on SQL database primarily.
  • Worked on developing Web Based application using ASP.NET and applied database connectivity to fetch and present real time data on web forms.
  • Built responsive website which can work perfectly fine in both desktop as well as mobile for better user experience.
  • Worked in Android Studio to develop small android application like Music Player, Messenger, Email Messenger, Sketch book, Gallery etc.
  • Summary of Duties:

Education

Master of Science - Computer Science

University of New haven
New Haven, CT
01.2023

Bachelor of Engineering - Information Technology

Sarvajanik College Of Engineering & Technology
Surat, Gujarat
01.2019

Skills

  • Programming: Python, R programming, Java, VBNET, C#, phpNET
  • Database Management: Microsoft SQL Server, MySQL, MongoDB
  • Tools: Tableau, Linux, Excel, Google Colab, IoT, RStudio, Kubernetes, Docker, PyCharm, Visual Studio
  • Cloud Platforms: AWS, Azure
  • Mobile Development: Andorid
  • Analytics: Data Cleansing, Data Mining, Data Wrangling, Data Analysis, EDA
  • Machine Learning: Reinforcement Learning Decision Tree, Random Forest, Reg (Linear & Logistic), Naive Bayes, K-Nearest Neighbor
  • Deep Learning: Neural Networks DNNCNNRNNLSTM, Backpropagation, NLP, Recommender Systems
  • Automation: Power Automate, Flows, D365

References

References Available Upon Request

Projects

Real Estate Management System: Real Estate Management System is a website to control, operate, maintain and oversight of property. Used php.NET to develop website and SQL database used for data connectivity. For better viewing experience of website incorporated other technologies like JavaScript, HTML as well as CSS., Enterprise Resource Planning (ERP) for Electronic Store: ERP is a business management software specifically developed for Electronic Store to maintain business related entities. Software was developed using C# and provided log in feature so multiple used can use software in their own different space as client had different store at multiple locations. It was develop to keep track of business resources like cash, stock availability, employees Information. Message API was used to send message as “Special Offer” to clients who purchased from store before using data stored in software. SQL database used to provide data connectivity and easy flow of data. Integrated Salesforce as CRM system to build bridge between client and developers for efficient interactions. After deploying the system Salesforce makes it easy to get feedback from client. Evaluate data to generate weekly reports to get insight of business model. Managing and optimizing the salesforce requests to reduce response time. Because of cloud based functionality of salesforce it gets easy to solve user request as no physical interaction required.

Timeline

Data Analyst

Winsor group of Consulting
01.2023 - Current

Software Developer

OM Software
01.2018 - 01.2019

Master of Science - Computer Science

University of New haven

Bachelor of Engineering - Information Technology

Sarvajanik College Of Engineering & Technology
Krishna Rajesh Sarang