PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Custom Applications using Oracle Databases and tools in Unix and Windows Environment.
• Strong knowledge and experience in Software Engineering and Database Management System.
• Strong working knowledge of Oracle 11g/10g/9i/8i, SQL, PL/SQL (procedures, packages, functions, database triggers), Teradata.
• Expertise in developing SQL & PL/SQL codes through various procedures, functions, packages, triggers, views and indexes to implement the business logics of database.
• Experience in working with Oracle Forms and Oracle Reports.
• Experience in loading data, troubleshooting, Debugging mappings, performance tuning of procedures and SQL queries.
• Expertise in operation of various database objects, such as Tables, Views, Indexes, Constraints, Materialized Views etc.
• Experience in using DDL and DML objects.
• Strong experience in design and development of ETL process from Staging to Data warehouse and to Data mart.
• Experience in Data modeling using Relational (Normalized), Dimensional Data Modeling (De - Normalized), Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.x.
• Experience in using OLAP/OLTP concepts for data stored in the data base.
• Expertise in Query Writing and Reports generation.
• Expertise in utilizing Oracle Utility tools like SQL*Loader, Import and Export.
• Experience in writing UNIX shell scripts and automated the entire processes using UNIX shell scripting.
• Experienced in working with different sources like Flat Files and varied RDBMS.
• Experienced in working with various SQL Editors such as TOAD, SQL Plus, and PL/SQL Developer.
• Strong knowledge of Object-Oriented software engineering methodologies, Object-Oriented Analysis and Design, Design By Contract, UML, Use-Case-driven development, the Unified Software Development Process, the full Software Development Life Cycle (SDLC), and extreme Programming.
• Good Business knowledge in telecommunications, Hospitals, Banking and Capital marketing, manufacturing domains.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Ability to work on multiple tasks and deliver the results within estimated budget and time.
• Expertise in documentation of the processes and other application related manuals to support production activities.
• Strong analytical, problem solving and communication skills with strong focus towards goals and work ethics.

TECHNICAL SKILLS:

Database: Oracle 11g/10g /9i /8i, Teradata 5.0

Operating Systems: UNIX, Windows 95/NT/2000/XP, LINUX

Programming Languages: SQL, PL/SQL, Unix Shell scripts, HTML, XML, Java, J2EE, C, C++, UML

Database Tools: TOAD, SQL Plus, PL/SQL Developer

Reporting Tools: Oracle Forms 10g 9i 6i 6.0, Reports 10g 9i 6i 6.0, Crystal Reports

ETL Tools: Informatica Power Center 8.5 8.1.1 7.1 6.2

Data Modeling Tools: Erwin 4.0/4.1

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

ETL Data Analyst

Responsibilities:

• Actively involved in design, analysis, developing, testing and performance tuning.
• Extensively involved in Creating/coding reports that meet user requirements, validating reports, supporting data and technical requests, and supporting strategic data analysis. Analyze, extract, transform, load, and integrate data into consumable formats, meeting all critical milestones using data warehouse techniques.
• Code Review of mappings from Source to Staging and Staging to Warehouse.Modified the existing code of SQL queries for data warehousing tests, data extracts and executive information requests as per the new requirements.
• Worked on Extracting, cleansing, aggregating, transforming and validating the data to ensure accuracy and consistency.
• Used SQL *Loader to Bulk load the data from the flat files to database.
• Extensively worked on Performance Tuning and thereby improving the load time.
• Extensively used Pl/Sql for analyzing packages, procedures and functions.
• Involved in constructing complex SQL queries with sub-queries, inline views as per the functional needs.
• Used Clear Case for Configuration management and revision control of the Source code.
• Involved in Data modeling and design of data warehouse in star schema methodology.
• Used ERWIN for designing Entity Relationship diagram.
• Actively ensured the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, PL/SQL Developer, TOAD 8.6.1, Erwin 4.1, Windows XP, SQL * Plus, SQL* Loader, Clear case, Oracle Reports.

Confidential, Bedford, NH

Data Analyst

Responsibilities:

• Involved in the full system development life cycle of the system.
• Designed and created custom tables that are required to hold customer registration data.
• Actively participated in the process of creating the Technical Design Specifications document for the custom system.
• Created SQL*Loader scripts to load the customer registration data from SalesForce.com into custom tables.
• Programs and custom packages were written in PL/SQL to create / update customer data.
• Wrote PL/SQL programs to create Sales orders for applicable customers were written, Order Management’s standard interface tables were used to create sales orders.
• Designed and developed a few reports, such as “Customer Listing”, “Install Base status report”, etc., using Oracle Reports.
• Used Oracle Forms a custom form was created to enable SEGWAY to identify and fix customer registration data.
• Coded all the PL/SQL Procedures for the backend batch processes.
• Created Entity Relationship diagrams using ERWIN 4.0.
• Used Control M for scheduling the scripts.
• Coded reports in PL/SQL and returned the result sets to Crystal Reports.
• Created regular reports and Ad Hoc reports using Crystal Reports.
• Modified and defined database objects as per requirements.
• Defined database application specifications, authored scripts, created program specifications and SQL code, developed test plans and produced necessary documentation for the data migration project.

