PROFESSIONAL SUMMARY

An accomplished Database Analyst and Design with 5 years of experience in life cycle development design, process, includes requirements definition, interface implementation, testing, and maintenance. Currently pursuing an MISM through Keller Graduate School of Management and strengthening knowledge in technology to focus on delivering business solutions.

• TECHNICAL SKILLS:
• RDBMS Oracle 11g/10g, Oracle 9i, MS-SQL Server 2008, MYSQL
• Operating Systems Red Hat Linux, Fedora, Ubuntu, Windows NT/2000/2008
• Languages C, Pointers in C, SQL, PL/SQL, Shell Scripting, .NET, Core Java, J2EE
• Excel Macro Programming, HTML, XML
• Oracle Tools SQL Developer, Informatica, Teradata, TOAD, SQL Plus, iSQL Plus, SQL Loader, Oracle Procedure Builder, Oracle Enterprise Manager
• Development Tools Developer 10g/9i, Reports 10g/9i, Forms 10g/9i
• Other Tools Visual Studio 2010/08, Control-M Desktop, Control-M Enterprise Manager, Control-M Configuration Manager, HP-Java Console, WS-FTP, Win-SCP, Reflection-X, Putty

QUALIFICATIONS:

• Oracle PL/SQL Developer with 4 years of IT experience in full system lifecycle design and analysis, development and implementation using Oracle databases.
• Has good knowledge of Software Development Life Cycle SDLC , RUP, and Agile Methodology.
• Advance at implementing physical database models with Oracle 9i, 10g, 11g
• Database / ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions. Performance Tuning of Informatica Mapping and workflow.
• Data Modeling: Experience in Dimensional Data Modeling using Erwin 4.5/7.3 and Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT Dimensions tables, Physical Logical data modeling, and Data Modeling Tools Visio.
• Expert at programming Packages, Stored procedures, Function, Triggers Views, Materialized Views, Nested Tables and Oracle Objects. Expert at data validation and quality assurance.
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions. Excellent business analysis skills.
• Professional experience in handling Very Large Databases using Oracle 11g/10g/9i.
• Experienced in tuning offensive SQL using SQL Trace, Analyze, Explain Plan, and TKPROF. Expert at using HINTS, Partitioning, Bulking techniques, and Indexes.
• Experienced in Linux Shell Scripting, scheduling Cron jobs.
• Experienced in using Oracle utilities Import/Export, SQL loader, Data Pump to load the data in to the database.
• Experienced in implementing code that performs well in a high volume OLTP Database OLAP database environment.

PROFESSIONAL EXPERIENCE:

Confidential

• Strong Knowledge of Business application like Oracle Apps R12, Forms and Reports.
• Experience in all aspects of analytics/data warehousing solutions Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions .
• Experience with version control, change management and defect tracking systems.
• Very strong working experience in SQL, PL/SQL Client and Server side Procedures, Functions, Packages, Objects, Triggers .
• Demonstrated expertise utilizing ETL tools, Data Transformation Services DTS , and Data Stage and ETL package design, and RDBM systems like Oracle, and DB2.
• Extensively worked on SQL Loader, creation of control files to load the data from flat files.
• Proficient in Shell Programming and Deployment of Packages to various Linux Servers. Well known in monitoring Linux Servers, their hardware using HP-Java Console.
• Worked with Linux Team in development of automated tool using Shell script and deployed to Linux Server.
• Developed Excel Application to populate the task status and work time of employee in form of chart and pie diagrams.

Confidential

Project Description: This project involves in populating of data from external source to database.

Responsibilities:

