SUMMARY:

• Around 10+ years of IT experience in Software Development life cycle(SDLC) and in analysis, design, modeling and implementation of business logic.
• Extensive experience in creating packages, stored procedures, Functions, Triggers, Views and other database objects using SQL, PL/SQL programming.
• Worked on oracle PLSQL constructs nested tables, associative arrays, records, arrays and dynamic SQL and analytical functions, Hierarchical queries, Bulk Binding.
• Expertise in the management of SQL scripts and documentation of the work.
• Good working experience in PL/SQL including Packages, procedures/functions, database triggers, EXPLAIN PLAN, Hints, PL/SQL Collections, Ref cursors, Performance Tuning, co - related queries, complex joins for existing and new programs.
• Proficient in Teradata RDBMS, SQL, MultiLoad, FastLoad, BTEQ.
• Experience in Performance tuning, writing complex SQL queries and Partitioning.
• Strong in working on UNIX environment and working with FTP and SCP to transfer files to remote servers.
• Expertise in Microsoft office tools, Visio, Oracle DBMS Job Scheduler, SQL*loader, Import/Export and Import/Export dump utilities.
• Exposure to Pharma, Automobile, Manufacturing, Banking and Telecom Domain
• Good Experience in handling the Master Data Management system.
• Demonstrated experience and competency in Data Warehouse and ETL concepts and Working knowledge of ETL (Informatica)andInformaticaMaster Data Management (MDM) tool.
• Hands-on experience with Informatica MDM Hub configurations - Data Mappings (Landing, Staging and Base Objects), Data Validation, Match and Merge Rules, Batch jobs, Customizing/configuring Informaticadata director(IDD) applications among others.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Demonstrated experience in using various InformaticaTransformations like Filter, Aggregator, Update Strategy, Router, Expression, Sequence Generator, Joiner, Stored Procedure, etc.
• Strong understanding/knowledge of Data Modeling, Dimensional modeling in Data warehouse environment such as star schema and snow flake schema.
• Good knowledge of configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Good Understanding of NoSQL and basic knowledge of MONGODB.

TECHNICAL SKILLS:

Operating System: Unix, Windows 98/ NT/ 2000/ XP/VISTA/7, DOS

Programming Languages: SQL, PL/SQL, C, Assembly Level Languages(8085 & 8086), Shell Scripting

Databases: Oracle 8i,9i,10g,11g, Teradata 14.0

Tools: and Utilities: Import/Export Utility, Import/Export Data pump, Sql*Loader, ERwin, Putty/Unix, Toad 9.5/8.6.1, UTL File packages, InformaticaPowercenter(8x, 9x), Informatica MDM 9.5.1,IDD, SQL Developer, SQL*Loader, TOAD,Teradata SQL Assistant 13.10, BTEQ,Fast Load, Multi Load,OBIEE 11.1.1, Star Team, SVN, Finacle(Banking Solution Software from Infosys), Microsoft Office tools

PROFESSIONAL EXPERIENCE:

Confidential, RICHARDSON,TX

Sr. Data Warehouse (Oracle/Teradata/Informatica) Developer

Responsibilities:

• Worked closely with Project Team, architects and SME to clarify business requirements and translate the requirements into technical specifications and conduct Data Model reviews with project team members along with Collaborating with the data architects for data model management.
• Worked with various database and ETL tools(Oracle TOAD, Teradata SQL assistant, InformaticaPowercenter, etc.) in order to effectively store, retrieve, analyze, and report data mapped across various dimensions.
• Responsible for designing, maintaining and troubleshooting an existing suite of applications - packages, reports and stored procedures that make up the core solution and also participate in Systems Testing (SIT), Integration Testing, User Acceptance Testing (UAT) and data analysis among other tasks.
• Create ETL Informatica mappingsand review the data load programs to ensure the data quality and provide proper checks and balances with upstream and downstream systems.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM and setting up the match/merge rule sets to get the right master records.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Creation and maintenance of UNIX shell scripts and BTEQ scripts.
• Worked on loading of data from several flat files sources using TeradataMLOAD&FASTLOAD.
• Creating and maintainingvarious ETL Informatica Workflows/Mappings (including SCD Type 2 Mappings) based on the requirements and running/monitoring the Workflows.
• Extensively used Transformations like Router, Update Strategy, Aggregator, Joiner, Expression and Lookup, Sequence generator and Stored Procedure in Informatica.
• Performance Tuning of the impacted Queries.
• Guiding/Assisting other developers to check/review the code.

