Guru Sami

Powerbuilder and PL sql developer with 10 plus years of exp

Professional Summary

• 10 years of IT experience in Oracle PL/SQL, SQL Server, PowerBuilder.
• 3 years and 10 months of onshore client experience at BNPP Paribas Fortis Bank, Belgium.
• Experience in different PowerBuilder objects such as Window, Data window, Datastore, Global functions, External functions, User objects, Structure, Menu, PFC objects, Consumption of webservice, REST API, Usage of environmental variables, Registry keys, Regional settings
• Worked on the various migration projects windows 2008 to 2012, SQL server 2008 to 2016            migration, PowerBuilder 12.5 to PowerBuilder 2017, Windows 2007 to Windows 2010 Migration.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, packages, Exceptions, Joins, Subqueries ,DBLinks and set operators.
• Experience in bulk collect, bulk bind operators and collections.
• Good exposure on advanced topics like Analytical functions, Indexes, Partition tables.
• Strong Knowledge in SDLC and all phases of application development.
• Designed interface for communication with other system like L2 (Automation Systems)
• Experience in program debugging and query tuning. 
• Experience in JIRA/Service Now/ SP Service manager incident management tools. 
• Strong understanding of business processes with good experience in development.
• Implementation of innovative custom solutions for complex requirements.
• Handling production release on scheduled time with efficient plan and process.
• Good domain knowledge and experience in Banking and Steel Manufacturing (MES).
• Keen to learn/adapt new technologies and skills.