Name: Jayanta Narayan Choudhuri

Born: 23rd June 1952 

Address:	Flat 302                 
               	395 Jodhpur Park         	Email: ssscal@gmail.com
           	Kolkata 700 068         	URL: http://ojnc.byethost11.com 
           	India                    		Telephone: 91 33 4731891 
                                    			Mobile: 91 98302 42070

My focus is on entrepreneurial innovative SAP surround opportunities.

I have a 5 year B1 Visa for USA. This is itself may be a business opportunity.

SAP Installations typically have 30-40% capacity peak. 
My idea is to use the idle time to build caches. 
Say NA to HANA and get sizzling MIS & Portals in R3!

Briefly this is my scheme 
a)	target SMB SAP customers  
b)	typically peak load is 8 hours and idle time 16 hours for SMB SAP
use idle time to do ETL inside SAP
c)	report through simple PHP Apache, Rails or J2EE portals
use web tech as per client preference
d)	implement vendor and customer portals  
e)	implement mobile apps based on Adobe Flex 4.5
f)	support standard SAP R3 services
that includes EDI, all core SAP R3 module support
including maintain & grow

My expectation is that some SAP SMB Customers esp. those in cost cutting mode,
will also see the benefit of reduced license costs by moving reporting to portals.

I might be US partner arm in Kolkata and use alliances as per business flow.

ABAP work; my ETL technology; low cost portals; mobile apps
are some innovative areas where I myself alone can do a lot.
We can do some innovative Mobile Apps for Senior management.
Security will be by password in addition to device id and mobile no.

Areas we can cover -
a) Access to a visually attractive app that gives charts and trends 
b) Instead of push technology as email or SMS is 
    Senior Managers can Pull info from anywhere in the planet
    and anytime
c) if a person quits organization; immediately the device will be blocked
    so a mobile id and device id etc is very helpful;
    though we will also have passwords
d) PO PR approval can be done remotely
    Organization efficiency goes up without compromising passwords

e) custom Workflow apps like Product Complaints of Customers
    can be on mobile; giving speedy approvals and alerts;
    resulting in better Customer Service
f) Innovative Workflow apps can be designed;
   leading to all round efficiency improvement
g) Plant process parameters can be seen on line;
    Benefit – senior Managers alerted to deviations early
h) Plant Maintenance can be integrated;
    Condition based alerts viewed in Mobile
i) Knowledge Bank access for Senior Managers
Senior Managers may find less time at office looking at above areas.
They can do so in leisure of home or while travelling from airports and hotels.
We will develop on Adobe Flex4.5 and also use PHP developers 
for Java Scripting extensions; this gives hardware independence;
Will work on Android(Google), Apple, Winphone(Microsoft) and Blackberry(RIM)

Below are my ideas on Reporting and Portals.
This may more relevant to SMB SAP clients.
Large clients have muscle power for ALL of SAP products BI BO PI …
BUT large clients who are open to innovative area specific solutions may also be interested. 
The borderlines between true BI and MIS portals are often blurred.
My ideas Portal (Customer or Vendor) BI MIS services with Web(Desktop Portal) and Mobile(Android iPhone) integration around SAP installations.

Backend part ABAP, PHP or J2EE.

