PROFESSIONAL SUMMARY:

• Over 8 years of experience in Analysis, Design and Data Processing using the Oracle technology on different platforms. More than 5 year experience Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Database: Using Oracle 10g/11g/12c, Teradata TD13/TD12, SQL, PL/SQL, SQL*Plus, SQL Server 2005/2008. Proficient in working with PL/SQL. Expertise in TOAD (Tool for Oracle Application Developers).
• Extensively worked on PLSQL - Functions, Procedure, Functions, Packages, Ref-Cursors, Triggers, Views, Materialized Views, Hits and Indexes.
• Strong hands on experience usingTeradata utilities (B-TEQ, FastLoad, MultiLoad, FastExport, and Tpump).
• Strong Data warehousing experience using Informatica Power Center, Power Connect for ETL, OLTP, OLAP, Data Mining, and Scheduling tool. Worked with heterogeneous source systems like flat files, RDBMS, and XML.
• Data Modeling: Data modeling knowledge in Dimensional Data modeling, SCD, Star Schema, Snow-Flake Schema, Dimensions and Fact Tables, Physical and logical data modeling and De-normalization techniques.
• Expertise in Client-Server Application Development using TOAD, SQL*PLUS, SQL DEVELOPER and SQL*LOADER.
• Experience in working with different source system and integrated the data into target system using the ETL Transformation Logic (Informatica).
• Experience in data cleansing/profiling operations on Source data (From source to Staging) and experience in performing SCD Type 1,2 and 3 on Target data.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof, Table Partitioning.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions).
• Experience in writing Python scripts to automate data loading process.
• Expertise in developing and working on UNIX shell scripts and automating the process by Autosys, Control-M, and Maestro. Extensively worked on SAP Business Object.
• Experience in all phases of Data warehouse development Like: Requirements Gathering, Developing the Code, Unit Testing and Preparing Design Documents.
• Worked on Unix commands, and created shell scripts based on Business prerequisite.
• Involved in providing Extensive production support to various Applications along with server Maintenance projects 24x7.
• Experience in developing applications using Agile, Scrum and Waterfall methodologies.

TECHNICAL SKILLS:

RDBMS: Oracle 9i/10g/11g, SQL Server 2008/2005/2000, MS Access 9.0/7.0, Teradata 12/13, Sybase, UDB DB2, My Sql.

ETL Tools: Informatica 8.6/9.1/9.5/9.6 products (Power Center, Power Exchange CDC) Informatica data quality IDQ, Informatica MDM, IDD, IDE, IMM, B2B and Informatica cloud.

BI/OLAP Tools: Cognos 9.0/8.0, Business Objects XI, Hyperion, Tableau, Oracle Reports.

Operating Systems: UNIX (AIX, HP/UX), Windows NT/ 2008/2000/2003/ XP/Vista/7,Linux

Data Modeling: Logical/Physical Data Modeling, IBM Rational Rose, ERWIN 7.3.10, Microsoft Visio 2004, 2007,2010., TOAD.

Programming Languages: SQL, PL/SQL, C, C++,Java, C-shell, K-shell, Perl,Python.

Scheduling Tools: Autosys, Control-M, Maestro

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

RDM Developer

Responsibilities:

• Involved in getting the User Requirements, Data Modeling & Development of the RDM Application.
• Extensively used SAP Power Designer to create data models
• EncapsulatedPL/SQLprocedures and functions in packages to organize application.
• Extensively used Views, Cursors, Store procedures, Packages, Collections and Triggers.
• Participated in Performance Tuning using Explain Plan and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Responsible for creating objects, deploying jobs and providing production support for Data Management (RDM) application
• Collaborated with Hadoop team to provide data masking and data encryption for RDM application
• Designed python scripts to scrape data from websites.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, flat files,, SAP Business Objects, SAP Power Designer, Teradata 15, and Python 2.7.

Confidential, Irving, Texas

PL/SQL Developer

Responsibilities:

• Worked with the Business user to finalize the rules for Loading data from External System in to database by creating DB links and used SQL*Loader to load the data from legacy system to temporary tables.
• Developed user defined functions based on requirements. Developed back end interfaces using PL/SQLStored Packages, Procedures, Functions, Collections and Triggers.
• Involved in performing data profiling in stage area and performed CDC (change data capture), data validation before loading the data into target database.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.
• Created technical documentation for all the scripts written for future .
• Involved rebuilding code into ETL mapping Logic based on requirement and modified the existing reports.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, etc. (Used Informatica for data loading).
• Extensively worked with joiner functions like normal join, full outer join, master outer join, and detail outer join in the joiner transformation.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Involved in performing the unit testing before loading the data into target.
• Prepared test plans for User acceptance test and used Winscp for Migrating code from local to remote system.
• Optimized SQLstatements and PL/SQLblocks by using OracleHints, Explain plans, profiling, collecting statistics and Trace sessions for Cost based Optimization.
• Extensively worked on PL/SQLError/Exception handling.
• Creating UNIX Shell scripts to automate the data loading process and schedule the Jobs using Autosys. Worked on creating the reports using SAP Business Objects. Migrated tables, procedures, packages, functions, triggers, views and indexes from Oracle 11g to 12c version
• Developed python scripts to gather latitude and longitude data for a set of zip codes using Google maps API
• Developed scripts in UNIX to migrate code from development to stage to production.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, flat files, Informatica Power Center 9.5.1,Python, SAP Business Objects, UNIX, and Autosys.

