Professional Summary

• Eight years of programming experience as an Oracle PL/SQL Developer in analysis, design, development, implementation and maintenance of business applications using the Oracle Relational Database Management System RDBMS
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines in Waterfall as well as Agile SCRUM development methodologies
• Coached Scrum teams and facilitated architecture, development and testing within sprints as a Technical Team Lead/Scrum Master, bootstrapped new teams adopting agile enabled teams to estimate better, stabilized velocity, deliver on time and embrace team empowerment and continuous improvement
• Worked with enterprise clients and end users on high stakes projects simultaneously managing user perception while delivering critical results on time
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Experience with data flow diagrams, physical and logical modeling, data dictionary/catalog views and database normalization theory techniques, entity relationship modeling and design techniques
• Expert in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD, PL/SQL Developer, Oracle SQL Developer, SQL LOADER
• Effectively made use of Pipelined Functions, Indexes, Table Partitioning, Collections, PL/SQL Object Types, Analytical functions, Materialized Views, Query Re-Write Transportable table spaces
• Strong experience in Data Warehouse concepts, multi-dimensional modeling and ETL processing
• Created Tables, Views, Constraints, Indexes B Tree, Bitmap and Function Based
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Developed materialized views for data replication in distributed environments
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling and Bulk Binding
• Loaded Data into Oracle Tables using SQL Loader
• Used Insert All, Insert First for multi table inserts.
• Partitioned large Tables using range partitioning, list partitioning and complex partitioning
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, UTL FILE, UTL MAIL, UTL SMTP packages
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables and to automatically disable and enable constraints for faster ETL processing
• Worked extensively on Ref Cursor, External Tables, Collections
• Expertise in Dynamic SQL, Collections and Exception handling
• Expertise in Performance Tuning through a thorough understanding of the Query Optimizer's in-built optimization methods, reading Explain Plans, running SQL Trace, generating tkprof reports, using Active Session History ASH , Automatic Workload Repository AWR and Automatic Database Diagnostic Monitor ADDM for identifying resource-intensive SQL statements
• Used HINTS, indexes BITMAP, B Tree, function-based , disabling and enabling constraints, using materialized views where necessary, table partitioning, bulk binding etc to improve performance
• Experienced in ETL techniques and Analysis and Reporting including hand on experience with the Reporting tools such as Cognos
• Created Shell Scripts, Windows batch scripts, Perl and Python a for invoking SQL scripts for automated database maintenance and deployment and unit testing of PL/SQL code
• Excellent analytical, communication, leadership and change management skills to enable teams to deliver results on time and embrace change as a constant in day-to-day operations

Skills

• Languages/Technologies: PL/SQL, Javascript, Perl, Python, C, C , Oracle 11g, MongoDB, Cognos
• SDLC: Agile Scrum Development Life Cycle as team member and Scrum Master , Waterfall
• IDEs and other tools: Microsoft TFS, GIT, IBM ClearQuest, HP ALM Quality Center, VersionOne, TOAD, PL/SQL Developer, Oracle SQL Developer, PyCharm, Eclipse Perl
• OS: Windows, Macintosh, UNIX, Linux
• Miscellaneous: MS Excel, Access, Other Office Products, LaTeX

Experience

Confidential

Database Developer

Responsibilities:

