Srinivasan

Pichaimuthu

**** ***** ***** **, ********, TN 37067

615-***-****

adill9@r.postjobfree.com

www.linkedin.com/in/itspsrini/

Software professional having 16+ years of experience and proven ability in architecting and developing solutions. Proven track record in diverse domains such as Automotive, Supply chain management, Finance and Telecommunication projects.

Played various different roles such as, Technical architect, Senior PL/SQL Developer, Subject Matter Expert (SME), Systems Analyst, Software Consultant and Programmer Analyst.

Excellent knowledge, understanding and proficiency of the Full Project Development Life Cycle including design, development, implementation, and support.

Adept in a variety of platforms including ORACLE 12c,11g,10g,9i,ORACLE FORMS and REPORTS, UNIX Shell Scripting,XML,XSL,JAVA SCRIPT.

Experienced in identifying Business and Technical requirements. Good Knowledge in Database Design, Troubleshooting and writing interfaces between various applications.

Expertise in various Oracle utilities like SQL*Plus, SQL*Loader, PL/SQL, Data Pump Export and Import, DBMS_SCHEDULER, TOAD, ORACLE SQL Developer.

In-depth Knowledge in Normalization techniques, Dataflow Diagrams and proficient in Oracle SQL Tuning and PL/SQL Debugging. Experienced in C, C++, Python, and Perl. Good knowledge in Informatica, Data warehouse concepts-Star Schema, Snowflake, Surrogate keys.

Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements and business problems and design/implement innovative custom solutions. Customer-focused, highly organized self-starter who excels at managing projects, collaborating with project teams, interfacing with clients and deploying technology to build successful solutions for clients.

Experience

Aug 2015 – present

Senior PL/SQL Developer /Subject Matter Expert: Nissan North America HQ, Franklin USA.

(B2C –Pre-Sales Applications)

Responsible for designing and implementing end to end solutions for back end integration to support Nissan’s various B2C (Business to Customer) Pre-Sales, After-Sales websites.

Design and Development of DB modules (Coding of PL/SQL Stored Procedures, Packages, Functions and Triggers) and implement back end batch jobs and provide ETL Solutions.

Successful completion of the Oracle Database migration from CTL (CenturyLink) Cloud to Oracle Cloud OCI (Oracle Cloud Infrastructure).

Major contribution towards the Oracle Database upgradation project (Oracle 11g to 12c).

Extensively worked on the B2C Application servers and Batch servers’ migration from CTL Cloud to AWS Cloud Environment.

Co-ordinate with Business Analysts, Senior Data Architects, Enterprise Architects, external vendors and the offshore team for the Development and Support activities .

Ensure that the data transfers and load between Nissan and external vendors are secured and as per standards using SQL*Loader and DATA PUMP utilities and Scheduling the jobs in CRON as per business requirements.

Housekeeping of the database/job servers, automating the batch monitoring activities, intelligent email alerts reporting, health check status of the application, dashboard reports.

Jan 2012 – Jul 2015

Senior Developer: NNA Offshore Development Center, Chennai, India.

(DPTS Systems)

Understand and prepare the Requirement specifications for the Applications enhancements for DPTS- Systems of NNA.

Perform Database restore activities using Oracle Data Pump import and Export utilities IMPDP, EXPDP.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Interact with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote Stored Procedures using PL/SQL. Involved in writing the Database Triggers to furnish the audit details.

Created SHELL Scripts for invoking Oracle SQL scripts, PL/SQL Subprograms and scheduling them in CRONTAB.

Extracted data from relational databases DB2, Oracle and Flat Files.Developed data Mappings, Transformations between source systems and warehouse .Developed Data Quality check mappings on top of Target mappings.

Experience in using the Informatica command line utilities like pmcmd to execute workflows through UNIX shell scripts

Tech Lead: NNA Offshore Development Center, Chennai, India. (LEASEPAK Systems)

Development of the SHELL scripts for the XML files conversion into other required formats like XML, CSV, RPT files using the XSL files.

Unit testing of XML files and the XSL scripts that converts the XML data into different formats. Integration testing of the LEASEPAK components with SAP and DEALER TRACK systems.

Used SQL HINTS to direct the Optimizer to choose optimum query execution plan.

