SUMMARY

• 10+ years of experience in all phases of SDLC - Requirements Gathering, Gap Analysis, Database and Application Designing, Coding, Debugging, User Acceptance Testing, Deployment, Implementation and Documentation of IT solution in application software in client-server technologies and three-tier technologies on turnkey basis for small, medium and large corporations.
• Strong knowledge in Oracle 11g/10g/9i/8i, SQL, PL/SQL, SSIS, Crystal Reports 2008, XI, 10, 9, Business Objects, UNIX Shell Scripting.
• Database programming using PL/SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built-in Oracle Packages.
• Expert in RDBMS logical and physical Database Designs with excellent Normalization and De-normalization techniques for efficient data storage and retrieval
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Experienced in Query Optimization, Debugging, Performance Tuning and Improvising performance of applications using SQL Trace and Explain Plan to analyze queries for efficient data retrieval.
• Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
• Technical Skill areas include Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, Oracle SQL, Oracle PL/SQL, Oracle Forms 6i/10g, Oracle Reports 6i/10g, SQL Loader, Oracle RMS, Oracle Apps Q2O, PL/SQL Developer, SQL Developer, Crystal Reports 2008, XI, SQL Server integration Services, SQL Server reporting Services 2000/2005/2008 , Toad, SQL Navigator, Putty, Rational Clear Case, Rational Clear Quest, Harvest.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• Good knowledge of Data Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Excellent Database modeling/designing skills using Erwin.
• Strong experience on testing and debugging computer code using different techniques based on system complexity
• Experience in designing and development of Crystal Reports.
• Supported DBA to Take Back up, Monitoring Performance and Tuning Activities.
• Strong experience in writing and modifying existing UNIX shells scripts.
• Experience in writing Shell Scripting on different type of shells (Bourne shell, Korn shell) using Unix/Linux and scheduling jobs using Crontab in UNIX environment.
• Good knowledge on version control tools like Clear Case, VSS, PVCS which helps multiple users to access the source code of the PL/SQL programs.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Worked on Production Support, troubleshooting the application and resolving bugs.
• Thorough in Unit testing and Integration Testing.
• Good knowledge of Web based technologies (HTML, Java Script and XML).
• Strong communication and team skills with proven ability to work on projects with minimum guidance and specifications.
• Very good understanding of Agile, ISO and CMM level-5 practices.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008

ETL Tool: SQL Server Integration services(SSIS)

Front End Tool: Crystal Reports 2008, XI, 10, 9, Oracle Developer 2000 (Forms 10g/6i, Reports 10g/6i), Oracle Apex

Languages: VB 6.0, ASP,SQL, PL/SQL, C, C++, UNIX Shell Scripting

Database Tool: Toad, SQL Navigator, Rapid SQL, PL/SQL Developer, SQL Developer, SQL*Loader

Application Server: IIS 5.0, Oracle 9iAS/10gAS

Configuration Mgt Tool: PVCS, MS VSS, Rational Clear Case, Harvest

Defect Mgt Tool: Rational Clear Quest

Designing/Other Tool: MS-Visio, MS-Office

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, MI

PL/SQL Developer

Responsibilities:

