Over 15 years of experience in different technologies including Oracle 12c, SQL, PL/SQL, TOAD, SQL Developer, SQL Loader, Unix Shell Script, Teradata EDW, SQL Assistant, SAS, Ab Initio ETL, TIBCO Spotfire, Tableau, Pro*C, Autosys, Oracle Reports, Oracle APEX.
Experience in Support, Maintenance, Migration and Development Projects.
Experience in Database Development, Performance Tuning, Query optimization, Data analysis, Issue investigation and resolution.
Experience in SQL Queries for pulling large volume from Teradata EDW, and create Extraction, Transformation, and Loading (ETL) process using Unix SAS scripts and Ab Initio graphs.
Hands-on with Stored Procedures, Functions, Cursors, DDL/DML, Joins, Inline Views, Indexes, Analytical Functions, Triggers.
Hands-on experience in Teradata EDW, Unix Shell scripts, Cron Job Automation, SAS programming, Ab Initio ETL.
Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, TOAD Data Point 3.6.
Excellent problem solving, multitasking, analytical and critical thinking with the ability to work on fast based environment.
Domain knowledge in Logistics, Retail, Warehouse, Material Management, Insurance.
Received CHAMPION award and Three SPOT RECOGNITION AWARDs.
Logos GlobalTech LLC (Client: Fidelity Investments, Boston) Role: Sr Developer Jul 2019 to Present
Being part of Asset Management data team, involved in requirement gathering, create and walk through on design with client.
Create and maintain efficient programs in Oracle databases including Functions, Procedures, Packages, and adhoc SQL scripts.
Participate in peer code review, DB design review, end to end testing, and validations.
Perform the utPLSQL testing (Unit Testing framework for Oracle PL/SQL).
Used GIT commands and STASH to manage the objects in the repository.
Participate Agile scrum meeting and periodic release meeting.
Present the demo and training on deliverables to the support team as part of sprint release.
Environment: Oracle 12c, SQL, PL/SQL, TOAD, Agile, Jira, Stash, GitHub, Jenkins, udeploy.
ATOS Syntel (Client: FedEx) Role: Sr Developer Dec 2014 to Jul 2019
Data modeling, design, and complete backend ownership for the three web applications called CHART TNT (FedEx TNT merging), CHART WWS (Worldwide sales) and CHART OD (On Demand).
The FedEx counterpart received SHINING STAR AWARD for this project.
The key activities of developing these web applications include:
oDatabase design, Creation of DB objects like Tables, Indexes, Constraints, Triggers.
oCreate and maintain programs in SAS and Unix Shell script to Extract, Transform and Load from Teradata to Oracle.
oAutomate the ETL jobs and automate Statistics gathering.
oOptimize, Performance tuning, Troubleshoot and bug fix.
Supporting web applications by periodic validations and load from Teradata to Oracle using Ab-Initio ETL tool.
Communicate with business stakeholders and provide consultative and technical support for database development tasks including developing KPI’s as well as Adhoc reports.
Automating and maintaining the various validations process that triggers auto email notifications.
Develop SAS and SQL backend scripts to extract and manipulate the data from Teradata EDW and load into Oracle.
Automating the jobs using CRON scheduler utility and Ab Initio control center.
Generate ad-hoc reports using Spotfire visualization tool.
Prepare Graph on Ab-Initio tool for data migration from Teradata to Oracle.
Migrate the ETL process from SAS model to AbInitio model.
Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
Environment: Oracle 12c, SQL, PL/SQL, TOAD, SQL loader, Unix shell script, Teradata SQL Assistant, SAS, Spotfire, AbInitio GDE 3.3
Syntel (Client: State Street Bank, Offshore India) Role: Sr Developer Feb 2014 to Dec 2014
Gather user requirement and coordinate with Service (Java), UI & Testing team to accomplish the development, testing and deployment activities.
Performance tuning on SQL queries by using tuning utilities like Explain plan, Trace Analyzer.
Involved in creating new modules for periodic releases.
Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
Creating Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
Environment: Oracle 11g, SQL, PL/SQL, SQL developer.
Client: Great Eastern Insurance, Kuala Lumpur Role: Production Support Apr 2013 to Jan 2014
Understanding the Reporting design requirements from the Architects and Business Analyst.
Interact with SME's and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
Maintain and Enhance the DCMS (Distribution Channel Management System).
Developed reports and some end user request reports on periodic basis.
Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports.
Performed Production Support, Troubleshoot and Defect fix.
Resolving performance issues and fine-tuning queries.
Served as technical expert guiding choices to implement analytical and reporting solutions for complex scenarios.
Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of SQL.
Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
Perform Enhancement, testing in SIT/UAT then coordinate production deployment.
Environment: Oracle 11g, SQL, PL/SQL, SQL developer, Autosys and Oracle Reports.
Vinculum Solutions (Client: HERO / GIANT Retail, Southeast Asia) Role: Sr Developer - Data Migration Jul 2010 to Mar 2013
Data migration that Involves data conversion and migration from the legacy RMS system to LSMW of a new SAP system.
The requirement was to extract data from customized RMS and conversion of data as per SAP supported business logic & Transform to the SAP system.
Analyzed data and tuning of scripts and involved in writing Oracle procedures, functions, packages, SQL loader scripts, and Unix shell scripts for incremental data extraction and implementing ETL logic for validating, manipulate, enhance, compare.
Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
Enhanced, developed and deployed reports based on new requirements for a separate module maintaining the standard of the layouts, data model.
Created PL/SQL packages for moving the data from staging table to the main tables.
Used Oracle utility tools, SQL * Plus, PL/SQL Developer, SQL * Loader.
Created Tables, Indexes and partitions. Developed Sub queries and Joins to retrieve the data.
Developed Procedures, Functions, Triggers and Packages as per the business requirements.
Created Views, Materialized Views, Synonyms and Sequences in Oracle.
Used SQL loader to load data into Oracle tables as per user requirement.
Involved in tuning the code where necessary by using performance-tuning techniques.
Worked on assigned incidents and defects during job failures.
Used Bulk Collections for better performance for fetching the data from the staging table and moving to the main tables.
Involved in release activities and deployment process and documentation.
Performed migration of objects from DEV to UAT and PROD environments.
Involved in Production Support fixing job failures issues and defects during off Peak hours.
Environment: Oracle 11g, PL/SQL, SQL loader, TOAD, XML, and Unix shell scripting.
Cognizant (CTS), India Role: Application Support Mar 2007 to Jan 2010
Involved in Application Maintenance and Support for leading US based Retail (Franklin Covey and Radio Shack).
The overall scope of the project consists of transition and delivery of Application Maintenance, Production support for RCOM (Retek Customer Order Management) applications under the Consumer Direct organization using COGNIZANT onsite-offshore model.
Conduct feasibility study and estimate the hours/work effort required for new developments and enhancements.
Business Requirement gathering, prepare and maintain Technical specification documents, customize/enhance/test database Packages, Procedures, and Views.
Periodic Job monitoring and amend the scheduled jobs using JIL commands in Autosys.
Designed and developed PL/SQL Packages, Procedures and Functions.
Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements using Oracle Forms.
Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, functions, procedures, packages, triggers and cursors.
Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
Extensively used SQL Loader, UTL_FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
Developed Complex UNIX shell scripts and Autosys jobs for scheduling and automation of the application jobs execution.
Support modules for implementation using PL/SQL scripts, UNIX shell scripts and Pro*C.
Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
Created several interactive reports and enhanced the existing reports with controls in Oracle Application Express (APEX).
Environment: Oracle 10g, PL/SQL, TOAD, Pro*C, Unix shell scripting, Autosys
Bin Dawood Group of Superstores, Jeddah Saudi IT Support Oct 2005 – Oct 2006
MIS with unique reporting tool called RETAIL IDEAS with JDA on AS/400.
Develop Views (Generic format of data saved globally & shared among users).
Generated matrix reports, drill down, sub reports, multi parameterized reports.
IBM AS/400 i5 Server Operations such as Backups (Entire Server, Periodic, daily & weekly), Patch Installation, perform Reclaim storage commands & IPL (Initial Program Load).
Daily health checks for Date change, Active Jobs, Log Files, Job Queue, Clear OUTQ, Active Disk Storage.
Develop/maintain documentation for AS400 Operations, checklist & procedures.
Sales data processing for branches through JDA.
Inventory data processing and generate various reports.
Interacted with business users at various levels and converted their business requirements into technical specifications.
Created Oracle Apex application from scratch and also involved in enhancements and customization of existing application.
IIT Kharagpur (Client: Neyveli Lignite Corp), India PL/SQL Programmer June 2002 – Sep 2005
Part of the OLIMMS (“Online Material Management System”) project developer for NLC, Govt of India.
Involved in periodic meeting with SME from various department / units of the Industry and Gathered business requirements.
Involved in Data collection, Renovation, Segregation and established Material Master Tables.
Analyzed COBOL-based legacy data and prepared Migration plan.
Involved in Source data analysis, Data Mapping and Data Population by creating various stored procedures.
Involved in physical database design, data sourcing and data transformation, and data loading.
PL/SQL development like stored procedures, functions, cursors, Joins, Inline views, correlated sub queries.
Used Bulk Collections for better performance, reducing context switching between SQL and PL/SQL engines.
Master of Science in INFORMATION TECHNOLOGY, Alagappa University, India.
Bachelor of Science in COMPUTER SCIENCE, University of Madras, India.
Oracle OCA - SQL 9i