SUMMARY

• 8 years of experience including onsite in planning, developing and implementing state of the art information solutions primarily in Telecom, Manufacturing Industry and Healthcare domain. A dynamic leader and mentor and able to build team cohesion and inspire individuals to strive towards ever higher levels of achievements. Exceptional client relationship and management skills. Adept at consensus building, crisis management, problem solving and negotiations.
• 8 years of experience in PowerBuilder Ver. 6,7, 8, 9,10 with PFC.
• Created PowerBuilder Training material/courseware for internal training of resources and team members.
• Strong capabilities of Application design/ development, Oracle 10g/9i/8i, SQL, PL/SQL, Data Modeling, PL/SQL Design and Development.
• Extensive experience in Application Development using Power Builder and PFC.
• Worked on creating an Implementation layer in PFC paradigm SFL- Sigma Foundation library . In this layer, we have extended and enhanced many PFC services and created some new application services such as data level, row level data access control.
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle/DB2 Database and many other facilities, such as Import/Export, SQL Loader and SQL Plus. Java Stored Procedure, DBMS Packages, UTIL Packages
• Created very complex near to IMPOSSIBLE reports, GUI functionality using Power Builder objects and particularly exploring the rich functionality of Datawindow.
• Developed many generic functionalities like security model using PowerBuilder which can be used across projects.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Have experience using very complex queries and data analysis.
• Excellent skills in Triggers, Stored Procedures and Standard Packages.
• In depth knowledge of Oracle technologies like XMLDB, RLS/FGA, XML Support and relevant features Like Xquery, Flashback query .
• Extensive knowledge of Modular PL/SQL design and development.
• Writing reusable PL/SQL utilities which can be used across projects.
• Experience in Java Stored procedure and Java programming in PL/SQL.
• Query Optimization and SQL/ PL-SQL performance tuning.
• Extensive experience in Dynamic SQL, Records, Arrays and Exception handling, data sharing, Data Caching, Data Pipe Lining. Complex processing using nested Arrays and Collections.
• Proficient in Oracle Tools and Utilities such as SQL Loader, TOAD, SQL Navigator and PL/SQL Developer, XML Parsers, tKprof report, Code Pining.
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Good understanding of OOA and OOD concepts and UML.
• Vast experience of execution of full SDLC for numerous projects.
• Good knowledge in the Implementation of Business Applications using the ORDBMS.
• Very strong ability of quickly identification of the problem and provide solutions.
• Excellent communication, interpersonal, analytical skills and strong ability to lead developers team as well as be part of development team.
• Excellent experience of Task Management and release/delivery management.
• Experience with Project estimation and Project Planning.
• Exposure to pocketBuilder PowerBuilder version for development of Mobile Applications

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Designation: Sr. Software Developer

• Worked as a Senior Developer, enhancing existing application for Administrative Office of the Courts AOC written using PowerBuilder deployed as EAServer component and JSP/Strut for user Interface
• Provide technical diagrams, write-ups and presentations on new system requirements
• Wrote and review requirements, documents, functional and technical specifications
• Provide LOE Level of Effort and wrote technical designs for PowerBuilder, JSP/Java and Applet components
• Enhanced system written in C for a point-to-point data interface with California's DMV agency.
• Wrote CRON jobs and shell scripts for outbound/inbound data interfaces.
• Wrote and enhanced several Stored Procedures utilizing 10g features, e.g. Pipeline tables, Collections etc.
• Provide immediate support and fixes on PowerBuilder objects deployed as EAServer component and/or JSP/Strut servlets

Environment: PowerBuilder 7/10 With EAServer, Oracle 9i/10G, SQL Reports, JSP, Core Java,C , Shell Scripts, Windows XP, Sun Solaris.

Confidential

Designation : Team Leader

Responsibilities

• System Study and change management.
• Oracle PL/SQL, Java Stored procedure development and testing.
• Front End Development as per the customization requirement from client.
• Static and dynamic reports using PowerBuilder dynamic data window.
• Onsite-Offshore development and delivery management.
• Design and development utilities like Oracle dashboard Data Analyzer and data auditing framework.
• WEBCARE WEB Based customer care and Invoice generation module. Summary and Detail invoice created using Jasper Report.

Environment: PowerBuilder 7/10, Oracle 9i/10G, SQL Plus, PL/SQL, Pro-Cobol, mySQL, Pro C , Data Vision, Data Pipelining. SQL Reports. Sytrix Server.

