aalap
Sr. PostgreSQL Developer at Verizon
postgresql developer
graduate student computer engineering professional well versed python , java , sql want explore new avenue technology . ability work little supervision accompanied great analytical thinking troubleshooting ability . well educated data scientist demonstrated ability deliver valuable insight via data analysis advanced data driven method . quick learner strong work ethic team individual setting drive product success 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