PROFESSIONAL SUMMARY

• Highly experienced IT professional with 12+ years of commitment to excellence and the implementation of best practices worldwide specializing in ETL, Data Warehousing, Data Migration, Data Modeling, Business Intelligence, Enterprise Resource planning (SAP R4.7D, BaaN ERP).
• Extensively worked on Informatica SAP BAPI/IDOCs transformations, Webservices transformations and security/certificates/mutual authentication configuration using Informatica 8.6, Siebel reports (Answers & Dashboards).
• 9+ years of strong experience in Data Warehousing and ETL using Informatica Power Center 8.6/7.1.3/6.2 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, and Informatica server), Webservices and security configuration in Informatica server (end-to-end), Power exchange, Power Connect, SAP BW.
• 3+ years of full cycle SAP R/3 & SCM (Rockwell Scheduler, i2) application software implementation experience as SAP ABAP consultant, Integration of SAP (PP, MM and SD Modules) with SCM application Rockwell Scheduler using SAP JCO connector, Web Methods, BAPI and RFC. RFID Integration with SAP 4.7D for Asset tracking project. Integration of SAP R/3 software with MES software (FlexNet 7.2- Apriso) using ALE& IDOCS.
• Eight Plus (9+) years of experience working on End-To-End implementation of Data warehouse and Strong understanding of Data warehouse concepts, ETL, Star Schema, Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT & Dimensions tables, Physical & logical database design and modeling, ERwin 4.5.
• 9+ years of Database experience using Oracle 10g/9i/8i/ DB2 8.0/7.0, Teradata V2R5, MS SQL Server 2008/2005/2000/7.0, MS Access 2003/2000, XML, T-SQL, SQL*Plus, PL/SQL, SQL*Loader and Developer 6i, Win 2003/2000, Windows NT/2000/XP, HP-Unix, IBM-AIX.
• Expertise with developing and maintaining software applications in the domain areas of Manufacturing, Financial, Insurance, Supply chain and Industries
• Worked in entire life-cycle beginning from Requirements gathering, Data Model Design, ETL Design, Report Design, Testing, and Migration to Production and Post Production Support.
• Worked closely with business application teams, business analysts, data architects, database administrators and BIS reporting teams to ensure the ETL solution meets business requirements. Performance improvement changes to the existing code of Informatica, queries using explain plan. Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files. Extensive experience in SQL tuning and Performance tuning of PL/SQL programs.
• Proficient in HP Openview, TeamTrack 6.5, PVCS Tracker 7.5 and PVCS Version Manager 8 tools.
• Has strong experience in Data warehousing projects using Informatica, and Cognos Report Net software. Installation, configuration and extraction/transformation/loading (ETL) data from the application systems and their databases viz. Mainframe (DB2), AS/400(DB2), Oracle10g/9i, MS SQL Server 2005, SAP R4.7D, MS Access and Flat files.
• Extensive experience in working with Relational databases Oracle 10g/9i, DB2 extracting data from these sources and also from other platforms like DB2, Oracle10g/9i, MS SQL server 2005/03/00, Flat files etc.
• Data modeling experience using Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Proficient working experience in creating Oracle Stored Procedures, Functions, Cursors, DB Triggers and Indexes. Extensive experience in SQL tuning and Performance tuning of PL/SQL programs. Proficient in SQL*Loader, SQL*PLUS, ODBC, TOAD, SQL developer applications to manage database and development.
• Developed extensively UNIX Shell Scripts (ksh) for data interfaces and batch jobs.
• Enterprise Resource Planning (ERP) implementation specializing in BAAN ERP, SAP R/3 and SAP BW. Integration of SAP R/3, BaaN ERP with other applications.
• Profound experience in performing all functions of System Development Life Cycle including writing Design documents and Test plans and conduct Unit and System testing. 4+ years Quality Assurance Testing, on Data warehousing QA Testing and Analysis.
• Have good experience in solving critical production problems and in taking critical business decisions. Worked as a team lead and Onsite/Offshore coordinator.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.6/7.1/6.2 ( Mapping designer, Repository Manager, workflow Manager, Monitor) Informatica Power Connect, Siebel Reports, COGNOS Report Net, SAPBIW 3.0, Business Objects , ERWIN 4.5

Databases: Oracle 10g/9i, MS-SQL Server 2005/2003,Tera data, DB2 UDB and MS Access 2000/2003/2007

