SUMMARY

• Over 6 years of IT experience spanning Applications Development, Support, Database Design & Development using Oracle technologies in various domains like Banking Finance, Insurance and Healthcare
• Extensive Knowledge in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams
• Experienced in Designing, Developing and Delivering Informatica Data warehousing project
• Extensively used QUEST Tools (TOAD, TOAD Data Modeler, Navigator) and SQL Developer, PL/SQL Developer, Erwin Data Modeler, SQL*PLUS
• Experienced in data extraction, transformation and loading data using Informatica Power Center 9.0.1, 8.6, 8.3 (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor)
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts
• Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory.
• Experienced in scheduling the jobs using Autosys and Crontab and monitor the batch processing.
• Experienced in writing SQL queries creating different kinds of reports from large scale database.
• Experienced in designing of Dimension modeling, Star Schema, and Snowflake schema
• Experienced in creating Sessions, Workflows, and Worklets by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer
• Designed and developed Informatica mappings for data loads and data cleansing.
• Integrated sources from different databases and flat files.
• Experience in various kinds of the transformations to implement simple and complex business logic. Transformations used: Remote Procedure, Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters, Sequence Generator
• Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Experienced in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Possess expert skills in the development of applications utilizing Oracle tools including Oracle PL/SQL, SQL Plus and utilities like SQL Loader, export/import, SQL trace, XML and data pump.
• Experience with PL/SQL back - end programming - Database Triggers, Packages, Stored Procedures, Functions, DB links, Materialized views and Management of Schema Objects on Windows & UNIX Platforms.
• Hands on experience on Oracle 10g features like SQL MODEL clause, dynamic SQL, analytical functions, WITH statement, Exists clause and Rollup.
• Knowledge of using Oracle supplied package like UTL FILE, DBMS JOBS and DBMS SCHEDULER.
• Hands-on experience in implementing various query-optimization techniques (Performance tuning using indexes, explain plan, Hints).
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Experience of onsite - offshore model.
• Excellent communication and interpersonal skills. Versatile team player with proven problem solving skills, user interface (UI) work and motivated to learn more and good inter-personal skills. Ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

Databases: ORACLE 7.3, 8i, 9i, 10g, 11g, MS SQL server2008,2005

Languages: PL /SQL, T-SQL, SQL*Plus, XML, C++, Unix Korn shell scripting

Platforms: Windows Vista/XP/2000/NT, UNIX (Solaris 5.8,5.9)

GUI Tools: Oracle PL/ SQL developer, TOAD, Rapid SQL

File Transfer Tools: FTP, Putty, Secure Shell SSH client 5.3

Dimensional Data Modeling: Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables

Data Modeling Tools: Erwin 4.0,Oracle Designer 10g

ETL Tools: Informatica Power Center 9.1/8.6/8.6.1,Informatica Designer, Workflow Manager, Work flow, Informatica Power Connect

Utilities: SQL * Loader, Export/Import, Data pump, Explain Plan

Domain Knowledge: Finance, Manufacturing, Healthcare and Insurance.

PROFESSIONAL EXPERIENCE

Confidential - NC

Oracle Pl/SQL Developer

Responsibilities:

• Involved in gathering business requirements, clarification and system design.
• Extensively worked in End-to-End phases of the application design, development, testing, production deployment and documentation.
• Prepared proto-types for the system design & approach and participated in business users presentations.
• Implemented RDBMS (normalization) concepts in Data modeling.
• Developed PL/SQL packages, procedures, functions, Indexes, SQL scripts for the implementation of the very complex business requirements.
• Wrote Complex SQL script, Analytical Function using Cursors, Bulking techniques, Collections, Dynamic SQL.
• Used exception-handling methods along with RAISE APPLICATION ERROR in order to associate our own created exception names.
• Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application jobs execution.
• Involved in Source code release to higher environments (QA, UAT and Production) using Tortoise SVN version control tool.
• Developed PL/SQL packages and database triggers and Improved performance of the extract - loads and existing applications for huge volumes of data by optimizing the queries, indexing and redesigning some of the scripts.
• Participated in Performance Tuning using Explain Plan.
• Extensively supported production for all the UNIX, Autosys issues.
• Used Cron Jobs and Autosys jobs to schedule various reports.
• Involved in Loading Oracle tables from flat files using SQL *Loader with appropriate control file.
• Prepared test data and expected results for the system testing with possible business functional scenarios to make the system bug-free.
• Involved in System testing, Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and walkthroughs.

