PL/SQL Developer

Canton, Michigan, 48188, United States
$55/ hr on c2c
March 02, 2011   all resumes
Contact Info:
*****@*********.*** ***-***-****

Around * years of extensive experience in Oracle*i/10g/11g, MS SQL Server SQL Server 2005/2008 Developer/Administrator with major focus on T-SQL, SSIS, SSAS and SSRS.5 years of sound experience as a database developer in insurance, marketing, IT and financial sectors. Sound knowledge of software development life cycle (SDLC) and agile methodology with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.

• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Over Six years of exclusive experience working with SQL, PL/SQL and Reporting.
• Experienced in developing stored packages, procedures, functions, Partitions, triggers, and views.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Excellent Knowledge of Business Intelligence and Data Warehousing Concepts.
• Experience working with various Heterogeneous Source Systems like Oracle, MS SQL Server, Teradata, and Flat files.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data which is store at the OS level.
• Experience in retrieving data from Business Objects Universes, Personal Data Files, and Stored Procedures.
• Excellent Knowledge in creating complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail, etc.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS_PROFILER), explain plan, auto trace and tuned them to suit SLA.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Expertise in Mathematical modeling and Numerical Analysis.
• Excellent planning, analytical, written Communication and Interpersonal skills. .
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan.

• Oracle Certified SQL Expert
• MCTS: Microsoft SQL Server 2008, Implementation and Maintenance
• MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

• Bachelors of Science, Jawaharlal Nehru Technological University, India.

Technical Skills:

RDBMS/ DBMS: Oracle 8i/9i/10g, SQL Server 2000/2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Access.
Tools: SQL Enterprise Manager, SQL Profiler, Query Analyzer, SQL Setup, Security Manager, Service Manager and ODBC, SharePoint Portal Server 2007
ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert, BCP.
Data Modeling: ERwin 4.0/7.x, Visio
Languages: C, C++, C#, Visual Basic, ASP.Net, Internet & Web Programming Fundamentals
OS: MSDOS, UNIX, Windows (NT, 95, 2000, XP, Vista, 7)

Work Experience
Blue Cross Blue Shield of Michigan May 2010 – Present
Southfield, Mi
PL/SQL Developer
Blue Cross Blue Shield of Michigan offers health care solutions tailored to fit individual’s lifestyle and specific health goals. Beyond health coverage, they count to provide impactful community initiatives and leadership in improving health care. it’s priority and responsibility to improve the health of Michigan's people, communities, economy and health care system And they do this for everyone in Michigan.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Responsible for performing code reviews.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 11g/10g and 9i, Toad, MS SQL SERVER 2005, SQL * Loader, PL/SQL, PL/SQL Developer SQL*PLUS, SSIS, SSAS, SSRS, IBM Rational 7.0.1

MediaCom Aug 2009 – Apr 2010
Ann Arbor, MI
PL/SQL Developer
MediaCom is a full-service marketing and media communications agency. MediaCom is that company believes in together with core digital team. MediaCom Interaction is a leading media's reinvention combining consumer insights and analytics, with strong strategic and creative thinking that drives results.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Responsible for making decisions on coding standards and documentation.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in tuning SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Involved in Unit Testing Stored Procedures and Functions.
• Involved in developing UNIX shell scripts for Loading Database Tables.
• Loading data from flat files into database tables using SQL* Loader
• Writing scripts for Data Staging, Loading and cleanup process.
• Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Experience in developing various kinds of triggers and used sequences to generate values for surrogate keys in data warehouse tables using Before Insert triggers.
• Extensively used SQL* Loader for data loading process.
• Extensively used CVS for Implementing the code Changes.
• Created Materialized Views and partitioning tables for performance reasons.
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, maintenance, reorganization, and recovery of databases.
• Preparing documentation for requirements, design, install and Unit testing.
• Resolving Production severity Issues in time and meeting the SLA.
• Responsible for Analyzing and Implementing the Change Requests
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Resolving the issues on priority basis.
• Writing high quality and well documented code according to standards.

Environment: MS SQL Server 2005/2008, Tortoise SVN, SQL * Loader, PL/SQL, PL/SQL Developer SQL*PLUS, Windows Server2003, SAINT, ETL Controller.

