Home

AYYO SRI - IBM OPTIM DEV

[email protected]

Location: Woodinville, Washington, USA

Relocation: WA

Visa: GC

Summary: Over 16+ years of IT experience in Analysis, Design, Development and Implementation of Oracle, IBMs Optim Integrated Test Data Management and Business Objects. Expert in archiving Oracle, DB2 (UDB, DB2/400, DB2 for z/OS), IMS, MySQL, Sybase and SQL Server applications using Optim. (Archived 200+ databases). Familiar with archiving Mainframe applications using Optim. Experience in extraction, transformation, cleansing, and loading of large data sets (ETL). Extensive experience in query optimization, indexing, and performance tuning of Optim archive data. Expert in creating integrated views of information across heterogeneous sources and DG4ODBC sources to provide a simplified data model, hiding information complexity from business users. Strong database application development skills using SQL, PL/SQL. Installation, configuration, and upgrade experience (including automated response file) on both symmetrical multi-processing (SMP) and massively parallel processor (MPP) servers with enterprise storage area networks (SAN) including VMware virtual machine servers and multiple DB2 versions. experience in using Business Objects Enterprise products (Business Objects Designer, Business Objects Reporting, Business Objects Enterprise XI 3.1/3.0/R2, Business Objects Supervisor, Web Intelligence, Info View, Business Objects Data Integrator and Scheduling the reports using Broadcast Agent Publisher (BCA)). Installed & Configuration of Business Objects XI 3.1/3.0/R2 with CMS on Windows and AIX Platform. Created Canned Reports, Complex Ad-hoc Reports using Business Objects and Web Intelligence tools. Designed and implemented a database application for scientific document analysis. Excellent working and conceptual knowledge of Oracle, PL/SQL, Developer Forms 10g/9i, and Reports 10g/9i. Extensively worked on Backend Programming using PL/SQL Stored Procedures, Functions, Packages, Database triggers for Oracle 11g/10g/ 9i/8i, and also SQL queries/reports and scripts. UNIX shell scripts for Cron jobs and for automating batch programs Experience in using SQL TRACE and TKPROF tools for Explain Plan, SQL tuning, creation of indexes for faster database access and indexing the required columns Involved in Production Support (24/7). Extensive experience in generating reports including graphs, invoice, audio files from archive databases using Attunity, Web, BO, APEX, SSRS, MS Access, excel as per Legal, SOX, Business team requirements. Experience in Performance Tuning, Backups, Restores and Monitoring experience. Applied retention period using Vormetric to lock the archive files. Maintain/Implementing/Document Business Rules, Provide Communication and Planning for customers as per the requirements. Education: Master of Computer Applications from University of Madras, India Technical Proficiency: Applications/Tools: Optim 11.3/9.1/8.1/7.3.1/7.3.0/7.2.0, Attunity Connect Studio, Optim Connect Studio, Nav_util, Chap View, DB Visulizer, Data Direct ODBC Drivers, Vormetric encryption, VMWare Server Business Objects Enterprise, Crystal Reports, DB Visualizer. Database: Oracle 8i/9i/10g/11i, SQL Server 2000/2005, MySQL, DB2/AS400, DB2 UDB, DB2 for z/OS, IMS, SQL*Plus, SQL*Loader, PL/SQL, ODBC, DG4ODBC, HSODBC, T-SQL, SSIS, SSRS, Sybase, MS Access, TOAD for Oracle, ERWIN, TOAD data modeler, Oracle Application Express (APEX)3.0,3.1,4.0,4.1,19.1,20 Programming Language: UNIX Shell Scripting, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, C, C++. Operating Systems : Windows NT/XP/00, MS-DOS, Solaris, Linux, AIX. Packages : MS Office. Professional Experience: AT&T, WA Mar 14- Till Date Sr. IBM Optim Architect/Sr. Oracle DBA Enterprise Archive Solutions (EAS) is the AT&T standard repository for the databases of retired applications and live applications. The data is retained to support legal and auditing requirements across the enterprise. EAS also tracks legal approvals, data retention periods, and storage savings from application retirement. Basic archival and limited data access is provided free of charge to retiring applications and paid for by storage cost savings. Here is to build and maintain the Optim production environment, interact with application manages, subject matter experts, technical team members to understand the application, archive, encryption requirements and retention policies, extract data from production environments. I ve archived 100+ applications from various relational and non-relational data sources. Responsibilities: Gathered Customer, User and Owner requirements analyzed and documented them. Gather requirements for Test Data Management (TDM) and Data Archival. Installed and configured Optim, Optim Connect Studio in Production and QA/Stage environments. Installed oracle database and client and apex in production and QA/stage environments. Installed, configured and migrated from optim 9.1 to 11.3 version. Configure the database and update the configuration file in apex. Configured Optim configuration, Optim, *.cfg files and Optim connect studio. Created Optim directories, Db Alias using different databases like Oracle, Sql Server and Sybase. Created Archive request and access definition using Optim and EAS Web tool. Created table map, insert and load request for restore process. Encrypt or Mask sensitive data without losing the relationship according to the audit and legal requirements. Extracted data subset from production database for testing environment. Staged legacy application data and archived from the staging database and source data bases. Worked with Optim support team (IBM) to resolve the archive data access issues with BLOB, NText, Nvarchar, XML, Row id and Image data types. Extensive experience using data subsetting and masking techniques and developing solutions using IBM Optim Masked several SPI/PCI (SSN, Credit Card, DOB, EMAIL, Personal info, etc..) data fields Good knowledge of the masking features and data compliance regulations in large scale enterprise. Encrypt or Mask sensitive data without losing the relationship per the audit and legal requirements. Created column mappings to mask SSN, Credit Card numbers, DOB, Member ID, ZIP CODE, etc. Fields across various applications. Data Masking, Data Creation, Masking of sensitive fields and loading of the masking data to non-production environments. Understand Masking features and data compliance regulations in large scale enterprises. Applied timely OPTIM Patches and Fix-Packs on all the Platforms. Installed and configured DG4OGBC, HSODBC components to access MS SQL, DB2, Optim, ODBC data sources. Verified the archived data using SQL developer, TOAD, Apex, CHAP View, DB Visualizer and Nav_util. Using PHP code to retire the CLOB and BLOB data in Oracle Apex. Using DB Visualizer to retrieve CLOB and BLOB data from ODBC data sources using JDOBDC. Created interactive reports using Oracle Application Express. Created databases, views, users and gave access to users in SQL Server. Created Windows DSN to create the Optim Directory and DB Alias using SQL Server and SY BASE. Take the backup of *.cfg files, Optim connect studio, rtsetenv, rt4s and rtserver in Solaris and Linux. Update the *.cfg files using Optim directory, DB Alias, Database info in Solaris and Linux Environments. Bounce the Optim Server after the update the *.cfg files. Worked with PDBA for mylogin tickets and AOTS tickets for create the Non-Attuid accounts in database. Applied encrypted code on archive files in every month ending. Working with Legal, SOX and Business teams to understand reporting requirements and build APEX reports from archive data. Instance and database monitoring and tuning experience using the DB2 Health Center, Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools. Database and SQL statement access plan optimization experience with DB2 s Explain, Visual Explain, and Design Advisor tools. Running diagnostic tools to identify database performance bottlenecks and taking appropriate corrective actions to improve database performance. Working with development teams to tune SQL queries. Troubleshooting Oracle performance and non-performance related issues independently and in conjunction with other DBAs. Partitioned tables using the new partition features of 11g/10g for performance improvement. Involved in testing and tuning SQL, stored procedures, and functions; analyzing the database schema including indexes and views to suggest optimization; analyzing and tuning the Oracle installation to ensure optimum performance. Tuning the SQL queries using explain plan. Recreated the database links, created profiles, configured row-level security VPD to provide more secure environment for controlling access to databases. Developed PL/SQL packages to retire the archive data for improve the performance of validation queries Created Optim indexes, views, and tuned the queries for data access of users. Create Oracle, APEX, Excel, MS Access, SQL Server Interfaces for the users to access the archived data. Created Interactive reports using Oracle Apex Express. Created different Items like date functions, shuttle, drop down boxes and list of values in Oracle Apex Express. Created materialized views to pointing source if we did not archive data. Worked with FileNet team for unstructured data like PDF, DOC and non-structured flat files. Analyzed unstructured data, flat files, CSV and XML files and design a database according to the user requirement to store them into the database. Worked with Oracle support to resolve the APEX and Oracle datatype issues. Environment: Optim 11.3, 9.1, Optim Connect Studio 5.3.3, Vormetric encryption, Oracle 11g, SQL server 2008, SSIS, SSRS, Sybase, DB2/400, DB2 UDB, DB2 for Z/OS, IMS, MySQL, PL/SQL, MS Access, TOAD, ODBC Drivers, DG4ODBC, HSODBC, SQL*Loader, Solaris, VMWare Server, Windows 2003. Express Scripts, MN May 13- Feb'14 Sr. IBM OPTIM Developer System Retirement Team is the Express Scripts (ESI) standard repository for the databases of retired applications. The data is retained to support legal and auditing requirements across the ESI. ESI tracks legal approvals, data retention periods, and storage savings from application retirement. Here is to build and maintain the Optim production environment, interact with application managers, subject matter experts, technical team members to understand the application, archive, encryption requirements and retention policies, extract data from production environments. I ve archived from various relational and non-relational data sources. Responsibilities: Installed and Configured Optim, Optim Connect Studio in Production and Pre-Prod and Pilot environments. Created software architecture and detailed design for various projects. Created different type documents like Technical specification, Unit Test, User Acceptance, Solution Design documents and Production Deployment documents. Applied timely OPTIM Patches and Fix-Packs on all the Platforms. Migrated data from DVD into SQL Server and Oracle 11g. Created Archive request and access definition using Optim. Created table map, insert and load request for restore process. Installed and configured DG4OGBC components to access MS SQL, DB2, Optim, ODBC data sources. Automated Oracle database analysis using korn shell and Perl scripts. To speed up the archive process we also built a web tool to automate the archive process, build table mappings, analyze the databases, archive the applications and provide ODBC, SQL, Oracle interface to access the archived data. Developed PL/SQL packages to maintain and control the sunset archive process, database driven notification system and database security strategy. Encrypt or Mask sensitive data without losing the relationship according to the legal requirement. Extracted data subset from production database for testing environment. Staged legacy application data and archived from the staging database. Working with Legal, SOX and Business teams to understand reporting requirements and build Crystal reports from archive data. Developed PL/SQL packages to load the invoice images into database. Created Optim indexes, views, and tuned the queries according to the user requirement. Configure Optim Connect Studio entries and create HSODBC connections. Create Oracle, Excel, MS Access, SQL Server Interfaces for the users to access the archived data. Designed and implemented a database to store the application archive requirements, approvals, modifications, and archive access details. Developed a shell script to generate the archive and access definitions for Optim. Analyzed unstructured data, flat files, CSV and XML files and design a database according to the user requirement to store them into the database. Monitor logs, debug errors and contact Oracle and Optim support team for support. Environment: Optim 9.1, Optim Connect Studio 5.3.3, Oracle 10g/11g, SQL server 2008/2012, SSIS, SSRS, DB2/400, DB2 UDB, DB2 for Z/OS, MySQL, PL/SQL, MS Access, TOAD, Business Objects, ODBC Drivers, DG4ODBC, Crystal Reports, SQL*Loader, Linux, Windows 2008, DB Visualizer. AT&T, WA Aug 10- Apr'13 IBM Optim Developer/Oracle DBA Enterprise Archive Solutions (EAS) is the AT&T standard repository for the databases of retired applications and live applications. The data is retained to support legal and auditing requirements across the enterprise. EAS also tracks legal approvals, data retention periods, and storage savings from application retirement. Basic archival and limited data access is provided free of charge to retiring applications and paid for by storage cost savings. Here is to build and maintain the Optim production environment, interact with application manages, subject matter experts, technical team members to understand the application, archive, encryption requirements and retention policies, extract data from production environments. I ve archived 100+ applications from various relational and non-relational data sources. Responsibilities: Gathered Customer, User and Owner requirements analyzed and documented them. Installed and configured Optim, Optim Connect Studio in Production and QA/Stage environments. Installed oracle database and client and apex in production and QA/stage environments. Configure the database and update the configuration file in apex. Configured Optim configuration, Optim, *.cfg files and Optim connect studio (formerly Attunity Studio). Created Optim directories, Db Alias using different databases like Oracle, Sql Server and Sybase. Created Archive request and access definition using Optim and EAS Web tool. Created table map, insert and load request for restore process. Encrypt or Mask sensitive data without losing the relationship according to the audit and legal requirements. Extracted data subset from production database for testing environment. Staged legacy application data and archived from the staging database and source data bases. Worked with Optim support team (IBM) to resolve the archive data access issues with BLOB, NText, Nvarchar, XML, Row id and Image data types. Extensive experience using data sub setting and masking techniques and developing solutions using IBM Optim Masked several SPI/PCI (SSN, Credit Card, DOB, EMAIL, Personal info, etc..) data fields Good knowledge of the masking features and data compliance regulations in large scale enterprise. Encrypt or Mask sensitive data without losing the relationship according to the audit and legal requirements. Created column mappings to mask SSN, Credit Card numbers, DOB, Member ID, ZIP CODE, etc. Fields across various applications. Understand Masking features and data compliance regulations in large scale enterprises. Applied timely OPTIM Patches and Fix-Packs on all the Platforms. Installed and configured DG4OGBC, HSODBC components to access MS SQL, DB2, Optim, ODBC data sources. Verified the archived data using SQL developer, TOAD, Apex, CHAP View, DB Visualizer and Nav_util. Using PHP code to retire the CLOB and BLOB data in Oracle Apex. Using DB Visualizer to retrieve CLOB and BLOB data from ODBC data sources using JDOBDC. Created interactive reports using Oracle Application Express. Installed, configured and migrated from APEX 3.0, 3.1 to 4.0. Created databases, views, users and gave access to users in SQL Server. Created Windows DSN to create the Optim Directory and DB Alias using SQL Server and SY BASE. Take the backup of *.cfg files, Optim connect studio, rtsetenv, rt4s and rtserver in Solaris and Linux. Update the *.cfg files using Optim directory, DB Alias, Database info in Solaris and Linux Environments. Bounce the Optim Server after the update the *.cfg files. Worked with PDBA for mylogin tickets and AOTS tickets for create the Non-Attuid accounts in database. Applied encrypted code on archive files in every month ending. Working with Legal, SOX and Business teams to understand reporting requirements and build APEX reports from archive data. Instance and database monitoring and tuning experience using the DB2 Health Center, Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools. Database and SQL statement access plan optimization experience with DB2 s Explain, Visual Explain, and Design Advisor tools. Running diagnostic tools to identify database performance bottlenecks and taking appropriate corrective actions to improve database performance. Working with development teams to tune SQL queries. Troubleshooting Oracle performance and non-performance related issues independently and in conjunction with other DBAs. Partitioned tables using the new partition features of 11g/10g for performance improvement. Involved in testing and tuning SQL, stored procedures, and functions; analyzing the database schema including indexes and views to suggest optimization; analyzing and tuning the Oracle installation to ensure optimum performance. Tuning the SQL queries using explain plan. Recreated the database links, created profiles, configured row-level security VPD to provide more secure environment for controlling access to databases. Developed PL/SQL packages to retire the archive data for improve the performance of validation queries Created Optim indexes, views, and tuned the queries for data access of users. Create Oracle, APEX, Excel, MS Access, SQL Server Interfaces for the users to access the archived data. Created Interactive reports using Oracle Apex Express. Created different Items like date functions, shuttle, drop down boxes and list of values in Oracle Apex Express. Created materialized views to pointing source if we did not archive data. Worked with filenet team for unstructured data like PDF, DOC and non-structured flat files. Analyzed unstructured data, flat files, CSV and XML files and design a database according to the user requirement to store them into the database. Worked with Oracle support to resolve the APEX and Oracle datatype issues. Environment: Optim 8.1/7.3.1/7.3.0/7.2.0, Optim Connect Studio 5.3.2, Attunity Studio 5.3.2, Vormetric encryption, Oracle 9i/10g/11g, SQL server 2000/2005, SSIS, SSRS, Sybase, DB2/400, DB2 UDB, DB2 for Z/OS, IMS, MySQL, PL/SQL, MS Access, TOAD, Business Objects, ODBC Drivers, DG4ODBC, HSODBC, SQL*Loader, Solaris, VMWare Server, Windows 2003. Citi Bank, NJ Nov 08- Jul'10 Data Analyst Responsibilities: Gathered Customer, User and Owner requirements analyzed and documented them. Installed & Configured Business Objects Suite of Products XI 3.1/R2 on Windows Server. Modified and developed database triggers, cursors, procedures, functions and packages to meet business requirements. Involved in day to day maintenance of Business Objects Servers (such as Back up the BO XI repository). Extensively used Business Objects Designer to design and maintain Data warehouse Universes. Exporting universes to the repositories to make resources available to the users. Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects. Experience in migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SQL Server DTS. Developed PL/SQL libraries to share form-level procedures, functions, packages across different modules. The main responsibilities were database Performance tuning and Application tuning i.e Fine Tuning SQL and PL/SQL scripts and debugged the functionality. Developed PL/SQL Procedures and Unix Scripts for Automation of Unix jobs. Developed and modified the existing Unix Korn Shell Script as required by Business. Developed UNIX shell scripts and PERL scripts to automate the ETL jobs. Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports, Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies. Created batch job in regular maintenance, email notification and production support to load the data using shell scripts and PL/SQL. Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs and client application. Created PL/SQL Packages for easier application design and improved Performance. Use of Business Objects Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies. Implemented Single Sign-on & Security Layer with Row Level Restrictions. Scheduled and Monitored reports using Central Management Console. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting. Environment: Oracle 11i/10g, Sql Server 2008/2005, Business Objects Enterprise XI3.1/XIR2, Data Integrator XI 11.7.2, Dashboard Manager, Xcelsius, UNIX, Windows 2000/NT, SQL, T-SQL scripts, TOAD 7.4. ACS, MD Jul 07 Oct 08 DW Analyst Responsibilities: Created PL/SQL Packages for easier application design and improved Performance. Modified and developed database triggers, cursors, procedures, functions and packages to meet business requirements. Modified, developed and enhanced the core business packages for the successful release of the project. Modified the existing packages and procedures and achieved benchmarks in the performance. Designed and generated database objects and oracle Forms and Reports using Oracle Designer. Updated and Migrated Business Objects XI R1 to Business Objects XI R2 using Import Wizard. Setup hierarchies in the Universe for providing drill down options in the reporting environment. Created Sets, Metrics, Rules, using Set Analyzer and Dashboard Manager. Created and customized application dashboards using Application Foundation and used balanced score cards and speedometers. Created reports using Business Objects functionality s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae s. Detected and rectified bugs in the packages and stand alone procedures according to the requirements. Implemented Explain plan for tuning sql statements for better performance. Developed PL/SQL Procedures and Unix Scripts for Automation of Unix jobs. Implemented external tables for loading data to external data sources. Encapsulated PL/SQL procedures and functions in packages to organize application. The project involved requirement analysis and making the technical specification document for the web enrollment Data Mart. Changed to the existing code or runtime problems at the client site. Optimized the Query for reducing the runtime of batch processing. Used PowerBuilder to display Data window reports on the web. Developed UNIX shell scripts and PERL scripts to automate the ETL jobs. Extensively used DBMS_SCHEDULER for defining the frequency and date/time specifics of the start-time of the job for executing Oracle procedures and functions. Used DBMS_SCHEDULER to run the shell scripts. Played a vital role in the release of the project upon successful completion. Environment: Oracle 10g/9i, Business Objects XIR2/R1,Developer2000 (Forms 9i, Reports 9i), Oracle Application Server, Informatica 8.1, DB2, UNIX Shell Script, PVCS, Oracle Data Mart, SQL, PL/SQL, Oracle Application Server, SQL*Navigator, TOAD, Visual Source Safe 6.0, MS-Windows 2003. AG Edwards, MO Apr 06 June 07 DW Analyst/Developer Responsibilities: Interacted with Business Users and Managers in gathering business requirements. Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports. Involved in High level and Low level database design Worked on physical and Logical Data Modeling Developed mappings, Transformation, mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter. Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load. Mappings were developed in Informatica employing transformations like Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router. Loaded data into Tables using external tables, pipeline functions, Unix Shell scripts Created applications with PowerBuilder which can access other databases on SQL Server using Open Database Connectivity (ODC). Prepared program specifications for PL/SQL Procedures and Functions Involved in database development by coding PL/SQL Functions, Procedures, Triggers, Packages and Materialized views and database objects Tables, Views, Synonyms etc. Created Unix Shell scripts for automating the execution process Created reports using Business Objects functionality s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae s. Published and scheduled Business Objects Reports to Users using Scheduler. Experience in Business Objects SDK and VBA coding for creation of objects. Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios. Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports. Coordinating with DBA and general supervisor for resolving technical issues Upgraded Business Objects Universes, Users and user groups, and reports from Version 6x to Version XIR1 using the Import Wizard. Environment: SQL Server 2005/2000, Business Objects XIR2/6.x, , UNIX, Broadcast Agent, Windows 2000 Server, Informatica. Aetna, CT May 05-Mar 06 Sr. Oracle developer Responsibilities: Expert knowledge and understanding of Support, technology and Financial Business issues for identifying the client requirements and for Improvement of Product. Working on Oracle PL/SQL to make any changes that client requires for its daily use of application. Migrated Data from COBOL files, flat files to Oracle Data Warehouse & data marts Worked on JCL, COBOL and DB2 Databases. Migrated DB2 database into Oracle. Designed, developed and maintained Universes for supporting Ad-hoc and canned reports. Created Web Intelligence reports using Multiple Data Providers, Prompts, break, filter, rank, alerters, Slice & Dice and Drill up/down functionality. Created Hyperlinked Reports using Open Document Functionality. Created Context, Alias to resolve the Loops in the universe. Modifying the existing universes, Adding new objects editing joins mapping the existing objects with renamed tables. Developed project utilizing Oracle Developer 2000 (Forms 9i, Reports 9i, and PL/SQL) on a Windows NT and UNIX platforms using Oracle 9iAS as Application Server. Writing very complex database packages, store procedures, functions and triggers. Created packages, store procedures to load data into generic template form. Creating SQL and PL/SQL scripts to create data elements for data exchange. Used TOAD, SQL Navigator and PL/SQL Developer for development of Oracle scripts and procedures Developed UNIX shell scripts and PERL scripts to automate the ETL jobs Current ongoing FISF release is 6.2, involved in Critical Business analysis and development of data model, coding, writing back-end Procedures, Packages, and Triggers. In FISF 6.1 release, handled development of UT (unit transactions) related CFL (Critical for launch) items. In FISF 5.10.1 release, handled complex calculations regarding LEP TOP Up transactions. ENVIRONMENT: Oracle 9i, Business Objects 6.0, Developer2000 (Forms 9i, Reports 9i), SQL, PL/SQL, SQL*Navigator, TOAD, MS-Windows 2003/NT,DB2, COBOL, JCL MS-VSS, Pro C, UNIX Shell Scripts. UBS, NJ May 04-Apr 05 Oracle Programmer Responsibilities: Developed project utilizing Oracle Developer 2000 (Forms 9i, Reports 9i, and PL/SQL) on a Windows NT and UNIX platforms using Oracle 9iAS as Application Server. Created tables, temporary tables, materialized views, constraints, managing triggers, stored procedures & cursors. Wrote the Scripts to create tables, functions, stored procedures, Triggers, Packages, Indexes, and Views. Created Universes, Classes, Dimension and Measure Objects by retrieving the data from various data sources and defining the necessary connections. Detected/Resolved data Cardinalities and loops, checked integrity of Universes, created list of values. Resolved Chasm, Fan traps and Loop problems using aliases and contexts in the universe and exported to repository. Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc. Created complex reports using cascading prompts. Created variables, formulas and used contexts (in, for all, for each). Created Web Intelligence reports using Multiple Data Providers, Prompts, break, filter, rank, alerters, Slice & Dice and Drill up/down functionality. Also involved in the business analysis, design, coding and testing of the Data analysis. Design new database table structure using MS-VISIO as data modeling tool and creating backend store procedures, packages and functions using SQL and PL/SQL. Prepared DS (Design specifications) from FS (Functional Specifications). Executed UAT (User Acceptance Test) and changed the system as per new requirement due to change in IIG Business. Performed Production Support and developed an interactive Production Support Reporting tool using MS-EXCEL and later on Forms 9i for Production related enhancements. Expert knowledge and understanding of Support, technology and General Insurance Business issues for identifying the client requirements and for Improvement of Product. Used Report 9i for all reporting purpose, which was designed on the basis of a configurable table driven procedure. Users can analyze and print the same for the corporate paper work. End User training, bug fixing and Post Implementation Support. ENVIRONMENT: UNIX, Oracle 8i, Business objects 6i, PL/SQL, TOAD, DDL, DML, Developer2000 (Forms 8i, Reports 8i), Window NT, DS, FS, WINCVS, Performance Tuning. Airtel cellular India Pvt Ltd, Hyderabad Feb 03 Apr 04 Programmer/Analyst Responsibilities: Extensively involved in requirements gathering and data gathering to support developers. Involved in designing and of functional specifications for the development of user interfaces. Involved in designing of Entity Relationship Diagrams. Created tables, indexes, sequences, constraints and snapshots. Developed packages, procedures, functions and PL/SQL blocks for data validation. Developed PL/SQL scripts to validate and load data into interface tables. Fixed software bugs and interacted with developers to resolve technical issues. Helped in writing proposals, documentation and training. Designed and developed a Generic Billing system for a Telecommunication company. Environment: Oracle 7.3.2, SQL, PL/SQL, Shell Scripts, Oracle Forms 4.5/Reports 2.5, MS Access, MS Excel. State Co-Operative Central Bank, Hyderabad, India May 02-Jan 03 Database /Application Developer Responsibilities: Designed the Interface of the Loans System with other modules at Branch Office Level. Finalized the table scripts of Long term, Medium term and Financial Accounting System Developed the entire Recovery part of banking and loaning system of Long term module Integrated the Long Term Loans Module with Financial Accounting System. Developed various MIS Reports using Crystal Reports. Involved in the testing of long Term Loans, Medium Term Loans, and Financial System. Involved in the Integrated Testing of the Project. Environment : Windows 98, Visual Basic 5.0, and Oracle 7.3. Keywords: cprogramm cplusplus quality analyst database zos active directory information technology microsoft procedural language Colorado Connecticut Idaho Maryland Minnesota Missouri New Jersey Utah Washington