Hanimi R Mortala

412-***-****

Green Card holder,USA

Summary:

Certified Microsoft developer(MCP) and PowerBuilder with 19+ years of experience in developing business related applications in the Client/Server, Unix / Windows, Web, Distributed (Full Life Cycle) (FLCD) environments using PowerBuilder 10.5/11.5/12.5, PFC, SSIS,SSRS,,Asp,ASP.net,vb.net Visual Basic, Crystal Reports, Oracle, Sybase EAS and Ms-Sql Server, Ms-access and Unix shell scripting.

Extensive experience in Information Systems Analysis, Design, Development, Coding, Testing, Migration, Enhancements (program maintenance), QA Management, Team Management, Documentation and Implementation.

Strong expertise in user interface, specification development and troubleshooting.

Solid knowledge of programming and Design methodologies related to RDBMS Applications.

Solid understanding of Systems life cycle (SDLC), relational databases and software engineering discipline.

Strong expertise in Advanced software engineering and design principles, including object-oriented methodologies and design patterns, multithreading and massively parallel computing, distributed and multi-tier models, cross-platform development; reliable and redundant server and service design, database-backed persistent services, encryption, authentication, and secure software; et cetera.

Resolved a lot of Performance Issues in PowerBuilder using PFC.

Strongly motivated person with a proven record of accomplishments at various levels.

Extensive experience in relational database administration, design, development and implementation using Sybase/sql server and tools and utilities.

Knowledge of standard languages, coding methods, operations requirements, company coding standards and quality requirements.

Experience in working with large databases and in designing robust, complex databases, expertise in Client / Server architecture.

Extensive experience in development of applications using ASP.NET, C#.NET, VB.NET, ADO.NET, ASP, VB 6.0, SQL Server 2000/2005/2008, Oracle 8i/9i/10g, Sybase, MS Access.

Experience in developing different types of reports using Crystal, WebI and DeskI.

Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communications to maintain effective work relationships with all levels of personnel in a team environment or independently.

Strong experience creating User Guide and Design Documentation.

Strong in all aspects application development process.

Strong with RDBMS features like Triggers, Procedures, Packages and Functions.

Having exposure in mutual funds, Compensation, Health insurance, Budget Information systems, Child welfare Systems, Health care industries, telecommunication industries, Banking, Financial, HRA, inventory management industries.

Education:

M. S (PhD)

PGDCA (postgraduate Diploma in Computer Applications)

Certified PowerBuilder Developer

Microsoft Certified Solution Developer

Skills:

GUI: PowerBuilder 5/6/7/8.01/10, VB 5/6, Developer 2000 and DatawindowBuilder

Languages: C, C++ Java,.NET, COBOL, JCL, CICS, HTML, PL/SQL, ISQL/TSQL and SQL* PLUS

RDBMS: Access 97/98, Oracle 7.x/8.x/8i, Sybase 10x/11x, Adaptive server, Sybase SQL anywhere 5/6, WatcomSQL4, DB2, VSAM, MS-SQL server

Script Language: VBScript, JavaScript, JScript, HTML and ASP.

O/S: Windows 2000, Windows NT/95/98, UNIX, Novell Netware3.12, MVS

Design Tools: Erwin, Power (S) Designer, UML, Rational Rose, OOAD

Reporting Tools: Seagate CrystalReports6/7, Oracle Reports 2.5, Discoverer3.x, SPUFI, QMF, PEGASYS, MQ-Series, and EASYTRIEVE

Other skills: Api, Solaris, Installsheild, Cold Fusion, SQL Builder, JSP, PVCS, ObjectCycle, SQLProgrammer, Sybase EA Server, MS Office Suite, EDI diagrams, PowerImage, Web Graphics Creation (artwork), Composer, Sun V880's, Cornerstone

ERP Tools: PeopleSoft7x (HRMS, People Code, SQR), SIEBEL E-CRM2000

Hardware: ES-9000, DEC Alpha, UNIX Server, HP-9000, IBM Compatible Pentium PCs.

PROJECTS:

1) CDW OCT’2013 to Present

Wells Fargo,Charlotte

As a Programmer/Analyst

Created and altered windows, large data windows with complex queries, user objects (Visual & Non visual) and functions.

Wrote complex procedures & functions in Sybase 12.5 environment to incorporate business rules and constraints.

