Priyanka Saluja

ac4f8c@r.postjobfree.com

201-***-****

SUMMARY

6+ years of hands-on IT experience in analysis, design and development of complex software solutions in client reporting and wealth management sectors.

Experience in IT industry in verticals like Telecom and Financial Services with emphasis on design, development, implementation and management of projects.

Excellent team player and proven track record working in various team sizes performing cross-functional roles.

Strong experience in entire SDLC process – requirement analysis, design, development, testing and maintenance of projects.

Intensive experience in translating business requirements to Database Objects.

Expertise in constructing T-SQL and Oracle PL/SQL Tables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per the business rule.

Expertise in creating Joins and Sub-Queries for complex queries involving multiple tables.

Strong Experience in writing advanced query concepts using having clause, group by etc.

Hands on experience in tuning SQL queries for enhancing the database performance.

Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Worked in AGILE and Waterfall methodologies mode of software development (SDLC).

Efficient in design test strategies for performance testing and volume testing of PL/SQL solutions.

Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DBMS_SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for front end module

Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, TK-Prof and Table Partitioning.

Expertise in Dynamic SQL, Collections and Exception handling.

Extensively used SQL tools like SQL Developer, SQL Server Management Studio.

Rich experience in Agile planning tool JIRA and defect tracking tools like HP Quality Center.

Received ‘Bravo Award’ by the employer as an appreciation for handling the key deliverable to the client.

Have strong collaboration and interpersonal skills and worked with Product Owners, Business Owners, Technical Teams and Functional Teams during design, implementation and testing.

Excellent problem solving skills, ability to handle multiple projects simultaneously, comfortable in interaction with both business and technical team members.

Experience in working with multiple teams under strict deadlines.

Quick learner, adaptive and possesses good inter personal skills and work ethics.

Excellent communication skills, diligent and good team player.

SKILLETS SUMMARY:

Methodologies and Framework

Agile/Scrum and Waterfall SDLC methodologies, Release Management, Database Design (RDBMS)

Operating System

Windows

Databases

Oracle 10g/11g/12c, SQL Server

Languages

SQL, PL/SQL, C, C++, C#, .Net, HTML, CSS

Configuration Tools

Tortoise SVN, GIT, TFS

Documentation

Atlassian Confluence, Windows Office, OpenOffice

EXPERIENCE:

Client: SEI Investments Oct 2016 – Current

SQL Developer

SEI is a financial services firm, provides Innovative solutions for creating and managing wealth, including asset management, investment processing and investment operations.

SEI Wealth Platform (SWP):

SEI Wealth Platform is a multiple technology platform delivered via the Internet that provides customers with the information and functionality needed to enable sales, marketing, advice, service, administration, and business management. The technology provides enterprise architecture, shared components, and an enhanced user experience, which supports all markets and solutions. SEI Wealth Platform has various different modules which cover the various business processes like Relationship Management, Portfolio Management, and Activity management, Client Portfolio Management, Corporate Actions, Reporting, Transaction Services and Reconciliation. Platform is used to capture the entire trade life cycle of various securities. It includes trading and settlement.

Responsibilities:

Currently working as a database developer to bridge the gap between the product architecture and detailed designing.

Analyze the features that are loaded and split them into user stories and work with the product owner to prioritize them.

Identification of risks, dependencies, cross track impacts and managing them within the agile teams.

Design, Review and performance test the code to make sure it scales appropriately.

Working with the Product Owner to identify the opportunities for improvement and add them to the technical debt of the agile team.

Preparing the High-Level and Low-Level Design documents based on the understanding of the requirements.

Create test plans for Volume testing of code that is developed in a sprint.

Creating PL/SQL triggers, sequences, and stored procedures using Toad and SQL Developer.

Continuous review of Business critical Database to proactively identify space issues, performance tuning issues

Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.

Handled errors using System defined exceptions and User defined exceptions like INVALID_NUMBER, NO_DATA_FOUND and PRAGMA EXCEPTION_INIT.

Developed Row level and Statement level Triggers for auditing tables in PL/SQL.

Developed Views and Materialized Views for specific data retrieval for the reports.

Involved in the continuous enhancements and fixing of production problems.

Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.

Developed SQL *Loader scripts to load data in the Staging tables.

Developed PL/SQL stored procedures, user defined functions for complex calculations and bundle them into a stored package that could be invoked from the Forms triggers.

Making sure that the new code is written as per the coding conventions.

Perform unit testing to ensure that the developed or modified code is as per the client requirements.

Review the code entirely to ensure accuracy, completeness and quality of the deliverables.

Incorporating code review comments as a part of code review activity.

Fixing the bugs at every level of testing.

Analyzing the RCA and ensuring that preventive measures are takes so as to avoid the bugs coming up in the future releases.

Version control of the application code.