Confidential, Plano, Texas

PL/SQL Developer

Responsibilities:

• Include Gathering Requirements from Business, Impacting Analysis,Estimation, Coming up with a Technical Solution & Design, Build, Test & deployment for data loads from external systems using Siebel EIM, SQLLDR.
• Written .IFB files and CTL files to load data from Legacy system to Siebel system.
• Developed EIM interfaces which will be run on daily basis and some on weekly basis for loading data from external system to Siebel system.
• Extensively used TOAD 12.1 for writing stored procedures, packages, functions,views and materialized views for validating and manipulating data.
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, object type, packages and stored procedures.
• Addressing Performance issue and creating the packages (includes procedure and functions) based on business logic.
• Increase the Performance of stored procedure by analyzing the explain plan (estimated plan and actual plan) .
• Imported Source/Target Tables from the Respective databases and created transformations like Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Used UNIX scripts to access Oracle Data and to run the Informatica jobs (using Maestro). Prepared test plans for User acceptance test.

Environment: Siebel Tools, Siebel Client 8.1.1, Siebel EIM, eScript, Informatica, SQL * Plus, TOAD 12.2, SQL*Loader, SQL Developer, Shell Scripts, UNIX and Maestro Scheduler.

Confidential, Ontario, CA

PL/SQL developer

Responsibilities:

• Worked with the Business user to finalize the rules for loading data using data mapping document.
• Interacting with the Business and the External Teams to understand the business requirements for creating the Technical Specifications.
• Wrote SQL scripts to create temporary tables and developed control files for SQL*Loader to load from legacy system into the temporary tables.
• Created various types of procedures using PL/SQL and SQL queries for data validation and data cleansing.
• Wrote Procedures to drop appropriate Indexes on tables to improve the performance of loading.
• DevelopedProceduresfor efficientError Handlingprocess by capturing errors into user managed tables.
• Usedcursorsfor accessing complex data resulted from joining of large number of tables and even have experience with exception handling..
• Used Informatica power center to load from different source system into target database.
• Used different transformation in Informatica to perform CDC(Like- Lookup, Update strategy, filter etc.)
• Used various transformations in Informatica to perform CDC( Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer).
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Involved in performance tuning by using different alternatives specified by informatica tool.
• Involved in writing shell scripts using UNIX.

Environment: Oracle 10g, SQL * Plus, SQL*Loader, SQL Developer, Informatica power center, and UNIX.

Confidential, Irvine, CA

PL/SQL developer

Responsibilities:

• Gathered requirements from Business users and created a Low level technical design documents using high level design document.
• Participated in the design meetings, and prepared technical and mapping documentation.
• Wrote SQL scripts to create temporary tables and developed control files for SQL*Loader to load from legacy system into the temporary tables.
• Created various types of procedures using PL/SQL and SQL queries for data validation, data cleansing.
• Designed and developed the scripts to create table, views, indexes and sequence.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
• Involved in Performance tuning, Included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats.
• Wrote Procedures to drop appropriate Indexes on tables to improve the performance of loading.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 10g, Informatica, flat files, SQL Loader, SQL * plus, PL/SQL, Erwin 4.0/3.5.2, and Unix Shell Scripting.

Confidential

PL/SQL developer

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse.
• Loaded Data using SQL loader and developed the files for the same.
• Used SQL Loader to dump the data provided in the form of flat files from the legacy system into normalized staging tables.
• Used various kinds of control structures including case, decode, if-then-else, for loops, while loops while developing procedures.
• Writing Unit Test Cases and Test Scripts for Manual Testing.
• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Designed, developed and modified various Reports.
• Analyzed the explain plans of long running SQLs and created triggers to solve.
• Handled and managed customer relationship management system(CRM).
• Designing and modeling database according to Requirement and made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Environment: Oracle 10g, SQLServer2008, IBM ISeries (DB2), MS Access, Windows XP, Toad, Cognos 8.4.1., SQL developer, SQL * plus.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for managing production, development & test databases and applications.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database and also using the informatica to load the data.
• Used largely Informatica to load the data and involved in using the complex mappings, Mapplets using the advanced transformations like Filter, Router, connected/unconnected Lookups, Aggregator, Joiner, Sequence generator, Update, and Expression.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Creation of Users and Granting them privileges and roles.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Oracle Configuration. Oracle Tuning. Oracle Patch Administration.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Used UNIX Putty to transfer, copy, and move and assign privileges to the files like read, write & execute.
• Monitoring the data loading jobs and tuning the SQL queries.

Environment: Oracle, SQL Server 2000, Informatica, UNIX, Windows, SQL*PLUS.