Aalap M
Sr. PostgreSQL Developer at Verizon
PostgreSQL Developer
Graduate Student and a computer engineering professional well versed in Python, Java, SQL who wants to explore new avenues and technology. Ability to work with very little supervision accompanied with great analytical thinking and troubleshooting ability.  Well educated data scientist with a demonstrated ability to deliver valuable insights via data analysis and advanced data driven methods. Quick learner with a strong work ethic in team or individual settings to drive product success and process efficiency.
Verizon
https://www.linkedin.com/company/verizon
	Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
	Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
	Developed UNIX Shell scripts to automate table creation, execute procedures.
	Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
	Creating Stored Procedures to transform the data and worked extensively in T-SQL for loading the data
	Set up and maintained the Windows/SQL Server 2016 virtual machines in Amazon (AWS) Cloud that support our customer's application environment deployed in the Amazon Cloud.
	PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 10 to PostgreSQL 11 and PostgreSQL 12. 
	Senior level supporting Oracle, MSSQL server, My SQL and PostgreSQL Production databases in an enterprise environment.
	Installed SQL Server 2017 on various Linux Operating Systems.
	 Good T-SQL Programming techniques in query optimization and performance tuning.
	Design and implement disaster recovery for the PostGreSql Database.
	Designed dashboards utilizing Power BI with rich visuals such as charts, slicers, gauges, funnel, word cloud.
	Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 11.x/10.x and greater).
	Guided and migrated Postgresql and MySql databases to AWS Aurora
	Wrote complex T-SQL queries and stored procedures for the building reports in SSRS.
New York, United States
https://media-exp1.licdn.com/dms/image/C560BAQHAiVb75wIpDQ/company-logo_100_100/0/1645721742845?e=1655942400&v=beta&t=EJhgPS8YHpG2nKlT1Ahkl9zXcz9zkBiG-nMutIZTIDY
Sr. PostgreSQL Developer
eBay
https://www.linkedin.com/company/ebay
	Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers.
	Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
	Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
	Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
	Responsible for all backup, recovery, and upgrading of all of the PostGreSql databases.
	Used Window Azure to Deploy the Application on Cloud and Managing the Session.
	Working on Oracle 11 to PostgreSQL Migration, Prepare DMA report in PostgreSQL.
	Extensively used WEBI, to create ad-hoc and schedule complex reports, and Central Management Console (CMC).
	Created Ad-hoc reports with complex t-SQL queries based on business requirement.
	Enhanced and translated existing dashboards in SSRS into QlikView and worked extensively with the set analysis.
	Migrated the on premises PostgreSQL, Oracle & MYSQL databases to Amazon AWS RDS and Aurora Databases using Amazon AWS Data Migration Services (DMS) and AWS Schema Conversion Tool.
	Load data from a text file or csv files or from flat files in a PostgreSQL database.
	Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups.
	Perform failover when necessary, and then rebuild the master as a slave in PostgreSQL streaming replication setup.
	Documented data mart and data warehouse database design, and performance tuning best practices in Greenplum and PostgreSQL database.
	Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
San Jose, California, United States
https://media-exp1.licdn.com/dms/image/C560BAQFfGj-Xuawo6A/company-logo_100_100/0/1634568184091?e=1655942400&v=beta&t=1jxFmMqZZyEbeQ16J5JlxjEukTF_vTLyZZx8rP9P5zA
PostgresSQL Developer
MakeMyTrip
https://www.linkedin.com/company/makemytrip.com
	Created database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.
	Involved in Testing and Debugging Stored Procedures and functions, database tuning.
	Created jobs and monitored job history for maximum availability of data and to ensure consistency of the databases.
	Designed new databases according to Business requirements like logical design and physical design.
	Created SQL Server Integration Service packages (SSIS) and used it to Extract, Transform andLoad (ETL) into Database tables.
	Demonstrable knowledgeable experience with Oracle SQL, PL/SQL development.
	Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
	Used PowerShell script for SQL Server Maintenance activities.
	Involved in preparing the automation test data and preparing the selenium script for new functionality.
	Knowledge in Setup and maintenance of Postgres master-slave clusters utilizing streaming replication
	Extract Transform and Load (ETL) source data into respective target tables to build the requireddata marts
	Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
	Redesign Oracle application architecture to prepare for migration to PostgreSQL environment.
	Experienced in ETL using DTS Import/Export Data, Bulk Insert, BCP, Data Replication andDTS Packages.
	Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
	Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS and designed reports using Crystal Reports