Frontend by Flex4.5 or AJAX.
I have 3 very successful portals LIVE at PCBL, Spencers & Century Ply.
All 3 on PHP Apache. PCBL & Century for Customers, Spencers for Vendor.
My message is very low cost EP and BI using approach detailed below.
LOW COST, SIMPLICITY and ability to meet SPECIAL NEEDS of Clients
BUY NOTHING but our service
Install a PC grade web server with Apache & PHP
And MIS up and running from 1st to 3rd month. After that maintain and grow with our service
The ONLY CON is that we are selling a service with a framework rather than a branded product.
The truth is there are NO PRODUCTs but only tools and be it BO or QLIKVIEW you need to build apps.
You need skilled people to build custom applications.
Even SAP BW book author stated that very little of SAP BW “content” can be directly used.
Other than SAP BW it is all build from scratch ….
I have no idea of Cognos but recently I used QLIKVIEW a bit with SAP.
QLIKVIEW needs skills to extract and skills to build apps and I found no report
with non time dimension additive KPI like stock or pending orders.
Stock as you know is tricky; in SAP you can have normal stock and various types of special stock
-      customer consignment
-      vendor consignment
-      subcontracting
-      PS project stock by WBS
-      stock in transit
-      pipeline stock as in GAS
Pending orders is very tricky
-      STO stock transfers to ware houses
-      SD customer orders
-      PO of trading goods
-      PR of trading goods
B2B, FMCG, FMDG(durable) all will have different styles and needs
Our MIS is useful and low time to market, very low cost and works very well
for balances that are not time additive - stock, pending orders etc.
I can understand and build exactly what is needed by business
NOT generic stuff that work well in specific areas
Our MIS can show "cross cube" data easily. Sales in Stock report. Stock in Production.
May be deployed on Android and desktops using Flex4 via cheap PHP & Apache.

FAST MIS FROM R3

Background: ETL is well established technology and objective is to separate out the reporting and analytics workload from production transaction servers.  Towards this end SAP Oracle and others have created Data Warehouse applications. SAP’s offering is BW. However for some SAP customers retaining BW talent and managing BW applications is sometimes a challenge.
My Innovation: I have successfully managed highly pragmatic ETL within R3 itself. My success stories are Spencer’s Retail with 250 stores all over India, PCBL a chemical industry and recently Century Ply a large building materials company with very high volume of transactions. 
The mechanism is to run jobs at night which create cache tables (SAP INDEX Database or BLOB tables) or even flat ZIP files in server say date wise plant wise sales, transfers, pending orders, production and stock. I look back 2 posting periods FI & MM only for backdated lagging transactions as SAP does not allow posting date earlier to the open periods. I extend this to important large master data even. These jobs take 3 minutes max 40 minutes total elapsed time.
During the day users take their MIS from these ZIPped BLOBs in Tables or Flat Files. The result is response time in the order of few seconds for almost any query. The “magic” is possible as I make use good use of in-memory hash tables.
Stock is the trickiest challenge as stock is non-additive over the time-axis. Also business variables like “pending” orders are difficult if not impossible to calculate back dated. The approach to such problematic variables needs specialist approach that has to be designed for particular customer situations.
Additive variables like sales or production are easier to deal with.
Another very interesting addition is my cache injection technique. In Century Ply certain key production parameters are entered next day say by 11am to 1pm. During day time users may optionally request “Want latest” when the last 4 days cache is injected or updated. This is an USP as it gives a clear advantage over 1 day stale info in conventional ETL.
In Spencer’s too I made sure stores sending data late were immediately updated into cache after late arrival of info. This gives clear “time to market” advantage in ETL inside SAP.
Considerations: The tricky variables like Stock or Pending Orders are a pain in conventional BW. In my solution these work nicely. Also “joining” info across cubes needs expertise but in my solutions it is easy.
To use any dashboard effectively we need to give very fast response for any MIS. Pulling conventional info from databases or R3 or BW is a challenge when ensuring reasonable response time. My home-grown ETL inside R3 is therefore an important component in delivering data to  to the complete satisfaction of MIS users.  
My approach is also similar to QLIKVIEW as I too believe in Reporting direct from R3
which gives all the advantage in “time to market” info besides “stock & pending”.

Low cost portal

a)	It is easy to develop a PHP based Web portal which will be integrate the SAP server We may also use J2EE and JCO(SAP Java Connectivity “Java Component Objects”) if PHP skills not available.
b)	The web application will work on a connected business model where our development will be in PHP/J2EE ABAP platform.
c)	The website will be a 100% browser based delivery.
d)	The website will use only SAP  database
e)	A few Z tables “inside SAP” will be used for application security logs.
f)	Business will be in SAP server side RFC enable Function Modules.
g)	Wherever SAP standard RFC (mostly BAPI) are available we will use standard.
h)	The PHP/J2EE application will ONLY do presentation logic delivering HTML PDF and maybe XLS. 
i)	PHP/J2EE will invoke RFC through one anonymous SAP user say J2EEUSER

