Summary-

 Over 5+ years of total experience as Database developer in analysis, design,development, and testing of business applications such as OLTP, OLAP, Enterprise, web based, Client/Server, SOA architectures.

 Experience in AWS Cloud Computing Services such as EC2, S3, EBS, VPC, ELB, Route53, Cloud Watch, Security Groups, IAM, RDS.

 Worked on AWS IAM and Security Groups in Public and Private Subnets in VPC.

 Involved in logical/physical data modeling using ERWIN.

 Experience in source systems analysis and data extraction from various platforms.

 Extensive experience developing External tables and using Oracle utility tools like
SQL Loader, Import and Export on UNIX platforms.

 Experience in developing and managing UNIX shells scripts and scheduling the jobs using Autosys, Control -M and monitor the batch processing.

 Strong understanding of Data Warehousing (Including Star Schema, Snowflake Schema) and Extraction Transformation Loading (ETL).

 Highly proficient in developing and understanding complex stored procedures and functions in PL/SQL, PL/pgSQL and T-SQL.

 Expertise in building schemas, managing db objects (tables, views, materialized views, indexes, triggers, scheduler jobs), partitioning tables, Hints, SQL tuning, troubleshooting, debugging and fixing the codes/scripts.

 Implemented various Error/Exception handling methods using system and user defined exceptions.

 Experience working on AWS RDS/Aurora for Oracle/PostgreSQL databases.

 Proficient in Python to extract/load data from the SQL source database.

 Knowledge on Core Java concepts like multithreading, Exception handling and Java collections.

 Proficient in technologies like XML, HTML, CSS and JSON.

 Implemented projects using various SDLC methodologies like Agile, Water Fall.

 Excellent experience in documenting technical and functional design specifications.

 Experience in Unit testing and Integration Testing with excellent debugging skills.

 Proficient in UML methodologies in preparing use case, sequence, class and interaction diagrams.