Objective
To associate myself with an Organization that will provide me an opportunity to portray my technical skills, improve my knowledge with learning environment and to be part of the team that works dynamically towards the growth of the Organization.

Professional Summary
    • Currently working with Societe Generale as Database/DWH Developer.
    • Senior DWH/ETL Professional with 7.10 years in analysis design and Implementation of ETL process using PL/SQL , EXADATA , Oracle SQL , SQL LOADER and Unix Shell Scripting.
    • Experience in automating manual processes (Reports, Customizations, manual processes like Deployments and frequent service requests) also Data visualization using Tableau and Python.
    • Worked on Oracle Data warehouse using PL/SQL Cursor, Views, Materialized Views, DB Triggers, Stored Procedures, Functions, Packages, and Collection Types and Bulk Collect etc. Good exposure to PL/SQL Query Tuning.
    • 7 Months of Onsite experience at IKEA of Sweden, handling client meetings, client requirement gathering, acting as the lone point of contact between offshore and client. Solving client queries and issues with the application in real time. 
    • A team player with effective communication, interpersonal, relationship management and analytical skills. Experience of working under cross-cultural environments. 
    • Experience with automating the processes while working in a DEVOPS model using UNIX.
    • Hands on experience with Core Java.

Key Skills:
    • Data visualization, Data profiling and Data Quality Management.
    • Business Analysis and Requirement Gathering.
    • Data Integration, Data Modeling and Data Warehousing Concepts.
    • Client Presentation and Team Management.
    • Customer Relationship Management & IT Software Project Management.

IT Skill Set:
    • Operating Systems: Windows Platforms, UNIX, Red hat Linux.
    • Technologies: Shell Scripting, Big Data (Hadoop, Hive) (Basics) , AWS, PL/SQL, Python.
    • Tools: SQL Plus, SQL developer, Toad, IBM B2B sterling integrator (ETL)
    • Scheduling Tools :  Cisco Tidal and Automic UC4 / One Automation
    • Visualization Tools: Tableau 2018.1, Qlikview 12.01, MS Excel Professional

Professional Experience
Organization: Societe Generale
Duration: April 2017- to present.
Role: Senior Software Engineer
Domain: Finance
Technology: Oracle PL/SQL 11g,12c, Exadata and Unix Shell scripting, Automic UC4,Tableau
Responsibilities:
    • Managing Task allocation and their successful delivery by team member. 
    • Onboarding of new team members and performing Knowledge transfer to them.
    • Creation of SQL Loader scripts and External Tables Loading of Source files to Staging.
    • Coding of PL/SQL packages, stored procedures, functions for extracting, transforming and loading of data from files to corporate warehouse.
    • Creation and enhancement of BOXI reports build on top of Trade repository for Client reporting. Documenting ETL mappings, created technical specification, unit test plans and involved in developing deployment plan along with deployment package in Jira / ServiceNow.
    • Creating UC4/One Automation workflows to schedule new PLSQL and Unix Jobs.
    • Responsible for Coordinating with the Business user [EMEA / NA /HNK / Singapore] to finalize requirement and performing Testing as well as UAT bug fixes.
    • Creation of feeds for bank regulatory like HKTR / BOI / DFA / IMVM / 871M etc as per requirement.
    • Creation of reports, scheduling them and sending them as per the requirement using Tableau.

Organization: Accenture.
Duration: August 2015 – April 2017.
Client: SIRIUS XM Satellite Radio (CMT)
Role: Application Development Senior Analyst
Domain: Supply Chain
Technology    : Oracle PL/SQL 11g, Unix Shell scripting, Cisco Tidal, IBM B2B Sterling Integrator
Responsibilities:
    • Preparation of Technical requirement documents and preparing and executing Unit test cases after coding is complete.
    • Development of PL/SQL UNIX Shell scripts and Performance tuning of SQL scripts. 
    • Handling IBM B2B sterling administration part. Looking into any business process failure and troubleshooting it. Also maintaining high availability of our ETL tool.
    • Automation of Manual processes and reports.
    • Job scheduling and administration using CISCO Tidal.

Organization: Genpact-Headstrong Capital Markets.
Duration: March 2015 – August 2015.
Client: Credit Agricole Corporate and Investment Bank (CA-CIB)
Role: Senior Software Engineer
Technology    : Oracle PL/SQL 11g, Unix Shell scripting, SUMMIT
Responsibilities:
    • SUMMIT Tool support
    • Developed PL/SQL Packages and scripts in Oracle.

Organization: HCL -Technologies.

Duration: Nov 2011 – Feb 2015.
Client: IKEA (Retail)
Role: Software Engineer
Domain: Supply Chain
Technology    : Oracle PL/SQL 11g, Unix Shell scripting, C#/.NET
Responsibilities:
    • Worked as BA for our application.
    • Preparation of Business requirement documents and Technical requirement documents.
    • Developed PL/SQL Program and performed SQL Tuning 
    • Develop UNIX Shell Script as per the business requirement.
    • Bug Fixing and UAT support for various modules, perform SIT and ORT.
    • Go Live and Post Go Live support.
    • Troubleshooting Data issues and providing timely solutions to them. 

Achievements / Extracurricular activities
    • Best new joiner award HCL-2011.
    • Awarded with ACE awards in Accenture for 2 consecutive quarters for adding value to client.
    • Awarded with Spot Award within 3 months of joining Societe generale for delivering High performant code for complex requirement.
    • Awarded for photography in Societe Generale for covering official functions.
Strengths
    • Strong commitment and dedication towards work.
    • Positive attitude towards life.
    • Ability of team work and leadership quality.
    • Always willing to learn. Currently taking online trainings on Machine Learning and Python.
    • Quick grasping of concepts.

 Educational Qualification 
    • B.E. in  Electronics and Communication (2007-2011) with 73% aggregate with Distinction
    
          University      :  VTU, Belgaum.
                 College           :  Guru Nanak Dev Engineering College, Bidar, Karnataka.

    • Secondary & Higher Secondary Education Record