Process Diagram

Browser

PHP
or
J2EE

F
I
R
E
W
A
L
L

SAP
 R3 Server

HTML

Web Server

Comparisons 
ETL within R3 Advantages
a)   No need for additional servers; uses R3 itself for storing Though if so needed we can use external server
As reporting from ZIPs and does no SQL there is very low impact of our reporting on concurrent transaction load
b)   Data is extracted incrementally and zipped and stored in BLOB tables.
This gives opportunity to do anytime delta extracts giving near real time information availability
c)   Good for Stock and balance like pending orders; KPIs that are NOT additive over time are good in our scheme
We can build complex KPI logic; specially suited to the business
d)   Very fast response for Daily, MTD and YTD figures; and this is true for BOTH time additive(Sales, Production) and
non additive(Stock Pending Orders)
e)   Easy to show cross dimensional figures; Ex. in Stock Aging you want to see Sales/month
In Production report you want Stock, Pending Orders and Sales
f)    Response time very consistent and very low as it works with cooked zipped data
g)   low cost PHP Apache solution to publish reports on Web Could be Flex4 or Excel downloads
Needs no client; ONLY a browser
h)   NO Costs other than OUR service; Other infrastructure like PHP web server very low cost
Our service costs to maintain and grow also small
i)     Unlimited user license from web or intranet; From desktop, laptop, tablets and smartphones
j)    We up-front state that all businesses will have special needs for reporting
B2B FMCG etc and we build a custom fit that delights; We also are able to change to business change demands
All of above at very affordable “Indian Labour” rates
k)   SIMPLICITY is key word; Results up and running 1 to 3 months; Incremental rollout

Competition Weaknesses
a)   Needs additional servers to extract out and store ETL data
3 for BW and 3 for EP usually in addition to 3 for R3; DEV QAS & PROD
b)   Data normally extracted nightly and hence 12-24 hour information lag
c)   KPIs that are NOT additive over time need either huge additional storage
or need to be calculated to give point in time results
d)   Good response for Daily, MTD and YTD figures
BUT this is normally true for additive(Sales, Production) but usually slow 
for non additive(Stock Pending Orders)
e)   Needs highly skilled people to do cross dimensional reports; 
Ex. in Stock Aging with Sales/month or Production report with Stock, Pending Orders and Sales
f)    Response time normally varies widely from fast and acceptable to often slow & disappointing
g)   Normally special client tools; Web publishing with restrictions and often slow
h)   Significant Costs; Costs of multiple Servers (3 for BW and 3 for EP)
License costs; High service costs to develop; High costs to maintain and grow
i)   Restrictive licensing; Often needs special client software
Will not run only on MS IE with ActiveX
May need additional investment to deploy on tablets and smartphones
j)    Demos are deceptively attractive; 
when it comes to addressing then expenses shoot up
Building good apps is expensive; maintaining them expensive
And reacting to changes sluggish owing to complexity
k)   COMPLEXITY high; Results take time to come

SUMMARY:
  
•	High skills in SAP technology in ABAP & Basis; focus on ERP 
•	FOCUS on SAP Integrations for Portals and Mobile Apps around SAP
•	Web Integration with Flex, PHP and Java
•	Proven competence in all areas of Software Development – end to end. Proposal, pre-sales, estimation, project management and the development life cycle.
•	Senior I.T. Consultant with about 35 years experience in Software Development.  
•	Technical background includes UNIX, Windows NT, ICL mainframe. J2EE 
•	Good exposure to ORACLE, MS SQLServer, SYBASE, INGRES and INFORMIX. 
•	Relevant experience with business applications in hospital management, hotel management, power and engineering industries. 
•	Executed highly successful migrations from legacy environments to UNIX/NT.
•	Consult mainly on helping clients chose the right software and hardware architecture that will support the applications.
•	High skill in mentoring teams in all aspects of software technology and methodology. Able to keep up with latest IT trends.