Programming Languages: Microsoft T-SQL programming, Oracle PL/SQL Programming, SQL, Oracle Stored procedures, functions, Unix Shell scripting, ABAP programming, BaaN Programming, C, C++, SQL, XML and Java

SAP (ERP): ABAP 4.0 programming, ALE Configuration, SAP IDOCs, BAPI, RFC, BDC, SAP Scripts, LSMW, Jco connector, Smart Forms and SAP4.7D –PP, MM, SD Module functionality

Technologies: Data warehousing, Enterprise Resource Planning (ERP), Relational Database Management Systems (RDBMS), Materials Requirement Planning (MRP), Object Oriented Analysis & Design (OOAD), Client server Technology, Supply chain Management, Configuration, Manufacturing Execution Systems (MES)

MIS Reporting Tools: COGNOS-Report Net , Siebel reports (Answers & Dashboards), Crystal Reports, MS Access reports , SAP Scripts, SMART Forms, SAP Reports (ALV/Interactive/Classical) and BaaN Reports.

SCM & Utilities: SAP R/3, BaaN ERP, i2, Siebel 7.8.2, BaaN CRM, FlexNet7.2 (APRISO MES Software). Utilities: TOAD, Win SQL, SQL Developer, Cybermation, APPWORX

Operating Systems: Unix, Windos2005 Server, Windows NT/2000/XP, IBM-AIX, Solaris, Linux & Ms-Dos

PROFESSIONAL EXPERIENCE

Client: Confidential, San Diego, CA, USA Since Mar 2010 to present

Project #1

Sony Electronics Inc is the largest and best-known global electronics manufacturer and their services provider. As part of Sony’s IT

Initiatives: Data ware house, Data transformation/ETL, SPARC Application development by Sourcing the data from multiple source systems, Data transformation, load data into Data warehouse, ODS, Data mart and Downstream applications. I worked as Lead Informatica developer in Data transformation/ETL Team in Integration competency center (ICC). Additionally, the common storage and consistent reporting will bridge the credibility gap between business & administrative units within the organization. The DataWarehouse/Data marts will provide centralized reporting and analysis to key stakeholders. Extensively worked on Data integration, CDW, Data integration using Informatica 8.6.

Job Description/Contribution: As Lead Informatica Developer/Analyst

• Gather requirements, Analyze, Design, Code, Test highly efficient and highly scalable integration solutions using Informatica, Oracle, SQL, Source systems viz. SAP, Oracle10g, Main frame (DB2) systems, MS SQL server databases, flat files, Unix Shell Scripting. Responsible for Functional design, technical design, coding, testing, debugging, and documentation.
• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into Source/s to Stage, Datawarehousing &Datamart using Informatica, PL/SQL, Unix Shell scripts, Control – M scheduling.
• Documentation of Source to Target matrix, Mapping specifications, Mapping inventory, Unit test plans and data base sizing.
• Unit test processes to ensure proper functioning, and collaborate with other team members during system and integration testing phases to ensure proper functioning as part of the larger system.
• Migration of Informatica workflows using Informatica migration tool from Development to QA and Production
• Created Informatica maps using various transformations like SAP BAPI/RFC, SAP IDOCs transformations, Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.
• Adhere to Informatica SDLC, CDW standards, policies, procedures and industry best practices with respect to system design, architecture, naming and coding standards and system development lifecycle steps.
• Worked closely with business application teams, business analysts, data architects, database administrators and BIS reporting teams to ensure the ETL solution meets business requirements. Performance improvement changes to the existing code of Informatica, queries using explain plan. Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files.
• Scheduling the Informatica workflows using Control-M scheduling tool & trouble shooting the Informatica workflows.
• Enhancing the existing mappings, workflows with new business requirements and Report the project status to the management
• Also worked as post go live support/on-call production support consultant to monitor the production support applications.
• Developed project plans with team members to ensure Informatica solutions are executed and delivered as per the plans with good quality. Mentor the team members in the design and development of mappings & workflows with onsite/offshore execution model.

Environment: Informatica Power center 8.6, CDW, ODS, Data mart (Oracle), SAP BAPI/RFC & IDOCs, Mainframe(DB2), Unix, Data Source/Target systems (SAP, Oracle 10g, MS SQL SERVER 2008, XML), Control – M scheduling tool

