Sql Server Manager
Resume:
HARJIT KAILAY
Phone:
Belleville, ON K8N 4Z5
Email:*******@*******.***
I am seeking a challenging position which will allow me to learn new skills and at the same time use my previous development/support experience to be a strong contributor and allow the organization to meet and exceed their goals.
RELEVANT SKILLS
Computer and Technical Skills:
In depth knowledge of PeopleSoft HRMS version 8.9, 9.0 and 9.1
Expertise in People Tools 8.x (Application Designer, Data Mover, PS/Query, Process Scheduler, Application Engine, Configuration Manager, Process Monitor), PeopleCode, SQR, Crystal Reports
Database Applications: Oracle, Microsoft SQL Server, Microsoft Access, IBM DB2, SQL Developer and TOAD
Programming Languages: ASP, SQL, SQR, ColdFusion, Perl Script, Unix, Microsoft Visual Basic, Java, JavaScript, HTML, C, and C++
Operating Systems: DOS, AS400, Unix, Linux, Windows 95/98/NT/XP
Other Applications: Microsoft Office suite, Adobe Photoshop, Visio, Microsoft FrontPage
Web-Development experience with HTML, ASP and ColdFusion
Interpersonal and Communication Skills:
Disciplined work habits with ability to meet deadlines
Able to identify problems and implement effective solutions
Able to prioritize and work independently with minimum supervision
Customer-oriented with excellent communication skills
WORK EXPERIENCE
Enbridge, North York, ON March 2012 – Sept. 2012
PeopleSoft Reporting Analyst
Reviewed query definition in 8.9 and based on impacts recorded in the data mapping / conversion document, upgraded the query so that it produced expected results in 9.1
Liaised with user(s) to gather more detailed requirements if needed
As part of query upgrade, validated data to confirm query was working properly prior to migration
Communicated significant impacts with query users so they could understand how the change affected their work
Provided HR EBS operational support by fulfilling reporting requests as assigned by the Team Lead
Defined reporting requirements for the clients
Wrote and validated queries in PeopleSoft and used formulas and Pivot Table function in Excel to create reports and deliver to clients
Updated project spreadsheet with user requested reports to keep the team informed and also for future reference
Modules worked on: Workforce Administration, Position Management, Time & Labor, Payroll, Pension and Benefits
City of Kingston, Kingston, ON August 2008 – July 2009
Application Specialist
Developed and modified the program code using the Application Designer to enhance reports
Customized People Tools objects like Pages, menus, and People Code
Analyzed the custom SQRs to determine what development was needed to be done to retrofit the new HRMS 9.1 record/field changes into the custom SQRs.
Created, modified and maintained custom SQR programs used by the City of Kingston
Updated, added and deleted data in Oracle database using SQL
Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
Created Permission lists, users, roles and assigned roles to users through Maintain Security
Created an SDE interface to retrieve data from PeopleSoft HR for current and former employees when they phoned the city of Kingston for questions regarding pension, health benefits, etc.
Created unique queries in PS Query for clients as per their needs
Liaised with clients to ensure expectations and needs of the delivered products were being met
Provided support to internal HR and Finance PeopleSoft users
Created documents and spreadsheets using Microsoft Suite (Word, Excel) and used MS Outlook for emails
Nortel Networks, Belleville, ON June 2003 – July 2008
Programmer Analyst
Developed and made enhancements to the Enterprise Solutions Patch Library (ESPL) which is a repository for all patches for internal and external customers. This included designing, coding, testing and debugging using ColdFusion
Implemented changes to ESPL Library Web pages using ColdFusion, Oracle, and Front Page
Updated/Deleted/Inserted/Altered data of tables in Oracle using SQL PLUS
Created web page to allow users to fill in forms to request access to special patches and sent out these requests to administrators automatically
Documented changes and trained users to run queries and reports
Provided support over 500 distributors worldwide for any technical issues with ESPL
Migrated ESPL development and production database servers from UK to Toronto
Supported and Administered ColdFusion Web Server
Evaluated change requests from customers and made recommendations for implementing solutions based on current workload and priority
Sprint Canada, Scarborough, ON June 2000 – Mar. 2003
Programmer Analyst
Customized People Tools objects like Pages, menus, and People Code
Migrated MS Access Reports into Crystal Reports using MS SQL Server Database
Created an attendance application using Visual Basic and Crystal Report to track holidays
Performed SQL back-end queries on Oracle Database
Built tables and views for Oracle database
Customized SQR reports for additional functionality
Supported internal users of various Business Applications including PeopleSoft and Oracle
Implemented changes to the Credits and Receivables Management (C&RM) Web applications using VB Script, ASP and JSP
Developed database applications and reports using Visual Basic, MS Access and MS Excel
Maintained and enhanced approximately 50 reporting applications/databases within CR&M department to ensure departmental efficiency and effectiveness
Leader of a project, which included installing, configuring and testing a server to run in-house applications. Trained internal users to use this server to generate various reports that were fully automated requiring minimal input
Provided 24 X 7 support for PeopleSoft Finance and HR Systems
EDUCATION
Bachelor of Computer Science Graduated in April 2000
Ryerson Polytechnic University, Toronto, ON
Chemical Technician Diploma Graduated in August 1996
Sheridan College, Brampton, ON
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate