Professional summary

• 7 years of programming experience as an Oracle Pl/Sql Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS
• Strong experience in Oracle, Perl and UNIX shell Scripting.
• 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.
• Very strong experience in supporting application using Oracle, unix, perl programming
• Excellent database knowledge on RDBMS like Sql , Pl/Sql
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Experience in performance tuning using Explain Plan, Indexing and Hints.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Good working experience in UNIX environment and have supported various business applications
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in programming using Perl, Java scripts and html
• Extensive experience in Oracle back end in Pl/Sql development
• Expertise in financial industries based application including trading system and insurance
• Excellent interpersonal and communicational skills, efficient time management and organizational skills, ability to handle multiple tasks and worked well in team environment
• Excellent logical and analytical skills to solve complex problems

Technical skills

Professional experience

Confidential

Market Operations

Marketing Operation is a part Dow Jones which deals majorly circulation operation of WSJ Wall Street Journal .It deals with the subscription data of WSJ, Barron's etc. throughout the world which roughly 1.2M print and 400K online. The project deals of collecting subscription data from different sources and clean them according to the needs of the business. Also collecting several marketing and campaign data and store them in database for pulling them with complex sql.

Responsibilities

• Was a part of the Data provisioning/ Circulation Operations group.
• Required to handle large and complex data sets help with analysis and creating tables and views based on user requirements under a severe time constraint.
• Some of the End User applications using these views that I created are IBM UNICA and MS ACCESS accessing Data Base .
• Was part of the ongoing requirement of converting existing shell script to Python scripts for more flexibility.
• Using Python 2.7 in Unix created python scripts to pull data from files and create new file implementing business logic.
• Required to handle large and complex data sets help with analysis and creating tables and views based on user requirements under a severe time constraint.
• Performed SQL and PL/SQL tuning with EXPLAIN PLAN and AUTOTRACE
• Created and scheduled Unix scripts for maintenance.

Environment: Oracle DB2, Python 2.7,Unix,IBM Unica, Salesforce, Factiva

Confidential

MDB CTI Application Development

Responsibilities:

• Extensive hands on experience in writing PLSQL packages, stored procedures functions.
• Developed views for data replication in distributed environments.
• Partitioned large Tables using range partition technique.
• Work with Business Analyst and Business Objects teams to get brief idea about requirements and translate the requirement into technical specifications.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Used Autosys extensively for scheduling.
• By using TOAD find and fix database problems with constraints, triggers, extents, indexes, and grants.
• Worked on enhancing the existing Stored Procedures, functions and views for changing different fields due to increase of clients.
• Wrote complex shell scripts to run mainframe tables extract data and transmit to PROD for client use.
• 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
• Partitioning the mothership tables and tuning procedures, functions and views

Environment: Oracle 10g, IBM WebSphere/HTTP Server/Java 5.0 SDK, PL/SQL, PERL, Korn Shell, Autosys, Unix, Oracle Exadata, Toad, Pl/Sql Developer

Confidential

Mortgage loan Origination system

Responsibilities

• Involved in requirement analysis, database design, coding, testing, implementation and review
• Backend Programming using Oracle 10g, screen designing using Forms 6i and developing reports using Reports 6i.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE
• Wrote UNIX utilities like AWK to support environment for security compliant, fix data etc.
• Prepared many Perl scripts for server side data processing
• Developed many tables, stored procedures and triggers on oracle database for implementing complex business logic
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Created and generated numerous reports daily weekly and monthly for various levels of support and auditing
• Developed ad-hoc reports using Pl/Sql blocks
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Worked with Unix commands to check and match the output manually
• Discussed all production support aspects with application development management
• Created Shell scripts that accessed data from the Oracle database using SQL
• Supported in resolving production batch failures and close out resolved tickets
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Managed batch jobs using Unix and Perl scripts to process database activities
• Responsible for all aspects of production engineering, release management and production support
• Created Sql loader scripts to load data from external system to oracle

Environment: Perl,pl/sql,unix,dbi/dbd,html,javascript,oracle 10g,sql,crontab,windows

Confidential

Brokerage Service management

Responsibilities

• Identified database objects, created and delivered them to the development team
• Developed scripts to run Unix shell tabs to update the database in specific intervals
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Developed Unix Korn Shell and Perl scripts to ad hoc user requests
• Automated numerous back end processes written using Perl and Unix
• Wrote and enhance oracle stored procedure and triggers for better performance of queries
• Developed Strategies for Extraction Transformation Loading ETL mechanism.
• Partitioned the fact tables and materialized views to enhance the performance.
• Involved in production support for reports monitoring end to end application performance
• Performed performance tuning of the SQL queries by eliminating redundant joins, creating functional indexes, removing redundant code.
• Used Perl, dbi/dbd for oracle connection
• Developed many Unix commands for data file movement and scheduling
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files. Fixed the performance bottlenecks identified by QA team
• Provided application support during post production
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Perl, pl/sql, unix, dbi/dbd, html, JavaScript, oracle 10g and 11g,sql,crontab,windows

Confidential

Medical documents and record tracking system

Responsibilities

• Participated in designing the application's enhancement using object oriented methodology
• Participated in production support, both monitoring and troubleshooting support
• Developed many Pl/sql scripts stored procedures triggers in oracle
• Created and modified SQL Plus, PL/SQL and SQL Loader scripts for data conversions.
• Created Unix code for sequential execution of Perl scripts including Data extraction, loading and Oracle stored procedure execution
• Created Perl scripts to support front end pages
• Created Html based report pages and modified existing pages
• Coordinate with production support processes of escalation and resolution of major service issues.
• Analyzed and support to all business processes and ensure compliance to all controlled processes according to business requirements
• Assisted all customers and provide production support for all designs and perform tests on all installation process for infrastructure
• Developed Unix scripts for ftp files and automated processes
• Helped design custom data models that integrated with oracle applications
• Provided 24x7 operational support to all production practices on holidays and weekends
• Developed many Perl modules and packages
• Designed and developed interactive GUI forms to support data entry, querying and reporting from the oracle database.
• Created and scheduled Unix scripts for maintenance
• Developed and supported custom applications and client web sites
• Developed procedures and created documentation to support batch operations for batch scheduling
• Participated in unit and system testing

Environment: Perl, pl/sql, UNIX, dbi/dbd, html, JavaScript, oracle, sql, crontab, windows