Conceived system requirements through in depth discussions with the Business and prepared development estimates.

Created number of new tables, views, triggers, screens and data windows as part of enhancements to existing applications.

Wrote Unit Test cases and tested them against the applications being developed.

Provided production support to a number of PowerBuilder applications by researching and debugging complex problems and solving the issues on time.

Did the Builds for the applications developed and deployed the executables (Implementation).

Recommended technical alternatives through active discussions to meet new requirements of business units.

Delivered end user training to business users for the enhancements made to applications.

Maintained and provided documentation of workload activities and time spent on projects.

Development, maintenance, and performance tuning of Sybase ASE stored procedures, triggers, views, and tables.

Wrote new complex stored procedures in Sybase and optimized the existing code written in Sybase.

Participated in requirement collection, analysis, designing for a new module.

Developed related PowerBuilder objects and GUI for the new module.

Maintain the application version management using CVS (Open source Version Control).

Performed analysis, development and maintenance of a Client Server PowerBuilder/PFC driven application running on an Oracle relational database.

Migrated PowerBuilder application pbls from version 10.5 to 11.5 and 12.5

Provided 24/7 on call production support.

Analyzed end users data needs and developed user oriented solutions which interface with existing applications.

Involved in Bug fixing and enhancements of the application.

Supported and enhanced institutional accounting software for small to mid-sized applications and designed using PowerBuilder 10 with MSSQL 2005 and T-SQL.

Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports 2008. Maintaining proper documentation of the reports for future reference.

Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.

Environment: PowerBuilder 10.5/11.5/12.65, PFC, Sybase 12.5 ASC, SQL server 2008, SDLC, Crystal Reports 2008, Shell Scripting, Windows XP, MS-Office Suite

2) Consolidated Management system Nov’10 to Dec’2013

Wells Fargo, charlotte NC,

Production support consultant.

• Created, customized, and managed stored procedures, functions and to triggers for database’s

Implementation of business rules and implemented database conversion.

Analyze the user requirements and create Use Case documents for each module, technical specifications about the module including the screen design, business process involved and the various ways of implementing the business rules including all the validations, SQL to be written and pseudo code wherever applicable.

Responsible for setting up and maintaining Ms-Sql Server development and production environments. Helped Database Administrator for 3 productions and 2 developments Ms-Sql Server Servers.

Led all project efforts including requirements gathering and JAD sessions.

technologies and were founded on a complete Service Oriented Application (SOA) architecture.

Experience with developing distributed applications (with Jaguar/EAServer, J2EE or equivalent technology)

Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers, and fine-tuning them for performance.

Implemented the use of standard templates to create up-to-date SDLC documents.

Migrated the applications from PB 7.0 to 10.5

Developed UNIX shell scripts to integrate and execute various pre-scheduled modules, event to execute at production servers and for generating logs on day-to-day basis.

Involved in development of NVO and base classes which are used across multiple applications.

Coding, testing, debugging of Windows, complex data windows, User objects, functions, events using Power Builder per company standards and techniques.

Creating and altering Tables, procedures, functions, triggers and packages.

Making Builds and deploying executables (Implementation).

Wrote auditing triggers, complex procedures & functions using PL/SQL to incorporate business rules and constraints.

Designing standard Framework as per PowerBuilder Foundation class.

Analysis, Design, development and Enhancements of the various applications.

Involved in writing design, technical, enhancements documentation and test plans.

Creating and changing Business objects (Visual and Non visual), windows, data windows, functions and menus using Power Builder.

Developed new classes in PowerBuilder™ 8.0 utilizing ActiveX technology, for deployment in COM / ASP or Sybase® EAServer (web target) environment.

Developed several PowerBuilder applications using RPC functionality.

Developed Front end windows using PowerBuilder v10.5 and PFC services with Sybase and Oracle as backend.

Created stored procedures, cursors, triggers, and views in TSQL and PL/SQL and modified existing ones so that the old and new functionality is supported.

(PowerBuilder 8.03/11.x, PFC, PL/SQL, Oracle 9i/10g, PVCS, SDLC, Shell Scripting, Windows XP, MOffice

Microsoft Visual Studio 2008, .NET Framework 2.0,unix

3)Beacon Oct’07 to Nov’10

Vanguard mutual, Charlotte, NC