Project #2

Client: Confidential, Downers Grove, IL, USA Feb 2008 to Feb 2010

Client is the largest and best-known global foodservice retailer with more than 30,000 restaurants, serving 46 million Customers each day in 121 countries. As part of McD’s IT initiatives: Data ware house, Data transformation/ETL, Restaurant Order Proposal (ROP) application development by Sourcing the data from multiple source systems, Data transformation, load data into Data warehouse, ODS, Datamart and Siebel Market Analytics. I worked as Lead Informatica developer in Data transformation/ETL Team. Extensively worked on Webservices configuration and security configuration using Informatica 8.6, Siebel reports (Answers & Dashboards).

Job Description/Contribution: As Lead Informatica Developer/Analyst

• Gather requirements, Analyze, Design, Code, Test highly efficient and highly scalable integration solutions using Informatica, Oracle, SQL, Source systems viz. Oracle10g, Main frame (DB2) systems, MS SQL server databases, flat files, Unix Shell Scripting. Responsible for Functional design, technical design, coding, testing, debugging, and documentation.
• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into Source/s to Stage, Datawarehousing &Datamart using Informatica, PL/SQL, Unix Shell scripts, Cybermation, Siebel reports
• Design, configuration of Informatica webservices to automate the eID requests using web services consumer transformation.
• Documentation of Source to Target matrix, Mapping specifications, Mapping inventory, Unit test plans and data sizing document
• Unit test processes to ensure proper functioning, and collaborate with other team members during system and integration testing phases to ensure proper functioning as part of the larger system. Created and used the Power Exchange connection/s.
• Migration of Informatica workflows using Informatica migration tool from Development to Sys test - > QA and Production
• Created Informatica maps using various transformations like Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
• Adhere to Informatica SDLC, standards, policies, procedures and industry best practices with respect to system design, architecture, naming and coding standards and system development lifecycle steps.
• Worked closely with business application teams, business analysts, data architects, database administrators and BIS reporting teams to ensure the ETL solution meets business requirements. Performance improvement changes to the existing code of Informatica, queries using explain plan. Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files.
• Scheduling the Informatica workflows using Cybermation scheduling tool & trouble shooting the Informatica workflows.
• Enhancing the existing mappings, workflows with new business requirements and Report the project status to the management
• Also worked as on-call production support consultant to monitor the production support applications.
• Developed project plans with team members to ensure Informatica solutions are executed and delivered as per the plans with good quality. Mentor the team members in the design and development of mappings & workflows.

Environment: Informatica Power center 8.6, Web services, Oracle 10g, Stage, ODS, Data warehouse, Data mart (Oracle), Power Exchange connection, Mainframe(DB2), XML, Unix, Data Source systems (MS SQL SERVER 2008), Siebel reports(Answers & Dashboards) & Cybermation scheduling

Project #3

Client: Confidential., Charlotte, NC, USA Since July 2007 to Feb 2008

Client is located in the Americas with an affiliated real estate operation. Headquartered in Charlotte, NC, is a Fortune 500 company traded on the NYSE. Administrative support of units within the organization have struggled to keep pace with this growth and ever increasing regulatory, management, unit level and Head Office reporting requirements.

• Multiple source systems across multiple business and administrative units produce inconsistent data and reports. The current process is Java and Microsoft Excel driven, extremely labor intensive, unreliable and difficult to maintain business changes. This worksheet technology is not scalable or flexible. Many analysts within the organization actually spend much of their time compiling reports in Excel and very little time analyzing.
• Additionally, the common storage and consistent reporting will bridge the credibility gap between business and administrative units within the organization. The Data Warehouse will provide centralized reporting and analysis to key stakeholders.
I was involved in a project of creating a Data mart, Data warehouse and Stage for Retail Marketing Systems (RMS) i.e. Charges, Service agreements, Service Contracts, Customer, Products, Product Agreements, Accounts, Account conditions, Premise and Premise conditions etc. I was involved in all the phases of the project from requirements gathering to implementation using Informatica Power center and Power exchange.

Job Description/Contribution: As Lead Informatica Developer/Analyst

