Post Job Free

Resume

Sign in

Sr SAP BW Analyst/Developer

Location:
Cleveland, OH, 44114
Posted:
September 24, 2010

Contact this candidate

Resume:

Objective:

To secure a CON_IND position in a computer industry utilizing my programming skills, database concepts and advanced quantitative abilities in order to deliver my best performance.

Education:

 Masters in Computer and Information Science Anticipated Dec 2010

Cleveland State University,

Cleveland, Ohio.

 Bachelor of Electrical Engineering May 2008

A.D Patel Institute of Technology, v.nagar,

Gujarat, India.

Technical Skills:

 Database : ORACLE 10g, SAP front end 7 and Microsoft Access

 Languages : PL/SQL, Toad, C++, C, JAVA,HTML

Academic Honors’ and Activities:

 President of HINDU STUDENT ASSOCIATION (HSA) of Cleveland State University.

• Worked as a President in this association for 1.5 years.

• Organized various events and parties for about 45 international students every semester which helped them to communicate with each other and solve any concerns.

 Secretary of FRIENDS OF INDIA (FOI) organization of Cleveland State University.

• Worked as an active member in FOI for 1.5 years. Organized many events for international students which helped them to understand CSU educational systems and procedures.

• Arranged for the temporary accommodation for about 30 CSU international students every semester.

• Conducted seminars to guide them with their registration process and the initial steps at CSU.

Projects:

Public health survey database (SAP Front End 7):

• Using SQL Front End designed a normalized database to store the data collected by the survey.

• Formed a data quality report, and suggestions of how to address any quality issues.

• Constructed a simple star schema design for a data mart to support at least seven public health decisions.

• Depicted a list of loading rules to move the data from the OLTP system to the data mart.

Experiences:

 Summer Internship

Company: Highmark Credit Bureau (INDIA)

Position: Oracle (Pl/Sql) developer

Duration: 3 months

Project: DATA QUALITY MANAGEMENT (DQM) Client: ICICI DURATION: 1 Month

Duties:

• Created and run various pl/Sql queries to test the data.

• Testing of cluster data and running sequential batches in order to check nature of match Engine on the data taken from banks.

Project: DATA LOADING Client: VARIOUS MFI (Micro Finance Institution) DURATION: 1 Month

Duties:

• Uploading data files of different format in the database using EXTERNAL TABLE in oracle.

• Developed an automated procedure to fetch data from file through External Table and split the raw delimited data on the base of delimiter according to specification in PL/SQL and inserted into respective tables.

• Data will be fetched from different sections in which each section is selected from multiple tables with proper joins. BULK COLLECT is used to fetch the huge amount of data and the fetched data will be stored in table TYPE objects before printing.

Project: DATA ANALYSIS Client: VARIOUS MFI (Micro Finance Institution) DURATION: 1 Month

Duties:

• Data profiling on raw data which includes pattern finding, pattern designing, checking data validity, data availability and data accuracy using oracle pl/Sql queries.

• Developed an automated procedure which can perform analysis of data and profiling (which calculates data availability and data accuracy) without manually firing individual queries.

• Generating reports showing the statistic of production data on the basis of data analysis in order to meet the business requirements

 TRAINING IN SAP (Company : ABB)

Content:

• Getting an overview of different modules which mainly includes

1. PP (Production and Planning)

2. MM (Material Management)

3. PM (Plant Maintenance)

4. SD (Sales and Distribution)

5. SCM (Supply Chain Management)

References provided upon request.



Contact this candidate