Custom search page

Profile

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

Currently working with Big data using Hadoop technology stack (HDFS, Map Reduce, HBase, Hive, Sqoop, Hue), Actian Paraccel database; SAS DataFlux, Bash Scripting, Python, Java and SQL Server.

Linkedin Profile: http://www.linkedin.com/in/shivachalla 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, VB.net, C#.net.

__
















































































Experience

Merkle Inc. A Customer Relationship Marketing Agency

Senior Database Application Developer - current 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.

Sprint/Nextel

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



SSI

Education

MS in Computer Engineering

Fairleigh Dickinson University, NJ, USA

BE in Computer Science & Engg

Periyar University,TN,India

















































































Tools

Technologies

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

Tools

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

Languages

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

Personal projects/Tools I created

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.

http://challa.net/getwebfile: Download any text file off of a website.

http://challa.net/browsepad: Simply a Notepad with a built-in file explorer.

http://challa.net/excel2csvconverter: Converts Excel(.xls and .xlsx) file to CSV files. Each individual tab will be converted to a seperate CSV file.

http://challa.net/renameext: Rename several file's extension in a folder in a jiff.

NEWhttp://challa.net/fc: Fortune Cookie : Simple demo of using Php to get data from a text file.

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!!

MSSQL_ObjectScripterv1.1_SetUp.zip Tools that will script out database objects out of Microsoft SQL Server 2000/2005/2008

ConsoleJobScripter_SetUP.zip Console tool to automatically tool to script out job definations out of Microsoft SQL Server 2000/2005/2008.

JobScripter_SetUp.zip GUI tool to script out job definations out of Microsoft SQL Server 2000/2005/2008

__
















































































Contact

About Challa.net

This is the homepage of Shivaram Challa or Shiva. I am hosting this site on Godaddy. This particular profile page is built using a HTML, CSS, JQuery plugin called Scrollto

other sites

readcache.com

Ads by Google