• Worked in an Agile Scrum development environment as Software Developer for ABB's Advanced Business Analytics Unit.
• As part of the Operations Management development team, analysed, designed, developed and implemented an Oracle - PL/SQL based data warehouse and used in-house ETL, dashboarding and reporting tools.
• Internationalized and localized several BI solutions including ABB's Outage Management, Storm Management, Asset Reliability and Outage Communications solutions.
• Implemented an automated build and deploy solution built in Perl that reduced installation time from 4 days to 5 hours.
• As a Scrum Master/Technical Team Lead, directed architectural decisions, resolved conflicts and enabled my team to stabilize sprint velocity, increase velocity from 16 points to 40 points per sprint, met and exceeded stringent deadlines on multiple projects.
• Used Perl scripts for automation and maintenance tasks, extensively used DBI and File::Find packages.
• Championed continuous improvement through automation, consistent code reviews, pair programming, team empowerment, effective use of retrospectives, and overall adherence to Agile best practices, and introduced an open-source model for inter-team development.
• Evaluated several PL/SQL unit-testing frameworks, and currently involved in integrating a SQL Developer based test harness with the custom build and deploy solution.
• Experience with data flow diagrams, data normalization theory and techniques, data dictionary, physical and logical models, ER diagrams and design techniques strong background in data warehousing and optimization for OLAP.
• Developed complex procedures, packages, functions, triggers, materialized views, tables, constraints and indexes B Tree, bitmap and function based built cubes from ground up for compatibility with Oracle Standard Edition extensively used collections, ref cursors, exception handling, dynamic SQL, pipelined functions, analytic functions, bulk collections, regular expression based validations, DBMS JOB and UTL FILE packages.
• Performance tuned SQL using cost-based optimization techniques, indexes, hints and explain plans.
• Wrote UNIX shell scripts for database maintenance and file transformation
• Administered development, QA and integration databases including parameter file maintenance, disk space allocation, tablespace management, general troubleshooting, maintaining and purging of archive logs and restore points.
• Worked in a highly matrixed environment and coordinated with clients, product managers, customer support professionals and quality assurance analysts to gather requirements, write up technical design documentation, and to maintain cadence between different development teams.
• Trained other resources on technical aspects as well as Agile development practices and processes.
• Selected to work on Asset Health Center a flagship project integrating ABB's subject matter expertise and Ventyx's business intelligence solutions as part of a team winning the ABB CEO's award one of only twelve awarded among 125000 employees.
• As part of FocalPoint's Federation Support team, trained new teams, setup environments, developed development and testing strategies, helped bootstrap new development teams.
• Developed packages, functions and views for data validation, data integrity and functional testing. Monitored performance using Oracle Enterprise Manager.
• Worked with clients, customer support personnel, and development team to identify goals and requirements, define technical specifications, draw out timelines, write and execute test plans, investigate, review and approve defects and resolutions.

Environment: Oracle 10g/11g, TOAD, SQL Plus, PL/SQL Developer, Windows 7, Linux, UNIX

Confidential

Product Developer

Responsibilities:

• Worked in an Agile Scrum environment, led development teams, coached them on Agile best practices as a Scrum Master
• Designed and developed Hawkes Learning Systems' software for Developmental Mathematics and Pre-algebra and Intermediate Algebra.
• Worked closely with product managers, QA analysts, in development of several software products including Developmental Mathematics, Business Statistics, College Algebra, Pre-calculus, Introductory Algebra etc.
• Developed and maintained a real time Oracle database backend to support online testing and score reporting.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Worked on SQL Loader to load data from flat files obtained from various facilities every day
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements
• Wrote Unix Shell Scripts to process the files on daily basis like renaming files, 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
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Involved in data loading using PL/SQL and SQL Loader and cron jobs calling UNIX scripts to download and manipulate files
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF, AUTOTRACE, ADDM, ASH and AWR
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between sql and pl/sql engines
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Creation of database objects like tables, views, materialized views, procedures, packages using oracle tools like Toad,PL/SQL Developer and sql plus
• Partitioned the fact tables and materialized views to enhance the performance
• Extensively used bulk collection in PL/SQL objects for improving the performing
• Created records, tables, collections nested tables and varrays for improving Query performance by reducing context switching
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Extensively used the advanced features of PL/SQL, like Records, Tables, Object types and Dynamic SQL
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Environment: Oracle 10g, SQL Plus, TOAD, SQL Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Created technical design document from the business requirements.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL loader from external files.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Used bulk collections, indexes, materialized views to improve the sql and plsql performance.
• Automated routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• 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 with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Implemented Oracle Advanced Queuing to send messages to JMS sever.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL trigger, sequence, stored procedure .

Environment: Oracle 11g, SQL, PLSQL, SQL Loader, KORN Shell script, SQL developer, Oracle Forms 10g, Reports10g.

Confidential

Oracle Developer

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Created scripts for Validating extracted data from Legacy systems before loading into target system.
• Involved in testing of objects while migrating from oracle 9i to oracle 10g.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures.
• Created SQL Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution using bulk collections and Dbms profiler.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend Procedures and Functions using PL/SQL.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• Wrote shell scripts for calling SQL scripts to automate the loading and extraction process from legacy system.
• Performance tuning using explain plan, TkProf and stats pack.
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes.

Environment: Oracle 10g, PL/SQL, SQL Loader, TOAD, Java, HTML, MS Office, PL/SQL Developer.

Confidential

Oracle Developer and Analyst

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Writing SQL reports and scheduling these reports from UNIX scripts.
• Created SQL Loader control files for moving the data from flat files to staging area tables.
• Worked on performance issues and used EXPLAIN PLAN for tuning the queries.
• Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
• Involved in the migration project to load data from mainframe systems into oracle database.
• Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms output and explain plan.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Involved in developing data conversion programs using SQL Loader, PL/SQL and UNIX shell scripts.
• Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
• Developed data entry forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
• Used various LOVS List of Values and record groups at various points in runtime.
• Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting, Toad, SQL PLUS, Data Stage ETL Tool .