SUMMARY

• 13 years of experience in Oracle SQL, PL - SQL Development Data Modeling in Power Designer, ETL, Python and Web services testing via Soap UI in Investment Banking, BFSI and Oil-Gas Domain. Currently employed as Technical Lead at Confidential Ltd. I worked as an Associate at Confidential Bank ( Confidential ) Bangalore, India. Prior to which, I held the post of Module Lead at Confidential Technologies.
• Extensively worked on skills like Data Modeling, Oracle, SQL, PL-SQL, Performance Tuning and Extraction Transformation and Loading (ETL) concepts and used various tools like SQL*Loader, Informatica and ET in large scale Oracle applications.
• Extensive work experience in writing various modules like Functions, Stored Procedures, Cursors (Implicit, Explicit and Ref), Packages, Triggers and Creating Global Temporary Tables (GTT), Views, Collections (Nested Tables /Arrays/Record Type) and Materialized views using Oracle SQL and PLSQL.
• Experience in Performance Tuning using various types of Hints, Partitioning, Indexes, M-Views/WITH clause, DBMS Profiler, SQL Trace, TKPROF and Explain Plan. Experience in utilizing performance tuning tools like AWR, ADDM and ASH Reports, and ASH Reports.
• Proficient in Oracle SQL tuning and PL/SQL debugging.
• Developed database objects such as tables (Virtual/Invisible), Indexes, views, sequences (IDENTITY), synonyms, triggers (Compound/Instead), and collections on daily basis.
• Expert in writing complex SQL queries using Aggregate/Analytical functions, Bulk Binding features, Pipelining, Hierarchical Queries and DBMS job scheduling features.
• Partitioning and Purging on New/Existing Tables, LOB data types, BLOB cleanup, reclaim space (SHRINK) and XML file processing.
• Experience in Data Warehouse design, Data Modeling and Schema Design.
• Developed UNIX Shell Scripting to execute PL/SQL Stored Procedures/Functions to automate repetitivedatabase processes by scheduling jobs (Control-M).
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Expert in Handling Exceptions, Mutating Error, Pragma Autonomous Transaction etc…
• Extract/Transform/Load from multiple data sources via staging, integration and loading into the Staging using SQL*Loader, External Tables and ETL tools.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Intermediate level of knowledge in Unix Shell Scripting, Control-M Scheduler, and trained on Python etc.
• Experience in Data Migration from Oracle to Oracle Database taxation system.
• Data Analyst and Data mapping from a source Oracle Database table to a target Oracle Database table.
• Data Manipulation by reformatting, processing, cleansing and integrating data.
• Extensive knowledge in Python and Application development using Python,Django
• Extensive experience in client facing roles & working in multi-geographic teams.
• Deep understanding of Software Development Cycle (SDLC) and implemented various models like Agile (SCRUM), Waterfall Model, Design, Development, Implementation, Testing & QA and Documentation.
• Ability to be an effective team player and work under time constraints.
• Moderate levels of knowledge in XML, CSS, HTML and JavaScript/Python.
• Tools: JIRA, Power Designer, HP Quality Center, and Service now as an ITSM, Bit bucket, Kibana and Erwin.
• Oracle version: Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i database.

TECHNICAL SKILLS

Data Modeling: Power designer, Erwin and SQL Developer tools

Programming Language: Oracle SQL, PL-SQL and Performance Tuning.

Application development using: Python,Django.

UNIX Shell Scripting and Control: M/Autosys Scheduling, Informatica, SQL* Loader and External Tables.

Java, Python: (Trained), JavaScript, HTML, CSS and XML

Microsoft: SQL Server (T-SQL)

Java web service testing: via Soap UI.

Operating Systems: Windows2000/XP, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Austin Texas

Senior Developer

Responsibilities:

• Requirements gathering from the client for all three major different regions.
• Also prepare Mockup/Test cases for any business change and walkthrough with client before the implementation.
• Work on business requirements mostly using PL/SQL Packages, Analytical functions, collections and complex SQL queries, Job Scheduling and most of the SQL/PL/SQL features.
• Performance improvement by replacing collections (slows for high data load) with Global temporary tables and indexes.
• Also implemented multi-threading concepts to improve the performance using parallel job submissions.
• Write shell script to automate the upstream data and schedule jobs via Autosys tool.
• Work on service layer developed in Python for data validation, processing and apply business logic required considering performance improvement.
• Have migrated few complex calculation from DB layer to Service layer which improved 60-70% performance.
• Work on day to day issues reported by client especially for AMR regions, Transfer the business requirements to offshore team and coordinate with them to track the development and testing activities.
• Work on performance issues by increasing the data load from frontend and perform the regression testing.
• Raise a change ticket and deploy the changes in production and sync up non prod instances.
• Reporting: Write a Complex Queries to provide the required data for various Reports and fix, any issues.
• Work closely with DBA/Performance team to find out the performance hick ups and act accordingly to improve it.
• Support on weekend job monitoring and work on the issues, if any.
• Split the task for all the team members and explain the requirement/issues in daily status all.

Confidential

Data Modeler/ Senior Database Developer

