A. YOVAN RAJ

Plot No: **, F*, *rd street, VGP Prabhu Nagar, Perumbakkam, Chennai, Tamilnadu – 600 100.

Mobile: +91-805******* E-Mail: admf4i@r.postjobfree.com

SUMMARY

I am a Technical Lead with 10+ years of technical and analytical experience. I have strong leadership and organizational skills, and proven problem-solving and analytical abilities. I am SLDC oriented and adept at translating business needs into technical requirements and documentation. My technical strength lies in my ability to use diverse technologies on multiple platforms to perform complex analysis, data mining, query optimization, and full lifecycle development.

10+ years of experience in the Automations, RPA and Macros, VBA field

Excellent communication skills - inquisitive, persistent, strong ‘get ‘er done’ attitude

Ability to multi-task in a fast-paced environment with proven record of consistent results.

Agility – strong grasp on importance of requirement evolution independent of technology

Extensive experience with data management (analysis, mapping, integration efforts)

Diverse background dealing with diverse technologies & platforms.

PROFESSIONAL EXPERIENCE

Presently working as IT Engineer II in DXC Technologies, Chennai from 10th Dec 2007 to till date.

Employed as SOFTWARE ENGINEER in LEGIO INFOTECH, Chennai from September 2004 to November 2007.

Employed as PROGRAMMER in GODS from,

Chennai from 11th Oct 2003 to 4th Jul 2004.

Worked as a Lecturer in St. Joseph’s College Trichy for two Years.

TECHNICAL SKILLS

Programming Languages

Advanced Excel,VB 6.0,C#,VBA,Coded UI

Scripting Languages

VB Script, Java Script.

Markup Languages

HTML, DHTML, XML.

Databases

SQL Server 2000/2005, MS Access.

Web Servers

IIS 5.0/6.0.

Report Tools

Crystal Report, VB Data Report.

Designing Tools

Dreamweaver, Visual Interdev, Photoshop.

Configuration Tool

Microsoft Visual SourceSafe

EDUCATION

Master of Computer Science (66 % - May’ 2001).

(St. Joseph’s College,Trichy - Affiliated by Bharathidasan University)

Post Graduate Diploma in Computer Science and Applications

(65.32% - May’1999)

(St. Joseph’s College, Trichy - Affiliated by Bharathidasan University)

Bachelor of Science (66.98 % - May’ 1998).

(St. Joseph’s College,Trichy - Affiliated by Bharathidasan University)

PROJECTS

Robotic Process Automations (May 2017 – till now)

Cash Application Automation

oCash App team’s primary role is to apply/book payments received from customers based on the inputs received from Bank Statements, Remittance documents, and inputs from Credit & Collections team.

oTreasury books all customer receipts to Bank GL account assigned to respective company code. Cash App team gathers remittance details available bank statement and allocates to the respective Customer account by debiting Bank GL. For those without remittance details; team receives allocation details from Credit & Collections team via email and allocates to Customer account based on the inputs. Once reference document number is generated in C1 for each allocation that marks the completion of the process.

ZMPWBSLST Automation

ZMPWBSLST Automation provides live ZMPWBSLST report from compass R3 which is being to validate the P&L impact instantly. This report is critical in planning additional accruals or deferrals and also supports tracking long and short-term deferrals and accruals. This is one of the most frequently used report since it is for reporting First Day Estimates (FDE) at Cost Stack 9 level.

Billing Blocks Automation

Accounts Payable team needs to download Invoice Block doc reports on a pre-determined schedule to track outstanding line items and trigger mails to buyers to take corrective action. This activity is carried out to ensure payouts go through processing and payout in a timely manner with accurate data.

Bank Reconciliation Automation

Bank Operations Team does reconciliation between GL Account Transactions and corresponding Bank Account transactions. This process is carried out to identify any mismatch between GL and Bank and resolve it. It forms the basis for posting Journal Entries to match GL and Bank.

BANK STATEMENT DOWNLOAD

Using UI Path

