PROFILE
Currently associated with Infosys Technologies Ltd. as Technology Analyst having 7.5 years of core technical expertise in Oracle PL/SQL development, Data Analysis, Performance Tuning, Sybase T-SQL development, RDBMS concepts, Python and Unix scripting.
Looking for a career in application design and development with an organization that enables learning and growth.
PROFESSIONAL EXPERIENCE
Infosys Limited
Wipro Technologies
Technology Analyst
Senior Software Engineer
Nov ‘14 to Current
Jul ‘10 to Nov ‘14
CORE COMPETENCIES
6.5 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).
1 year experience as Sybase T-SQL and PowerBuilder application developer.
3 years experience in Unix korn shell scripting, and automating many process through scheduled jobs using .jil files in Autosys.
2 years experience as a Python developer in integrating Python with Oracle using cx_Oracle library and automating tasks such as data load and enabling connection pooling to Oracle database.
Experience of using various Python libraries like Pandas, NumPy and converting the data stored in database to excel files and generate reports out of them.
Excellent interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment, and also handle a small team and work as a module lead.
Involved in consulting and coordinating with Customer regarding specific technical and business needs and writing technical and functional documents defined by business requirements.
Involved in all phases of the SDLC (Software Development Life Cycle) from requirement gathering, analysis, design, development, testing, implementation and warranty support with timely delivery against aggressive deadlines.
Involved in Root Cause Analysis and timely resolution of the issues reported.
Expertise in Client-Server application development using Oracle 12c/11g/10g, PL/SQL, SQL *PLUS, Toad
Effectively made use of Indexes, Collections, and Analytical functions, Table Partitioning, Materialized Views, Global Temporary Table and Sequences and other DB objects.
Good knowledge on logical and physical Data Modelling using ERWIN tool.
Developed database objects to implement complex business logic like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Developed materialized views for data replication across distributed environments.
Experience in Oracle supplied packages, Dynamic SQL, and file handling.
Extensively used Oracle Collections like Nested Tables, Associative Arrays and Variable Size Array(Varray), Bulk Processing, REF Cursors and Bulk Binds
Good hands on experience in working with Java class schema objects.
Loaded Data into Oracle Tables using SQL Loader.
Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB, UTL_HTTP and UTL_FILE.
Experience in SQL performance tuning using Cost-Based Optimization (CBO).
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Good knowledge of implementing Advanced Queues in Oracle and integrating user triggered processes in Queues, thus reducing UI wait time.
Data Migration using impdb and expdb and by chunks using DBMS_PARALLEL_EXECUTE.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab and autosys.
Extensively used advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Created Python scripts to implement connection pooling and enable data load to files from tables and vice-versa.
DOMAIN
Manufacturing
Supply Chain Integration
CURRENT ROLES & RESPONSIBILITIES
In my current position as a Technology Analyst, my primary responsibility is that of a Senior PLSQL Developer.
As a senior PLSQL Developer, I am primarily involved in design and developing procedures and packages to implement the complex business logic.
Develop and provide support to all interface systems.
Coordinate with onsite leads to provide project specifications and gather the technical requirements for all core modules.
Prepare designs for new modules and document all processes to ensure effective evaluation of the modules.
Maintain database objects for various application components.
Design and implement various DB objects and recommend changes on applications through efficient statistical analysis.
Root Cause Analysis and timely resolution of critical issues reported by Customer.
Fix issues related to performance by analysing the explain plans of queries, partition techniques of the tables, and other parameters to suggest or implement changes to enhance the performance of
the application.
Automate various backend processes by creating shell scripts for invoking PLSQL packages and schedule these using crontab and autosys.
Developing basic python scripts to implement features like connection pooling and enable data load to excel files from tables thus generating reports that help to analyse the data.
Lead and mentor a team of 6-7 members and ensure the successful completion of critical modules well within the time frame.
PROJECTS
Supply Planning Tool, also known as SPT, is a Custom standalone Application used by Apple's Supply Demand Management team for performing Short term and Long-term supply planning of Apple's Finished Products.
This Application enables the Apple Supply planners to calculate the finished goods Inventory availability at various Supply chain nodes such as Warehouse, Factory, IN transit etc.
This Supply plan acts as an input to achieve the efficient replenishment to the Channel partners. This application also enables Multi-dimensional hierarchical constrained based planning, managing both global and regional business Sales & Operations planning process.
This Project helps Apple to achieve efficient and effective distribution of finished products from available Supply levels. Currently working on this project.
Vehicle Incentive Management System, also known as VIMS, is a web application which is dedicated to program creation by NISSAN for its various dealers across the globe.
These programs are basically incentive programs for the dealers on reaching certain targets.
CBS 3 is a standalone Windows application used by Continental Tires to automate their tire manufacturing process. It determines the quantities of raw materials required at each step of tire manufacturing. This application used by customer at real time production line to enhance and automate their process of manufacturing tires.
SKILLS
Technology
Working experience in PL/SQL, T-SQL, Python, UNIX, PowerScript
Database experience in Oracle10g/11g/12c ,Sybase 12.5.
SQL Developer, Radar, Espresso, Transmit, Autosys, ERWIN, TOAD, SQL Advantage, PowerBuider 11.5
Version control using Subversion and Gitlab
EDUCATIONAL QUALIFICATION
B.E Biotechnology
2010
New Horizon College of Engineering, VTU, Bangalore (71%)
Class XII
2006
Denobili C.M.R.I, Dhanbad, Jharkhand (73%)
Class X
2004
Denobili C.M.R.I, Dhanbad, Jharkhand (75%)
Achievements
Infosys Star award winner for performer of the quarter Q3, 2015 and Q1, 2017
Received Most Spirited Team award in Infosys in quarter Q3, 2015.
Infosys Wow award winner for performer of the quarter Q2, 2016.
Received FIMC (Feather in My Cap) award for my contribution towards the project. FIMC is a Wipro internal award given to those who excel in their work.
PERSONAL DETAILS
DOB-
PAN
AWKPD8261G
PASSPORT
H-
NOTICE PERIOD
3 months