Bala Uppaloori

Cell: 914 912 7674

PROFILE

  • Over 13 years of experience in the design, development, and implementation of high-performance robust applications.
  • Exceptional experience in developing enterprise client/server, three-tier and web-based business applications using Microsoft and other leading technologies.
  • Exceptional skills in Datawarehousing and architecting applications.
  • Exceptional Client management skills, communication skills and problem solver.
  • Enthusiastic and self starter.
ACADEMIC

BACHELOR OF SCIENCE IN ELECTRONICS 1996

OsmaniaUniversityAmong Top 10 Engineering Schools in Asia

Post Graduate Diploma in Computer Sciences 1997

National Institute of Information TechnologyA premier computer school in Southeast Asia

Certifications

Microsoft Certified Professional in Visual Basic

Microsoft Certified Professional in SQL Server

BrainBench Certified Professional in ASP

Technologies

Development Skills:Visual Basic.NET, VB 5.0/6.0/.NET, ASP.NET, Visual Studio.NET, C++, C#

Design tools: ER Studio, Rational Rose, Microsoft Visio

Web Tools:ASP.NET, ASP, Cold Fusion, Visual InterDev Front Page 98, HTML, DHTML, XML, XSL, XSLT, VB Script, Java, Java Script, CSS, AJAX (Microsoft Atlas)

Team Systems:Visual SourceSafe

Business/PortalServers:BizTalk Server, Microsoft Application Server, SharePoint 2003, IIS

Databases:MSSQL Server 2005/2000/7.0/6.5, Oracle 9i/8/8i/7x, Sybase, MySql, MS-Access

DataWarehouse:MS Integration Services, MS Analysis Services, Reporting Services, Embarcadero tools, OLAP technologies, Star Schema and other Kimball structures

ETL Tools:Microsoft DTS, DataStage, Excel PivotTable, Access OLEDB

Reporting:Microsoft Reporting Services, Crystal Reports 6.0/7.0/8.0/90, RAS, Business Objects, Microstrategy

Operating Systems: Windows 2003/2000/9x, Windows NT 3.51/4.0, MS-DOS, UNIX

CRM:Conceptual knowledge of MS CRM 3.0

Technologies:SOAP, ODBC, DAO/RDO/ADO, OLEDB, COM, DCOM, MTS,ActiveX, Internet/Intranet

Methodologies:RUP Agile

Patterns :GangofFour(GoF) Patterns

EXPERIENCE

Senior Software Development EngineerApril 2010 to Present

Expedia.com

Projects:

Clarity Data Warehouse: Clarityis a Project and Portfolio management software and was in a hosted platform. we developed a data warehouse which involved a nightly ETL pull from external siteusing SSIS and clarity web services and developed Analysis services cubes and SSRS reports.

Role:

•Developed incoming feeds using SSIS.

•Provided business user community with data support.

•Requirement collection and product/data delivery.

•Worked with downstream data partners in understanding the available data points and providing them with required support.

•Coordinated point releases with downstream data partners in understanding and delivering available data points.

•Developing iterative processes for better deployment of data points.

Technologies Used: SQL Server 2008, Analysis Services (SSAS), Integration Services (SSIS) , C#.NET, Sharepoint Portal Server 2007, Reporting Services 2008

SQL Server/BI ConsultantJune 2008 to April 2010

Microsoft

XBox

Projects:

Atlantis: Atlantis is the new reporting solution for Xbox gaming. It is a comprehensive solution to provide business users

with an excellent and cutting-edge user experience using latest BI tools from Microsoft(SQL server 2008, Analysis Services 2008 and Reporting Services 2008). It provides users with information like usage, purchase and achievement information of an xbox user.

Role:

•Developed incoming feeds using SSIS.

•Provided business user community with data support.

•Requirement collection and product/data delivery.

•Worked with downstream data partners in understanding the available data points and providing them with required support.

•Coordinated point releases with downstream data partners in understanding and delivering available data points.