Production support consultant

Collected user requirements, analysis, design (GUI & Database) and developed the system. Interacted with the users to discuss business logic and workflow of the all the system. Created Functional specification, technical design document, Integration and unit test cases.

Extensively used Object Oriented Techniques in c# like Inheritance, Polymorphism and Encapsulation.

Collected Business requirements, Upstream& Downstream Impact analysis on Applications with schema changes, Created Functional specification and technical design document. Preparation of detail design, development and production support for the assigned modules.

Modified and created tables, stored procedures, database triggers and complex queries for reports of sql server Databases.

Responsible for all ETL operations within the Engineering group including client feeds, warehouse loads, and data extraction large quantities of database records, thus making policy valuations, transaction status, summary reports and different cycles are implemented (monthly, quarterly, yearly and daily).

Designed several Sequential Workflow Libraries (WWF) for business logic by analyzing business requirement.

Developed Interfaces for data exchange using MS SQL Server2008, C#.NET

Manage a team of database developers to support the Business Intelligence and data services needs of the enterprise.

Manage migration from Crystal Reports to SQL Server 2008 Reporting Services (SSRS)

Custom ETL solutions using T-SQL stored procedures schedules as jobs.

Perform ETL operations for Business Intelligence reporting solutions using custom VBA and Excel web queries

Actively engage in design discussions for all Business Intelligence and database initiatives.

Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in

Developed drill down and drill through reports from multi dimensional objects like star schema and snow flake schema using SSRS and performance point server.

Developed and maintained different SSIS packages to integrate data from different servers to main production server.

(PowerBuilder 10.5/11.5/12.5, AUTOSYS,PERL, ORACLE, SQL server 2008, SDLC, Shell Scripting, Windows XP, MS-Office Suite,Visual Studio.NET, .NET Framework 3.5, VB6.0, sybase12.5,Ms-Sql server 2005/2008, IIS 5.0,C/C++, UNIX, Sun Solaris, Control-M, Windows-NT, MS-Office2000)

HDS Loan Servicing System Sep’06 to Oct’07

FHLB ATLANTA

Housing and Development Software’s Loan Servicing system provides loan servicing functionality for both single-family and multifamily loans. This functionality makes it suitable for State, County, and City Community Development Agencies as well as Housing Finance Agencies.

Analyze the user requirements and create Use Case documents for each module, technical specifications about the module including the screen design, business process involved and the various ways of implementing the business rules including all the validations, SQL to be written and pseudo code wherever applicable.

Developed .NET components, Web User Controls, Custom Controls using C#

Developed SQR programs to generate reports from a Sybase database (including requirements gathering).

Lead team on Business Intelligence efforts by providing real world training exercises and demonstrations Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified dimensional Model (UDM)

Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)

Architect faux data mart solutions to improve performance of SQL Server 2005 Reporting Services (SSRS).

Created, customized, and managed stored procedures, functions and to triggers for database’s

Implementation of business rules and implemented database conversion.

Responsible for setting up and maintaining Ms-Sql Server development and production environments. Helped Database Administrator for 3 productions and 2 developments Ms-Sql Server Servers.

Led all project efforts including requirements gathering and JAD sessions.

Developed Systems were designed and implemented using SQL server products and .net technologies and were founded on a complete Service Oriented Application (SOA) architecture.

Experience in creating and consuming XML Web Services with C#, SOAP Headers and Extensions, WSDL, WSE 2.0, Serialization.

Created MDX queries to access the OLAP cube information.

Designed and implemented reports with different layouts using SSRS 2005 and Crystal Reports and exported them into Excel, PDF and HTML.

Designed and deployed various reports using SSRS.

