SHIVA KUMAR

Profile
From past 10+ years I am working in this IT industry and I have strong expertise in J2EE and Data Warehouse applications. I have worked in both Project and Product environment, and have implemented Enterprise applications like Pharmacy Data Warehouse, Pharmacy Account Receivables, J2EE framework, CRM for European FMCG market, Banking, MRP II, Point of Sale, Work Flow Automation, Financial Accounting and Management Information System.
I have proficiency in understanding Business user requirement and translate to strong design through OOAD and UML, to provide best possible value added solution in IT industry.
Designed, developed and successfully implemented many Enterprise applications on large databases for major clients in USA, Europe and India like Duane Reade (Pharmacy Chain), Nestle, KJS, Whirlpool, MAX Pharma (Drug manufacturing Industry), Wipro (Printer Manufacturing Industry), World Bank, Co-operative banks, State irrigation department and Washington Dental Service
Currently working for a client “Duane Reade”, a Pharmacy Chain in New York and managing (requirement study, analysis, design and implementation of) following applications on IBM AIX platform
 Pharmacy & Non-Pharmacy Data Warehouse using Business Objects and DB2 UDB, which helps corporate management to reduce cost and improve productivity, revenue and gross margin
 Third Party Account Receivable, a J2EE Web based application using BEA WebLogic, which keeps track of accounts and receivables from Insurance Third Parties
 Pharmacy Intranet, which establish sophisticated communication between corporate office and pharmacy stores
 Patient Compliance Program, a CRM application to improve customer relation and increase corporate revenue







IT Work Experience (10+ Years)
Aug-2002 to till-date: Program Manager and Technical Architect at Duane Reade Pharmacy Chain in New York-USA, for Pharmacy applications developed by ADITI Technologies. Duane Reade operates around 260 pharmacy stores in New York & New Jersey.
 Manage all Pharmacy related applications developed by Aditi technologies like understanding business user requirements, design architecture, define application features and standards, offshore team management and technical support.
 Designed, developed & successfully implemented a Pharmacy Data Warehouse using DB2 UDB & Business Objects products on AIX platform. This helps Corporate Management to generate various pre-defined and ad-hoc analysis reports across various dimensions Fiscal Calendar, Store, Drug, Carrier, Patient and Physician with minimum technical knowledge.
 Successfully deployed a TP AR (Third Party Account Receivable) Application, which is developed in J2EE technology using WebLogic 8.x & DB2 UDB on AIX. This application helps TP department to Manage Carrier information; bill/re-bill claims and adjusts payment received by TP Carriers against Claims.
 Designed, developed & successfully implemented a Pharmacy Intranet Application, which establish sophisticated communication between Pharmacy Corporate office and Pharmacy Stores Ex:
a) Publish HR Policies, Holiday Schedules, News & Events, Important Messages, etc.
b) Publish reports like Refills Due, Drug Recall, Inventory, Loss Prevention, etc.
 Designed, developed & successfully implemented a data de-duplication program, which cleanse Patient and Physician address using FirstLogic address cleansing tool and compares Patient and Physician information across pharmacy chain to create non-duplicated Patient & Physician information
 Designed, developed & successfully implemented a CRM application “Patient Compliance Program”, which improves customer relation and increase revenue across chain. Like refill reminder, refill pick-up reminder, health education, introduction to new drugs, recall drug info, FDA drug warnings, generic opportunities, welcome to new customers and sale promotion information.
 Designed, developed & successfully implemented a Front Store Data Mart, which helps Corporate Management to create reports and analyze data across Pharmacy and Non-Pharmacy departments.
 Designed, developed & successfully implemented a Purchase Monitor application, which helps Purchase department to monitor low-cost drugs, formulary and invoiced items.
 Designed, developed & successfully implemented large number of Business Analysis reports, which helps Pharmacy Chain to improve productivity, generate more revenue and improve gross margin.
 Database Administration of DB2 UDB 8.1 on AIX 5.1, and successfully fine-tuned VLDB 250 GB (with 3 & ½ years of prescription data) and many complex reports.
 Configured the DB2 Servers to take database backup directly onto TSM Server.


Mar-2001 to July-2002: Technical Architect for J2EE projects in ADITI Technologies - www.aditi.com, a Software development company in INDIA & USA.
 Designed, developed & successfully implemented a J2EE Meta data Framework tool (Ensemble), which helps business analyst to build their own applications by translating Domain Neutral Abstraction (DNA) vocabulary/methodology to J2EE application without writing programming codes. This expedites the application implementation by reducing code design, code development and code testing. This Product implements many J2EE Design Patterns to make the Product robust and independent of database and application server.
 Design and developed a “Port Of Seattle” J2EE application, which allow customers to logon, view and reserve parking place for their ships.
 Designed, developed & successfully implemented a Data Mart on SQL Server 2000 database for Washington Dental Service (WDS), Seattle, USA. This helps WDS Management to generate various analysis reports to monitor services provided by Physicians, by city and by region. This also provides flexibility to members to login and monitor online statements through Web.

