SMITA SHAH
Senior PowerBuilder Consultant
OBJECTIVE
Pursue a challenging and growth oriented position as a Programmer Analyst that
would best utilize my strong technical, project management, and business skills.
SUMMARY
IT consultant with over 9 years of experience in all phases of Software
Application Development encompassing the full life cycle of projects
Expert at Power Builder Technologies with 5 years of professional experience
in developing and managing Power builder application using OOP, RDBMS, GUI, PFC
objects.
Extensive experience in developing, managing and supporting Oracle
applications with focus on client/server architecture
Proficient in writing oracle stored procedures, Packages, Triggers and
functions using SQL & PL/SQL & SQL*Loader
Highly motivated problem-solver with excellent analytical and communication
skills.
Versatile team player with good interpersonal skills.
Very good exposure to various quality and review processes.
Expert at Production support activities in the Insurance domain.
Executed software projects for Insurance domain. Posses good knowledge in
Insurance Investment domain.
Complete understanding of QA methodologies. Expertise and experience in
performing different kinds of testing like, functionality testing, unit testing,
integration testing, performance testing, load testing, and system testing for
the various batch process and applications and bug tracking.
Performed analysis of current functionality and recommend process improvements
for enhancement.
Conversant with all phases of Project Life Cycle including Requirement
gathering, Analysis, Design, Development, Implementation, Testing, Software
quality standards.
Have a good combination of technical, business background communication and
interactive skills.
Highly motivated with the ability to work effectively in teams as well as
independently.
Complete understanding of the Oracle database hierarchical structure.
TECHNICAL SKILLS
Hardware(s): IBM Compatible PCs
Operating System(s): UNIX, Windows Vista/ XP/2000/98/95/3.1/3.11, MS DOS
Database(s): Oracle v10g/ v9i/ v8i/ v8.0/ v7.3/ v7.1, PL/SQL,
Sybase, MS Access 2000, SQL Server
GUI (s): Power Builder 10.0/ 9.0/8.0/7.0/6.5, PFC ,Visual Basic 6.0 and ODBC,
Developers 2000, Forms 5.0/4.5, Graphics 2.5, Reports 3.0/2.5
Web Technology: ASP.NET, ADO.NET, Visual Studio.NET, VB.NET, HTML Web
Services, Win Forms, SOAP
Language(s): C#, C, COBOL, FoxPro, Visual Basic
4GL (s): SQL
Tools: TOAD, MS Visual Source Safe, WRQ Reflection, Embarcadero
Network(s): Novell NetWare 3.12/3.11/2.2, Windows NT
Other Utilities: MS Office 2006/2003, Lotus
PROFESSIONAL EXPERIENCE
Bobs stores (Retail chain business)
Connecticut, CT 07/2008 to Present
Role Sr. Power Builder Consultant
Project: Flash Sales Application
It is a window based application which is mainly used as tools for different
types of sales reports for each store in different regions and markets.
Responsibilities:
Actively contributed in requirement gathering, analyzing and designing of the
systems
Developed, Implemented and tested the crosstab reports
Designed and developed the database tables and wrote complex queries, stored
procedures
Developed the crosstab sales reports for each stores in different regions and
markets
Prepared the system document
Environment: Application employs a client/server architecture using Sybase 12.5
as back end and Power Builder 10 as
Front end using PFC objects.
Project: Style Count Application
This is window based application which is mainly used as tools for tracking
inventory of each style in each department in the company.
Responsibilities:
Actively contributed in requirement gathering, analyzing and designing of the
systems
Developed, Implemented the PFC based application and tested the reports
Designed and developed the database tables and wrote complex queries, stored
procedures
Developed complex style count reports based on department and sub department
of the company using stored procedures as data source
Developed UNIX script to run the batch jobs
Prepared the system document
Environment: Application employs a client/server architecture using Sybase 12.5
as back end and Power Builder 10 as
Front end using PFC objects.
Project: On Order Flow Application
This is window based application. The application is for tracking month wise
purchase order of each style vs. forecasted receipt and sales of styles in each
department in the company in a fiscal year. The report covers the past current
and future orders for each style.
Responsibilities:
Contributed in requirement gathering, analyzing and designing of the systems
Developed and tested the reports
Designed and developed the database tables and wrote complex queries, stored
procedures
Developed complex on order flow reports using stored procedure as data source
for each department and sub department of the company
Developed UNIX script to run the batch jobs and loaded data from external data
files into interface tables using
BCP format files
Prepared the system document
Environment: Application employs a client/server architecture using Sybase 12.5
as back end and Power Builder 10 as Front end using PFC objects.
Allstate Insurance Co, (The nations largest publicly held personal lines
insurer.)
Chicago, IL
11/2004 to
07/11/2008
Role Sr. Power Builder programmer
Project: Pricing Application
It is a windows based application which collects prices for securities currently
owned by Allstate Insurance Co. using a variety of vendors as well as providing
an interface to verify, validate and modify these prices. This application
automates the arduous task of updating numerous prices on a daily basis.
Trade Capture Applications
These are windows based applications which are used for the entry of all fixed
income security trading activity and some equity security trading within the
investment department of Allstate Insurance Co. Security and Trade information is
entered and managed both prior to and after trade settlement. The application is
also used as a reporting tool. There are various online maintenance screens and
reports available. The application interface with other systems.
Responsibilities:
Developing, Implementing and Supporting Pricing Application, Trade Capture,
Collateral Management systems
Designing and modifying the database table and wrote complex SQL queries,
stored procedures, functions and triggers in oracle as per business rules set by
the client.
Developing front end maintenance screens to verify validate and modify these
prices, developing Management Information System reports. Automated process of
sending price request email to various brokers and loading prices into the
database using SQL*Loader.
Extensive interaction with Client and Vendors
Responsible for testing the application and post implementation support and
trouble- shooting.
Developed and updated application documents, involved in presentation of
Pricing Application, its functionality and business process
Provided freshman training to new team members
Environment: Application employs a client/server architecture using Oracle 10g,
PL/SQL, SQL*Loader, UNIX, Toad 8.6, Power Builder 10.0/8.0 using PFC objects,
TIBCO and Remote plus and Tivoli job scheduler
Project: Bond Edge Application
The Bond Edge fixed income portfolio analytics system is designed to give
clients an edge when evaluating risk, analyzing returns and meeting reporting
demands from clients, internal management, regulators and rating agencies.
Muni Credit scope/Perform and Private Placement Credit Scope/Perform are vended
application provided by Investor Tools.
Muni Credit Scope/Perform applications used for the analysis of the performance
of Municipal bonds and the credit stability of the bonds issuers. Users employ
the applications to assist in making Municipal Bond trading decisions for the
upcoming day, and to track the indicative data on the Municipal Bonds and their
issuers.
Private Placement Credit scope/Perform applications replaces several loosely
connected processes into a single application that will track pending Deals in
the Market as well as deals that we already own. It also tracks Deals that
Allstate has turned down for historical monitoring purposes.
Responsibilities:
Supporting Bond Edge, Muni Credit Scope/Perform , Private Placement Credit
Scope/Perform applications
Extensive Interaction with Client and Vendors
Responsible for testing the application and post implementation support and
trouble- shooting.
Environment: Vended application developed by Investor Tools using proprietary
database, windows batch process, Tivoli job scheduler
Project: Collateral Management System 02/2005 to 08/2005
Collateral Management system provide all relevant parties with the functionality
needed for efficient and centralized tracing of collateralized and restricted
securities for better liquidity management.
Fund Management Systems is a real time solution that gives portfolio managers,
traders and operation managers an edge in successfully managing their funds.
Responsibilities:
Developed, Implemented and Supported Pricing Application, Fund Management
System and Supporting Collateral Management system
Designed and modified the database table, converted data into newly designed
database. Developed complex SQL queries, oracle PL/SQL stored procedures,
functions and triggers in oracle as per business rules set by the client.
Developed and modified front end maintenance screens to verify, validate and
modify these prices, developed Management Information System reports as per
requirements of the client.
Developed UNIX script to run the batch jobs
Responsible for testing the application and post implementation support and
trouble- shooting.
Environment: Application employs a client/server architecture using Oracle 9i,
PL/SQL, UNIX, Toad 7.6, Power Builder 8.0/ ASP.NET and Remote plus to perform
data extracts and Unicenter job scheduler.
Base Information Management (P) Ltd., Mumbai India
Role: Programmer- Power Builder
12/2000 to 10/2001
Client: Edwards Life sciences India, Pvt. Ltd.,
Project: Financial Accounting Integrated System
Developed and implemented the Finance module of an integrated system that
maintained records of each entity or company that had business transactions with
organization. Module involved receipt, payment, and accounting data entry
screens, bank reconciliation statement, and budget vs. actual data comparison
report generation tools.
Responsibilities:
Participated in a study evaluating clients existing accounting/finance
system
Developed account master, supplier master, customer master data entry screens,
customized bank and cash payment and receipt data entry screens. Developed tools
to generate debtor, creditor, accounts payable, accounts receivable, financial
statements, and Management Information System reports.
Responsible for testing the application and post implementation support and
trouble- shooting.
Facilitated user training
Environment: Application employs a client/server architecture using Oracle 8i.0
as back end and Power Builder as front end, UNIX scripts
InfoSoft Services, Mumbai, India
Role: Functional Consultant
04/2000 to 08/2000
Project: Financial Accounting System
Involved in understanding the requirement of the client of existing Financial
Accounting system. Coordinated the requirements for developing the integrated
systems as part of a team. Module involved receipt, payment, and accounting data
entry screens, bank reconciliation statement, and budget vs. actual data
comparison report generation tools.
Responsibilities:
Involved in a study evaluating clients existing Financial Accounting system
Developed financial reports generation tool
Checked and documented functionalities of the Finance module and the
integrated system
Consulted with clients testing the functionality of the system and performed
trouble-shooting
Environment: Application employs a client/server architecture using Oracle 8.0
as Back end and Developer 2000, Forms 5.0, and Report 3.0 used as Font end
Systems and Support Services, Mumbai, India
Role Coordinator - Functional &Technical
08/1999 to 03/2000
Project Title: Financial Accounting and Purchase Systems
Involved in understanding the requirement of the client for Financial Accounting
and Purchase systems. Coordinated the requirements for developing the integrating
systems. Module involved Bills Receivable, Bills payable, and accounting data
entry screens, bank reconciliation statement, Materials to purchase, evaluating
quotations, placement of purchase order and budget vs. actual data comparison
reports.
Responsibilities:
Involved in a study evaluating clients existing Financial Accounting and
Purchase system
Developed transaction front-end screens and report tools, data entry screens
for placing and verifying purchase orders, entering receipt of materials, and
checking the purchase transactions effect on Finance module
Checked and documented functionalities of the Financial Accounting module and
Purchase module in integrated system
Consulted with clients and performed trouble-shooting
Environment: Application employs a client/server architecture using Oracle 7.3,
Developer 2000, Forms 4.5 and Report 2.5.
Triveni Infosystems Ltd., Mumbai, India
Role: Software Engineer
08/1997 to 07/1999
Project: Procurement System
Developed Procurement system and supported in menu driven accounting systems.
Understanding the requirement of the client designed and developed Export systems
as a member of a team.
Responsibilities:
Developed item master, supplier master, customer master data entry screens and
general ledger, creditors ledger, debtors ledger, financial and MIS statement
reports Customized transactions data entry screens for the Purchasing and
accounting modules
Developed financial reports generation tool
Understanding the requirement of the client. Developed and Checked
functionality of the Export system.
Consulted with clients and facilitated user training
Environment: Application employs a client/server architecture using Oracle 7.1,
Developer 2000, Forms 4.5, Report 2.5, Graphics 2.5, SQL, and PL/SQL used for
development.
Tarille Corporation Ltd., Mumbai, India
03/1995 to 07/1997
Programmer
Project: Finance and Accounting Systems
Developed and implemented Finance, Transportation and Stock Exchange systems, as
a member of a team.
Responsibilities:
Developed menu driven accounting system that included:
Account masters, transaction data entry screens
Accounting, Financial and Management Information system reports
Communicated end user requirements to Software Developers
Performed testing on reports developed by other team members
Conducting functionality testing of Transportation and Stock Exchange systems
Provided the user training
Environment: Application employs a client/server architecture using Oracle 7.1
as back end Developer 2000, Forms 4.5, Graphics 2.5, Reports 2.5, Procedure
Builder 1.5, SQL, and PL/SQL used to design the systems.
EDUCATION
Masters of Business Administration (M. Com), University of Bombay, Mumbai,
India (1994)
Diploma in Systems Management (Hon.), National Institute of Information
Technology (NIIT), Mumbai, India (1992)
Bachelor of Commerce, University of Bombay, Mumbai, India (1991)
Certificate in Advanced Programming languages, IBS Computer Academy, Mumbai,
India (1990)
AWARDS
Received High performance Award (2006) one outstanding employee out of team
of 83 recognized annually.
|
