Visual Basic Sql Server
Resume:
Rajender Dichpally Address : **
Wilson Avenue
Permanent Resident Kearny
NJ 07032
201-***-**** - Residence, 973-***-**** - Cellular
Summary
Extensive experience in analysis, design and development of Client
Server applications using various databases like Oracle, SQL Server and
Sybase etc. Experience in working on vast Data Ware houses. Programming
in Visual Basic.Net, Visual Basic (4, 5, 6.0) Oracle Forms etc. Involved
in several Life Cycles of development on the front end and back end.
Experience using several reporting tools like crystal reports, business
objects, oracle reports, Sql server reports, report writer etc. Vast
Experience with business intelligence and business logic tools. Worked
on several projects as a business analyst/ developer to understand the
business and the end user requirements. Worked as developer, business
analyst and project lead on several of the projects.
Education
1) MS Computer Science (New York Institute of Technology) - May 1997
2) Master of Business Administration (Finance) - June 1994
3) Master of Business Administration (Marketing) - June 1993
3) Diploma in Computer Management. - June 1999
4) Advanced Toast Master, Toastmasters International. - December 2002.
5) Pursuing Project Management Professional
Experience
Senior Programmer/ Business Analyst
United Water - Suez. Oradell (NJ) - Consultant April
2008 to December 2009
? Designed and Developed the Core Application of the firm - Key System
using Visual Basic for Applications with Oracle 11g and SQL Server 8.0
database.
? Developed a pilot project on Visual Basic.Net to convert an old
legacy system for management review.
? Maintained and developed the Share Point application for putting all
data into the central repository.
? Conducted requirement gathering with end users and converted them
into business specs and developed the specs into application design and
development. Conducted user acceptance testing including the
documentation and final turnover into production after due processes.
? Fine tuned the stored procedures in PL/SQL for optimum performance
that saved the users a lot of delay time in accessing data from the
front end.
? Helped the company to resolve issues with corruption of the front end
system on Citrix by giving solutions that resolved the issue resulting
in less downtime of the system during peak hours.
? Developed several reports in Business Objects XI R2, Crystal Reports,
Oracle Reports for the users and management for effective decision
making.
? Involved in loading data from Oracle and SQL Server and performing
maintenance on the database servers for optimum performance that helped
the firm with better customer service to the users.
Environment : Oracle 11G, Visual Basic.Net, Microsoft Visual Basic
Applications, ASP.Net, XML, DHTML, VB Script, Java Script, PL/SQL,
Oracle Reports 11G, Microsoft Access 2007, Business Objects, SQL Server
8.0, Business Objects XIR3, Data Integrator - X1R2, Remote Desktop,
Oracle Lite Repository.
Senior Programmer/ Business Analyst
Burlington Coat Factory. Burlington (NJ) - Consultant
November 2007 - March 2008.
? Developed packages in PL/SQL that implemented the company's business
rules on the Electronic Data Interchange(EDI) Project.
? Programmed in Unix Shell scripts to run the PL/SQL packages and
schedule them.
? Developed user cases for the business rules of the company.
? Fine tuned the existing PL/ SQL procedures for optimum performance
that helped the company serve its users effectively and efficiently.
Environment: Oracle 10G, Visual Basic.Net, ASP.Net, XML, Toad 8.6 * 9.5,
SQL Navigator 4.5, Putty 0.54 (Perl), UNIX, SQL*Plus, Secure Shell
3.2.9, Crystal Reports X1.
Senior Programmer/ Business Analyst
CDG - Millennium. Edison (NJ) - Consultant
February 2007 - November 2007
? Wrote Visual Basic programs to process the firms tele marketing lists
to help management study the success and
quality of the tele marketing calls.
Resume
Rajender DICHPALLY
Page 2 of 4
Experience (continued)
? Fine tuned the existing PL/SQL stored procedures to reduce the data
retrieval from the back end. Was able to reduce response time by almost
70%. This helped the company in providing better response time and
service to users.
? Led a team of developers to successfully process several tele
marketing lists within the budgeted time and allotted resources.
? Worked with end users in getting the requirements and converting them
into business requirements and technical specs and allotted the work
proportionally to the developers. Also took a large chunk of work for
development in Visual Basic.Net, Visual Basic 6.0 and Oracle 10G.
? Conducted code reviews, developers reviews, process reviews and plan
reviews to see that the projects were being completed within the time
frames and budgets and adhering to firm standards.
? Interacted with third party vendors to help the company with mission
critical applications.
? Developed and documented the User Acceptance testing and production
roll outs and issues and notes on the project.
Environment: Oracle 10G, Visual Basic.Net, ASP.Net, XML, XSL, ADO.Net,
Java Script, Visual Basic 6.0, Crystal Reports 11, Visual Source
Safe, Oracle Reports 10G, UNIX, Oracle Loader, SQL Plus, PL/ SQL, TOAD.
Senior Programmer/ Business Analyst
Nomura Securities - Wall Street (NY) - Full Time
June 2004 - February 2007
? Responsible for Technical support to over 40 controllers and brokers
over several groups (Fixed Income, Treasury, Asset Management,
Mortgages, Management Reporting etc).
? Designed and developed Visual Basic applications to read data from
the dataware house to populate local databases that were used by the
controllers.
? Developed DTS packages that read real time data. Wrote Visual Basic
application that parsed over 300 tables with data from the mainframe
files and flat files based on the arrival of the file on the firm's
network domain. Worked on Informatica to pull data from several source
database tables into the custom databases.
? Coordinated several mission critical updates like Oracle and SQL
Server upgrade, File system upgrades, DLL installations, disaster
recovery testing etc.
? Worked on making the applications that I supported SOX complaint.
? Supported the Controllers and Brokers with several ad hoc
applications designed and developed in Visual Basic, VBA, PL/SQL, SQL
Server reports, DTS packages, Crystal Reports, Business Objects reports
etc.
? Built project plans for optimum utilization of the allocated budget
and resources.
? Documented the existing procedures for the firm's knowledge
management repository.
Environment: SQL Server 8.0, Sybase 12.5.1, Oracle 10G, Mainframe,
Visual Basic 6.0, Visual Basic.Net, Access 2000, Excel Macros, Dameware,
Crystal Reports 11, Business Objects XI R2, Informatica, UNIX.
Senior Programmer/ Business Analyst
Standard & Poor's. Manhattan (NY) - Contractor January
2002 to May 2004
? Developed Visual Basic.Net applications using Oracle as a backend for
the CVC reporting application that helped the management monitor and
study the different financial instruments of the company.
? Interacted and liasoned with several departments to effectively
design and implement the firms reporting process on the company's
intranet.
? Worked on several reporting tools like Crystal Reports, Oracle
Reports to help the company build a strong reporting process for
effective management decisions.
? Allocated work among the developers for optimum utilization of the
contractor's time and effective load balance of the work.
? Gave inputs to management for decisions on third party software
procurement.
Environment: Visual Basic.Net & Visual Basic 6.0, Oracle 9.0, ASP.Net,
HTML, DHTML, XML, Crystal Reports 9.0, UNIX, C, Microsoft Transaction
Server (MTS), Compuware (QALoad etc), Microsoft Project 2000, ASP,
COM, DCOM, Java Script, VB Script, IIS Server
Senior Developer/ Project Leader/ Analyst
KPMG - Peat Marwick. Montvale (NJ) - Fulltime January
2000 to December 2001
Resume
Rajender DICHPALLY
Page 3 of 4
Experience (continued)
? Lead a team of 6 programmers on a financial application designed and
developed in Visual Basic and Oracle.
? Wrote several Visual Basic applications that read data from the
dataware house and populated the tables in several custom databases in
Oracle and SQL Server for specific groups (HR, Management Reporting
etc).
? Customized several DLL's and Active X controls for the firm's
specific usage.
? Developed and documented several business processes that helped the
firm with effective implementation of projects.
? Wrote PL/SQL packages to pull data from mainframe and legacy
applications to populate the custom databases.
? Liasoned with different departments for effective production rollouts
and seamless integration of the new systems with the existing systems.
? Developed best practices to be followed by the developers. This
included the process of version control, code review, User sign offs,
business requirement documentation, user acceptance test scripts and
sign off's and production roll outs.
? Trained with third party vendor software to understand the
functionality and implement the software within the firms practice.
Environment: Oracle 7.4 & 8.0, Visual Basic.Net, Visual Basic 5.0 &
6.0, C, SQL Server 6.5 & 7.0, ASP, COM, DCOM, Active X, XML, DHTML, IIS,
Crystal Reports 8.0 & 8.5, Java Beans, Dream weaver, CORBA, JDBC, Erwin,
UNIX, LDAP, Windows NT & Windows 2000, Microsoft Transaction Server
(MTS), Microsoft Project 98 & 2000 and Microsoft Outlook.
Senior Programmer/ Project leader/ Business Analyst
Pepsi Cola - Westchester (NY) - Contractor
March 1999 - December 1999
? Lead a team of programmers on the MITS application that was developed
on Visual Basic 6.0 and Oracle 8.0.
? Developed several reports in Crystal reports and Excel for end users.
? Generated expense codes through the Oracle General Ledger for the
marketing personnel for allocation of expenses.
? Involved the administration of the database users and rights to the
objects in the database based on formal approval from management.
Backed up databases on specific demand.
? Designed the flow charts for the application development and
functionality flow of the application process.
Environment: SQL Server 2000, Visual Basic (6.0), C, Crystal Reports
7.0, Crystal Enterprise, MS Access 2.0 & 97, AS 400, Oracle General
Ledger, Windows NT, UNIX, Windows 97, Microsoft Project 98 and Microsoft
Outlook.
Senior Programmer/ Project Leader/ Analyst
Ernst & Young - Lyndhurst (NJ) - Contractor March
1998 - March 1999
? Worked on the CRM application Quintus that was purchased from a third
party vendor for help desk.
? Developed and modified several front end screens using Visual Basic
and VBA.
? Built alerts into the CRM application in VBA to notify groups that
were being allocated tickets by help desk to help the users.
? Developed custom pop ups for easy navigation for the end users.
? Implemented tight database security on data objects and administered
the database rights for the users.
? Created User acceptance test scripts and conducted migration of code
from development into production seamlessly.
? Implemented the project plan for the roll outs and conducted regular
review meetings of the developers to check the progress of the project
and its adherence to time lines and resource allocation.
Environment: Visual Basic 5.0, Oracle 7.3, PL/SQL, C, UNIX, VBA, Crystal
Reports 6.0 & 7.0, Lotus Notes, Windows NT, Windows 97 and Microsoft
Project.
Programmer/ Analyst
AT&T - Berkeley Heights (NJ) - Contractor January
1997 - February 1998
? Developed and Modified the Business Unit Result System using Visual
Basic, Oracle, Crystal Reports.
? Developed shell scripts to schedule the reports and application runs
to process at specific off business hours.
? Wrote PL/SQL procedures to process and read data from the front end
application.
? Fine tuned existing PL/ SQL objects and wrote triggers to ensure data
integrity.
Environment: Oracle 7.3, Visual Basic 5.0, Crystal Reports 6.0, UNIX,
PL/SQL 2.3, Windows NT, Windows 97 and Microsoft Outlook, Forms 2.3, 3.0
& 4.0, VAX/ VMS
Resume
Rajender DICHPALLY
Page 4 of 4
Experience (continued)
Programmer/ Analyst
DGL TRADING CORP. Manhattan (NY) - Contractor September
1995 - December 1996
? Responsible for designing, data modeling and developing financial
accounting database system in Oracle (7.1) on UNIX platform.
? Developed forms in SQL *Forms 4.5 for the accounts receivable,
account payable, Cash Management and General Ledger.
? Wrote triggers and stored procedures.
? Developed ad hoc reports in SQL *Report Writer (2.5)
Environment: Oracle 7.1, UNIX, SQL *Forms 4.5, SQL Report Writer 2.5,
UNIX, Windows NT, Microsoft Outlook.
Languages
Visual Basic, C, C++, PRO *C, SQL, PL/SQL, Java
Databases
Oracle (11G & below), SQL Server (2008 & below), Sybase 12.5, MS Access
(2.0, 7.0, 2000), DB2.
Operating Systems
Unix, MS DOS, Windows (3.1, 95/98 & 2000), and VAX/VMS
Tools
Oracle Intelligence Builder, SQL * Forms (3.x, 4.x), SQL *Plus, SQL
*Reports, Informatica, Cognos, Visual Basic (6.0 & below), VB.NET,
ASP.Net, Crystal Reports (7.0, 8.0 & 8.5), AS 400, Erwin, Power Builder
(4.0, 5.0), Java Beans, Java Script,VB Script, ASP, JDBC,COM, DCOM,
Active X, MTS, Perl, HTML, DHTML, XML.
Packages
Microsoft Project, Excel Macros, Visual Basic Application (VBA), MS
Exchange, Developer 2000, MS Office 2000, Erwin, Peach tree, Polygon,
Lotus AmiPro, Lotus Graphics, Visual Interdev, Visual SourceSafe, Lotus
Notes, Quintus 3.1.
Contact this candidate