SUMMARY

• Expertise in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, Confidential, 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).
• 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.
• Expertise in working on TFS, SVN, CVN for source code management.
• Good experience with working on Core JAVA, JAVA script and HTML.
• Experience in writing Technical design documents and developing Unit Test documents. Very good knowledge in C/C++, Java Script, Core Java, .NET, Postgres.
• 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, DMS

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

Sr. ORACLE Pl/SQL DEVELOPER

Confidential, HOUSTON, TX

Responsibilities:

• Wrote Stored Procedures, Functions, Packages and Confidential using PL/SQL to implement business rules and processes.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Optimized SQL used in reports to improve performance dramatically.
• Reverse engineering the existing data flow and transformation logics in SSIS for workflow consistency.
• Tuned and optimized the complex SQL queries.
• Had to design database model risk management application.
• Performance tuning on Data virtualization implementation in CIS.
• Worked with Business users to gather requirements for developing new Reports or changes in the existing Reports.
• Gathered detailed functional requirements by interacting with various stakeholders in the lead of senior business Analyst and hosted requirements review meetings.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
• Created Cursors, Collections and DB Confidential .
• Created Test Cases and performed Manual Testing like Positive Testing and Negative Testing.
• 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.
• Designed and implemented client-server application. Developed various complex User Interface screens using Oracle Forms Builder 11g.
• Migrating data from your Oracle source into PostgreSQL target using AWS DMS.
• Involved in working on AWS Schema conversion tool to convert Oracle schema to PostgreSQL.
• Provided UNIX scripts and Linux Bash for deploying and building the system.
• 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.
• Involved in working on Maven with DevOps team and written code in GIT repositories.
• Installed Ansible and written Ansible cookbooks for Automation and cron jobs in UNIX.
• Worked with HTML, JavaScript pages to create web pages and fix bugs for the Rhapsody web site.
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Tuned SQL queries, performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Developed application code using Java programs and worked with the development team to make changes on web pages
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables.

Environment: Oracle 11g, Oracle 12c, SQL, PL/SQL, SQL*LOADER, HTML5/JavaScript, TOAD, ERWin, Informatica, TFS, UNIX, Oracle 10g RAC, BMC Control-M, Maven, GIT, ANSIBLE.

SR. ORACLE PL/SQL DEVELOPER

Confidential, ATLANTA, GA

Responsibilities:

• Working on Agile Methodology
• Coordinated with the front-end design/JAVA team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages.
• Extensively used Dynamic SQL.
• Daily receiving flat file from different vendor and loading into Oracle database using SQLLOADER.
• Working on Oracle Total Recall to get history data for compliance audit process.
• Created various Confidential for Audit process.
• Developing data archival process with merging/exchanging table partition.
• Experience in Merging Partition, Exchange Partition and Drop Partition
• Involved in PL/SQL code review and modification for the development of new requirements.
• Working with DevOps team and used chef for automation and written chef recipes.
• Working closely with DBAs in monitoring the performance related issues.
• Involved in the continuous enhancements and fixing of production problems.
• Developing Auto-sys jobs and Shell Scripting in UNIX environment for scheduling routine task.

Environment : Oracle 12c, Jira, graphite, SQL developer, Putty, SQL Plus, SQL* Loader, FileZilla, Chef.

ORACLE PL/SQLDEVELOPER

Confidential

Responsibilities:

• 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.

SQL DBA DEVELOPER

Confidential

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, Confidential, 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.

SQL DBA DEVELOPER

Confidential

Responsibilities:

• Installed SQL Server 2005 in production and development environments.
• Successfully upgraded from SQL Server 2000 to SQL Server 2005 on various Environments.
• Installed and Configured SQL Server 2005 using Surface Area Configuration.
• Worked in Active/Active Clustered Environment.
• Migrated DTS Packages to SSIS packages
• Successfully deployed SSIS packages from test and development server to production server.
• Implemented Database Mirroring with High Availability Mode in SQL 2005.
• Migration of Data from Excel, Flat file, Sybase, Oracle to MS SQL server by using BCP and DTS utility.
• Extracting Transformation and Loading of data using SQL Server DTS and SSIS
• Through experience reading Execution plan for seek vs. scan operation
• Creation of Reports using tools like Crystal report, Microsoft SQL Server Reporting Service (SSRS)
• Implemented several types of Replication Models like Snapshot, Merge and Transactional.
• Maintaining both DEV and PRODUCTION servers in sync
• Creating back up strategies and scheduling them for execution.
• Helped Development Team in deploying and testing the application, which uses SQL Server backend.
• Writing functions, stored procedures, Confidential .
• Working with SSIS

Environment: SQL Server 7, 2000/2005, SSIS, SSRS, MS EXCEL, MYSQL