SUMMARY

• 7+ Years of experience in the Information Technology field with extensive experience in Database development, RDBMS based application, Requirement gathering and analysis, Unit Testing and monitoring, documentation and technical support.
• 3+ years as a DB performance analyst.
• Experience with database platforms Oracle and Teradata.
• Experienced as Oracle developer in large production environments with database implementation on UNIX and Windows.
• Experienced in Developing PL/SQL and T - SQL - Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
• Extensive knowledge in developing PL/SQL codes using Oracle 11g.
• Experienced user of PL/SQL and T-SQL for development of server-end program units as well as reusable codes using Procedures and functions.
• Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory.
• Experienced in scheduling the jobs using Autosys and Crontab and monitor the batch processing.
• Experienced in writing SQL queries creating different kinds of reports from large scale database.
• Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Experienced in tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Experienced in Trade Surveillance.
• Experienced in migration of database from SQL Server 2000 to Oracle 10g.
• Experienced in performing of data mining and data analytics on data-sets and data-mart.
• Translated the T-SQL procedure, function and views into Oracle’s PL/SQL Packages, Procedure, Function and Views.
• Experienced in PL/SQL with PowerBuilder
• Extensive Knowledge and Experience in ETL tools like SQL Loader, Informatica, and DTS packages to transfer the data between different databases.
• Extensive knowledge and experience in oracle reporting tools and crystal reports business objects enterprise server.
• Extensive Knowledge and Experience in Data Analysis and managing data warehouse and data marts.
• Extensive Knowledge in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
• Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
• Extensive Knowledge in developing applications using PHP, .NET technologies, VB 6.0, C#, ASP.Net, ADO.Net and Java.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Experienced in providing technical and non-technical production support.
• Involved in Oracle Data Integrator (ODI) development
• Involved in preparing the SQL and PL/SQL coding convention and standards.
• Involved in preparing the functional specification, technical documentation, schema documents, flow charts and user support documents.
• 4+ experienced in C# and responsible for the design and development of middle-tier business objects (C#).

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Java, ADO.NET, UNIX Shell Script

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2005, MS Access

Modeling: UML

Other Tools: TOAD, SQL Developer, Microsoft Office Suite (Visio, Project), Forms and Reports 9i/10g

Other Application: Symphony RPM Web application, Analytic Workbench

Operating Systems: Windows, Linux, Mac/OS

BI TOOLS: OBIEE 11g, 10g, Siebel Analytics 7.x

Web Technologies: HTML, HTML5, CSS, CSS3, JavaScript, Ajax and XML

PROFESSIONAL EXPERIENCE

Confidential, Hunt valley, Maryland

PL/SQL DEVELOPER

Responsibilities:

• Creation of database objects like tables, views, procedures, packages using Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
• Create PL/SQL packages, stand alone procedures, and stand alone functions.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
• Use Collections like variable arrays, nested tables
• Design and create entity relationship diagrams (ERD) for Oracle based applications and interfaces.
• Create utPLSQL unit testing framework for Oracle’s PL/SQL .

Environment: SQL, PL/SQL, Oracle 10g, Toad 8.5, SQL*Plus, SQL*LOADER, UNIX shell, GIT,scripting, Reports 6i, Forms 6i, MS SQL Server 2000, Discoverer 10g.

Confidential, Jefferson City, MO

PL/SQL Developer

Responsibilities:

• Designed and developed complex PL/SQL Packages, Procedures, and Functions.
• Documented business rules, functional and technical designs, test cases, and user guides
• Created Oracle Forms and Reports using 10g
• Created Reports using Crystal Report 10/2008 and Deski/Webi reports using Business Objects XIR2/R3
• Created Extracts for the Data warehouse using complex SQL Statements
• Worked on Admissions, Discharges, Admission Screening, Orders, Medical Administration
• Worked on setting up Oracle Application Server with the given configuration.
• Involved in Analysis and Design of Logical and Physical Database and related objects
• Created Materialized views and scheduled using bash scripts
• Used Shell scripts and Perl scripts for automating the processes.
• Developed Scripts for Data Migration, Data Cleansing
• Worked with Clinical Workflow Initiative (CWI) to define business rules, requirements and calculations for the key performance metrics to be included in dashboard roll-out.
• Worked on Remedy 7.5 to solve work Orders for production support
• Sub-queries and joins were extensively used in stored procedures
• Used PL/SQL, Shell Scripts and SQL*Loader to import /export data from various sources
• Worked on Migration of processes and reports from servers to different upgraded servers.
• Heavily optimized the code for high performance using bind variables, & bulk collects
• Worked on day-to-day issues; importing/loading huge amount of data, user related, performance tuning.
• Used Oracle Tools Explain Plan and TKProf to do the performance tuning of the Sql

