Sruthi C Email & Phone Number

Chicago, Il, Us

• Functional Developer for the Client.• Responsible for the implementation of business implications and knowledge transfer to the application developer, project manager or onshore team including status reporting. • Supporting Critical and all other applications of the client and ensure their efficient functioning.• Client interactions upon stand-up calls, requirement gathering and analysis prior development.• Responsible for requirement analysis with Business Specification Documents and Functional Requirement Specification Documents, development and unit testing.• Worked extensively in creating Queues, Queue Manager Functionalities, PL/SQL objects. • Created Packages, Cursors, stored procedures, functions, XML parsing, XSD validations.• Interactions with Testing team and closure of defects logged.• Created shell scripts for calling DB related objects.• Lifecycle management through Serena Dimensions Tool. (DEV/TEST/INTEGRATED ENV)

• Requirement analysis and understanding• Over 3+ years of programming experience as an Oracle PL/SQL developer in Requirement gathering, analysis, design and implementation of Applications using Oracle RDBMS.• Experience in creating Materialized views to replicate data across different environments.• Experience in creating Web applications using ASP.NET MVC architecture with ADO.NET/ENTITY FRAMEWORK as Data Access Layers with C#.NET as code -behind language.• Experience in implementing the requirements in Agile environment using Confluence, TFS.• Developed complex database objects like Packages, stored procedures, functions, cursors and collections.• Implementation of the design document and unite testing in the development environment.• Creation of Queues, Queue Payload Objects, propagation of queue data across distributed databases.• Creation of queue listeners(packages) to process the queue records and updating underlying tables with processed data.• Created Shell scripts for calling the implemented packages.• Scheduling of Control-M jobs for the shell scripts.

Bangalore, Karnataka, In

• Requirement analysis and understanding.• Created Shell Scripts for invoking SQL scripts and scheduled them using CONTROL-M.• Performed Performance Tuning for the existing functionalities using Explain Plan and HINTS.• Loaded Data into Oracle Tables using SQL Loader.• Worked extensively on Ref Cursor, External Tables and Collections.• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.• Collaborated with test teams for functional and user acceptance testing.• Participated in change and code reviews to understand the testing needs of the change components. Worked on trouble shooting defects in timely manner.

Hyderabad, Telangana, In

• Requirement analysis, understanding and documentation• Created Used bulk collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. • Created PLSQL scripts to extract data from the operational database into simple flat text files using UTL_FILE built in package.• Used Pragma autonomous transaction to avoid mutating problem in database trigger.• Extensively used the advanced features of PL/SQL like Records, Triggers, Object Types and Dynamic SQL.