HIC – HPFS Input Control (Jan 2015 – April 2017)

HIC (HPFS Input Control) is an information environment, which support the control and management of the leasing charges. HIC is designed to work for contracts which follow the embedded lease IC policy and processes.

Its aim is, to help FAM / EngCOS and Finance in the setup of COMPASS information and reconciliation of 3099 and 1226/3091* accounts and more specifically:

• Prepare a COMPASS plan, in line with the HP EB expectations of current and future lease charges

• Compare the actual charges, which are sent from HPFS to HP EB COMPASS, via IC Equate or IC Pyramid, with the HP EB expectations (as documented in Lease Master File and reflected in Compass Plan).

• Create reports documenting variances between Compass Plan and actual charges received from the IC process (IC eQuate or IC Pyramid) to support their historical tracking and their resolution, via SharePoint shared information and automatic escalation mails.

• Create reports documenting the History of Compass received charges with the charges out bounded from HPFS Pyramid system by comparing the reports from HPFS (Pyramid Business Objects report, start of the flow), with the reports from COMPASS (end of the flow): Historical and E2E transactions reconciliation reports

• Calculate ageing for postings made to 1226 accounted by COMPASS RA Key PS-LCR or 3091 accounted by COMPASS RA Key PS-EML.

*1226 for existing leases until expiry prior to 15th June ’14)

3091 for leases procured from 15th June ’14)

Primary Responsibilities

Leading and Managing seven member Team

Project specification analysis, designing and development.

Application development with Proper standards.

Coded the system using Excel VBA, VBA MS ACCESS and SharePoint 2010.

Using COM objects to incorporate business logic.

Using Advanced Queries and Forms in MS Access 2010.

PMT - Production Management Tool (Mar 2014 – Dec 2014)

Production Management Tool is mainly used for tracking all the activities of each user. It contains three modules, viz., User Module, Production Control Module & Scorecard Management Module. User module contain all information about user like 1x1 discussions, user feedback, seat sharing, leave details etc.

Production Control module is used to capture all the IE (Industrial Engineering) times of employee along with the client request, with the online dash board the Admin can track the status of the requests. The request that is likely to miss TAT, the PL will be notified, hence the PL work is minimized and simplified.

Scorecard Management module is designed mainly for management. They can view all production details of team, vertical and center viz., which helps the senior management for cost cutting and easy decision making. The Customers can also view the reports as required.

Primary Responsibilities

Project specification analysis, designing and development.

Application development with Proper standards.

Coded the system using VB.NET,C#, SQL Server 2000.

Using COM objects to incorporate business logic.

Using Stored Procedure, Triggers and Views in SQL Server 2000.

CLIENT: HEWLET PACKARD, Chennai.

Return Material Authorization Tool (Jan 2013 – Mar 2014)

To Convert the RMA request into editable and Post to RAQS (Return and Quote sys) tool for generating the RMA number

Manual posting of the entire RMA request to RAQS tool for generating the RMA number.

Primary Responsibilities

Project specification analysis, designing and development.

Application development with Proper standards.

Coded the system using C#, ABBY, MS Access 2010,Coded UI

CLIENT: HEWLET PACKARD, Chennai.

Production Activity Control Tool (Jan 2009 – Nov 2012)

Production Activity Control Tool is mainly used for tracking all the activities of each user. It contains three modules, viz., User Module, Production Control Module & Scorecard Management Module. User module contain all information about user like 1x1 discussions, user feedback, seat sharing, leave details etc.

Production Control module is used to capture all the IE (Industrial Engineering) times of employee along with the client request, with the online dash board the Admin can track the status of the requests. The request that is likely to miss TAT, the PL will be notified, hence the PL work is minimized and simplified.

Scorecard Management module is designed mainly for management. They can view all production details of team, vertical and center viz., which helps the senior management for cost cutting and easy decision making. The Customers can also view the reports as required.

Primary Responsibilities

Project specification analysis, designing and development.

Application development with Proper standards.

Coded the system using VBA, MS Excel 2010, MS Access 2010.

