Management System Software Engineer

SANJEEV HURALIKOPPI

Mobile No: 703-***-****

Email: *********@*******.***

SUMMARY:

Over 15+ years of IT experience in analysis, design, development, deployment, testing and production support of Client/Server Systems.

PowerBuilder V.5-V.12.5 (15+ years’ experience)

Oracle PL/SQL (Stored Procedures, Triggers & Functions, Packages, Views/Materialized view, SQLPlus, PL/SQL Developer, TOAD, MS SQL (Transact-SQL) Stored Procedures and Triggers

Knowledge of Appeon Conversion of PowerBuilder applications.

Background in Unix shell scripts, Business Objects, Control-M Scheduling Tool

Data Modeling using Power Designer, Erwin

Expert in designing PowerBuilder Client/Server applications using Frameworks/PFC.

Expert in writing stored procedures, packages and functions.

Good exposure to overall software development life cycle with good knowledge of processes like version control, bug tracking.

Good Knowledge of Operating Systems and Version Controls

Strong Interpersonal and communication skills, ability to work in a team as well as independently with minimal supervision.

Very methodical and well organized with excellent bottom-line for work.

Good understanding of PowerBuilder Frameworks such as PFC.

Motivated problem solver with strong analytical skills.

A quick learner, punctual and trustworthy.

A capable and resourceful team member. Excellent written and verbal communication skills.

EDUCATION:

MS - Power Systems Engineering

National Institute of Engineering, Mysore

BS - Electrical & Electronics Engineering

National Institute of Technology, Karnataka

SKILLS:

Development Technologies PowerBuilder 12.5/11.5/6.5, SQL.

Databases Oracle 10g/11g, SQL PL/SQL, Server, MySQL

Version Controls Team Foundation Server (TFS), Clear Case/Clear Quest, StarTeam

Operating Systems Windows 7/XP, Windows NT 4.0, Windows 2000

EXPERIENCE:

Unisys Corporation, Reston, VA April 2012 – Present

Role: Senior Consultant - Application Developer/Analyst

Project: Jail Management System (JMS) Application

Responsibilities

Worked on the Production Support, Analysis and Development of New Enhancements of the JMS application.

Tasked to creating New User Interfaces for JMS application.

Tasked to investigate and resolve the issues in production.

Tasked to write Stored Procedures, Packages used in JMS application.

Currently, involved in the Appeon Conversion of JMS (Jail Management System) applications for Nashville Customer. Resolved the issues such as Arrays which cannot be passed as argument in Stored Procedure using PARSE Package where array is converted into concatenated string delimited by comma on the Appeon Side.

Environment: PowerBuilder 12.5, Oracle 11g, PL/SQL, Appeon, TFS and Windows 7 OS.

Unisys Corporation, Bangalore, India Feb 2010 – Apr 2012

Role: Senior Consultant - Application Developer/Analyst

Project: LEMS Console application

Responsibilities

Worked on the Production Support, Analysis and Development of New Enhancements of the LEMS Console application.

Tasked to creating New User Interfaces for LEMS Console.

Worked on making modifications and bug fixing.

Environment: PowerBuilder 11.5, MS SQL Server, Clear Case/Clear Quest and Windows 7 OS.

HCL Technologies Ltd., Bangalore, India Jan 2007 – Feb 2010

Role: Technical Lead

Project: dbFastCollect 5.8 (CCCS)

Responsibilities

Tasked in the development of enhancements in the CCCS, cheque clearing and collection system.

Tasked in the development of Server Upload of transactions where the files are validated in the front end, zipped and transferred to the UNIX server. At UNIX location, the files are unzipped and uploaded with help of shell scripts.

Worked in the development of the Configurable Upload of transactions, where unformatted file is converted into an upload file and uploaded with help of shell scripts.

Worked in writing Stored procedures and Packages.

Environment: PowerBuilder 10.5, Oracle 10g, Control-M, TOAD, AIX 5.3 and Windows XP

First Apex Technologies Pvt Ltd, Bangalore, India Dec 2005 – Jan 2007

Role: System Analyst

Project: XGEN V3 System

Responsibilities

Tasked in Production Support and Maintenance of XGEN V3 SYSTEM.

Worked on bug fixing, making enhancements and modifications such as Renewal Re-extraction and CDB Enquiry to the UNDERWRITING Module of the system.

Tasked in writing Stored procedures and Packages.

Environment: PowerBuilder 6.5, Oracle 8i, TOAD and Windows NT

VERCOM Software Pvt Ltd, Hyderabad, India Mar 2005 – Nov 2005

Role: Senior Software Engineer

Project: Shop Floor Information System (SFIS)

Responsibilities

As a Senior Software Engineer, tasked in migration of data from SQL SERVER 2000 to MySQL database. I made necessary changes in the front-end PowerBuilder objects.

Worked on Password functionality to provide additional level of security for Admin. I created a pipeline for SERIAL_XREF view into sfis_serial_no table.

Worked on validation check for serial no and job no. Plugged in IO ActiveX component to read the numeric value stored in TT5B Register.

Worked in a production support and maintenance environment.

Environment: PowerBuilder 6.5, MS SQL Server 2000 and Windows NT

TV GUIDE INC, Tulsa, OK Aug 2000 – Oct 2001

Role: Senior Programmer Analyst

Project: Apollo2 Application

Responsibilities

As a Senior Programmer Analyst, tasked with responsibility for making enhancements, modifications and adding new features to the Apollo2 application using PowerBuilder 6.5 as front-end interface and MS SQL Server 7.0 as back end.

This System helps in generation of reports related to programs, schedules for TV GUIDE Channel.

Used Structures for passing information between windows, writing Stored Procedures, triggers.

Tasked in the development of Video on Demand, a new feature for the Apollo application.

Tasked in the enhancements and modifications to Apollo2.0 according to user requirements.

Worked on bug-fixing of bugs such as Program Save and Copy date.

Environment: PowerBuilder 6.5, PFC, MS SQL Server 7.0, Visual Source Safe and Windows NT

Webloyalty.com, Norwalk, CT May 2000 – Jul 2000

Role: Senior Programmer Analyst

Project: Webloyalty Reporting System

Responsibilities

As a Senior Programmer Analyst worked on Data warehousing/OLAP project and was responsible for creation of universes and reports in Business Objects 5.0, a reporting and analysis tool as front end as well as writing stored procedures in Oracle 8i PL/SQL, to retrieve the data from the OLTP database into OLAP database.

Worked in writing stored procedures which retrieved the data from OLTP and insert the data in OLAP

Worked in creating Business Objects universes from which reports are generated.

Tasked to create Business Objects Reports for core response, fulfillment and billing.

Environment: Business Objects 5.0, Oracle 8i, PL/SQL and Windows NT

OLSTEN Corporation, Melville, NY Nov 1999 – Apr 2000

Role: Senior Programmer Analyst

Project: OFISS 2000 System

Responsibilities

As a Senior Programmer Analyst, tasked with responsibility for enhancements in OFISS 2000 Application, OFISS Setup Application using PowerBuilder 6.5 as front-end interface and Oracle 8i as back end. I made extensive use of PowerBuilder features such as User Events, Functions, and Data Sharing between data windows. Have used Structures for passing information between windows, writing Stored Procedures, triggers. This System helps in generation of reports related to Customer, Employee, Order, Office, Management, Payroll and TQM using Crystal reports 5.0.

Worked on the development of new features for the OFISS 2000 application

Worked on the enhancements and modifications to OFISS 2000 according to user requirements.

Tasked in the fixing of bugs and Production Support.

Environment: PowerBuilder 6.5, KPMG Class Libraries, Oracle 8i, PL/SQL and Windows NT

SystemLogic India Pvt. Ltd., Bangalore, India May 1996 – Nov 1998

Client: Thai Carbon Black Co. Thailand

Role: Programmer Analyst

Project: Manufacturing Process Monitoring System

Responsibilities

As a Programmer Analyst, tasked for Requirement Study, Analysis, Functional specifications, Design, Development, coding & Implementation of the Manufacturing Process Monitoring System in Client/Server environment. This application was designed and deployed for Thai Carbon Black Public Co Ltd. covering all the manufacturing processes of Carbon Black raw material. It comprises of Production Planning Control System, Quality Management System, Warehouse Management System, and Utility Management System. This system was designed to handle online transaction in high volume, while at the same time, maintaining good response time.

Responsible for writing and tuning Stored Procedures in Sybase 11 ensuring high response time, integrity and consistency.

Worked extensively in PowerBuilder 6.0 for developing the application programs/User Interfaces.

Involved in the creation of design documents.

Worked in the development of Utility Management System and Warehouse Management System modules according user specifications.

Tasked in the testing and fixing bugs.

Environment: PowerBuilder 6.5/6.0, PFC, Sybase System 11, Windows NT and Windows 95

Client: Fame IT Solutions, Dubai

Role: Programmer Analyst

Project: Financial Accounting and Inventory System (FAIS)

Responsibilities

As a Programmer Analyst, responsible for design, development, coding, testing & implementation of the integrated system in Client/Server environment. FAIS is the application software specifically designed for small-to-medium sized trading houses to maintain their Account Payable, Account Receivable and financial accounting.

Tasked in the creation of data model and design documents.

Worked on the development of Account Payable and Account Receivable modules according user specifications.

Tasked in the testing and fixing bugs.

Environment: PowerBuilder 5.0, PFC, Sybase System 10, PowerDesigner 5.0, Windows NT and Windows 95

Client: Mercury GoldMann (India) Pvt. Ltd., India

Role: Programmer Analyst

Project: Document Management System

Responsibilities

As Programmer Analyst, responsible for Design, Development and Implementation of the Document Management System, this caters to registering/unregistering, documents for a given keyword. The DMS provides for maintaining the registered documents and viewing of the same in Word Viewer, Excel Viewer and PowerPoint Viewer depending on the type of document.

This System also provides for search of registered documents for a given keyword.

Worked in the enhancements and modifications to the application according to user requirements.

Worked in the testing and fixing of bugs.

Environment: PowerBuilder 5.0, Sybase SQL Anywhere 5.0 and Windows95

Client: BioSafety Inc., India

Role: Software Engineer

Project: Contact Management System

Responsibilities

Responsible for User Requirements Study, Analysis, Design, Development and Implementation of the system, which is designed to help the sales representatives in effective planning of their activities and also in scheduling an activity. It maintains the details of Subject Areas such as Contact, Company, Distributor, Salesrep, CMSuser, and Competitor. The Subject Functions Are Address, Phone, Notes, Detail and some specific subject functions for a Subject Area.

Responsible for writing stored procedures with Sybase 10, as the back-end Database.

Tasked in the enhancements and modifications to the application according to user requirements.

Worked in the testing and fixing of bugs.

Environment: PowerBuilder 5.0, Sybase System 10, Windows NT and Windows 95

Contact this candidate