Unix Shell Scripting Developer in Chennai, Tamil Nadu, India

• Analyzed, modified, designed, and developed macros and VBA programs to an existing EMPNG spreadsheet.
• Debugged existing macros/VBA and new logic into EMPNG spreadsheets.
• Debugged the conditional formatting and formula issues present in the spreadsheet.
• Worked closely with the customers to purge all of the inappropriate data from the spreadsheet to improvise the performance/response time.
• Analyzed the workflow of the EMPNG spreadsheet and trained the customers on the best practices to prevent any future data issues with the spreadsheet.
• Created new template spreadsheets for new businesses.
• Trained the customers in both Excel and the spreadsheet functions for better performance and any further data issues.
• Worked on sophisticated Excel features like pivot tables, HLookups, VLookups, formula, formatting, and more.

Technologies: Office 365, MS Excel, VBA, Macros

• Gathered requirements from the clients every week.
• Converted the Oracle/MySQL program blocks to SQL Server programs using MS SQL Server Migration Assistant 2012.
• Worked on a line-by-line conversion of Oracle program blocks to MS SQL programs when the SSMA fails to convert.
• Trained a team of developers on SQL Server and PL/SQL.
Designed WIM interfaces for various applications in Kronos WFC.
• Designed and developed batch scripts for all the existing shell scripts and scheduled the new jobs in Windows Scheduler.
• Performed unit testing, integration testing, and performance testing on the MS SQL programs.
• Completed the Oracle/MySQL to MS SQL migration for 65,000 employees without any delays and any post-release issues.
• Created new batch scripts to create files and schedule pay file creation in the MS SQL Server.
• Designed applications using SSIS and SSRS.
• Migrated large datasets using Pentaho ETL. Created APIs using Pentaho.
• Trained in Dell Boomi iPaaS Integration.

• Gathered a design, analysis document from BA and created packages to extract data from the apps and CATS databases.
• Extensively used an Oracle-supplied package UTL_FILE to generate data files in the Unix Server.
• Created directories in databases and used Unix to write data files.
• Wrote shell scripts to run the Oracle programs to create files and transfer to EDW servers.
• Extensively used ConnectDirect feature to establish communication to EDW servers for file transfers.
• Scheduled the entire process in AppWorx scheduler.
• Performed unit, integration, and system testing.
• Prepared MD70 (technical design), did a walkthrough of MD70 and implemented a code review for the RICE components.
• Worked on post-release support activities and change requests.
• Gathered the requirements from clients to implement all the Java code to Oracle packages of the existing system and also designed new features.
• Extensively used types, tab-types, and collection features in Oracle for better performance.
• Led a team of four developers.
• Conducted requirements gathering, status reporting, creating various metrics, and project deliverables.
• Worked on day-to-day customer web-team tickets.
• Computed the statistics features.
• Extensively worked on the performance tuning, query optimization, explanation plan, TKProf, the automatic workload repository (AWR), indexes, and Dynamic SQL.

• Analyzed the existing payroll, income tax, human resources, and provident fund trust and bonus modules.
• Developed new interfaces for payroll, income tax, provident fund, and bonus.
• Improvised and tuned the performance of the existing database system.
• Designed new forms for human resources, payroll, and bonus modules.
• Designed new reports (RDF) for Form-B, Form-C, Form-16, Form-3, annual returns, and PF/EPS reports.
• Worked directly with the customer on requirements gathering and tickets.
• Coordinated all end-user meetings and training sessions.
• Performed unit, integration, and system testing.
• Supported the third-party tool Skorydov for annual returns filing.
• Gained extensive experience in relational database administration, design, development, and implementation using Oracle Developer/2000, PL/SQL, ASP, ASP.NET, and other Oracle tools and utilities.

• Gathered design document from SME’s and designed forms, reports, and PL/SQL packages.
• Created new forms and reports applications based on customer requests.
• Developed extensively on request for change (RFC) for change management meetings.
• Worked on the day-to-day resolution of customer tickets and questions.
• Implemented change initiations and change approvals and delivered products to staging and production systems.
• Prepared change review documents for the change review meetings with the change manager/coordinator.
• Followed GAD QMS (global application delivery and quality management system) quality procedures.
• Designed and developed applications in Oracle Developer Forms 9i, Oracle Developer Reports 9i, Oracle 10g database, Unix Shell Scripting, and Cron scheduling.

• Migrated SQL Server 2016 database objects to MS Access.
• Transferred all of the ASP.NET web forms to MS Access Forms.
• Handled the migration from ASP.NET Reports to MS Access Reports.
• Wrote all of the macros and VBA programs to handle all the logic for the applications.
• Performed comprehensive end-to-end testing of all the forms and reports for the deployment.