Career summary

Ph: (513) 808 5425

cnukota@gmail.com

Sr. PLSQL Developer

• 
  Over 9 years of programming experience as an Oracle PL/SQL Developer, have in-depth knowledge and exposure to different types of applications and architectures which include web-based & client-server application development projects in the domains of Health Care, Insurance, Investment Banking, and Financial Services.
  
• 
  3 years hands on experience in ETL mechanisms using INFORMATICA Power Center 8.6/9.1 and Pentaho Data Integration.
  
• 
  2+ years’ hands on experience on oracle forms and reports building using Oracle reports 10g/6i and Forms 11g/10g/6i.
  
• 
  Excellent knowledge of Software development life cycle (SDLC).
  
• 
  Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  
• 
  Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, repository management and administration, implementation of STAR, Snowflake schemas and slowly changing dimensions
  
• 
  Strong experience in Data warehouse concepts, ETL.
  
• 
  Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors, Cursor Variables, Collections, Triggers.
  
• 
  Extensive experience in the database analysis, development and maintenance of business applications using Oracle 10g, 11i, PL/SQL Developer.
  
• 
  Extensively used navigational tools like TOAD, SQL Developer, and Rapid SQL.
  
• 
  Expertise in developing SQL, PL/SQL scripts in oracle distributed environment.
  
• 
  Experience working in waterfall, scrum, and Agile methodologies.
  
• 
  Experience working in Linux/Unix.
  
• 
  Excellent debugging skills on SQL,PL/SQL code issues
  
• 
  Experience in source systems analysis and data extraction from various sources like Flat files, Oracle, Teradata, and Sybase.
  
• 
  Wrote stored procedures/triggers for database operations in Oracle. 
  
• 
  Expertise in Dynamic SQL, Collections and Exception handling.
  
• 
  Expert in Export, Import and SQL*Loader Utilities.
  
• 
  Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  
• 
  Experience in data extraction, data migration and Data loading.
  
• 
  Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
  
• 
  Experience with oracle supplied packages such as DBMS_STATS, DBMS_MVIEW, DBMS_SQL, DBMS_JOB and UTL_FILE.
  
• 
  Good Knowledge in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
  
• 
  Worked on performance tuning of many applications. The most successful project decreased run time of the SQL package for application with complex data extraction from multiple large tables from 30 minutes to 10 minutes.
  
• 
  Experience and Knowledge in using SQL Programmer, Toad, SQL Developer, Clear Case, PVCS,VSS, Putty.
  
• 
  Self-motivated, resourceful and result oriented Team Player.
  
• 
  Having good communication and interpersonal skills, a clear understanding of business rules and the ability to work well as a part of project team.
  

• 
  Designed Technical Documents based on business requirements and followed standards designed by the company.
  
• 
  Involved in Production Support, Problem resolutions and Bug fixing.
  

• 
  Provided 24X7 Production Support for daily regular jobs and monitoring and identifying the root cause of delays in jobs and also preparing scripts for any failures.
  
• 
  Involved in analyzing the root cause for the missing data and providing the missing data from the Extracts for Testing.
  
• 
  Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
  
• 
  Used SQL hints and Indexes as needed to improve SQL performance and used advanced Bulk techniques (FOR ALL, BULK COLLECT) to retrieve and insert the data into destination tables.
  
• 
  Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
  
• 
  Responsible to write scripts which identify the legacy data and the valid data.
  
• 
  Extensively used Cubes & Rollups for making cross tabular reports.
  
• 
  Expertise in handling errors using Exceptions
  
• 
  Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  
• 
  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.
  
• 
  Creating Database specific DDL's for application database and maintain versioning using Tortoise SVN
  
• 
  Creating PENTAHO transformations and Jobs for extracting and loading the data from source to target tables.
  
• 
  Created Partitioned tables using various Oracle Partition methods, Materialized Views, Indexes for easy maintenance.
  
• 
  Developed Oracle procedures, functions and packages to handle various business requirements, for exception handling, data cleansing/consistency.
  
• 
   Pro-actively participated in SQL tuning, Used ANALYZE, DBMS_STATS, EXPLAIN PLAN, SQL TRACE.
  

• 
  Understanding the legacy systems to create requirement and design documents.
  
• 
  Designed and developed Technical Specification and Data Mapping documents by gathering functional requirements from Business Analysts.
  
• 
  Data mapping exercise for migrating data from Sybase to Oracle database. 
  
• 
  Converting PERL, SQR and shell scripts into PL/SQL package for reporting and using Informatica for data staging and loading. 
  
• 
  Analyzing and developing the existing applications which are developed in SQR in SYBASE database and migrating these applications to Oracle DB.
  
• 
  Developed Informatica mappings and workflows to create intermediate data files by integrating data from feeds and database.
  
• 
  Extensively developed UNIX Shell scripts to transfer and archive account files.
  
• 
  Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
  
• 
  Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies. 
  
• 
  Involved in the creation of oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
  
• 
  Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  
• 
  Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
  
• 
  Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows. 
  
• 
  Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables. Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Rank, Update, Router and Sequence generator.
  
• 
  Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
  
