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 interaConfidentialng directly with End Users and Business Analyst.
• Experience in performance tuning using Explain Plan, Indexing and Hints.
• Developed Complex database objects like Stored Procedures, FunConfidentialons, Packages and Triggers using SQL and PL/SQL.
• Good working experience in UNIX environment and have supported various business applications.
• 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 colleConfidentialng subscription data from different sources and clean them according to the needs of the business. Also colleConfidentialng 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, FaConfidentialva

Confidential

MDB CONFIDENTIAL Application Development

Confidential is an oracle database designed and developed by CONFIDENTIAL as a Data Mart for temporary storage of sets of accounting data retrieved from FDR. FDR, Financial Data Repository is the source for all MDB operations. It is where the current data, historical data, EOD and EOM data and client's operational data are being stored. Vision of CONFIDENTIAL Client Technology Interface Knowledgebase is an Enterprise solution which will create an application that will provide internal CONFIDENTIAL users the ability to configure, schedule, generate, and deliver data extracts both standard and custom to clients or internal destinations in a flexible and automated fashion. CONFIDENTIAL Team is responsible for delivery of extracts to the majority of State Street clients and other third parties. Each night over 11,600 jobs are run and over 6,500 data feeds are supported to provide over 450 clients and vendors time critical data extracts.

Responsibilities:

• Extensive hands on experience in writing PLSQL packages, stored procedures funConfidentialons.
• 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, funConfidentialons 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, extraConfidentialng 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, funConfidentialons 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

This product is used to automate the mortgage loan qualification and application process. This system is modeled for the Confidential mortgage loan market. The system assist a mortgage loan broker to access the potential of a loan applicant on various loan processing parameters and provide consulting assistance for potential borrowers.it is an intranet 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, funConfidentialons 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 ColleConfidentialons 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 produConfidentialon support aspects with application development management
• Created Shell scripts that accessed data from the Oracle database using SQL
• Supported in resolving produConfidentialon batch failures and close out resolved tickets
• Created records, tables, colleConfidentialons nested tables and arrays for improving Query performance by reducing context switching.
• Managed batch jobs using Unix and Perl scripts to process database aConfidentialvities
• Responsible for all aspects of produConfidentialon engineering, release management and produConfidentialon 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

The purpose of this software was to server the brokerage side of the firm. It provides trading flexibility, comprehensive statements for easy record keeping, dividend management, trade settlements, cash management, direct deposit, margin and option investing, trade confirmation and alerts.

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, colleConfidentialons 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 ExtraConfidentialon Transformation Loading ETL mechanism.
• Partitioned the fact tables and materialized views to enhance the performance.
• Involved in produConfidentialon support for reports monitoring end to end application performance
• Performed performance tuning of the SQL queries by eliminating redundant joins, creating funConfidentialonal indexes, removing redundant code.
• Used Perl, dbi/dbd for oracle conneConfidentialon
• 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 produConfidentialon
• 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

This system is used to store track and retrieve doctors, patients and hospital staff related information. The patients records/history, staffs doctors and other hospital staff duty and schedule info is also tracked by this web based intranet system. This system also logs hospital inventory and equipment and can run detailed reports of any available information.

Responsibilities

• Participated in designing the application's enhancement using object oriented methodology
• Participated in produConfidentialon 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 extraConfidentialon, 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 produConfidentialon 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 produConfidentialon 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 produConfidentialon praConfidentialces on holidays and weekends
• Developed many Perl modules and packages
• Designed and developed interaConfidentialve 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