Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rajesh Jampala

Atlanta,USA

Summary

Senior data professional with strong background in designing and implementing comprehensive data architecture solutions. Skilled in data modeling, database management, and cloud integration, ensuring scalable and efficient data systems. Demonstrates collaborative approach to projects, effectively adapting to evolving requirements and delivering reliable results. Known for driving successful outcomes through strategic planning and teamwork.

Overview

32
32
years of professional experience

Work History

Senior Data Architect

Milliman/Akur8
05.2015 - Current
  • Built an enterprise cloud based actuarial software application which was desktop based has been upgraded into a cloud-based enterprise application to leverage the collaborative effort between actuaries working at a company.
  • Designed and built an interface to work with Azure Databricks that helps access client data to be accessed and load data into Azure blobs that can be loaded into a data warehouse.
  • Designed and built a POC to connect Snowflake data to reserving cloud application and move data to Azure blob storage.
  • Designed a database for the security model to manage the setup of organizational security during the onboarding process.
  • Designed and developed the Enterprise Arius Application database
  • Built and automated SSAS cubes and set up automated refresh processes.
  • Responsible for database tuning and performance.
  • Designed and built reports in Power BI accessing multiple data sources like Application Insights, Azure SQL, Azure Data Explorer etc.
  • Support more than 55 clients with their own individual Azure subscriptions.
  • Manage and tune performance of databases ranging in sizes from 50MB to 1.5 TB.
  • Platform/Tools: Azure SQL, Synapse (previously Azure SQL Data Warehouse), Azure Data Explorer, Cosmos DB, Mongo DB, SQL Server 2014/2016, Azure Databricks.

Senior Data Architect

Georgia Department of Education
08.2005 - 04.2015
  • Instrumental in designing and developing the data needs for multiple projects at the Georgia DOE.
  • Worked with business users in understanding the requirements, designing and developing the data models.
  • Worked with infrastructure teams in building high availability solutions for the databases (Clustering).
  • Built HA Clusters for SQL Server 2005/2008/2008R2/2012, MySQL and PostgreSQL databases.
  • Maintained six environments (DEV, FUNCTIONAL, UAT, PROD, TRAINING and DEMO) for databases and applications.
  • Designed, built and deployed database scripts, SSRS reports and SSAS cubes.
  • Worked on building clickstream data for the usage of all the applications using big data and Hadoop framework. Built a prototype using Microsoft HDInsight and loading data from SQL Server into HBase for consumption.
  • Statewide Longitudinal Data System (SLDS) is designed to help districts, schools, and teachers make informed, data-driven decisions to improve student learning.
  • Designed and developed the data warehouse for SLDS. Involved in design and responsible for the deployment of SSRS reports for the application. Built the SQL server cluster (active/passive node) for high availability. Worked on designing the regular data loads into the warehouse. Designed and implemented near real time sync between Oracle and SQL Server database.
  • Instructional Improvement System (IIS) is a data analysis tool that provides school and district level users within the state of Georgia the ability to create customized reports using multiple dimensions like assessment, attendance etc.
  • Designed, built and deployed Analysis services (SSAS) cubes and SSRS reports for the tool.
  • Georgia Online Formative Assessment Resource (GOFAR) which is an online Assessment system for students built on Windows Azure supported by SQL Azure and MongoDB databases. The question and its Metadata information are stored in SQL Server 2012 and the student's test transactional information is stored on MongoDB.
  • Designed, developed and deployed databases in SQL Azure, Azure Data Explorer, Cosmos DB, MongoDB. Built SQL Agent jobs to move data from Azure to on premise SQL databases for reporting.
  • State Exchange of Education Data (SEED) enables states to track, monitor and share information for transfer students who cross state lines.
  • Designed and developed the database and also the ETL process to extract demographic data in xml format and can be used in the search engine.
  • Teacher Resource Link (TRL) is an application that delivers vetted and aligned digital resources to Georgia Teachers.
  • Designed and developed the database. Responsible for loading multiple resources from various sources in different formats into our database.
  • Georgia Virtual School (GAVS) , Learning Object Repository (LOR), Student Growth Model (SGM), Assessment Factory and multiple financial applications dealing with managing Federal and State fund distribution to County and School levels.
  • Designed and developed the databases for Georgia Virtual School (GAVS). Build SQL agent jobs to sync data between the new and legacy applications as certain components were running on the legacy application.
  • Designed and developed database for Student Growth Model. Built and migrated the database on SQL Azure used for public consumption.
  • Platform/Tools: SQL Database on Microsoft Azure, SQL Server 2012/2008R2/2008, My SQL, PostgreSQL, Mongo DB 2.4, TFS, Visio, JSON, MSRS & Windows 2012 Server and Microsoft Azure.

Data Architect/DBA

