Figura professionale: PowerBuilder, Oracle 11g, PL/SQL, Oracle Forms, Sybase 12.5

Nome Cognome: D. M.Età: 36
Cellulare/Telefono: Riservato!E-mail: Riservato!
CV Allegato: Riservato!Categoria CV: DBA/Oracle/SQL Server/Mysql
Sede preferita: Brussels

Accesso Full al database con 29.989 CV a partire da € 5,00    ABBONATI SUBITO!



Sommario

PowerBuilder, Oracle 11g, PL/SQL, Oracle Forms, Sybase 12.5

Esperienze

WORK EXPERIENCE

Cognizant Technology Solutions Benelux BV November 2017 to present
Cognizant Technology Solutions India Pvt. Ltd November 2010 to October 2017
 Expertise in PowerBuilder 10.5, 11.5, 12.6, 17 involving development and analytical activities.
 Expertise in Oracle 11g/ PL-SQL. Good exposure in writing complex SQL queries, Packages,
Stored Procedures, Views and Triggers.
 Good Knowledge in MS SQL Server 2008, Sybase 12.5, Oracle Forms and Agile methodologies
 Worked on Development, Maintenance and Production Support over various domains such as
Commodity Trading and Accounting, Life Insurance, P&C Insurance and Information, Media and
Entertainment.
 Strong project co-ordination combined with effective analytical, writing, communication and
presentation skills and got good experience on client interaction starting from gathering
requirements to production support.
 Experience in validating the Deliverables in each phase to ensure Quality Compliance and
closure of internal audit findings.
 Worked on critical projects with stringent timelines and have endured consistent delivery.
 Done various automations and innovations which helped to reduce the manual efforts of the
team and increase the profitability for the client.
 Awarded Certificate of excellence from Cognizant for the contributions towards enhancing the
client application and gaining customer satisfaction, thus supporting the growth of Energy and
Resources vertical in The Netherlands on July 2019.
 External Certifications:
 1Z0-144- Oracle Database 11g: Program with PL/SQL (Oracle Certified Associate)
 1Z0-051- Oracle Database: SQL Fundamentals I
 LOMA 280 – Principles of Insurance: Life Health and Annuities
PROJECTS ACCOMPLISHED
 Commodity trading
ERP system used for administrating and managing trade related activities. From registering and
monitoring contracts and positions to invoicing and inventory management. Mainly taking care of
Registration of the purchase and sale trades, Execution of the registered purchase and sale trades,
Maintenance of the goods positions, Visualization of the most actual status of the trades, Managing the
financial impact(s) of the trades.
Tools Used : PowerBuilder 17, PLSQL developer, XML Spy, TFS, StarTeam
Database : Oracle
Roles and Responsibilities
 Working in client location at Rotterdam necessitating close interaction with clients on a daily
basis on finalizing the requirements, brainstorming scenarios involving the possible impacts,
raising clarifications, risks and concerns proactively on both technical and functional aspects,
handling demo sessions.
 Working on Agile methodology involves estimations of the development required for the entire
solution.
 Enhance existing application with new features and also manages existing modules part of RFC
 Perform analysis on existing behavior of screens as part of migration of certain modules to
newer technologies
 Design changes, creation of new PB screens and database Tables, Packages, Stored
Procedures, Views, Indexes and new data model.
 P & C Insurance
An integrated system to manage Policies in the Insurance Company, which includes Policy amendment
functionality, Document Generation functionality and Role Management. Performed various
maintenance activities to an existing application by which eliminating manual processing which requires
information to be entered into multiple applications, allowing for a single point of entry. Enhanced the
current forms so that they are more flexible and dynamic and allowing users to process unlimited ‘real
time’ transactions on a policy per day. Document generation involves decoupling document generation
capability from individual applications and to centralize the capability, standardize the templates and
better management of templates and ensuring a professional look and feel for the templates.
Enhanced existing features/transactions such as New Business, Renewal, Endorsement, Re-issue and
introduced new features such Broker Commission Change, Cancellation, Mid-term broker change,
Reversal, Backdated Endorsement, Year-end Annual Adjustment and Extension.
Tools Used : PowerBuilder 12.6, SQL Server Management Studio
Database : MS-SQL Server
Roles and Responsibilities
 Lead the PowerBuilder development team, provide estimations, schedule and allocate tasks for
each team member and oversee the work being done by team members.
 Preparing Low Level Design(LLD), High Level Design(HLD) and table structure for the change
 Creation of database Tables, Stored Procedures, Views, Indexes, Roles and maintain users
 Coding, Testing and Implementation
 Conducting code reviews for the development team and code walkthrough
 Quality review of deliverables ensuring Incident, Problem and Change management goals and
SLA attainment
 Doing the functional testing and integration testing of the system and passing it to QA
 QA support and defect fixes
 Value addition to organization and manual effort reduction by optimization through system reengineering, process improvements and system automations
 Information Media and Entertainment
An application which is used by Media Agency, where there are systems that enable comprehensive
planning and buying, including accounting. This application is for facilitating users to plan advertising
campaigns, estimate the ratings of programs analyze and obtain an optimal package of advertising
spots and eventually buy those spots. It also contains features to manage changes to requirements and
buy, and monitor campaigns and do a performance analysis.
Tools Used : PowerBuilder10.5, 11.5, ASE ISQL (Sybase 12.5), Toad for
Sybase, Putty, FileZilla, Excel Macro
Database : Sybase
Roles and Responsibilities
 Involved in maintenance and support activities.
 Requirement analysis and daily discussion
 Requirement Clarification and existing system study.
 Estimation of Modules.
 Preparation of unit test plans for the assigned module.
 Coding and Unit testing
 Defect assignment and tracking and bug fixing.
 Production Support involves direct interaction with client and extending the support over night
during peak business needs
 Life Insurance and Annuities
Application developed for Annuities line of business which will fall under Life Insurance, handling all the
business flows.
Tools Used : SQL Navigator (PLSQL), SQL Plus, Oracle Forms Developer,
Toad for Oracle, Excel Macro
Database : Oracle
Roles and Responsibilities
 Requirement analysis
 Solution Design, Detail Design
 Coding by following quest architecture, Implementation
 Test case preparations, Unit Testing, Assembly Testing, SIT support
 Knowledge Transfer Sessions
 Preparing Status Reports
 Communicating effectively with the Onsite Coordinator and team members and ensuring quality
deliverables on time.

ACADEMIC PROFILE
 Federal Institute of Science and Technology, Kerala, India
(2006-2010)
Bachelor of Technology (B-Tech)
 Technical Higher Secondary- IHRD, Kaprassery, Kerala, India
(2004-2006)

SUMMARY
 Working as Senior Developer in Cognizant Technology Solutions since November 2010
 PowerBuilder, PL-SQL, SQL Server Professional, C#, Sybase with 8+ years of experience
 Recorded highest performance ratings twice over last three years within Cognizant
 Won various awards and recognitions inside Cognizant
 Active member of Cognizant CSR activities and other organizational initiatives
 Completed Bachelor of Technology from Federal Institute of Science and Technology(FISAT),
India in the year 2010

TECHNICAL SKILLS
 PowerBuilder 10.5, 11.5, 12.6, 17
 Oracle 11g, PL/SQL, Oracle Forms
 Microsoft SQL Server 2008
 Sybase 12.5
 C#, HTML, CSS, Excel Macro

171 total views, 1 today