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 the IT industry in verticals like Banking and Financial Services, Telecom Domain with emphasis on design, development, implementation and management of projects.
• Proficient in PL/ SQL, T-SQL programming.
• Have strong collaboration and interpersonal skills and worked with Product Owners, Business Owners, Technical Teams and Functional Teams during design, implementation, and testing phase.
• Strong experience in entire SDLCprocess - 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, Analytical Functions to facilitate efficient datamanipulations as per the business rule.
• Expertise in creating Joins and Sub q ueries 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 normalization Techniques.
• Worked in AGILEand Waterfall methodologies mode of software development (SDLC).
• Efficient in design test strategies for performance testing and volume testing of PL/SQL solutions.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Table Partitioning.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Extensively used SQL tools like SQL Developer, SQL Server Management Studio.
• 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 interpersonal skills and work ethics.
• Excellent communication skills, diligent and a good team player.

TECHNICAL SKILLS

Methodologies and Framework: Agile/Scrum and Waterfall SDLC methodologies, Release Management, DatabaseDesign (RDBMS)

Operating System: Windows

Databases: Oracle 11g, SQL Server

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

Configuration: ToolsTortoise SVN, GITHUB, TFS, Ctrl-M, Informatica

Documentation: Atlassian Confluence, Windows Office, OpenOffice, Share Point, JIRA

PROFESSIONAL EXPERIENCE

Database Modeling/ Developer

Confidential, Charlotte, NC

Responsibilities:

• Involved in database design for integrations of various source systems with center pole (data mart).
• Participated in requirement gathering business activity.
• Developed ILMS credit module and involved in extensive database development.
• Worked on various JIRA tickets which involved creation of database objects, Tables, Views, Stored Procedures, and Functions as per ILMS standards.
• Provide production support in critical deployment.
• Involved in ongoing enhancement work for ILMS application.
• Prepared production installation scripts and deployment documentation.
• Involved in other modules of ILMS such as Wires and Payment Instruments.
• Created indexes and optimized queries using Query Execution Plan.
• Incorporated code review comments as part of code review activity.
• Worked closely with testing team and supported them with their testing.
• Developed ad-hoc SQL queries to analyze and troubleshoot data errors.
• Working as a part of team involved in high complexity source code development.
• Fault Management on HP-QC.
• Worked on SVN, GITHUB for version control, source control.
• Working in Agile Scrum Team and using JIRA for complete project communication.

Environment: T-SQL

Tools: Used: MS SQL Server2014, SVN, GIT, JIRA,HP QC

Oracle PL/SQL Developer

Confidential, Oaks, PA

Responsibilities:

• Currently working as a database developer in data migration team which is responsible for migration of client data from Trust300 to SWP platform.
• Creating PL/SQL procedures, functions, cursors and sequences 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.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• 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.
• 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

Tools: Used: SQL Developer, Toad, GIT, HP QC, Confluence

Senior Systems Engineer

Confidential

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.
• 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.
• Worked on TFS, SVN for version control, source control.
• 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.

Environment: Oracle 10g and ASP .NET 2.0