Hitesh Keshani
Email:
hmkeshani@gmail.com
I have over 12 years of experience in Project Management,
Data Conversion, Data Modeling, Analysis, Design and Development of Application
Software and User Support.
SKILLS PROFILE
|
Databases: |
Oracle 7.x / 8i / 9i /10g, SQL Server
2000, Sybase 12.5 |
|
Data
Modeling / ETL Tools: |
Power Designer, Data Transformation Services (DTS), SQL Loader |
|
Application
Development Tools: |
PowerBuilder 8.0, Visual
Basic 6.0, Oracle Developer 2000, Oracle
Forms, Oracle Reports, Object Cycle, PowerTools, PFC, Infomaker, PL/SQL
Developer Debugging Tool. |
|
Desktop
Tools: |
MS Office, Lotus WordPro, MS Project |
|
Hardware: |
IBM PC, HP 9000, Sun Microsystems |
|
Methodologies
/ Techniques: |
Client-Server Development, Data Warehouse
methodologies |
|
Operating
Systems: |
MS Windows XP / 2000/ 2003, 95/98, HP/UX, MS DOS, Sun Solaris,
SCO/UNIX, Novell NetWare, AIX 5.3 |
|
Programming
Languages: |
SQL, PL/SQL, |
|
Utilities
/ Command Languages: |
FTP, LPR Spooler, Wincvs, Textpad, Visual Source Safe,
PVCS, Rational Pro |
|
Industries: |
State Government, Banking, Finance, Trading, Insurance |
|
Functional
Areas: |
Object Oriented Analysis/Design, Systems Analysis, Data
Modeling, Finance / Accounting, Payroll, Testing, Interviewing |
|
Methodologies: |
Productivity Management (PM), Project
Estimating and Risk Management (PRAM) |
Oracle 10g: Java Programming Ed 1.2 using Oracle
JDeveloper.
11i/2.6
Implement Oracle Workflow Ed 3
Sybase Inc, 2001
Keane Inc, 2003
Project Estimating and Risk Management (PRAM)
Keane Inc, 2003
PROFESSIONAL EXPERENCE
Liberty Mutual Insurance Company
Senior
Software Engineer –Team Lead for Oracle Applications.
Liberty
Mutual Insurance ranks 102nd on the Fortune
500 list of largest
Presently I am working on the Oracle Applications E- Business suite
version 11.5.10.1 to support the Oracle Accounts Payable/iExpense Modules and the
Websqribe Application for Account Payables. My roles and responsibilities
include:
iExpense Modules
·
Upgrade Application to OiE.J, Family
Pack.
·
Customizations in Workflow.
·
Customization of the PL/SQL procedure
and Packages.
·
Support the upgrade of the Oracle
Database to 9.2.0.7 and existing application.
·
Upgrade the Discoverer 10g Reporting
front application.
·
Upgrade of the latest Financial pack to
Accounts payable, Account Receivable and General Ledger.
Websqribe Application with Sybase.
Enhancement s, Maintenance, and support for
creating new Reports for the Websqribe Application.
·
Create new SQR web reports for the
users to query from the Application.
·
Create batch reports in SQR and deploy
to production.
·
Write shell scripts to execute and FTP the
reports.
·
Upgrade application to Java 1.4, SQR
Server 8.3, Sybase database 12.5 and Aix Unix 5.3.
The Bureau of Motor Vehicles (BMV) is designed to serve the resident and users of the State of Maine
I worked on converting the Legacy data from the Bull
Mainframe to the Oracle 10g Environment. My roles and responsibilities
includes:
·
System Administration and Database Administration of
SQL Server.
·
Analysis, design and documentation of the
requirements for the Bureau of Motor Vehicles system.
·
Working with client, developers and upper management
to assure all business needs are implemented.
·
Creating source-to-target mapping.
·
Converting and loading the data from legacy system.
·
Involved in the physical database design and database
tuning.
·
Developed test scripts for configuration and
functional testing.
·
Project planning and evaluation on weekly basis.
·
Metadata preparation.
Keane, Inc, 07/2002-
06/2004
STATE OF
Analysis, maintenance and enhancement of the State of
·
Served as Release Coordinator/Project Manager
for our
·
Resolve defects occurred during Client
Acceptance testing.
·
Evaluated,
tested and tuned the system.
·
Provided
maintenance and upgrades to the application.
·
Served as the Keane Testing Coordinator for the Eastport
release, and coordinated the deployment of the release after completion of the
system and client testing.
·
Wrote specifications for the system test plan for the
release.
·
Led team of client and vendor developers for the software
release.
·
Defined requirements, organized specifications, and
prioritized workloads for distribution.
·
Provided
cross training to staff for knowledge transfer of information relating to the
Finance Module.
Environment: PowerBuilder
8.03, Oracle 9.2, WS_FTP, LPR Spooler, Object Cycle, PowerTools, PFC, PVCS,
Wincvs, VSS, Textpad, PL/SQL Developer tool.
For the State of
·
Designed and
developed the Financial Management module, and participate in Joint
Applications Design Discussions (JADS) for the analysis, design, development
and enhancements of the MACWIS Application.
·
Enhancements
involved: development of the Automated IV-E Eligibility Enhancement; migration
of the existing Power Builder 6.5 application to Power Builder 8.0.1; financial
payroll enhancements, including object design and coding; adding Accrual
process information to the payrolls; service authorizations in the Case Module;
a safety assessment in the Assessment Module; interface with the IV-D Child
Support; PFC Security Changes required to use Power tools; and Medicaid
Eligibility Interface Enhancements.
·
Analyzed,
designed and developed the Financial Management Module. This consisted of: Accounts Payable / Account
Receivables, ledgers, budgeting and forecasting processes, contract services
for the child welfare vendors, child welfare payroll, miscellaneous payroll,
authorizations review prior to making payments, Bills Processing, and
Administrative Services.
·
Designed and
developed more than 50 financial management complex reports. All reports were related to the State and
Federal financial funds with forecasts for their three payrolls which run
weekly and are sent through FTP to the State's Accounting Mainframe System (MFASIS).
·
Wrote batch
processes in Oracle to verify the payroll funding account codes, and to match
the State and Federal funding after processing the payrolls.
·
Met with clients
at the project site and off-site to gather data / information for the three
major deliverables (Requirement Specifications, General Design, and Detail
Design Documents) for the MACWIS interfaces.
·
Designed and developed the following interfaces:
MFASIS (State of
Environment: PowerBuilder
8.01, Oracle 7.3.4, WS_FTP, LPR Spooler, Power Designer, Object
Cycle, PowerTools, PFC, PVCS
The system maintains
computer components and availability of various software products versions, and
provides information to departments to maintain inventory and purchase.
·
Responsible for
analysis, design, and development of the Inventory Tracking system.
·
Provided report
generating and invoicing capabilities.
· Evaluated, tested and tuned the system.
Environment: Visual
Basic, MS Access
Designed and developed data entry and query screens for the Imports division, and developed a format for printing letter-of-credits for various banks and indents for clients.
Generated monthly
reports using Reports 2.5 and Graphics 2.5 as follows:
·
Clients
Instructions outstanding.
·
Clients L/C
outstanding.
·
L/C opened but
goods not shipped by the supplier.
·
Goods received
but commission outstanding.
·
Total commission received during the
month indent-wise & client-wise.
Environment: Oracle Developer 2000, Oracle Forms, Oracle Reports
Designed and developed purchase and sales transaction menus with online Cash-Memo. This included support for query, updates, or print Inventory with various options. Generated daily reports using the Powerbuilder report for cash and credit sales analysis.
·
Generated the
following reports: Date-wise Gold & Currency Quantity and Valuation
(Item-wise /Branch-wise); Daily Gold & Currency movement; Daily Item-wise
and Branch-wise Gross Sales.
Environment: PowerBuilder,
Oracle
Designed and developed the
Dual Currency Financial Accounting system and created new windows, data windows
and user objects for entry and query screens.
Deployed the accounting package creating the PBD's at every branch of
the company.
· Created the following reports: Daily Audit Trial; Any Date Trial Balance; Monthly Branch-wise and currency-wise Profit / Loss report for Central Bank Of Oman; Monthly Ledger Printing of all individual currency accounts.
· Conducted training for all account clerks.
Environment: PowerBuilder,
Oracle
For a Foodstuff and Textile business, developed the multi-user Financial Accounting system in
Foxbase that produced various management information reports. Reports included: Daily Audit Trial; Accounts
Receivable aging Analysis; Accounts Payable; Trading Profit & Loss; and
Balance Sheet.
Environment: Foxbase, Sco Unix
Foreign Currency Checks Reconciliation project: computerized Private-Banking certified checks and reconcile them with Indian Rupees, Bangladesh Takas, and US Dollar Drafts issued by Exchange Houses.
Food stuff and Textile Inventory and Sales Analysis project: computerized the Foodstuff and Textile Wholesale Departments with their inventory and sales Analysis system. Participated in all aspects of the project beginning from analysis, design, development, testing and deployment, to training management and internal staff to utilize the system.
· Created the following reports: Inventory Report; Sales Analysis Report of the Total Inventory; Sales Analysis Report By sales Team.
Environment: Foxbase, Sco Unix
BACHELOR OF COMMERCE
Financial Accounting and Auditing,
Export Management and Economic Systems
Team Award: Keane Inc,
State of
04/04
Commissioner Award for Excellence on the
MACWIS Project
State of
02/98
Immigration status: Permanent Resident