Female ** Years India
5+ year’s experience in Database and Reporting .
Expert in PL SQL,Sql scripting language on Oracle, Mysql and Sql server Database .
Experienced in Shell scripting on linux platform,Reporting on JasperStudio and Oracle BI Publisher.
Experienced in Reconciliation using Intellimatch .
Leadership skills,Team player, value driven, and result oriented in delivering business requirements .
PL Sql / Sql
Ownership,Leadership & Team Management
Reporting – Jasper Studio & Oracle BI Publisher
Reconciliation - Intellimatch
Oracle, Mysql, sql server & Postgres Database
Database Management & handling
Tata Consultancy Ltd Gurgaon, IN Feb ’18 – Jul ‘18
Technical Lead (Database and Reporting) Feb’18 – Jul’18
Project Profile – RBS – Credit Submission
Documented the requirement collected from the client and distributed the work among the team members .
Support the client in oracle database migration from on premises to private cloud .
Documented the database configuration needed for migration purpose.
Populated data on reporting server and created bank reports .
Bharti Airtel Ltd Gurgaon, IN Apr ’16 – Dec ‘17
Senior Software Engineer (Database Developer and Reporting Analyst) Apr’16 – Dec’17
Project Profile – Airtel Payment Bank
Gathered business requirements, individually handled and delivered to business teams.
Support the team in migration of oracle database of Airtel Payment Bank on flex cube - Developed multiple complex Sql queries, procedures, triggers, functions,views, Reports and shell script.
Optimized the performance of queries, debug and exception handling of procedures.
Created shell scripts to call procedures, to create and copy data dump on servers or on mails, to insert data into tables,to enrich the data and to schedule automatic jobs.
Daily reconciliation of Airtel Payment bank data on intellimatch tool and created several reports based on result using Oracle BI publisher and jasper Studio.
Reliance Jio Infocomm Ltd Gurgaon, IN Jul ’12 – Jan’16
Software Developer – Database Development Jul’12 – Jan’16
Project Profile – 4G (HLR / HSS / IMS)
Database programming using c++ API of MySQL database which involves database activities, Database handling, database design, connection handling at application end
Designed and Developed a utility script file using shell scripting to provide facility to install/uninstall packages of MySQL cluster manager, generation of rpms and created databases on the servers and named this as Package Manager.
Implemented and optimized Pl/Sql stored procedures, Queries and other database activities on MySQL and Oracle Database as per requirement .
Created reports on jasper and deliver them to business .
Tools used : Sql Developer, Intellimatch (Reconciliation tool 9.1 version ), Sql yog
Database : Oracle,Mysql, Sql Server, Postgres
Reporting : Jasper Reports,Oracle BI Publisher
Language : Sql, PL/SQL, Shell Script
Bachelor of Technology – Computer Engineering National Institute of Technology (NIT) Jaipur, IN ‘12