Jyothirmai

y9jyothirmai@gmail.com

615-625-6457

SQL Developer

9 years experience W2

Recommendations

Average rating

216

Profile views

Summary

Over 5+ years of experience as a SQL Developer with extensive experience of analytical techniques.
Experience in all phases of Software Development Life Cycle.
Expertise in Client-Server application development using Oracle, PL/SQL, SQLPLUS and TOAD.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
Expertise in Client-Server application development using Oracle, PL/SQL, SQLPLUS, TOAD.
Hands on experience in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
Experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center and SQL Loader.
Expertise in Dynamic SQL, Collections and Exception handling.
Exposure in using CASE tools like SQL Developer for writing PL/SQL programs.
Proficient in SQL Server and T-SQL (DDL and DML) In constructing Tables, Normalization/ Denormalization Techniques on database Tables.
Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTLFILE.
Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and exception handlers.
Very good experience in Oracle tools like SQLPlus, SQLLoader, SQLDeveloper using TOAD in secure databases.
Having experience in Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
Knowledge of Relational Database Management systems.
Experience in installation, configuration of Oracle, MySQL, MSAccess, MSSQLServer, MongoDB and DB2.
Extensive ability on Data modelling tools Erw in and UML.
Very good knowledge of SQL, PL/SQL especially writing queries WIJoins, Sub-Queries, Rollups, Cubes, Set Operators.
Prepared flowcharts, database ER diagrams using diagramming tools like Microsoft Visio.
Good team player and have the ability to work independently in a time sensitive environment
Good organizational and communication skills, with the ability to express technical concepts verbally and in written.

Experience

Education

Skills