Environment: Oracle 11g/10g, TOAD, PL/SQL Developer, Unix K - shell, SQL *Plus, SQL*Plus, SQL Loader, WINSCP, PUTTY, Autosys, Tortoise SVN, Clear Quest, Erwin.

Confidential, FL

ETL and Pl/SQL Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirements and Specification.
• Used Rapid SQL to write complex queries against Oracle and Sybase databases, validated warehouse data with Operational Databases to make sure import ran correctly.
• Created complex mappings for fact and dimension tables using the various transformations that involved implementation of Business Logic to load data from multiple sources into Operational Data Store (staging area) and then load into Teradata based Data Warehouse.
• Extensively used Router, Lookup, Aggregator, Expression, Update Strategy & Normalizer transformation.
• Developed mappings to load Fact and Dimension tables, for Type 1 and Type 2 dimensions and Incremental loading and unit tested the mappings.
• Coordinate and develop all documentation related to ETL design and development.
• Used the update strategy to effectively migrate data from source to target.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplet.
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and setup email delivery after execution.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.

Environment: Informatica PowerCenter 8.1, Oracle 8i, Toad, SQL*PLUS, MS SQL Server 2005, SQL*Loader, Putty, Windows XP, MS Outlook, SecureCRT, ERWIN

Confidential, Owings Mills, MD

ETL and Oracle Pl/SQL Developer

Responsibilities:

• Participated in Data Modeling (logical and physical) and Star/Snow Schema for designing the Data Marts for Business users.
• Created Informatica mappings with SQL procedures/functions to build business rules to load data. Transformations used were Source qualifier, Aggregators, Connected & Unconnected lookups, Expression, Filters, Sequence, Router and SQL
• Developed Technical Design Documents for implementation.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width) and Excel files to staging database and from staging to the target Oracle database.
• Implemented SQL and TSQL scripts in accordance with the necessary Business rules and procedures
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center
• Setting up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager
• Monitored the status of Workflows/Worklets/Sessions in Task view mode using Workflow Monitor.
• Used SQL tools like SQL Navigator, Rapid SQL to run SQL queries and validate the data in warehouse.
• Involved in Unix Shell Scripts for automation of ETL process
• Error Handling: Handled in Informatica Mappings & sessions and also through Validation Scripts

Environment: Informatica PowerCenter 8.1, Oracle 8i, Toad, SQL * PLUS, MS SQL Server 2005, SQL *Loader, Putty, Windows XP, MS Outlook, SecureCRT, ERWIN

Confidential

SQL Developer

Responsibilities:

• Designed business models that use large amounts of data to find solutions to business questions for customers and other stake holders
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS.
• Created reports that call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Created several packages in SSIS.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Optimized queries using SQL Profiler and Database engine tuning advisor.
• Developed UNIX Cron job scripts to automate the load process to be in synch system
• Setup and enable AstraZeneca to do secure file transfer with its customers.
• Migration of customer implementation to production from pre-production after testing the setup
• Supporting day to day business related to Secure File Transfer.
• Plan, schedule and execution of Business Continuity Plan for Cyclone TRACE run services project.

Environment: Synchrony Gateway Interchange (Cyclone), Secure Relay, Sentinel, SQL Server 2005 Enterprise Edition, SSIS 2005, SSRS 2005, Sybase 15.0.3, SQL Developer, Embarcadero Rapid SQL 7.4.2, SQL Loader, BCP, Serena ChangeMan Version Manager 8.1, Putty, Windows XP, Outlook, CuteFTP 8.0 Prof, SecureCRT, MS Visio 2010