Professional Summary:

• 13years of relevant experience in Information Technology which includesdata analysis, database design, development, testing, implementation, support and enhancements of BI / Data Warehousing and client/server applicationsusing Oracle 11g/10g/9i, Erwin, DBA, PL/SQLandDataStage.
• Worked as a Data Modeler 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, Datapump, 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
• GM - MARS Database Migration 10 TB done from Solaris to Linux environment which is one among the top 5 complex/critical/high visibility applications of General Motors GM .
• 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.

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

ProfessionalExperience

Confidential

Data Modeler / Development DBA / Team Lead

The Confidential Tooling Asset Management system was designed to streamline communication between suppliers and Confidential via a web interface on the Confidential supply power portal. Confidential provides current detailed tool description, cost and location for Confidential owned tools to suppliers and multiple Confidential internal organizations based upon business needs. Tooling Contracts from Confidential Purchasing System and tool management data from Confidential is migrated into SAP system and the MaRS Metrics and Reporting System receives the tooling contract data and tool management data from SAP for reporting.

Responsibilities:

• Dimension, Star and Snow flake schema Data modelingdone for reporting using Erwin.
• Involved in development of DataStage jobs/sequencersfor Interface and ETL.
• Developed and created DB Objects like Tables, Indexes, Package and Procedure.
• Involved in development of PL/SQL.
• 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

Development DBA / Team Lead

• The Confidential Worldwide Purchasing Metrics and Reporting System Confidential provides web-delivered, self-service business information to the broad GM Worldwide Purchasing organization, related to the procurement of direct material, in the form of on-demand information. The business information must be consistent, complete, accurate, up-to-date and verifiable.
• Confidential provides a common methodology for General Motors to share reporting data by including the Confidential into the architecture for incremental data change capture.
• The system provides incremental data refresh additional data and expanded reporting capability for the Confidential Business Customer. In general, any Purchasing operation attempts to find an optimal balance with Supplier Quality, Delivery and Price.

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 General Motors GM .
• Involved in implementation of Oracle Golden Gate replication for Data Migration and disaster recovery for one of the high visibility application of General Motors GM .
• 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, Datapump, 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 DataWarehousing 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 Modeler / Development DBA / Team Lead

Confidential is an application which is aimed to compute new route cost allocation and route result generation in order to capture and report the route performance. It helps Confidential in automating the preparations of monthly report that analyzes the performance of all the routes in the network as well as in the Route Costing Allocation exercise done immediately after the month. The application is designed to import data from different sources, compute provisional costs and generate a set of reports on discrepancies and analysis of the captured data. The reporting system is having drill-down functionality and is capable of doing what-if analysis .

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

Confidential is the Confidential scanning platform that has been implemented across Confidential. This helps manufacturers to develop the right marketing and sales programs, and to help retailers to understand their competitive positions. This integrates information from a variety of sources to provide accurate, decision-ready reporting and coverage of a broad array of retail channels. Retail measurement services help management to measure product penetration, overall product performance, distribution, promotion effectiveness and price sensitivity. Confidential measures and tracks sales volume, selling price, observed promotion and merchandising execution, encompassing an organization's own brands as well as competitive brands.

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

SrOracle Developer / Team Lead

Customer staging is a data interface from the Customer Information File CIF Mainframe DB2 to webstation Confidential. Confidential is the enterprise customer store that feeds this information to downstream systems. Webstation is the Confidential application that used by the retail agents. This interface populates the necessary adds, changes and deletes for customer profile and relationship data. The updates to this interface are on a nightly basis. The interface uses Informatica to populate the EIM tables on Oracle.

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: Informatica7.1, Oracle 10g, PL/SQL, Mainframe, Unix

Confidential

Development DBA / Team Lead

Customer Information Environment aims at providing a customer centric data across citigroup Line of Businesses and Channels. The functions of Confidential Cards IT include business relationship management, project management, solutions, development, testing, engineering, infrastructure, information security, finance and administration, architecture, and data systems management. IT is responsible for implementing business initiatives, maintaining existing technological components, and providing production support.

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: Informatica7.1, Oracle 10g, PL/SQL, Unix

Confidential

Sr. Oracle Developer

The goal of the Data Warehouse Table Audit project is to ensure on-going data completeness and accuracy in the Confidential. This project is purely a back-end project, which could possibly modify any of the following existing items - source tables, target tables, packages and the Informatica mappings. New Table Created to store the unavailable time by locomotive wise.

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: Informatica6.2.1, Oracle 9i, PL/SQL, Appworx Scheduler

Confidential

Development DBA / Oracle Developer

Confidential is a Product Lifecycle Management System that automates the product data and life cycle processes. It streamlines the process steps employed to create, manufacture, and support the products, from the earliest glimmer of a concept through to retirement. Confidential has the following six components, namely Document Management, Design Integration, Configuration Control, Process Management, Product Collaboration and Enterprise Integration

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

Confidential is a client server architecture driven system that enables the enterprise to increase its customer base and effectively manage retain them. This system is a collection of highly independent yet easily pluggable products viz., Call Centre Management System Inbound Outbound calls management , Campaign System for creating launching effective campaigns to acquire more customers by marketing , Profiling System Profiles the customer based on several criteria to use in campaigns, Accounts, Materials, Mass Communication, Email, Dmail, Fax, Operation Fulfillment, MIM Medical Informatics Management .

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

Confidential is a Confidential based company producing various lights. Confidential package developed for this company to automate all the department transactions. This package consists of five modules namely Finance, Materials, Manufacturing, Sales and distributions and HR. Finance module is my core modules having five sub modules namely General Ledger, Account Payable, Account Receivable, Fixed Assets and customization. All necessary reports are generated by this system.

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.