Objective:
To obtain a position in Information Technology to utilize and increase my skills to benefit the company in building, installation, configuration, and maintenance of Application Systems

Summary of Qualifications:

• Extensively worked in Oracle SQL, PL/SQL and used Oracle database and tools in Linux, Unix and Windows environments
• Experience in writing complex SQL, Packages, Stored Procedures, and Triggers
• Experience in data modeling tool ER-WIN
• Experience in developing and executing test cases in the area of functional, integration, validation, regression, error, destructive, performance testing
• Experience in developing Reports, Sub-Reports, Cross-Tab Reports using different report engines
• Experience in designing web based applications using LAMP
• Sound knowledge and exposure in data warehouse, data modeling, mapping, extraction, migration, and data validation

Technical Skills:

• Platforms: MAC OS X, Linux, Windows 2000/XP/Vista
• Languages: Perl, Shell scripting, PHP
• RDBMS/Tools: Oracle, SQL, PL/SQL, MS SQL Server, MySQL
• Reporting Tools: Crystal Reports, Business Objects, Intellicus
• Testing Tools: Radar, JIRA
• Others: Microsoft Office, Excel, Macros, Pivot Tables, WinCvs, Visual Source Safe

Professional Experience:

Confidential April 10 - till date
Confidential is recognized for innovative mental health treatment, foster care and social services that help families recover from trauma, abuse and addiction, and rebuild their lives.
Title/Position: PL/SQL Developer
Job Description:

• Creating Packages, Stored procedures, Triggers, and developing complex SQL queries and dynamic SQL’s thorough out the projects.
• Designed ER Diagrams via reverse engineering in ERWIN
• Created TIER data dictionary using ERWIN and referential integrity constraints in tables.
• Created back-end triggers to overcome a base product limitation to support e-signatures.
• Created stored procedure based crystal reports with User Interface in Electronic Health Record System TIER.
• Created and modified user defined functions, procedures and triggers to implement partial Short Doyle Phase-II requirements to meet billing requirements.
• Documented user’s requirements, and technical specifications
• Created master script to generate triggers’ scripts for tables to capture the history of DML operations.
• Presented and documented various approaches to capture history data for the transactional tables.

Environment: Oracle 10G, SQL, PL/SQL, Crystal Reports XI, Clinical System TIER, Visual Source Safe, ERWIN 7.3, Windows 7

Confidential Jan 09 - Jan 10
Title/Position: QA Analyst
Job Description:

• Built web-based PHP/Mysql applications to report progress for test cases between builds and releases.
• Installed and configured Mac OS X Server/Client on different machines.
• Developed and executed test cases for Mac OS X components/applications in area of integration, validation, regression, error, destructive, and functional testing.
• Created scripts to automate certain tasks using PERL, Shell, uTest, RAFT, and Apple script.
• Isolated bugs by observing system and application logs and filed them in Radar.

Environment: MAC OS X, PERL, Shell, Radar, PHP, MySQL, uTest, RAFT, and Apple Script

Confidential Jan 08 - Oct 08
Confidential a Web-based project, document and property management solution designed for the development and ongoing management of geographically dispersed assets.
Title/Position: PL/SQL Developer
Job Description:

• Customized application according to the client’s need which included creating Packages, stored procedures, indexes, dynamic SQL, and triggers.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Queried database for data-dump required for business users.
• Tuned the SQL queries for fast retrieval of data in reports.
• Created Custom login pages using XML template.
• Created new reports and enhanced existing reports.

Environment: Oracle 10G, PL/SQL, MS SQL Server 2000, Business Objects, Intellicus, JIRA, WinCvs

Confidential Aug 07- Dec 07
Confidential is the leading provider of children\'s mental health, and social services in Northern California.
Title/Position: Crystal Report Developer
Job Description:

• Designed forms in Tier and linked them to the database.
• Designed and developed Reports to get the clinical data as per user requirements, using Base Tables, views and stored procedures.
• Created packages, stored procedures, and enhanced existing reports by fixing the crystal reports and SQL query errors.

Environment: Oracle 10G, SQL, PL/SQL, Crystal Reports, Clinical System TIER

Saucio Jan 06 - Jan 07
Saucio Systems is premier developer of fully Web-based transportation software for dispatch and accounting solutions. Saucio eTrucking is a Web-based dispatch and accounting software for transportation industry.
Position: QA Consultant

• Designed and implemented test cases to verify Business requirements
• Performed Unit, Functionality, and black Box Testing
• Queried database-using SQL for data integrity checks

Environment: Oracle 8, SQL, PL/SQL, and MS Excel

Education:

• Oracle Database Developer Certificate
• Masters