PROFESSIONAL SUMMARY:

• 13 years of relevant experience in Information Technology which includes data analysis, database design, development, testing, implementation, support and enhancements of BI / Data Warehousing and client/server applications using Oracle 11g/10g/9i, Erwin, DBA, PL/SQL and DataStage.
• Worked as a Data Architect and done Data Modeling of BI / Data Warehousing (Dimensional, Star & Snowflake Schema) and client/server applications using Erwin.
• Experience in writing, testing, and implementing of Stored Procedures, Packages, Functions, Triggers and Views at database level using SQL and PL/SQL.
• Experienced in development, support and enhancements of Data Integration applications using ETL (Datastage, Oracle PL/SQL and Informatica).
• Involved in writing Unix Shell Scripts for various tasks.
• Strong in Business Intelligence (BI), Data Warehousing concepts and Dimensional data modeling.
• Having experience and performed Oracle DBA Activities (Users/Schema Maintenance with Security, Data pump, Export/Import, Materialized Views/Logs, SQL Tuning & Optimization, SQL*Loader, Maintenance of all Database Objects, Tablespace/Storage Management, DB Backup, Statistics Gathering/Analyze of Objects, External Tables, UTL File, Data Migration, Partitioning tables, ASM Disk Group/Member Maintenance and Oracle Golden Gate Replication)
• Confidential - MARS Database Migration (10 TB) done from Solaris to Linux environment which is one among the top 5 complex/critical/high visibility applications of Confidential ( Confidential ).
• Experience in Data Migration using Oracle Golden Gate.
• Experience and knowledge in Manufacturing, Insurance and Banking domains.
• Have gained full SDLC (Software Development Life Cycle) experience in many projects.
• Have been involved in project planning and management activities.
• Experience in writing various test cases and testing for the jobs designed.
• Experience in interacting and coordinating closely with clients for timely support and managed service delivery to customer.
• Excellent and proven, written and oral communications skills.
• Having good inter-personal skills, dedication, hard work and commitment.
• : Oracle Certified Associate (OCA), Six Sigma Green Belt.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, SQL Server, Trained on Teradata 12

ETL: Data Stage 8.7, Informatica 7.1, Trained on Abinitio by TCS

Replication Tool: Oracle Golden Gate 11g

Languages: PL/SQL, SQL

RDBMS Tools: TOAD, PL/SQL Developer, SQL*Plus, Oracle Enterprise Manager (OEM)

Operating Systems: Linux, UNIX, Solaris, Windows NT/2000/XP

Data Modelling Tools: Erwin 9.0

Configuration Tools: IBM Clearcase, Microsoft VSS

SAP: Trained on SAP BI 7.0

Other Tools: MS Office, Win Merge

PROFESSIONAL EXPERIENCE:

Confidential - MI

Data Architect / Development DBA / Team Lead

Responsibilities:

• Dimension, Star and Snow flake schema Data modeling done for reporting using Erwin.
• Involved in development of DataStage jobs/sequencers for Interface and ETL.
• Developed and created DB Objects like Tables, Indexes, Package and Procedure.
• Created materialized views and materialized view logs.
• Involved in writing Unix Shell Scripts for Interface development.
• Linux Crontab job scheduled for various data load interfaces.
• SQL tuning & optimization done for the queries taking longer time to run.
• Assisting team members for any technical issues/decisions.
• Involved in validation and reconciliation of data at the time of testing.
• Prepared/Reviewed the test cases to test the functionalities of the developed DataStage jobs and documented the test results with test data preparation with script.
• Involved in preparation of technical specification documents.
• Involved in co-ordination between the client and team members.
• Involved in daily status and review meetings with clients.

Environment: Erwin 9.0, DataStage 8.7, Oracle 11g, PL/SQL, TOAD 9.2, Linux, Cognos 10

Confidential - MI, USA

Development DBA / Team Lead

Responsibilities:

