Aadarsh Nalla

Background

About Aadarsh Nalla

ETL Developer/Support and Data Archival/BI Analyst with 9+ of IT Experience. Good working knowledge in architecture / design in multiple business domains ranging from Banking, Financial services and Health. Worked on IICS, GCP Bigtable, Dataflow, Big query and Cloud storage etc components, Informatica 10.1.1, Teradata 14, Oracle 12c, SQL Server, Unix, CA WA Workstation (scheduling tool), BMC Remedy tool and BMC Control-M Scheduler and HPE Content Manager, HPE SDM and SAP BO WebI. Creating data pipelines and providing cloud native solutions. Mapping design documents in session level to taskflow level and building lineage inventory Strong SQL working experience in Teradata, Oracle and SQL and large-scale database management including building and tuning complex SQL queries, bteq scripts, Mload, Fload and TPT utilities. Provide SQL queries or views for downstream reporting. Track the efforts and completions of the tasks through JIRA’s or Kanban if they are defects. Validated the data between Teradata and Big Query tables. Created detailed design, development, testing & migration documents and performing Proof of Concepts (POC). Delivered all the projects and assignments within the specified timelines with accuracy. Created detailed technical specification, business requirements and unit test report documents. Responsible for validating the developed applications against the predefined design standards. Jot down the defects based on the validations and bring them to closure. Perform error handling process, debugging and troubleshooting the applications. Also have experience in building universes (UNX & UNV), retrieving data using universes and personal data files, creating ad-hoc reports using business objects and web intelligence tools in 4.2. Having a very good experience in data archival in HPE Content Manager and HPE Structure Data Manager for unstructured and structured data.