Used BULK COLLECT, FOR ALL collections for better performance and easy retrieval of data.

Created PL/SQL Stored procedures to extract the data from Operational Database into Flat Files using UTIL_FILE Packages.

Created RECORDS, tables COLLECTIONS (nested tables and arrays) for improving query performance.

Jan 2009 – Dec 2011

ETL Lead: CITCO GROUP LIMITED (Offshore Development Center), Chennai, India.

(Citco - NEXTGEN Data warehouse Systems)

Load the CITCO DWH from source systems by developing the necessary ETL loads based on the CITCO Data warehouse and source models.

Development of custom DB objects like Oracle Packages, Stored procedures and Functions etc. .

(APRA - Australian Prudential Regulation Authority)

Worked on the integration of the B2B logic with the new Portal front-end and the ESB using XML schemas and PL/SQL.

Development and Support for the DB objects like users, roles, packages, procedures, functions to the Java Layer and Unit testing of the packages.

Used REF CURSORS to enable the records set to be displayed online effectively. Creating test scripts to test the packages.

Nov 2004 – Dec 2008

Offshore Lead: FORD DIRECT STOCK EXCHANGE (Offshore Development Center), Chennai, India.

(FDSE -Ford Direct Stock Exchange)

Ford direct stock Exchange (FDSE)/Web Selling applications enable Dealers to purchase premium used vehicles direct from Ford. This provides dealers with the ability to purchase re-marketed vehicles through various buying mechanisms.

Understand and prepare the Requirement specifications for the enhancements. Development of pseudo code according to business requirements.

Development of Stored Procedures and Functions with the extensive usages of Object Arrays.

Supported these applications by developing and modifying Packages, writing UNIX SHELL scripts, Scheduling Cron jobs and creating database objects.

Used REF CURSORS to enable the record set to be displayed online.

Technical writing that included Unit Test Plans, Database Code Reviews, Test Cases and Report Code Review documents.

Developed SQL scripts to extract data from the database based on the user requirement.

Jan 2004 – Oct 2004

Senior Software Engineer CISCO SYSTEMS (Offshore Development Center), Secunderabad, AP India.

(CISCO-Q2C- QUOTE TO CASH MIGRATION)

The work involves the development of Custom APIs, Packages, and Reports. ASIS analysis, documenting the current functionality of the existing API Packages, Reports.

Developing the Technical Design Documents for the upgradation of those to 11i for the APAC region.

Responsibility included understanding the ETL process, study the flow of the existing AUTOSYS jobs and Linux shell scripts.

Created audit tables and triggers for all existing and any new tables in two schemas.

Used SQL hints and Indexes as needed to improve SQL performance.

Schedule Oracle jobs for update, validate data and create vendor reports for analysis and Monitor ETL jobs.

Troubleshoot/Resolve any Database/Application issues.

Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.

Developed PL/SQL Triggers to monitor the database activities and to implement complex database constraints. Extensively used UTL FILE to read and write files that are located on the server.

Technical Expertise

OPERATING SYSTEMS: WINDOWS 10/7/XP/98/NT/2000/XP/7.0/10, Solaris 5.8, UNIX, Linux.

RDBMS: ORACLE 12c/11g/10g/9i/8i, SQL Server 2008, DB2 UDB.

LANGUAGES: SQL, PL/SQL, HTML, XML.JAVA, C++, C

TOOLS: TOAD 9/10, Oracle Developer, SQL LOADER, Informatica 8.x (Power Center), WS-FTP, Notepad ++, Text Pad, Araxis Merge, I2 Factory Planner, DBMS_SCHEDULER, DBMS_JOB, CRON, PUTTY., BMC Remedy, HP Quality Center, Service Now, Autosys. JIRA, Confluence.

SDLC METHODOLOGIES: Waterfall, Agile

VERSION CONTROL: Visual Source Safe, SVN, Bitbucket

DESIGN /GUI TOOLS: Oracle Forms Reports 6i/10g/11g.

SCRIPTING LANGUAGES: UNIX SHELL Scripts, XSL, Perl, JavaScript, and Python.

Education

APR 2002

Master of Computer Applications (MCA)/Barathidasan University, TamilNadu, India

Contact this candidate