• Gather requirements, Analyze, Design, Code, Test highly efficient and highly scalable integration solutions using Informatica, SQL, Source systems viz. 3 Main frame (Db2) systems, Oracle10g, MS SQL server 2005 databases, flat files, Shell Scripting
• Design and development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into Source to Stage, Data warehouse and Data mart.
• Documentation of Source to Target matrix, Mapping specifications, Mapping inventory, Unit test plans and data sizing document
• Unit test processes to ensure proper functioning, and collaborate with other team members during system and integration testing phases to ensure proper functioning as part of the larger system. Created and used the Power Exchange connection/s.
• Migration of Informatica workflows using Informatica migration tool from Development to Sys test - > QA and Production.
• Adhere to Informatica SDLC, standards, policies, procedures and industry best practices with respect to system design, architecture, naming and coding standards and system development lifecycle steps.
• Worked closely with business application teams, business analysts, data architects, database administrators and BIS reporting teams to ensure the ETL solution meets business requirements.
• Scheduling the Informatica workflows using Cybermation scheduling tool & trouble shooting the Informatica workflows
• Enhancing the existing mappings, workflows with new business requirements and replaced existing Java ETLs with Informatica workflows. Report the project status to the management
• Developed project plans with team members to ensure Informatica solutions are executed and delivered as per the plans with good quality. Mentor the team members in the design and development of mappings & workflows.

Environment: Informatica Power center 8.1, Power Exchange connection, Mainframe(DB2 – CBIS, CMSE, CMSW), XML, Unix, LANDTRACK (Oracle 10g), Stage, ODS, Data warehouse, Data mart (MS SQL SERVER 2005), Crystal reports and Cybermation scheduling

Project #4

Client: Confidential., Brooklyn Park, MN, USA June 2005 to July 2007

Caterpillar Paving Products Inc. is one of the leading large and heavy paving equipment manufacturers in the world. They have offices in almost all the major countries in the world. Administrative support of units within the organization have struggled to keep pace with this growth and ever increasing regulatory, management and unit level and Head Office reporting requirements.

• Additionally, the common storage and consistent reporting will bridge the credibility gap between business and administrative units within the organization. The Data Warehouse will provide centralized reporting and analysis to key stakeholders.

I was involved in a project of creating a datamarts for Order Receipts, Service order receipts, Materials inventory, Planning and Scheduling metrics. I was involved in all the phases of the project from requirements gathering to implementation. All the datamarts are completed and implemented. Business intelligence reports are under development. Integration of i2 (Oracle database) with Orders Processing System (Mainframe: DB2 database), MRP system (AS/400: DB2 database), SAP R/3 using Informatica Power center.

Job Description/Contribution: As Sr. Informatica Developer

• Prepared program specifications and diagrams, developing coding logic flowcharts
• Analysis of business requirements, design and development of ETL mappings involving complex business rules.
• Extracted large volumes of data form DB2, MS SQL Server, Oracle, Flat file systems to target Oracle database.
• Coordinate all communications with the Database Management team, project team and management.
• Developed Data mapping and filtering procedures.
• Extensively worked on Performance tuning of queries/programs. Complex SQL queries are used for data retrieval.
• Designed, Developed and Deployed UNIX shell scripts.
• Development & Implementation of a data warehousing project and also production support for enhancements and maintenance.
• Coordinated and worked closely with architects, operations, Database Management team, project team and management, system admin teams, business units to build and deploy.
• Worked in a support team rotation which performs night and weekend support for all production data integration services from client site/ home. Created and used the Power Exchange connection/s.
• Implementing data quality management solutions that manage millions of customer transactions.
• Installation, Configuration and Administration of Informatica Servers on development/test/production servers.
• Performed systems, data quality assurance, system testing, ensuring that software and systems perform to specification.
• Established test environments and test data and advocate the use of common re-usable functions, services and data
• Participated in quality assurance activities like reviews, walkthroughs etc.
• Performed extensive risk assessment prior to production implementations and carried out validations for post implementation to ensure successful execution monitoring performance.
• Created source to target definition, repository, Informatica services and repository services.
• Troubleshoot and resolve functional issues to meet the user requirements. Built and deployed complex transformations.
• Optimized SQL for faster extraction, transformation, loading and performance of mappings.
• Documentation of design specs, Informatica Mappings & Transformation Specicifications and logic process flow charts.
• Created SQL scripts, store procedures, functions, views using PL/SQL, Unix shell scripts which were used to transform data.
• Administered & scheduled batches/sessions using server manager. Modify/Migrate the Informatica mappings (XML) from the Development to Test Server and Production server.
• Troubleshoot the reasons for load failures, analyze, identify the missing data and their dependencies.
• Develop, document, manage, and coordinate all user test plans, user validation/acceptance testing.
• Testing the transferred data, analyze the log files, Establish Join relationships between the Query Subjects.
• Designed and developed approaches to acquire data from new sources like Mainframe (DB2), AS/400(DB2) and i2 (Oracle as database) application. Studied and analyzed existing mappings/sessions and identified performance bottlenecks.
• Modify/Migrate the Informatica mappings (XML) from the Development to Test Server and Production server.
• Create Standard Reports in COGNOS Report Studio. Created graphical reports (Charts) to review and analyze the performance of each assembly line and how the order board is filled with different types orders.
• Developed Informatica Interface to i2 system (Oracle database) with CMOPS (Mainframe-DB2 database) and MRP system (AS/400:DB2 database).

