Candidates About

 

Kripakaran Jayakumar

PROFESSIONAL SUMMARY:

§  Over 8+ years of Information technology experience including all aspects of application life cycles.

§  Expertise in Oracle database application programming ( PLSQL,SQL)

§  Expertise in Database performance tuning, SQL tuning.

§  Proficient in Data analysis, Data modeling (Physical and logical), including ER diagrams, DFD (data flow diagrams) and Database designing.

§  Expertise in Complex SQL queries.

§  Expertise in application development using oracle plsql.

§  Experience in server side scripting using Python 3x, PERL 3x.

§  Knowledge of shell scripting.

§  PERL to PYTHON code conversion.

§  Familiar with JSON and XML based REST web services using PYTHON.

§  Experienced in Unit testing and integration test.

§  Worked on development of in house ETL tools, ADLS and PTL.

§  Having knowledge of Data warehousing concepts and normalizations.

§  Functional Expertise in RETAIL domain.

§  Functional knowledge in HEALTH CARE, SCM domain.

§  Expertise in tools like TOAD,PLSQL DEVELOPER,SQL DEVELOPER, Python IDE,PyCharm

§  Expertise in SQL loader.

§  Performed role as technical lead for a team of technical associates.

§  Understanding of Django, html scrapping.

§  Support engineer for DevOps and support team.

 

Skill

        Domain Worked                          : RETAIL, HEALTHCARE, Ecommerce

        Database                                                  : Oracle 8i, 9i, 10G, 11G

        Language                                   : PL/SQL, SQL, Python 3x, Perl 3x, Basic knowledge of UNIX

        Tools                                          : Toad, Oracle SQL Developer, SQL loader, PyCharm,IDE

        Version Management Tool          : CVS, SVN.

        Job Monitoring and Scheduling  : CA workload center, Autosys.

 

PROFESSIONAL EXPERIENCE:

New York State Department of Health                                                                       Nov 2014 - Present

Oracle PL/SQL /Python Developer,

 

Project: New York e HIV Management Systems

Role: Technical lead developer/development engineer

Key Project Highlights:

§  Created REST web service requests using python.

§  Created analytics module using python.

§  Worked on large file structures for analytics and ftp of files to CDC using python.

§  Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements.

§  Create and maintain Database objects.

§  Design and automate SQL LOADER scripts for data ingestion.

§  Integrate and manage data flow between external systems and the application. 

§  Optimized the Oracle SQL queries by Performance Tuning.

§  Working in data analysis & data cleansing.

§  Directly involved in process improvement plans and implementing business change

§  Data Migration from Legacy Systems.

 

Walmart.com/Cognizant Technologies                                                                                May 2011 – Nov 2014

Oracle PL/SQL /Python Developer

Project 1: Fraud Migration

Role: Technical lead developer/development engineer/SME

Key Project Highlights:

§  Created High level/Detail design document

§  Created Architecture/Order lifecycle design document for the integration between multiple modules

§  Created Data modeling, logical Modeling, and Data migration of legacy data.

§  Innovated the risk calculation and rules methodologies.

§  Served as technical Lead in the completion of coding and integration

§  Developed and test PL/SQL  APIs used to integrate with vendors

§  Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements.

§  Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.

§  Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF and AUTOTRACE.

§  Prepare deployment scripts for Production and UAT environment and coordinate code release with release management team

§  Perl /Python enhancements.

§  Identification of condition of the rules through data analysis.

§  Contributed to 20% increase in identification of fraudulent orders.

§  SME of payment processing module of walmart.com

§  Python scripts for data transfer

 

Project 2: Pay In Cash

Role: Development engineer, Architect

Key Project Highlights:

§  Built a new payment type for walmart.com

§  Created Detail design document, and integration design.

§  Developed APIs to change the order flow cycle, integration and finance reports

§  Acted as a SME for future enhancements.

§  Performed Performance tuning using Explain Plan, Partition, index management, Hint, Pipelined Functions, Bulk Bindings etc .

§  Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF and AUTOTRACE.

§  Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements

§  Member of the team for the Patent filed by walmart.com.

§  Contributed for annual increase in sales by $28 million.

§  Batch File processing using Python for generation of reports to Finance Teams

Project 3: CPE/DevOPS support

Role: Support Engineer,Development engineer, SME

Key Project Highlights:

§  Created complex reports for DevOPs team using complex SQLS and Python.

§  Supported CPE team (Support Team) with day to day activities.