Current Assignments

SAP

I have associated with many major implementations of SAP and worked intensely in basis as well as ABAP. At present my focus is on SAP business and technology areas. Having a strong background of Java I could master ABAP OO and deployed vital BAdI (Business Add In) as well as DOI(desktop Office integration) solutions. I have published quite a few articles in SDN, SapGenie etc.

I have a good understanding of the SAP data model and navigation and document flow for MM (Materials management) SD (Sales & Distribution) and PPPI (Production Planning Process Industries).

I was engaged by SkyTech for advice on high technology enterprise integration solutions. This leads me to a lot of study in Java, Linux, Opensource, Webservices, Rule Engines, Security and other advanced areas to configure solutions.

I supported a CRM Initiative for a Real Estate Company. This Oracle Siebel on demand with strong Webservices integration.

My focus is now SAP and SAP Web integration. I retain strong skills in basic Oracle/RDBMS Unix admin support for SAP, SAP development & integration technologies like Netweaver around ERP solutions.

Recent Interests 

My skills in SAP Java integration lead me to explore PHP & Java web integration with SAP. PHP enjoys the support of IBM Oracle etc giants and is perceived as a quick development environment with a vast library of excellent stable components available.

This led me to Rich Internet Applications (RIA) area and I chose Adobe’s Flex3 as my preferred RIA as Flash is almost universal and the security model is excellent and again a vast library of ready to use solutions available.

Recent Assignments 

Natrol USA
I am involved in total support besides lot of developments.
Picked up high skills in WM Warehouse management and EDI.

Managing team of 12 in support plus development.

Project Systems
Have high strength on PS and have strong team as well.
PS specific support & development at PCBL and KHD.

Spencer’s Retail Limited
I was involved with RPG’s SAP IS-Retail from just before go live. I have done part the POS to SAP in-bound and out-bound IDOCs movement using Java & SAP integration using JCO. 
I provided SMS and email integration for Top Management reports.

Besides Application Development areas I provided support on Oracle 10g, RMAN, SAP Backup, Solaris, Clustering & Failover aspects of BASIS Administration.

Spencer’s Retail Limited
I was involved with RPG’s SAP IS-Retail from just before go live. I have done part the POS to SAP in-bound and out-bound IDOCs movement using Java & SAP integration using JCO. 
I provided SMS and email integration for Top Management reports.

Besides Application Development areas I provided support on Oracle 10g, RMAN, SAP Backup, Solaris, Clustering & Failover aspects of BASIS Administration.

BOC Linde Global
I was involved with BOC Linde and contributed mainly to SAP performance management and SLA measurement. BOC Global had a SAS based system around their dozen plus production R3 servers. 

Axiomestates
I worked 1 year on Oracle Siebel CRM on Demand an excellent SaaS application. The most important skill acquired was webservices programming for Siebel. Had to leverage and achieve high levels of VBA, TSQL integration in order o go live on Siebel.

Descon-DPSCL
I have successfully salvaged a floundering SAP project and managed to get this back on track in a course of 6-7 months. SAP now live since 1st Novemeber 2008.

Under Descon Banner I have supported KHD a German SAP customer on Project ystems.

Tata Tea Limited 
I was involved with Tata Tea from just after go live. I was in an active mentor role and trained three senior programmers in ABAP besides actively participating in guiding them in live delivery. I have also been responsible for vetting the delivery of ABAP code delivered by TCS.

Phillips Carbon Black Limited
I was involved in the project almost from day one. I wrote many important ABAP programs and many user exits and BaDIs. I also guided them in BASIS areas like HP Unix clustering and advanced activities like Heterogeneous System Copy.

I was responsible for a significant “upgrade” project for SAP patches.

