SUMMARY:

• Around 8 Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 9i/10g, 11gR1 and 11gR2, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
• Hands on experience in defining Technical Requirements for ETL processes and developing Complex Mappings to load data into enterprise data warehouse and data marts.
• Excellent hands on experience in the entire Life Cycle of Data warehouse/Business Intelligence, designing and developing ETL objects, performance tuning.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements.
• Created materialized views like primary key, rowid, and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Powercenter (9.x/8.x).
• Experience in creating Complex Spotfire Dashboards, Reports Using Tibco Spotfire Professional Client (Analyst), TIBCO Web Player Client (Consumer), Regression and Predictive Modeling using TIBCO TERR and Automation Server.
• Expertise in development of ETL flows using Information Builders iWay Data Migrator and development of reports using WEBFOCUS Developer Studio.
• Extensively worked on data warehousing and decision support systems with relational databases such as Oracle design and database development using SQL, PL/SQL and TOAD.
• Experience with Unix Shell Scripting (KSH - Korn Shell Scripting).
• Hands on experience in tracking down the bottlenecks in query using trace files.
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Strong Background in implementation of RDBMS concepts.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Ability to learn new tools, concepts and environments.
• Ability to explain technical concepts and communicate with users and system administrators at all levels.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX

Languages: JAVA, C, SQL, PL/SQL

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, iSQL*Plus, SQL*Loader

Development Tools: Developer 11g/10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g

ETL Tools: Informatica Power Center 8.1/7.1, iWay Data Migrator

Reporting Tools: WEBFOCUS Developer Studio, TIBCO Spotfire

Scripting Languages: Java Script, UNIX Scripting

Web Technologies: HTML

PROFESSIONAL EXPERIENCE:

Confidential, NY

Senior Technical Architect

Responsibilities:

• Extensively worked on understanding the business requirements and designing iWay Data Migrator ETL jobs, Spotfire Analytics and Oracle PL/SQL Packages, Procedures and Functions.
• Implemented dimensional models (logical and physical) for all the data marts.
• Created mapping document for source to target.
• Developed PL/SQL Packages to extract the data from the source systems.
• Developed iWay Data Migrator Synonyms, Flows and Procedures to extract and load the data from source system and load into DW.
• Developed Spotfire Information Links using Information designer.
• Developed Spotfire Analytics reports and Dashboards using Spotfire Professional Client (Analyst)
• Successful in developing SQL Scripts, database objects, procedures, functions and packages to check supplied data for sense, consistency and accuracy.
• Perform code review and make changes/improvements as required.
• Ability to develop unit test documents and perform unit testing to ensure overall functionality and technical quality of deliverables.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Develop Functional Specifications, high Level Design documents
• Data Modelling through Generic Data Modelling, Dimension-Fact/Star Schema Modeling.
• Worked on testing and gathering statistics and monitoring the run times for the performances and fixing it.
• Worked on Business support activities
• Develop and handle Migrations from source to destination

Environment: Oracle 11G, PL/SQL, PLSQL Developer, iWay Data Migrator, WEBFOCUS Developer Studio, TIBCO Spotfire

Data warehouse Developer

Responsibilities:

• Analyze the functional & technical requirements and of the project.
• Discuss with business users, BA's and UI Architects to finalize requirements and scope of the project.
• Design the Database and ETL framework for the new enhanced UI for SCT tool
• Design and provide Database service call contracts to Java/UI team
• Provide development, CUT, and SIT estimates to project services team
• Create functional and technical documents.
• Create new tables, views, materialized views, Packages, Stored Procedures and functions as per the requirements.
• Data modeling and design of data warehouse and data marts in snowflake and star schema methodology with confirmed and granular dimensions and FACT tables.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Perform code review and make changes/improvements as required.
• Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance.
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
• Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams like DBAs, Unix Admins, Informatica Admins etc.
• Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per mappings.
• Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.
• Ability to trouble shoot technical issues and problems, monitor progress against plan, and communicate status to Leads.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Designed Database Triggers for audit and validation purpose.
• Migration from Oracle 10g to Oracle 11

Environment: Oracle 11.0.2, Oracle 11G, PL/SQL, PLSQL Developer, Windows Server 2008, Perl, Unix

Oracle PL/SQL Developer

Responsibilities:

• Used the merge statements to select rows from one or more sources for update and insertion into one or more tables.
• Used PL/SQL collections (Nested Tables and Varray) in complex backend packages.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan documents for all back end database modules.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Wrote Database triggers for audit and to implement complex business logic.
• Discussed and analyzed business functionality with the client and the developers.
• Involved in the database design for better understanding the relations, associations and dependencies within the data base.
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Involved in writing functional and technical documents.
• Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
• Wrote complex SQL queries to retrieve information from the database depending on user requirement.
• Created PL/SQL program units to implement DML, DDL statements using dynamic SQL.
• Developed Procedures and Triggers for Oracle Forms and Reports.
• Wrote control files and loaded the data into oracle database with SQL*Loader.
• Used PL/SQL Developer tool to do the backend development.
• Wrote complex oracle SQL using joins, sub queries and correlated sub queries.
• Implemented Materialized View for extracting the data from remote database.
• Handled various Exceptions to trouble-shoot PL/SQL code.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2, Toad 7.5.2.0, UNIX.

Data warehouse Developer

Responsibilities:

• Analyzed the system, met with end users and business units in order to define the requirements.
• Wrote SQL Queries, Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the Business Rules.
• Extracted the data from Oracle, SQL Server, Flat files and load into Data warehouse.
• Extracted source data using Power Exchange from Legacy systems.
• Translated business requirements into Informatica mappings/workflows
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Creating Stored procedures for loading the staging tables.
• Designed and developed number of complex mappings, mapplets and reusable objects for the credit marketing systems to facilitate daily and monthly load of data
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Developed MLoad and BTeq scripts to load the data into Teradata.
• Worked with Mapping variables, Mapping parameters and variable functions like set variable, Count variable, set minvariable and set maxvariable.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Review high level business reqs, technical specs, data mapping documents and create detailed test cases.
• Migrated existing mappings to production environment.

Environment: Informatica Power Center 8.1, Oracle 9i, PL/SQL,SQLServer2005,Teradata V2R5 1.2, Toad, Windows NT,UNIX .

ETL Developer

Responsibilities:

• Majorly involved in development, and maintenance for ETL (Extract, Transform and Load) process using Informatica Power Center.
• Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements.
• Extensively used Power Center designer to develop complex mappings using transformations like Source Qualifier, Lookup (connected & unconnected), Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier to implement simple and complex business logic.
• Implemented slowly changing dimension Type 2 and Type 1 for accessing the full history of accounts and transaction information.
• Developing Mappings as per the design document with naming conventions using Informatica Best Practices.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets, shortcuts and Transformation objects.
• Extensively used mapping parameters and variables for incremental loading of data and session parameters for migrating workflows.
• Involved in performance tuning of source, mappings, sessions, workflows and identifying the bottlenecks.

Environment: Informatica Power Center 7.1, Solaris, Windows XP, Oracle 10g/9i, PLSQL, SQL Server2005, T-SQL.

Oracle Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL*Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Oracle 8i,SQL SERVER 2000,SQL, PL/SQL, Windows 2000.

Programmer

Responsibilities:

• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Designed tables, indexes and constraints using SQL*Plus and loaded data into the database using SQL*Loader.
• Developed Stored Procedures and functions to accomplish several computations.

Environment: Oracle 7.1 using UNIX, Windows NT and Windows 95.