Confidential, RICHARDSON,TX

Sr. Oracle-ETL Developer

Responsibilities:

• High Interaction with the Clients/business team to understand the current process, gather the requirements and detailed design Planning.
• Creating the Design Documents based on the requirements.
• Write new logic/code for the new process(Time-Boxing the Input from the various data sources, comparison of GPIs, NDCs, etc.).
• Used Informatica Power Exchange for loading/retrieving data from Mainframe systems.
• Writing Queries, Complex SQL Queries/DML Statements, PL/SQL packages/procedures/functions using collections, co-related queries, etc as per the requirement.
• Loading of the data in bulk using SQL Loader and validating the data.
• Troubleshoot the issues in the code and performance impact queries.
• Worked with Business SMEs on developing the business rules for data cleansing. Applied those business rules using Informatica Data Quality (IDQ) tool to cleanse the data.
• Creating Informatica Workflows/Mappings based on the requirements and running/monitoring the Workflows.
• Extensively used Transformations like Router, Aggregator, Joiner, Expression and Lookup, Sequence generator and Stored Procedure in Informatica.
• Involved in Mapping and extraction process during the data Conversion.
• Performance Tuning of the impacted Queries.
• Guiding/Assisting other developers to check/review the code.
• Involved in the weekly project status meetings.

Confidential, THOUSAND OAKS, CA

Onsite Lead/SR ETL-Oracle Developer

Responsibilities:

• Handling the Onsite team/Managing the Critical Confidential (Master Data Management system) and coordinating with the offshore lead/team.
• High Interaction with the Clients/business team to resolve the issues.
• Writing Queries, Complex SQL Queries/DML Statements, PL/SQL packages/procedures/functions/triggers as per the requirement.
• Loading of the data in bulk using SQL Loader and validating the data as part of Semester Load process.
• Developed ETL(Informatica) and Data Quality mappings to load and transform data from source to ODS using Powercenterand IDQ tool.
• Setup Match and Merge Rules and also developed Mappings in Informatica MDM to create master records.
• Working with the DBA and other Java support teams to identify the issues and help to resolve the same.
• Troubleshoot the issues in the code and performance impact queries.
• Performance Tuning of the impacted Queries.
• Running and Monitoring the Informatica workflows and analyzing the same.
• Executing of the UNIX scripts for generation of reports/standardization of addresses.
• Handling/managing several processes in Confidential and also fixing the bugs.
• Guiding/Assisting other junior developers to check the code and reviewing the code.
• Supported APEX applications and conducted performance tuning for PL/SQL.
• Coordinating the weekly project status meetings.
• Used JIIRA to access and log defects.

Confidential, DETROIT, MI

Sr. Oracle Developer

Responsibilities:

• Developing Queries, packages/procedures/functions/triggers as part of the development.
• Responsible for implementing changes and debugging/fixing bugs in the packages/procedures using PL/SQL Programming.
• High Interaction with the Clients/Onsite team to resolve issues in quick time.
• Loading of the Test data into Database using SQL Loader.
• Helping the DBA to export/import the databases.
• Involved in the weekly project status meetings.

Confidential, SAVANNAH, GA

Oracle Developer

Responsibilities:

• Maintaining the Billing & Rating Module.
• Involved in the production support activities of the previous releases and responsible for solving the critical issues on time.
• Development of packages, procedures and triggers as part of the enhancements.
• Responsible for implementing change requests (CRs) for customers and clients.
• Data modeling and writing complex queries for reporting team.
• Customization of the product for different customers (users).
• Interacting with clients and the onsite team to solve issues.
• Updated and maintained all the DDL and DML scripts for production release.
• Work on the billing cycle modules which require constant post-production enhancements to accommodate diverse calling plans and rates.

Confidential

Oracle Developer

Responsibilities:

• Involved in the development of packages, procedures and triggers as per the requirements.
• Involved in Fetching of the data from Database using SQL Queries and displaying using MRT.
• Interacting with the bank staff to fetch proper reports(Loans/advances) for the bank.
• Involved in writing Unix Shell scripts and unit testing.

Confidential

Developer

Responsibilities:

• Was involved in writing System Call Hijacking Component. The component is responsible for hijacking system call and releasing hijacked system call.
• Was involved in designing the Application and writing Test Cases for Testing.
• Following the processes and maintaining the scripts in Star team tool.
• Providing the Status update on a regular basis.