Poonam Diwate

Project: AT&T Mobility

Technology: SQL (Oracle 11g), PL/SQL, and Unix.

Products : Ensemble , Enabler

Tools Using: Citrix(Priceplan onlines), SIDTEL, RDS(AT&T tools)

Responsibilities :

• Implementing business parameters & tarrif plans in (Ensemble/Telegence)billing system as per business needs.
• Implementing offers, packages in Rating Logic Configurator (RLC) application as per business requirements. Providing reference changes in enabler as a dump to UAT and also for Production.
• Handling production defects, as well as UAT issues, through data manipulation via SQL queries.
• Handling dump activities and dump delivery on time to effect the changes done in Master Environment onto Production Environment, DB compare report preparation.
• Automation in extracting QA, MQ testing report directly from the SIDTEL web application in Java.
• Automation to schedule a reminder message for filling daily report in python.
• Automation to structure the bulk data and make SQL query of it using Excel VBA.
• Automation to fill the fields in web application Citrix PPOL automatically, as per the Excel sheet provided by the business in Java.

• Experience of working with KANTAR-GDC-AMA as a programmer since January 6, 2020.
• 2+ years of experience working in SQL and Java. Ability to understand and manage deployment using the same.
• Knowledge and experience of development using Python & SQL in ad hocs like MONDELEZ, LUX, NISSAN, ABBOTT, FAIR AND LOVELY, VASELINE & trackers like FRESHLY (water bottle survey)
• Knowledge and Experience of Data Visualization in Projects Like NESTLE, LOREAL, by using Power BI.
• Worked and shared accurate reports to clients of well-known companies like LIFEBUOY, LUX, LOREAL, SURF, DOVE, MONDELEZ, KNORR, MRF, FRESHLY, etc.
• Knowledge about CAWI, CAPI, and CASI methodologies of survey techniques.