Environment: Oracle 10g, SQL, PL/SQL, SQL * PLUS, SQL Developer, Oracle Reports, Oracle Forms, Crystal Reports XI, Erwin 4.0, Toad 8.6.1.

Confidential, SanFrancisco, CA

Data Analyst

Responsibilities:

• Involved in design, development, customization and integration of workflows, reports, and interfaces as per the business requirements.
• Involved in business process re-engineering and implementation of the support system.
• Designed and developed distributed project management, Web-based tool to automate the tasks associated with the software development process.
• Responsible for code installation and maintenance of production systems.
• Responsible for creating the scripts for the custom interfaces, reports and programs based on the business requirements.
• Involved in Automation of certain process in order to reduce 4-6 Hrs of manual effort in monitoring the production system.
• Authored extensive SQL, PL/SQL stored procedures, oracle packages, ETL programs, partitioning, materialized views, functions and triggers, and SQL*Loader programs to perform data migration while preparing Source Staging, Migration Staging and Target environments.
• Involved in Data modeling and design of data warehouse in star schema methodology with conformed and granular dimensions and FACT tables.
• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures
• Logged all transactions and generated exhaustive reports to identify process performance ratio, errors prioritized, and percentage of success and failure reports etc in an understandable cross-matrix layout enabling Business Intelligence staff to perform gap analysis.
• Implementing the backup procedures like exporting the schemas, hot backups and cold backups.
• Involved in analysis of bugs, defects, problems and issues in the production system.

Environment: Oracle 9i/8i, SQL, PL/SQL, SQL * Loader, UNIX, PL/SQL Developer, Toad, Erwin 4.0, Windows, Java, J2EE, XML, HTML.

Confidential, Monrovia, CA

EDW Database Analyst

Responsibilities:

• Responsible for Analysis, Design, Development, Testing, Implementation, and Post Production Support of the System.
• Responsible for Implementation and Maintenance of Reports.
• Involved in the Creation of Table Scripts, Views and Tuning of SQL.
• Responsible for writing Packages, Procedures, Triggers using Oracle Pl/sql.
• Responsible for creating Test Scripts and Test Scenarios for the Oracle Reports & Interfaces.
• Extensively worked on Performance Tuning and thereby improving the load time.
• Involved in System Integration, System & User Acceptance Testing of the Oracle Reports.
• Created new Reports using Reports 6i.
• Designed GUI screens and reports using Developer 2000 and are being migrated to Developer 6i (Forms 6i &Reports 6i).
• Extensively used SQL * Loader, Informatica tool to extract, transform and load the data from Oracle Database, Flat Files.
• Extensively worked on tuning and thereby improving the load time.
• Developed Oracle and Teradata queries to replace current data ware house reports.
• Extensively used PL/SQL for creating procedures and functions.
• Automated the entire processes using UNIX shell scripts
• Used Autosys to schedule UNIX shell scripts, PL/SQL scripts and Informatica jobs.
• Wrote UNIX Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Involved in the development of Informatica mappings and also performed tuning for better performance

Environment: Oracle 9i/8i, SQL, PL/SQL, Toad, Oracle Forms 6i, Oracle Reports 6i, UNIX, Informatica Power Center 6.2, Teradata Sql Assistant, Business Objects, Windows, Autosys, Clear Case.

Confidential

Business Reports Analyst

Responsibilities:

• Worked with different clients to deliver new products, upgrades and program fixes.
• Involved in Tuning, Performance, and Optimization of queries and standardization of the code.
• Planned the index rebuilding, index analyze and table analyze on periodical basis
• Resolved application problems to maintain high level of customer satisfaction.
• Created SQL*Loader scripts and Oracle external tables.
• Developed complex shell scripts for backup, rotating logs/files, etc.
• Managed tables, indexes, constraints, views sequences, synonyms and stored program units.
• Used Packages UTL FILE, DBMS JOB, DBMS PROFILER.
• Created Stored Program Units in the Functions, Triggers and procedures for implementing complex database intensive business rules.
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• Coded PL SQL cursors for transaction processing.
• Implemented triggers based on the business rules.

Environment: Oracle 9i, Oracle Forms 6i, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), SQL*loader, Stored Procedures/Triggers, XML, Windows.

Database Analyst

Confidential

Responsibilities

• Designed the data model for Web Trader module based on the analysis.
• Developed PL/SQL Packages, Procedures, Functions.
• Tuning of SQL Statements using TOAD Optimizer.
• Standardizing names for source, target and transformations for Web Trader module development.
• Involved in performance tuning of Sources, Targets and Mappings. Improved performance by identifying performance bottlenecks and tuned various jobs at session level.
• Used PLSQL stored procedures and functions to perform specific task (like mathematical calculation, date calculation).
• Compared data between the source and the target data base using shell script.
• Create the Shell Scripts to run the batch scripts through CRON jobs.
• Involved in Business Object reports analysis design, development, quality control testing, integration and deployment.
• Involved in the testing like Unit testing, fixing bugs for problems in QA testing and moved application to QA.

Environment: Oracle 8.1.7,Pl/SQL Forms 4.5/5.0, Reports 2.5, 3.0.