Jan-1998 to Feb-2001: Team Lead & Technical Architect for FMCG-CRM Products at DeDuCo Software Systems - www.deduco.com (European development center in Bangalore, India).
 Visited Clients KJS, Nestle & Whirlpool in Belgium, France & Netherlands to understand & analyze business requirements for FMCG-CRM product “Key Account Plus (KA+)”.
 Designed, developed & successfully implemented a multi-language CRM product “Key Account Plus (KA+)” for FMCG super markets in Europe. This allows Key Account Managers, District Managers and Sales Representatives to create their Marketing Sales Plan (MSP), Customer Plan (CP) and Work Sheet Plan (WSP) based on the promo and budget allocated by the plan. This also integrated with field CRM application “SALES FORCE PLUS” to compare the actual Vs planned.
 Successfully Migrated a multi-language CRM product “SALES FORCE PLUS (SF+)” from Client Server PowerBuilder architecture to 3-tier J2EE architecture. This allows field representatives to directly interact with central office to check stock, place orders and synchronize with central office for latest information.
 Successfully implemented replicated database (Sybase SQL Anywhere) across Fields and Central office, to reduce the complexity of End-of-Day activities and improve the communication between central and field representatives.
 Designed, developed & successfully implemented a multi-language CRM Product “CALL CENTER PLUS (CC+)”, which supports Clients and Call Center staff to open and track cases, and supports Supervisors to schedule routing for technician/representatives based on geographical location. Also integrated with MAP software to help Supervisors while scheduling.
 Successfully designed and implemented an Intranet application to establish sophisticated communication between Head Office in Europe and Development center in Bangalore. This helps Users to track Project Schedule, Time Sheets, Leave applications, LTA, Medical-Claims, and also to publish HR Policies and other personnel information like address book.

Nov-1995 to Dec-1997: Software Engineer & Project Lead for MRP, Banking, Work-flow-automation and MIS Projects in Excel-Soft Technologies - www.excelindia.com (Mysore, India)
 Successfully completed the Requirement Analysis, Design, Development and Implementation of a banking application for co-operative bank. To track online day-to-day transactions, Loans, Shares and accounts management
 Designed, Developed and successfully implemented a Work-Flow Automation application “Work-In-Progress (WIP)” for Printer Manufacturing Industry. This application helps to track printer production from component assemble to quality assurance and dispatch. Also integrate with Bar Code system to read and print Bar Codes.
 Successfully completed the Requirement Analysis, Design, Development and Implementation of MRP II application for Pharmaceutical Drug Manufacturing Industry. I was responsible for key modules like Purchase, Stores, Payroll, Personnel, Time & Attendance and Equipment Maintenance. Also include work-flow automation to track all documents like Indents, Enquiries, Quotations, Purchase Orders, Goods Receipt Note (GRN), Quality Assurance and Payments.
 Successfully completed the Requirement Analysis, Design, Development and Implementation of a Rehabilitation & Resettlement Management Information System for World Bank, IMF and Irrigation Department of Karnataka State, India. Allow Users to capture details about Project Affected Family (PAF), Project Displaced Family (PDF) and live stocks, which helps in compensations calculation and generate various MIS reports for Management & World Bank.

Mar-1995 to Oct-1995: Software Engineer for Point of Sale (POS) and Financial Accounting Projects in Chadurang Compuware (Mysore, India).
 Successfully completed the Requirement Analysis, Design, Development and Implementation of Point of Sale application for retail wholesalers to keep track of online day-to-day sales, purchase and inventory data. Also integrated with Financial Accounting application to update the accounts online.
 Successfully completed the Requirement Analysis, Design, Development and Implementation of Financial Accounting application for retail wholesalers to capture information like vouchers & payments, to generate various reports like Balance sheet, Trial balance, cash ledger, etc.


Education
Bachelor of Engineering (B.E.) in Computer Science, 1995

Skill set - Business Domain
 Business Intelligence, Intranet & Account receivable applications for Pharmacy Chain
 CRM product for European FMCG Market
 Banking
 MRP II for Drug Manufacturing Industry
 Point Of Sale (POS) for Retail Sales Super Markets
 Work Flow Automation for Printer Manufacturing Industry
 Financial Accounting for Wholesale Traders
 Management Information System (MIS) for State Government and World Bank
 Meta Data Model: Rapid Application Development Framework for J2EE Applications using DNA (Domain Neutral Abstraction) methodology

Skill set - Technical
 Operating System: AIX 5.1 (IBM pSeries, RS/6000), Windows 2000/NT Server & DOS
 RDBMS: IBM DB2 UDB, MS SQL Server, Sybase SQL Anywhere (with Database Replication), Sybase Enterprise Adaptive Server, Oracle, MS-Access and PostgreSQL
 J2EE Technology: EJB, JSP, Servlet, JDBC, XML, XSL, Java AWT/Swing, HTML and JavaScript
 UML Design Tools: TogetherSoft and Rational Rose
 Data Modeling Tool: Sybase PowerDesigner and ERWin
 Application Servers: WebLogic, Pramati and Orion
 Development & Reporting Tools: Business Objects Products (Universe, Supervisor, WebIntellogence & Broadcast Agent), PowerBuilder, InfoMaker, Visual Basic with Sheridan Tools, IBM Visual Age, JBuilder for Java Development, Allaire Homesite for JSP development and Crystal Reports
 ETL Tool: Business Objects Data Integrator (ActaWorks)
 Computer Language: Java, Clipper (with Flipper & Blinker), Foxpro, C and Pascal

