SUMMARY

• Over 6 years of experience in analysis, design, development, testing and supporting of business applications in OLTP, OLAP and web - based Client/Server architectures.
• Worked wif various clients in Banking, Health Care, Financial and Insurance domains.
• Expert knowledge inSDLC(Software Development Life Cycle) and was involved in all phases in projects process and familiar wif Agile, Scrum, and Waterfall methodologies.
• Proficient in analyzing teh end user requirements and converting them into efficient Technical Solutions.
• Extensive experience in database programming using Oracle SQL/PLSQL, Informatica and Unix shell scripting.
• Extensive experience in implementing enterprise-wide Oracle based Client/Server and web applications.
• Responsible for all backup, recovery, and upgrading of all of thePostgreSQLdatabases.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and ProductionPostgreSQLdatabases wifin teh organization.
• Extensive experience in shell scripting,Python, or any other scripting language
• Expertise in developing complex code units like packages, procedures, functions, triggers and optimizing performance in Oracle 10g/11g/12c versions.
• Demonstrated experience in writing complex T-SQLqueries as per requirements.
• Experience in designing and development of integration of teh oracle applications wif peer systems like SAP, Teradata, SQL Server, Oracle etc.
• Strong Knowledge on oracle architecture and database design.
• Experience in Database design using Normalization and E/R Diagrams.
• Expertise in loading data from legacy systems/flat files using SQL*Loader or external tables or ETL tool (Informatica Power Center).
• Experience in developing ETL programming using PL/SQL packages, stored procedures, functions, triggers.
• Experience in developing Database Triggers to enforce Data integrity, Data security and additional Referential Integrity.
• Experience in developing views to restrict users by providing column level security on teh database tables.
• Experience in developing integration logic using ETL tools like Informatica Power Center (version 9.5.1).
• Experience in using Jira to track teh cases/tickets in teh production environment.
• Experience in working on Unix/Linux servers such as developing UNIX shell scripts, scheduling jobs using CRON tab, checking logs, validating inbound/outbound files, day to day maintenance activities.
• Experience in Query Optimization, Debugging, Tuning and improvising performance of teh database, using teh Oracle tools like Hints, Explain Plan, and TKPROF.
• Strong knowledge on OLTP and OLAP components development.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency
• Strong Analytical, Problem solving and communication skills.
• Extensively involved in communicating wif teh business users in resolving teh issues and contributing in teh design sessions.
• Experience in all SDLC stages wif CMMI level procedures and processes.
• Hard working, aggressive in acquiring new skills, ability to excel under pressure, innovative, self-motivated and good problem-solving skills.
• Experience effective in visualizing and implementing creative solutions to teh most complex requirements.

TECHNICAL SKILLS

Programming Languages: PL/SQL, PL/PGSQL, SQL, C, C++, .Net, Core Java

Web Technologies: HTML, HTML5, XHTML, PHP

Scripting Language: XML, CSS, Java Script

Database: Oracle 10g/11g/12c, SQL Server, MS Access.

ETL: Informatica 9.5.1

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2007, UNIX, Linux

Tools/Utilities/IDE: Oracle Warehouse Builder, SQL Developer, PLSQL Developer, SQL Navigator, SQL*Plus, SQL*Loader, Dream viewer AQT (Advanced Query Tool), Oracle forms and reports 9i, UML, Export & Import (DTS), SSIS (Integration Services), SQL Server Analysis Services 2005, SQL Server Reporting Services 2005.

PROFESSIONAL EXPERIENCE

Confidential, New York

Oracle PL/SQL Developer/Data Analyst

Responsibilities:

• Responsible for requirements analysis, database design, development and unit testing of teh application.
• Involved in teh full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Developing teh Data Mart for teh base data in Star Schema, Snow-Flake Schema involved in developing teh data warehouse for teh database.
• Developed and Debugged PL/SQL packages, procedures, functions and to ensure integrity of loaded data, based on pre-defined table-driven validations.
• Wrote Loader scripts using SQL Loader/External tables to load large tables.
• Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
• Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• Designed database tables using various normalization techniques and database rules.
• Performed maintenance work on teh database.
• Analyzed data integrity problems and provided assistance in giving solutions.
• Experience wif industry standard methodologies such as Agile in various software development project.
• GeneratedAWRand SQL Monitoringreportsfor SQL Performance tuning.
• Extensively used DTS package in Migration of teh data from teh previous timesheet database in SQL Server database to Oracle 10g.
• Developed queries or stored procedures using T-SQLto be used by reports to retrieve information from relational database and data warehouse
• Actively involved in troubleshooting database issues.
• Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
• Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules.
• Experience in creating autantication schemes and authorization for security components.
• Developed transformations, schemas and driver programs usingPython3.0 to transform thedataas per teh business needs (me.e., type-1, Insert/Update and type-2 logics)
• Modified and debuggingOracleForms 11g andOracleReports11g through theOracle Forms Builder andOracleReportBuilder applications.
• Creating Problem Ticket, LCM JIRA request for DBA to execute teh script in teh database.
• Worked wif Dynamic SQL, Global Temporary Tables. Created materialized views, Inline Views & normal views where business requirements needed.
• Worked in Oracle reports and forms version 6i and 10g.
• Worked on Pro*C programs and PL/SQL Scripts to generate full extracts of large tables.
• Extensively used bulk collection in PL/SQL objects for improving teh performing. Developed stored procedures and packages. Extensive work in PL/SQL. Developed Reports and forms using Oracle Designer.
• Worked wif development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.

Oracle Developer

Responsibilities:

• Analyzed teh business requirements for teh enhancements needed in teh contract Administration application and related policy modules.
• Implemented various customized Oracle reports using different techniques in Oracle SQL/PLSQL like SQL*Plus reports.
• Translated client data requirement s to logical data model using ERWIN modeler.
• Created and maintained data model whenever their are new table requirements.
• Generated DDL for DB objects.
• Provided 24*7 on call support to production environment.
• Created huge database packages wif related functions and procedures.
• Developed views by joining multiple cash flow tables to show output as a report to teh user.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to incorporate advanced modules.
• Worked on BULK COLLECT for bulk loading teh data into various transaction tables.
• Added database triggers to some history tables of teh database for keeping track of updates to values in a history table.
• Responsible for migrating teh data and data models from SQL server and Oracle environment to Teradata environment and applied Big data and Hadoop on top of it.
• Synched up teh models by reverse engineering, compare model and merge model from
• Was a part of conversion team and have taken part actively in propose an idea to convert data from DB2 database to Oracle.
• Coding tasks have included Server/Database configuration, Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Transaction Control Language (TCL), .NET CLR stored procedures, triggers, functions and data retrieval structures using T-SQL, PL/SQL (ORACLE)
• Used file handling in Oracle to read and write into files associated wif teh modules.
• Worked on external hints during teh SQL optimization to fast up teh SQL process.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, stored procedures, functions and packages.
• Skilfully defined teh list codes and code conversions between teh Source Systems and Data Mart as well as actively involved in extensive data analysis on Teradata and Oracle Systems querying and writing in SQL.
• Used No SQL database Amazon dynamo DB (AWS) to store data of reporting Application.
• Used JSON for data exchange between browser and server. Used JSR353 for processing and manipulating JSON objects.
• Associated wif physical and Logical Data Modeling using Erwin. Created models based on teh dimensions, levels and measures requires for analysis.
• Responsible for design, develop and implementation of BI reporting solutions using SQL Server 2008 SSRS
• Assisted in working wif Data stage Design of ETL mappings
• Database security by autanticating users, using logon triggers. Created materialized view on remote database and automated scheduler for refreshing of materialized view.
• Responsible for performance tuning, SQL tuning and optimization of SQL queries and indexes.
• Conducted GAP analysis to understand functional and technical dependencies in teh documentation of new ecommerce features and functionality.
• Extracted teh Business Requirements from teh end users keeping in mind their need for teh application and prepared Business Requirement Documents (BRD) and tan translating into functional specifications and test plans. Closely coordinated wif both business users and developers for arriving at a mutually acceptable solution.
• Error handling and monitoring SQL Server for Scheduled jobs.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel and Oracle.
• Developed korn shell scripts to kick off back endPL/SQL, SQL, Pro*C programs.
• Developed screens andForms10g usingOracle Forms/Reports6i/9i. Also developedreportsusing Pro*C andPL/SQL.

