Project Data
Resume:
SRINIVASA REDDY Email:
********************@*****.***
Hyderabad Mobile:
Professional Summary
V Having 4.5 years of IT experience
V Extensive implementation experience in Siebel CRM Applications
V Experience in total life cycle of Siebel Implementation
V Experience in Enterprise Integration Manager for Data Loading
V Experience in loading User data
V Experience in Preparation of control files (SQL loader) for external data
load
V Experience in WinSQL, TOAD, SQL Developer
V Experience in writing SQL Commands and scheduling PL/SQL Procedures
V Experienced in coding programs in Pl/Sql.
V Good knowledge of UNIX shell scripts
V Knowledge on ETL tool, Oracle Argus
V Proficient in handling projects efficiently for delivering required
applications in a very systematic way.
Work Experience
> Working as a Technology Analyst for Infosys Limited, Hyderabad (SEZ)
from Aug'12 to till date.
> Worked as an Analyst Programmer for Wipro InfoTech, Gurgaon from
June'09 to Aug'12.
> Worked as an Asst System's Engineer for T.C.S Ltd, Mumbai from July'08
to Jan'09.
Academic Qualification
> Master of Computer Applications from Osmania University, Hyderabad with
72% in 2006
Technical Skills
SQL,PL/SQL (Oracle 10g,11g)
SQL Developer (Oracle)
Siebel CRM-7.7/8.X
Siebel - Tools, EIM
TOAD
Basic knowledge of UNIX, ETL, Oracle Argus
Domain Knowledge
Good knowledge in Enterprise Solutions, Telecom, Automobile and Finance.
Project Experience
Project #1
Project: HISNA Siebel Implementation
Organization: Infosys, Hyderabad
Client: Hyundai, US
Role: Technology Analyst
Skills: Siebel 8.1, Oracle 11g, UNIX
Duration: Sept 12 to till
Team Size: 13
Description:
Hyundai Information Service North America (HISNA), an information
technology organization committed to providing world-class technology
services to its clients throughout North America.
In today's fast-paced global business environment, information technology
is a necessity to reduce costs, build competitive advantage, and increase
market share. With that understanding, Hyundai Kia Motor Group established
Hyundai Information Service North America in March 2005.
By consolidating all IT related resources into one company, HISNA will be
able to maximize its synergy to provide top quality IT services to its
Hyundai Kia Motor Group companies and act as the information bridge between
Global Headquarters and North America.
Responsibilities:
. Created mapping sheets for Account, Contact, Dealer, Vehicle,
Products, Parts
. Validation of data in EIM tables before loading to avoid the errors
. Involved in the preparation of control files for external data
. Creation of configuration file. Updating the IFB files based on
specific requirement for run the EIM
. Run EIM jobs to load data into Siebel base tables from EIM tables
. Involved in running the EIM process using Import, Export and Delete
. Involved in PL/SQL procedures creation, Triggers
. Written Shell Scripts to run Siebel jobs
. Worked on Unix environment for multiple purpose
Project #2
Project: DICV Siebel Implementation
Organization: Wipro, Chennai
Client: Daimler, Germany
Role: Analyst Programmer
Skills: Siebel 8.1, Oracle 11g, UNIX
Duration: April 11 - Aug 12
Team Size: 26
Description:
In 1886, Gottileb Daimler and Carl Benz, the founders of Daimler AG, gave
the world, it's very first Automobile, marketing the beginning of the Auto
History, and proudly continue creating it till date with its global brands.
The current brand portfolio includes the world's most valuable automobile
brands, Mercedes Benz, Smart, Maybach, Freightliner, Western Star,
Mitsubishi Fuso, Setra, Orion and Thomas Built Buses. Daimler is an
automotive Group with a commitment to excellence, aiming to achieve
sustainable growth and industry-leading profitability. Daimler India
Commercial Vehicles (DICV) is a 100% owned Daimler subsidiary in India.
DICV will initially produce Light, Medium, and Heavy-Duty Commercial
Vehicles for the India market. Daimler Mercedes-Benz trucks will be brought
under the umbrella of Daimler India Commercial Vehicle, which will assume
the responsibility of sales and marketing with immediate effect. Currently,
Mercedes-Benz India sells Actros brand trucks which will now fall under
DICV.
Responsibilities:
. Involved in Migrating Data in Pre-Prod and Production using EIM
process
. Created mapping sheets for Account, Contact, Dealer, Vehicle,
Products, Parts
. Validation of data in EIM tables before loading to avoid the errors
. Involved in the preparation of control files for external data
. Creation of configuration file. Updating the IFB files based on
specific requirement for run the EIM
. Run EIM jobs to load data into Siebel base tables from EIM tables
. Involved in running the EIM process using Import, Export and Delete
. Tracking the errors using Log file and troubleshooting.
. Involved in PL/SQL procedures creation
. Written Shell Scripts to run Siebel jobs
. Worked on Unix environment for multiple purpose
Project #3
Project: Aircel Siebel Implementation
Organization: Wipro, Gurgaon
Client: Aircel, INDIA
Role: Analyst Programmer
Skills: Siebel 8.0, Oracle 10g
Duration: June 09 - Mar 11
Team Size: 32 Members
Description:
Aircel is the India's largest telecom provider in India the project
involves the customization of Siebel CRM and import Prepaid & Postpaid data
and migration of existing circle. Siebel 8.0 the process of customization
involves analysis, customization at database level. Aircel begin its
outwards expansion in 2005 and met with unprecedented success in the
Eastern frontier circle. It emerged a market leader in Asian and North
Eastern Provinces within 18 months of operations. Till today, the company
gained a foothold in 23circles.
Responsibilities:
. Involved in Migrating Data in Pre-Prod and Production using EIM
process
. Involved in developing PL/SQL procedures.
. Involved in preparation of mapping sheets using tools
. Experienced in handling the performance related issues while loading
large volumes of data
. Involved in the preparation of control files for external data
. Develop procedures for loading data from staging table to EIM tables.
. Creation of configuration file. Updating the IFB files based on
specific requirement for run the EIM
. Run EIM jobs to load data into Siebel base tables from EIM tables
. Developed batch files to automate the process of running EIM job.
. Involved in preparation of shell script for batch job scheduling.
Project #4
Project: Kotak Mahindra Siebel Implementation
Organization: TCS, Mumbai
Client: Kotak, INDIA
Role: Assistant System Engineer
Skills: Siebel 8.0, Oracle 10g
Duration: July 08 - Jan 09
Team Size: 30 Members
Description:
Kotak is one of India's leading financial institutions, offering complete
financial solutions that encompass every sphere of life. From commercial
banking, to stock broking, to mutual funds, to life insurance, to
investment banking, the group caters to the financial needs of individuals
and corporate. Kotak has different organizations like Kotak Life, Kotak
Security etc.
Responsibilities:
. Involved in Migrating Data in UAT and Production using EIM process
. Extensive knowledge in preparing the 'Data Mapping Documents' for
mapping the Legacy Data to
Siebel Tables.
. Experienced in handling the performance related issues while loading
large volumes of data using
Siebel EIM.
. Extensive knowledge in preparing the IFB files.
. Develop scripts to qualify and validate (Pre Processing) the data and
move data from staging tables to Siebel EIM tables.
. Designed, documented and published Data Mappings based on the business
requirements, required Columns, User Keys and LOV values using Siebel
tools, EIM tables and Base Tables.
. Developed multiple control files for loading data into EIM tables
Contact this candidate