Bala Uppaloori
Bala Uppaloori
Phone: (914)-912-7674
email: balapavan@balapavan.com
Download Resume
Education:
Bachelor of Science
Postgraduate Diploma in Computer Applications
Certifications:
Microsoft Certified Professional in VB
Microsoft Certified Professional in SQL Server
Specific Background
Over 9 years of experience in the design, development, and implementation of
high-performance robust enterprise client/server, three-tier and web-based business applications
Extremely strong in Visual Basic, VB..NET, Oracle PL/SQL, SQL Server T-SQL, ASP, ASP.NET, Cold Fusion,
XML, ADO, MTS, COM, IIS, HTML, DHTML, Cascade Sheets, Java, JavaScript, VB Script, VBA, Microsoft Access,
MS Excel and Visual Interdev
Experience using C,C++, JAVA, FrontPage, ODBC, DAO/RDO, Oracle Developer 2000(Forms & Reports), Oracle Financials
11i,Windows NT/2000 and UNIX
Extensive experience in designing, developing and deploying reusable, programmable COM / DCOM based Components
using VB
Developed client/server applications utilizing Visual Basic, Oracle, SQL Server, Crystal Reports, and Visual
SourceSafe change control system
Experience in database administration responsibilities, Backup, Recovery and Tuning
Strong Analytical, Inter personnel and Communication skills
Strong articulating abilities. Have given seminars and presentations at various levels.
Excellent Knowledge in RDBMS Concepts, three-tier and object methodologies
Microsoft Certified Visual Basic Developer and SQL Server developer
Exposed to ERP package Oracle Financials 11i
Technical Skills
Development Skills: Visual Basic.NET, VB 5.0/6.0/.NET, ASP.NET, Visual Studio, Cold Fusion, C++, C#
Design tools: ER Studio, Rational Rose, Microsoft Visio
Web Tools: Visual InterDev 1.0/ 6.0, Front Page 98, HTML, DHTML, XML, VB Script
Servers: BizTalk Server, Microsoft Application Server, Windows 2003
Java, Java Script, IIS 4.0/5.0, ASP 2.0/3.0/.NET Cold Fusion
Databases: MS-SQL Server 6.5/7.0/2000, Oracle 7.x/8/8i, Sybase, MS-Access
Reporting: Crystal Reports 6.0/7.0/8.0/90, RAS , Business Objects
Operating Systems: Windows 3.x/9x/2000, Windows NT 3.51/4.0, MS-DOS, UNIX
Technologies: ODBC, DAO/RDO/ADO, COM, DCOM, MTS, OLE/ActiveX, Internet/Intranet
Methodologies: RDBMS, Client/Server, Three-Tier, OOP
Patterns : GangofFour(GoF) Patterns
Experience:
Client : Microsoft June 2008 to Present
Title : SQL Server/BI Consultant
Division : Xbox
Projects:
Atlantis: Atlantis is the new reporting solution for Xbox gaming. It is a comprehensive solution to provide business users
with user experience (including user presence and purchase history) using latest BI tools from Microsoft
(SQL server 2008, Analysis Services 2008 and Reporting Services 2008).
Role:
Helped the dev team in developing SCS Feeds.
Provided business user community with data support.
Helped downstream data partners in understanding the available data points and providing them with required support.
Developing iterative processes for better deployment of data points.
Client : Expedia.com September 2006 to February 2008
Title : ASP.NET/ Sharepoint/SQL Server Consultant, Technical Program Manager (Internal Systems)
Division : Internal Systems
Projects:
IT Anonymous: IT Anonymous is a workflow application designed to provide Expedias top level management with the feedback
submitted anonymously by any Expedia employee.
Role:
Architecting and estimating project deliverables.
Developed project methodologies by working closely with Program Manager
Requirement collection and product delivery.
Designed a library for scalability and availability of the application and for future use.
Provided guidelines for database encryption to truly keep the feedback anonymous and secure
Coding in ASP.NET using Visual Studio 2005
Expedient: Expedient is a web portal, developed in ASP.NET, which provides access to SQL Server Reporting Services Reports.
It is also Integrated with Active Directory, so users can define their set of filters, which would be global to all the reports.
Role:
Designed the architecture for the application.
Developed project deliverables, defined project goals and dates,
Requirement collection and product delivery.
Maintaining SQL Server Reporting Services availability.
Performance tuning on both SQL as well as at the server end.
Coding in ASP.NET using Visual Studio 2005
Reporting Performance: Complex reports have been developed and code reviewed according to business requirements.
Role:
Performance tuning of Reports.
Provided guidance to the report development team in developing and fine tuning reports.
SQL Server administration and installation.
Maintaining SQL Server Reporting Services availability.
Performance tuning SQL Server.
Coding in ASP.NET using Visual Studio 2005
StageGate : StageGate is a project status tracking website built for Sharepoint Portal Server 2003.
Role:
Developed high level coding for web parts in ASP.NET
Liason between developers and business.
Collection of business requirements.
Participated in research and feasibility study for project scope and technical abilities of chosen product (SharePoint 2003).
Coding in ASP.NET using Visual Studio 2005
Technologies Used: ASP.NET, C#.NET, VB.NET, SQL 2005, Sharepoint Portal Server 2003, Reporting Services 2005
Client : Capstone Technologies June 2006 to September 2006
Title : .NET 2.0/SQL Server and Reporting Services 2005 Consultant
Division : Software Development\Client Services
Projects:
TTPayRoll: TTPayRoll is a payroll application developed using ASP.NET, VB.NET on .NET 2.0 framework and SQL Server 2005.
Application web interface was developed using ASP.NET and windows interface was developed using VB.NET.
Reports are developed using Reporting Services. All the development was done using Visual Studio 2005.
Business Rule layer was maintained in SQL Server.
Role:
Designing and Programming using VB.NET, SQL Server 2000 (SSIS, complex Stored Procedures and T-SQL)
Promote and merge production databases using SQL Delta and Adept SQL tools
Requirement collection, analysis and design of Reports.
Maintaining SQL Server availability.
Performance tuning on both SQL as well as at the server end.
Client : Weidmuller Inc February 2006 to May 2006
Title : Reporting Consultant
Projects:
SQL Reporting: Designing and developing reports on Microsoft Reporting Services, with Microsoft SQL Server.
SourceSystem was JDEdwards with DB2 on AS/400 platform. Tasks included Sales Reporting by performing ETL using DTS packages on
SQL Server 2000 using Stored Procedures, Cleansing and loading of DB2 Data and loading onto a SQL Server platform.
This would be was later used to reporting using SQL Server stored procedures and Reporting Services.
Role:
Designing the data platform for SQL Server. Designing the database, reports, and ETL (Using DTS and stored Procedures).
Requirement collection and Analysis and design of Reports.
Maintaining the data warehouse availability.
Performance tuning on both SQL as well as at the server end.
Performed DBA activities on an adhoc basis.
Supporting the nightly loads and jobs for the data warehouse.
Client : WellsFargo Financial services, Des Moines, IA September 2005 to Present
Title : Architect/Designer(Consultant)
Division : Credit Card Services
Projects:
Data WareHouse Reporting: Administrating, Designing and developing reports on Microsoft Reporting Services,
with Microsoft analysis services and SQL Server as the platform for both Business Intelligence
(OLAP) and OLTP business managers. Performing ETL using DTS packages on SQL Server
2000 using Stored Procedures. Maintaining the data warehouse availability.
Performance tuning on both SQL as well as at the server end.
Responsibilities:
Designing and Architecting enterprise wide database and data warehouse using SQL Server,
Analysis Services and Microsoft Reporting Services.
Requirement collection and Analysis and design of Reports.
Database design and development using Stored Procedures, DTS, SQL Jobs.
Performed DBA activities on a need basis.
Client : Principal Financial Group, Des Moines, IA December 2002- August 2005
Title : Technical Designer/Lead
Division : Principal Global Investors
Multiple projects
Key Projects:
ReportLauncher: ReportLauncher is a web based reporting application that was developed using VB.Net and ASP.NET.
The reporting technology was implemented using RAS in Crystal 9.0. Reports would be available on
demand and users couldrequest them selecting multiple criteria, which was in the form of Asp.NET
web pages.
Role: Requirement analysis, design and coding.
General Ledger: General Ledger is a legacy system, implemented at an organization level on MainFrame. PGI was to
send information on all the transactions for a given day, every day, on monthends for any given
month, both on a Calendar and a BusinessDay monthend. The transactions were part of a third party
application called Portia and were stored in Sybase. This was achieved with an application developed
in Vb.NET interfacing with Portia for running its reports to pull the transactions using SQL Server
and Sybase as backends.
Role: Requirement analysis, design, coding, enhancements and production support involving Tivoli job
server.
Autobuild: Building Security information at run time using Bloomberg. High level messaging technologies were
used to notify when a new security is built and to pull info about the same security from Bloomberg.
After the pull, the information with the security would be built into Portia and Charles River.
BizTalk Server was used to develop Schemas, Maps and pipelines. Biztalk server Orchestrations were
created for a better business modeling. Object Oriented technologies were heavily used, implementing
GoF patterns (Observer and Factory).
Role: Requirement Analysis, Design, High level coding.
Principalglobal.com: Website for Principal Global Investors. This website was developed using Asp.Net and VB.NET,
while closely tying to the AppBase framework. Components were developed in VB.NET, as code behind.
Business logic was layered into Vb.Net components and stored procedures. Active Directory and common
functionality was implemented using the web services developed as part of the Appbase framework.
Role: Requirement Analysis, Design, coding and maintenance using teamSite.
AppBase: A Common framework for all the PGI applications. When an application starts it would contact
this framework for its initial settings and to perform common functionalities. This was later
ported to Web services using SOAP, UDDI and ASP.NET while coding was done using Vb.NET.
Role: Design, Architecting and high level coding
*Several other projects were also developed as part of the contract with this client.
Responsibilities:
Designing enterprise applications using GoF patterns for development with Vb.NET.
Requirement collection and Analysis
Architecting and developing high level coding using VB.NET, SQL Server, Visio, UML etc
Engineered Web Services for an enterprise wide framework using VB.NET and ASP.NET
Designed, developed and implemented messaging technologies.
Also responsible for engineering and maintaining several websites like PrincipalGlobal.com,
inside.principal.com etc, using a content management tool called TeamSite.
Architecting Vb.Net applications around trading and accounting products like Open Trader and Portia.
Developing and implementing standards for the team and the division.
Maintained and supported applications like GL, Open Trader and Portia.
Managed a team of 6 professionals
Client : Washington Mutual Financial Services, CA Mar 2000 - Dec 2002
Project : MERCURY
Title : Data Warehouse Project
Description :
This project is mainly to convert the existing legacy system (BOSS) into New System (MERCURY) based on SQL
Database and Interfaces were designed in Visual Basic. Responsible for the design and coding of extensive
application by designing an architecture consisting of basic modules, class modules and Standard Modules to
manage data access, controls, forms, security, message logging, and error handling. Created a Data
Environment for connecting to database, in which we used disconnected record sets. Provided Security at
various levels like Menu level, Form level and Record level.
Role:
Designed and Coded robust security and password management modules by creating profiles
Created robust SQL Repository using the Data Environment Designer as well as COM
Designed most of the complex Crystal Reports using stored procedures and views.
Extensive TSQL coding to encapsulate most database interaction via Procedures and Functions
Developed entire series of lookup screens to allow for dynamic user-driven querying and application
navigation without compromising performance
Managed builds and created installation applications for the primary application and associated custom
ActiveX DLL
Performed extensive Unit testing, defect tracking and resolution, and production support
Created stored procedures for batch programs and created extracts to writing flat files
Migrated to VB.NET utilizing all Object Oriented features
Involved in the maintenance of WEB based intranet project using ASP and XML
Environment: Visual Basic 6.0,VB.NET, MS SQL Server7/2000,Visual SourceSafe, Crystal Reports 8.0, Install Shield, ADO,
ADO.NET, ASP, Win. API s, COM, XML, WinDNA, Windows NT, and Unix
Client : Value Communications Inc., IL Jun 99 - Feb 2000
Project : Virtual Shopping Cart
Title : Programmer Analyst
URL : www.valucorp.com
Description :
This project aims at advertising and marketing various products over the web. Site provides info about the
company, products and promotion details. Primarily involved in developing online customer support,
maintenance, order processing and reporting. It facilitates online inquiry form, online ordering form and
online feed back form. Visitor can navigate through the web site to get the basic and general information.
Role:
Created Static and Dynamic web pages with form fields are developed using HTML, DHTML, and Cascade Sheets.
Involved in the design and development of advertising, Online shopping and customer management system using
ASP and Visual Interdev
Responsible for designing the presentation tier using ASP, Java script, VB script, HTML, Cascade Sheets, and
using XML as the primary mechanism for the storing of data and parsing of data.
Worked extensively on Crystal reports
Created client and server-side validation processes using JavaScript and VB Script
Developed COM components to perform all calculations and aggregations as well as manage data presentation
Used third party components like ASP Mailer for sending instant mails thru web page and ASP upload for
uploading pictures into web sites
Leveraged SQL Server Stored Procedures using T- SQL extensively
Used Microsoft XML DOM object extensively to have the control over the navigation of the whole application.
Implemented the data transport mechanism between the web server and client using XML.
Worked to improve the performance of ASP pages using XML
Generated Text files for Secured Data to export to third party companies like check free Inc. for validations
and funds transfer
Environment: ASP, HTML, DHTML, XML, IIS 4.0, VB Script, Java Script, MTS, ADO, COM, VB, SQL Server 6.5, Crystal
Reports7.0, Image Composer and Visual InterDev 6.0
Client : Delray Technologies Inc, FL Oct 98 - May 99
Project : www.infotechjobs.net
Title : Developer
URL : www.infotechjobs.net
Description :
This Web Site mainly enables consultants to post their resumes and search for Specific job opportunities. And
also enable to search for a specific job in a specific location. Employers can use the site to advertise the
job listings and search through the resumes that are posted on the site. All these resumes and job listings
are stored in the SQL Server 7.0 database. Designed & developed front-end web based online job site for
consultants and employers using Active Server Pages (ASP), Internet Information Server (IIS) and SQL Server
Analyze and document client requirements and design the application in an iterative manner using Internet
technologies like ASP, ADO, HTML, as appropriate. The coupon data is imported into SQL Sever database.
Role:
Created reusable DHTML custom controls (Grid, Tab) using Java, and Java script.
Developed Cascading Style Sheets (CSS) using HTML, Cascade Sheets, and DHTML
Extensive ASP and ADO integration for data access components
Implemented online database search functionality, including the ability to search the text of all resumes
stored in the SQL Server database
Complex Reports were generated using Crystal Reports
Site included dynamic content
Created components to track web site statistics and traffic
Modified the existing Stored Procedures in SQL Server 7.0 as per requirement
Interaction with business objects and stored procedures through the application
Environment: ASP, Visual Interdev 6.0, ADO, HTML, VB Script, VB, SQL Server 6.5, Image Composer, Crystal Reports7.0,
Java Script, Unix, Windows NT
Client : Medinova Diagnostics, India Jul 97 - Sep ' 98
Project : Hospital Management Services System
Title : Developer
Description :
As a developer developed Hospital Management Services System to maintain data relating to physicians,
surgeons, and patients. This project was developed to maintain information regarding physicians, surgeons
and patients. It generates various service bills for tests performed and maintaining the status of the
patients.
Role:
Involved in developing data entry screens and report generation.
Used Crystal Reports to generate various reports including chief complaints, patient status between two
dates, ward status reports and number of patients admitted for the doctor.
Environment: Visual Basic 5.0, MS SQL Server, Crystal Reports 6.0/7.0, Windows NT, and Unix
Client : Sivian Poultries, India July ' 96 - Jun ' 97
Project : Stores Management System
Title: : Developer
Description :
This project involved creating the Stores Management System to track all inventory data. System managed
invoices, deliveries, and material receiving.
Role:
Developed data entry screens and reports
Created Stock Verification processes to track all materials
Designed and developed automated re-order level and safety-level tracking
Coded ActiveX controls that provide complex validation services for data entry
Environment: Visual Basic 5.0, Oracle 7.x, Crystal Reports 6.0,and Windows 95