•Developing iterative processes for better deployment of data points.

Technologies Used: SQL Server 2008 (Including SSIS and SSAS), C#.NET, Sharepoint Portal Server 2007, Reporting Services 2008

ASP.NET/ Sharepoint/SQL Server ConsultantSeptember 2006 – February 2008

Expedia.com

Projects:

IT Anonymous: IT Anonymous is a workflow application designed to provide Expedia’s top level management with the feedback submitted anonymously by any Expedia employee.

Role:

•Program Management for Data Services

•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 into 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. Building data warehouse for reporting using SSIS 2005. Converted DTS packages from SQL 2000 to SSIS 2005.

Role:

•Performance tuning of Reports.

•Provided guidance to the report development team in developing and fine tuning reports.

•SQL Server administration and installation.

•Built Data Warehouse ETL processes based on SSIS (SQL Integration Services 2005).

•Converted SQL 2000 DTS processes to SSIS packages.

•Monitored load processes using SQL Notification Services.

•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

.NET 2.0/SQL Server and Reporting Services 2005 Consultant June 2006 to September 2006

Capstone Technologies

Projects:

TTPayRoll: TTPayRoll is a payroll application developed using ASP.NET, VB.NET on .NET 2.0 framework and SQL Server 2005 (SSIS, SSRS and Notification Services).

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.

Reporting Consultant February 2006 to May 2006

Weidmuller Inc

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.

Architect/Designer(Consultant) September2005 to February 2006

WellsFargo Financial 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.

Role:

  • 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.

Architect/Designer (Consultant) July 2002 to August 2005

Principal Financial Group

Projects:

General Ledger: General Ledger is a legacy system, implemented at an organization level on Mainframe. Every division needs to send its GL data to the Mainframe. Thisdata was part of a third party application called Portia and was stored in Sybase. Extracting and merging data from different databases and loading them to SQL Server was the major task. This involved running reports in Portia, cleansing it and copying it to SQL Server, merging with other data from multiple sources. Business rules were different for business day monthend and calendar day monthend. Robust performance with maximum uptime was achieved with an application developed in Vb.NET interfacing with Portia for running its reports to pull the transactions. These transactions were then uploaded to mainframe via ftp.The same data would be loaded into DataWarehouse for OLAP. Cubes and aggregations were developed using MS Analysis services. Microsoft reporting Services was used.

Autobuild: Building Security information at run time using Bloomberg, to be used by Charles River and Portia, was the major task of this project. When a new security is built, it would only have basic information, and further details were to be extracted from Bloomberg. This involved notifications when a security is built and to upload/download the information from Bloomberg in real time. Messaging technologies were used to notify when a new security is built and business processing was implemented using Vb.Net. Object Oriented technologies were heavily used, implementing GoF patterns (Observer and Factory). BizTalk Server was used to develop Schemas, Maps and pipelines. Biztalk server Orchestrations were created for a better business modeling.

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 could request them selecting multiple criteria.The user interface was developed using Asp.NET web forms. Vb.Net was used as the development language.

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.

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:

  • Designing and Architecting enterprise, web applications using GoF patterns for development with Vb.NET.
  • Requirement collection and Analysis and design using Visio and UML.
  • Designed and executed Cubes for OLAP database.
  • Used DTS as the ETL tool for OLAP database and ODS database.
  • 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 and implemented messaging technologies.
  • Architecting Vb.Net applications around trading and accounting products like Open Trader and Portia.
  • Created specifications of SQL Server stored procedures and implemented most of them
  • Developing and implementing standards for the team and the division.
  • Was responsible for writing a number of sophisticated Data Transformation Services (DTS) in T-SQL and VBScript in SQL Server
  • Maintained and supported applications like GL, Open Trader and Portia.
  • Worked with a diverse team of 9, mentoring and designing for them.

Sr. Developer/Architect 2000 to 2002

Washington Mutual Financial Services

Projects:

Mercury: Thisis a Conversion/DataWarehouse project. The old system was based on legacy systems, and the application was using Access for reporting. Tasks included rewriting the application interfacing with Mainframe database (DB2) and providing data both for OLTP as well as OLAP. This was achieved using Visual Basic, VB.Net, MS Analysis Services and SQL Server. COM was extensively used to develop business processes that interact at multi levels. ODS and the datawarehouse (OLAP) were located on SQL Server. Users interfaced to the ODS and data staging database, while knowledge users interacted with the datawarehouse (OLAP). Reports were developed in Crystal reports 8/9.

DataWareHouse: Designed OLAP solution to perform multidimensional analysis of financial data. Built the data warehouse on SQL Server 2000, and a single point of management to a set of external systems to insure high network uptime. Cubes and aggregations were built using analysis Server. Involved in Data Modeling and ETL. Data was extracted and loaded (ETL) using DataStage.

Intranet applications: Developed several intranet applications. Involved in the architecture of a common framework, building common functionality and business rules into it. Developed internal systems to be available on intranet. Components were developed in Vb, VB.NET and the user interface was designed and developed in ASP.NET. VBScript and JavaScript were used.

Role:

  • Designed and implemented development standards complying with Microsoft Application Architecture.
  • Designed applications to take advantage of the newly available OOP capabilities in Vb.Net.
  • Designed and took a leading role in implementing the presentation layer in ASP.NET.
  • Performed business and system analysis
  • Worked with OLAP database and executed reports for the same using Crystal reports.
  • Defined and implemented coding standards.
  • Created components to communicate with various systems.
  • High level coding of Objects and SQL using Stored Procedures.
  • Used Microsoft Data Access Application Blocks (DAAB)
  • Worked closely with Web Designers.

Sr. Developer1999 to 2000

Value Communications Inc. , IL

Project:

E-Commerce application: 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. Visitors can navigate through the web site to get the basic and general information.

Took the leading role converting existing desktop and status report applications to ASP - SQL Server architecture (Intranet).

Role:

  • Performed the existing system analysis and new architecture design (UML)
  • Coordinated and supervised the efforts of several other programmers.
  • Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL)
  • Coded ASP in MS Visual InterDev 6.0 using VBScript, JavaScript, HTML/DHTML/CSS, XML and ADO.
  • Created components in MS Visual Basic 6.0, used CDO and Outlook 2000 for messaging
  • Deployed the solution, participated in testing and documenting
  • Performed extensive Unit testing, defect tracking and resolution, and production support

Developer1998 to 1999

Delray Technologies Inc

Project:

Desktop Applications: Developed applicationsthat interact with database. This application was used on a daily basis by the users. Users would input daily usage and time tracking information into Oracle using these applications. Reports were developed using Crystal Reports. Involved in user interface design and developing code. Participated in designing database and adhering to most database development concepts.

Role:

  • Designed and developed windows applications usingVB and Oracle.
  • Developed several User Controls
  • Developed stored procedures and views in Oracle.
  • Involved in production support

Developer1997 to 1998

Medinova Diagnostics, India

Project:

Hospital management system: Developed Hospital Management Services System to maintain data relating to physicians, surgeons, and patients. Project was developed in VB.

Role:

  • Developed an application to maintain information regarding physicians, surgeons and patients. It generates various service bills for tests performed and maintaining the status of the patients.
  • 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.

Developer1996 to 1997

Sivian Poultries, India

Project:

Stores management system: Created the Stores Management System to track all inventory data. System managed invoices, deliveries, and material receiving.

  • Developed data entry screens and reports
  • Created Stock Verification processes to track all materials and to automated re-order level and safety-level tracking
  • Designed and developed
  • Coded ActiveX controls that provide complex validation services for data entry

ADDITIONAL INFORMATION

AWARDS & LEADERSHIP: 100% Tuition Waiver at NIIT

INTERESTS: Debate Team and Chess.

REFERENCES

Available upon request