Confidential, Franklin, TN

Oracle PL/SQL Developer

Responsibilities:

• Involved in design sessions to understand teh business requirements.
• Created Erwin data models for developed applications.
• Preparing estimates, prototyping teh solution.
• Preparing solution design document, functional documents and technical documents.
• Review teh components developed before deployment to test environments.
• Involved in preparing test scenarios and performing unit testing and supporting system integration testing and UAT testing.
• Developed backend PL/SQL packages, building UNIX shell scripts for data migration & Batch Processing
• Maintained General Ledger usingOracleFinancials, produced managementreporting, reconciled General Ledger issues and made adjustments where needed.
• Automated managementreportingusing OBIEE and Tableau
• Written Python scripts to connect-extract-stage as a part of dataloading process for web-based API calls
• Tuning performance of teh database using tools like STATSPACK, EXPLAIN PLAN, TKPROF, SQL TRACE,AWRand ADDMreports.
• Train business users and client IT team to make them comfortable wif application.
• Support application during batch window and non-batch window.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data wif master tables, insert teh valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying teh errors.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Confidential

Oracle Database Developer

Responsibilities:

• Created database objects like tables, synonyms, sequences, views.
• Developed ETLs to pull data from various sources and transform it for reporting applications using PL/SQL.
• Strong Performance tuning and optimization experience wif SQL and stored procedures (PL/SQL)
• Documented Technical Specs, Dataflow, Data Models and Class Models.
• Performed integration testing wif frontend reporting infrastructure.
• Wrote shell scripts for automating teh process of data loading.
• DevelopedTableauworkbooks from multiple data sources using Data Blending.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Worked on data warehouse, data mart reporting system in accordance wif requirement.
• Involved in developing and scheduling using Cronjobs to load teh data into teh database and export/import mechanism for data migration for bulk upload.
• Documented requirements gatheird from stake holders.
• Completely redesigned teh database process in PL/SQL to be able to configure variables in database tables opposed to code and developed system alerts to proactively notify about discrepancies in data.
• Deployed database objects (procedures, triggers, tables) to production.
• Identified dependencies of different components.
• Review, process and carry out regular site and office safety audits and inspections for all related site projects.
• Conducted code review to ensure development standards.
• Created materialized views, partitions, tables, views and indexes.
• Developed complex hierarchical SQL queries to provide hierarchical views of organization’s structural data in Organizational Mapping system.
• Involved in writing Technical Specification Documentation.
• Developed APIs to validate inputs and retrieve data for frontend applications.
• Built dashboards using SSRS, Tableau and PowerBI for teh business teams to take cost effective decisions.
• Developed Reusable PL/SQL functions for validation of inputs.

Confidential

PL/SQL Developer

Responsibilities:

• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts.
• Used export and import utilities for logical backups.
• Involved in Data Analysis for teh data warehouse and data mart system.
• Analyzed and discussed teh business requirements wif teh business owners and business analysts.
• Optimized and modified teh triggers, complex store functions, procedures.
• Wrote test scripts for testers to test teh system before it goes to production.
• Maintained user accounts.
• Created PL/SQL Procedures, function Packages and SQL queries starting from middle level to high level complexity based on system needs
• Reorganized existing automated reporting scripting system to increase performance and reliability.
• Wrote technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).