SUMMARY

• Sr Consultant with 12 years of experience in the analysis, development, testing, implementation, production, and maintenance of Business Intelligence and Data Warehousing Solutions.
• 8 years of experience in 11g/10g/9i/8i, writing and performance tuning of SQL queries, coding with PL/SQL, anonymous block, implementing different complex business logics into PL/SQL codes and calling PL/SQL stored procedures from Unix Shell scripts.
• Have concepts of Data Modeling (conceptual, logical and physical model)
• Done performance tuning using indexes, Oracle hints, WITH clause, GTT tables, semi - join sub queries with EXISTS etc.
• Done Data Integration
• Done Data Warehousing
• Done Data Analysis.
• Created reports using horizontal tables, vertical table, cross tables, dimension, measure and filters.
• Customized the automatically generated back end SQL queries in BO.
• Done testing during migration from desktop intelligence reports to web intelligence reports in BO.
• Changed and selected correct universe during testing.
• Worked in normal bar chart, grouped vertical bar chart with multiple measures.
• Generated prompt so that BO reports can take the inputs during execution time.
• Configured page layouts and used variables during BO report design.
• Worked in BO universe creation including connectivity with rdbms, data foundation, business layer creation and publishing.
• Resolved looping in universe using alias to avoid wrong data fetch during SAP BO execution.
• Done object oriented programming with java specifically with abstruct class, jdbc:odbc connectivity with oracle, memory allocation, inheritance, operator overloading, function overloading, writing functions and procedures.
• 3.5 years of experience in Unix Shell scripting.
• 3 years of experience in Teradata development using Bteq, Mload, Fast Load, Fast Export.
• Having knowledge and 3 years work experience in star schema, snowflake schema, SCN type1, SCN type 2, surrogate key and data warehouse with Teradata database and with different data warehousing tools like SAPBI, Informatica and AWM.
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle and many other facilities, such as Import/Export, SQL*Loader and SQL*Plus.
• 2 years of experience in SQL Server.
• Creating stored procedures in SQL Server.
• Creating Tables in SQL Server.
• Creating indexes in SQL Server.
• Re building and re organizing index in SQL Server.
• Writing cursors and exception handling in SQL Server stored procedures.
• Worked with transaction SQLs.
• Did SQL Server index maintenance.
• Expertise in Performance Tuning using oracle hints and optimization process.
• Good knowledge in Oracle and Teradata database Architecture.
• A logical, analytical thinker with exceptional database skills.
• Expertise in requirement analysis, designing, developing, implementing and executing a project
• Expertise in SQL, PL/SQL,Unix Shell scripting, Teradata Bteq, Mload,Fast Load,tpump utilities and data warehousing.
• Have 12 months experience in Informatica.
• Execution of Informatica workflow, working with source qualifier and creating transformation using source qualifier, joiner, filter, aggregate, router, expression transformations.
• Implemented SQL override in source qualifier.
• Applied connected dynamic lookup and update strategy for doing insert update in the target tables.
• Created sessions with mappings and maplets.
• Used aggregator transformation for doing sum, count etc.
• Used router transformation for making different groups before insert into target table.
• Used Oracle table as source and Teradata table as target for data fetch and insertion.
• Created and connected different sessions in a workflow for serial and parallel execution.
• Creation of surrogate keys using Informatica sequence generator.
• Worked with mapping parameters and work flow parameters.
• Worked with session task, email task and command task.
• Incorporated logics to send failure and success emails after workflow execution.
• Worked with heterogeneous sources in Informtica ETL.
• Experience in creating Tables, Views, Constraints & Index (B Tree, Bitmap and Function Based)
• Excellent skills in Triggers, Stored Procedures, Functions and Standard Packages.
• Expertise in Dynamic SQL, collections and Exception handling.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, UTL FILE etc.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Good Knowledge in Table spaces, Segments, Extents & Oracle Blocks.
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Outstanding logical & problem resolving skills.
• Good knowledge in the Implementation of Business Applications using the ORDBMS.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Methodologies: Agile, Test Driven DevelopmentDatabases Oracle 9i/10g/11,Teradata,Sqlserver

Operating Systems: HP-UX, Windows NT/2000/XP

Software/Tools: Toad, Putty, plsql developer, vi editor, K/Bourne Shell, Awk, SAPBI,SAPBO, SQL Assistance