§  Acted as a SME for payment processing module of Walmart.com

§  Trained DevOPS and CPE teams on new enhancement features.

§  Involved in creation and maintenance of solution documents, which will be referred by support team in case of emergency.

§  Involved in 24 hours support of new enhancements

§  Worked on JIRA, Remedy 6.0 applications for maintenance of remedy documents.

Project 4: Auth Reversal

Role: Development engineer

Key Project Highlights:

§  Risk analysis, Data Modelling.

§  PERL / Python enhancements.

§  Integration of new action with payment gateway.

§  Customized in house ETL process with python and Database API changes

§  Contributed 3% increase in come back customers

§  Designed and developed scripts for data import and export and conversions.

§  Involve in Code development/customization and take care production and UAT bugs.

Project 5: Golden gate Performance Tuning

Role: Development engineer

Key project Highlights:

§  Performance tuning using  STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR 

§  Understanding of AWR reports.

Project 6: Perl to Python Conversion

Role: Python engineer

Key project Highlights:

§  Conversion of legacy perl codes to python.

§  Enhancements using python scripting.

§  Used python to extract credit card billing information from different CC vendors to be processed by Finance Teams. 

§  Edit card billing information from different CC vendors to be processed by Finance Teams. 

§   

SONATA SOFTWARE LTD                                                                  Mar 2010 - May 2011

Application Developer / Analyst,

Key Project Highlights:

§  Analyzed all business functionality related to back end database interfaces.

§  Developed technical specifications for various back end modules from business requirements. Specifications are done according to standard specification formats.

§  Developed technical specifications for various back end modules from business requirements. Specifications are done according to standard specification formats.

§  Worked with DBA in making enhancements to physical DB schema. Also   coordinated with DBA in creating and managing table, indexes, table spaces, triggers and privileges.

§  Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, triggers, Shell scripts

§  Developed shell scripts to kick off back end PL/SQL, SQL programs.

§  Developed screens and reports using Oracle PL/SQL

§  Utilized SQL*Loader to load flat files database tables.

§  Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.

§  Utilized PL/SQL, TOAD developer tool in developing all back end database interfaces.

§  Designing front end using PL\SQL Cartridges.

§  Responsible for performing code reviews.

§  Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.

§  Also responsible for unit testing, and documentation of the interfaces. Also utilized version control software PVCS/M-Files and make utility

§  Supporting for production releases.

 

 

 

QUINTILES TECHNOLOGIES                                                               Aug 2008 - Mar 2010

Programmer Oracle PL/SQL,

 

Key Project Highlights:

• External Tables
• Mapping
• Loading of data from external files (ADLS)
• SQL queries, PL/SQL blocks for generation of reports.
• Database Object Creation

• • Table
  • PL/SQL Program Blocks
  • Indexes
  • Triggers
  • Sequences
  • Scheduling (DBMS_SCHEDULER)

• File handling operations.
• SQL explain Plan and TKPROF

 

One APPS Enterprise Technologies PVT ltd                                          Jan 2007 –Aug 2008

Oracle PL/SQL Developer,

 

CANTEEN STORES DEPARTMENT – Indian Army

Key Project highlights:

• Writing the required PL/SQL procedure for the modules Personnel, Admin, Inventory, Finance and Accounting.
• Involved in getting functional requirements for FA,PER,ADM,CNC modules
• Writing the required FUNCTIONS and TRIGGERS for the modules Personnel, Admin, Inventory, Finance and Accounting.
• Involved in developing user interface using FORMS 10G for all the modules – (Personnel, Admin, Inventory, Finance and Accounting) for head office level applications.
• Involved in Functional Analysis of the project by coordinating with Business analysts.
• Involved in doing the validations for the forms created.
• User log in and log out password encryption and Decryption
• Involved Session variables creation
• Involved in creation of business logic and table creation for personal and administration modules.
• Data migration of all the setup data from legacy application.

§  Integration of schema object scripts from all the modules

 

CONTROL OF DEFENSE AUDIT (CDA)

Key Project Highlights:

• Involved in the costing and claims (CNC) module of the project.
• Writing the required PL/SQL procedure for the module.
• Creation of the forms and reports on 10g
• Involved in doing the validations for the forms created.

 

EXIDE ERP

Key Project Highlights:

• Involved in Customization of the already existing application.
• Forms 10g
• Customization included adding of application for incentive calculation.
• Involved in creating a concurrent program for incentive calculation.
• Involved in writing packages and functions for the same