• Involved in the full development lifecycle, responsible for collecting business requirements, System Analysis, Functional Specifications, Detailed Technical Design, Application development, Data Modeling, Data Warehouse Implementation.
• Collaborate with project team to understand requirements in order to effectively plan and execute test following agile methodology.
• Analyzed customer specifications and custom design of applications successfully and implementing designs in new/existing application using PL/SQL.
• Generating DDL files to create new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges by incorporating business standards throughout the files.
• Designed and developed system using Oracle Forms, Reports and PL/SQL.
• Involved in Design of Data modeling including logical, physical data modeling and dimensional data modeling using ERWIN.
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• The Oracle Forms 6i was upgraded to Forms 11g with a brand new platform.
• Used SQL Loader scripts to load the flat files into the Oracle Database.
• Developed PL/SQL Packages, Procedures and Functions for validating the information from the legacy system and imported into Oracle Applications using the Open Interface Import program and populated the base tables.
• Created database link to create materialized views to maintain copies of remote data on the local node.
• Used various SQL Expressions and Conditions in standalone procedures and functions.
• Used Oracle data pump utilities EXPDP/IMPDP for Copying of data from development server to test and production server.
• Used features like Bulk Collect AND Bulk Insert to process large amount of data in data base.
• Performed application on performance tuning by using SQL Trace and Explain plan for better performance.
• Configured the data warehouse application for best performance with parallel query, Materialized Views, Query Rewrite.
• Executing and maintaining the data warehouse extract transform load ETL process.
• Use of rollup, inline views, cube operators, merge and update statement.
• Loaded data from flat files into Database using SQL Loader.
• Worked on Unix Shell Scripting for Scheduling Batch Jobs using Crontab.
• Designed and customized BI Answers, Reports and BI Delivers according to the requirement.
• Substitute teacher 08/2009- 06/2010 Columbus Public Schools,
• Help Desk Wal-Mart Distribution Center: Grove City Ohio 09/2011-06/2012
• Help Desk Specialist Gap Direct Groveport, OH 10/2010- 09/2011

Confidential

• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Performed physical database design like join indexes, primary indexes, secondary indexes, PPI, collect stats and data skew
• Worked on Oracle Hints. Partition tables in Oracle Database, Dynamic SQL.
• Expertise on working with forms and reports.
• Written several complex Unix Shell Scripts for clean-up, logging, file manipulation and transferring the files.
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements.
• Database and table design and implementation for data warehouse and related ETL processes.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
• Involved in creating INDEXES to avoid the need for large-table, full-table scans and disk sorts, and for fast retrieval of data from database objects.
• Worked in ETL data stage.
• Tuned the T-SQL Queries and Stored procedures for better Performance.
• Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Migrated data from SQL Server to oracle 10g.

Environment: Oracle 10g, PL/SQL, SQL Server, T-SQL,SDLC, Toad, UNIX, Erwin 4.5,SQL Navigator 6.4, Toad, SVN, Informatica, UNIX Shell Scripting, Windows XP.

Confidential

Responsibilities:

• Responsible for system analysis, development, documentation and unit testing and Data Warehouse Implementation.
• Participated in daily scrum meetings as part of implementing the Agile testing methodology.
• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Managed offshore resources in making them understand the CORE application and tasks, and coordinating with them to deliver respective tasks in time with respect to enhancements.
• Enhanced and maintained various database objects of the CORE system meeting the business rules.
• Enhanced database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges by incorporating business standards throughout the files.
• For the purpose of backend analysis, developed anonymous blocks in PL/SQL to resolve data glitches.
• In the application level made necessary changes in CORE Power Builder code and respective packages dealing with data fixes.
• Created Logical and Physical Models in data modeler using ERWIN.
• Added new packages, with generalized procedures and functions to reduce the Trigger level load and making the code workflow better, having the business rules intact.
• Wrote advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using Oracle, SQL.
• Extracted data from Flat files using SQL Loader.
• Used Oracle Data Integrator ODI to improve inter-application dialog by having interfaces executed asynchronously.
• Worked on ETL tools from source to target business objects by using Transformation Manager.
• Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.
• Handling database Query Optimization, and Performance Tuning.
• Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections, and used BULK Binding involved in writing database procedures, functions and packages for application.

Environment: Oracle Applications 11.5.10.2, Oracle 10g, PL/SQL, Agile, Erwin, PowerBuilder, ODI, SQL PLUS, TOAD, SVN, SQL Navigator