Srinivas Sanganbhatla
2824 El Lago North Drive, Apt B, Indianapolis, IN 46227 USA
Phone: (317) 783-1879 E-mail:
srinisan@rediffmail.com
- SUMMARY
-
* Total 6 years of IT experience, worked on diversified projects in different technology areas
* About 1 year each in Data Warehousing, Java, Visual Basic and internet technologies
* More than 2 years in Mainframe environment
* Over 6 years of experience in management, administration, accounts and customer service
- EDUCATION
-
* Bachelor's degree in Commerce from University of Mumbai
* Diploma in Computer Programming from Indo-German Institute, Mumbai
* IBM Mainframe training from Param Education, Mumbai
* E-commerce training from Kiosk Computers Pvt. Ltd., Mumbai
- SKILLS
-
* Data Warehousing: Cognos Impromptu, Transformer, Powerplay, Informatica, Business Objects, Designer, Supervisor and ERwin
* Mainframe: COBOL, JCL, DB2, IMS DB,CICS, VSAM, MVS, TSO/ISPF
* Java: Core API, Servlets, JSP, JDBC, Swing
* Languages: VB 6,SQL, Java Script, VB Script, HTML 4
* Databases: Oracle 7, MS-Access, dBase III+
* Operating Systems: MS-DOS, Windows 95, Windows NT
* Tools: MS FrontPage, Adobe PhotoShop
- EXPERIENCE
System Analyst, HDFC Securities Ltd, Sep 2000 to Mar 2003
Data Warehousing Project, Apr 2002 to Mar 2003
HDFC is one of the largest business organizations with diversified interests. HDFC has a unique ability to deliver multiple products through multiple channels to meet customer needs in an integrated manner. We have extracted data from different data sources and then created several Data Marts to answer various business requirements.
* Involved in the requirement definition and analysis in support of data warehousing efforts.
* Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Repository Manager and Server Manager.
* Designed and maintained Impromptu Catalogs, Folders, Templates, Reports and snapshots.
* Set up user classes and privileges, partly responsible for Impromptu Administration
* Interacted with users to identify information needs for reports.
* Created User conditions, calculations, prompts and Filters to improve the report generation.
* Created the Power cubes from the Transformer.
* Trained user groups for administration support and report generation
* Created reports in HTML format for easy navigating of data from web browser
* Developed BO Universes using Designer and used Business Objects for reporting
* Provided BO administrative support with Supervisor
* Also responsible for administrative, personnel and general management activities.
* Reconciled and maintained over 150 accounts pertaining to major financial institutions
* Recovered outstanding receivables worth more than INR 14 million
* Resolved problematic cases related to stocks worth over INR 20 million
Computer Assisted Policy Holders Service (CAPS), Equitable Insurance, NY, Mar 2001 to Mar 2002
As an Analyst/Applications Consultant, engaged in the project development and maintenance of CAPS (Computer Assisted Policy Holders Service), for the Equitable Insurance, New York, USA. Equitable Insurance is one of the leading insurance companies in USA. It consist of many sub-systems, which were used to process and maintain various policies/schemes for the policyholders. The scope of this project is conversion from OS/VS COBOL to COBOL - 370, maintaining existing programs and database conversion from IMS to DB2.
Responsibilities:
* Actively responsible for the analysis, development, modification and testing of the programs.
* Assigning the programs received from the client to the respective team members.
* Updating the various documents such as Status/Task table/summary of changes table for the Project
Manager and the client.
* Communicating with the Project Manager and the client on the issues such as deadline for a
particular Task, Status of the team members, Pending tasks etc.
Environment: IBM 3090, MVS, IMS DB, DB2, OS/VS COBOL, COBOL 370, File Aid, Xpeditor
Customer Satisfaction System (CSS), Franklin Mint, USA, Sep 2000 to Feb 2001
The project consists of various modules, viz. Invoicing, Material Requirement Planning and other relevant functions. This project incorporates both development and maintenance using COBOL II, DB2 and TELON.
Responsibilities: Studying the existing system, writing program specifications for the new programs and taking care of enhancements, modifications, development and walkthroughs of the changes in the programs.
Environment: IBM 3090, MVS, DB2, TELON & COBOL II, Xpeditor.
Responsibilities: Studying the existing system, writing program specifications for new programs, enhancements, modification, development and the walkthroughs of the changes in the programs.
Team Leader, Kiosk Computers Pvt. Ltd., Dec 1999 to Sep 2000
Online Brokerage System (OBS), Apr 2000 - Sep 2000
OBS is an online, fully automated, comprehensive trading product that was being developed for the brokerage industry. It is be used by firms engaged in stock brokerage and financial products distribution. OBS manages the entire business process life cycle apart from allowing the casual visitor to browse through the site for any general information. The initial version of the system supports dematerialized securities meant for compulsory delivery only. OBS performs the following functions viz. User Registration, Investor Order Management, Risk Management, Order Routing, Portfolio Management
Watch list & Alert Management, Interfaces to External Sources, System Administration
Responsibilities: Requirements Collection, Analysis, Documentation
Documented the requirements, Provided functional inputs and programmed in HTML and JavaScript
Web based Applications, Dec 1999 - Mar 2000
The following web sites were developed for various clients using listed internet technologies.
*ecolumbiasports.com *welfabstorage.com *emetalcraft.com *mobileindia.com *prakashprint.com *naturalveneers.com *espeeengg.com *shreyaspackaging.com *mayfieldbearing.com,
Responsibilities: Requirements Collection, Analysis, Development and Testing.
Environment: HTML, JavaScript, VBScript, PhotoShop, Flash, FrontPage, Access
Programmer Analyst, Hexaware Technologies Ltd (CMM V), Jul 1998 to Nov 1999
Metrics Management System (MMS), Jun 1999 - Nov 1999
MMS is developed to collect, analyze and report the metrics of the different projects to improve some of the processes that are currently being followed. In order to facilitate the metrics analysis, is was decided to have a centralized metric collection system which can be used to collect important data related to projects to find out trends, areas of process improvement etc. This system will track the proposed, planned, revisions and the actual metrics for the effort, resources, schedule and the staffing - for software project management activities.
Responsibilities: Documentation, Development and Testing. Documented the requirements, programmed in Java, HTML, JavaScript, JDBC and performed unit Tests.
Environment: Java 2, JavaScript, HTML, Oracle, JDBC, and Java web Server 2.
Knowledge Management System (KMS), Jan 1999 - May 1999
KMS is a repository of all the documents like project plans, project profiles, windup notes, standards documents, lessons learnt, online books for the organization etc. developed for sharing the knowledge across the projects. It was observed that many of the best practices followed in the projects can be used by the other projects which otherwise get lost when the project winds up. KMS is a knowledge store, which maintains the documents related to different projects that can be referred to by the other projects in the organization to make the process of knowledge sharing efficient.
Responsibilities: Development and Testing. Programmed in JavaScript, HTML, Java, JDBC, JSP and Java Servlets.
Environment: Java 2, JSP, Servlets, JavaScript, HTML, ORACLE, JDBC, and
Java web Server 2.
Investment Management System (IMS), Jul 1998 - Dec 1998
Alliance Capital Management, NY, USA.
This project is executed with a view to prepare for the development of a new system to replace the existing Investment Management system of the client with the new system having all the requirements and functionality of the existing application. The detailed data dictionary and program specifications would serve as a supporting document to complement the feasibility study in this direction.
Responsibilities: Preparation of detailed data dictionary and cross-reference documents for all the major files and programs and preparation of comprehensive program specifications.
Environment: IBM S/3090, Host Access terminal, MS-Word, MS-Excel.
Programmer, IIT InvesTrust Ltd. Jun 1997 to Jun 1998
Equity Trading System (ETS), Jan 1998 - Jun 1998
The project involves processing of various transactions handled by the Investment Company. The Company accepts deposits from the customers, invests in the Equity market and declares the Net Asset Value (NAV) of the investments on a regular basis. Investors can add/withdraw funds any time.
Responsibilities: Requirement collection, Analysis, Documentation, development.
Environment: Visual Basic 5, Oracle 7.
Bad Delivery Management System (BDMS), Jun 1997 - Dec 1997
The project involves processing of the shares received under objection (termed as 'bad delivery') by the stock brokerage firm from the custodians who hold shares on behalf of institutional investors. The various modules involved are Master maintenance, Transaction processing, Queries, Reports and System administration.
Responsibilities: Requirement collection, Analysis, Documentation, development and Testing.
Environment: Visual Basic 5, Oracle 7.
For your copy of this Resume, kindly copy and paste it on
Word/Notepad