CV, Technical IT Consultant Seeking Work In Australia

I am currently available for work
Serial No: 24256

Skills keywords: mssql, payroll consultant, project management., requirements gathering, software developer
Short Bio:

I am currently working as an Analyst Programmer in Ramco Systems, India (Chennai) ! I come with strong knowledge in Human Capital management ( HCM ) modules. I have 2+ years of work experience in IT domain, I started my career as a Technician but currently i am a Techno-Functional handling multiple projects all over the Globe. I have very good hands on experience writing MS-SQL queries and have strong knowledge in Payroll concepts.

Current location: Tamil Nadu, India - View on map
Nationality: Indian
Preferred Sector of Employment:  IT and Technology, HR and Recruitment
Spoken languages: english, Hindi, Malayalam, Tamil
Location I am interested in working: Anywhere


Ambitious and self-motivated SQL developer with a strong Technical Background and 2+ years of work experience in SQL Server 2008/2005. Experience working with Australian Payroll and many other counties too. A payroll expert with good knowledge in both Technical and the Functional. Capable of working with a team as well as individually. Experience working throughout the SDLC of a project. Quick learner with creative ideas. Hard Worker with a desire to use updated MS/SQL skills in the field to assist with achieving goals.

Technical Skills

Languages: MS-SQL, XML, HTML, Transact-SQL

Operating Systems: Windows XP/NT, Safari, UNIX

Microsoft Technologies: SQL Server 2008/2005, Word, Excel, Power Point

Database Tools: Management Studio, Profiler, ERWIN 4.x, SQL Compare.

ETL Tools: ETL Tools Data Transformation Services (DTS) – Export/Import, SQL

Primary Skills: MS-SQL / Java Script

Secondary Skill: PL/SQL

Functional Skills

Ability to communicate clearly and effectively. Understanding customer requirements and proposing new enhancements for product improvement, handling customer evaluation, supporting customers at an engineering level.

A Member of Toast Masters International.

A Public Speaker / Personal Mentor and a Coach.


Ramco Certified HCM Consultant.

Achieved Competent Communicator and Competent Leader Awards from Toast masters International.


Career Summary

Duration : 2 Years and 11 Months
Designation : Analyst/ Programmer
Company : Ramco Systems, India

• Created numerous simple to complex queries, involving self joins, correlated sub-queries, and XML techniques for different requirements.

• Have been a part of HCM Module, which was successfully launched on Cloud as ‘Ramco HCM on Cloud (Human Capital Management)’which compromises of comprehensive HR & Talent Management solution. Good Knowledge in Modules like Employee Induction, Time management, Leave Management, Staffing Solution.

• Excellent in High Level Design of ETL – DTS Packages & SSIS Packages – for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

• Have worked for clients like KPMG, TAFE, Inlakh Computers.

• Have Done MDCF to upload large number of data’s from excel for US PAYROLL, WNS.

• Have been a part of the R & D Department for 6 Months.

• Have been Giving Production Support for Various customers as per their needs.

• As a part of the team, created various Screens, reports according to the business requirements for various projects. Worked as a part of team which developed various HRMS Modules like ‘Timesheet Management’, ‘Leave Management’,’RFH’ in the HCM module.

• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.

• Have Worked in Development of various Statutories for Various Countries like AUSTRALIA, GHANA, PHILLIPINES, TAIWAN, NIGERIA, HONG-KONG, and SOUTH-AFRICA.

• Have been providing continuous support to LIVE Customers in helping them solve the issues.

• Have knowledge about PAYROLL Concepts and have processed Payroll for around 500 employees. Have also coded for computing various tax for calculating Payroll. Knowledge in Writing RULES for tax computation.

• Used the SQL PROFILER tool to monitor the performance of SQL-server –particularly to analyze the performance of stored procedures. Applied Database Tuning and Optimization, Normalization in the new database design.

• Good Knowledge in Server back-Up, Database Restoration and performance tuning.

• Excellent in Creating Stored Procedures, Functions, Triggers.

• Experience in Data Modelling skills ERWIN.

• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.

• Expertise in generating reports using Crystal Reports, RDW and Excel spreadsheet.

• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.

• Have Experience in creating Alerts, SQL Mail Agent, Database Mails (Work Flows).Perform quality assurance and testing of SQL server environment.

• Testing, System Testing, Regression Testing, and Performance Testing.

• Have Prepared Test Cases, Test Scenarios and have provided it to the customers.


Project: Timesheet on Mobile

Customer: Reliance India

Duration: 1 Month

Team Size: 5

Role: Developer

Front End: RVW 2.0

Back End: Microsoft Server 2008

Task: Completed two UI’s independently (View Edit and Approve Search)

Details: Created An Module, with options for the user to Book his Day to day entries via Mobile.Supervisior can log-in and approve or reject the entries of his sub-ordinates. Currently available on IOS and ANDRIOD 4.1(Jelly Bean)

Project: Location Aware Timesheet with Google Maps

Customer: Coke India

Duration – 2 Months

Team Size – 1

Role: Developer

Front End: RVW 3.0

Back End: Microsoft Server 2008

Task: Completed the Coding part, all alone, handled complex queries, procedures, views, along with XML configuration and HTML fonts and styles.

Details: By Integrating with Google Maps, User can turn on his GPS in Mobile and book Entries Jus on Click of various Locations that are mapped to him. Currently available on IOS and ANDRIOD 4.1(Jelly Bean)

Project: WPS

Customer: Sharaf DG, Dubai

Duration – 12 Days

Team Size – 2

Role: Techno Functional

Front End: RVW 3.0

Back End: Microsoft Server 2008

Task: Was Assigned to Generate a WPS for the employees for whom payroll was processed.

Details: With less amount of Time, designed and developed the feature and released it with fewer defects before the Deadline and went GOLIVE successfully. Customer was heavily satisfied on the performance. Acted as a Techno Functional, by interacting with the Customer, and by providing Constant Production Support.

Offshore Support Experience:

Project: Payroll Support

Customer: Stuck On You (Australia)

Duration: 2 Months

Team Size: 6

Role: Technical

Front End: RVW 3.0

Back End: Microsoft SQL Server 2008 / Java Script

Task: Provide Technical Support from offshore to the functional person onsite and provide support during the time of processing payroll. Processed payroll for all employees in their organization.

Details: Supporting the offshore team, in helping the payroll process run smoothly for over 200 employees and providing continuous and tremendous support in achieving the milestone.

Onsite Implementation Experience:

Project: Staffing Solution

Customer: Adecco (BANGALORE)

Duration – From 1st Sep to 31st Sep

Team Size – 12

Role: GO LIVE support and implementation in Client Place. Also was a part of the offshore team which supported the project.

Task: Design and Code UI’s for various screens as per Customer requirement.

Details: When a New Employee Joins a Company, from Employee Data Generation till his separation is recorded. This module helps us to keep Track of the employee data’s.

Project successfully went LIVE on 15th Sep with minimal number of issues.

Project: Payroll Processing


Duration – From 26st Feb to Till Date

Team Size – 1

Role: Training / UAT / GO LIVE support and implementation in Client Place.

Task: Code and process Payroll with tax engine as per their details. Process payroll and provide payslips and provide to the employee.

Details: A complete end to end cycle, starting from training the users to make them use the system fluently. Making them test and use the system frequently and going LIVE on  April 16th.


Bachelor’s Degree in Computer Science
Rajiv Gandhi College of Engineering, Chennai
2008-2012 ( 7.00 CGPA)