Data Developer

PROFESSIONAL PROFILE:

Accomplished Senior IT professional having over 21 years of IT experience with background in business intelligence, software design and full life-cycle development. Capable of managing numerous projects while leading cross-functional teams to meet and exceed overall IT initiatives. Demonstrated consultative process skills with emphasis on written and relationship development skills.

Experience in various Business Domains like Manufacturing, Mortgage & Banking, Oil.

Extensive experience in SAP Business Objects Data Services 3.2 and 4.x in design, creation and implementation of work flows, data flows, scripts and performing simple and complex transforms in dataflows.

Strong experience in using BODS as an external system for ETL between ECC and BI.

Have good understanding of BW objects infoobjects,DSO,Cubes,open hubs,scheduling jobs through process chains.

Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.

Experience in setting up Development, Test and Production environment by additionally setting up a local and central repository and migration of reusable of objects such as Jobs, Workflow, Dataflow both by Import/Export directly and Checking In/Out in Central Repository and by using ATL files

Extensive experience in Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using SAP Business Objects Data Services.

Expertise in implementing Data Cleansing, Data Profiling, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.

Experience in debugging execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data.

Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.

Experience in creating and administering the metadata Data Integrator repository in a multi user environment.

Extensive experience and solid understanding of Data Warehousing, Data Marts, Star, Snow flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.

Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.

Expertise in ETL techniques using SQL Loader to Load and Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional Database.

Extensive experience in UNIX Shell Scripting, AWK and file manipulation techniques.

Extensive experience in Oracle Databases in Creating Packages, Stored Procedures, Functions, Views, Indexes and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader.

EDUCATION:

B.E.,(Computer Science & Engineering), Madras University, April ‘94.

EMPLOYMENT DETAILS:

June 12 - Till Date

:

Sash Data Innovations Inc, USA(Client – Bell Helicopters Textron, Hurst, TX,CLR - OKC).

Nov 11 – June 12

:

Open Systems Technologies, USA(Client - Chase, Coppell, TX).

Oct 10 – Nov 11

:

PDDN Inc, USA (Client – Bell Helicopter Textron, Hurst, TX).

Nov 98 – Sep 10

:

Syntel Inc, USA., Project Lead (Client:- First Data Merchant Services, Maryland, USA).

Oct 97 – Nov 98

:

Mastech System Corporation, United Kingdom.

Dec 96 – Oct 97

:

Silverline Industries, Chennai, India.

Jun 96 – Nov 96

:

HMT Industries Ltd, Bangalore, India.

Aug 94 – May 96

:

Expo Systems, Chennai, India.

TECHNICAL ENVIRONMENT:

Hardware

:

IBM PC Compatibles, HP 9000/800 Series,HP UX 11.0,SUN SOLARIS.

Operating Systems

:

UNIX,WINDOWS 3.11, 95, 98, NOVELL NETWARE, WINDOWS NT

Languages

:

C, C++, COBOL.

Database

:

ORACLE 7.x, 8.0, 8i, 10g,11g.

GUI

:

SDK, VISUAL C++, DEVELOPER 2000(FORMS 6/4.5/3.0&REPORTS 6/2.5).

Tools

:

Business Objects Data Services 4.x,3.2, SQLPLUS 3.3,PL/SQL 2.3,SQLFORMS 3.0, SQL Loader

Industries

:

Manufacturing, Mortgage, Banking, Financial, Oil.

PROFESSIONAL EXPERIENCE

Continental Oil Resources, OKC, OK

May 2013 – Current

Enterprise Information Management (EIM)

SAP Data Services Consultant

Designed/Developed/Enhanced/Unit Tested ETL code using SAP Business Objects Data Services.

Configured the Data services to connect to the SAP R/3, BI.

Used Open Hub Services to push data out of SAP BI using BODS.

Worked with business process owners, stakeholders to understand and document the requirements. Interacted with the manager to understand the business requirements and implemented the business rules to design and enhance the existing dataflows.

Designed job/workflow/dataflow structure for optimized batch load performance.

Constructed reusable templates to speed ETL development in SAP Business Objects Data Services and provide auditing functionality.

Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies using Business Objects Data Services.

