back Shivaram Challa's Profile
site search


Data Architect and Programmer Analyst

"It's all about data"

I specialize in developing database centric solutions to fullfill information needs of the organization, helping management to make informed decisions. Leveraging on Data integration and Data quality improvement experience.

Experienced Data warehouse architect, Dimensional Data Modeler, ETL designer, Data Integration, Data quality management, Metadata repository and management, Performance metrics accumilation, Business intelligence

Experienced in designing, implementing and maintaining system interfaces with synchronous and Asynchronous communication, data extraction, data profiling, data integration, data quality, Metadata analysis; while using the most suitable tool and/or technology for the job, including Direct Database access, Web services, Message Queues, CSV/text files, web scrapping, programming API, FTP, XML, Custom programming using C#, ColdFusion (CFML), VBScript and Batch programming.

I produce outstanding results leveraging on my strong technical, analytical and problem solving skills to analyze, design, develop and support highly available, highly performing systems, while leveraging on user requirements analysis, database design skills, strong programming background, excellent oral and written communication and adroit understanding of business.

Ccurrently, I am with Hogan Lovells, an international law firm, as the Data Architect. I am leading the effort to create a centralized data integration hub and master data management solution.

Linkedin Profile: Skills & Tools: SAS/DataFlux Data Management Studio, Oracle & PL/SQL, IBM WebSphere MQ, Oracle SQL Developer, Toad, MS SQL Server, Expert T-SQL skills, SQL Server Integration services (SSIS), Reporting services (SSRS), CA ERWin, Crystal reports, Oracle Forms & Reports, Windows 2003/2000. SFTP, DatabaseMail, Visual Studio 2005, Business Intelligence Development Studio (BIDS), Management Studio (SSMS), SQL Server Profiler, Performance monitor, Microsoft Security Baseline analyser, Database Engine Tuning Advisor, Teradata SQL Assistant 7.2, Oracle SQL Developer, MS Excel and Access, HTML, XHTML1.1, JavaScript,,



** Please click here for my interactive Resume **

Hogan Lovells
Global lawyesr - International Law firm

- (current) - As the Data Architect, I am leading the effort to create a centralized data integration platform and master data management solution.

Merkle Inc.
A Customer Relationship Marketing Agency

Senior Database Application Developer Currently working with Big data using Hadoop technology stack (HDFS, Map Reduce, HBase, Hive, Sqoop, Hue), Actian Paraccel database, SAS DataFlux and SQL Server.

Lockheed Martin IS & GS Civil

Enterprise Data warehouse Design,Implementation & Administration, Metadata & Master Data Management, Logica Work Management Information System Administration, MS SQL Server 2005/2008 DBA, Oracle 10g/11g DBA, Reporting and BI.


Enterprise Data warehouse Design, Implementation, Master Data Management, Metadata, BI, Reporting Services, Maintenance automation.

Inphonic (now Simplexity)

Software Research Group (now Bartronics America)

Hamburger Law firm/MarketCounsel

FDU Student Union

FDU Continuing Education



MS in Computer Engineering

Fairleigh Dickinson University, NJ, USA

BE in Computer Science & Engg

Periyar University,TN,India


Certified ScrumMaster®

by Certificate link

Certified Merkle Digital Professional

I have attended 10 classes and passed 11 exams to be certified MDP


Merkle One Team Award

- for Hadoop Migration work from Cloudera to Horton works

Merkle attribute award - Passionate

- for helping another team for an oracle database related project

Merkle attribute award - Sense of Urgency

- for diligently working on getting a client's corrupt reference base back online

NOVEC - Lockheed Martin IS &GS Civil - Recognition Award

For outstanding customer service that was appreciated in a communication from the client.


Personal projects/Tools I created

Tidbits Quotes and tidbits I'd like to remember

scrummie A simple Agile based project management system

NEW (fortune cookie): Check your Fortune now!!
Simple demo of using Php to get data from a text file.

All the following tools are coded in C#. They are all licensed under GNU GPL 3. Which means you can download, use and redistribute at will. Download any text file off of a website. Simply a Notepad with a built-in file explorer. This was featured on Converts Excel(.xls and .xlsx) file to CSV files. Each individual tab will be converted to a seperate CSV file.
*** Received SOFTPEDIA "100% FREE" AWARD Rename several file's extension in a folder in a jiff.

NEW"Single page" or "One page" website template using JQuery. As you can guess, the whole website is in one page.

Simple website template using AJAX and JQuery will be added soon!! Tools that will script out database objects out of Microsoft SQL Server 2000/2005/2008 Console tool to automatically tool to script out job definations out of Microsoft SQL Server 2000/2005/2008. GUI tool to script out job definations out of Microsoft SQL Server 2000/2005/2008


Tools & Technologies I work with

SAS DataFlux Data management server Administration, Oracle 10g/11g Server Administration, Microsoft SQL Server 2005/2008 Server Administration, MS IIS 6.0/7.0 Administration

Hadoop, Map/Reduce, SAS DataFlux Data management server Studio,
Toad, Oracle SQL Developer, Oracle Enterprise manager Console,
Microsoft SQL Server Integration Services, MS SQL Server Reporting Services, MS SQL Server Analysis Services, Microsoft SQL Server 2005/2008 Data managements studio
MS Visual Studio 2010, Adobe ColdFusion Builder, Oracle Forms and Reports Developer, Oracle Fusion Middleware/Oracle JDeveloper studio 11.1.2


Bash scripting, Python, Java, PL/SQL, T-SQL, C#, C/C++,, Coldfuision, JSP, XHTML 1.1, HTML4, CSS3, Java Script, VBScript, Windows Shell scripting, ...



This is the homepage of Shivaram Challa or Shiva. I am hosting this site on

This particular profile page is built using a HTML, CSS, and JQuery plugin called Scrollto

Photo by Peng Chen on Unsplash
Ads by google-ads

other sites