Environment: Oracle 11g, Oracle Forms & Reports 10g, Linux, Crystal Report 2008/10, Business Objects XI R2/R3, UNIX Shell Scripting, Autosys, Remedy 7.5, Toad, SQL/Pl/SQL Developer, Putty, WinScp3, Explain Plan, SQL*Plus, SQL server 2005/08, SSIS, SSRS,T-SQL, Unix shell script, Perl, Oracle Enterprise Manager

Confidential, San Francisco, CA

Database Developer

Responsibilities:

• Involved in all the stages of Software Development Lifecycle (SDLC) - design, development, analysis, testing and deployment of application.
• Involved in the Data Analysis and quality assurance testing and code reviews.
• Involved in Oracle Data Integrator (ODI) development
• Involved in ETL/Data stage.(IBM InfoSphere Datastage).
• Involved in Teradata.
• Involved in Oracle DDL scripting
• Involved in Oracle Application Express .
• Involved in SQL queries to pull data from telecom billing system .
• Created test scripts and complex queries to test against the application built by third party for Confidential .
• Applied the patch in Dev environment to install the new version of codes.
• Created the shell scripts to automate the execution of the oracle procedure and back up the daily files to the Archive folders.
• Involved as a developer /tester in trade surveillance.
• Experience working with Cognos and Data stage
• Created the Daily Report using the business object crystal Reports.
• Created SQL*Loader scripts to load data into the database tables.
• Created scripts for tables, views, indexes, sequence for DBA.
• Involved in ETL concepts and data quality controls .
• Created Indexes and also partitioned the tables to improve the performance of the query.
• Created scripts to modify/update the data in one shot as per required by the users.
• Used the SQL loader to load the data into CMP database as per requested by the business users.
• Experienced in PL/SQL with Pro C.
• Experienced in C# and responsible for the design and development of middle-tier business objects (C#).
• Worked with NDM, Crontab and Autosys.
• Developed and managed the NDM scripts to transfer the files between CMP server to others servers.
• Used FTP, SCP and WinSCP to transfer the files between different servers.
• Involved in data modeling and creating ER Diagrams using MS-Visio.
• Scheduled the Jobs using the Autosys 4.5 and 4.5.1 to automate the daily jobs.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Interacted and coordinated with technical and non-technical clients while providing 24/7 production support.
• Created the Process flow and Flow Charts for the schema using the MS Visio.
• Prepared the technical documentation and user support documents.

Environment: Oracle 10g/11g, PL/SQL, SQL plus, SQL Navigator, UNIX, Shell Scripts, ETL, Dataware house design SQL Loader, Business Object, IIS, C++, C#,PL/SQL with Pro C, ASP, ASP.NET MS Excel, MS- Visio, ERWin, WinSCP, VI Editor, NDM, Autosys 4.5/4.5.1,HTML,Java script.

Confidential

PL/SQL DEVELOPER

Responsibilities:

