SUMMARY:

• Analyst/Developer with around 10 years of IT experience. Experience using a wide variety of technologies across various industries
• Excellent team player, demonstrated initiative, good verbal and written communication skills, excellent problem solving skills, highly motivated and driven to meet targets and deadlines.
• Experience at various levels in database programming, application analysis, design and development, implementation, business analysis and system maintenance using Oracle Database
• Expertise in Oracle 12c/ 10g/9i back - end development that includes writing stored procedures, functions, triggers and packages.
• Experience in web development using HTML, JavaScript, ASP, AJAX, CSS, JQUERY
• Strong background in UNIX Shell programming.
• Actively involved in all stages of Software development and implementation life cycle.
• Strong analytical, problem solving and debugging skills
• Experience providing Confidential .
• Proven Skills in meeting aggressive goals and deadline, writing functional/technical specifications

TECHNICAL SKILLS/TECHNOLOGIES:

Database Management System: Oracle 12c/10g/9i, MYSQL

Programing Language: SQL, PL/SQL, JavaScript

Technologies: HTML, AJAX, CSS, Classic ASP, jQuery

Operating System: Windows, UNIX

Tools: TOAD, SQL navigator, SQL Developer

Utilities: SQL Loader

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Gathered and analyzed requirement for various new reports and existing reports for Confidential .
• Designed and developed reports based on business requirements
• Created reports that involved creating views, packages, functions, procedures, and developing complex and dynamic queries that uses analytical functions like cube, rollup, and grouping.
• Developed front end for reports using ASP, HTML, CSS, AJAX and JavaScript.

Development tools: Oracle 12c, TOAD, SQL, PL/SQL, classic ASP, HTML, CSS, AJAX and JavaScript.

Confidential

Responsibilities:

• When a university is added in University Conditional Admission network for first time or modified, their profile is saved in Confidential database. To get data from Confidential database, I created views, packages and procedures.
• Created tables to get snapshot of data.
• For the templates, which had fixed format, I merged database data with word document. I used macros to split document for each university.
• Each university offer different majors for undergraduate or graduate students. There was no fixed format for templates, to create word document, I have created excel from procedure. Then used macros to create word document and split document for each university.
• Used Confidential tool kit to send email to university.
• Created reports for the Confidential process

Development tools: Oracle 12c, TOAD, SQL, PL/SQL, Macros, excel and word document

Confidential

Responsibilities:

• Gathered and analyzed requirement for various new and existing web pages for Confidential .
• Created and modified various web pages that involved creating views, packages, functions and procedures for backend processing.
• Developed/Modified web pages using ASP, HTML, CSS, AJAX and JavaScript.

Development tools: Oracle 12c, TOAD, SQL, PL/SQL, classic ASP, HTML, CSS, AJAX and JavaScript.

Confidential

Responsibilities:

• When an agent/student provides student information and saves the application. A validation process checks for all required fields and returns percentage of application filled. In cases, where a student had a dependent, it was performing an incorrect calculation. I identified the reason behind the incorrect calculation and fixed the trigger, validation package and created virtual column to calculate the correct percentage of application filled.
• A report called “Matriculation report”, displays how many students who studied at Confidential matriculate to a particular university. This report was not displaying the correct count. This was because the field, name of university, was free text. I cleaned up the data so that report would show correct count.
• Fixed data for Confidential files system which was causing glitches on page, using views and stored procedure
• Fixed context view to get cover letter based on student/university search

Confidential, New York

Responsibilities:

• I was responsible for finding auto renewal subscribers universe using complex SQL query
• Generated data using procedure and packages to send email through third party software e-dialog before auto renewing subscribers.
• Developed email landing page using HTML
• Created packages, procedures and functions to capture data based on subscribers click through
• Prepared cursors for sending it to billing process.
• Generated reports for success and failure of billing process by payment provider/ credit card

Development tools: TOAD, PL/SQL, SQL, UNIX SCRIPT, HTML.

Confidential

Responsibilities:

• Created daily Confidential reports for subscribers who watched media on different platforms which included IPAD, IPONE, ROKU, media player, PS3, APPLE TV, Android
• Provided ad-hoc histogram report for Confidential
• Created package/procedure to run daily Confidential process

Development tools: TOAD, PL/SQL, SQL, UNIX SCRIPT, MYSQL

Confidential

Responsibilities:

• Provided Confidential for various forms
• Solved customer service issues
• Ran ad-hoc reports for all Confidential teams based on requirements
• Provisioned user security for forms

Development tools: TOAD, PL/SQL, form builder, report builder, UNIX SCRIPT, SQL Loader

Confidential

Responsibilities:

• Developed user parameter form for customer service
• Created reports for creating physical card for self-purchase, gift purchase and offline purchase
• Created procedure for assigning promotion codes to subscribers who purchase certain sku's and scheduled the process to run daily
• Opted in customers to receive fan club newsletter based on their successful purchase of a fan club membership

Development tools: TOAD, PL/SQL, form builder, report builder, UNIX SCRIPT.

Confidential

Responsibilities:

• Responsible for user requirements gathering
• Created PL/SQL procedures, functions and packages
• Performed end to end testing and provided end user training

Development tools: TOAD, PL/SQL, form builder

Confidential

Responsibilities:

• Responsible for database architecture for Confidential project. Created database tables, indexes and partitions
• Created procedures, functions and packages for the project
• Provided reports to Finance for accounting purposes
• Developed front end form for employee detail entry
• Maintained Employee data

Development tools: TOAD, PL/SQL, Discoverer administrator, discoverer desktop, SQL Loader

Confidential

Responsibilities:

• Gathered data for sending emails to customers based on users request, it involved writing SQL, stored procedure, cursors, functions and SQL loader for loading external files
• Generated promotion codes and assigned those codes to customers based on ecommerce data
• Created PL/SQL procedures and packages.
• Scheduled processes for sending recurring emails
• Generated click through analysis, sent emails based on click through and generated Confidential reports
• Generated monthly Confidential reports

Development tools: TOAD, PL/SQL, report builder, UNIX SCRIPT, HTML and SQL Loader