• Involved in requirements gathering process and assisted the business analysts in understanding the functional specifications.
• Designed and developed the Packages, procedures, functions efficiently in loading, validating the data. Also worked on creating users and roles as needed for the applications.
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
• Worked on Performance tuning using indexing concepts.
• Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
• Developed reusable unit test scripts for every store procedure.
• Created Shell Scripts, SQL scripts, Stored procedures and Constraints according to the Data transfer from Legacy systems to Oracle Database.
• Created various objects such as Tables, Views, Materialized Views, Stored Procedures, Functions and Triggers.
• Developed complex triggers in reports before/after for validation of user input.
• Extensively used SQL*Loader to load Data from flat files from various Data Sources to Database tables in Oracle.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Involved in continuous enhancement, optimization and fixing of problems.
• Worked mainly on analyzing the problems occurring in the data, and finding the solution to resolve them.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Performance was improved by creating the materialized views and going against those materialized views instead of multiple relational tables.
• Created several views, stored procedure, indexes, joins and UDF’s.
• Designed and developed PL/SQL stored procedures, functions and database triggers required in the application.
• Used cursors and parameter passing with PL/SQL tables and data types, Reference cursors.
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Better understanding of MISACWIS projects in terms of various modules ‘Provider Management’, ’Case Management’, ’Intake’, ’Investigation’, ’Financial Module and understanding of various terminology within the MiSACWIS application like ‘Person’,’ Case’, ’Intake’, ’Investigation’, ’Home Study’, ’Placement’, ‘Workload Item’, ‘Provider’, ‘Agency’, Case Service Plan’ etc.
• Worked with Analytic Functions (DENSE RANK, LISTAGG, ROW NUMBER,LEAD,LAG,etc)
• Developed BATCHES for Interfaces and Financial Modules.
• Created UNIX shell scripts for automating batch jobs.
• Optimized existing queries for better performance and less impact on database.
• Developed XML inbound and outbound files for different agencies.
• Worked with Indexes to avoid full table scans on large tables for the fast retrieval of data.
• Worked withBulk Collectsto improve the performance of multi-row queries by reducing the context switching.
• Designed and developed reports using Crystal Reports XI version.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Extensively used PLSQL tables and Bulk loader utility for processing data and loading into oracle tables.
• Developed statistical reports to keep track of numbers of Investigations, Ongoing cases, Case Service Plans, Home Study Evaluations assigned to each worker in a county.
• Involved in analysis, design and coding of Oracle processes in PL/SQLto built packages.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files for Merge Case, Person, and Provider Use Cases.
• CreatedTables, Views, Materialized views, and constraints.
• Develop PL/SQL code for designing the reports mapping each report to its own package.
• Used Clear case for version controlling and Clear Quest for ticketing system.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Solved the complicated run time errors while running the process along with DBA team members.
• DevelopedShell Scriptsfor executing PL/SQL Scripts, and the Shell scripts are scheduled throughOpCon.

Environment: Oracle 11g, JAVA,J2EE, Windows7, UNIX, TOAD, SQL Loader, SQL Developer, PL/SQL Developer, Crystal Reports XI, XML, SQL, PL/SQL, Clear Case/Clear Quest, Opcon.

Confidential, Lansing, MI

PL/SQL Developer

Responsibilities:

• Involved in Technical Analysis of the business requirements.
• Involved in requirements analysis, design and development of the system.
• Involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Extensively used PL/SQL features such as procedures stored procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Involved in designing Crystal Reports and migrating the existing reports from Crystal Reports XI to Crystal Reports 2008.
• Involved in configuring different environment for report(s) developed using XML/XSD and reports designed against stored procedures written in Oracle.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Written/Debugged Packages, Procedures, Functions and Triggers.
• Involved in Designing/Customization/Debugging of Forms and Reports.
• Develop the Complex SQL Constructs required for the Datamart Database.
• Developed the New Pl/SQL units and prepare the Unit Test cases as per the new CR.
• Developed the Generic Pl/SQL unit using the Dynamic SQL.
• Involved in the logical and physical data modeling using ER-win
• Used the UTL FILE functions for the data loading activities for complex business logic.
• Assisted in the enhancement of back end routines for the AYP application.
• Expertise in Moving the database objects using traditional import and export.
• Designed the Oracle Partition strategies, Performance tuning and data analysis.
• Expertise in writing Complex SQL queries, structure hierarchy by using Analytical functions, data validation using Regular Expressions
• Created adhoc scripts, reports by using sql and plsql for the bug fixes and pre and post verification script for the data verification.
• Loaded data into Datamarts by using Hardcore PL/SQL by writing procedures and loaded the data by using sql loader and utl file programming and also using Merge.
• Optimized the queries by creating the indexes and re-write the SQL’s for best performance.
• Developed the shell scripts to automate the jobs by using UNIX.
• Configured job dependencies, automated the jobs via Unix scripts to be called in Control-M (production batch execution tool).

Environment: Informatica 8.6, UNIX, SQL Developer, Crystal reports 2008, Oracle 11g, IBM Clear Case/Clear Quest.

Confidential, Lansing, MI

PL/SQL/ETL Developer

Responsibilities:

• Created SSIS/DTS packages for application that would transfer data among servers and perform other data transformations, scheduled the same SSIS packages by creating the corresponding job tasks.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Configured XML Config files (.dtsconfig files) to change properties of packages dynamically.
• Migrating MS Access databases to SQL Server, Creating new database / tables to put in the extracted data and rebuilding the relationship, Created ETL SSIS packages both design and code to process data to target databases.
• As a member of BI Reporting team Developed SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server 2005 using different transformations; derived column, sort, aggregate.
• Created complex DTS Packages DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc., Involved in migration from SQL Server 2000 to SQL Server 2005.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence (BI) using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Customization and enhancement of the existing software based on user requirements.
• Worked on Dynamic Link Libraries (DLL) using Visual Basic classes.
• Worked on modules such as Participation rate, proficiency rates /safe harbor, Attendance and graduation rates.
• Involved in designing of batch files.
• Worked on AYP Admin App modules using VB and Oracle 10/11g for School AYP status and District AYP Status.
• Used Stored Procedures for most of the database operations for the Quick Access of data from the Database.
• Worked with policy people to identify the business processes, rules and application user requirements.
• Involved in gathering user requirements.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Designed and developed reports using Crystal Reports XI version.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Developed batch script to deploy SSIS packages on to the MSDB database
• Designed, Developed and implemented various reports for Confidential departments on production and test servers.
• Created heavy stored procedures for financial transaction by using procedural parameters & worked with packages, blocks & exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Created various adhoc reports as of when required for the production analysis and bug fixing.
• Converted reports to browser supportable XML format.
• Extensively utilized TOAD for performance tuning by generating explain Plans.
• Involved in data validation/testing and debugging code for school report card system.
• Involved in fixing the bugs while using different versions of crystal reports and work station issues.
• Configured packages using Package configuration wizard to allow package run on different environments.
• Created complex Oracle Stored Procedure, packages using TOAD tool to migrate data from heterogeneous data sources such as MS Access, Excel etc., and Involved in migration from SQL Server 2005/2008 to Oracle11g Servers.
• Experience with SQL performance tuning, error handling, event handling, re-running of failed PL/SQL packages using checkpoints and scripting with Active-X and VB.NET in Oracle.
• Done performance tuning to SQL query on manipulating and retrieving data from Oracle/SQLSERVER 2008 for migration.
• Involved in writing test plans and writing test scripts for unit testing.
• Experience in Quality Assurance and application testing methodologies.
• Written stored procedures, triggers, views, packages, PL/SQL programming using Oracle 10/11g as backend.
• Involved in create a detail design documentation, flow charts, and procedures around organizational Infrastructure, defining standards and templates to ensure consistency

Environment: Visual Studio.NET 2010/2008/2005 , ASP, VB6.0, C#.NET, VB.Net, crystal reports, ASP.Net, Ajax Control Toolkit, SOM SUITE Methodology, SQL Server 2005/2000,PL/SQL, Oracle 10/11g, DB2, HTML, Win forms,DHTML, Team Foundation Server, Business Objects, JavaScript, XML, XSL, XSLT,IIS 6.0, PVCS, Ms Office 2000, XML Web Services, windows XP, MS-VISIO, MS Office Suite, CSS, 508 Compliance, UML, MS SQL Reporting Services(SSRS), Integration services(SSIS),TOAD,XML Web Services, MS Office Tools.

Confidential, Jackson, MI

PL/SQL/Oracle Developer

Responsibilities:

• Responsible for the detail design documentation, development, unit testing and maintenance of internally developed applications.
• Designed a workflow management system to streamline the process. Used cursors and parameter passing with PL/SQL tables and data types, Reference cursors
• Responsible for creating Data change request and String Testing before deployment to production.
• Responding to Remedy case assigned by help desk.
• Designed and developed PL/SQL stored procedures, functions and database triggers required in the application.
• Used cursors and parameter passing with PL/SQL tables and data types, Reference cursors.
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Involved in analyzing data required for the report(s) and assist ETL developers in defining the report needs.
• Give feedback in team meetings when finalizing the estimates for any given reporting requirement.
• Assist with technical expertise in meetings with business to explain things involved in requirement and suggest any improvements/enhancements which could be possible.
• Develop reports, Unit test and circle back with ETL/Database developers if any issues found during development/unit testing process.
• Scheduled oracle jobs through DBMS SCHEDULER.
• Involved in Writing, debugging and optimizing PL/SQL code.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Prepared Build and Unit Testing of Portal Data Differential CR.
• Designing and Developing Reports in Crystal Reports .net compatible version
• Developing Statistical/Graphical Reports in (Visual Basic) VB environment Using SQL Business Objects and Crystal Reports 10.x.
• Involved in Software Development Life Cycle starting from requirements gathering, and performed object oriented analysis and design.
• Involved in Quality Assurance, Technical documentation and application testing methodologies.
• Involved in unit testing and system integration testing