• Developing SQL and PL/SQL scripts for problem solving.
• Generating reports using Report builder.
• Developing Shell Scripts.
• Establish onsite/offshore communication between onsite users and offshore project teams.
• Tracking and ensuring timely deliveries as per SLAs committed to the client.
• Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.
• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Experienced in performing of data mining and data analytics on data-sets and data-mart .
• Involved in SDLC including designing, coding and testing.
• Invloved in application life cycle management, B2B exchange, cloud data integration, data masking, messaging .
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Involved in data stage .
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Responsible for the design and development of middle-tier business objects (C#).
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle 10g, PL/SQL, Explain Plan, TKPROF UNIX, Javascript, SQL, jQuery, XML, XMLDOM, XSL, XPath, Windows XP.

Confidential, Tampa

Oracle PL/SQL Developer

Responsibilities:

• Wrote procedure on Suspect Validations on Deposits.
• Designed, developed, tested, supported and maintained PL/SQL stored procedures, functions, triggers, complex Tables and data analysis to solve complex business problems.
• Installed metadata repository and Experienced in administering database objects in development environments
• Coordinated with DBAs for administrative tasks like creating/rebuilding indexes, adding partitions, analyzing tables
• Performance tuned stored procedure, function, view, trigger, and query by utilizing indexes, partitioning, Explain Plan, SQL Trace & TKPROF utilities
• Experienced in Oracle/UNIX development environment using a standard interface tool such as Toadand SQL Developer
• Worked on Unix shell scripting
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Migrated data from Flat File to Oracle Database Table using SQL*LOADER
• Wrote and reviewed technical and functional specification documents
• Configured IBM Websphere version 6.2 Application Server Administration Console for server-database connection
• Run “end-to-end” process works for Analytic Server 6.2 version.
• Executed the QMemo processing scripts and verified the successful completion of each process (QMemo Generation, Edit Check, Quality Check, End-to-End) individually
• Configured and tested response file with all parameters for installing XBI (Xcelerated Business Insights) Application (SymphonyRPM Web application 7.2)
• Installed Xbi Application Code and Upgraded the Xbi application repository Version from 6.2 to 7.2 (DB VERSION)
• Installed SymphonyRPM Web Component on Development, System Integration Test (SIT) and Stress environment on Linux platform (RHEL 6.2) and tested Web Component pointing to new Websphere Application Server in Linux STE for connectivity and reports generations.
• Submitting package request for SymphonyRPM Web Component
• Worked for setting up single-sign-on (SSO) for Wesphere Application Server (WAS) 7.0
• Worked for Determining the integration needed between Webbank and Web component. Requested Web Bank environments and configuration for Development and System Integration Test (SIT)
• Prepared Architecture Diagram for Webbank. Worked on Webbank Application Hosting Registration and Deployment

Environment: Oracle Database 11g, SQL Developer, LINUX, Symphony RPM web Application, Analytic Workbench, HTML, JAVASCRIPT .

Confidential, Bloomington, IL

Oracle Developer

Responsibilities:

• Gathered and analyzed requirements from business analyst.
• Created database objects like tables, synonyms, sequences, triggers, and views.
• Created, edited procedures and functions for improved business requirements.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Conducted impact analysis and designed structures to enhance performance.
• Involved in data cleaning, merging and conversion.
• Modified tables, synonyms, sequences, views, stored procedures and triggers.
• Generated SQL and PL/SQL scripts to create and drop database objects.
• Enforced constraints for data validation.
• Fixed performance issues and bugs with packages and stored procedures using explain plan.
• Created B-tree and Bitmap indexes.
• Loaded flat file using as SQL *LOADER into database.
• Used TOAD & SQL Developer for debugging application.
• Written cursors and REF Cursors for transaction processing.
• Implemented database triggers based on the business rules and requirements.
• Assisted in Functional Requirement Specification & Use Case Diagrams to streamlining the business flow.

Environment: UNIX, Oracle, PL/SQL, Sun Solaris 5.8, Putty Beta 0.60, VI Editor, MS SQL 2005, HTML, Toad, MS Visio 2005.

Confidential, Topeka, KS

Oracle Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Prepared program specifications for PL/SQL Procedures and Functions to do the conversion.
• Implemented RDBMS (normalization) concepts in Data modeling.
• Designed the front end interface for the users, using Forms 6i
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Participated in Performance Tuning using Explain Plan and TkProf.
• Developed number of Reports using Reports 6i and Crystal Reports.
• Created Unix Shell Scripts for automating the execution process.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, item classes and list of values using Discoverer 10g.
• Worked on Perl scripts to transfer files using FTP to all the UNIX servers at one time.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: SQL, PL/SQL, Oracle 10g, Toad 8.5, SQL*Plus, SQL*LOADER, UNIX shell scripting, Reports 6i, Forms 6i, MS SQL Server 2000, Discoverer 10g.