Sun America May2007-July 2009
Woodland Hills, CA.
PL/SQL Developer.

Sun America is The Retirement Specialist, mainly focused life companies provide nearly half a million individuals with the financial products and services they need to help them retire stronger. We have experience and leadership, offering variable annuities that can provide investment growth potential plus options for guaranteed lifetime income that’s protected from downturns and market volatility.

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Actively involved in different stages of Project Life Cycle.
• Participated in gathering of User Requirement and System Specification.
• Worked on designing of the application that covers process flow of the business logic.
• Participated in database logical design to fit new business requirement, and implemented new design into SQL Server 2005.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created and maintained database, tables, user logins, views, indexes, and constraints to implement business rules and also created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server and for Application Developers.
• Maintained and Created Replication: Merge Transaction and Snapshot. Also implemented data transformation to the published articles.
• Developed applications like integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens.
• Administered security, user account management and access privileges.
• As part of a team, created various reports according to the business requirements and also individually authored, installed, deployed and managed reports using SSRS for a library database.
• Generated drill down and drill through reports from data warehouse using SSRS.
• Optimized indexes with the use of Index Tuning Wizard and Rebuild indexes.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Analyzed and debugged jobs and procedures.
• Developed the SSIS packages to transform data from SQL 2000 to MS SQL 2005(DTS to SSIS conversion).
• Created SSIS packages for processing fact and dimension tables with complex transforms and also configured and deployed SSIS packages to import and export data.
• Performed Backup operations.
• Used Crystal Reports to generate ad-hoc reports.


SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, VBS, Crystal Reports, ERWIN, MS Office & Windows 2K platform

Iowa foundation for Medical Care Jan 2006 – May2007
Columbia, MD.
PL/SQL Developer.

Iowa foundation for medical Care has been deeply rooted in health care data management and research. IFMC has experience in collecting, storing, safeguarding and mining data in the health care industry. It is proving these services to the Centre for Medicare and Medicaid Services. IFMC provides flexible solutions and mainly focuses services on three main areas of health improvement, Care, Quality and Information management.

• Developed PL/SQL Business Functions, procedures and packages for data models to create reports from J2ee web Application.
• Involved in Gathering the Requirements for creating data models for data analysis and reporting
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Involved in developing ETL Process to Load the Data from the Mainframe Production Databases to the Oracle Database models
• Involved in writing Test plans for PL/ SQL Stored Procedures and Functions.
• Involved in Unit Testing and System integration.
• Involved in developing UNIX shell scripts required for maintaining the data Models and processing job.
• Involved in Developing and maintaining control files for SQL* Loader to load data from flat file into database tables.
• Writing scripts for Data Staging, Loading and cleanup process.
• Involved in Writing Oracle Application Program Interfaces(APIs) and Performance tuning
• Created Materialized Views and partitioning tables for performance reasons.

Environment: Oracle 9i, UNIX, SQL, PL/SQL, SQL*PLUS, SQL, SQL Developer, C, k-shell, SQL*Loader, TOAD, JAVA J2EE.

Nexgen Software Solutions Sep 2004 – Dec 2005
Hyderabad, India
PL/SQL Developer
NexGen is a Software Solutions provider with a strong focus on hi-end cutting edge Technologies. The company offer total solutions in the areas of Client/Server technologies, Desktop and Web based Applications. NexGen understands the business implications of each client, and requirements to offer highly customized solutions that fit clients business perfectly

• Analyzed all business functionality related to back end database interfaces
• Developed technical specifications for various back end modules from Business Principles. Specifications are made according to standard specification formats. .
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Worked with DBA in making enhancements to physical DB schema.
• Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Analyzed and designed tables based on small and large database transactions.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Object Types, triggers, C#, K-Shell scripts
• Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files database tables.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Preparation and Reviewing Production Patch Implementation Documents.
• Creation of Change Requests for bimonthly changes movements.
• Responsible to keep the production test machine in sync with production.
• Also responsible for writing test plan documents and unit testing for the application modules.

Environment: Oracle 9i, UNIX, Windows NT, PL/SQL, SQL*PLUS, SQL, C#, k-shell, SQL*Loader, PL/SQL Developer Tool.

Furnished up on request