SUMMARY

• Over 7 years of extensive experience in all phases of SDLC (Software Development Life Cycle) that includes Requirement Analysis, Design, Development, Integration, Documentation, Testing, Deployment, Code Management, Maintenance, Enhancements in Enterprise Application Integrations.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 12c/11g/10g, MS SQL, PL/SQL, T-SQL, SQL*PLUS, TOAD, SQL*LOADER and ERWIN Data Modeler .
• Created Tables, Views, Constraints, Synonyms, Sequences, Indexes and other database objects and granted privileges.
• Solid experience in writing and debugging stable and robust PL/SQL code using Exception Handling.
• Developed complex database objects like Stored Procedures, Functions, Packages, Triggers and Jobs using SQL and PL/SQL.
• Worked extensively on Cursors, REF Cursors, Collections, Dynamic SQL, Records & PL/SQL tables.
• Expertise in Performance Tuning and Query Optimization using analysis from AWR reports, E xplain Plan, SQL Trace, TKPROF, Partitioning, Bulking techniques, Hints and Materialized Views.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Experience in using Oracle Enterprise Manager (OEM) for monitoring Golden Gate streams.
• Extensive knowledge of using Oracle Data Dictionary and DBMS Oracle supplied packages like UTL FILE, DBMS JOBS, DBMS SQL, DBMS SCHEDULAR, DBMS STAT, DBMS OUTPUT, V$Tables, DBA Tables and All Tables.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• Experience in developing ETL mappings and scripts using Informatica Power Center 9.x/8.x.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Coordinate Production/QA related activities.
• Functional knowledge in Energy and Telecom domain.
• Clear documentation of technical specifications and strong interpersonal and communication skills in dealing with customers . Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies with expert time management skills.

TECHNICAL SKILLS

Programming: C, SQL, PL/SQL,T-SQL, HTML,CSS

Database: ORACLE 10g/11g/12c, MS SQL Server 2012

Platforms: Windows family, DOS, UNIX

IDE: SQL Developer, TOAD, Erwin Data Modeler, Informatica Power Center 9.x/8.x, Anaconda Navigator, Jupyter Notebook

Scripting: Shell Scripting

APM Tools: Dynatrace (DB Dynamics), SSIS, SSRS, AWR Reports, OEM, SOAP UI Ticketing - JIRA, Spira, Remedy, ADO

Other: GIT (Sourcetree), SVN, Fish Eye, Crucible, Beyond Compare, MS Office

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

• Worked on several tickets which involved analyzing the business flow and identifying various mile-stones and accordingly doing code-fixes and also coordinating with different teams to understand the data-flow within various sources and doing any data-fixes if needed, for both ‘EZStatus’ and ‘UOTM’ applications.
• Developed a collaborated Python script for CSM data load from SQL server to Oracle database based on the business requirements.
• Developed automated scripts for On-boarding new users to different portals based on their assignments to UOTM application.
• Scheduled different status reports and was also involved in resolving multiple Production issues on demand, related to EZStatus application.

Environment: Oracle Database 11g R2, SQL Server 2012, SQL Developer, PL/SQL, SQL*PLUS, SQL Loader, Anaconda Navigator, Python 3.6, Informatica 9.1, Linux, MS Excel 2010.

Confidential

Senior Oracle Developer

Responsibilities:

• Worked on Retail and Corporate Real Estate clients, creating outbound and inbound integrations using Oracle PL/SQL in backend for Store Life Cycle Management, Sales Forecast Model, Real Estate, Lease Administration and Facilities processes, which uses ADF in front-end.
• Worked on extracting data from XML files for inbound and outbound integrations to store different kinds of Customer data to the Tango database, using store procedures, packages, triggers and cursors.
• Generated email notifications for the error files for each integration with details including records processed and error messages involved.
• Worked on extracting data from pipe delimited text files, for storing different Vendor inbound and outbound integrations as well as complex Sales calculations with Actuals overriding forecast logic every month for different Sales inbound integrations, using records, functions, DML queries and logging the errors in Service log tables.

Environment: Oracle Database 11g R2, SQL Developer, PL/SQL, SQL*PLUS, SQL Loader, Linux, Excel.

Confidential

Senior Oracle Developer

Responsibilities:

• Worked on multiple projects- WINCare CRM, HIP and Dragonfly, including WINCare 4.0/5.0/6.0, WINCare CRM Performance, providing production support as required.
• Hands-on-experience in code development, testing, validation, migration and support on several production issues, co-ordinate with the Business analysts and Business Users while validation.
• Developed automated scripts in Oracle PL/SQL to maintain and support all the required databaseenvironments during project releases, code merges, database upgrades and refreshes, coordinating with offshore teams, and the DBAs.
• Supported the successful flow through between WINCare and other middleware systems likeInformatica, Oracle Golden Gate and BPMS by handling the appropriate triggers, jobs and otherdatabase objects in different schemas within WINCare databases.
• Developed several priming scripts to prime data into WINCare databases from several systems likeNGMSS, MSS Enterprise, MSShWin, Remedy etc.
• Kept multiple systems like Winforce (Salesforce) and Hwin-Paetec (Golden Gate) in sync withWINCare, by setting up the right parameters and resetting sequences and appropriate applicationconfiguration related URLs.
• Developed packages, functions, procedures, tables/views, indexes/triggers, materialized views, scheduler jobs and other database objects within our project development.
• Extensively worked on importing data files from the business through SQL Developer and usingSQL*Loader Control files for doing large data uploads and executing PL/SQL scripts using the loaded data, to update the customer accounts.
• Worked on the PSR-module, which involves case-by-case scripting to resolve issues occurring due to failure in creating Orders on the PSR-management tab.
• Extensively worked on preparing build scripts and installation instructions for each release and perform code deployments in different schemas in various environments.
• Developed the Services/Products pages related module in CRM application, also performed the Customer Services loads through service hierarchy tables and priming scripts.
• Generated a report of all logged exceptions and worked on fixing the high frequency database exceptions .
• Generated AWR Reports on weekly basis and worked on improving the performance of top SQLs.
• Developed PL/SQL ETL scripts to transfer the data across various schemas and databases and scheduling jobs to refresh the Oracle objects daily.
• Fine-tuned the application using DBMS Profiler, Explain Plan, TKPROF and Dynatrace Application monitoring tool to identify the bottlenecks and rewrite the queries and sub routines efficiently making use of result cache, parallel pipelined table functions, analytical functions, BULK Collects, FORALL inserts/updates/deletes, conditional debugging, instrumentation, inline pragma, materialized views & materialized view logs, object based multidimensional collections.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Worked on several emergency change requests (CRQ), high priority environment issues, codeenhancements, code defect fixes, JIRA tickets and different projects related SPIRAs.
• Deployed and migrated code using DEVOPS process (continuous deployment pipelines, integrating Git, Bit bucket and Jenkins) to different environments (Dev, Test, UAT, PROD).

Environment: Oracle Database 11g R2, SQL Server 2012, SQL Developer, Toad, PL/SQL, T-SQL, SQL*PLUS, Erwin Data Modeler, SQL Loader, Informatica 9.1, Oracle Application Express (APEX) 4.1/4.2, Linux, MS Excel 2010.

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Gathered the requirement from business analyst and translated user requirements into data flows, detail technical specifications and database requirement and involved in its technical documentation.
• Ability to work independently and develop projects in SDLC and Agile fashion.
• Develop PL/SQL objects - Packages, Procedures, functions, Sequences, Triggers, tables, views, synonyms . Write complex queries using joins, inline functions and analytical functions .
• Used composite data types like %ROWTYPE and %TYPE.
• Create Audit log Triggers to track the changes made to system.
• Enhancement of existing modules and also develop new modules as per business requirements using Collections, Bulk Binds and REF Cursors .
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Developed DDL Scripts for Database Objects like Tables, Views, synonyms, sequences, Indexes and other database objects.
• Modified shell scripts to call different procedures and functions in different environments to run in different time periods.
• Developed and scheduled scripts for table space monitoring, Alert Log notifications through emails, Archive log space alerts and autosys jobs for automation of PL/SQL wrapper scripts in UNIX.
• Involved in design and implementation of complex ETL logic for business process.
• Data mapping for inbound and outbound ETL process and data integration.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, INDEXES and materialized views to tune queries for better performance.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops while developing procedures.
• Created various SQL and PL/SQL scripts for verification of the required functionalities .
• Worked on generating reports using MSBI for business users from Oracle database.
• Code check-ins via GIT and generated the builds and performed several code-publishes during weekly releases to the test environments.

Environment : Oracle 11g, SQL Developer, PL/SQL Developer, SQL*PLUS, Erwin Data Modeler, Script Runner, Windows XP, MS Excel 2010, MS-BI Reporting Tool.

Confidential

Database/HTML Developer

Responsibilities:

• Worked in areas of HTML/Database development, CSS, PHP at Center of Government Services at Auburn University in Department of Public Administration.
• Involved in gathering the general statistical information for the regular Survey Analysis and created tables, Functions, Triggers, procedures and packages for implementing the database intensive business rules.
• Developed several HTML pages, which involved coding for design of different survey formats that included tabular, multiple choice like radio buttons and checkbox forms.
• Modified themed templates using custom content types using HTML, CSS and PHP scripting.
• Created Audit log Triggers to track the changes made to system.
• Developed database objects including Tables, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Tested, debugged and took measures for maximum performance utilizing query optimization.
• Created various simple and complex views by joining multiple tables.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed and implemented ETL processes to load data from source files to target tables.

Environment: Oracle Database 10g, SQL Developer, PL/SQL, SQL Server 2012, UNIX, SQL server, SQL*PLUS, T-SQL, SQL Loader, Putty, WinSCP, Erwin Data Modeler, Windows XP, MS Excel 2010.