Delta Technology
04.2002 - 07.2005
  • Worked on the SalesNet, NIS, RDO, SOAR, PCI, Orbitz Supplier Link projects at Delta Technology.
  • Worked on the Evaluation model as part of the PCI project.
  • Designed, developed and maintained SQL Server 2000 database for .NET applications (VB.Net, ASP.Net) written in C#.
  • Responsibilities include data modeling, design and development of the database. Performed role of a DBA in creating the database, performance tuning, backup and recovery and building stored procedures. Used DTS to migrate data from multiple data sources to the SQL Server database. Performed the duties of a DBA, Creating Roles, Synonyms, Granting privileges to the end users, managing and monitoring the rollback segments. Tuned the views using Explain Plan Utility to enhance the Response time of the Reports.
  • Working on the migration of UNIX script based ETL processes to using Informatica.
  • The current process involves extracting data from a Teradata data warehouse environment to an Oracle database. The new process was built to access data from a Teradata Data Warehouse. Created schema and data marts. The Oracle database will eventually be migrated to SQL Server Database.
  • Worked on the design and development of the SOAR (Sales Organization Account Relationship) system.
  • Responsibilities include data modeling, application design and development. The application gets data from various outside sources (ARC, IATA etc.) and which is loaded after applying Delta business rules. The application also has a web-based component which is used by the Sales Department to define the hierarchy.
  • Worked as a DBA for the project helping out with creating tables, indexes and views, performance issues, writing stored procedures and performing backup and recovery tasks.
  • Worked on defining the architecture of Orbitz Supplier Link projects.
  • Main responsibility is defining the architecture in working with various teams that are involved to accomplish this task. The goal of the project is to help Orbitz to connect directly to Delta to purchase their tickets instead of using Worldspan which is the practice now. This would help in reducing the costs paid to Worldspan in the process of buying a ticket.
  • Worked on defining the architecture, design and development of Passenger Count Incentive (PCI) project.
  • Responsibilities in this project include defining architecture, data modeling and the development of the incentive processing component. This project has multiple components like processing and summarizing travel data, applying rules for incentives based on contracts and the analysis tools that help the sales agents to create contracts. Most of the backend components were developed in C++.
  • Worked on the solution for the Passenger Sales Hierarchy to implement the business changes in the Reference Data Objects (RDO) system.
  • Maintenance support for the RDO application which contains the Passenger Sales Hierarchy and Travel Agency Hierarchy.
  • Migrated the NIS Data Extract Utility application to comply with the WRM specification which includes implementing Delta Passport and the Authorization (AUZ) API.
  • Worked on the enhancements and maintenance of the SalesNet application.
  • SalesNet is a web-based application written in Java using Servlets and JSP technology. The application helps the sales force at Delta Airlines to efficiently manage the clients that they are working with (like large corporations and travel agencies) in getting their business. The application is built using the MVC architecture.
  • Environment: XML, C#, .NET, VB.NET, VBA, C++, PRO
  • C++, Unix Shell scripting, Perl, PL/SQL, T-SQL, Java, J2EE, Orbix, Sun Solaris, HP/UX, SQL Server 2000, Oracle 8.1.7/9i, Teradata, WebLogic

Technical Lead/Data Architect

Alcoa Inc.
06.2001 - 03.2002
  • Worked with the production services team of Alcoa GIS.
  • Worked on the design of an application internal to Alcoa to measure the e-commerce statistics of the Alcoa intranet applications. Objectives include interacting with the different projects and business units that are using the application in order to get historical data and also to handle the information moving forward.
  • Mentoring java developers and working on the bug fixes of Alcoa’s intranet applications.
  • The applications were built on a J2EE platform using the MVC architecture with JSP pages serving as presentation layer, Servlets acting as controllers, delegating to java-bean services which get the relevant data from an Oracle Database. Also working with a team to work on porting the application from JRun to OC4J.
  • Worked on the design and development of applications using Mercury TestDirector and Remedy to create a knowledge base system for the helpdesk support to efficiently serve the users in a better and efficient way. Responsibilities include design and development of the database and creating the necessary UI.
  • Worked as part of the architecture in defining a technology-defining matrix (TDM) required for the evaluating EAI and B2Bi products (Vitria, Webmethods, MQSeries, OAI).
  • Environment: J2EE, JSP, Servlets, EJB, JRun3.0, HP-UX, Oracle 8.1.6

Project Lead

MetalSpectrum.Com
01.2001 - 05.2001
  • Technical Lead for the Contract Management System module of the metalspectrum.com b2b exchange. Responsible for implementation of the Provato Product Suite to provide a Contract Management Solution for metalspectrum’s metals exchange. The implementation provided a central contract repository, contract compliance and reporting, and integration with metalspectrum.com’s marketplace. Updated the JSP framework of the Provato Suite to match the look and feel of the Metalspectrum’s framework. Worked on the adapter (written in Java) that converts cXML (coming in from Ariba Marketplace) to ProvatoXML. Worked with the DBA and the UNIX system administrator in setting up, designing and creating and in tuning the database.
  • Environment: J2EE, JSP, Servlets, EJB, XML, XSLT, JRun3.0, Sun Solaris, Oracle 8.1.6

