PROFESSIONAL SUMMARY:

• Around 8 years experience in programming, System Analysis, Design, Development, and Support of Oracle Database in Production, Staging, Development, and Testing Environments.
• Expertise in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Created distinct types of database objects Indexes, tables, Sequences, Synonyms
• Proficiency to create composite data types such as PL/SQL records and PL/SQL collections.
• Ability to manage objects dependencies in the Oracle database.
• Strong ability to handle Oracle Exceptions.
• Strong knowledge of Oracle utilities like SQL*Loader, Export/Import, Data Pump and External Table.
• Experience in working with SQL Server Reporting Tools (SSRS) and SQL Server Integration (SSIS). Hands on experience in ETL process using different ETL tools and using PLSQL to populate the tables in OLTP and OLAP Data warehousing environment.
• Solid development skills in Oracle tools and technologies including Oracle Forms and Oracle Reports.
• Experience in query optimization, performance, and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Worked heavily with relational database models, schemas & entity - relationship diagrams (ERMs) to create technical/system design documents.
• In-Depth Knowledge of Oracle Architecture, data dictionary, to understand Schema Objects, Schema Objects Relations, Schema Privileges, Roles, and Restrictions.
• Experience in using several built-in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, and DBMS SQL.
• Strong knowledge of PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Gained valuable experience working on Linux environment with Oracle 10g and Automating backups.
• Experience with XML packages, XML parsing and loading into Oracle.
• Worked on Red Hat Linux to install MYSQL, Mongo DB and MS SQL server.
• Experience with working on tools like MS Access 2016, MS Visio, Oracle Policy Modeling.
• Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction through expertise knowledge in database programming using PL/SQL Collections, Cursors, Bulk Processes (DML), Merge, Dynamic SQL (DDL), Exceptions handling, Autonomous transactions, Pipelined Table Functions, Partitioning, Materialized views.
• Experience in OOAD Object Oriented Analysis and Design techniques using UML in Relational Rose and Enterprise Architect.
• Experience with DevOps tools like Chef, Maven, Ansible, Puppet.
• Worked on AGILE methodologies and used tools like JIRA, Graphite and Sensue for tracking issues and weekly scrum.

TECHNICAL SKILLS:

Languages: Java, C, C++, UNIX shell scripting, Linux Bash, HTML.

Databases: Oracle, SQL Server, MySQL, SQL Developer, T-SQL, MongoDB.

Servers: Web Logic, Web Sphere, Apache Tomcat

Tools: BMC Control-M, Informatica, Toad, SQL*Plus, PL/SQL, SSIS, SSRS, Tableau, Microsoft Team Foundation Server (TFS), Chef, Maven, Ansible

Operating Systems: Windows 98/NT/2000/XP, UNIX, LINUX, Mac

Web technologies: HTML5, JavaScript, CSS.

Modeling Tools: UML on Rational Rose 4.0, MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Greater Seattle Area

Oracle developer

Responsibilities:

• Written triggers, packages, procedures and functions with the usage of PL/SQL for implementing business processes.
• Using informatica 9.1/8.6.1 in domains such as power center and power mart, I have gained testing ETL experience (designing, workflow manager and monitor, server manager).
• Performed analytical, aggregate functions for math and statistical calculations using advanced SQL.
• Amping performance drastically achieved by using SQL optimization.
• Tuning complex sql queries.
• Experience in designing DB model for risk management app.
• Loading legacy data into staging tables and packages to validate and cleanse data using SQL Loader scripts.
• Creation of DB triggers, collections and cursors.
• Creation of table method INDEX BY for fetching records in random selection.
• Using TOAD performed code debugging.
• Using Tidal setup batch and prod jobs.
• Shell scripts were created to access and setup runtime environment and to run oracle stored procedures.
• Used html and javascript to fix bugs for rhapsody website.
• Reviewed the rules for data transformation and offered tech suggestions in data transformation logic and pseudo code.
• Refined DB using Explain Plan, TKProf thus improving system response time and efficiency.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.

Environment: oracle 11g, SQL, PL/SQL, SQL*Loader, HTML/Javascript, TOAD, ERWIN, Informatica, UNIX and Oracle 10g RAC.