CESC – one of India’s largest Power Utility Company
I was fully responsible for a large Oracle 9.2 application for a large Utility Company with a 2 million plus customer base in Calcutta. The platform was 64-bit Oracle 9.2 on Sun platform. Most of the code is done in PL/SQL, C and Java. Managing such huge volumes of data has been a very valuable experience. The system has been live processing 80,000 bills per day end to end.

SBS UK (Siemens Business Services) North West England
July 2000 to February 2001
Role: Involved in data extraction and transformation from both ICL VME and existing Oracle systems to latest Oracle technology. I guided and trained all SBS personnel.
Project:  A large migration project from ICL VME and older Oracle based systems to a Tuxedo Oracle application platform.  

Peerless Hospital Calcutta – Hospital Management System
Oct 1999 to April 2000
Role: Wrote all migration tools.  I have completed migrating DEC RALLY RDB large applications to Oracle D2K using my own tools. 
Project: There were 3 parts - migrating the schema, migrating ESQLC and the most difficult part migrating RALLY forms and reports. The entire original HMS application was successfully migrated with significant value addition.
Published:  http://www.aboutlegacycoding.com/ in June 2000.

SBS UK (Siemens Business Services) South Africa
Sep1998 to Dec 1998
Role: I was retained by Siemens ( Siemens Business Services ) to assist their prime client Medscheme in migrating applications from a Siemens mainframe BS2000 running ISAM, UDS(network DBMS close to IDMS) and UTM a TP monitor.
Project:  Medscheme is the largest Medical Benefits Administrator in South Africa. There approx. 1 million Members and 50 thousand transactions per day. They have a large range of hardware and a massive network infrastructure. The applications were being migrated to Oracle with Designer 2000 and Developer 2000.

GKW’s Powermex Division 
June 1999 to Aug 1999
Role: I used my own clone for migrating RPT&RPF. I had to write a near perfect clone for Oracle's RPT/RPF.
Project: Migration of a large mission critical Oracle 5, Forms 2.3, ProC and RPT/RPF top Oracle8 & D2K. RPT/RPF is a product discontinued by Oracle with no upgrade path.

STL, Nairobi at Kenya
April 1999 to May 1999
Role: I trained the staff of STL at Nairobi in all aspects of Y2K compliance and migration. I have to personally part C++ programs for special devices used to print receipts and mark cheques.
Project: 2 large migrations to Oracle8 & D2K for 2 very large Kenyan organizations with objective of Year 2000 compliance. There was a stiff penalty clause in the contract.

Other Assignments

Hospital Management
Developed a custom Hospital Management System for a large Nursing Home in Calcutta. The modules include Admission, Billing, and Pharmacy, EPABX telephone connectivity, Operation Theatre, Pathology, Ward Management and many others. The RDBMS is SYBASE. The front-ends are mainly SYBASE APT & RWB. For the pharmacy system Bar Code technology was used. 
Size: 10 man-years, over 2 years
Responsibilities: I have participated as Analyst, Designer and Programmer. I was subsequently responsible for maintenance and enhancements of the HMS package.

Hotel Management
Migration of ORACLE Forms 3.0 based Hotel Management System to ORACLE RDBMS and Developer 2000. The modules include Guest Reservation, Check-in, Bar and Restaurant, Night Audit, EPABX Telephone Connectivity, Room Service, Housekeeping and many others. EPABX software is in Visual Basic running in the NT server and uses Oracle Objects for OLE. This package is running very successfully in several Hotels.
Size: 8 man-years, over 1.5 years
Responsibilities:  Technical leadership of the development team.

Financial Accounting
Financial Accounting Application for a medium sized Engineering Company’s head office. The server was MS SQLServer on NT with Powerbuilder as front-end.  The application is a totally on-line application. The vouchers are posted immediately into the various ledgers and sub-ledgers. All workflow activities of the office are captured into the process. The coverage is all aspects of Purchase, Invoicing, Employee Expenses, and Loans etc.  The system is in operation from April 1997.
Size: 2 man-years, 6 months.
Responsibilities:  Technical leadership of the development team.