Responsibilities:

• Requirement gathering from Operations/Product Owners, SME and Business users to understand specific needs in Scrum.
• Unit test case preparation and Impact analysis on the existing functionality.
• Data Modeling and PDM changes using Power designer (Physical Design - ERD) and Logical Modeling in Erwin, define coding standards, and performance standards, and work with DBA on solution design.
• Analyze and convert business requirements to technical requirements.
• Development using SQL, PLSQL Developer and testing as per agile methodology, performance, and secure coding standards; resolve defects identified in testing and peer reviews.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Mainly used DBMS PROFILER package to find the time consuming query out of packages .
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Web service changes using Java and testing via SoapUI.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day also used SQL * Loader for release deployment activities to reduce the deployment time.
• Also used XML features of PL/SQL to process XML file from UI and load it into core tables.
• Validation and verification of data (4 eye check) and raise an appropriate user defined errors.
• Setup a framework to reduce the code repetition considering reusability.
• Unit and Integration Testing in Development and all other non production environments.
• Bulk files processing implementation/remediation, if any.
• Bug fixes if any in SIT/UAT phase identified by Testing/User acceptance team .
• Non-production deployment activity to Sync with Production.
• Regular interaction with consumer (downstream) team to discuss on new requirement flow and enhancements, Performance tuning and production fixes.
• Regular tracking of JIRA changes and participate in Agile/Scrum meetings.

Confidential

Senior Database Developer/Data Analyst

Responsibilities:

• Data Modeling: Involved inLogical & Physical Database Layout Design using SQL Developer.
• Generating DDL scripts from Relational Model and deploy it in Database.
• Portioning existing table and Purging automation using scheduler jobs.
• DBA level Performance Tuning using Data profiler, Explain Plan, Statistics and Analysis of AWR, ADDM and ASM reports.
• Implementation of business logic in PL/SQL with almost all latest features.
• Effectively made use of Table functions, Indexes, Table Partitioning (Range/List/Has/Interval) and Analytic functions.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements and used Informatica to load index data external databases.
• 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.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Experience inDatabase Application Development, Query Optimization, Performance TuningandDBAsolutions and implementation experience incomplete SDLC.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• Participate in Business checkout process during monthly release process.
• Responsible in all facets of Software Development Life Cycle (SDLC), including requirements gathering, establish technical specifications, set deadlines and milestones, Designing, Coding, Testing, Quality Assurance and Production Deployment.
• Integration of new flat files using SQL Loader and output report generation as per the business requirements.
• Handling of Ad-hoc requests (Report history generation), and helping production team on resolving critical fixes.
• Interact with customers to understand the business requirement and giving update on all open items that we work and prioritize the tasks etc.
• Lead and help team members in case if they need any help and make sure that all changes are in track and deliver them on/before expected time lines.
• Work with business analysts and business representatives to define and clarify requirements, perform detailed analysis, develop detailed designs, and implement robust, maintainable solutions that meet the business requirements.
• Prepare project artifacts such as detailed design documents, data flow diagrams, test scripts, run book and other process related documents.
• Profiling of the data, prior to development, and gathering Information from source systems.
• Understanding business needs for some specific source system, and developing an alternative flow for data loading.
• Developed new Unix shell scripts for high level automation of data loading processes and enhancing existing ones for better performance as well as designing and executing test cases and test plans in compliance with established procedures and methodologies.
• Testing in non production environment with various business test cases.
• Been part of QC and prod UAT testing and validation and provided solutions for the finding raised by business.
• Been part of production implementation and business checkout.
• Deployment Tasks to sync non-prod environments and bug fixes.
• Migration of COBOL to PL/SQL for upload and download report generation based on regions.
• Regular tracking of Jira changes and participate in Agile/Scrum meetings.
• Provided KT on the implementation logic to the support team.

Confidential

Senior Database Developer

Responsibilities:

• Oracle SQL, PL/SQL end to end development like integration of new downstream/upstream system to send/receive new Benchmark data in single/multi-index format requested on JIRA.
• Validations of incoming/ outgoing data as per business rules.
• Extract/Transform/Load from multiple data sources via staging, integration and loading into the Staging.Data Manipulation by reformatting, processing, cleansing and integrating data.
• Performed SQL tuning and indexes, partitioning/purging and XML file processing.
• Writing shell scripts to call Oracle procedures & Control-M job Scheduling.
• Production release support.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• 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.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Performance testing and tuning activities.
• Coordinate with L1/L2 team to resolve any critical production issues.
• Weekly call with Product owners/Business to track the changes.
• Taking ownership of all major development like new interface building for Liquidity/new instrument feed creation and extract feed which meets the requirement.
• Interact with Europe customers to understand the business requirement and giving update on all open items that we work and prioritize the tasks etc.
• Writing/Modifying shell scripts for performance tuning, splitting/Merging the vendor files and also written few new shell scripts to design a file according to new downstream Specification etc.
• Partition/ automated Purging activities for set of core tables.
• Worked on some of the Value-adds in Index Data management systems to stabilize the application.
• Handling Technical team with appropriate guidelines.