Other Professional Achievements
1) Sybase Certified PowerBuilder Developer Associate (CPDA6), Jan 2000.
2) Consistently rated between 80 to 90% in monthly appraisals at DeDuCo Software Systems (European Software Development Center in India).
3) Undergone 2 1/2 months Industrial Orientation Program (as part of academic course) at High Speed Fiber Optics Systems Section - FOSAPP, ECIL, Hyderabad, India.
Project-1: Development & Testing of Driver routines for FDDI Node Controller.
Project-2: Study & Testing of 20 mbps Fiber Optics link for PARAM Super Computer


Summary of Projects & Technologies
1) Business Intelligence for Pharmacy Healthcare: Pharmacy and Non-Pharmacy Data Warehouse for "Duane Reade” Drug Chain, New York, USA.
Tools and Technologies: AIX 5.1, DB2 UDB 8.x, Business Objects 6.x, BO Data Integrator (ActaWork - ETL tool), Business Object Web Intelligence, Business Objects Broadcast Agent, FirstLogic Address Cleansing, WebLogic 8.x Application Server, PowerDesigner data modeling tool, PDX and TSM for DB backup.

2) Intranet for Healthcare systems: Pharmacy Intranet for "Duane Reade Stores”, New York, USA.
Tools and Technologies: Windows 2000 Server, DB2 UDB on AIX, IIS, ASP, VB Macros for Business Objects, PowerDesigner and Citrix Server.

3) Business Intelligence for Healthcare systems: Dental Insurance Service Data Mart for “Washington Dental Service (WDS)”, Seattle, USA.
Tools and Technologies: Windows 2000 Server, SQL Server, DTS, IIS, PowerDesigner data modeling tool and ASP.

4) Meta-Data Model: Domain Neutral Abstraction (DNA) Rapid Application Development Framework for J2EE Applications.
Tools and Technologies: Windows 2000 Server, Linux, Oracle 8, SQL Server, PostGreSQL, Pramati Server & Studio, WebLogic Application Server, EJB, Java Swing, JSP, TogetherSoft for UML Diagrams, JBuilder and PowerDesigner data modeling tool.

5) CRM Products (3-tier): Sales Force+, Key Account+ and Call Center+ for European FMCG Market (Clients: Nestle, KJS, Whirlpool, etc.).
Tools and Technologies: Windows NT, Sybase Enterprise Adaptive Server, Sybase SQL Anywhere, WebLogic Application Server, EJB, JSP, Rational Rose for UML Diagrams, IBM Visual Age for Java, Allaire Homesite, Visual InterDev, PowerBuilder, Sybase Infomaker reporting tool and PowerDesigner data modeling tool.

6) CRM Products (Client-Server): Sales Force+ on Pen PC (handheld Computer) for European FMCG Market (Clients: Nestle, KJS, Whirlpool, etc.).
Tools and Technologies: Windows NT, Sybase SQL Anywhere (with Replication), PowerBuilder (with PFC), Cyrano testing tool, Sybase Infomaker reporting tool and PowerDesigner data modeling tool.

7) Banking: Banking Application for “Merchants Co-Operative Bank (MMCB)”.
Tools and Technologies: Windows NT, MS SQL Server 6.5 and PowerBuilder 4.

8) Work-Flow-Automation: Work In Progress, Tracking application for Printer Manufacturing Industry “WIPRO Printers”.
Tools and Technologies: Windows NT, MS SQL Server 7 and PowerBuilder 4.

9) MIS: Rehabilitation & Resettlement Management Information System (Upper Krishna Project) for “Irrigation Dept., Govt. of Karanataka, India & WORLD BANK”.
Tools and Technologies: Windows NT, MS SQL Server 6.5 and PowerBuilder 4, Clipper 5.2, and Blinker.

10) MRP II: Manufacture Resource Planning for Drug Manufacturing Industry “MAX Pharma”.
Tools and Technologies: Novel Network, Clipper 5.2, Flippere 6 and Blinker.

11) POS & Inventory Control: Point Of Sale and Inventory control for “Retail Sale Super Markets”.
Tools and Technologies: Novel Network, Clipper 5.2, Flippere 6, Blinker, MS Access and FoxPro 2.5

12) Financial Accounting: Financial accounting software for “Retail Sale Super Markets”.
Tools and Technologies: Novel Network, Clipper 5.2, Flippere 6, Blinker, MS Access and FoxPro 2.5

References
Reference will be provided upon request.