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: http://www.linkedin.com/in/shivachalla
Skills & Tools:
- Architected and Implemented multiple Data warehouses in various business and technical environment.
- DBA experience in Both Oracle and Microsoft SQL Server.
- Experience with Very Large Database (VLDB) administration.
- Seasoned database design skills.
- Strong programming background.
** Please click here for my interactive Resume **
Global lawyesr - International Law firm
- As the Data Architect, I am leading the effort to create a centralized data integration hub and master data management solution.
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.
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.
Personal projects/Tools I created
NEWhttp://challa.net/fc (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 BrotherSoft.com http://www.brothersoft.com/browsepad-468773.html
: 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
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++, ASP.net, Coldfuision, JSP, XHTML 1.1, HTML4, CSS3, Java Script, VBScript, Windows Shell scripting, ...