Praveen Kumar Nallana

About Praveen Kumar Nallana

Over 17+ years of experience in Data Modelling, Data Architecture, Data warehousing, & Extraction, Transformation, Loading (ETL) data from various source systems into Data Warehouse and Data Marts using Informatica Power Center 9.1/8.6.0/8.1.1/7.x/6.x. in various Verticals viz, HR, Banking, Insurance, Retail, Telecommunications, Health Care and Pharmaceuticals.• Proficient in Logical and Physical Data modelling, Dimensional Data Modelling (Star Schema/Snowflake Schema), Creation of FACT and Dimensional tables using Bill Inmon & Ralph KimBall Data Warehouse Construction Methodologies.• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, COBOL files, VSAM, IBM DB2 UDB, Excel, Oracle, Sybase, MS SQL Server, Teradata, SaaS Oracle Fusion (Financials and HCM) and Netezza.• Extensively worked with various Business Intelligence tools like Tableau/OBIEE/Business Objects/IBM Cognos Series 7, Hyperion Excel Essbase Add-In & Micro strategy Flash reports. • Well versed with handling of PHI and PII sensitive data which requires special handling and protection due to privacy and security concerns.• Expert in Database loading utilities including SQL Loader and Teradata TPump, Fast Load and MultiLoad.• Excellent in Problem Solving, Analytical Skills, Root-Cause Analysis, Change Impact Analysis, Debugging, Performance Tuning, Query and Memory Optimization techniques.

Experience

1. Staff Architect

   TriNet

   Feb 2017 — Present · Austin, TX, US

   Involved in Planning, Architecting, Data Modelling, Design/Development/Deployment/and Delivering end to end ETL solutions for various in-house projects (EDW1.0 to EDW2.0 migration/COGNO\'s retirement/Qualtrics survey automation/Timeline PI and Anaplan Integration/BODT (Back Office Digital Transformation) migration from PeopleSoft to Oracle SaaS Fusion Platform.

Education

• Andhra University

  Master’s Degree, Computer Science

  1998 — 2000

Skills

• Shell Scripting
• Data Integration
• Microsoft Sql Server
• Alm
• Pl/Sql
• Sql
• Ccar
• QA Automation
• Unix
• Data Modeling
• Unix Shell Scripting
• Oracle
• Requirements Analysis
• Agile Methodologies
• Defect Life Cycle
• Business Analysis
• Business Intelligence
• Sdlc
• Etl
• Team Leadership