Participated in Data Mapping workshops and follow-up meetings with the client business and IT teams.

Assists in data mapping and GAP analysis between source and target data in SAP Business Objects Data Services as per the

blue print by following ASAP methodology.

Involved in migration of data from legacy systems to ECC through SAP Business Objects Data Services using IDOC.

Responsible for day to day operations and technical deployment to ensure solution is in compliance with quality and regulations, meeting user’s requirements and applying standards and best practices where appropriate.

Responsible for movement of data between source systems SAP BI, ECC and target database and vice versa including XML files.

Used different transforms such as Query, Case, Table Comparison, Key Generation, Merge, Data Generations, Pivot transforms and functions.

Wrote SQL functions and procedures for complex transformations using data workflows, embedded data flows, multisource, multi format data flows in SAP Business Objects Data Services.

Migrated dataflows, workflows, scripts, and jobs between repositories.

Involved in installing Business Objects Data Services 4.0 and upgrading Repository from 3.2 to 4.0.

Worked as Data Services Administrator managing and configuring Job Service from Unix Servers.

Managed and configured Job server in Unix Server.

Managed, configured repositories and setting up users in Web console.

Worked with Functional SAP/ERP teams closely to understand the gaps, coordinate with business on specific business rules, Worked with data migration programmers on transformation rules and meet project standards using proven data load tools and methodology.

Involved in time estimation,impact analysis,preparation,Functional Analysis, requirement analysis and monitoring Business objects data service jobs.

Environment: Business Objects Data Services 3.2 & 4.2, ORACLE 8i,10g,11g, SAP BI 7.3,7.4, ECC 6.0, Unix

Bell Helicopter Textron Company, Hurst, TX

Jun 2012 – Apr 2013

Enterprise Information Management (EIM)

SAP Data Services Consultant

Designed/Developed/Enhanced/Unit Tested ETL code using SAP Business Objects Data Services.

Designed job/workflow/dataflow structure for optimized batch load performance.

Constructed reusable templates to speed ETL development in SAP Business Objects Data Services and provide auditing functionality.

Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies using Business Objects Data Services.

Configured the Data services to connect to the SAP R/3, BI.

Used Open Hub Services to push data out of SAP BI using BODS.

Participated in Data Mapping workshops and follow-up meetings with the client business and IT teams.

Assists in data mapping and GAP analysis between source and target data in SAP Business Objects Data Services as per the

blueprint by following ASAP methodology.

Involved in migration of data from legacy systems to ECC through SAP Business Objects Data Services using IDOC.

Wrote SQL functions and procedures for complex transformations using data workflows, embedded data flows, multi source, multi format data flows in SAP Business Objects Data Services.

Migrated dataflows, workflows, scripts, and jobs between repositories.

Involved in installing Business Objects Data Services 4.0 and upgrading Repository from 3.2 to 4.0.

Worked as Data Services Administrator managing and configuring Job Service from Unix Servers.

Managed and configured Job server in Unix Server.

Managed, configured repositories and setting up users in Web console.

Worked with Functional SAP/ERP teams closely to understand the gaps, coordinate with business on specific business rules, Worked with data migration programmers on transformation rules and meet project standards using proven data load tools and methodology.

Involved in time estimation,impact analysis,preparation,Functional Analysis, requirement analysis and monitoring Business objects data service jobs.

Environment: Business Objects Data Services 3.2 & 4.1, ORACLE 8i,10g,11g, SAP BI 7.3,7.4, ECC 6.0, Unix

Chase, Coppell, TX

Nov 2011 – Jun 2012

Mortgage Business Treasury Reporting

ETL Developer and Administrator

Designed/Developed/Enhanced/Unit Tested ETL code.

Designed job/workflow/dataflow structure for optimized batch load performance.

Constructed reusable templates to speed ETL development to provide auditing functionality.

Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies..

Participated in Data Mapping workshops and follow-up meetings with the client business and IT teams

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Unit testing, System testing, Integration testing.

Involved in time estimation and impact analysis preparation.

Provide production support to ensure SYSTEM run and complete successfully.

Provided technical decision support for the system and business analysts.

