EXPERIENCE SUMMARY:

• Experienced with all phases of SDLC (System Development Life Cycle) Starting from Requirements gathering, system analysis, design, development, testing and deploying of windows/web applications, Databases and GUI on Windows platform.
• Good knowledge in RDBMS concepts and ER Modeling (SQL Server 2008/2005 & Oracle).
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Extensive experience in system development, implementation, maintenance and conversion of varied information systems and testing tools.
• Possesses expert skills in the development of applications utilizing Oracle tools including OraclePL/SQL, SQL Plus, SQL Loader, and experience with PL/SQL back-end programming - Database Triggers, Packages, Stored Procedures, Functions and Management of Schema Objects.
• Experience in PL/SQL Programming and in writing Stored Procedures, Functions, Packages and Triggers.
• Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.
• Possesses thorough understanding of relational database architecture, data warehousing, from logical and physical design, with proficiency in data definition and data manipulation languages.
• Have clear understanding of Data Warehousing Concepts.
• Experienced in E-R modeling and Relational Object Relational Database concepts and coding.
• Excellent database normalization skills.
• Knowledge of networking and installing Routers, Hubs, Modem and etc.
• Knowledge of Hardware like System Assembling, some extend to troubleshooting and Software Installation.
• Experience in using UNIX platform with shell scripting.
• Experienced in Data loading using SQL Loader, Export and Import utilities.
• Involved in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution usingInformatica PowerCenter 8.6.1 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer).
• Designed complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables.
• Experience in interacting with business users to clarify requirements and translate the requirements into technical specifications.
• Experience in Data Modeling & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Expertise in developing standard and re-usable mappings using various transformations like expression aggregator, joiner, source qualifier, lookup and router.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative.

TECHNICAL SKILLS:

ETL Tools

Informatica 8.x/7.x (Power Center/Power Mart/Power Exchange) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling

Star Schema Modelling, Snow Flake Modelling

Databases

Oracle 10g/9i, MS SQL Server 2008/2005

Languages

T-SQL, PL/SQL, Unix Shell Script

Tools

Toad, SQL* Loader, Autosys

Operating Systems

Windows 2003/2000/NT, UNIX, Linux

EDUCATION:

Master of Science in Information Technology and Management
B.Tech in Computer Science

Client: Confidential, Tempe, AZ Aug 2010 - Till Date
Position: Oracle Developer

Responsibilities:

• Responsible for setting and managing user accounts, granting required privileges to users.
• Coordinated with the Business users to collect requirements.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Worked on Logical and Physical Data Modelling.
• Developed & Reviewed the PL/SQL code written by team members and fine tuned the code with best practices of coding which reduced the processing time effectively from 60 hours to 16 hours.
• Suggested best methodologies to team members to overcome the performance lags in their code.
• Used Materialized views, Indexes, bulk collect utilities, views, optimizer hints, tune the PL/SQL code to avoid huge hits to database by including views and Materialized views with Index for consolidated data, effective Cursors.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Created Oracle instance, table space and UTL settings. Developed, Tested and Migrated the Oracle PL/SQL scripts to Production. Developed, Tested and Migrated Unix Shell Scripts.
• Created different kinds of views including Materialized Views.
• Created database objects like Tables, Sequence, Synonyms, Views and Indexes.
• Participated in System test case preparation and execution.
• Worked on tuning the SQL Queries by code review.
• Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
• Performed Unit Testing and tuned the code for better performance.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Configuring Jobs and scheduling them through Autosys job scheduler.

Environment: Toad, Oracle 10g, Flat file, SQL Server 2008, PL/SQL, SQL*Loader, UNIX, UNIX Shell Scripts.

Client: Confidential, Des Moines, IA Aug 2009 - Jan 2010
Position: Informatica Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering and project co-ordination.
• Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.
• Extensively used various transformations Lookup, Update Strategy, Expression,
• Aggregator, Filter, Stored Procedures and Joiner etc in Power center designer to develop various mappings.
• Used Debugger to debug the mappings. Examined sessions, event, and error logs and analyzed for trouble shooting mappings and sessions.
• Performed Unit Testing and tuned the mappings for better performance.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Configuring sessions in a batch and scheduling them through Autosys job scheduler.
• Documentation of existing mappings as per standards.

Environment: Informatica 8.6.1, Oracle 10g, Flat file, PL/SQL, SQL*Loader, UNIX, UNIX Shell Scripts.

Client: Confidential, Hyderabad, INDIA Aug 2006 - Mar 2007
Position: Oracle Developer

Responsibilities:

• Involved in writing PL/SQL code for triggers, functions and procedures and packages.
• Prepared the Unit Test Plans (Required test Scenarios).
• Involved in the code review.
• Debugged the stored Procedures, Functions, and Triggers in the Oracle Databases.
• Participated in internal meetings for the daily status report of the assignments.
• Involved in resolving the production issues at the client side.
• Designed database tables as per technical specifications.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.

Environment: Toad, Oracle 9i, Flat file, PL/SQL, SQL*Loader, UNIX, UNIX Shell Scripts.