Vinay Kumar Thota
************@*****.*** +1-603-***-****
Professional Summary:
Over 4+years of professional experience in IT industry as Oracle SQL/PLSQL developer, Analysis, Design and Modeling.
Strong knowledge on oracle architecture and data base design.
Excellent skills in designing and development of applications using Oracle, SQL/PLSQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
Experience in understating the business use cases and implementing logical, physical database schemas.
Oracle Forms and Reports.
Experienced in all phases of Software Development Life Cycle (SDLC).
Excellent SQL skills, experience in writing complex queries and working with database objects like tables, views, sequences, synonyms.
Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
Experience in Bulk Data loading using Oracle utilities namely SQL* Loader and External Tables.
Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
Working Knowledge on Unix and Windows.
Good knowledge on ETL tools/languages like SQL/PL/SQL/OWB/Informatica/T-SQL/PostgreSQL/Greenplum function/Talend
Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
Good knowledge of Data modeling using ETL tools, LAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
PostgreSQL features that are suited to smaller-scale OLTP processing, such as secondary indexes and efficient single-row data manipulation operations, have been omitted to improve performance using REDSHIFT.
Developing reports using ETL tool.
Created Database constraints like Primary key and foreign key using RDBMS concepts.
In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, T-SQL using database tools like Toad, SQL Developer, pgAdmin.
Designed and developed user interfaces using Oracle Forms 10g
Used Version Control Software.
Experience in Mathematical and Modeling and Numerical Analysis.
Excellent planning, analytical, written communication and Interpersonal skills.
Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
Technical Skills:
Data Modeling
Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling,
FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin
Front-end tools:
TOAD, SQL Developer, PLSQL Developer, pgAdmin.
GUI
Oracle Forms 6i/9i/10g and Reports 6i/9i/10g.
ETL & BI Tools
Informatica, ETL. Basic knowledge of SAS
Programming:
SQL, PL/SQL, T-SQL, JSP, UNIX/LINUX Scripting.
Operating Systems
Windows and UNIX/Linux.
Education:
Master of Science in Information Technology, 2016. Southern New Hampshire University, New Hampshire.
Bachelor of Technology in Information Technology, 2009. Jawaharlal Nehru Technological University, Hyderabad.
References:
References are furnished upon request.
Professional Experience:
Company: SRK SYSTEMS
Naperville, ILLINOIS.
Role: Database Developer October 2016 to Present
Responsibilities:
Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.
Implemented logical and physical database schemas.
Extensively worked on Schema Migration, Database Program Migration, and Data Migration from Sybase to Oracle by using Oracle SQL Developer.
Created database objects like tables, views, procedures, packages in Oracle and PostgreSQL using tools like SQL*Plus, SQL Developer, PL/SQL Developer TOAD, pgAdmin.
Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS_PROFILER, and Hints etc.
Worked on Dynamic SQL by using Execute Immediate and DBMS_SQL along with Bulk Collect.
Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading in the PL/SQL Packages.
Used UTL_FILE_PACKAGES for writing DBMS_OUTPUT into the files.
Monitor and troubleshoot the daily Database refresh process.
Wrote many UNIX scripts and CORN jobs to automate the ETL process.
Extensively used Oracle 11g/12c features like RESULT_CACHE, Compound Triggers etc.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day
Worked on Table partitioning and Index creation to improve the performance of the query.
Worked with DBA's regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
Experience in using oracle standards to secure the data from unauthorized and unauthentic access by restrict privileges like library-related, synonym related, SYS schema, and export/import to user. Applied risk mitigation strategies.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology using Informatica 7.1.3.
Worked on Apex DATA loader to load data into Sales Force.
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Many implementations are made to the existing database systems to provide cross-platform functionality.
Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project's success.
Involved in error corrections for change requirement and modify the existing code for enhancement.
Create a risk plan and list all the mitigations.
Provided users organization department specified privileges and access to database.
Facilitate timely approval of major milestones, approvals and signoff.
Report the project status and generate milestone reports.
Facilitate and document the post implementation results in the form of closure reports.
Conduct weekly status meetings.
Created Business Logic Layer & Data Access Layers to implement the MVC architecture
Participate in requirements review, application design review and test plan reviews
Environment: Oracle 12c/11g/10g, PostgreSQL 8/9, WINDOWS 7, SQL, PL/SQL, SQL * Plus, TOAD, pgAdmin, JSP, MVC, SQL*Loader, Shell Scripts, SQL Plus, Informatica 7.1.3, SQL Developer, UNIX/Linux, VI editor Windows XP
Company: ABSOLINSOFT
North Extension, Seethammadara, Visakhapatnam
Role: PL/SQL Developer April 2012 to April 2015
Responsibilities:
Interacted with the Business Analysts in understanding the business requirements for the project.
Gathered the requirements from the users and analyzed their business needs and created SRS documents.
Involved in SDLC including designing, coding and testing.
Writing Technical design documentation. SQL tuning of queries.
Complex queries like inline views and Sub queries. Initializing TIBCO jobs by using Data Base.
Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, SQL Developer, PL/SQL Developer TOAD.
Defined database requirements and designed data model
Created Forced Views.
Extensively used Dynamic SQL for calling procedures
Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER
Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
Writing PL/SQL scripts for the DDL's. Fixing bugs in .txt, .csv and .dmo files.
Running explain plan for tuning the SQL queries.
Import and export of data from Xl sheets.
Extensively used for all and bulk collect to fetch large volumes of data from table
Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using ETL. Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
Created Indexes for faster retrieval of the customer information and enhance the database performance.
Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
UAT testing for the functionality for application.
Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Table Partitioned by creating a table in to smaller level partitions based on date. Usually we do for Saving storage space and Performance issues instead of querying whole big table.
Used informatic for extraction, loading and transformation (ETL) of data in the data warehouse.
Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
Environment: Oracle 11g/10g, PL/SQL, Oracle Forms 10g, Informatic, Reports10g, SQL Navigator, LNIX, Windows XP, WINCVS, SSH, SQL Developer, PLSQL Developer, TOAD.