• 
  Developed Oracle Stored Procedures to update the data in control tables and account tables.
  
• 
  Maintained versions of code and supporting documents in Clear Case (UNIX) 
  
• 
  Prepared and deployed build from DEV to other environments.
  
• 
  Created AUTOSYS JIL scripts, Control files, Parameter files and UNIX Environmental files.
  
• 
  Coordinated with QA and development teams during System Integration and User Acceptance Testing to accurately resolve the issues.
  

Freddie Mac is a credit union in USA who deals with several kinds of home loans to different individuals in different categories. They have all kind of credits and different logics to give finance guidance to different individuals. Their loan landing business logic really complex and the data flow from different server and the data is highly important and secure. The application is GUI based and Client/server in multi tier functionality. All the verification and validation test and performance testing are highly importance. The application is handling huge volume of sensible data.

• 
  Designed Technical Documents based on business requirements and followed standards designed by the company.
  
• 
  Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  
• 
  Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  
• 
  Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  
• 
  Developed packages for processing data in the staging tables according to the Clients requirements.
  
• 
  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 TOAD.
  
• 
  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.
  
• 
  Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  
• 
  Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  
• 
  Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  
• 
  Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  
• 
  Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  
• 
  Partitioned the fact tables and materialized views to enhance the performance.
  
• 
  Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  
• 
  Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  
• 
  Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  
• 
  Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  

FortisTCI Limited (FTCI) became a wholly owned subsidiary of Fortis Inc. located in Newfoundland, Canada in August 2006. Turks and Caicos Utility Limited (TCU), which is the sole provider of electricity on the Islands of Grand Turk and Salt Cay, was acquired by FTCI in August 2012. FTIC is the sole provider of electricity in Providential, North Caicos, Middle Caicos, East Caicos and adjacent Cays, and South Caicos. Together the two companies serve approximately 120,000 electricity customers in the Turks & Caicos Islands. The Utilities have an aggregate diesel-fired generating capacity of approximately 75 megawatts.

• 
  Interact with the business users to get the requirements.
  
• 
  Analyze the requirements to prepare technical specs from the functional specs.
  
• 
  Developed Design Summary Report to aid the engineers in estimating the total cost of the Project.
  
• 
  Developing and modifying PL/SQL packages, functions and procedures.
  
• 
  Creating and populating table fields by migrating data from different Databases.
  
• 
  Used Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections, and dynamic SQL.
  
• 
  Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
  
• 
  Used SQL*Loader as an ETL tool to load data into the staging tables.
  
• 
  Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
  
• 
  Designed and developed Oracle forms & reports generating up to 60 reports.
  
• 
  Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
  
• 
  Improved query performance by query optimization - tracing the query execution plan (explain plan).
  
• 
  Created partitioned tables, partitioned indexes for manageability and scalability.
  
• 
  Responsible for Migration from one database to another database using Data Pump.
  
• 
  Did Relational Data modeling, and created Data Dictionary.
  
• 
  Set up batch and production jobs through Autosys.
  
• 
  Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  
• 
  Involved in the analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).
  
• 
  Modified SQL statements to increase the overall performance as a part of performance tuning.
  
• 
  Used SQL*loader to load the data from the files provided by the interfacing applications.
  
• 
  Deployed reports in Oracle Application Server 10g AS Portal.
  
• 
  Developed database objects (packages, procedures, triggers, views, etc.) to provide custom functionality within Maximo environment.
  
• 
  Designed and developed Work Order Detail Report, Load Unbalance, Load Reading and Counter Log, List reports using Oracle reports 10g.
  
• 
  Development, Deployment and Maintenance of JSP Reports, ST TOOL and RTview.
  
• 
  Extensively used TOAD and SQL Developer tool for effective application development.
  
• 
  Prepared Documentation of all the errors faced while deployment of reports in Portal, Application server.
  

Forms & Reports 9i, RTview, Oracle Application Server, Windows, Oracle Enterprise Manager.

Developed and enhanced the Window’s based applications for Business and hospital Management team. Applications provide a platform to business team, so that they can understand the database and implement their strategy accordingly. For the Hospital team is helped them to track down their Inpatient treatment history, Insurance history etc.  It is a user-friendly system, which can easily add or open connection for their consumer use and general business purposes.

• 
  Developing and modifying PL/SQL packages, functions and procedures.
  
• 
  Creating and populating table fields by migrating data from different Databases.
  
• 
  Used Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections, and dynamic SQL.
  
• 
  Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
  
• 
  Improved query performance by query optimization - tracing the query execution plan (explain plan).
  
• 
  Created partitioned tables, partitioned indexes for manageability and scalability.
  
• 
  Did Migration from one database to another database using Data Pump.
  
• 
  Did Relational Data modeling, and created Data Dictionary.
  
• 
  Set up batch and production jobs through Autosys.
  
• 
  Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  
• 
  Involved in the analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).
  
• 
  Modified SQL statements to increase the overall performance as a part of performance tuning.
  
• 
  Used SQL*loader to load the data from the files provided by the interfacing applications.
  

• 
  B.S. in Computer Science Engineering
  
• 
  Post Graduate Diploma in Computer Applications