Senior Software Engineer

Metro Information Services
02.1996 - 12.2000
  • New Incentives System: Lead team member involved in requirement gathering, design and development of the New Incentives system (NIS). NIS is a re-engineered incentives processing system of Delta Airlines that deals with the travel agencies’ performance and payments. The system processes and analyzes 60 million bookings, 20 million flown in around 550000 markets per quarter. Worked on the database design and modeling for the system. Wrote shell scripts for getting the data in a TERADATA database on the mainframe environment to a UNIX environment. The data transfer was done through an NCR UNIX system to a SPARC 6000 UNIX server. The data was then loaded into an ORACLE database for further processing with shell scripts. The programs taking care of the business logic were written in PRO
  • C++. The testing was done on a SUN SPARC 6000, and the system has been ported onto a HP UX system.
  • NIS CORBA Server: Part of the team that developed the IDL interfaces for the NIS Server enabling it to communicate with other systems of the delta airlines such as tickets capture, bookings capture, automated contract entry interface.
  • NIS Server: Part of the team that designed and developed the NIS Server, which picks up the data feeds from RDO objects and populates the back end ORACLE database running on the HP-UX V-class m/c. Also responsible for the batch processes that evaluate the markets and create summaries.
  • RTB Sales Reporting Tool: This tool helps the delta reps track the performance of travel agencies. The front-end is developed in Visual C++ looks at the revenue, traffic and booking data of the agencies that the rep is concerned with. Worked on getting the data loaded into the Oracle database using PL/SQL procedures and functions.
  • Environment: PRO
  • C++, HP-UX, Sun Solaris, NCR UNIX, shell scripting, PERL
  • Environment: CORBA-ORBIX 2.3, IDL, C++, UNIX.
  • Environment: UML-Rose 98, C++, HP-UX, ORACLE, Rogue Wave tools, Clearcase.
  • Environment: ORACLE 8.0.5, PL/SQL

Software Developer

Oxford and Associates
06.1995 - 02.1996
  • Worked as a DBA on three Oracle databases in UNIX and Windows NT environment. Performed the duties of a DBA, Creating Roles, Synonyms, Granting privileges to the end users, managing and monitoring the rollback segments. Tuned the views using Explain Plan Utility to enhance the Response time of the Reports.
  • Environment: Oracle 7, SQL, PL/SQL, SQL
  • PLUS, DBArtisan

Research Assistant/Programmer

University of Alabama
08.1993 - 05.1995
  • Developed a finite element code in C and Visual Basic for two-dimensional stress analysis of three and four noded elements. Implementation done in VB to enable users to analyze structures of given geometry and shows a graphical representation of the structure designed before and after the stress analysis.
  • Designed and built a small company database system using the concept of relational database systems using DB2 and C on UNIX (IBM RS/6000) environment.
  • Developed programs in C for various concurrency control techniques for database schedules.

Education

Master’s in engineering - Mechanical Engineering

University of Alabama
Tuscaloosa, AL
05-1995

Bachelors in Engineering - Mechanical Engineering

Jawaharlal Nehru Technological University
05-1992

Skills

  • Databases: SQL Database on Microsoft Azure, Azure Data Explorer, Cosmos DB, PostgreSQL, MySQL, SQL Server 2005 and above, MongoDB, Oracle7 and above, Informix, Sybase, Teradata, HBase, Cassandra
  • Languages: Python, PowerShell,TSQL, Kusto Query Language, PSQL, PL/SQL, XML, C#, VBNET, C, C, SQL, Shell Scripts, Perl, Java
  • OS: Windows Server 2012/2008/NT/2000/XP, UNIX (SunOS, Solaris, AIX, HP-UX, SCO-Unix)
  • GUI tools: Azure Data Studio, SSMS, Robomongo, Visio, ERWIN, TOAD, SQL Navigator, Aqua Data Studio, VS Code, Visual StudioNET, JDeveloper
  • Version Control: Team Foundation Server, Visual SourceSafe, PVCS, ClearCase, MKS Source Integrity

Timeline

Senior Data Architect

Milliman/Akur8
05.2015 - Current

Senior Data Architect

Georgia Department of Education
08.2005 - 04.2015

Data Architect/DBA

Delta Technology
04.2002 - 07.2005

Technical Lead/Data Architect

Alcoa Inc.
06.2001 - 03.2002

Project Lead

MetalSpectrum.Com
01.2001 - 05.2001

Senior Software Engineer

Metro Information Services
02.1996 - 12.2000

Software Developer

Oxford and Associates
06.1995 - 02.1996

Research Assistant/Programmer

University of Alabama
08.1993 - 05.1995

Master’s in engineering - Mechanical Engineering

University of Alabama

Bachelors in Engineering - Mechanical Engineering

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Rajesh Jampala