SUMMARY

• Around 7 years of experience in Analysis, Design and Implementation of Business Applications
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Materialized Views, Query Re-WriteandTransportable table spaces.
• Strong experience inData warehouse concepts, ETL
• CreatedTables, Views, Constraints, Index
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Knowledge of various coding languages including SQL, HTML, XML, XSL
• Experience of working in Windows and Unix operating system
• Able to diagnose and solve programming issues
• Excellent ability to present complex ideas
• Very strong team player or able to work independently
• Co-ordination with the clients for understanding product specific requirements

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP/7/8, UNIX

Languages: SQL, PL/SQL, Unix, Java

Other tools and technologies: SSH secure shell, Filezilla, FTP Client, SVN, HTML, XML,XSL, SQL developer, Putty

Databases: Oracle9i,10g/11g

PROFESSIONAL EXPERIENCE

Confidential, Columbus,Ohio

PL/SQL Developer

Environment: Oracle 11g, Putty, SQL, SQL Developer

Responsibilities:

• Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Extensively used SQL Developer, SQL*Plusfor daily development jobs
• Involved in importing data from client files to Oracle.
• Developed Pl/SQL Packages, procedures and Functions for data population and updating as per project requirements.
• Writing cursors according to specifications.
• Creating database triggers to maintain Data Integrity.
• Designing constraints and tables.
• Worked on PL/SQL Tables, Records and Collections (Nested table)
• Created Tables, Indexes, Views, Sequences, Synonyms and stored program units.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Performance tuned stored procedure, function, view, trigger and query by utilizing indexes, partitioning, Explain Plan, SQL Trace & TKPROF utilities.
• Used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in end to end testing and defect fixing

Confidential

PL/SQL Developer

Environment: Oracle 11g, Putty, SQL, SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer Information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 10g database.

Confidential

Developer

Environment: Windchill 9.0, Oracle 11g

Responsibilities:

• Duties have included installation, configuration, implementation & maintenance for software, hardware and operating systems
• Also working as Windchill administrator and debugging problems related to it.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Installing and troubleshooting different applications like Link-It, VariPDM, Vertex etc.
• CAD and PLM tool installations to the new users with full access configurations
• Querying Database using SQL to get the information and supporting PTC team.
• Privileges provided to the users based on their role in Product, Project and Library in Confidential environment
• Synchronizing the data between Windchill and VariPDM system
• Preparing call reports and discussing critical issues with the client weekly

Confidential 

Software Engineer

Environment: UNIX, Oracle 10g, Bugzilla, SVN, Java

Responsibilities:

• Developed and maintained workflows to process feeds that is used to render Confidential news, Finance, Entertainment, Movies, OMG and US Local News (NPC)
• Requirement Gathering, Analysis Coding, unit testing and integration testing.
• Developed and enhanced different java classes to convert the News feed into standard format
• On-boarding various providers onto Confidential Sites in US, Canada
• Maintenance of Confidential Finance on US, Canada
• Provide support of incoming tickets, including extensive troubleshooting tasks andMonitoringtickets in Bugzilla.
• Worked on SSH secure shell, Filezilla, SVN, JavaScript, HTML, XML,XSL,
• Querying database by using SQL scripts.
• Maintained the documents and create reports for the business analysts and end-users.
• Preparing call reports and discussing critical issues with the client weekly