Pankaja Shivananjappa

Experience

• 

  Sonata Software

  Sept 2006 - Oct 2008

  Senior Application System Analyst

  Roles:• Worked as PL/SQL developer.• Responsible for gathering the requirements from the client and analyze the technical aspects of it and then develop the Technical Design Document.• Involved in development of packages and procedures. • Involved actively in analysis of production issues and support activities.

• 

  Target

  Oct 2008 - Jul 2012

  Lead developer BI

  ° BI tools experience on Microstrategy,Web focus• Worked as Lead developer.• Worked in conjunction with business owners, architects and analysts, assessed the suitability of information systems in terms of their intended outcomes and collaborates with end users, software vendors, technical and application architects. • Involved in development of Dashboard and its components and testing.• Involved in UAT and client handover sessions.

• 

  Nokia

  Aug 2012 - Aug 2018

  Research And Development Specialist

  Roles:• As module lead, owned end to end design of new features along with meeting the timeline and quality.Also played scum master role(Agile) to keep up the motivation of the team and effectively tracking project activities.• Analysis of Dimension tables, Fact tables and Summary tables required for business analysis based on the business requirement and customer needs.• Involved in review of the content pack (Front end Application).• coordinating with different teams in process of release document preparation and reviews.• Responsible for analyzing upgrade path, Data model and Technical Document designing.• Upgrade to new Platform, Database and Content release to support new Content Packs.• Played Pronto coordinator role during maintenance phase which involved rigorously tracking pronto fixes from multiple teams on time.• Facilitating Daily Scrum Meetings and Monthly Reviews meetings. Conducted sprint retrospectives Show less

• 

  Wipro

  May 2019 - Jan 2020

  Lead Data Engineer

  As a Lead Data Engineer, with a team of 10+ Data engineers was handling ETL Design for quality data preparation and Reporting using AWS and Python. • Analyze different source of data and define mapping for the target tables.• Design ETL to retrieve data from different sources like excel, snowflake, onelake and load into MS SQL Server and S3.• Design Databricks notebook to retrieve data from refinery repository.• Automate the ETL process using python.• Monitor BAU (Business as Usual Process) to meet SLAs, trouble shoot the issues for quick recovery and Redesign BAU for new workflows• Generate Bank revenue reconciliation reports for end-users.• Analyze the Income statement for missing revenue amount and come up with correction action. Show less

• 

  Rolls-Royce

  Feb 2021 - now

  Data Engineer