Sap Project
Resume:
Aashish Sinha [pic]
I am a consultant with IBM India Pvt Ltd with more than 6 Years of
experience in IT Industry. I have worked extensively in, SAP XI, webMethods
and Informatica. I am a certified Development Consultant of SAP NetWeaver
2004s - Exchange Infrastructure (PI 7.0).
Education
Bachelor of Computer Application
1999-2002
Indira Gandhi National Open University
Certifications
SAP PI 7.0: Development Consultant of SAP NetWeaver 2004s - Exchange
Infrastructure.
Certificate ID: 000*******.
IT Exposure
Language C, C++, Core Java
RDBMS MS Access, SQL Server 7.0, Oracle 9i, Sybase, MySql
Operating Systems MS Windows, UNIX, Windows NT, Linux, HP-UX 9000/11.0
Web Programming HTML, XML, Java Script, JSP, EJB, DSP
EAI SAP XI/PI 7.0, 7.1, SAP CE 7.1, webMethods
Integration Server, Developer,
Trading Network, Broker Version 6.1, Mercator (Partly),
SAP BC
ETL Informatica 6, SAP BI
PLM Optiva 4.6 (Product lifecycle
Management Tool)
Passport Details
Passport Number F7419445
Valid Till 26th Mar 2016
Work Experience
IBM India Pvt. Ltd.
Jan 2010 - Till Date
Designation: Sr. System Engineer
Software: SAP XI (3.0, 7.0 and 7.1), SAP Auto ID Infrastructure (AII) and
SAP OER.
Platforms: Windows 2000, Linux
Projects: (please refer to appendix for the details of these projects)
. SAP AII - OER implementation (SAP RFID Infrastructure / SAP Item
Serialization)
. AMDS SAP Implementation
Atos Origin Ltd.
July 2006 - 4th Jan 2010
Designation: Systems Analyst
Software: SAP XI (3.0, 7.0 and 7.1), CE 7.1, webMethods 6.1, webMethods
6.5, and DSP, SAP 4.7 Enterprise Editions.
Platforms: Windows 2000, Linux
Projects: (please refer to appendix for the details of these projects)
. PI 7.1 and CE 7.1 Ramp Up(Onsite/Offshore)
. MDM - SAP XI - SAP R/3 and Multiple CRM System (Onsite/Offshore)
. Upgrade Tooling R/3 4.7 to ECC 6.0(Onsite)
. Migration from WebMethods 6.1 to WebMethods 6.5 (Onsite)
. SAP XI Production Line
Asian Paints Ltd.
Oct 2004 - July 2006
Designation: Programmer Analyst
Software: Oracle 9i, Sybase, Perl, And Web methods 6.1, Informatica, DSP,
SAP 4.7 Enterprise Edition.
Platforms: Windows 2000, Linux, HP-UX
Projects: (please refer to appendix for the details of these projects)
. Product Lifecycle Management : Formulation Control System
. Supplier Management: Supplier Portal
. Invoice Verification and Document Posting System: Accounts Portal
. Online system for Outside Processing Centers: OPC Portal
. Epayment : Cheque Outsourcing
Informatica Power Center and Power Connect Works:
Synopsis:
Working on I2 project, which involves creating Informatica, transforms to
load data into ODS (Operational data source) and DMS (Data Management
Systems) based on which I2 engines run. The sources and targets for
transforms are Oracle 10g, SAP RFC/BAPIs, ABAP Open Sql, mainframes and
flat files. Informatica Power Center 6.2 and Informatica Power Connect 6.2
were being used as the ETL tool.
National Center for Software Technology, Mumbai
July - Oct 2004
Title: Development of website for Artificial Intelligence Conference,
2007 Duration: 3 months
Software: HTML, XML, CSS, Java Script, JSP
Platform: Windows 2000
Synopsis:
Developed a website for the International Joint Conference on Artificial
Intelligence that contains:
. Some tutorials on Artificial Intelligence
. Space for submission of AI research papers, nominations, participating
companies, universities etc.
Member companies and institutions include Indian Institute of Technology
Bombay, Indian Institute of Information Technology, Centre for Development
of Advanced Computing, Hewlett Packard, Tata InfoTech, Novell and many
universities from the United States & United Kingdom
Achievements
. Appraised from Programmer to Programmer Analyst within a year in Asian
Paints Ltd.
. Secured 87 Percentile in Competence in Software Technology 'G' level
entrance examination in 2004.
EXTRA-CURRICULAR ACHIEVEMENTS
Chess
. Member, State chess team, National 'B' level chess tournament in 1991
. Rated 4th best player of the state in the junior level in 1991
. Won the Rajesh Memorial Open Chess tournament in 1993
. Won 6th place in Apurva Memorial Open chess tournament in 1998, 3rd
place in Ambedkar Inter school Chess championship in 1993 and 1st place
in school chess championship in 1994
. Won 3rd place in Human Open Computer Tournament in 2002
. Won 2nd place in Human Open Computer Tournament in 2003
Quiz:
. Awarded 2nd place in the "Science Day IT Quiz" at NCST in 2004
Positions of Responsibility
. Member, Placement Team, National Centre for Software Technology.
Key activities included creating the placement brochure, proactively
contacting companies and
Organizing their placement schedule on campus.
APPENDIX
This section serves to explain the projects I have undertaken so far in my
current responsibility.
Project: AMDS SAP Implementation (Arcelor Mittal)
Software: SAP Process Integration 7.0 (SAP PI), SAP BI, SAP APO and other
Non SAP Appl.
Synopsis:
The main aim of this project is to integrate SAP and Non SAP components
using SAP PI.
Role:
. Development of PI Interfaces, adapter and proxy communications.
. Responsible for Team management and Creation of functional and
technical documents and understanding client requirements.
. Responsible for converting Functional Specification to Technical
Specification and distributing to consultants.
. Responsible for the technical deliverables to the customer.
Project: SAP AII - OER implementation (SAP RFID Infrastructure / SAP Item
Serialization)
Software: SAP Process Integration 7.0 (SAP PI), SAP AII and SAP OER.
Synopsis:
The main aim of this project is to integrate SAP Auto ID infrastructure
(AII) and SAP OER (Object Event Repository) using SAP PI. For this purpose
we need to develop mappings and interfaces in SAP PI and do all setting in
SAP AII and SAP OER.
Role:
. Development of PI Interfaces, adapter and proxy communications.
. Settings at SAP AII and SAP OER side
. Custom layer creation for data communication between devices and
SAP AII as no device controller used in between and also
responsible for development of all interfaces and settings.
. Creation of BI interfaces to communicate with SAP OER repository
and integration with SAP EP i.e. sending data to Enterprise
Portal using web services.
. Responsible for Team management and Creation of functional and
technical documents and understanding client requirements.
. Responsible for creation of Project Plan based on SAP ASAP's
Methodology.
. Responsible for the technical deliverables to the customer.
Project: PI 7.1 and CE 7.1 Ramp Up (Onsite: 5 month, Continued offshore)
Software: Process Integration 7.1, Composition Environment 7.1.1. Ehp1.
Synopsis:
The main aim of this project is to check the functionalities of Process
Integration 7.1 and Composition Environment 7.1. For this purpose we need
to create some common business scenarios in Process Integration and
Composition Environment and check the newer functionalities with those
scenarios. Some of the functionalities we checked for Process Integration
7.1 are XML Validation, Monitoring Process creation, BAM Configuration,
Enterprise Service Repository, Service Registry posting and retrieving
WSDL, Net weaver Administration and Message Prioritization.
We also created some of the common scenarios to test different types of
adapters and Proxy. We also analyzed the design and configuration steps
involved.
In Composition Environment 7.1.1, I worked with Development tool CE NDS
7.1.1 (With Galaxy Design time). I created Processes in Process Composer,
Business Objects and UI and configured the whole scenario in CE 7.1.1.
Role:
. Development of PI Scenarios to check functionalities like XML
Validation, Monitoring Process, BAM Configuration (BOR Objects),
ESR, Service Registry and different types of Adapters.
. Development of CE 7.1 Scenarios in NWDS (Galaxy Framework) using
Process Composer, Composition Environment. Main aim was to
create Process, Business Objects and UI and connection between
these three. Also deployment of application on SAP AS JAVA.
Project: MDM - SAP XI - SAP R/3 and Multiple CRM System (Onsite: Client:
Efteling)
Software: MDM 5.5, Portal, SAP PI 7.0, ECC 6.0, SAP CRM 5.0
Synopsis:
The main aim of this project was to integrate MDM System with SAP R/3 and
Multiple SAP CRM and Non-SAP CRM systems using SAP XI. Portal will receive
input data and depending upon type of input (Create, Update and Search),
particular web service will be called to do further processing in MDM side.
If data get created or updated in MDM system, we need to update/create the
same in SAP R/3, SAP CRM and Non-SAP CRM systems using SAP-XI as
Integration Backbone.
Role:
. Requirement analysis with client and designing End to End
Integration Scenario and pilot product to gather actual
requirement and functionalities.
. Development of whole scenario and work distribution to team as
Team Leader.
. Responsible to gather input information from portal and
depending upon the type of input (Create/Update/Search), use web
services for MDM Interaction.
. Responsible to send data to SAP R/3 and various SAP/Non SAP CRM
systems using SAP PI/XI. Also created Inbound and Outbound ports
for MDM to SAP PI/XI communication.
. Responsible for the creation of SAP Tables to store MDM data for
updating or creation in SAP CRM systems.
Project: Upgrade Tooling R/3 4.6 to ECC 6.0 (Onsite: 2 month Client: KLM)
Software: ABAP, ECC 6
Synopsis:
In the past upgrade tooling has been developed for upgrading from SAP R/2
to SAP R/3. This tooling has not been maintained since, and is outdated.
Momentarily, there is a requirement to update the upgrade tooling to ensure
that it can be used in upgrades to SAP ECC 6.0.
Role
. Redesign of the functionality.
. Overview of all changes necessary in the upgrade, and
development of replacement patterns also for Unicode-compliance,
and development of replacement patterns.
. Collection of all expertise from earlier or current upgrades.
Project: SAP XI Production Line (Client: PBAS)
Software: SAP XI; SAP 4.7 Enterprise Editions, XML, XSLT, and Java
Platform: Windows 2000, Linux
Synopsis:
The main aim of this system is to provide solutions to the customers if any
incident occurs. The incident occurrence is dependent upon the tickets
which are generated by client if any error occurs in their SAP XI system.
Also our work includes Development of mappings and configuration of
scenarios depending upon the client agreement.
Role
. Team Management and Client Interaction
. Study existing application and landscape and suggest enhancing
productivity and performance.
. Provide Change Management as on need basis.
. Development of mappings, Integration Processes, ccBPM.
Administration in RWB using Message Monitoring, Component
Monitoring,End to End Monitoring and also Performance
Monitoring to provide status of systems to customer.
Project: Migration from WebMethods 6.1 to WebMethods 6.5 (Onsite, 5 Months)
Software: webMethods 6.1, webMethods 6.5, Oracle 9i, SAP 4.7 Enterprise
Editions, Java
Platform: Windows 2000, Linux
Synopsis:
The main aim of this project is to migrate to webmethods 6.1 services to
webmethods 6.5. It also includes upgradation of Integration Server and
Trading Network from 6.1 to 6.5.
Role
. Analysis, Design and Development of Services on WM 6.5
. Integration Server Upgrade from 6.1 to 6.5
. Trading Network upgrade from 6.1 to 6.5 and also Installation of
PRT 6.5.1.
. WebMethods Monitor Upgrade from 6.1 to 6.5
. Development of Java services for Broker Storage Files and
Performance monitoring.
Asian Paints Limited, Mumbai
Oct 2004 - July 2006
Project: Product Lifecycle Management: Formulation Control System
Software: Optiva 4.6, WebMethods IS Server 6.1, Oracle 9i, SAP 4.7
Enterprise Editions
Platform: Windows 2000, Linux
Synopsis:
This system aims to maintain formulations which are used to make paints,
using optiva tool in the oracle database. It provides plant users and
technical functions and R&D people to test paint formulas, upload formula
to optiva system, which fetches data from oracle database, also provide
functionality to interact with SAP systems using middleware tools like
WebMethods. To send data and receive data from SAP/R3, it uses a common
format as XML. Optiva sends user request to SAP in XML format using
webMethods and generate responses through IDocs in SAP,
Role
. Developed the design of this system and leading the module for
Integrating Optiva and SAP/R3 to WebMethods.
. Developed flow services and UI for invoking RFCs and BAPIs calls
and processing inbound / outbound IDocs from SAP.
. Building a role based authorization mechanism in the system.
. Trained super user and end user of the system.
Project: Supplier Management: Supplier Portal
Software: WebMethods IS Server 6.1, HTML, DSP, JSP, and Oracle 9i, SAP 4.7
Enterprise Editions
Platform: Windows 2000, Linux
Synopsis:
This web based system aims to provide real time online support to suppliers
by allowing them to view all transaction and communication details
regarding Purchase Orders raised against them which includes Purchase
Order, Accounts, Dispatch, Quality, Goods Receipt details. Purchase orders
or Goods receipt when generated in SAP are passed on to the Oracle database
through IDocs or send to vendors via Trading Network. User management is
online and functionality has been provided for suppliers to interact with
the users / buyers.
Role
. Developed flow services and UI for invoking RFCs and BAPIs calls
and processing inbound / outbound IDocs from SAP.
. Handling users queries regarding any technical aspects of the
system.
. Building a role based authorization mechanism in the system.
Project: Invoice Verification and Document Posting System: Accounts Portal
Software: Web Methods IS Server 6.1, HTML, DSP, JSP, Oracle 9i, SAP 4.7
Enterprise Edition
Platform: Windows 2000, Linux
Synopsis:
This intranet system aims at verification of Invoices raised against
various types of purchase order(s) / service orders. The Goods Receipt
details, Excise details and Material details for the particular item
details will be displayed for verification. The verified invoice is then
posted in SAP. The system reduces the time taken to post invoices,
efficient time management, reduce human errors.
Role
. Developed flow services for invoking RFCs and BAPIs calls.
. Developed appropriate UI web pages for flow services.
. Handling users queries regarding any technical aspects of the system.
Project: Online system for Outside Processing Centers: OPC Portal
Software: Web Methods IS Server 6.1, HTML, DSP, Oracle 9i, SAP 4.7
Enterprise Edition
Platform: Windows 2000, Linux
Synopsis:
This web-based system aims at for providing online processing and reporting
options to the OPCs to streamline business process, reduce paper work,
efficient time management and reduce human errors.
Role
. Maintenance of the System
. Developed flow services for invoking RFCs and BAPIs calls.
. Developed appropriate UI web pages for flow services.
. Handling users queries regarding any technical aspects of the system.
Project: EPayment: Cheque Outsourcing
Software: Web Methods IS Server 6.1, HTML, DSP, Oracle 9i, SAP 4.7
Enterprise Edition
Platform: Windows 2000, Linux
Synopsis:
This intranet system aims at payments to Asian Paints Trading partners like
SBI, HDFC, and Citibank electronically in real time. After each transaction
it maintains all information in Oracle database table and maintains all
logs in other log table. This application also maintains the XMLs which is
sent to Trading partners in a separate folder in IS Server.
Role
. Developed flow services for invoking RFCs and BAPIs calls.
. Developed appropriate UI web pages for flow services.
Administration of the web Methods IS server and Trading Networks:
. Troubleshooting and monitoring the web Methods server.
. Installed Elemica Connectivity Package in Web Methods IS
. Managing the server, error and other log files.
. Package and User management
. Changing the users, group and ACL settings.
Informatica Power Center and Power Connect Works:
Synopsis:
Working on I2 project, which involves creating Informatica, transforms to
load data into ODS (Operational data source) and DMS (Data Management
Systems) based on which I2 engines run. The sources and targets for
transforms are Oracle 10g, SAP RFC/BAPIs, ABAP Open Sql, mainframes and
flat files. Informatica Power Center 6.2 and Informatica Power Connect 6.2
were being used as the ETL tool.
Responsibilities:
. Develop Informatics mappings to extract, transform and load data from
legacy systems and Sap R/3 to DMS (Oracle) and from DMS to ODS
(oracle) and from DMS to SAP. This transformed data is used by I2
Technologies DP (Demand Planner), SCP (Supply Chain Planner), FP
(Factory Plan) and RPS (Rhythm Production Scheduler) Engines, which
are used to generate forecasts, Schedule deployments, schedule the
daily time by time Production based upon the fortnight plan and
generates optimized time base Schedule for production based upon
penalties & constraints.
. Worked with ETL architect to develop ETL design.
. Making structural changes to the databases when design changes are to
be implemented. Also implemented those changes in Informatica
mappings.
. Developed UNIX shell scripts to take regular backup of Informatica
repository and scheduled it in Informatica.
. Developing UNIX shell scripts and SQL scripts to carry out routine
checks on databases. This also included running DDL SQL Scripts using
informatica through UNIX shell scripts.
Final Year Project (Internship) National
Insurance Company Ltd.
Title: Development of Insurance Information System
Duration: 4 months
Software: Visual Basic, Oracle, FrontPage
Platform: Windows NT
Description:
Develop and implement a full-feature Insurance System for vehicles that can
serve multiple clients simultaneously. All transactions and transfers to
the centralized database Oracle 8 were automated. The system contains 18
tables, 60 queries, 4 stored procedures and 2 triggers.
Achievements:
. Successfully implemented the insurance system for two-wheelers, three-
wheelers, four wheelers and LMVs (Light Motor Vehicles).
. Also created web pages for insurance information using FrontPage, for
general information of company employees
Contact this candidate