Environment: VS.Net 2003, VB.Net, ASP.Net, C#.NET, WinForms,ASP, VB6.0, HTML, ADO.Net, Oracle 9i, SQL, PL/SQL, Web Services, MS SQL Server 2000, Visual SourceSafe, Crystal reports 10, Designer 2000, IIS 5.0,JavaScript, ERWIN, MS Office Suite 2000, Windows 2003/XP, Unit Testing - nUnit..

Confidential

Software Developer

Responsibilities:

• Involved in the business, data access and UI layers design and development.
• Developed stored procedures, packages and functions for the application that could be called by Forms & Reports.
• Used Stored Procedures for most of the database operations for the Quick Access of data from the Database.
• Created database objects for the system like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Involved in writing the stored procedures, Packages, Batch Processing, SQL Queries and also involved in fine-tuning the queries using Query Optimizer.
• Designing and Developing Reports in Crystal Reports .net compatible version
• Developing Statistical/Graphical Reports in (Visual Basic) VB environment Using SQL Business Objects and Crystal Reports 10.x.
• Involved in Software Development Life Cycle starting from requirements gathering, and performed object oriented analysis and design.
• Involved in UML, Quality Assurance, Technical documentation and application testing methodologies.
• Involved in unit testing and system integration testing

Environment: VB.Net, VB 6.x, ASP,ADO, COM+, MTS, IIS 5.0, XML, Html, Oracle 7.3/8.0, TOAD, MS SQLServer 2000, SQL, PL/SQL, MOSS (Share point server), visual Interdev 6.0, ASP 2.0, Data modeling with ERwin3.0/ MS-VISIO, Crystal Reports 8.0, Java Script,IIS, VBScript,CDO, MS-Access,MS-Excel, VBA, MS Office Suite 2000, MS Visio, Windows 98/NT/2000.

Confidential

Software Developer

Responsibilities:

• Involved in Application design, Business Analysis/Use Case Modeling, System Upgrade, Evaluation and System maintenance
• Involved in Gap Analysis, Preparation of TSD, Unit Test Cases, Coding, Bug fixing, Creating Reports, On-Site production and user support.
• Write/debug Packages, Procedures, Functions and Triggers.
• Designed/Customized Oracle Forms and Reports.
• Used Stored Procedures for most of the database operations for the Quick Access of data from the Database.
• Involved in software development life cycle Methodology- Requirements gathering, Analysis, design, Development and System Testing.
• Used HTML, CSS, JavaScript, VBScript for appealing GUI
• Created components that constitutes the business logic.
• Integrated the COM components to enhance the functionality
• Created User Controls to navigate between web/windows forms
• Created and used custom exception classes
• Implemented online payments processing and updates policy at the same time.
• Implemented online policy payment detail
• Implementing data exchanging between server and administrator’s application using .NET Remoting technology.
• Developed Statistical/Graphical Reports Using Crystal/SQL Server Reporting Services and XML.
• Middle tier business logic ADO.net transacts with either XML/Oracle/SQL Server
• Used web server controls with ASP.NET, ADO.NET and VB. NET
• Data conversion between ADO com and ADO.Net.
• Provided database connectivity using Microsoft OLE-DB Provider.
• Utilized Data Adapter and Data set to access database using ADO.Net.
• Dynamically configured DTS packages and tasks at run time.
• Export data to excel sheet through Data Transformation Services(DTS) package.
• Created Stored Procedures and Triggers to perform automated rules, updating to related tables using Oracle.
• Involved in reverse engineer system documentation from an existing system.
• Involved in Technical documentation, Quality Assurance and application testing methodologies.
• Used the source control tool Visual Source Safe 6.0.
• Designed and Developed Windows Forms, reports are written in MS-Word from VB
• Performed unit testing, integration testing.

Environment: C#.NET, ASP.NET, VB.NET, ADO.NET,WinForms,VB 6.0, ASP, IIS 4.0/5.0, MTS, XML, COM, HTML, Java Script, VB Script, SQL, PL/SQL, XSL,WSDL,SOAP, Crystal Reports 8.0/8.5, MS Visio,DTS,MS SQL Server 7.0/2000, Oracle 8i, TOAD,Visual Interdev, Visual SourceSafe, ADO, Dreamweaver, Windows Forms, .NET Framework 1.1, MS SQL Reporting Services, Visual Studio 2003,IIS, MS Office Suite 2000, WindowServer2003.