SAP HANA Certified Consultant

Software Professional with 10+ years of experience in ERP, EAI, Object Oriented Programming, Networking and Internet/Intranet based Systems involved in design, development, implementation, Testing and System Administration. Good technical knowledge in SAP HANA, SAP Business Objects Data Services, Software AG Products, SAP PI, WSDL, SOAP, Java, J2EE, EJB, JSP, OOAD, BEA WebLogic, XML, Oracle & Informatica. Involved in all phases of software development life cycles including QA/QC activities. Possesses good verbal and interpersonal skills and a quick learner.

TECHNICAL SKILLS:

• EAI: Webmethods 7.1.2/6.5/6.01, SAP PI, SAP CE BPM
• B2Bi: Integration Server, WebMethods Trading Networks
• Programming Languages: Java, C++, Pl/Sql, UNIX Shell Scripts, XML
• Application Servers: BEA WebLogic4.5/5.1/6, IBM WebSphere
• RDBMS: Oracle 10g/9i, SQL Server 7.0, DB2
• Operating Systems: Windows XP/NT, UNIX
• Tools: TOAD, PL/SQL Developer, Microsoft SQl Server
• Scheduling tools: Tivoli
• Version Control tools: PVCS, VSS
• ERP: SAP, PeopleSoft
• Data Modeling: SAP HANA Studio
• Data warehouse ETL Tools: SAP Business Objects DataServices 4.0, Informatica Power Center 8.1/7.1
• Data Mapping: XML, Electronic Data Interchange (EDI)
• Data Formats: EDI, EDIINT, SAP IDocs, XML, xCBL, cXML

WORK EXPERIENCE:

Confidential, MN April 2004 to till date
HANA Projects:

• Implemented two projects on SAP HANA.
• Involved in business and Architecture discussions.
• Worked closely with SAP Technical team on implementing the First Customer's project on HANA.
• Involved in installation of SAP HANA 1.0.17 in two environments.
• Involved in installation and configuration of SAP Business Objects Data Services 4.0.
• Used SAP BW/SAP CRM/Oracle as source and HANA as target with SAP Data Services as the Integrator.
• Developed Jobs in SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.
• Worked closely with WEBI Reporting team on the requirements.
• Created Attribute, Analytical and Calculated views as per the requirement needs.
• Created procedures in HANA Database.
• Involved in Support and Monitoring activities after go-live.
• Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA.

Other Integrations projects

• Involved in business discussions, Architecture discussions and writing the Technical documentation.
• Worked very closely with SAP process teams in understanding the functional requirements
• Involved in design, development and support of the integrations.
• Developed various integration solutions which use IDocs, RFCs, Flat Files & EDI to interact between SAP and various different legacy systems and applications.
• Developed reusable java services which are used in almost all the integrations.
• Involved in design and development of common flat file transfer framework between SAP and Webmethods.
• Worked on EDIFACT Transaction sets: EDIfact 96A Orders, 99B DELFOR, 99B INVPRT
• Worked on SOAP web service calls to interact with Salesforce (SFDC).
• Involved in volume testing, regression testing to check the performance of all the interfaces.
• Developed interfaces using Informatica.
• Working on SAP PI projects.
• Worked on SAP CE BPM and SAG BAM projects.

As an Administrator:

• Participated in all system management activities including software upgrades, installations, performance monitoring and tuning.
• Participated in upgrading Webmethods 6.5 environment to 7.1.
• Installed, upgraded, configured and performed maintenance tasks on Integration Server, Broker, My Webmethods Server and TN Server.
• Configured SAP Connections, Listeners, Notifications and Adapter services (RFCs) for communication between SAP and Webmethods.
• Worked closely with WebMethods (Software AG) Tech Support to resolve various issues.
• Interacted with SAP Basis team, network, database, and Unix administrators to seamlessly implement solutions to complex technical issues
• Worked closely with project application architects and developers to ensure that proper application-integration is being built in to all components of the application(s) and systems
• Support the design and implementation of WebMethods, SAP topologies
• Fixed various Production - application's and infrastructure issues.
• Created UNIX scripts which purge the data at database level and on file systems.
• Developed/configured the monitoring tools.
• Weekly code migrations to production environments.
• Rolled out 7 Generations (Based on geographies) to Production till today.
• 24/7 production support.
• Handled Production environment outages (Ramp down & Ramp up processes) in line with SAP.
• Involved in weekly Informatica code migrations.

Environment: SAP HANA 1.0.17, SAP Business Objects DataServices 4.0, Webmethods 7.1.2/6.5/6.01, MWS, Webmethods Integration Server 7.1/6.5/6.01, Trading Networks 7.1/6.0/6.5, Broker, SAP Adapter 6.5/4.6, SAP, SAP PI, SAP CE BPM, UNIX Scripts, DB2, Oracle10g, SQLServer, Informatica, Web services, Windows NT, Sun Solaris (UNIX).

