Profile
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.
Certifications:
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.
Projects:
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
Customer: BOFINET (BOTSWANA)
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.
Qualifications
Bachelor’s Degree in Computer Science
Rajiv Gandhi College of Engineering, Chennai
2008-2012 ( 7.00 CGPA)
