plastemartjobs.com Email: jobs@plastemart.com, hr@plastemart.com Download Date: 6/1/2025 6:07:23 PM ________________________________________________________________________________________ RefNo: CA - 29479 Gender: Male Age: 30 Designation: PL SQL Developer Highest Education Level: Graduate - Degree Preferred Location: Mumbai Notice Period: 30 Days Education Details: B.E-EXTC from ATHARVA COLLEGE OF ENGINEERING in 2017 with BE- 5.54 CGPI. INTERMEDIATE from PATKAR COLLEGE OF COMMERCE & SCIENCE in 2012 with 70%. SCHOOL (MAHARASHTRA BOARD) from ST.JOSEPH?S HIGH SCHOOL in 2010 with 85.27%. Skill Sets: SKILLS Tools: Oracle PL SQL Developer,Big Data Tools. Database Programming: PL SQL Operating System: Windows 7/Windows 10 SUMMARY 2.7 Years of IT Industry experience in SQL Development,PLSQL development, Big Data Tools,Oracle Reports development and enhancement and support of application. Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions. Ability to write Complex and difficult SQL Queries for Reporting purpose. Extensive on PL SQL Development and Oracle reports. Knowledge of Hadoop ecosystem and different frameworks inside it ? HDFS, YARN, MapReduce, Apache Pig, Hive, Flume, Sqoop, ZooKeeper, Oozie, Impala and Kafka. To write Map Reduce jobs, Pig, Spark, HIVEQL. To support code/design analysis, project planning, and strategy development. To load and transfer a large set of structured and unstructured data. To load data into partition tables of Hive. To import data through Sqoop into HBase and Hive from ex Work Experience: 7 Work Experience Details: Working as a PL SQL Developer (DEC 2017-MAR 2019). PROJECT Project Name: Payment Control. Client : BUPA. Role: Developer Duration: DEC?17-MAR?18 Description : Working on Insurer Domain we have to introduce a New Payment Method of SCB(Standard Chartered Bank) for BUPA(Insurer). Job profile- Created the necessary stored procedures and packages and according to the requirement. Involved in the continuous enhancements and fixing of production problems. 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?for moving the data from staging area to data mart. Created scripts to create?new tables, views, queries?for new enhancement in the application using PL SQL Developer. Created?indexes on the tables for faster retrieval of the data to enhance database?performance Project Name: Ex-stream Document Migration Client : BUPA. Role: Developer Duration: MAR?18 ?DEC?18 Description : Migration of all Daily User Requested Letters generated from Oracle Report to Ex-stream. Job profile- Creation Of New PL SQL Packages for Various Types of Letters Depending Upon Letter Type. Created a new service through .Net for picking up the Content of Letter Generated Through PL SQL Code. Code Generation Of XML File through PL SQl code using CLOB data type. XML Generated was Used by Ex-stream Server and Ex-stream tool Generated the PDF for the corresponding Letter. Project Name: Retail Data Analysis. Role: Developer. Duration: JAN?19-MAR?19 Description: Retail stores daily generate millions of transactions logs, analyzing these logs would generate beautiful insights and improve business Process these logs over night as a batch to understand: Demand of a given product. Trend and seasonality of sales. Understand performance of chain. Loyal Customer identification. Job profile- Created reports for the BI team using Sqoop to export data into HDFS and Hive. Load Data into Pig for Retail Data analysis. Worked with Sqoop to ingest & retrieve data from various RDBMS like Oracle DB & MySQL Created schema in Hive with performance optimization using bucketing & partitioning Written Hive queries to transform data for further downstream processing Retail Data Analysis with Pig. Used partitioning and Bucketing Concept in hive for the faster querying and For dynamic partitioning, load the data in to staging table. Working as a PLSQL Developer at Synergistic Financial Network Pvt. Ltd. (SEP?2019 ? DEC?20). Project Name: Drachma(Hindustan Unilever Ltd). Role: Pl Sql Developer Duration: SEP?19-DEC?20 Job profile- To Create new Procedures as per the requirement and providing with the dashboard reports to the client on daily basis. Working on payment domain need to create DML scripts to handle the transactions of the customers for some manual transactions in case of request from client. Changes in the existing procedures and enhancement of the existing functionality depending upon the payment types and the scheme as per the business requirements. Extensive use of Collections and arrays in the PLSQL Code and Use of Error handling Exceptions and throwing Error messages on the User Interface. Future Goals: To be associated with a progressive organization, where I can apply my knowledge and acquire new skills with a team of highly qualified professionals. I would like to work with the people where hard work and smart work is recognized and rewarded. ________________________________________________________________________________________