Attending and co-ordinate with offshore and onshore meetings to discuss the progress of the task assigned and the issue faced.

Providing Level 3 support for client code release in a live production environment.

Environment: Oracle 11g, 12c, Informatica

Tools Used: SQL Developer, SQL*Plus, Informatica Powercenter 9.1, GIT, HP QC, Confluence

Client: British Telecom July 2014 – Sep 2016

Module: RoBT (Rest of BT) SI (Single Interface)

British Telecom is one of the leading communication company serving the broadband, phone, TV and mobile needs of customers in UK and in more than 170 countries around the globe.

The project involved Agile based development & Enhancement activity for a major Telecom giant.

RoBT SI is the internal ticketing tool for BT employees wherein the users can check for the services they need to provide to clients. BT performs two sort of journeys, L2C(Lead to Cash) and T2R(Trouble to Resolve) to provide services to clients. Oracle was used as the database to maintain the data/ services required by the client.

Responsibilities:

Participate in the Design Workshops with the different stakeholders of the application and come up with the finalized approach.

Design Technical design document based on the business requirements.

Prepare technical artifacts, review the design thoroughly and estimate the effort and time required for preparing the requirement document, development of code, mapping it to the architecture.

Prepare the High-Level Design and Low-Level Design Document.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Partitioned the fact tables and materialized views to enhance the performance.

Extensively used bulk collections in PL/SQL objects for improving the performance.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Written PL/SQL Cursors for transaction processing.

Used Bulk collect feature to process the data from Cursor/Ref Cursor.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Create PL/SQL procedures using Global Temporary Tables and Dynamic SQL that will be used by the UI.

Create reusable views and materialized views that will source data from different tables within or across schemas.

Perform Unit Testing to check whether the developed code meets the user requirements.

Acted as the single point of contact for all Level 3 service requests.

Co-ordinate with the incident managers from different geographies and with other stakeholders for incident resolution.

Co-ordinate with the Business Analysts and with the users and compile the Low Level Design for the change requests.

Created new reports for the operations user using PL/SQL, Global Temporary Tables and PL/SQL collections.

Worked extensively with the universe team and database team and users to analyze the gaps.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Carry out internal and external code reviews and then incorporating changes as per required.

Track the defects and bugs found in the code during Unit test in HP QC.

Worked on TFS, SVN for version control, source control.

Fixing issues which popped up in QC.

Figured out the Root Cause Analysis for the issues and documented it in order to prevent it from coming in future releases.

Provided support for client code release in live production environment.

Involved in Logical & Physical Database Layout Design.

Created queries to minimize transactions, table data size and copy into historical tables.

Environment: Oracle 10g and ASP .NET 2.0

Tools Used: SQL Developer, SQL*Loader, SQL*Plus, Tortoise SVN, Visual Studio 2010 and Control M

Client: British Telecom July 2012 – June 2014

Module: SI (Single Interface)

The project involves developing a single interface module communicating with various modules developed on Client's Platform. The application sends and receives data to various upstream and downstream components. Various applications communicate to Single Interface Unit through XML files. Being the only User Interface, “Single Interface” – forms the heart of the application.

User defined graphs & trends are generated. SQL server database is used for Data management part.

Responsibilities:

Involved in entire project life cycle of Business, Database Design, Development, Implementation, Testing and enhancements of the application.

Created DDL Scripts for database schema and database objects.

Write SQL queries and stored procedures for high volume reports as per the business requirements.

Highly involved in query optimization and troubleshooting long running queries

Used SQL Profiler, Execution Plan and Database Engine Tuning Advisor tools to trace the slow running stored procedures and tried to optimize the queries so as to enhance the performance.

Worked on deadlock issues and minimized the occurrences of these situations.

Created and Worked with Global Temporary Tables.

Developed various user defined functions and created different views.

Created cursors and triggers to maintain the referential integrity.

Extensively used joins and sub-queries to simplify complex queries involving multiple tables.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Rebuilding indexes and tables at regular intervals.

Created and automated various jobs.

Fault Management on QC.

Worked on TFS, SVN for version control, source control.

Provided 24/7 support for production database and also deployed the code in production environment.

Provided RCA for production issues and documented the resolution for the same.

Coordinated with onshore, offshore teams and created BRD and FRD documents based on the requirements.

Performed code reviews and planned test plans for the project deliverables.

Environment: T-SQL, ASP.NET 2.0

Tools Used: SSMS 2005, Visual Studio 2008, HP Quality Centre, SVN

EDUCATION:

EXAMINATION / DEGREE

INSTITUTION

YEAR OF PASSING

MARKS

B. E. in Computer Science

Chitkara University, Himachal Pradesh,

India

2008-2012

85%

HSC

C.B.S.E

2008

78.2%

SSC

C.B.S.E

2006

95%

Contact this candidate