Environment: SQL Server 2012, Windows 2003/2007 Server. SSIS, SSRS, Data stage and reporting tools Business objects, MS office, BMC remedy, Toad, Putty, MS SQL server, SQL server management studio, Linux, Microsoft Visio, Rational Rose

Confidential, Overland Park, Kansas City

Oracle developer

Responsibilities:

• Set the req analysis, sys design and prepared tech design docs.
• Written script to validate data extracted from legacy systems before loading into target systems.
• Developed DB objects such as tables, clusters, indexes, views, sequences, packages, triggers and procedures to troubleshoot DB issues.
• Loaded data in to temp staging tables using SQL*Loader scripts.
• Uploaded data from flat files in to the DB and validated it using PL/SQL procedures.
• Developed DB structures as per req and tuned stored procedures for quicker execution time.
• Created SQL and PL/SQL scripts for verifying req functionalities also in addition to developing stored procedures, packages, interfaces and triggers.
• Created DB triggers for implementing data integrity and referential integrity.
• Created shell scripts to call functions and automate the loading and extraction from legacy sys.
• Created INDEX BY Table Method to Fetch Records in Random Selection.
• Fine-Tuned and optimized number of SQL queries and performed code debugging using TOAD.
• Set up batch and production jobs through Tidal.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Used and excelled in version control tools such as MS visual source safe.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, TOAD, Java, HTML, MS Visual Source Safe.

Confidential, Phoenix, AZ

SQL DBA

Responsibilities:

• Installed and upgraded SQL server environments 7.0, 2005, and 2008
• Performed Backups and Restores of databases as per the business requirement
• Created Logins for the users, granted database privileges as per the request and security guidelines of the organization
• Carried out Extraction, Transformation, and Loading of Data into SQL Server from various data sources such as MS Access, MySQL, and Oracle
• Performed Data Import and Export using DTS packages within SQL Server
• Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems
• Created Stored Procedures, triggers, and views in SQL for data manipulation and reporting
• Carried out Reporting using Crystal Reports on SQL Server 2005 databases
• Worked with the system administrators, network, backup, and storage engineers to migrate all databases, procedures, and reports into a central data warehouse as a continuous effort

Environment: SQL Server 7, 2005, 2008, Oracle, MS Access, MySQL, SSIS, Crystal Reports, Windows.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures, and Functions in accordance with the business requirements for extracting legacy data and loading data into database tables as part of data migration.
• Involved as a key team member for Requirement Analysis during the design phase and developed various Design documents according to the user requirements.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Created technical mapping documents as part of data modeling and design.
• Created data stores, interfaces, procedures, packages and scenarios in ODI repositories.
• Designed and generated Oracle Forms and Oracle Reports.
• Developed user interfaces using Oracle Forms.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Generated dynamic web-reports using HTML, JavaScript.
• Efficiently designed the Database schema suitable for the client requirements. Implemented the Client-side HTML/ java script-based Pages for User Interaction with the system.
• Coded several Unix Scripts to interface with several external databases, Sybase ASE and SQL Server and packaged applications.
• Produced a UML workflow and object flow diagram for the EMR application using Power designer.
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys.
• Physical Data Warehouse design, table partitioning, indexing strategy, materialized views, hands on with PL/SQL, SQL development using packages and program units.
• Developed PL/SQL functions to facilitate business functions and calculations and did required modifications to the existing once.
• Created complex stored procedures, views, SQL joins and scripts.
• Create and edit SSIS packages including error management and logging.

Environment: Oracle 12c/11g, SQL Server 2012, SQL, PLSQL, UNIX, Sybase 9.0, TOAD, JavaScript, Oracle SQL Developer, Oracle Forms 11g, Oracle Reports 11g, SSRS, TFS, Putty, Shell Scripts, AutoSys.

Confidential

Software Engineer

Responsibilities:

• Involved in the preparation of specifications for PL/SQL procedures and functions to do the data migration and conversion
• Created Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections
• Coded SQL*Loader, PL/SQL procedures, and triggers to migrate data from legacy applications into Oracle 8i
• Updating existing procedures, functions, triggers and packages to synchronize with the changes in Transformations
• Involved in extracting large volumes of data from different data sources into staging tables, performing transformations on them before loading into final tables
• Involved in debugging the code when Tickets are assigned to fix the issue

Environment: Oracle 8i, PL/SQL, SQL, SQL*Loader, UNIX and Windows NT