(PowerBuilder 10.5/11.5/12.5,SSIS, SSRS,, SSAS, PowerBuilder, UNIX shell scripting, ASP.NET, VB.net, SOA, C#, Ms-Sql Server 2005, Windows-NT, VSS, MS-Office’2000)

Compensation processing system (Cops) Nov’04 to Sep’06

JPMC Tampa, Fl

Cops are used to compensate the loan originators, the managers of those originators for the loans they disburse. Cops developed under 3-tier architecture.

Responsibilities:

Created, customized, and managed stored procedures, functions and to triggers for database’s implementation of business rules and implemented database conversion.

Extensively involved in hands on coding and debugging of new and existing Applications with large scale / high volume databases

Developed the user interface in ASP.NET using C#.NET as code behind language.

Experienced and managing development efforts using a configuration management tool, such as PVCS.

The application programs are developed using C++ and designed using object oriented methodology.

Three-tiered architecture, with the business processing separated from the user interface and the database interface.

Created and altered tables, procedures, Packages, functions triggers functions and pl/Sql sub programs.

Designed (GUI & Database) & developed business objects and lead a team of 4 members during construction phase. Wrote PL/SQL Stored procedure, Packages and Trigger, created Sequence and tables. Conducted and participated in Peer reviews and Code review.

Investigate and resolving issues relating to the .net, Oracle and UNIX scripts in the application code.

Extensive use of Oracle Designer as a modeling and design tool.

Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers, and fine-tuning them for performance.

Implemented the use of standard templates to create up-to-date SDLC documents.

Migrated the applications from PB 7.0 to 10.5

Design, create and populate back-end SQL Server2000 Database

Used ADO.NET extensively for data retrieving, querying, storage and manipulation.

Involved in creating Datasets from an XML file for data interaction

Used Java Script and .NET Validation Controls for the Page Validations.

Used ADO.NET extensively for data retrieving, querying, storage and manipulation.

Designed and support a scalable distributed SOA application environment in order to migrate from a single legacy midrange system

Designed and developed Data Transformation Process and used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.

(PowerBuilder 10.5/11.5,PFC,Visual Studio .NET 2005, ASP.NET, IIS Server, C# .NET, ADO.NET,UNIX shell scripting, SOA, SQL Server 2000, Oracle 9.i/10g, Crystal Reports8.0, Windows-NT, PVCS,VSS, MS-Office’2000)

Integrated Customer Information System (ICIS) Dec’03 to Nov’04

Blue cross blue shield (high Mark), Pittsburgh, PA

ICIS, the Integrated Customer Information System is a Sale closing process that provides an effective way to enter, use and maintain customer information in four key areas: Demographic data such as contacts, eligibility requirements and general information, Product information and benefits, Rates for each product, billing information.

As a Lead developer

Technical Coordination – Coordinate with the developers and assist them with various functionality and technical issues.

Quality assurance of the software developed based on a quality manual.

Designed tables, created, and managed sql server to hold Sales, Support, Operations, and Billing data (read only).

Developed presentation layer with Web Forms, HTML Controls, Web Controls and Cascading Style Sheets using ASP.NET and C# as Code behind language

Performed troubleshooting and maintenance of applications and design, development and testing.

Analyze the user requirements and create Use Case documents for each module, technical specifications about the module including the screen design, business process involved and the various ways of implementing the business rules including all the validations, SQL to be written and pseudo code wherever applicable.

Helped create DBA stored procedures to simplify development process and still maintain the integrity of the schema owner passwords.

Designing & implementing extensions to Harvest for unsupported platforms & extended process automation

Analyzed and formulated business requirements, and implemented Database and applications performance tuning & improvements.

Made use of services, function overloading and over-riding for the development of the application.

Facilitated JAD sessions with direct marketing experts to capture design requirements for a very complex heuristic real-time intelligent ad-serving engine

Used ADO.NET for Data Querying, Storage and Manipulation from database.

Designed and Implemented Data Access Layer (DAL) using ADO.NET to communicate with MS SQL Server 2000.

Requirement analysis, Use case preparation, and developing UML Model.

Investigate and resolving issues relating to the .net and SQL during construction.

(VB.net,asp.net,C#, PowerBuilder 8.03/9.0, PFC, MS SQL Server 2000, PFC, Harvest, Visio 2000,API, PVCS, Installsheild 5.0, Windows2000, MS-Office’2000)

Maine automated child welfare system (macws) Nov’ 01 – Dec’03

State of Maine, ME – USA.

Responsibilities:

Involved in application testing to make sure that all the functionality is implemented for each of the module.

Created tables, stored procedures, functions, database triggers and Optimized query plans with DBAs.

Facilitated Application Design Sessions (JADS) for the development of the financial management module of Macws and Data Conversion related to Finance and maintain state of Maine PFC standards.

Performed troubleshooting and maintenance of applications in a distributed environment consisting of Sybase, Jaguar CTS.

Designed, implemented, and documented the client and task runtime APIs.

Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.

Created Linked ODBC tables to Sybase Server to facilitate Inserts and updates.

Extensively used Embedded Dynamic SQL in PowerBuilder for Dynamic Reports and Queries.

Extensive coding, testing, fixing bugs, enhancement was in C/C++ and use of Win NT for batch jobs.

Migrated (Conversion) the application from PB 7.0 to PB 8.01/9.0.

Modified and enhancing the application by making appropriate code changes and testing the software as per the specifications, Data Conversion, Interfacing with other DBMS, Pilot testing.

Written stored Procedures and triggers for batch conversion for auto scheduler.

Responsible for system administration and continuous process improvements as needed.

Create and deploy components on to application server sybaseEAS.

Responsible for setting up and maintaining SYBASE SQL Server11.x, 12.x development and production environments. Database Administrator for 5 productions and 2 development SYBASE SQL Servers.

Developed RPC for extensively used in communicating with database.

(PowerBuilder 8.03/9.0, PFC, C/C++, Sybase 12.5, EA Server4.2, Visio 2000,API, PVCS, Installsheild, Windows2000, MS-Office’2000)

Common Order Information Systems (Mar’ 00 to Oct’01)

Pacific Bell, San Francisco, CA, USA.

Responsibilities:

AS a Lead PowerBuilder Programmer / Business Analyst

Wrote high-level, detailed design documents and test plans.

Performed QA testing of modifications and enhancements to ensure system integrity. Debug and resolve production problems

Created and altered tables, procedures, Packages, functions triggers and functions.

Involved in Frame work design using PFC.

Created User Objects, windows, datawindows and functions.

Utilized PVCS change control to keep track of version object development changes and to track migration changes and specification changes.

Developed Secured Authentication Model for users of Pacific Bell Site.

Designed and implemented interfaces using embedded server side script to automatically generate asp pages.

Created Distributed object for business logic.

Created a Windows Sockets programming API for PowerBuilder called the "PowerSocket Library" to enable PowerBuilder programmers to write Internet applications.

Developed text and graphic reports using Crystal reports and various standard templates for easy maintenance and for future scalability.

Developed business layer COM(C++) components instances of which are called in Transaction forms.

Apart from these Responsibilities was involved in Client's Onsite for the product Installation, and Training. Provided Telephone Support and trouble shooted major problems and resolved the issues.

Developed Pro*C programs to generate reports from an oracle database (including requirements gathering).

Developed routines for data transfer and conversion between new (NT) and legacy (VMS) systems, using Oracle 8, Pro*C.

Created data-driven pages in ASP, VBScript, ADO, InterDev 6.0, HTML/DHTML, JavaScript

(Power builder6.0/7.0, C++, VB 6.0, Asp3.0, IIS 5.0, MTS2.0, COM, C++/PRO C, Oracle 8.0, SQL Builder, Ms-Sql Server7.0, PFC, PVCS, Windows NT, MS-Office98)

Inventory Management System (Feb’98- Jan’ 00)

Standard Organic Ltd.,

Responsibilities:

Created flow diagrams and class diagrams for the application being developed.

Designing standard Framework as per PowerBuilder Foundation class.

Developed several key components of the system, enabling the GUI developers to write business-level code.

Created system requirement specifications and prototyping.

Created data entry screens with validation rules.

Created stored procedures views, indexes, Packages, triggers and functions.

Performed database integrity testing.

Made Builds and deployed executables (Implementation).

Interacted with end users to determine the feasibility, cost, time requirement, and compatibility with current system and computer capabilities.

Created batch programs using C and UNIX.

Customize Oracle Forms and Reports.

Performed Database conversion between a Prime system and an Oracle NT Database.

Designed and developed the implementation of this three tire project to separate the business logic from the presentation Layer and data layer.

Modified and enhancing the application by making appropriate code changes and testing the software as per the specifications, Data Conversion, Interfacing with other DBMS, Pilot testing.

Created Oracle Server Login to users, object permissions and backups, restore for data transfer.

Develop new Forms and Reports based on user specification.

(PowerBuilder6.5, COBOL, UNIX, C, C++ PFC, PVCS, Oracle 7.3, Forms, Reports, Windows-NT, MS-Office98)

Contact this candidate