Using WinSock Control.

CLIENT: HEWLET PACKARD, Chennai.

Work Flow Management Tool (Jan 2008 – July 2008)

Workflow Management Tool is mainly used for tracking all the activities of each user. It contains three modules, viz., User Module, Production Control Module & Scorecard Management Module. User module contain all information about user like 1x1 discussions, user feed back, seat sharing, leave details etc.

Production Control module is used to capture all the IE (Industrial Engineering) times of employee along with the client request, with the online dash board the Admin can track the status of the requests. The request that is likely to miss TAT, the PL will be notified, hence the PL work is minimized and simplified.

Scorecard Management module is designed mainly for management. They can view all production details of team, vertical and center viz., which helps the senior management for cost cutting and easy decision making. The Customers can also view the reports as required.

Primary Responsibilities

Project specification analysis, designing and development.

Application development with Proper standards.

Coded the system using VB, ASP and SQL Server 2000.

Using COM objects to incorporate business logic.

Using Stored Procedure, Triggers and Views in SQL Server 2000.

CLIENT: MIRRA AND MIRRA Industries, Chennai.

Devotio (The Complete Payroll Solution) (March 2006 – Aug 2007)

Devotio is a Payroll Package dealt with Pay slip Preparation by maintaining the employee’s details like Basic pay, Allowances, Deduction and Attendance with Over Time Calculations. It’s having the features like, Pay slip Designer, Statutory Reports, Effect Date Maintenance, Coin Balance Difference, Denomination Configuration and Over Time Entries. Reports like Salary Comparison statement, Salary consolidation, Salary register, PF Statement and other Forms with ready to provide format. Employee wise salary calculation, employee category wise salary calculation, Designation wise salary calculations are the special features in calculations of allowances and deductions.

Primary Responsibilities

Coded the system using VB and SQL Server 2000.

Using COM objects to incorporate business logic.

Using Stored Procedure, Triggers and Views in SQL Server 2000.

Generating Reports using Intelliview tool.

CLIENT: National Dairy Development Board (NDDB), Tiruppathi.

NDDB Thrift Cooperative Project (Nov 2006 - June 2007)

NDDB Dairy Development Board is the governmental organization running under the control of Ministry of Dairy Development Board. WTC - Women's Thrift Cooperative Project is the NDDB initiated program. It has been implemented and it has successfully entering in to the sixth year. NDDB is having the requirement to develop a window based application. Which will automate the existing manual system involves Member Creation and Information system, Society Creation and information system, AWTC Investments Information system, Staff Maintenance, Meeting details, Thrift maintenance, Loan and Bonus maintenance.

Proposed system covers all the functionalities of the existing manual system with features of n number of Society maintenance, Dual language support and Security settings.

Primary Responsibilities

Analyzed project specification & designed workflow process.

Involved in application development with proper standards.

Coded the system using VB and SQL Server 2000.

Created Trigger, Stored Procedures in SQL Server 2000 database to perform the Data retrieval from multiple tables.

Generated Excel report using BCP utility & System stored procedure in SQL Server.

CLIENT: Green Olive Digital Solution, Chennai (www.godsinfo.com).

Automation Tool for E-Paper (Jan 2004 to Jul 2004)

This product is an Automated Tool for creating E-Paper. The E-Paper project aims at developing a GUI tool for digitizing the newspaper and scientific books. The following are the Processes involved in this project:

1.Pre-Process.

2.Identification of Articles.

3.Jpeg File Creation.

4.Creation of XML Files.

5.Linking.

Primary Responsibilities

Analyzed Clients requirements.

Designed workflow processes and necessary documents for the project.

Application development with proper standards.

Coded the system using Java Script, ASP, SQL Server 2000 and VB.

PERSONAL DETAILS

Date of Birth : 16 – 05 – 1978.

Languages Known : English, Tamil.

E-Mail : admf4i@r.postjobfree.com

admf4i@r.postjobfree.com

Passport Number : Z 2252054

Contact this candidate