Environment: Informatica Power center 7.1/8.0, Power exchange connection, Cognos Report Net, Unix, AS/400(DB2), i2 (Oracle 10g/9i), ODS (Oracle 10g/9i), Legacy systems viz. PLAINS (MS SQL Server 2005), Mainframe(DB2), SAP R/3

Project #5

Client: Confidential, Ins, WI, USA From Dec 2004 to June 2005

Job Description/Contribution: As Sr. Informatica developer

American Family offers a full selection of reliable insurance and financial products. It offers vehicle insurance, home and property insurance, health insurance, life insurance, business insurance or financial products like annuities or loans. I was involved in a project of creating a datamarts for AUTO and LIFE insurances. I was involved in all the phases of the project from requirements gathering to implementation. The Life datamart was completed and implemented.

• Prepared program specifications and diagrams, developing logical flowcharts for coding.
• Translated business specifications and designs into language coded programs, packages, procedures or automated batch scripts
• Analysis of business requirements, design and development of ETL mappings involving complex business rules.
• Involved in Dimensional modeling of the data warehouse projects by using star schema
• Designed and developed ETL Informatica mappings. Scheduled and Managed Informatica sessions.
• Data Modeling (Physical and logical) using Erwin. Developed Data mapping and filtering procedures.
• Extracted large volumes of data form Mainframes systems to target Oracle database.
• Extensively worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• Designed, Developed and Deployed UNIX shell scripts.
• Development & Implementation of a data warehousing project and also production support for enhancements and maintenance.
• Coordinated and worked closely with architects, operations, and business units to build and deploy.
• Implementing data quality management solutions that manage millions of customer transactions.
• Configuration and Administration of Informatica Servers.
• Oversee the technical design of the data warehouse, optimizing for scale and performance.
• Performed systems, data quality assurance, system testing, ensuring that software and systems perform to specification
• Established test environments and test data and advocate the use of common re-usable functions, services and data
• Participated in quality assurance activities like reviews, walkthroughs etc.
• Performed extensive risk assessment prior to production implementations and carried out validations for post implementation to ensure successful execution monitoring performance.

Environment: Informatica Power Center 7.1.1, DB2 UDB, WINSQL, IBM-AIX, CA7, Business Objects

Project #6

Client: Confidential, NJ, USA From April 2002 to Nov 2004

Business Intelligence and Warehousing (Finance Data Warehouse). Fortis Americas has seen tremendous business growth in the last couple of years.

• Multiple source systems across multiple business and administrative units produce inconsistent data and reports. The current process is Microsoft Excel driven, extremely labor intensive and unreliable. This worksheet technology is not scalable or flexible. Many analysts within the organization actually spend much of their time compiling reports in Excel & very little time analyzing.
• I worked in the design and development of Financial Data Warehouse to cater to the above issues.

Job Description/Contribution: As Informatica developer

