Ankita Rawal Email & Phone Number

Gurugram, Haryana, India

Involve in requirement gathering for new development work as well as coding (writing stored procedures/functions/triggers etc.), testing &implementation.Performance tuning of PL/SQL block i.e. Indexes, clusters, Hints and many more.

Chandigarh, India

Noida Area, India

• To analyze business user needs, collate requirements, and produce functional specifications within project to enable the technical project team to build systems as per requirements.• Worked on reporting/compliance requirements including FATCA, PSDMMR, ISA’s,LISA etc and core product improvements for UK Market.• Good knowledge of working on agile methodology, writing user stories, conducting daily stand-ups, identifying product backlog items, prioritizing & assigning it to different sprints and closing the same.• Strong understanding of various SDLC methodologies such as Waterfall and Agile with hands on experience on them.• Use of JIRA for logging work and related communications on tasks assigned.• Currently Working on Oracle Fusion Forms according requirement given by client.• Lifetime ISA requirement for UK banking, Creating new forms or amending on old forms according requirement.• XML publisher is used while creating XML .Soap UI is also used to check the connectivity between AIS and Summit.• Clearcase used to check out the forms, Unix Script , sql and come to know old checkin files detail from previous release.Technology :- Oracle Fusion Middleware, Oracle 12c, JIRA

Noida Area, India

CLIENT – British Telecom.•This project was all about implementing EUGDPR security guidelines for safeguarding sensitive personal data stored in OBOE. Under this all bank account numbers, credit card numbers, personal details,Building soceity roll numbers were tokenized using a secure token vault.•OBOE front end screens were changed to incorporate this tokenization capability on the fly.Apart from this I was also involved in creating customized API to perform one time data migration of exiting bank account numbers.• We have check performance issues while tokenizing bank accounts through Explain plan,Indexes,Cluster,Hints and partitioning Delivery of end to end sustain services to Client  Define, agree and organize Service reviews. Review service performance against SLA and focus on improvements, particularly the client experience Handling of internal and external customer issues on behalf of Soprasteria Ensure risks to the service delivery are identified and mitigated. Performed incident management, problem management, release management, change management. Service level management Overall Service Reporting and driving Continuous Improvement Plans  Lean initiatives undertaken for Incident Reduction, Service Request reduction, Small Works, Band Mix, Productivity savings and TOM Transition of New and any changed application succession and Rotational Planning of resources Created and modified several UNIX Shell Scripts. Involve in requirement gathering for new development work as well as coding (writing stored procedures/functions/triggers etc.), testing & implementation. Performance tunning of PL/SQL block i.e. Indexes,clusters,Hints and many more. Majourily used bulk collection in PL/SQL objects for improving the performing. Audits – DNV, BT SecurityTECHNICAL :PL/SQL, Oracle 10g,Windows 2005/2008 Server, HPUX, Oracle E-Business Suite R12, XML publisher.

Gurgaon, India

Project Overview :- To design a data warehouse for UNICA campaign system from the existing BI system for sending the campaign to customers and after getting the response from the customer do reporting on that data for the clients.RESPONSIBILITIES Developing around 200 KPIs at Mobile Number data for their campaign system. Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements. Worked on SQL*Loader to load data from flat files through Script. Modified stored procedures, functions according changes need in project. Working on collections and Records to fetch millions of Records in best time duration through SQL engine.  Extensively used bulk collection in PL/SQL objects for improving the performing. Using external table to fetch records through UTL_FILE. Performance Tunning of PL/SQL Block.  Managing and leading the team, providing weekly and monthly status reports to client and ensuring client satisfaction.  Involve in requirement gathering for new development work as well as coding (writing stored procedures/functions/triggers etc.), testing & implementation. Providing 24X7 supports to production instances of the application. Client Interaction for updating status, building customer confidence and generating new requirements to expand the scope of work.  Enhancement for the application (new releases which include user requirements), testing, Root cause analysis and Bug fixing. Customization development of the application by creating server objects and database experience of SQL/Oracle. Bridge case handling. Liaising with other support team and users over phone and email. Raise Change Request for Release, Outage, Fix and Testing.TECHNICAL ENVIRONMENT: PL/SQL, Oracle 10g,Toad,Unix(AIX),Shell Scripting,DB2.

Noida Area, India

Project Overview :- CIRAS is the Circuit service order and engineering tracking system of CenturyLink. The acronym of CIRAS is Circuit Administration System. This application provides Facility, Circuit and Trunk Provisioning system for CenturyLink. CIRAS is a distributive processing system that provides the engineering function related to the Access and Non-Access circuit provisioning process. EASE create a PON and send to Ciras. Ciras create Circuit and send to NIDA for Data warehouse. Creating of circuit is depend on three orders i.e. SSO,FCO,TCO. RESPONSIBILITIES• Creating and maintaining PL/SQL Procedures, functions and package as per client’s requirement. • Writing new procedures • Maintaining Triggers codes of backend database trigger for transaction forms to maintain the data accuracy and transaction.• Worked on collections and Records so that user can fetch the records fast and for optimization of queries. • Check for SQL queries performance tuning according result, optimization through performance tuning. • Shell scripts to open the orders and many more other shell scripts are used to run the files.• Customization of forms and amendment in forms.• Using external table to fetch records through UTL_FILE.• Involved in SQL tuning process to increase the speed of queries in database.TECHNICAL ENVIRONMENT: Oracle 10g/9i,PL/SQL,Oracle Forms 6i/10g,Reports 10g,UNIX(AIX).

Master Of Computer Applications - Mca, Computer Software Engineering

Dr A.P.J. Abdul kalam Technical University, Lucknow

Bachelor'S Degree, Computer Engineering, Bca