SUMMARY

• Worked on complex business solutions using BODS and Migration from BODI 11.7 to SAP BODS 12.2 implementation.
• In spite of primary role as Lead ETL developer, Shared responsibilities of primary DBA.
• Highly involved in project’s Operations and Maintenance activities.
• Implemented Several performance enhancements and tuning techniques
• I have 10 years of experience in IT industry. Majority of which include working as Lead ETL developer using SAP Business Object Data Services(BODS), and also 3 years of experience as Oracle DBA.
• I have worked on 3 full SCLC implementations of Data Warehouse applications.
• I have solid expertise in data analysis, Design, development of complex business applications and ETL/database performance tuning methodologies.
• Hands on Experience of working on SAP Business Object 4.0, Business Object XI 3.2/3.1 Data Integrator version 11.7 and BODS 12.2.
• Implemented data warehouse techniques such as Data Cleansing, Slowly Changing Dimensions and Rolling back data of slowly changing dimensions.
• Data modeling experience using Star Schema, Snowflake schema, and developed Physical and Logical Data models using ER studio, ERWIN.
• I have worked with diverse business requirements and developed ETL jobs that have more than 25 different sources including xml and delimited source files.
• Written several technical documents such as ETL Design document, Process Flow documents, Test scripts, Deployment documents, User training documents.
• I have worked with databases like ORACLE database (versions 7, 8i, 9i, 10g, 11g RAC), Informix 9.4, 10,11 and SQL SERVER 7.
• I have worked on Design implementation and verification of backup strategy for point in time recovery using Recovery Manager (RMAN) Recovery Catalog and various UNIX Scripts. I have used Oracle Enterprise Manager (OEM) to monitor database activities. For one of the project I have provided 24 *7 as primary contact person for production support.

PROFESSIONAL SKILLS

Data Warehousing: SAP Business Object 4.0, XI 3.2/3.1, SAP BO Data Services 12.2, BO Data Integrator 11.7, Informatica Power Center 9.1 / 8.1 OLAP

Environment: Linux, Sun Solaris, HP - UX, IBM AIX, MS DOS, Win NT4.0.

Databases: Oracle 11g,10g/9i/8i, ASM, RAC, MS Access, MS SQL Server 2000, Informix 11, MS SQL Server Management Studio, Erwin

Programming: UNIX Shell scripting, Toad, SQL, T-SQL, PL/SQL, HTML, C, C++, Java, VB6.0, ASP.net, VB.net

Application Packages: Visual Studio 6.0, MS front page, MS Office, Linux Red Hat 8 CuteFTP, Tally 4.5 Accounting Software

PROFESSIONAL EXPERIENCE

Engineer III (Lead ETL developer)

Confidential DC

Responsibilities:

• Working as Lead ETL Developer using BODS/BODI for more than 5 years.
• Designed and developed data warehouse model which is combination of Star and Snowflake schema.
• Developed numerous ETL jobs using BODS to extract data coming from Courts all over USA and load into the data warehouse.
• Implemented Type-2 and Type-3 Slowly changing Dimension solutions.
• Performed Migrations for large ETL jobs from BO Data Integrator 11.7 to SAP BO Data Services 12.2
• Successfully conducted highly monitored and time-crucial reload of large source data with complex business calculations.
• Redesigned Complex ETL job using Business Object Data Integrator to make it simple and meaningful.
• Provided routine operations and support and conducted routine loads in timely manners.
• Automated major groups of ETL jobs with very minimal monitoring and human interaction required.
• Worked on Database Migration from Informix 10 to Oracle 11g.
• Managed more than 20 Database Instances and five database servers throughout the project. Also managing database users for security privileges on each server with no / minimal help from other DBA.
• Implemented performance tuning techniques including partitioning and indexing for table with more than 77 million records. And achieved great success for slow running queries.
• Migrated production and test database instances (including schemas, tables, SP, views, users, roles, permissions, and data) into the new database servers with upgraded database from the scratch. Performed validation before and after the migration and prepared several technical requirement documents.
• Trained users using presentations and one-on-one training sessions.

ETL Developer & Oracle DBA

Confidential MA

Responsibilities:

• One Member of Database Administrators team, monitoring Production systems of around 20TB in size for stability
• Upgrade of Oracle Databases from 9.2.0.7 to 10.2.0.3
• Maintain ETL large jobs using Business object Data Integrator.
• Tuning the Database by identifying bottlenecks related to latch contention and locks
• Design implementation and verification of backup strategy for point in time recovery using Recovery Manager (RMAN)
• Developed automated process for nightly Cloning(Replicating) of the Production 10g instance
• Cloning and refreshing the database and application on quarterly basis based on BSCI's release calendar
• Implemented RAC as one of the disaster management strategy
• Identify the fragmented objects and rebuild them at regular intervals to improve performance
• Applying one-off patches on top of 11.5.10 through AutoPatch
• Performing System Administrator activities like managing application Users Profiles Responsibilities and Concurrent managers etc
• Maintain Data Guard to reduce the human intervention required to switch databases at Maintenance and Upgrades
• Performing Operational DBA Duties like tuning and maintenance of the Oracle Database
• Helped in configuring Automatic and Manual Remedy tickets using OEM

Environment: Sun Solaris, Oracle 11g

Confidential

Production Database Administrator

Responsibilities:

• Worked as Point of Contact for DBA Support and responsible for patching cloning backup and recovery of Oracle Applications instance and its maintenance
• Installed various versions of databases of 10g on different platforms like Linux HP-UX Solaris and Windows 2K
• Analyzed replication environment, provided replication support fixes: Implemented Replication Conflict Resolution
• Provided Replication troubleshooting and solutions for various Replication issues; provided Oracle Patch installation
• Performance monitoring and tuning of application database and various servers (Concurrent Management Server Forms Server Reports Server)
• Proficiency in applying auto patches as well as manual patches
• Installed Demand Planning and Express Server and solved the problems related to Express Server
• Created users custom responsibilities functions menus concurrent programs and managers
• Resolved Oracle Applications related issues by raising several metalink TARs including severity1 TARs

Environment: Oracle Applications 11.5.3 11.0.3 Oracle 10g Oracle Demand Planning and Express Server RMAN

Confidential

Oracle Database Developer & Associate DBA

Responsibilities:

• Developed E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and Procurement
• Gathered application requirements and provided design recommendations
• Helped design custom data models that integrated with Oracle Applications
• Designed and implemented error checking and correction protocols and programs
• Built Internet access and GUI interfaces to Relational Database Management Systems (RDBMS)
• Coded, tested, debugged, documented, and maintained programs
• Created detailed project outlines, application design specifications, and test plans

Environment: HP-UNIX, Oracle 8i-9i, SQL-server 2000