Environment: ORACLE 8i,10g,11g, Unix

Bell Helicopter Textron Company, Hurst, TX

Oct 2010 – Nov 2011

Enterprise Information Management (EIM)

SAP Data Services Consultant

Designed/Developed/Enhanced/Unit Tested ETL code using Business Objects Data Services.

Designed job/workflow/dataflow structure for optimized batch load performance.

Constructed reusable templates to speed ETL development in Business Objects Data Services and provide auditing functionality.

Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies using Business Objects Data Services.

Configured the Data services to connect to the SAP R/3, BI.

Used Open Hub Services to push data out of SAP BI using BODS.

Participated in Data Mapping workshops and follow-up meetings with the client business and IT teams. Assists in data mapping and GAP analysis between source and target data in Business Objects Data Services as per the blueprint.

Wrote SQL functions and procedures for complex transformations using data workflows, embedded data flows, multi source,

multi format data flows in Business Objects Data Services.

Migrated dataflows, workflows, scripts, and jobs between repositories.

Worked as Data Services Administrator managing and configuring Job Service from Unix Servers.

Managed and configured Job server in Unix Server.

Managed, configured repositories and setting up users in Web console.

Worked with Functional SAP/ERP teams closely to understand the gaps, coordinate with business on specific business rules, Worked with data migration programmers on transformation rules and meet project standards using proven data load tools and methodology.

Involved in time estimation,impact analysis,preparation,Functional Analysis, requirement analysis and monitoring Business objects data service jobs.

Worked on Remediating the existing database and ETL codes.

Provide production support to ensure SYSTEM run and complete successfully.

Provided technical decision support for the system and business analysts.

Environment: Business Objects Data Services 3.2, ORACLE 8i,10g,11g, SAP BI 7.3,7.4, ECC 6.0, Unix.

First Data Merchant Systems, Hagerstown, Maryland, USA.

Apr 2003 – Sep 2010

Integrated Suspense System and Funding System

ETL Project Lead

Production Support and Development team lead.

Designed job/workflow/dataflow structure for optimized batch load performance.

Constructed reusable templates to speed ETL development in Oracle and provide auditing functionality.

Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies.

Tracking issues and fixing them.

Developed and Customized Oracle PL/SQL stored Procedures,Functions,Packages, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Developed backend Oracle PL/SQL procedures, functions for processing the information that was being called from front end application like visual basic, java.

Used ETL methodologies to load data using SQL Loader and Oracle PL/SQL Stored Procedures to Extract,Transform data from various data sources and Load to the Database & to produce flat files from Oracle Tables to be sent out for processing.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Developed many Unix KSH scripts and Scheduled Cronjobs to trigger batch schedules automatically.

Wrote Connect Direct/NDM shell script to sent the file to Mainframe from unix server.

Did Defect Tracking,Unit testing, System testing, Integration testing.

Involved in time estimation,impact analysis,preparation,Functional Analysis, requirement analysis and monitoring jobs.

Involved in designing of various critical data flow diagrams required for the project.

Using SOA designed and developed Business Rules Engine to execute and integrated with web application.

Wrote and run test cases and modules for load testing scenarios.

Provided technical decision support for the system and business analysts

Environment: ORACLE 8i,10g,11g, Unix.

First Data Merchant Systems, Coral Springs, Florida, USA.

Jan 2003 – Mar 2003

Value link System

ETL Project Lead

Production Support and Development team lead.

Tracking issues and fixing them.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Wrote Unix scripts and C scripts.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Involved in time estimation and impact analysis preparation.

Involved in performance tuning of the various times taking stored procedures and functions.

Environment: ORACLE 8i, Unix, C.

Kintetsu World Express, Dallas, Texas, USA.

Aug 2000 – Jan 2003

Freight Management Systems

Programmer Analyst

Customization and enhancement of Oracle Applications for freight management systems.

Preparing detailed design document for interfaces, conversions, forms and report customizations using Oracle AIM documents. Worked in AR, AP, GL modules

Customizing existing forms in 6/4.5 and reports in 6/2.5 to meet the client needs.

Developing Applications using Forms 6/4.5, Reports 6/2.5.