Web/App Servers: Weblogic, Tomcat,JSP and Design Patterns.

Testing Tool: Quality Center

Version Control Tools: VSS, PVCS, Synergy 7.1

Programming: SQL, PL/SQL (packages, ref cursors, procedures, functions, triggers, cursors, exceptions, utl file handling, anonymous block, collections),Teradata Bt Et, Teradata Bteq, Mload, Fast Load, Fast Export, Tpump, Unix Shell scripting,TSQL, stored procedure in SQL Server, object oriented programming with .net Technology

ETL Tools: INFORMATICA,SAP BO,SAP BI

PROFESSIONAL EXPERIENCE

Confidential

Sr Database Developer

Responsibilities:

• Created Teradata utilities like Mload, fast load.
• Created export scripts like Bteq, Fast Export to export data in csv files
• Created Teradata GTT tables.
• Done performance tuning in Teradata.
• Created BTET (begin and end transaction) in Teradata.
• Modified UNIX shell batch jobs where new columns like coupon number are being incorporated in place of old column sku nbr.
• Incorporated logics to send emails in case of success/ failure of the processes.
• Written Teradata alter scripts where column name alteration took place and carried out statistics collection after successful alteration.
• Interacted with Users and gathered Business Requirements.
• Created tables in star and snowflake schema with SCD type 2 implementation.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Reviewed User Requirements. Created detailed Functional Design Documents and Report design details documents for the reports.
• Coded PL/SQL packages and procedures to create ref cursors, error handling.
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Createdglobal temporary tables to populate the intermediate data joining several large transaction tables.
• DesigningGTTs.
• Optimized lot ofSQL statementsandPL/SQL blocksby analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Written dynamic SQL statements inside PL/SQL packages.
• Used different types of Ref Cursors (strong and weak) to provide data to crystal report team.
• Created Test Plans, Test Scripts and Perform the testing for data conversion process during all phases of Testing Starting from Unit, System, Integration and UAT

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Plus, TOAD, SQL Developer, Teradata, SQL assistance, Putty

Confidential

Sr PL/SQL Developer

Responsibilities:

• Interacted with Users and gathered Business Requirements. Mostly involved in making changes to the existing Reports and updating the reports as per the Requirements.
• Creating entity relationship model.
• Worked with conceptual, physical data modeling.
• Created tables in star and snowflake schema with SCD type 2 implementation.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Reviewed User Requirements. Created detailed Functional Design Documents and Report design details documents for the reports.
• Coded PL/SQL packages and procedures to create ref cursors, error handling.
• Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL as part of Project/Application requirements.
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Createdglobal temporary tables to populate the intermediate data joining several large transaction tables.
• DesigningGTTs.
• Optimized lot ofSQL statementsandPL/SQL blocksby analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Written dynamic SQL statements inside PL/SQL packages.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Used different types of Ref Cursors (strong and weak) to provide data to crystal report team.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types
• Involved inUnit Testing Stored ProceduresandFunctions along with UAT and production support.
• Used PL/SQL developer tools for faster application design and developments
• Responsible for Analyzing and Implementing the Change Requests.
• Involved in handling the changes in compiling scripts according to the database changes.
• Created Test Plans, Test Scripts and Perform the testing for data conversion process during all phases of Testing Starting from Unit, System, Integration and UAT
• Created Teradata utilities like Mload,fast load.
• Created export scripts like Bteq,Fast Export to export data in csv files and later these data are loaded into table through SQL loader.
• Created Teradata GTT tables.
• Done performance tuning in Teradata.
• Created BTET (begin and end transaction) in Teradata.
• Have extensive knowledge in Teradata architecture.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Plus, Crystal Reports 2008,TOAD, SQL Developer, Teradata, SQL assistance

Confidential

Sr. PLSQL developer

Responsibilities:

• Having experience on handling various customers, Understand their requirements and involving in full product life cycle of the project.
• Analyzing the business requirements of the project by studying the Business Requirement Specification document.
• Supported Unix and oracle jobs in 24*7 production support.
• Monitored and fixed Unix jobs and PL/SQL procedures.
• Worked in L2 and L3 support.
• Creation of database objects like tables, views, Materialized views procedures, packages using Oracle tools like PL/SQL, SQL*Plus and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the business logic.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Done Seasonality calculation of sold products by BP in Turkey region.
• Sales Order calculation the products.
• Use hints for better optimization..
• Developed and modified UNIX Shell scripts and executed them as a cron jobs.
• Participating in Performance Tuning using Explain Plan.
• Maintained dimensions and cubes in Oracle AWM.
• Created calculated measures in AWM.
• Created materialized views required for the application.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Participating in Technical Documentation, Unit test, Integration test and writing the Test plan.
• Created Test Scripts and Perform the testing for data conversion process during all phases of Testing Starting from Unit, System, Integration and UAT
• Done Data Modeling (conceptual, logical and physical model)
• Done Data Integration
• Done Data Warehousing
• Done Data Analysis

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Plus,AWM

Confidential

Sr. Programmer

Responsibilities:

• Involved in production support for several modules like Anti-money laundering, Enterprise Solutions, Credit and debit card fraud solutions and Merchant solutions of Proactive Risk Management System developed in Java, PL/SQL and SQL Server.
• Creating stored procedures in SQL Server.
• Creating Tables in SQL Server.
• Creating indexes in SQL Server.
• Re building and re organizing index in SQL Server.
• Writing cursors and exception handling in SQL Server stored procedures.
• Worked with transaction SQLs.
• SQL Server index maintenance.
• Supported Unix and Oracle jobs in 24*7 production support.
• Monitored and fixed Unix jobs and PL/SQL procedures.
• Worked in L2 and L3 support.
• Created several PL/SQL stored procedures for introducing new validation logics in Proactive Risk Management System.
• Involved in production support for taking care of authproc process used to track fraudulent transaction.
• Joined as BI consultant in ACI Worldwide forum to provide quick technical solutions on PL/SQL /SQL Server to users, other ACI developers and team members.
• Worked in database triggers like row level trigger, statement level trigger and before - after trigger.
• Worked as data base lead and did several code review activities.
• Involved in several knowledge sharing sessions where knowledge is shared amongst other team members of different modules.
• Created HLD and LLD design documents.
• Involved in understanding of entity relationship diagram during the initial stage of project.
• Responsible for analyzing the business requirements of the project by collecting the Business Requirements from the end users.
• Involved in version control activity through PVCS
• Created Test Plans, Test Scripts and Perform the testing for data conversion process during all phases of Testing Starting from Unit, System, Integration and UAT
• Modified and fixed of existing java programs.
• Incorporated new logics in java codes using function overloading.
• Written codes related to JDBC:ODBC connectivity to connect with oracle.
• Written new classes for incorporating new functionality.
• Done table creation, writing stored procedures in Sybase. Also involved in code review activity.
• Done performance tuning of Sybase stored procedures.
• Done performance tuning of SQL queries required in Sybase database.

Environment: Oracle 11g/10g, SQL, PL/SQL, Windows XP, SQL Server 2005

Confidential

Senior Developer

Responsibilities:

• Understanding the business rules completely and implementing waterfall methodology.
• Experience in writing PL/SQL, Teradata utilities, Unix scripts and creating reports in SAP BO.
• Experienced in writing tuned code, and validating the fields.
• Performed module lead activity where lead a team of the size 10.
• Worked on estimations, causal analysis and fishbone analysis etc.
• Worked with project risks and mitigation plans.
• Worked in creating SAP business objects reports using horizontal, vertical and crosstab tables from existing universes.
• Worked with creating SAP BO reports with prompts and Alerters for conditional colour changes.
• Worked on Teradata utilities like Bteq,Mload, Fast Load etc.
• Worked on Teradata stat collection.
• Worked on Teradata performance tuning.
• Worked on writing ANSI SQLs.
• Worked on LO ITT team as tester.
• Done customization of SQL queries generated in the backend of SAP BO reports.
• Worked with variables, dimension and measures in SAP BO.
• Having concepts of creating universes and resolving looping issues using aliases and contexts.
• Experienced in Unit testing and help others for System Testing.
• Reviewed the test cases and participated peer reviews of the test cases.
• Tracking the defects and reporting the defects using defect log
• Prepare the user guide and manuals.

Environment: Teradata, SAP BO,Unix

Confidential

Responsibilities:

• Worked with Confidential accounting and invoicing systems using Teradata,Unix and Autosys.
• Involved in creating Teradata tables, global temporary tables, and volatile temporary tables.
• Created several Mload scripts and wrapper Shell scripts which is needed to load the flat file data coming from external mainframe systems to staging area and later to data warehouse.
• Created several Bteq scripts for loading the target normalized tables through full load / incremental loading processes.
• Created several Shell scripts which sends email while files are received in landing area.
• Created Shell scripts which checks whether files are landed in the landing area.
• Created PI and NUSI indexes on target Teradata tables.
• Created fast load scripts while relatively less data need to be populated in data warehouse.
• Created Fast Export scripts for exporting the data from tables to flat files.
• Created partitioned primary indexes.
• Involved in system integration testing and unit testing.
• Monitored autosys box jobs and provided necessary solutions while there is any issue in production environment.
• Execution of Informatica workflow, working with source qualifier and creating transformation using source qualifier, joiner, filter, aggregate, router, expression transformations.
• Implemented SQL override in source qualifier.
• Applied connected dynamic lookup and update strategy for doing insert update in the target tables.
• created Informatica mapping with connectivity with oracle database.
• Created sessions with mappings and maplets.
• Used aggregator transformation for doing sum, count etc.
• Used router transformation for making different groups before insert into target table.
• Used oracle table as source and Teradata table as target for data fetch and insertion.
• Created and connected different sessions in a workflow for serial and parallel execution.
• Creation of surrogate keys using Informatica sequence generator.
• Created checksums using MD5 function in Informatica.
• Worked with mapping parameters and work flow parameters.
• Worked with session task,email task and command task.
• Incorporated logics to send failure and success emails after workflow execution.
• Incorporated logics for truncate load, incremental iggregation etc in Informatica.
• Worked with heterogeneous sources in informtica ETL.
• Worked with infa parameter files.

Environment: Putty, Teradata SQL assistance, Informatica 8.6 Windows XP

Confidential

Development Project

Responsibilities:

• Created Shell scripts which FTPs the APAC trade data files into the Landing Layer from source Environment.
• Created several SAPBI info packages in SAP data warehousing workbench to load landing layer files to staging area.
• Created several DTPs and transformations in SAPBI to load the staging layer data into target cubes.
• Created several cubes containing dimensions and facts.
• Involved to create process chains consisting of DTPs and IPs to load cubes for reporting purpose.
• Involved in production support and peer review activity.
• Closely worked with SAP basis team to schedule process chains in production environment.
• Responsible for analyzing the business requirements by collecting the Business Requirements from the end users.
• Providing adhoc reports through executing SQL queries in db2 database.
• Involved in unit testing and several cycles of system integration testing.
• Created SAP BO (infoview) reports using existing universe.
• Created reports using horizontal tables, vertical table, cross tables, dimension, measure and filters.
• Customized the automatically generated back end SQL queries in BO.
• Done testing during migration from desktop intelligence reports to web intelligence reports in BO.
• Changed and selected correct universe during testing.
• Worked in normal bar chart, grouped vertical bar chart with multiple measures.
• Generated prompt so that BO reports can take the inputs during execution time.
• Configured page layouts and used variables during BO report design.

Environment: Data ware housing work bench, SAPBI, SAPBO, Windows XP, putty, db2

Confidential

Responsibilities:

• Interacted with Confidential Users and gathered requirements for the Reports while working as a onsite coordinator from China location during the execution of Confidential project from China location.
• Worked as senior PL/SQL developer and Shell script developer during development and UAT phases of Customer statistics and Customer satisfaction survey projects.
• Worked as tester with client testing team before delivery of customer statistics project to check whether the dashboards created in OBIEE is correctly working or not.
• Reviewed User Requirements. Created detailed Design Documents for the reports.
• Conducted weekly meetings to gather the necessary requirements from clients.
• Created temporary table, views, GTTs, materialized view and stored procedures.
• Created synonyms, anonymous blocks, indexes and done query optimization with oracle hints.
• Analysis of explain plans to go through costs at different levels of query.
• Involved in peer review and onsite coordination activities.
• Created Test Plans, Test Scripts and Perform the testing for data conversion process during all phases of Testing Starting from Unit, System, Integration and UAT
• Involved in developing logics for cross sell, up sell, new business and attrition using PL/SQL cursors, temporary tables and exception handlings.
• Written several wrapper Shell scripts to call stored procedure.
• Involved in version control activity through PVCS
• Involved in full project life cycle implementation (requirement gathering to production phase).

Environment: Oracle 11g/10g, SQL, PL/SQL and Windows XP.