Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Profile & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
SKILLS SUMMARY:
EDUCATION:
Mumbai
University , May
2006
Mumbai
University , Aug
2001
Download Resume Format
SUMMARY:
Ø 5 years of
progressive experience in various phases of IT project life cycle
Ø Concentrated
highly on the Siebel application suite and have hands on experience on Siebel 6.0,
7.X and Siebel 8.1
Ø Excellent
experience in Siebel (CRM), Oracle PL/SQL
Ø Experience
in designing and developing of interfaces using Siebel EIM for Data
Integration.
Ø Excellent
experience in Loading data from legacy systems to Siebel using PL/SQL, SQL Server, SQL Loader
Ø Siebel
eBusiness Enterprise Applications Implementation experience including ePharma,
eSales and Siebel eMedical.
Ø Siebel CRM
experience with expertise in EIM, Configuration, Scripting, Workflow,
Assignment manager and Integration of Enterprise applications, Siebel CRM
product and tools, Siebel Business Services.
Ø Configuring
Applications using Siebel Tools and Siebel eScript and VBScript.
Ø Knowledge
of Siebel Analytics.
Ø Troubleshooting
production issues related to Configuration, Infrastructure and User related
defects on any version of Siebel application
Ø Designed
the ETL processes using SQL Server DTS, SSIS packages to load data from non
homogeneous source system (File source and Oracle) into the targets in to
Enterprise Data Warehouse
Ø Involved
in configuring and customizing UI objects like applets, views, screens, Pick
Lists, Drill down, MVG using Siebel tools.
Ø Created
links and joins for the business components.
Ø Worked
closely with Onshore and Offshore teams from US and India for development, and
production support tasks.
Ø Excellent experience
on Oracle database Stored Procedures, Functions and Packages.
Ø Knowledge
of UML designing using MS Visio.
Ø Well
acquainted with software development life cycle (SDLC)
Ø Excellent
experience in designing and execution of test scenarios and test cases
Ø Excellent
experience in preparing various documents required for testing environment
Ø Exposed to
CMMI, Quality and Testing Excellence Processes.
Ø Conducted
Siebel EIM training at Cognizant Technology Solutions.
Ø Good
communication, analytical and troubleshooting skills.
EXPERIENCE:
Employer:
IQ Tech Pros
Client:
Boeing, Renton, Washington, USA
Project: MyOpsCenter Feb 2010 – June 2010
Location: Washington,
USA
Role: Interfaces
& Data Migration Expert
The Boeing Company is
the world’s leading aerospace company and the largest manufacturer of
commercial jetliners and military aircraft combined. Boeing has customers in
more than 90 countries around the world and is one of the largest U.S. exporters
in terms of sales. Boeing is seeking information technologies to improve their
enterprise Sales Operations functions related to Boeing Commercial Airplanes.
Siebel Sales served as the primary system for Airplane and Services Sales teams
to manage their work. It provides a
standard system to incorporate all Sales activities for Boeing Airplane and
Services sales. The system is fully integrated and optimized for sales
operations.
Technology:
Ø Siebel
8.1.1.2
Ø Siebel
Tools 8.1.1.2
Ø Oracle 10g,
11g
Ø SQL Server
2005/2008
Ø SQL
Developer
Ø PL/SQL
Ø SQL Loader
Ø SVN
Responsibilities:
Ø Analyzed the different client systems and their data model with Oracle
10g and SQL Server 2005 as the backend.
Ø Prepared the plan for data migration from the client systems to Siebel
and final schema for the target application for Dev, Test and Production
Rollout
Ø Supported the Data warehousing team to prepare the Data Model and create
complex views for carrying out nightly loads from Siebel 8.1 using backend as
Oracle 11g to Data warehouse (Teradata).
Ø Prepared the plan and designed complex views in target application to
migrate the transactional data from Siebel using backend as Oracle 11g to the
Data warehouse (Teradata).
Ø Analyzed the Data Model for the different Client systems using Oracle 10g
and SQL Server 2005.
Ø Gathered Requirements from the Client and checked the technical feasibility
for the same and prepared the Data Migration and Interfaces Requirement
document.
Ø Prepared the High Level Design document describing solutions to the
client requirements and how the same will be implemented.
Ø Prepared the Data Mapping Sheet, which is also a deliverable to the
client which gives the Source systems to Siebel EIM tables and Siebel Base
Table and column mappings.
Ø Created DB Links and Materialized views in Oracle 11g to extract the data
from source database servers.
Ø Created complex PL/SQL packages and stored procedures in Oracle 11g to cleanse,
normalize or de-normalize and update client application data to migrate the
data from the Source Systems to the staging tables and from here into the
Siebel EIM tables.
Ø Also used MS Access for Data Cleansing, Normalizing and De-normalizing
data to convert the client system data as per Siebel EIM format
Ø Written macros in MS Access to export the data from MS Access to flat
files and csv files, and from there loaded the data into Siebel EIM tables
using SQL Loader. Also written control files and scripts to transform the data
from the flat/csv files into Oracle 11g database and run those automatically
through .bat files.
Ø Created interfaces using PL/SQL in Oracle 11g to propagate the changes
made in different client applications on a daily basis in Siebel application by
scheduling nightly EIM batch jobs in Siebel.
Ø Created DBLinks, Materialized Views, Views and Staging tables to pull
data from the client applications for the interfaces and initial data migration.
Ø Created custom tables in Siebel and extension columns in already existing
Siebel Base Tables and also created corresponding EIM table columns and EIM
table column mapping for the same.
Ø Configured IFB files for migrating data from Siebel EIM tables to Siebel
Base Tables and Intersection Tables.
Ø Created scripts to automatically load data from different environments
into Siebel using VB scripting and bat files.
Ø Prepared Low Level Design document with a detailed description of the
requirements implemented.
Ø Created Unit Test scripts and other test scripts to test the
functionality of the application, data migration and interfaces.
Ø Coordinated daily with the offshore team through nightly conference calls
and emails to provide them the necessary project details and updates required
to support development.
Ø Worked with the client to fully support Test and Production data
rollouts.
Ø Worked with the client team to support deployment activities.
Employer:
Cognizant Technology Solution US Corp
Client:
Alcon Laboratories Inc, Fort Worth, Texas, USA
Project:
Alcon Siebel Upgrade Nov
2006 – Feb 2009
Location:
Texas, USA & Mumbai, India
Role:
Technical Analyst
Alcon, the leader in
eye care, strives to make significant contributions in the fight to prevent and
eliminate blindness. Alcon is dedicatedly providing the highest quality eye
care products for treating various eye diseases and eye conditions. Alcon was
in the process of developing and implementing Siebel 7.8 e-medical for Sales
for Salsa and SalsaLite countries.
Responsibilities:
Ø Gathered requirements and migrated data for entities like Employee,
Position, Mobile Clients, Accounts, Contacts, Products, Service Requests and
Activities and their associations with other entities
Ø Migrated data from SQL server 2000 and excel sheets into SQL Server 2005
Ø Migrated data for more than 25 different countries
Ø Analyzed the source and destination systems, that is, Siebel 6 and Siebel
7.8 and their Data Model in SQL Server 2000 and SQL Server 2005
Ø Created MDBs to extract, cleanse, normalize, de-normalize and apply
country-specific business logic by writing complex SQL queries in MS Access and
to convert the de-normalized legacy system data as per Siebel EIM format
Ø Involved in preparing Data Mapping between legacy systems and Siebel by
developing MS SQL DTS and SSIS packages
Ø Extended Siebel tables through custom tables and columns
Ø Worked with data import and export and integration with legacy systems.
Modified and designed batch jobs to import, update, delete, export data between
Siebel Database and legacy systems
Ø Configured and optimized configuration (.IFB) files to run the EIM job
for loading data into the base tables and intersection tables.
Ø Prepared the EIM jobs integrating with the external system for bulk data
import, export, update and delete
Ø Written Siebel VBCOM scripts for migrating data which cannot be loaded
through EIM due to Siebel application restrictions
Ø Used EIM log files to check and debug errors if any
Ø Created unit test cases and used it for testing the application
Ø Worked with the team to deploy the application in the Test and Production
environments
Employer: Patni
Computers
Project:
Sunrise Decision Support Manager (SDSM) 2005
– 2006
Role:
Software Developer
SDSM is a MIS (Management
of Information System) product which is used by hospitals for management of
information. It is a decision support system used by the hospitals to maintain
records of the patients, medicines, treatments, medicine stock, and doctors to
offer the patients the best and most cost effective treatment. This system also
supports the Top level Management of the hospitals to take various business
decisions.
Technology:
Ø VC++ (MFC)
Ø Visual
Basic 6
Ø SQL Server
2000
Ø Rumba
Ø Crystal Reports
Ø VSS
Responsibilities:
Ø Requirement
Analysis of the enhancements and defects and preparation of the technical plan
to implement the requirements like implementing additional business logic in
the existing system, modifying existing system, creating new reports and
modifying the existing ones.
Ø Impact
Analysis; studying the impact, the implementation of the enhancements and
defects would have on the existing reports and system and accordingly prepared
the impact analysis document.
Ø Development;
actual coding of the business requirements in VC++ and VB 6 and integrating it
with the existing application.
Ø Testing
the implementation by importing the data into the test environment. Also
creating test cases for integration testing.
Ø Documentation
of the business enhancements and defects starting right from the requirement
analysis phase, impact analysis, development, integration, testing to the final
closure of the requirement.
Ø Responsible
for the Configuration Management of the project using VSS 6
COURSES/WORKSHOPS ATTENDED
Year and Month
|
Title
|
Location
|
Organized by
|
July
2008
|
Informatica
|
Mumbai
|
Cognizant
Technologies
|
July
2008
|
Data
warehousing & ETL
|
Mumbai
|
Cognizant
Technologies
|
January
2007
|
Siebel
and its Utilities like Actuate Reports
|
Mumbai
|
Cognizant
Technologies
|
December
2006
|
J2EE & Advanced Java
|
Mumbai
|
Cognizant
Technologies
|
November
2006
|
Oracle
& PL\SQL
|
Mumbai
|
Cognizant
Technologies
|
November
2006
|
Procedural
Programming & OOPS concept (C & C++)
|
Mumbai
|
Cognizant
Technologies
|
COURSES/WORKSHOPS
CONDUCTED
Year and Month
|
Title
|
Location
|
Organized by
|
June 2010
|
Siebel EIM
|
Seattle,
Washington
|
Boeing
|
May 2008
|
LOV
Compare Tool
|
Mumbai
|
Cognizant
Technologies
|
February
2008
|
Siebel
EIM
|
Mumbai
|
Cognizant
Technologies
|
February 2008
|
MS
Access
|
Mumbai
|
Cognizant
Technologies
|
February
2008
|
SQL
Server 2000
|
Mumbai
|
Cognizant
Technologies
|
February
2008
|
DTS
Packages
|
Mumbai
|
Cognizant
Technologies
|
SKILLS SUMMARY:
CRM
CRM: Siebel 6.0 / 7.5
/ 7.7 / 7.8 / 8.0 / 8.1
Siebel Applications: Pharma and Sales
Siebel customization tools: Siebel Tools, Siebel VB, e-Script
Siebel business automation: EIM
Siebel Applications: Pharma and Sales
Siebel customization tools: Siebel Tools, Siebel VB, e-Script
Siebel business automation: EIM
Databases
Oracle 8i,
9i, 10g, 11g
MS SQL
Server 2000, 2005, 2008
MS Access
Database
Utilities
Toad
SQL Loader
SQL*Plus
SQL
Developer
SQL
Server Management Studio
Programming
Languages
C
C++
Core Java,
Advanced Java, JDBC, Servlets
Visual
Basic 6.0
PL/SQL
T-SQL
Web
Development
HTML
Javascript
Others
Informatica
Visio
Certifications
Completed:
MCTS, Microsoft SQL
Server 2008, Implementation and Maintenance
Oracle 11g (OCA)
Cognizant Certified
Professional for Oracle 8i & PL\SQL
Cognizant Certified
Professional for Siebel 7.8
Certifications
Pursuing:
MCTS, SQL Server
2008, Business Intelligence Development and Maintenance
Oracle 11g (OCP)
EDUCATION:
Master's Degree in
Computer Applications (M.S equivalent) Mumbai , India
Bachelor of Commerce (Financial Accounts & Economics) Mumbai , India
Download Resume Format
0 comments:
Post a Comment