Deepak Barla

About Deepak Barla

Experience in Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server/Legacy applications using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.•Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.•Experience in design and implementation of Star, Snowflake schemas and multi dimensional modeling.•Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader.•Worked on both Unix- based and Mainframe-based Warehouse environments.•Worked for multiple DataStage initiatives on a large Data Warehouse that processes more than 15 TB/year that grows at nearly 1 TB/year.•Sound knowledge on DataStage /Unix based ETL development and performance tuning•Experience in integration of various data sources like SQL Server, Mainframes, Oracle, Sybase, MS Access and Flat Files into staging area.•Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension Type II phenomenon, surrogate key assignment and change data capture.•Hands on Experience in UNIX Shell Scripting.•Proficient in Data analysis, Data modeling, Database design and Data migration. •Worked extensively on different types of stages like Join, Lookup, ODBC, XML Pack (XML Input, XML Output and XML Folder stage), Hashed File, Aggregator, DB2UDB, Transformer, Merge, Sort, Pivot, FTP, Change Data Capture(CDC), Filter, Modify, MQ Connector, Shared Containers for developing jobs.•Used the DataStage Director and Tivoli Maestro Scheduler, UC4 Scheduler extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics.•Good working knowledge of various Databases like Oracle11g/10g/9i/8i, DB2 UDB, SQL Server, Paraccel, Teradata.•Trained in Big Data,Hadoop.

Experience

1. Data Architect

   Carilion Clinic

   Apr 2021 — Present · Roanoke, VA, US

   Architect the framework and data pipelines for the Enterprise Data Warehouse.Design/Develop data pipelines for new/existing data pipelines.Work with staff and customers to understand the business requirements and business processes, design data warehouse (\" DW \") schema and define extract-translate-load (\"ETL\") and/or extract-load-translate (\" E LT\") processes for DW. Lead the teams in establishing analytic environments required for structured, semistructured and unstructured data. Drive rapid prototyping and design for new projects and analytic R&D environments. Translate broader business initiatives into clear team objectives and concrete individual goals, aligning appropriately with other groups for efficient, coordinated action.

Education

• University of Massachusetts Lowell

  Master of Science - MS, Information Technology

• Nalanada Junior College

  High School, Maths Physics Chemistry

  2000 — 2002

• Kakatiya Institute of Technology & sciences

  Bachelor’s Degree, Computer Science

  2003 — 2007

Skills

• Business Intelligence
• Data Warehousing
• Teradata
• C
• Uc4
• C++
• Informatica
• Unix Shell Scripting
• Ibm Db2
• Agile Methodologies
• Tws
• Ibm Mainframe
• Big Data
• Hadoop
• Java
• Data Integration
• Datastage
• Db2
• Oracle
• Shell Scripting
• Data Analysis
• Ibm Infosphere Administrator
• Unix
• Ca7
• Paraccel