Technology Analyst Resume

SUMMARY

Whole 9 and half years Industry experience and 8 years 3 months experience in SAP BODS Analysis, Design and Development of various Data Integration projects usingSAP Business Objects Data Services 4.2/3.2.
Experience in Analyzing Software Requirement Specifications and involved in development of Test Plans, Test Cases and executing them.
Hands on experience in Agile and SDLC methodologies.
Extensive experience in implementation of ETL methodology in Data Extraction, Transformation and Loading.
Substantial development experience in BODI/BODS (Business Object Data Services) Projects like End to End implementation, Data migration.
Has a good understanding of SAP BODS transformations like Lookup, Joins, Map, Merge transforms, Abap data flows using the SAP BODS Designer.
Experience in configuring SAP ECC, SAP BW systems wif Data Services system.
Skilled in Appworx scheduling tool, Oracle SQL, PL/SQL, UNIX.
Involved in creatingStored Procedures, PL/SQL, SQL and Query optimization in Oracle SQL/PLSQL.
Extensive experience in trouble shooting and resolving the defects, extracting the data from heterogeneous data sources.
Four years of experience in leading a team at onsite and coordinating wif offshore team in tasks prioritization, development and support activities.
Worked extensively on Go - live Preparation, data migration and Post go-live support.
Flexible and versatile to adapt to any new environment and work on any project.
Excellent in Oral and Documentation skills.

TECHNICAL SKILLS

ETL Tool: SAP Business Objects Data ServicesConstellar HUB tool

Languages: Oracle SQL/PLSQL, UNIX scripting

Scheduling Tools: Appworx

Databases: Oracle, MS SQL Server

Other Tools: Microstrategy reporting tool, Business Objects Reporting tool, Windows scripting, Toad.

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential

Technology Analyst

Responsibilities:

Designed Data Flows for extracting data from various sources including excel work books, flat files, XML and relational tables.
Used Lookup, Joins, Map, Merge transforms, ABAP data flows.
Loading the data into SAP-ECC system using IDOC's.
To schedule Data Services jobs, UNIX scrips, Oracle stored procedures from Appworx scheduling tool.
Worked on Unix Commands for Copying, Archiving of files on daily basis from ftp Locations, implementing logic & daily scheduling of UNIX jobs
Worked on support activities related to EDI Gentran tool to receive and process EDI format orders from customers into the WMG system and transferring back ASN and Invoices back to customers.
Involved in Data Services tool Upgrade from SAP-BODS 3.2 to 4.2 versions.
Involved in requirement gathering meetings wif clients.
Code Review and Performance improvement of jobs.
Created custom functions to implement reusable code in the jobs.
Identified areas of manual intervention and automated them.

Confidential

Senior Systems Engineer

Responsibilities:

Developing Workflows, Data flows based on the specifications using various stages in BODI/BODS.
Preparation of Test scenarios documentation.
Created UNIX scripts to perform file level operations on sever.
Experience in Automation of jobs through Management console & Creating Batch jobs.
Implemented validation rules for population of mandatory fields.
Exception handling using TRY/CATCH block.
Worked wif different transformations like Table Comparison, Validation, SQL Transformation, Case and Table Comparison, Row Generation.
Using SQL Queries like inner joins, Outer joins and DDL, DML commands to test the data at the database level.
Troubleshooting day to day technical issues.

Confidential

Systems Engineer

Responsibilities:

Prepare sequence for automatic generation of unique keys to support primary and foreigner key constraints in data conversions.
Create various DML and DDL statement using Oracle Pl/SQL and SQL.
Worked wif SQL* Loader to import and export data from the flat files in and out of the legacy database.
Experience in developing Joins, Indexes, sequences, DB Links.
Worked on set operators inPL/SQLlike Union, Union all, Intersect and Minus.
Participated in creation of database objects like tables, views, Materialized Views, cursor (Implicit, Explicit, REF), packages and Handled Exceptions.
Implemented Table Partitioning for huge data.