Developer Data
Resume:
Sukhbir Singh Goraya
Surrey BC
V3W3X7
*******.*****@*****.***
Skills
IT professional with 8.5 years’ experience specializing in Data Oracle. My greatest strength is Business awareness. It helps me streamline application. I am very dedicated towards work and always work hard towards excelling at the task in hand. I have good leadership qualities. Positioning team members to make optimal use of their talents. Highly skilled and experienced PL SQL Developer with wide knowledge of a variety of programs and procedures.
●I have around 6.5 years of Industry experience in implementing and supporting web based applications/Oracle and 2 years in Mainframes with Infosys. My career profile includes leading multiple Web Applications while performing activities like, Requirement Gathering, Effort Estimation, High Level and Low Level Design & Development, Test Case Review, Deployment & Warranty Support.
●I have played the role of Acting Manager, Team Lead, Technology Lead, Technical Analyst, Track Lead and Developer over my career span.
●I have excellent problem solving skills. Effective working skills to ensure project completion on time with minimal defect rate.
●I have hands-on experience in developing and implementing strategic IT applications processes, procedures, and decision support, Hands-on experience with business requirements gathering/analysis.
●I have provided support during almost all development deployments and has proven expertise in troubleshooting production support defects under time pressure.
Experience
1.)Project Name
WellPoint(CHIPS)
Client
WellPoint - West Virginia
Role
System Engineer
Job Location
Pune, INDIA
Duration
Start date: July, 2011 End date: August, 2012
Software
SQL Developer, COBOL, JCL, Online / Batch job Processing, IMS DB, DB2, Putty.
Responsibility
●Have written a lot of one-shots during the same period.
●Was involved in requirement analysis, design, coding, unit testing and defect fixing.
●Identifying the manual work and automating those using different technologies and frameworks using Infosys Data Services Solution (iDSS);
●Providing production support for daily batch operations for various systems using IPSP tool;
●Interact with customer and participate in business and system requirements sessions
●Requirement gap analysis and transforming the functional specs into technical specs
●Functional and Technical Testing.
●Responsible for delivering the project as per customer requirements within the given time period
●Creating Knowledge management repository to share between team members using KSHOP.
2.) Project Name
Citi Bank- Support
Client
Citi Bank
Role
Senior System Engineer
Job Location
Pune, INDIA
Duration
Start date: August, 2012 End date: July, 2014
Software
Putty, Microsoft Excel, Microsoft Office, MYSQL, PL/SQL, WinSCP, Filezilla, Putty
Responsibility
●I was responsible for the schema creation and liaising with different teams from different geographies for the data. We followed Agile Methodology.
●Participate in creating application architecture document to provide deliverables in line with architectural requirements.
●Deliver high quality code deliverables and supports peers in quality checks
●Create Knowledge management repository to share between team members using KSHOP.
●Created Estimations for new development and enhancements by following ESTEEM which is a customized Infosys function point estimation methodology.
●Implement ticket resolution and other such IT service management activities through robotic operations using Infosys automation platform (IAP).
●Participate in KT sessions from different team in different geographies.
3.) Project Name
Carefirst (PCMH)
Client
CareFirst- MaryLand
A.) Role
Technology Analyst, Track Lead
Job Location
Pune (INDIA); Baltimore (USA) (H1-B Visa)
Responsibility Duration
Start date: August, 2014 End date: March, 2018
Software
Oracle PL/SQL Programming, Stored Procedures, Triggers, MS SQL, Toad for Oracle, Unix Shell Scripting, Putty, WinSCP, Webshpere, Sharepoint, Control-M, Service Now, KSHOP, IPM, IAP(Infosys Automation Platform).
Responsibility
:
●Was a KM anchor for KSHOP, initiated a KM contest for getting the complete documentation of the business.
●Compliance anchor: Taking care of all compliance related activities. Party Representative: Have organized parties and team get together.
●Have provided support during almost all my development deployments.
●I have proven expertise in troubleshooting production support defects under time pressure.
●I am involved in root cause analysis, coding, estimations, Tracking and fixing defects in all my developments.
●Deliver high quality code deliverables and supports peers in quality checks.
●Participate in creating application architecture document to provide deliverables in line with architectural requirements.
●Created Estimations for new development and enhancements by following ESTEEM which is a customized Infosys function point estimation methodology.
●I was also leading data masking for the project using Infosys Data Masking Software(IDMS) which enables the organizations to comply with regulations, prevent data theft and enhance data privacy.
●Help the manager in prioritization of effort to resolve the most critical tickets as per business requirements.
●Also used Infosys MaskIT DataMasking for data privacy and protection for sharing masked data for business needs like application development, testing, training, statistical analysis.
●Was at client location in US for 2 years handling data operational work directly with Client using Toad Data Point and PL/SQL skills.
●Project quality check using IPM+ for project tracking, milestone check, and schedule management.
●For Automation, gained experienced on IAP through trainings and used IAP tool to increase productivity and reduce error rate.
B.) Role
:
Technology Lead, Team Lead
Responsibility Duration
:
Start date: April, 2018 End date: December, 2018
Software
:
Oracle PL/SQL Programming, Stored Procedures, Triggers, MS SQL, Toad for Oracle, Unix Shell Scripting, Toad Data Point, Putty, WinSCP, Control-M, Service Now, PL/SQL Developer, KSHOP, IPM, IAP(Infosys Automation Platform)
Responsibility
:
● I have proven expertise in troubleshooting production support defects under time pressure.
●Work with customers on project scoping and overall estimations/schedule, closing down dependencies and managing risks/issues.
●Manage on-boarding of new applications and resources
●I am involved in root cause analysis, coding, estimations, tracking and fixing defects in all my developments.
●Deliver high quality code deliverables and supports peers in quality checks.
●Created Estimations for new development and enhancements by following ESTEEM which is a customized Infosys function point estimation methodology.
●Drive technology and functional training sessions within the team to improve team productivity.
●Project quality check using IPM+ for project tracking, milestone check, and schedule management.
●Participate in creating application architecture document to provide deliverables in line with architectural requirements.
●For Automation, gained experienced on IAP through trainings and used IAP tool to increase productivity and reduce error rate.
●I was also leading data masking for the project using Infosys Data Masking Software(IDMS) which enables the organizations to comply with regulations, prevent data theft and enhance data privacy.
●Help the manager in prioritization of effort to resolve the most critical tickets as per business requirements.
●Also used Infosys MaskIT DataMasking for data privacy and protection for sharing masked data for business needs like application development, testing, training, statistical analysis.
.
4.) Project Name
Application Support and Transformation
Client
Northern Trust
Role
Technology Lead
Job Location
Pune, INDIA
Duration
Start date: December, 2018 End date: May, 2019
Software
Putty, PL/SQL, Control-M, Oracle, Unix
Responsibility
:
●I was responsible for the schema creation and liaising with different teams from different geographies for the data. We followed Agile Methodology.
●Project quality check using IPM+ for project tracking, milestone check, and schedule management.
●Work with customers on project scoping and overall estimations/schedule, closing down dependencies and managing risks/issues.
●Provide IT support to critical business operations and solve any reported issues with SLA.
●Implement ticket resolution and other such IT service management activities through robotic operations using Infosys automation platform (IAP).
●I use NIA platform for AI based enterprise automation for problem analytics module of Infosys NIA to arrive at recurring issues that can be remediated at source thus leading to reduction in work drivers for the application support team.
●Requirement gap analysis and transforming the functional specs into technical specs.
●Deliver high quality code deliverables and supports peers in quality checks
●Create Knowledge management repository to share between team members using KSHOP.
Education
Year Of
Passing
Institute Name & Location
Qualification Code
Branch Code
University
31-Mar-2004
Sri Guru Harkrishan Public School
Secondary School
General
Secondary Education Examination Board
31-Mar-2006
Mela Devi Kalra Public School
Pre-University Course
Science
Higher Secondary Education Examination Board
31-May-2010
Lovely Institute Of Technology
Bachelor Of
Technology
Electronics And
Communication Engineering
Punjab Technical University
Personal Details
DATE OF BIRTH
:
31st January, 1989
MARITAL STATUS
:
Married
NATIONALITY
:
INDIA
VISA STATUS
:
CANADA (PR), USA (H1-B Visa)
EDUCATIONAL BACKGROUND (MONTH AND YEAR OF PASSING)
:
Bachelor Of Technology (Electronics & Communication Engineering)(May 2010)
PASSPORT NO. (VALID UPTO)
:
N3843898 (14 Oct 2025)
COMPUTER LANGUAGES
:
PL/SQL, UNIX Shell Scripting
(Experience in Oracle PL/ SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views,
PL/SQL collections. COBOL, JCL, REXX)
OPERATING SYSTEMS
:
Windows, UNIX
DATABASES AND SERVICES
:
IMS DB,My SQL, Oracle, Oracle Database,SQL Server, MS SQL, Toad for Oracle
TOOLS
:
SharePoint, Toad Data Point, SSH Tools (Putty), Citrix, Autosys, ContolM, WinSCP, PL/SQL Developer.
CLIENT SPECIFIC TOOLS
:
Service Now, PL/SQL Developer, Control-M Scheduler
INFOSYS PROPRIETARY TOOLS
:
Automation Platform NIA, IAP, KSHOP Lex, Infosys data Masking Software (IDMS), Infosys MaskIT DataMasking Database, Infosys Influx Business Process Engineering, Infosys Estimation Methodology using ESTEEM, Infosys Program Management Processes and IPM+
Contact this candidate