• Designed ETL process from source to target. Designed logical and physical data model.
• Created database objects like staging tables, target tables, synonyms, sequences, triggers and stored procedures to move data to target. Developed Shell scripts to run the ETL batch on receiving the flag.
• Created Informatica maps using various transformations like Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
• Tested the ETL mapping codes and validated data. Created daily and weekly ETL batches and scheduled them through Control-M schedule according to the client requirement.
• Documented validation rules, exception processing and test strategy of the maps.
• Migrated ETL codes from Development to Test to Production.
• Designed & deploy a Financial Data-Warehouse, for Fortis Bank in Investment & Merchant Banking areas.
• Responsible for coordinating with end users for requirements capture & documentation in BRD
• Created Legacy Source systems (MIDAS) to Target (Oracle) Data-mapping
• Designed & implemented Data Quality validation routines throughout the ETL lifecycle, to validate Data accuracy.
• Designed Extract, Transform, and Load (ETL) routines to load data using Informatica power center
• Detailed Data-Modeling of Conformed Dimensions in the Ledger & Budget subject areas & corresponding Balances & Journal Detail Facts. Also worked in creating & monitoring Test plans.
• The subsequent steps involve the development, Unit Testing, SQA function and roll out into production environment.

Environment: Informatica Power center 6.2, Cognos Report Net, Oracle9i, MS-Visio 2000, Erwin 4.2, Unix

Project #7

Client: Confidential, Chennai, India From Dec 2001 to April 2002

Implementation and Integration of SAP4.7C with APRISO MES software (FlexNet7.2) using ALE configuration and 35 SAP Inbound/Outbound IDOCS with customizations with Oracle 9i.

Job Description/Contribution: As a Project Leader cum SAP ABAP – Flex Net Integration consultant

• Configuration of SAP R/3 IDOC Mapping Definition for SAP table fields mapping with FlexNet table fields for all the 35 SAP Inbound/Outbound IDOCs as per the business scenarios of St.Gobain Glass India.
• Integration of SAPR/3 with Apriso software (FlexNet7.2) using ALE and 35SAP Inbound/Outbound IDOCS with customizations. Change control management is a part of the implementation process.
• Developed SAP BAPI programs, Developed BDC programs, CATT procedure etc.
• Configuration of SAP Message Types, Basic IDOC Types, Segments, Segment attributes in FlexNet according to the SAP IDOC structure in SAP4.7.
• Configuration of SAP R/3 IDOC Mapping Definition properties for each SAP IDOC like Format Functions, Sequencing, Concatenate, Both, Qualifier values for Current Segment, Parent Segment and Default values.
• Testing, Support and Trouble shooting the SAP IDOCs data sent from SAP to FlexNet and vice versa.
• Generation of SAP metafile in SAP & Parse into FlexNet to keep the SAP IDOC structure same in FlexNet.
• FlexNet Software Modeling, Implementation and Configuration of Apriso software (FlexNet7.2) for the St.Gobain India Business scenario transaction/s requirements.
• Configuration of FlexNet services i.e. Execution manager, Kernel service, FlexNet mapper (SRVMapDown and SRVMap up), FlexNet Service Down, FlexNet SAP Uploader and FlexNet Post Batch service. Setting up the SAPRFC.ini in FlexNet to establish the connectivity between SAP and FlexNet. SAP Partner profile configuration with ALE like Defining Logical systems, Maintain Port ranges, Defining RFC Destination, Distribution Model and Generation of Partner file in SAP4.7 for SAP Development/Quality/Production servers with External application FlexNet7.2. Performance tuning of the software applications.

Environment: SAP R4.7c, Oracle, Unix, FlexNet7.2 (APRISO MES Software), SAP Abap workbench

Project #8

Client: TVS Group of companies, Chennai, India From June 2001 to Dec 2001

Implementation of SAP4.7D and Integration with SAP4.7D with RS Scheduler at Client site. Implementation of Rockwell Scheduler solution at SUNDRAM FASTENERS LTD (TVS Group of company, India) and integration of SAP R4.7D PP (Production Planning), S&D module with Rockwell Automation’s RS Scheduler software application with MS-SQL server 2000 as database.

Job Description/Contribution: As a Project Leader cum SAP ABAP consultant

