Data Sql
Resume:
Sahiti Kamineni
**************@*****.***
PROFESSIONAL SUMMARY:
Over 1 year of extensive experience as a software developer in Oracle PLSQL.
Excellent command over SQL, PL/SQL proficient in SQL and Oracle databases.
Oracle 10g/11g/12c, SQL, PL/SQL; Query Optimization, Performance Tuning, and referential integrity, Packages, Stored Procedures, Triggers and Export/Import Utilities.
Good experience in client/server technology, GUI design, Relational Database Management Systems (RDBMS)
Experience in Data warehousing design & Concepts and ETL
Modified database structures including table spaces, tables, views, triggers, stored procedures.
Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
Good knowledge in UNIX Shell Scripting.
Experience in working with UTL Files and Dynamic SQL.
Experience in working with Informatica web services components. Proficient in designing, modeling, creating and maintaining Oracle database.
Used ETL to load data from different source systems like Flat files into the Staging table and load the data into the target database.
Experience in monitoring Performance and Tuning of the database for optimization using Explain Plan.
Knowledge of other Programming languages like Java, VB .Net,C# .Net
Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
Trained in Oracle DBA and have knowledge in DBA concepts like Database installation, configuration, Tablespace management, User management, Data pumps, ASM, RAC, Data Guard, Goldengate, RMAN, Backups, Patching and upgrading of the database.
Strong perseverance and diligence towards attaining challenging goals and effective time management.
Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.
EDUCATION:
Masters in Applied Computer Science, Northwest Missouri state University
Missouri -- Aug 2013 - Dec 2014
MS Applied Computer Science GPA: 3.3/4.0
Relevant Coursework: Java, Network Security, iOS, Advanced Database, Project Management, Information Technology
Bachelor of Technology in Computer Science & Engineering May 2013 GPA: 3.5
Jawaharlal Nehru Technological University, Hyderabad, India
TECHENICAL SKILLS:
Operating Systems
DOS, Windows XP/7, Linux, UNIX
Languages
SQL, T-SQL, PLSQL, C, C++, Java, C# .Net, VB .Net
Scripting Languages
JavaScript, Perl, HTML and XML
Databases
Oracle 10g/11g/12c, SQL server 2000, MS Access
Utilities
SQL* Plus, SQL* Loader, SQL Navigator, TOAD, UTL_File, ETL tools Informatica Power Center, OEM
PROFESSIONAL EXPERIENCE:
Harte Hanks, Trevose, PA June 2015 – Till date
Oracle PL-SQL Developer/Analyst
Responsibilities:
Worked on Large Data Base processing millions of records Change requests and Source Controls.
Developed PL/SQL code to implement business rules using procedures, functions
Worked on export and import of data, SQL *Loader, UTL File package.
Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using AllLink Transact Load (Front end Application used for ETL)
Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
Integrated SQL server reporting services with ASP.Net to view generated reports in Crystal reports.
Involved in Unit Testing the code before Deployment.
Created indexes on the tables for faster retrieval of the data to enhance database performance
Used hints in select statement for improving the performance.
Created PL/SQL program units to include DDL statements using Dynamic SQL.
Used cursor variables to pass query result sets between PL/SQL programs and client application
Handling CR’s and implementing according to the business rules as per required to the client.
Developed complex queries to retrieve the data
Wrote Queries to retrieve data in XML format from the tables.
Worked on the Analytical functions.
Involved in UAT testing, Bugs fixing and the code was sent to Production.
Involved in developing test plans and test cases based on high-level and detailed designs.
Involved in Production Support and troubleshooting data quality and integrity issues.
Interacted with clients in remote locations to verify customer requirements.
Responsible for writing the technical documents and maintaining the documentation.
Handled Production issues with high pace and efficiency.
Environment: Oracle 12c/11g, PLSQL Developer, SQL *Developer, UNIX, Windows 7, AllLink Transact Load, Virtual Source Safe (VSS), MS Office.
Karvy Global Services, Hyderabad, India May 2012 – Aug 2013
Intern/ SQL Developer
Responsibilities:
Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts.
Created Materialized Views, Triggers, Sequences, collections.
Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms.
Worked with tuning the complex Stored Procedures for faster execution using bulk collections.
Involved in design, development and Modification of PL/SQL stored procedures,
Functions, packages and triggers to implement business rules into the application.
Extensively used cursors for fetching the rows.
Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
Developed complex triggers in reports before/after for validation of user input.
Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks.
Environment: Oracle 9i/10g, SQL, PL/SQL, SQL*Plus, Windows.
ACADEMIC PROJECTS:
1. Project Title: "Pallet App"
Description: Deliver a warehouse management system to control the storage of products within the warehouse and track their movement from source to destination.
Environment: iOS 7, iOS interface, C#, SQL database, ASP.net.
2. Project Title: “Nymble-Blocking Misbehaving Users”
Description: Nymble is a system which BLACK LISTS the misbehaving/invalid users from unknown networks. This is a secure system which provides properties: anonymous authentication, subjective blacklisting, fast authentication speeds, rate-limited anonymous connections.
Environment: HTML, JavaScript, CSS, JAVA, SQL, Apache Tomcat.
Contact this candidate