Gitanjali Sharma

Senior Analyst Programmer

Fidelity International•  August 2019 - Present

Created technical design for the back end PL/SQL based on business requirement documents and the functional system design. Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer. Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. Involved in updating procedures, functions, triggers, and packages based on the change request. Built complex queries using SQL and wrote stored procedures using PL/SQL. Used ref cursors and collections for accessing complex data resulted from joining of a large number of tables. Used Oracle VPD to hide sensitive data from all users except authorized users. Extensively used for all and bulk collect to fetch large volumes of data from the table. Orchestrate ETL process using BMC Control?M. Data ingestion using in?house built Django utility. Performed in agile methodology, interacted directly with entire team, provided/took feedback on design,suggested/implemented optimal solutions, and tailored application to meet business requirement and followed standards

System Engineer

TCS•  January 2017 - August 2019

Leading the implementation team at SocGen Securities. Vital member of the development team off shore. Major hands on PL/SQL. Development involves file read /write in PL/SQL, writing Package and procedure, cursors,triggers and PL/SQL collection(PL/SQL table, records) for processing huge volume of transactional data. Development of External and Global Temporary tables for maintenance high volume file upload and download. Development of desktop application screens using Microsoft .Net. Providing QA/UAT/Production Support. Real?time development of SQL queries for clients for audit level data. Query optimization and performance tuning in Oracle. Well versed with software development life cycle including requirement analysis, development, troubleshooting, implementation and post implementation support. Vital Contributions: SociétéGénérale: Member of Product Implementation and then SPOC which involved implementation of Segments(Equity, Cash Derivatives and Currency Derivatives) IDFC Securities: Off?Shore Developer for Product Implementation (Equity, Cash Derivatives) Citigroup Global Markets (India) Private Limited: Off?shore Developer for Product Implementation which involved implementation of Segments(Equity, Cash Derivatives, Currency Derivatives and SLB)