Analyst/developer Resume Profile
New, YorK
Summary:
- 10 years of Oracle experience
- 18 years of PowerBuilder experience
- 6 months of WEB Development
- About 18 years of industry experience in Analysis, Design, Development and Implementation of client server systems
- About 15 years of US experience
- Work experience in PowerBuilder 11.5/9.x/8.x/7.x/6.x/5, Power TCP Controls, PFC 6.x, Forms 3.0, Oracle 10g/9i/8.0/7.1, Sybase 12/11/10, MS SQL Server 6.0, Sybase Adaptive Server Anywhere 9.0/8.0, PL/SQL, SQL Loader, TOAD, Visio, HOW Case Tool, Rational Rose, S-Designor, PVCS, Visual Source Safe 6.0 , Object Cycle Manager, Crystal Reports, Clarify, Wise Installation 6.0,
- Working knowledge of C , ASP.NET , MVC, HTML, CSS, Java Script, JQuery, Kendo, MS Visual Studio 2005/2010/2013, Visual Studio Team Foundation Server, SSRS, SharePoint
- Strong Knowledge of SQL Stored Procedures
- Experience in Object Oriented Analysis and Designing , CASE Tools , Use Cases
- Experience in Project Management, Client Management
- Experience in all stages of Project Life Cycle: Business Requirement, Analysis, Development, Testing, User Acceptance Testing, Implementation Production Support
- Experience in writing Tech Specs, Test Plan, Implementation Plan Test Results
- Industrial Knowledge In : Claims Management, Radio Programming, Retailer Business, Financial Accounting, Sales Purchase Accounting, Payroll Accounting, Wireless Communication
- Excellent Communication Skills
Software Competencies:
Front End :PowerBuilder 11.5/9x/8x/7x/6x/5, PFC 6.0, Corner Stone 5.0, Forms 3.0, PL/SQL,SQL-Plus, PowerTCP WebEnterprise Tool
WEB/ Tools : ASP.NET , C , MVC, HTML, CSS, Java Script, JQuery, Kendo, MS Visual
Studio 2005/2010/2013, Visual Studio Team Foundation Server, SSRS, SharePoint
Back End/Tools :MS-SQL Server 2012, Oracle 10g/9i/8.0/7.0, Sybase ASE 12, Sybase System 10/11,MS-SQL Server 6.0, MS Access, TOAD, MS Management Studio
2012/2010, DB Artisan
CASE Tools :MS Visio 2003, HOW 1.01, Raditor 1.0, S-Designor 6.0, Rational Rose 5.0,
ABC Flow Charter
Other Tools :PVCS, Wise Installation 5.0, MS Visual Sourcesafe 6.0, Process Analyzer, Clarify, Crystal Reports
Operating Systems :Windows8, Windows 7,Windows XP, Windows 95/NT, HP-UNIX,
Sun SPARC
Selected Assignments:
Confidential
Role : Analyst/Developer
Environment :PowerBuilder 7.0, MS-SQL Server 2010/2012, MS Management Studio 2010/2012, MS Export/Import Tools, MS Analyzer, Windows7/Windows XP, Visio, PVCS, Visual Studio 2010/2013, ASP.NET, C , MVC, HTML, CSS, JavaScript, JQuery, Kendo, SSRS , SharePoint, Visual Studio Team Foundation Server
Responsibilities:
- Involved in Analysis, Design, Development and Implementation of Schedules System for Bankruptcy Group
- Involved in Analysis, Design, Development and Implementation of Banking Application for loading the paid items through one process and related reports
- Involved in Analysis, Design, Development and Implementation of customized Claims Management System screens and reports to accommodate the requirement of different cases/projects.
- Involved in Enhancement and Implementation of different systems i.e Integration GCG2020, Watchlist, GCG EFC, Ohio Maintenance and other related system in accordance to 2020 Systems
- Involved in writing complex stored procedures for data processing and also for reports which pulls data from different project databases
- Involved in ETL processes for different projects
- Involved in bug fixing in WEB Applications
- Involved in production support for multiple Applicatons
Confidential
Role : Analyst/Developer
Environment :PowerBuilder 11.5 , Sybase ASE 12, DB Artisan 8, Windows XP, Unix, PB Native
Responsibilities:
- Involved in designing creating new screens as per the New Business rules for the redefining AS 400 processes to migrate to Airwave.
- Involved in creating and implementing an new application Affiliate Master to download data MS CRM to Sybase database using Web Server Proxy via Affilate Portal Service Calls.
- Involved in writing complex stored procedure for implementation of Affiliate Compensation Process other related processes.
- Involved in writing Technical Specs
Confidential
Role : Senior Analyst/Developer
Environment : PowerBuilder 9.0/8.0 , Oracle 10g/9i/8.0/7.3, PL/SQL, Cursors, SQL Loader,TOAD, Sybase ASA 9.0/8.0, Windows XP /Windows NT/95, Unix, PowerTCP WebEnterprise Tool, Visual Source Safe, Wise Scripting, MS Visio 6.0, Snagit7, MS Visual Studio 2005 ,ASP.NET
Responsibilities:
- Analyzing and implementation of the new Business Rules for different companies.
- Creating modifying different screens reports as per the Business group requirements
- Creating reusable NVOs to implement the business rules
- Used an third party OLE Control to implement transfer of data between local Sybase ASA database to the Oracle Database using the HTTPS protocol
- Extensively used dynamic features to modify Datawindow objects on runtime.
- Initiated the rewrite process of changing complex functions into stored procedures to improve the performance of the AMPS processes
- Involved in analysis, design ,development of PB dll download automation process
- and coded complex procedure to upload PB dlls as blob and also created a restart tool to automatically restart the application after the dll download process.
- Involved in analysis, design and development of security methodology for all applications including the Web applications and implemented using stored procedures.
- Involved in trouble shooting and resolving production issues.
- Completely handled maintains support for AMPS Admin and Metadata manager applications which involved writing complex SQLs to update data on Oracle Server
- Interacting directly with the business group to gather new requirements.
- Involved in writing technical specs, test plan and test results.
- Involved in converting Sybase SQLs to Oracle Stored procedures for web AMPS implementation.
- Involved in testing for web AMPS implementation.
- Coded complex procedure to upload PB dlls as blob
Confidential
Role : Analyst/Developer
Environment : PowerBuilder 6.0/ PFC 6.0, Oracle 8.0, Windows NT, HP-UNIX
Object Cycle 2.0, PL/SQL, SQL-Plus, Clarify 1.0 :
Responsibilities:
- - Involved in the production support activity which included Bug fixing, trouble shooting, database changes and enhancement of the different system as per the user requirement.
- - Creating modifying different screens reports as per the Business group requirements
- - Creating reusable NVOs to implement the business rules
- - Extensively used PFC features in enhancement of the system
- - Involved in writing stored procedures
- - Involved in testing and implementation of the changes done to the system
- - Interacting with the different users for getting the user specification.
- - Used Object Cycle for Version control
- - Used Clarify Tool for problem tracking
Confidential
Role : Analyst/Developer
Environment : PowerBuilder 5.0/ PFC 5.0, PL/SQL, Oracle 7.1, Windows 95
Responsibilities:
- - Involved in Bug fixing and completing modification required in different modules of OPCS, GEO Geographic Data System and Security System and also involved in improving the performance of the system.
- - Creating modifying different screens as per the Business group requirements
- - Creating reusable NVOs to implement the business rules
- - Extensively used PFC to enhance the features of the application.
- - Reviewed the code for improving performance issues and implementing it
- - Interacting with clients for getting requirement specification.
Confidential
Role : Analyst/Developer
Software : Power Builder 6.5/ PFC 6.0, Object Cycle 2.0, MS SQL Server 6.0,
Windows NT
Responsibilities:
- - Involved in developing generic window templates using PFC features which can be used by the Team
- - Involved in analysis and developing loading module to load the existing data from the old system and successfully completing the loading of data.
- - Involved in analysis and developing billing extract module which create text files with the information extracted from the system and send it through e-mail as an attachment to the client.