Manager Developer

Sheetal Verma

Female ** Years India

+91-965**-***** ************@*****.***

SUMMARY

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 .

KEY SKILLS

PL Sql / Sql

Shell Scripting

Ownership,Leadership & Team Management

PROFESSIONAL EXPERIENCE

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

EDUCATION

Bachelor of Technology – Computer Engineering National Institute of Technology (NIT) Jaipur, IN ‘12

Contact this candidate