• Functional definition study, AS-IS, To Be process Analysis at client site and collecting the user requirements.
• Identification of SAP functional scenario to RS Scheduler process flow and points of integration
• SAP master data transfer from SAP to RS Scheduler using JCO connector, Implementation and business functionality logic configuration in RS Scheduler, Integration of SAP R4.7 with RS Scheduler using RFC and BAPI
• Dialog programming to finalize To Forge Quantity on MFM screen between Production and Sales Teams and remarks with reason codes. Change control management is a part of the implementation phase.
• Developed menu interfaces for screens and interactive lists. Creation of Planned Orders in RS and transferred to SAP PP Module. Update Production order confirmation data from SAP PP Module to RS
• About 20 reports (Classical/Interactive/ALV reports) developed using ABAP
• Raw material requirement reports as on date using SAP scripts and modified existing Purchase document reports to meet the client specific layouts. Developed BDC programs, Recording the BDC programs, Executing the CATT procedure etc.
• Developed Remote Enabled Function Module on PM Schedule to interface with a Third Party Production Scheduler (Rockwell Scheduler) interfaced with SAP R/3. The Production Scheduling was done through Third Party Production Scheduler, which was interfaced with R/3. For Production Scheduling, the Maintenance Activities planned on a particular work center had to be considered as constraint before scheduling. The data returned by the Remote function Module was pushed to the Database of the Scheduler using a program in Visual Basic, which was then made use by the Scheduler for its Scheduling activities.
• Created Tables, Data elements, Domains, Search Helps, Lock Objects
• Technical specifications documentation for the customization & development work.
• Rescheduling as per the addition/deletion of existing planned orders, insertion of new orders within RS to reflect the new scenario. Changes in Rescheduling to be reflected in SAP PP Module
• RS Scheduler Configuration & Customization of RS Scheduler existing scheduler functionality to meet the customer requirements, Development of Crystal reports.
• Data transfer between two systems is configured using the XML. JCO connecter is used to transfer data between two systems.
• Installation and Configuration of Rockwell Scheduler, unit testing, integration testing and user training
• Users used to access the system like Client server technology software application.
• Logical and physical Database design & Development of MS SQL server 2000 stored procedures, writing triggers and views, User interface development using Visual Basic 6.0 to provide integration between RS scheduler and SAP – PP. Used T-SQL for programming (Cursors, Queries/Procedures/Functions/Tables/Views) to fetch the data to display in Visual basic screens.

Environment: SAP 4.7D, Oracle, Unix, Rockwell Scheduler, SAP Abap workbench, Transact SQL (T-SQL)

Project #9

Client: IS3C, USA From Jul 2000 to Dec 2000

Development and Customization of reports in BaaN ERP Finance, BaaN Manufacturing and Service packages of BaaN ERP.Job Description/Contribution: As an Enterprise Resource planning software application Technical Consultant

• Study the specifications provided by the clients.
• Write detailed descriptions of users’ requirements, program function and steps required to develop or modify computer programs. Review computer system capabilities, workflows and determine if requested program or program change is possible within the existing system. Consulting with the users on issue resolution procedures and Issues.

Environment: BaaN ERP, Unix and Oracle

Project #10

Client: Dagger Forst Tools Ltd, Mumbai, India From Dec 1999 to Jul 2000

Implementation of SAP R/3 software and customization and development of SAP R/3 software as per the user requirements.

Job Description/Contribution: As a SAP ABAP Consultant

• SAP Abap programming in developing and supporting SAP implementations as ABAP developer
• Worked on creating and maintaining forms using SAP Scripts.
• Worked on Business Add-In, Customer Exits, User Exits. Familiar with development process in SAP Systems.
• Interpretation of functional requirements and development of ABAP programs according to specifications. Programs to be developed include, but are not limited to, the following: conversions, reports, forms, enhancements and interfaces.
• Develop functional prototypes to explore different design concepts. Developed BDC programs.
• Worked closely with Business Analysts to ensure accuracy and completeness of Functional Specifications.
• Design, develop, and expose SAP BAPI objects. Develop and deploy SAP interfaces with external enterprise systems.
• Development, execution, and documentation of unit test procedures.
• Assist in system, integration, performance and user acceptance testing.
• Assisted assistance to the Business Analyst with the analysis of ABAP change requests.
• Development of technical and support documentation.

Environment: SAP R/3, Oracle, Unix

Work Experience as BaaN ERP Technical Consultant:

• BaaN ERP implementation at National Peroxide Ltd, Mumbai, while working with Hexaware Technologies, Mumbai, India, July 1999 to Nov 1999. Environment: BaaN ERP, UNIX and Oracle
• Customer Support on BaaN ERP of BaaN Support center, Sydney, Australia, Feb 1999 to Jul 1999
• BaaN ERP software development on BaaN ERP for BaaN India Jun 1998 to Feb 1999 as a BaaN ERP Developer

Environment: BaaN ERP, UNIX and Oracle/MS Sql server as databases

EDUCATION: Master of Engineering in Computer science.