Prakash Mirani
IT Technical Expert
Cell# 980-***-****
Email – **********@*****.***
SUMMARY OF EXPERIENCE:
Solid Academic and Industrial background in Banking, Government, Utility Companies
Multiple Roles/Responsibilities –
-Technical Development Lead
-Application Support Lead
-Release Management Lead
Strengths -
Continuous Improvement
Always ON
Quick learner
Team player
Efficient developer with solid experience in Client Server, Oracle PL/SQL and Web Technologies,
Database Programming, Software Architecture, Application Design and Development,
Program and Project Management, QA, Technical Writing, Data Science
SKILLS and SOFTWARE:
Operating Systems: Windows 10-XP, Windows Server 2000-2012, NT, DOS, Unix (Sun, HP), Linux
Languages: PowerBuilder,C#, ASP.NET, Java, Python, Perl, R, VB, VB.NET,
SQL, PL/SQL, HTML, CSS, VBScript, JavaScript, XML, Autosys,
Unix-Shell, CGI(Perl), UML.
Software, IDEs and SDKs:
MS Visual Studio 2003-2013,
.NET 1.0-4.0, R,
Perl, JSP 1.2-2.2, ASP 1.0-3.0, Sybase EAS Studio,
PowerBuilder 4-12 - Expert/Champion
IBM Rational Software Architect and Application Developer,
Web Servers: Oracle BEA Web Server, IBM Websphere 6-8, MS IIS, Apache, Tomcat.
DBMS: IMS, RBMS, Oracle 7.x-12.x, Sybase 11.x-15.x, Sybase Adaptive Server Anywhere 6-15, MySQL,
Database API and Design Tools: TOAD, Oracle SQL Plus, ErWin
Class Libraries and Frameworks:
PFC 5.0-7.0, MVC, JQuery, Hibernate.
Software Design, QA and Version Control Tools:
IBM Rational Architect, ClearQuest, ClearCase, SDLC, Visio, PVCS, Subversion.
Program and Project Management:
Developing New Initiatives, Use Cases, Status Reporting, Risk Management,
Budget Planning, Schedule and Development Phase Planning, Stakeholder Communication,
Project Scope Management, Change Requests, Collecting Project Metrics,
Third Party Relationship Management, Issues Escalation and Corrective Action,
Project Release and Deliverables, Project Reporting, Knowledge Transfer.
Content Creation and Management: HTML, DreamWeaver, Flash, Photoshop, SharePoint.
eLearning and LMS:
Tutorial Development, Instructor Manuals, Webinar Development
QA and UAT Testing:
System and Unit Testing, Integrated System Testing, User Acceptance Testing,
Browser Compatibility Testing.
Technical Writing:
User Requirements, System Requirements, System and Application Diagrams, Data Diagrams,
Application Development Guidelines and Standards, User Guides, Build Analysis, Gap Analysis.
Release Management -
Code Merges, Build/Deploy - Multiple environment - DEV, IST, UAT, Productions Installation,
Post Production Check out/Verifications.
WORKEXPERIENCE:
Wells Fargo Bank, Senior Technical Lead
Release Management Lead May 2014 – Present
Roles/Responsibilities:
•Daily Build/Deploy –
•Oracle DBWORK, Autosys, Unix/perl, Java
•Java – Using AntHillPro, JENKINS, UCD
•PowerBuilder - Support/Testing
Develop/Maintain PowerBuilder Applications
Created new Datawindow/Window/User Objects
Datawindow objects using PL/SQL as data source
Created DDL/OLE interface objects
Prepare PowerBuilder Build as needed
Resolve Critical PowerBuilder Issues
•Code Merges using SVN, Prepare Dry Run Plans, Release plans, Environment Refresh, Release Dry Runs, Production install
Development Technical Lead Aug 2011 - May 2014
Roles/Responsibilities:
•Lead Development Team
•Involve in complete Software life cycle development process
oReview BRD, Prepare Functional Design, Prepare Technical Design
•Migrated Enterprise wide Large Collections PowerBuilder Application to JAVA
•Developed Spell Check with PB interfacing with MS WORD
•Developed OLE Interface in many Application modules
•Interfacing with Credit Reports
•Accounts having Legal Cases in Legal Module
•Worked on DDL objects interfacing with other applications
•Receiving request to open account using other applications.
•Expert in interfacing DataWindow objects with PL/SQL stored procedures
•Environment – JAVA, PowerBuilder, Oracle PL/SQL, Unix/Perl, Autosys, IBM Webshere, IBM Eclipse studio, TOAD, PL/SQL Developer
Support Team Lead June 2007 - July 2011
Roles/Responsibilities:
•Lead Support Team
•Resolve PAC 2000 tickets
•Analyze PAC tickets,
•Review Technical Design,
•Mentor Team,
•Introduce/Implement new process/Coding Standards.
•Extensive coding in PowerBuilder and PL/SQL
•Developed Analysis/Design document Templates
•Code Reviews - PowerBuilder, PL/SQL
•Environment – JAVA, Oracle PL/SQL, Unix/Perl, Autosys, PowerBuilder, TOAD, PL/SQL Developer
Development Technical Lead July 2004 - May 2007
Roles/Responsibilities:
Involved in requirement gathering, analysis, debugging, code review and maintenance of PowerBuilder based application.
Lead Development Team – Created PB Development standards document
Involve in complete Software life cycle development process
Redesigned entire collection application to new UI single handedly
Developed PB to MS word interface via OLE to generate MS Word letters
Played key role in product go-live implementation while working on site.
Created database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using Oracle PL/SQL.
Designing and implementing the system enhancements which utilized PowerBuilder for dynamic front end user interface.
Involved in migrating code from PowerBuilder 7 to PowerBuilder 10.5
Created/Modified DataWindows, Windows, User Objects, Menus in PowerBuilder.
Examining the user interfaces, scripting the Database functions and procedures according to the requirement.
Designed and Developed Windows, Datawindows & User Objects in PowerBuilder.
Developed Front end windows using PowerBuilder v10.5 and PFC services with Sybase and Oracle as backend.
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
Develop technical specifications and solutions in support of business requirements.
Implemented the Mail API service in PowerBuilder code to alert the users in case of any job failures.
Created Use Cases to describe the System needs program functions to develop or modify the system and programs.
Developed Front end windows using PowerBuilder v10.5 and PFC services and Sybase ASE 15.5 as backend.
Written unique PowerScript to handle the actions created by various components of the application.
Build solutions and deploy to staging and development environments and do initial testing before assigning the ticket to QA and UAT.
UsedTest Management ToolQuality CenterforTest Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Reporting.
Administrated Oracle server with Linux, indexes, tables, views, users, profiles, synonyms, tables space, data files, backup, restore, performance, tuning.
Create and update deployment scripts and documents.
Environment: PowerBuilder 10.5, UNIX, java/j2EE, Linux, Oracle9i/10g, Sybase ASE 15.5, Perl, PowerScript, Testing, TOAD, PL/SQL, EA Server 6.1, Quality center, XML, shell scripting, Visual studio .NET
Pacific Gas and Electric - Technical Lead/Sr. Software Engg March 1997 - Aug 2004
Roles/Responsibilities:
Involved in requirement gathering, analysis, debugging, code review and maintenance of PowerBuilder based application.
Lead Development Team – Created PB Development standards document
Involve in complete Software life cycle development process
Worked Extensively with Energy Rebate program related applications
Developed PB to MS word interface via OLE to generate MS Word letters
Played key role in product go-live implementation while working on site.
Created database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using Oracle PL/SQL.
Designing and implementing the system enhancements which utilized PowerBuilder for dynamic front end user interface.
Involved in migrating code from PowerBuilder 7 to PowerBuilder 10.5
Created/Modified DataWindows, Windows, User Objects, Menus in PowerBuilder.
Examining the user interfaces, scripting the Database functions and procedures according to the requirement.
Designed and Developed Windows, Datawindows & User Objects in PowerBuilder.
Developed Front end windows using PowerBuilder v10.5 and PFC services with Sybase and Oracle as backend.
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
Develop technical specifications and solutions in support of business requirements.
Implemented the Mail API service in PowerBuilder code to alert the users in case of any job failures.
Created Use Cases to describe the System needs program functions to develop or modify the system and programs.
Developed Front end windows using PowerBuilder v10.5 and PFC services and Sybase ASE 15.5 as backend.
Written unique PowerScript to handle the actions created by various components of the application.
Build solutions and deploy to staging and development environments and do initial testing before assigning the ticket to QA and UAT.
UsedTest Management ToolQuality CenterforTest Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Reporting.
Administrated Oracle server with Linux, indexes, tables, views, users, profiles, synonyms, tables space, data files, backup, restore, performance, tuning.
Create and update deployment scripts and documents.
Environment: PowerBuilder 10.5, UNIX, Linux, Oracle9i/10g, Sybase SQL Server, Perl, PowerScript, Testing, TOAD, PL/SQL, EA Server 6.1
References
Stan Banner – Wells Fargo Bank - Technology Lead - Cell - 704-***-****
Vasu Vanam – Wells Fargo Bank - Technology Manager - Cell - 415-***-****