Confidential

Designation : Team Leader

Responsibilities

• Business Analysis and Use case definition Onsite at Toronto Canada
• Data Modeling, Database design.
• Prototyping of Product using PowerBuilder 10
• Creating HLD, LLD for desktop version of product PowerBuilder
• Designed the extension layer on PFC for application framework.
• Design and development of Desktop version of iBace application using PowerBuilder 10.5
• Generic Framework definition J2EE
• XML parser based Database manipulation framework designed and developed.
• PL/SQL technical specification creation and writing/ administrating the development.
• Audit Framework and RLS based framework designed for role based data access control.
• Application page flow definition
• Single point contact person for Product development.
• Development, Program change, Delivery management.
• Task estimation and delegation.
• Usability Engineering.
• Iteration based Project Planning and development co-ordination.
• Training to sub-ordinates.
• 'Ireport' Jasper report

Environment: PowerBuilder 1o,Oracle 10g/9i, SQL, PL/SQL, SQL Plus, Java, J2EE- Struts, Jasper Reports 10.x, Windows XP, Unix, Solaris, Linux, DRUL Rule Engine , jBoss Server, Apache Server. Dynamic JSP.

Confidential

Designation : Team Leader

Responsibilities

• System Study and change management.
• Oracle PL/SQL, Java Stored procedure development and testing.
• PL/SQL tuning and creating various Database objects including DB Links.
• Front End Development using PowerBuilder 7 and later migration and development in PowerBuilder 10.
• Team Management and release management.
• Static and dynamic reports using PowerBuilder dynamic data window.
• Client side implementation / User Training and Change Request Management. UAT Support.
• Onsite-Offshore development and delivery management.
• Customization of product to parameterize the use cases.
• Design and development utilities like Oracle dashboard Data Analyzer and data auditing framework.
• Oracle Policies and Policy group definition. Implementation of row/column level access control.

Environment: PowerBuilder 7/10, Oracle 9i/10G, SQL Plus, PL/SQL, Pro-Cobol, mySQL, Pro C , Data Vision, Data Pipelining. SQL Reports. Sytrix Server.

Confidential

Designation : Senior Software Engineer

Responsibilities

• Creating Application framework extending PFC PowerBuilder Foundation Class libraries services.
• Writing specification for PL/SQL.
• Design and development of Application front-end using SFL Sigma Foundation Library framework.
• Development of PL/SQL and SQL PL/SQL tuning.
• Database Profiling and sizing.
• Technical Documentation and development co-ordination.
• Team Building and training new resources on PFC-SFL and PL/SQL.
• Created a Process Scheduler module in PowerBuilder/Oracle and Process Pooler in C language.
• UAT- Production support.
• Program Change Request PCR and delivery management.
• System and integration testing.
• Complex report writing using DataVision, Jasper Report, PowerBuilder Data window.
• Production data migration. Postgrey SQL to Oracle .
• Delivery management

Environment: PowerBuilder 7,9, Oracle 9i, SQL Plus, PL/SQL, Pro-Cobol, mySQL, Pro C , Data Vision, Jasper Report, Ruby Scripting Language , Java/J2EE my Personalizer Framework , Data Pipelining. Oracle RAC and Mirroring. Radius Server.

Confidential

Responsibilities

• Domain trainings and study.
• System Design and Data Modeling. Database programs PL/SQL development. Testing and implementation.
• Account Management For different Client installation
• Front End framework design and GUI screen development using PowerBuilder 6.
• Resource Planning and development co-ordination.
• Data Transfer across multiple location of same company Using SQL Loader, PowerBuilder Pipeline object .
• MIS report design and development.
• Investigation of how to deploy the window based software on Citrix Server and successfully deployed the application on it first time within the organization.
• Creation of Oracle Jobs for huge data processing which are scheduled to run at particular intervals.

Environment: PowerBuilder 7, Oracle 9i, SQL Plus, PL/SQL

Confidential

Responsibilities

• Understanding the requirements and designing/development of application components using Sybase PL/SQL, PowerBuilder.
• User Training and online production support.
• Various MIS and statutory reports created using PowerBuilder / Sybase/ Stored Procedure based Datawindows.
• Data Cleanup and issue resolution.

Environment: PowerBuilder 5/6/7, Sybase SQL Anywhere, Windows NT, Windows 98.