Sales Order System
Developed a Sales Order system for an Engineering firm. This system was developed in Powerbuilder with Applib framework. The RDBMS was SQLServer on NT. The modules covered Order Entry, acknowledgement, material dispatch; excise accounting, Invoicing, Stock Transfer to outlets and Finished Goods inventory.
Size: 3 man-years, 6 months.
Responsibilities:  Technical leadership of the development team.

Executive Information System
Developed an EIS system for the largest Private Power Company of India i.e. CESC of Calcutta. The system was based on Sybase on Novell NLM with Pilot Lightship as front-end. Microsoft Access was also used for data entry. All the very senior managers use Lightship to access data. This was a highly successful system operational till date. All corporate information and even external business information were made available with highly attractive graphics and color highlighting. Trends, ratios and comparisons can be done by a WIMP interface. The managers are almost never required to touch the keyboard. Drill down and multidimensional analysis is supported. Interface to email and personal office applications are possible.
Size: 3 man-years, 6 months.
Responsibilities:  Technical leadership of the development team.

Education and Qualifications

No.  Qualification                    		Year   Institute
1    Diploma in Computer Science      	1974   Indian Statistical Institute -
      Thesis: Symbolic Differentiation	          Calcutta

2    Master of Statistics             		1973    Indian Statistical Institute -
      Specials in Computer Science          	           Calcutta
      1st Class; rank 1st                  

3    B.Sc. Honours in Physics         		1971    St. Xavier's College - Calcutta

4    Indian School Certificate        		1968    St. Edmund's School - Shillong

5    National Science Talent Search   	1968    All India Examination 
      Scholarship     				           - ranked 1st

                             
Employment Summary

No. Organization            Period        Important Work Done
1   Independent               Oct 1995-    Hospital and Hotel Management
     Consulting                  Present       Evaluate Architecture options
                                                        WEB Application development
                                                        Network Consulting
                                                        RDBMS Application Tuning
                                                        Application Development
                                                        Testing and Implementation
                                                        Training for high-end skills
2   NIIT                      Sep 1992-        Manager looking after marketing
                                 Oct 95                 and execution of projects in 
                                                           Application Software Development
                                                        Executive Information Systems
                                                        ERP(BPCS)
                                                        SYBASE Technical Support

3   ICIM                      Dec 1982-       Manager responsible for Pre-Sales Support
    A subsidiary            Sep 92            Transition from COBOL to RDBMS
    Of ICL   UK                                    Technical Support 
    Exposed to all                                Benchmarking 
    ICL Platforms                                 Application Software Development                                                        
                                                        Transition from DME/DMF to UNIX/VME

4   CESC  - Electricity       Jun 1977-    Senior System Analyst
    Largest Utility              Dec 82                  developing applications 
    Used ICL-2904                               Analysis, Design, Programming
                                                                     and Testing

5   BOC - British Oxygen   May 1974-   System Analyst in 
     Used ICL-1901            Jun 77                    Application Development

Technical Skills

Operating Systems
MS-NT, DRS/NX, HPUX, DEC/OSF1, SUN-Solaris, VAX-VMS;  
ICL VME, TME, George2+, DMFIII

Programming languages and Development Tools
ABAP, Developer 2000, PowerBuilder 7, Designer 2000, Visual Basic
INTRANET and WEB Technologies, C++, S-Designer, ERWIN
COBOL, PLAN 1900, RALLY, Java, J2EE, VB.NET & XML, Flex3(MXML & Actionscript)

Data Base Platforms
ORACLE, SYBASE, MS-SQLSERVER, INFORMIX, RDB and INGRES.

Application Server Platform
Orion and equivalent OC4J(Oracle) J2EE Application Server
Also worked on BEA WebLogic EJB Container

ERP
SAP ERP 4.7, ECC6 Netweaver 2004s