Profile
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
- 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.
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
** 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.
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.
SSI
Tools
Personal projects/Tools I created
Tidbits Quotes and tidbits I'd like to remember
scrummie A simple Agile based project management system
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.
http://challa.net/getwebfile: Download any text file off of a website.
https://code.google.com/archive/p/browsepad/: Simply a Notepad with a built-in file explorer. This was featured on BrotherSoft.com
http://www.brothersoft.com/browsepad-468773.html
http://challa.net/excel2csvconverter: 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
http://challa.net/renameext: 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!!
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
Reference
Master Data Service - Leaf table reference
Power shell - tidbit I'd like to remembrer
__
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
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, ...