India
https://media-exp1.licdn.com/dms/image/C4E0BAQGztBPTPiyXdA/company-logo_100_100/0/1568713277315?e=1655942400&v=beta&t=_AjZxzMhlqCg3thIhyV-YTv2DTwa6fdvASGPNdRTaH4
PostgreSQL Developer
Qualcomm
https://www.linkedin.com/company/qualcomm
	Involved in gathering user requirements and documenting the Technical specification analysis based on functional needs. 
	Involved in query optimization and developing ER models as per the requirements.
	Handling large size databases which involve migration of data from Oracle to SQL.
	Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
	Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
	Developed PL/SQL triggers and master tables for automatic creation of primary keys.
	Created PL/SQL stored procedures, functions and packages.
	Dealt with the third party vendor (4Sight) for resolving issues, finding software related bugs and gave recommendations to resolve it. 
	Worked with different business users in setting up data marts based on their Analysis/Reporting needs. 
	Developed SQL scripts /libraries for various data loads and validation for both OLTP and OLAP systems. 
	Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end applications. 
	Created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL across all SDLC environments.
India
https://media-exp1.licdn.com/dms/image/C560BAQHHmRgEadFrdA/company-logo_100_100/0/1611250856145?e=1655942400&v=beta&t=OlYNWFjd-lqOEJ82mAVDViNdhY9vT1MpPZalKn2mWA4
Plsql Developer
Master's degree
Computer Science
https://media-exp1.licdn.com/dms/image/C4E0BAQGeM2xL_Ibjhw/company-logo_100_100/0/1564427229540?e=1655942400&v=beta&t=iOsMVa64fF9eCgQ-E20F0koKZ66XyGSOWVIlRmCvUsc
New Jersey Institute of Technology
https://www.linkedin.com/school/njit/
Bachelor's degree
Computer Engineering
Shah And Anchor
Certificate for excellent academic performance
Shah And Anchor Kutchhi Engineering College
First Class
Shah and Anchor Kutchhi Engineering College
Winner - Counter Strike Tournament (LAN gaming event)
Shah And Anchor Kutchhi Engineering College
Winner - Cricket Tournament
Advanced Database Management Systems
-
Artificial Intelligence
-
Computer organzation and Architecture
-
Distributed Computing
-
Image Processing
-
Database Management System and Design
-
Data Structures
-
Internet and Higher Layer Protocols
-
Java Programming
-
Software Architecture
-
- Using MapReduce Jobs found out common friends between two users and recommended new users to them.
- The first MapReduce job finds out common friends between two users and the second MapReduce job makes a recommendation using a Key value pair.
Recommendation System Using Collaborative filtering
- Idea was to build an AI based deep learning model that can classify images to different categories of clothes to get the fashion trend.
- Built a convolution neural net using 32 kernels which was able to classify images to their categories with the accuracy of 95%.
Fashion Class Classification
•Created data pipeline; analyzed the text data using several techniques of Natural language processing.
•Developed a model using Multinomial Naïve Bayes classifier which was able to classify Yelp reviews into 1 star to 5 stars based on the text content in the reviews.
Classifying Yelp Reviews
- Gathered and prepared the data set, performed data cleaning by fixing the missing values and the standardizing it.
- Developed a model using nonlinear Support Vector Machine which can precisely classify the emails as spam or ham with an accuracy of 86% and precision of 87%.
Email Spam Classifier
- Built a predictive model using CART and Random Forest to anticipate which employees will leave.
- Implemented Exploratory data analysis to visually summarize and study the behavior of the employees.
- The predicted factors which are most responsible are overtime, monthly income and total years in the company.
Analysis of factors of attrition
Implemented a page rank algorithm to calculate the importance of a web page for better search results.
Computed a transition matrix using the incoming and outgoing links to and from Web Pages; using this matrix recursively calculated the page rank after every iteration
Google PageRank Algorithm
Designed a desktop based application that automated the manual process of library and maintained a central repository to store the data; Programmed application to manage data of different departments in college.
Library Management System
-
Android Development
-
OCPJP
https://in.linkedin.com/in/rohit-prabhu-45a414a2
Mumbai
Rohit Prabhu
Student at University of Mumbai
https://in.linkedin.com/in/sandesh-ayare-466829106
Mumbai
Sandesh Ayare
fresher
https://www.linkedin.com/in/kranthi-tupakula-6b64984a
Spring, TX
Kranthi Tupakula
Technology Analyst at Infosys
https://www.linkedin.com/in/sravanireddydotnet
Parsippany, NJ
Sravani Reddy
Sr. Dot Net Developer
https://in.linkedin.com/in/meenaz-shaikh-740609147
Mumbai
Meenaz Shaikh
Analyst at PwC
https://www.linkedin.com/in/rachael-peterson-30a7b245
Greensboro, NC
Rachael Peterson
Lead Administrator at AIS Solar
https://in.linkedin.com/in/ravinamin
Ahmedabad
Ravin Amin
A
https://www.linkedin.com/in/kathleen-trevino-b0283029
Rahway, NJ
Kathleen Trevino
CEO and Founder, Emerson Consulting, LLC
https://www.linkedin.com/in/roy-silveira-a6a7b67a
Nashville, TN
Roy Silveira
Team Lead - Consulting Application Engineer at HCA Healthcare
https://www.linkedin.com/in/dannishan
Chicago, IL
Danni Shan
Product Design Engineer at Suvie
https://www.linkedin.com/in/nisarg-patel-850274ab
Edison, NJ
Nisarg Patel
Stability Operations and Compliance (ACDS)
https://www.linkedin.com/in/robert-spink-b7a2511a
Butler, NJ
Robert Spink
Lead Software Engineer, Instrumentation  at Xybion Medical Systems
https://www.linkedin.com/in/dawn-l-rex
Evanston, IL
Dawn L. Rex, MS
Manager Clinical Science Center of Excellence - Process, Training, and Innovation at Astellas Pharma US
https://www.linkedin.com/in/tramya
Washington DC-Baltimore Area
Ramya Tannidi
DevOps Engineer (CKA) at Vibrent Health
https://www.linkedin.com/in/suhas-sudhindra
United States
Suhas Sudhindra
RF Engineer
https://www.linkedin.com/in/melissa-cook-11825b6
Wauconda, IL
Melissa Cook
Director Global Project Management at PPD
https://www.linkedin.com/in/mohammad-suleman-shaik-63909a14
Suwanee, GA
Mohammad Suleman Shaik
Sr.Java Developer / App Support
https://www.linkedin.com/in/harish-y-098765
Loretto, MN
Harish R
MacOS/iOS Developer at Apple
https://www.linkedin.com/in/vaibhavrupapara
Greater Boston
Vaibhav R.
18x  Salesforce Certified, Salesforce Developer at BestDoctors
https://www.linkedin.com/in/bhanuakella
San Francisco Bay Area
Bhanu Prakash Akella
Senior Salesforce Developer at Cohesity
https://in.linkedin.com/in/aalap-h-m-4299211b0
Visakhapatnam
Aalap H M
Student at Gandhi Institute of Technology & Management (GITAM) University, Visakhapatnam
Algorithms
https://media-exp1.licdn.com/dms/image/C4D07AQGA5XUw50o-Cg/group-logo_image-shrink_200x200/0/1631374096732?e=1647691200&v=beta&t=8Qcdx82hDXSql-sgtq8Tpl6ywMbUAuPXM--PTAZynss
https://www.linkedin.com/groups/98713