TECHNICAL SKILLS

• 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 wif 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 wif 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 wif Oracle 10g and Automating backups.
• Experience wif XML packages, XML parsing and loading into Oracle.
• Worked on Red Hat Linux to install MYSQL, Mongo DB and MS SQL server.
• Experience wif working on tools like MS Access 2016, MS Visio, Oracle Policy Modeling.
• Innovative professional wif 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 wif DevOps tools like Chef, Maven, Ansible, Puppet.
• Expertise in working on TFS, SVN, CVN for source code management.
• Good experience wif 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 triggers 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 wif Business users to gather requirements for developing new Reports or changes in the existing Reports.
• Gathered detailed functional requirements by interacting wif 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 Triggers.
• 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 you're 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 wif DevOps team and written code in GIT repositories.
• Installed Ansible and written Ansible cookbooks for Automation and cron jobs in UNIX.
• Worked wif 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 wif 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 wif the front-end design/JAVA team to provide them wif 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 triggers for Audit process.
• Developing data archival process wif 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 wif DevOps team and used chef for automation and written chef recipes.
• Working closely wif 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, cHARLOTTE, NC

Responsibilities:

• Developed PL/SQL Packages, Procedures, and Functions in accordance wif 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 wif the system.
• Coded several Unix Scripts to interface wif 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 wif their applications in AutoSys.
• Physical Data Warehouse design, table partitioning, indexing strategy, materialized views, hands on wif 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 wifin 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 wif 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 wif 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, triggers.
• Working wif SSIS

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