Talent's Information
-
Location
Nagpur, India
-
Rate
$12.0 per Hour
-
Experience
3.10 Year
-
Languages Known
English,Hindi
Available for
About Dilip S
IT professional with 3.10 years of experience in software industry with AWS Services as skills.
Current work experience with client Netcomm Wireless,Australia as a Software Engineer for HR4860 Secure 5G SD-WAN Gateway on Fiber Networks
Resourceful, enthusiastic person with hands on technical skills in the field of AWS Cloud Computing.
Worked on AWS services like VPC, S3, RDS, AWS Glue, EC2, Redshift, IAM, CloudWatch, ELB.
Worked on ETL transformations with AWS Glue, SQL, Power BI and Tableau as reporting tool.
Result oriented pro-active professional possessing strong analytical skill.
Team player with quick learning abilities and problem-solving skills.
AWS Certified Solutions Architect - Associate Certificate
Tech Stack Expertise
-
Python
Django,Pandas,Python
0 Years -
Kotlin
Spark
0 Years -
Repository Tools
Git
0 Years -
AWS
AWS S3,Amazon AWS
0 Years -
Azure
Azure Databricks,Azure,Azure ADF
0 Years -
Big Data
Big Data
0 Years -
Microsoft SQL Server
SSMS,Microsoft SQL Server 2016
0 Years -
Oracle
Oracle
0 Years
Work Experience
Software Developer
- January 2020 - November 2022 - 2 Year
- India
Projects
HR4860 Secure 5G SD-WAN Gateway On Fiber Networks
- January 2020 - November 2020 - 11 Months
-
This Solution is used for the management and orchestration of user virtual and physical network functions to facilitate the adoption of new technologies so user can innovate in service creation. The support provided by Liberty Global OSS for both PNFs and VNFs serves as the foundation of network slicing. Packet traffic on Fiber networks is steadily on the rise and Fiber network operators must meet exacting services while optimizing performance. As a result, more and more telecom operators are ramping up their transoceanic fiber networks to improve reliability, performance and bandwidth availability, making comprehensive testing—across the multiple layers of the network—critical.
Laying out new submarine fiber is several times more expensive than terrestrial deployments. Its troubleshooting, repair and upgrade is likewise costly. Telecom operators face the task of running each fiber at its maximum capacity. Therefore, network characterization tests, including end-to-end chromatic dispersion (CD) and polarization mode dispersion (PMD), are essential to guarantee high-speed submarine transmission. What’s more, validation with a next-gen optical spectrum analyzer (OSA), performed during system commissioning, ensures that a single fiber will contain as many dense wavelength-division multiplexing (DWDM) channels as possible, while operating error-free.
Today’s regional and transoceanic network deployments demand powerful, flexible multiservice testing solutions that address SONET/SDH/OTN (up to OC-768/STM-256/OTU3) and Ethernet (10M to 100G) transmissions. Accelerating and simplifying the deployment processes with powerful, intelligent platforms that easily accommodate a variety of optical, transport and datacom modules help overcome these challenges. In addition, capabilities, such as automation, simultaneous and in-service testing, as well as remote management, validate that all the tests performed throughout the lifecycle are accurate, thereby ensuring the cost-efficiency and success for 40G/100G submarine networks.
The main features are
Support for corporate hierarchies,Order Management automation,Product management and pricing for any business model,One bill for any service,Capture all your revenue,Integrate with ease,Agent support
Task Handled
Experience in developing entire frontend and backend modules using Python on Django Web Framework.
Experience in working at various phases of project such as analysis, design, development, and testing.
Using Django Framework model, implemented MVC architecture and developed web applications with superb interface.
Created user interface of website using Python, HTML5, CSS, JSON. Used CSS bootstrap framework for developing web application.
Developed the business logic in views for the URLs created and linked the webpages to functions in views to show the output to the end-user or to store information from the website into the database
Worked on Django REST framework as it is much faster to read data and it can be cached. REST allows more formats than SOAP and gives better support for browser clients as it supports JSON.
Written scripts to import data, export data and data modeling.
Worked on Django ORM API to create and insert data into the tables and access the database.
Extensive experience in using the python packages such as NumPy, SciPy, Pandas, Pickle and OS.
Built multifunction readmission reports using python pandas and Django frame work
Involved in Preparing Low level Design of Application, To take part in software and architectural development activities
Involved in designing and preparation of call flows with usability services.
Perform data exploratory analysis using Matplotlib
Collected historical data and third party data from different data source,Improved Operation activities. Used Linear & Logistic Regression
Understand and Analyse Customer requirements and Busi
Edwards Data Lake Development
- June 2020 - January 2021 - 8 Months
-
Edwards Life science is the global leader in the science of heart valves, hemodynamic monitoring and global leader of patient-focused medical innovations for structural heart disease and critical care monitoring. Edwards Lifesciences Corp. engages in the patient-focused medical innovations for heart disease and critical care monitoring. Its products are categorized into three areas: Transcatheter Heart Valves, Surgical Structural Heart and Critical Care. The Transcatheter Heart Valves portfolio includes technologies designed to treat heart valve disease using catheter-based approaches as opposed to open surgical techniques. Its portfolio includes technologies designed for nonsurgical replacement of heart valves. The Surgical Structural Heart portfolio includes tissue heart valves and heart valve repair products for the surgical replacement or repair of a patient's heart valve. The Critical Care portfolio products through hemodynamic monitoring system measures a patient's heart function and fluid status in surgical and intensive care settings. The company was founded by Miles Lowell Edwards in 1958 and is headquartered in Irvine, CA.
The requirement is to create a data lake for one of the business use case of clinical trials.
Key Responsibility areas:
Developing AWS Glue jobs to join, transform, partition & load data into S3
Crawled clean data from S3 and established the connection with RDS in the AWS Glue Data Catalog.
The data is ingested from different vendor sources in the file format into AWS data lake.
Add trigger to automate the ETL pipeline.
Aventri Data Lake Development
- February 2021 - October 2021 - 9 Months
Cloud Based Event Management, data integrations, marketing automation, CRM, ERP, association management
Aventri is a leading cloud based Event management company known for its integrated solutions for management of meetings, events & tradeshows. It provides platform to other companies and organizations to execute event and meetings for virtual, hybrid and in-person event globally.
The requirement was to develop the data lake with historical and near real time data from different data sources with partitions and row level security.
Key Responsibility areas:
Involved in project planning and execution as well as monitoring
Involved in setting up the required architecture for the Datalake development using various AWS components such as VPC, IAM, Glue, Redshift, Athena, etc.
Setting up connections with different data sources such as MySQL, Azure SQL, etc
Part of creation of raw layer and staging layer from different data sources in S3
Designed and developed AWS Glue jobs to join, transform, partition & load data into S3
Developed workflows to schedule the loads for incremental data
Implemented row level security to restrict access to different users using IAM policies
Designed and implemented simple star schema model into AWS Redshift
Loaded the dimensions and facts in Redshift using AWS Glue
Working on Infrastrcture - EC2 Instances (254) and RDS Instances hosted in Regions N. Virginia (US), Europe (Ireland), Asia pacific (Sydney) and Monitoring and troubleshooting DB Instances, CPU Utilization and Disk Space
Responsible to action on configuration and Infra Requests, which are reported on SLACK or JIRA
Working on Technology Stack: Bitbucket (Source code Repository), Jenkins (Support for scheduled builds & automation test execution, Deployment of the artifact with custom scripts), Linux, AWS Services: IAM, Cloudwatch, EC2 Instance, VPC (Virtual Private Cloud), Route53, Elastic Load Balancer, Security Groups, RDS: MySQL; PostgresSQL; MongoDB, S3, Lambda (Serverless), SNS; SQS, Certificate Manager.
Power BI Reports For The WIP Data
- October 2021 - January 2022 - 4 Months
System/Component : Manufacturing WIP data Business Intelligence Reporting
Howmet Aerospace Inc., (formerly Arconic Inc.) is an American aerospace company based in Pittsburgh, Pennsylvania. The company manufactures components for jet engines, fasteners and titanium structures for aerospace applications, and forged aluminum wheels for heavy trucks.The Project Objective is to create the Power BI Reports for the WIP Data for one of the business use case.
Key Responsibility areas:
Communicating with client to understand business requirement and enhancement the dashboard using Power BI.
To enhance the programs for data collection, modelling and reporting the operational performance.
Creating Data Presentation/Visualization layer with Power BI for report enhancement.
Involved in effectively used filters, actions feature in Power BI.
Accessed and used various Custom Visuals available in Power BI.
Retrieving the required data from database Using SQL queries.
Well versed in data modeling, data extraction from multiple data sources MS SQL server.
Delivered UAT test cases; validate the quality and integrity of the data included in the Reporting Packages and Dashboards.
Responsible for enhance the Reports/Dashboards and publish into cloud services.
Create dashboards by pulling data from different sources and present them to management team
Analytical Grid & Smart Visualisation
- February 2022 - October 2022 - 9 Months
-
Detail Project Overview and Workflow :
Grid analytics is a solution for end user to check the availability of product in Warehouse .Market Basket Analysis is a technique that identifies the strength of association between a pair/group of products that are purchased together. In simpler words, it’s based on the concept that if a customer buys a product, they are more or less likely to buy another related product. Market Basket Analysis also uses machine learning/deep learning algorithms, like product recommendation engines.
SERP (Search Engine Result Page) analytics help user measure how customer's interact with the search results on user SERP, which gives insight to how customer search engine is functioning. This gives user important data points about where to improve the search experience.
Association rule learning is a machine learning method that is used for discovering associations between products. It does not consider the order of the purchase of products. Product Analytics will show user most popular products and availabiity along with detailed insight into how often each product is purchased and how much revenue it generates.
user can also see the keyterms shoppers are searching and which product they end up buying, so user can update the product naming to better fit for customers.
Task Handled :
Involved in requirement analysis, design, estimation and testing of the assigned tasks in open stack WITH BA
Interpreting data, analysing results using statistical techniques
Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
Design python script with respect to ensure functionalities meets customer requirements
Extensive experience in using the python packages such as NumPy, SciPy, Pandas, Beautiful Soap, Pickle and OS.
Worked on Django REST framework as it is much faster to read data and it can be cached. REST allows more formats than SOAP and gives better support for browser clients as it supports JSON.
Client : The Home Depot,USA
System/Component : Logistics
Created user interface of website using Python, HTML5, CSS, JSON and JQuery. Used CSS bootstrap framework for developing web application.
Acquiring data from primary or secondary data sources and maintaining databases
Work with stakeholders to determine how to use business data for valuable business solutions
Search for ways to get new data sources and assess their accuracy
Browse and analyze enterprise databases to simplify and improve product development, marketing techniques, and business processes
Create custom data models and algorithms
Use predictive models to improve customer experience, ad targeting, revenue generation, and more
Develop the organization’s test model quality and A/B testing framework
Coordinate with various technical/functional teams to implement models and monitor results
Soft Skills
Industry Expertise
Education
Electronics in B.Tech/B.E
Maharashtra Institute- June 2015 - June 2017
