CAREER OBJECTIVE:

“To work in a progressive organization that provides an opportunity to utilize my knowledge and skills in order to keep me abreast with latest trends and technologies and contributing in growth and development of the company. ”

SUMMARY:

• 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and Agile Methodologies.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client - Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re-Write.
• Good experience in Data warehouse concepts, ETL.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Dynamic SQL, Records, Exception Handling and PL/SQL Tables.
• Experience with SQL Performance Tuning for Oracle RDBMS using Cost-Based Optimization (CBO), Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab.
• Good Experience in developing Jasper Reports using iReports tool, which is deployed on Jasper Server.
• Novice experience in using Python Lists, Dictionary, Data frame to manipulate and extract data.
• Novice experience in Data Wrangling and Data Manipulation techniques using Python types.
• Good experience in developing Visualizations using Tableau Desktop.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Languages: Python, PL/SQL, SQL, JAVA

Development Platform: Anaconda Distribution - Jupyter Notebook| Spyder, PyCharm, PLSQL Developer, TOAD, Tableau Desktop, Tableau Server, MS Excel, LINUX

Big Data Technologies: Hadoop - HDFS, MapReduce, Pig, Hive, HBase, Sqoop, Spark(PySpark)

Relational Databases: Oracle 10g/11g

Tools: JIRA, GIT, Bamboo, SVN, CVS, VirtualBox, Putty, WinSCP, Desktop Intelligence, SAP Business Object

PROFESSIONAL EXPERIENCE:

Confidential

Skills: Time Series Analysis, Data Wrangling, Manipulation, Visualization and Machine Learning - Python.

Tools: TOAD, Python, Anaconda (Jupyter Notebook), Tableau and Python-Machine Learning Libraries.

Responsibilities:

• For this project module, we used 70% of our production merchant as datasets and performed several data transformation logic.
• By the end of this module, we were able to rank(score/100) our existing TransIT merchants based on their interaction(various factors) with our application.
• Once 70% of merchants were ranked as per their score, we used this data to predict rest 30% Merchant's score.
• This prediction was done using Python Machine Learning - Linear Regression techniques.
• Based on above 2 models, we visually demonstrated various factors affecting merchant score on Tableau Dashboard.
• This analysis was easily used for important decision making, so as to increase revenue of our merchants and indirectly increase the organization revenue.
• Administrator Dashboard was created for organizational reference, based on which we classify top, mid and low performing merchant for that period.
• Based on merchant scoring and predictions, TSYS will identify merchant pain or weak areas.
• These areas will be acted upon by this Merchant Recommendation Engine, which are trained using advise from CRM and Business Analyst and Experts.

Confidential

Skills: Time Series, Data Wrangling, Manipulation, Visualization and Machine Learning - Python.

Tools: TOAD, Python, Anaconda (Jupyter Notebook), Tableau and Machine Learning Libraries.

Responsibilities:

• Later this project was approved, developed, integrated and deployed till production.
• Dealer Management System uses Dealer Sales Forecasting Model so as to predict the sale for all the dealers in Dealer Management System.
• This data is shared with the dealers as well as the CRM team, so that they can necessary actions in case of low performing dealers.
• These data are later transformed in insightful visuals using Python’s Matpotlib and Seaborn libraries.

Confidential

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• 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.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Oracle PL/SQL jobs using DBMS JOB package.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages as per the requirement, using oracle tools like PL/SQL Developer and SQL* plus.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Developed analytical Python Scripts for data wrangling and manipulation of data.
• Created scripts for plotting different kinds of Visualizations using Python Matplotlib and Tableau Desktop.
• Extensively used MS-Excel to perform basic analytics and visualizations.
• Used Tableau Server, WinCVS, Tortoise and Jenkins as Continuous Integration/Delivery tools.
• Consistently coordinating with clients to understand and resolve their queries.
• Good Understanding of Jasper Reports, Tableau Desktop, BO, PRISM, and QC report tools.
• Getting required test environment signoff from client for all major upgrade activity on Production environments, by resolving all the issues rose during testing phase.
• Improving Product Quality by avoiding temporary workarounds and providing permanent resolution for the redundant issues.
• Good Understanding of business terms like Agile Methodology, SLA's and Service Credits.