Confidential, MN - Jan 2003 to Mar 2004
Webmethods Developer

Development on webmethods 6.1/6.0/5.0

• Installed and configured 6.0.1 JDBC, I/O, Oracle, MQ Series Adapter, B2BServer Package Adapter, XML Adapter, Brokers.
• Created message handlers on WebSphere MQ3.0 and adapter services for JDBC adapter.
• Responsible for developing the database interfaces including Stored procedure calls using JDBC adapter.
• Used Migration Utility Tool to generate the documents types and Oracle adapter services.
• Developed flow services in Developer. Requirement gathering, Gap Analysis, Client & User interaction for design.
• Installed and Configured Enterprise Server, Oracle Applications Adapters, Enterprise MQ Adapters, Database Adapter etc.
• Created Brokers, Document scope, document type, client groups, external clients.
• Developed Integration component, configured operations, scripted operations in Enterprise Integrator.
• Used Flow Diagram and Blue print Editor to create Operation Steps and Input, Output fields mapping.
• Setup for Client Queue, Client Group, Event/documents types like volatile, persistent etc.
• Provided solution for business integration rule with components and configured operations after creating intelligent adapters like source and target agents.
• Worked on IO Adapter to parse the Flat Files.
• Performed Unit /Integration /Functional /Regression /Stress /Performance /Acceptance tests.
• Involved in three migration projects (Webmethods 4.6 to 6.0).

Development on Automate Deployment

• Designed and developed an application for automate deployment.
• Developed UNIX scripts on ANT tool for automation.
• Created webmethods flow services to support the automation.
• Installed and configured the tomcat server.
• Deployed and tested the application on tomcat server.
• Involved in testing and deploying the application on production server.

Environment: Webmethods 6.1/6.0/5.0, Webmethods Integration Server 6.0/4.6, Enterprise Integrator 4.6, Doc Tracker 4.5, Trading Networks 4.6, MQSeries, UNIX Scripts, CruiseControl 2.1, DB2, Oracle9i, Windows NT, Sun Solaris (UNIX).

Confidential Feb 2002 to Oct 2003
Sr.Analyst Programmer

• Involved in design, development, testing & implementing the Vehicle Inspection and Type Approval System (VITAS) application for Land Transport Authority
• Actively participated in requirement analysis, code reviews and testing design documents
• Designed & developed a framework encapsulating following functionalities:
• Online Application Submission Module
• Vehicle Inspection Module
• Document Management System
• User management
• Designed & developed a helpdesk providing following features:
• Customer Support
• Check the Status of the Application
• Reporting
• Created several interface functions using J2EE, XML to interface with external Electronic Road Pricing (ERP) & Motor Vehicle Project (MVP) systems.
• Created several stored procedures to get the data from external interfaces (XML) and to pump data into database tables.
• Created several stored procedures and SQL scripts to generate the reports required by VITAS application
• Created & Configured ODBC data source to point Oracle database.
• Involved in Load and Performance testing.
• Actively participated in bug review/bug fixing.

Environment: J2EE, XML, Servlets, Jsp, JBuilder7.0, Rational Rose (UML), Dream Weaver, JavaScript, CSS & Html, UNIX Scripts, Weblogic, Oracle, ETester, Windows NT, Sun Solaris (UNIX).

Confidential, Singapore Jul 2001 to Jan 2002
Software Engineer

• To analyze and implement PC-Phone billing model
• Gather requirement from various divisions such as Customer support, finance and network operations center and design and manage the implementation of those requirements.
• Designed and developed a framework using J2EE technologies on Weblogic encapsulating following functionalities:
• Account Management
• Rate Scheme Management
• Order Management
• Call Detail Management
• Designed and developed a helpdesk providing following features:
• Customer Support
• Monitoring system & process status
• Reporting such as finance reports
• Designed & developed a framework using Struts, J2EE, J2SE & XML on Weblogic for payment module to interface with HSBC System for validating the Credit card details and inserting the transaction details in database.
• By Using Object Oriented Programming in Java, Written different Java classes as per business requirements.

Environment: J2EE, J2SE, XML, Jakarta Struts, Servlets, Jsp, Visual Interdev, JavaScript, CSS & Html, UNIX Scripts, Weblogic 6.1, Apache Server, DB2, Oracle9i, Windows NT, Sun Solaris (UNIX).

Confidential, Singapore - Jul 2000 to Jul 2001
E-Commerce Consultant

• Designed & developed an intranet based application with following functionality:
• Human Resource Corner
• Officer Resource Management
• Purchase Order System
• Leave Management System
• Developed a mass mailing system using J2EE technologies on Weblogic Application Server.
• Setup the Server and Client configurations for Oracle Server database.
• Involved in User Acceptance Testing there by fixing the bugs reported by customer.

Environment: J2EE, XML, Servlets, Jsp, Jbuilde5.0, JavaScript, CSS & Html, Weblogic4.5, Oracle, Windows NT, Sun Solaris (UNIX).