Converted forms 4.5 to 6 and Reports from 2.5 to 6. Handled Customer and Vendor Interfaces applications.

Handled the Interface flow between the applications.

Registering Forms, Value Set, Concurrent programs,Executables in AOL.

Defining alerts as per the system requirements.

Preparing unit test plan for each interface and conversion programs.

Giving production support. Customized CUSTOM.pll for Customized forms.

Wrote Stored Procedures,Functions and Database Triggers.

Unit Testing,System Testing and Implementation of Application.

Environment: ORACLE 8.0,8i, Developer 2000, Forms 6, Reports 6.

Cummins Engine Company, Memphis, Tennessee, USA.

Nov 1998 – June 2000

AfterMarket Salesorder Management System

Programmer Analyst

Wrote Stored Procedures,Functions and Database Triggers.

Developing Reports 2.5 for the entire ASOMS modules.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Developed many Unix KSH scripts for batch scheduling and Cronjobs to trigger batch automatically.

Prepared User and Developer Manual.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing,System Testing and Implementation of Application

Involved in time estimation and impact analysis preparation.

Environment: ORACLE 8.0, Developer 2000.

GE Caledonian, United Kingdom.

Oct 1998 – Nov 1998

Invoicing

Programmer Analyst

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Developed many Unix KSH scripts for batch scheduling and Cronjobs to trigger batch automatically.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Involved in time estimation and impact analysis preparation.

Unit Testing,System Testing and Implementation of Application

Environment: ORACLE 7.3, Developer 2000.

Electronic Data Systems(EDS), United Kingdom.

Nov 1997 – Sep 1998

Annuities Tracking System

Programmer Analyst

Wrote Stored Procedures and Database Triggers. Development of Forms.

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Developed many Unix KSH scripts for batch scheduling and Cronjobs to trigger batch automatically.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Involved in time estimation and impact analysis preparation.

Environment: ORACLE,Pro *c,SQLForms 3.0,Developer 2000.

Bahrain Telecom Communication, Bahrain

Dec 1996 – Oct 1997

Invoice System and Inventory System

Programmer Analyst

Study and design the system

Developed Customer Care and Account Number creation modules in Forms 4.5,Reports 2.5.

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Developed many Unix KSH scripts for batch scheduling and Cronjobs to trigger batch automatically.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Involved in time estimation and impact analysis preparation.Unit Testing and System Testing.

Environment: ORACLE 7.3, Developer 2000.

HMT, Bangalore, Karnataka, India.

Jun 1996 – Nov 1996

Purchase Order System

Programmer

Developed modules using Forms 4.5, Reports 2.5, pro*c programs.

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Involved in time estimation and impact analysis preparation.

Environment: ORACLE 7.3, Developer 2000.

Expo System, Chennai, Tamil Nadu, India.

Feb 1996 – May 1996

Sales Processing

Programmer

Developed modules in Forms 4.5, Reports 2.5.

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file and Cronjobs to trigger batch automatically.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Environment: ORACLE 7.3, Developer 2000.

Expo System, Chennai, Tamil Nadu, India.

Aug 1995 – Dec 1995

Attendance Recording system

Programmer

Developed modules in Forms 4.5, Reports 2.5.

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Developed many Unix KSH scripts for batch scheduling and Cronjobs to trigger batch automatically.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Environment: ORACLE 7.3, Developer 2000.

Expo System, Chennai, Tamil Nadu, India.

Feb 1995 – Jun 1995

Front Office Managements System

Programmer

Developed modules in SQLForms 3.0,pro*c programs.

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Environment: ORACLE 7.3,Forms 3.0, Pro *c.

Expo System, Chennai, Tamil Nadu, India.

Aug 1994 – Dec 1994

Civil Supplies

Programmer

Wrote Oracle PL/SQL stored Procedures,Functions,Packages, Views, SQL scripts to facilitate the functionality for existing module and to meet Customer Requirement.

Used SQL Loader to load data from delimited and position based files into Oracle tables.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking, Unit testing, System testing, Integration testing.

Environment: ORACLE 7.3,Forms 3.0, Pro *c.

Contact this candidate