SUMMARY

• 11+ years of total IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications
• Understanding teh Business requirements and converting them into Blueprint.
• Interacted with Clients to understand teh business processes across various functional areas.
• Proficient in Oracle 11g/10g/9i/8i/8.0 (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), Ms Sql Server 2008, SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages, oracle supplied utilities
• Experience on Reporting Tools - Crystal Reports, Sql Server Reports.
• Experience in Visual Basic 6.0 programming, Unix Shell scripting
• Extensive experience with SQL (DDL, DML, and DCL), PL/SQL.
• Expertise in working on Toad for oracle, SQL Developer.
• Strong knowledge in all kinds of Database Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• In-depth knowledge of PL/SQL with teh experience in creating tables, views, sequences, triggers, packages, functions, materialized views etc.
• Strong knowledge in DDL, DCL, TCL and DML statements, RDBMS and data dictionaries
• Experience in writing Packages, Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Good understanding of Normalization and De-Normalization techniques.
• Knowledge in Oracle supplied packages like DBMS JOB, DBMS OUTPUT etc.
• Experience in data loading using Export and Import utilities such as UTL FILE and SQL loader.
• Management of schemas, objects & partitioning teh tables & indexes, users and privileges monitoring.
• Knowledge in planning and implementing Database Security by creating users and assigning Roles.
• Performed Logical (EXP/IMP) and Data pump for taking Backup of Database Objects.
• Tuning of applications for long running queries using TKPROF, EXPLAIN PLAN and AUTO TRACE.
• Experience in Creating DBLINKS between Oracle to Oracle for accessing teh data and User Maintained Tables(UMT).
• Modified, maintained and developed teh SQL codes to develop new enhancements.
• Knowledge in writing and tuning Complex Queries and familiar with Unix commands.
• Performance tuning of SQL queries used in extracting data from different source systems as well as in transformation of data using SQL and PL, SQL code.
• Very familiar with Waterfall and Agile methodologies for System development and implementation.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Able to work in any kind of Environment, Self-motivated and quick learner.
• Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Self-starter who takes responsibility and accountability.
• Excellent time management skills and documentation skills.

TECHNICAL SKILLS

Business Systems: Mining, Inventory, Materials, Media.

Databases: Oracle, MS SQL, Access

Utilities: Auto Trace, TKPROF, Explain Plan, Sql Loader.

Reporting Tools: Crystal Reports, Sql Server Reports

Languages: SQL, PLSQL, Visual Basic 6.0, Unix, Perl

Operating Systems: Windows NT, Windows 2000, Unix, Linux, Sun Solaris, DOS

PROFESSIONAL EXPERIENCE

Confidential, Englewood, CO

Oracle PL/SQL Developer

Environment: Linux, Unix

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Created SQL*Loader scripts to load data into teh temporary staging tables.
• Utilized SQL*Loader to load flat files into database tables.
• Created procedures to transform and data massaging and loading into aggregated tables
• Written SQL Scripts and PL/SQL Scripts to extract data from Database
• Migrated tables from database to other database
• Developed stored procedures and triggers to facilitate consistent data entry into teh 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 teh deliverables.
• Performed functional testing for teh procedures and packages.
• Experience in job defining, scheduling and monitoring tool AutoSys.
• 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.

Confidential, San Francisco, CA

Data Analyst / Pl-SQL Developer

Environment: Windows, Linux

Responsibilities:

• Worked as aParticipated in Designing databases (schemas) to ensure that teh relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of teh Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in teh creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from teh database tables and exported teh data to different sources in different formats.
• Worked with several tools to access and perform several operations on database.
• Experience in Generating Reports.
• Experience in job defining, scheduling and monitoring tool AutoSys.
• Developed Data entry, query and reports request screens and tuned teh SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of teh requirements with teh technology teams.

Confidential - Bentonville, AR

Oracle PL/SQL Developer

Environment: Sun Solaris, Linux, Windows

Responsibilities:

• Developedstored procedures to extractthe data from different sources and load it into data warehouse.
• Involved in creating detailedFunctional Documentationwhich includes all Business requirements andTechnical specifications.
• UsedOracle PL/SQLfor implementing business rules and do performance tuning procedures.
• Created data mapping files for teh data coming from different web services.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied teh procedures into an existing ETL process.
• Developed procedures usingDynamic SQL..
• Worked for designing Logical and Physical data models for Master Data and Transactional Data. knowledge and experience in structured systems analysis and design techniques
• Developed database objects includingtables, clusters, Indexes, views, sequences, packages, triggers and proceduresto troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Prepare teh Mapping document which details out teh mapping of source to teh target data model with application of business rules.
• Importing and exporting teh data into multiple environments.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for teh database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Involved in handling teh changes in compiling scripts according to teh database changes
• Developed reports using complex queries as perclient requestas a part of production support
• PerformedSQL tuning using Explain Plan, Hints and indexes
• Responsible for performing code reviews
• CreatedSQL*Loaderscripts to load data into temporary staging tables
• UtilizedSQL*Loaderto load flat files into database tables
• Created procedures to transform and data massaging and loading into aggregated tables
• Written SQL Scripts and PL/SQL Scripts to extract data from Database
• Migrated tables from database to other database using DB-Links

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in Discussions with teh client regarding Business Requirements.
• Installation, Creation and support of Oracle 9i database environments.
• Involved in teh maintenance and enhancement of teh application.
• Maintaining Logical and Physical structure of teh database.
• Creating tablespaces, tables, views,scripts for automatic operationsof teh database activities.
• Coded variousstored procedures, packagesandtriggersto in corporate business logic into teh application.
• Used teh technical document to design teh database tables.
• Data conversionfrom flat file to intermediate tables usingSQL*Loader,Data mapping
• Created control files forSQL*Loader.
• GatherDatabase and User Level Statisticsand Analyze Overall System Performance.
• Designed/developedtables, views, various SQL queries,stored procedures, functions.
• Monitor database and system backups, developedOracle Stored procedures, functions, packages, and triggersthat pull data for reports.
• DevelopUNIX shell scriptsto administer teh system.
• Extensively worked withDynamic SQL, Composite data types &Global Temporary Tables.
• Responsible for purging and archiving teh production databases.
• UsedUTL JOBto automate thePL/SQLprocedures and packages.
• Involved in Interacting with users, error fixing by enhancingPL/SQLpackages, stored procedures & functions.
• Data conversionfrom flat file to intermediate tables usingSQL*Loaderand also created control files forSQL*Loader.
• Communicate issues and progress to project manager.
• Performed logical backup usingexport and import utilities.
• Developed database objects includingtables, Indexes, views, sequences, packages, triggers and proceduresto troubleshoot any database problems.
• Involved inUnit Testing Stored ProceduresandFunctions
• CreatedSQL*Loaderscripts to load data into teh temporary staging tables.
• CreatedCustom Triggers, Stored Procedures, Packagesand SQL Scripts.
• Involved in uploading of teh data from flat files into Databases andvalidated teh datawith PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to teh requirements
• Created various SQL and PL/SQL scripts for verification of teh required functionalities.
• Developed complex SQL queries for data retrieval from various database objects includingtablesandviews.
• Worked on variousbackend proceduresandfunctionsusing PL/SQL.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Installed and configured Red Hat Linux, Oracle 9i and performed migration from existing oracle 8i system to 9i.
• Provided System support for both development and 24*7 production environments.
• Involved in applying patches for up-to-date database software, creating new control file, log files, tablespace, rollback segments, datafiles and alter datafiles for resolving disk contention issues.
• Produced DB Links in Oracle for communicating with external databases.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Used tools such as SQL*Loader to develop procedures for migration of data from systems.
• Tuning of database performance by query optimization and trace facility using Utlbstat/Utlestat utilities, Explain plan, analyze and Tkprof.
• Created SQL*Loader scripts to load data into temporary staging tables
• Utilized SQL*Loader to load flat files into database tables
• Created procedures to transform and data massaging and loading into aggregated tables
• Written SQL Scripts and PL/SQL Scripts to extract data from Database
• Migrated tables from database to other database
• Suggest appropriate measures depending on bottlenecks type - IO, CPU or memory bottleneck.
• Created users and granted/revoked their respective privileges and roles.
• Designed schema objects and extensively used PL/SQL procedures, sub queries, triggers, packages, Perl scripts to automate data loading.
• Experienced in documenting teh architecture and data flow of teh entire system.
• Developed PL/SQL Packages, Stored procedures, functions, triggers and Views for Reports
• Modules design as per User requirement Specifications.
• Designing and coding of screens
• Coding, Unit Testing, Implementation and User training
• Generated Various Reports using Crystal Reports
• Designing teh COM Components.
• Rectification of Functionality Bugs, Rectification of coding bug’s etc
• Taking Daily Database Backups
• Testing and bug fixing