Information Technology Operations Analyst
Bangalore, India
• Gathered, collated, transformed, analyzed large sets of rich banking datasets for my client(VISA,RBS) using advanced SQL queries and provided actionable insights to management team/ key stakeholders to make strategic decisions. • Performed ad-hoc analysis in analyzing and transforming complex data to meaningful reports and dashboards. • Performed data filtering and wrangling using DB2, SQL and Hive databases. • Achieved 100% success in creating automated test tool to migrate and encrypt data from DB2 to Hive database. • Translated business propositions into quantitative queries and collect/clean the necessary data using the Data warehousing tool Informatica in an agile environment. • Evaluated the workflow orchestrations that increased the efficiency of ETL pipelines to process over 20 TB of data daily in Banking projects. • Created Dataframes with Python, using Pandas, experience with NumPy, analyze large datasets to build data-driven stories using Jupyter Notebook. • Synthesized current business intelligence data to produce reports and publish presentations, dashboards utilizing Tableau, highlighting findings and recommending changes. • Developed test plans for structured and unstructured data, depending on user scenarios and performed A/B testing involving permutation concepts and hypothesis testing using Python.• 75+ critical reports were created, upgraded and validated using Microstrategy reporting tool. • Prepared regression test plans, interacted with design team to decide on various dimensions and facts to test the application. • Defect tracking and management using JIRA.