• MaRS Database Migration (10 TB) done from Solaris to Linux environment.
• Worked and handled of 10 Terabytes database which is one among the top 5 complex and critical applications of Confidential ( Confidential ).
• Involved in implementation of Oracle Golden Gate replication for Data Migration and disaster recovery for one of the high visibility application of Confidential ( Confidential ).
• Done users/schema creation and assigning necessary privileges to them.
• Developed and created DB Objects like Tables, Indexes, Packages, Procedures, Functions, Triggers and Views.
• Created Materialized Views and Materialized view Logs.
• Table Partitioning done for very big Tables.
• Performed Oracle DBA Activities (Users/Schema Maintenance, Data pump, Export/Import, SQL Tuning & Optimization, Maintenance of all Database Objects, Tablespace /Storage Management, DB Backup, Statistics Gathering/Analyze of Objects, Data Migration, Partitioning tables and ASM Disk Group/Member Maintenance)
• Table/Schema wise data backup taken and restored when necessary.
• Database Monitoring done for identifying any performance bottleneck.
• Solaris/Unix/Linux Crontab job scheduling done for various data load/script run.
• Involved in writing Unix Shell Scripts for various tasks.
• SQL Tuning & Optimization done for the queries taking long time to run.
• SQL * Loader utility used for data loading from dump files and csv files.
• External Tables and UTL Files used.
• Involved in Datastage job design/development/implementation for enhancements tasks.
• Monitoring data load from various applications to Data Warehousing database (WWPMaRS).
• Assisting team members for any technical issues/decisions.
• Worked on the service center tickets to provide best solution to the customers for data issue.
• Involved in validation and reconciliation of data.
• Done maintenance and enhancement activity for existing codes.
• Involved in co-ordination between the client and team members.
• Prepared/reviewed the test cases to test the functionalities of the developed code and documented the test results with test data preparation with script.
• Involved in preparation of technical specification documents.
• Involved in Daily Status and Review meetings with clients.

Environment: Oracle 11g, RAC, ASM, PL/SQL, Oracle Golden Gate 11g, TOAD, Oracle Enterprise Manager (OEM), Solaris/Linux, Datastage 7.5, Cognos 8

Confidential

Data Architect / Development DBA / Team Lead

Responsibilities:

• Led the team with task allocation, tracking, monitoring and provide support to the team members for any technical issues/decisions.
• Effort estimation and distribution done for each and every tasks/activities.
• Involved in Data Modeling using Erwin and BO Universe Design.
• Involved in Data Migration activities.
• Performed DBA activities like Users/Schema creation and maintenance, Export & Import, SQL Tuning & Optimization, SQL * Loader.
• PL/SQL Programming (Packages, Stored Procedures, Functions, Triggers and Views).
• Table Partitions done for the tables having large volume of data.
• Involved in code walkthrough, review and testing.
• Involved in co-ordination between the client and team members.
• Prepared/reviewed the test cases to test the functionalities of the application and documented the test results with test data preparation with script.
• Involved in preparation of technical specification documents.
• Involved in status and review meetings with clients.

Environment: Oracle 11g, PL/SQL, Linux, J2EE, Business Objects XI R2, Erwin 7.2

Confidential

Development DBA / Sr. Oracle Developer

Responsibilities:

• Led the team with task allocation, tracking, monitoring and provide support to the team members for any technical issues/decisions.
• Analyzing the problems/requirements and provide the best solutions.
• Performed DBA activities like Users Maintenance with Security, Export & Import, SQL Tuning & Optimization, SQL * Loader, External Tables and UTL File.
• PL/SQL Programming (Packages, Stored Procedures, Functions, Triggers and Views).
• Table partitions done for the tables having large volume of data.
• Maintained & versioning the codes in IBM Clearcase.
• Involved in code walkthrough, review and testing.
• Involved in co-ordination between the client and team members.
• Prepared test cases to test the functionalities and documented the test results with Test data package preparation with script.
• Involved in preparation of technical specification documents.
• Involved in status and review meetings with clients.

Environment: Oracle 10g, PL/SQL, Linux, J2EE, IBM Clearcase

Confidential

Sr Oracle Developer / Team Lead

Responsibilities:

• Involved in PL/SQL programming and Informatica mappings development.
• Analyzing the problems and provide the best solutions to support the clients.
• Application maintenance and SLA based delivery of application support.
• Coordinated communications between the offshore team and clients.
• Developed and maintained project plan for transition.
• Involved in mapping documents preparation.
• Prepared test cases to test all the mappings as per the approved test plan, and documented the test results.
• Preparation of test data package with script.
• Responsible for moving the application into staging and production environments
• Involved in status and review meetings with clients.

Environment: Informatica 7.1, Oracle 10g, PL/SQL, Mainframe, Unix

Confidential

Development DBA / Team Lead

Responsibilities:

• Performed DBA activities like Table Partitioning, Export & Import, SQL Tuning & Optimization
• Led the ETL team with task allocation, tracking, monitoring and provide support to the team members for any technical issues/decisions.
• Perform data mapping for new data sources
• Developed ETL transformation rules and instructions.
• Involved in Informatica mappings development and PL/SQL programming.
• Participated in data validation, data quality testing, and other ad hoc query requests
• Involved in onsite-offshore calls for co-ordination
• Involved in initial team setup for development at offshore
• Involved in knowledge sharing sessions within the CIE team
• Responsible for moving the application into staging and production environments.

Environment: Informatica 7.1, Oracle 10g, PL/SQL, Unix

Confidential

Sr. Oracle Developer

Responsibilities:

• Informatica mappings development and modification
• Oracle 9i PL/SQL Packages development and modification
• Testing of Oracle Packages and Informatica mappings
• Creation of new tables to implement the new enhancements
• Prepared unit, integration and performance test plan documents. Performed unit, integration and performance test as per the approved test plan and documented the test results
• Responsible for moving the application into staging and production environments
• Responsible for mapping document preparation, status Reporting and Presentation

Environment: Informatica 6.2.1, Oracle 9i, PL/SQL, Appworx Scheduler

Confidential

Development DBA / Oracle Developer

Responsibilities:

• Performed DBA activities like Users with Quota Maintenance, Export & Import, SQL Tuning & Optimization.
• Performed the roles like team leader and team member.
• Developed and maintained project plan.
• Provide support to consolidated RTS applications.
• Respond to problems and perform tasks necessary to sustain system operations.
• Analyse and resolve the problems.
• Develop fixes for runtime issues due to data errors.
• Fix or Solve custom application bugs / problems.
• Maintain application source code using standard version control tool Microsoft VSS.
• Migration of codes from development to production environment.
• Minor enhancements and major enhancements to the existing applications, which includes document the functional requirements, coding, unit and integration testing.
• Design & development of new & relevant applications required during the project period like dashboards, setting up new systems at remote locations and data migration.
• Log and analyze the time spent in various project activities using IPMS.

Environment: Windows NT, Oracle 8i, PL/SQL, ASP, XML, HTML, Perl

Confidential

Design Engineer

Responsibilities:

• Performed DBA Activities like users with quota maintenance, export & import, SQL tuning & optimization, frequent analyze of DB Objects/Schemas and database cloning.
• Involved in existing system study and gap analysis.
• Involved in requirement gathering and prepared SRS.
• Involved in application analysis and database design.
• Involved in Data Modeling using the tool Erwin.
• Preparation of HLD, LLD, program specifications and other documentation.
• PL/SQL Programming (Packages, Stored Procedures, Functions, Triggers and Views)
• SQL * Loader, External Tables, Export, Import and UTL File.
• Code walkthrough and Review done.
• Table partitions done for the tables having large volume of data.
• Done Data Migration using PL/SQL.
• Performed query tuning & optimization.
• Involved in onsite co-ordination for Data Migration.
• Performed unit, integration and performance tests as per the approved test cases, and documented test results for data migration.
• Involved in deployment and Implementation of this application at on-site.
• Participated in status and review meetings.

Environment: Sun Solaris 8 / Windows NT 4.0, Oracle 9i, PL/SQL, Visual Basic 6.0, Crystal Reports 8.5, Erwin.

Confidential

Programmer

Responsibilities:

• Involved in Visual Basic front-end form designing and coding to develop the application.
• Performed unit and integration test as per the approved test plan and documented test results.
• Involved in user manual preparation and project documentation.
• On line help done based on Field and Screen Level using Microsoft HTML Help Workshop 1.1
• Extensively used Visual Source Safe to maintain the Source Code and Version Control.

Environment: Windows NT 4.0/ 2000, Visual Basic 6.0, Oracle 8i, Crystal Reports 7.0, MS-VSS.