Samrat Kar, PMP

Experience

• 

  HCL Technologies

  Aug 2000 - Nov 2001

  Associate

  Project- Lufthansa Cargo eBooking systemLocation - Bangalore India Responsibilities• Involved in the designing/preparing use cases/development/Testing of a module called Queue Handling • Coding part was in ProC in which dynamic SQLs was used and made calls to stored procedures(written in PL/SQL) in ORACLE from the ProC code, C++ in which Roguewave Class libraries were used • Queuing of messages using tuxedo was also implemented by me• Used BEA Weblogic server for running servers coded in C++.• Also involved in writing Use Cases, Test Cases, design work and client interaction.• Performed GUI, Performance and Load testing using Rational Robot and Rational performance studioTechnologies Used- C++, Pro* C, Roguewave class libraries, CORBA, PL/SQL, Shell scripting, Tuxedo, Oracle 8i, Rational Robot, Rational Performance Studio, Rational Rose, BEA Weblogic, Clearcase, HP UX Show less

• 

  Raffles Software

  May 2002 - Nov 2002

  Technical Consultant

  Customer- ANZ Grindlays Bank Responsibilities • Designing, development and testing of 2 packages namely Collections and Payment Management• Used the prophecy tool that is basically a 4G development tool used for achieving the business logic related to the GUI needing interface with the database• Used PL/SQL for implementing the business logic, which was required by the batch jobs.Technologies Used- PL/SQL, XML, Shell scripting , ProphecyOpen, Windows XP, HP UX

• 

  Cyient

  Dec 2002 - Oct 2003

  Software Engineer

  Customer-Pratt and Whitney Project- Graphical processing unitResponsibilities • Designing of test cases Designing of complex Control system circuits using the various combinations of 56 control system primitives by giving different data types as input Providing code fix for production issues Entering the Circuits into the GPU tool• Reviewing the C++ and ADA code generated by the tool Developing tools in VBA, VC++ for automating some of the processes in all stages Shell and DCL scripts for batch mode running of the test cases Verifying the generated files• Designing Software Requirement specs (Includes Control System test circuits) • Entry of the components into the GPU tool and Generation of code in ADA and C++• Preparation of discrepancy report between design and actual code generated by the tool• Develop code in VBA for automated creation of design documents• Development of defect tracking toolTechnologies Used- C++, ADA, VBA, DCL, Shell scripting ,Graphical Processing Unit ,Windows XP, VAX VMS Show less

• 

  Polaris Consulting & Services Ltd

  Nov 2003 - Mar 2004

  System Analyst

  Customer-GE Plastics, USAProject Title-GE Plastics, Asia Pacific ERP supportResponsibilities • Production support to users who were using System ESS which was a homegrown ERP application written in PL/SQL and Unix shell scripts• Monitoring of Scheduled Jobs • Providing code and data fix for production issues and development for minor enhancements• Doing Root cause analysis for high priority tickets• Creation of TDD and FDD for major enhancementsTechnologies used - C++, Unix Scripting, PL/SQL, Pro * C Oracle 8i, MS Office, System ESS, Remedy,Sun Solaris Show less

• 

  Cognizant

  Mar 2004 - Mar 2005

  Associate

  Customer-Mellon BankProject- Defined benefits calculation Business analysisResponsibilities • Preparing the pseudo code for defined benefit calculation and Making changes according to change requests• Understanding the plan structure for individual clients• Comparing of pseudo code and code written in C++ and PL/SQL• Preparation of discrepancy report between TDD and code, Modification to code according to discrepancies• Writing shell scripts for batch jobs that used to run the calculation engines• Preparation of technical design documents for new and existing customers• Code review and Impact analysis for change requests.• Interaction with Customer and Onsite team for requirement gathering and provide status reports• Mentoring and monitoring of junior team members• Preparation of user manual for the entire DB Calc process in Robot helpTechnologies used - C++, Unix Scripting, PL/SQL, Pro * C, Windows XP, Sun Solaris, Oracle 8i, Robo help, MS Office, Defined Benefit Calculator Show less

• 

  Tata Consultancy Services

  Mar 2005 - Sept 2017

  Associate Consultant

  Worked for various customers listed below in Business Intelligence and Oracle EBS suite in Supply chain, Finance and CRM domain. Worked at various locations in US,UK and IndiaOracle EBS Modules used-Order Management, Inventory, Shipping, Warehouse Management Systems, Purchasing, Pricing, Account receivables, Account Payables, Fixed assets, General Ledger, Incentive Compensation, E-commerce Gateway, Approval Management Engine, CollectionsTechnologies Used-Oracle PL/SQL, Oracle forms and Reports, Oracle workflow builder, Unix Shell scripting , TOAD, , XML publisher, JDeveloperResponsibilities • Enhancing and supporting the existing customization on the SCM and finance applications using PL/SQL which included various incoming/outgoing EDI, the entire automated booking to shipping application, various customized forms and reports, various inbound and outbound interfaces. There were a total of around 500 customized components that were supported and enhanced by me and my team.• Designing and developing the migration of standalone forms application to Oracle EBS• Writing MD50 and BR100 documents• Implementing a new operating unit in order management, inventory, purchasing, account receivables, account payable and general ledger in a tight schedule• Analysis, Planning, Development and support for the upgrade of Oracle EBS from 11.5.9 to 11.5.10ALCOA IncGlobal data warehousePittsburgh (Pennsylvania)ALCOA Mill ProductsSiebel CRM Application maintenanceDavenport (IOWA)IKON/Ricoh Oracle EBS Quality assuranceNorristown (Pennsylvania)CVS Caremark Third Party Management SystemWoonsocket (Rhode Island)Sunrise GreetingsOracle EBS Application Support and maintenance.Bloomington (Indiana)Hallmark Oracle EBS Application support and maintenanceKansas CIty (Missouri)Cummins Inc.STAT and SWIFT implement Columbus (Indiana)Canon Oracle R12 EBS MaintenanceKolkata (India)Arval fleetDrive application bug fixingSwindon (United Kingdom) Show less

• 

  CNSI

  Oct 2017 - Oct 2018

  Software Developer 3

  Project- Medicare Medicaid Information Systems, Conversion for State of Michigan(CHAMPS) and State of Illinois (IMPACT)Project details- • State of MI -CHAMPS Facility Settlement- is to settle out federal funds to facilities like Clinics, School Based Services (SBS), and Hospitals and so on. Based on the contract, the payments are made monthly and at every fiscal year end the amount is settled out to these facilities. This is to ensure the all child facilities also get the amount as per the services provided based on the certifications of services on that facility.Responsibilities • Creation of jobs in data stage and PL/Sql for conversion projects. These jobs were basically used for converting data from legacy systems to oracle systems. There used to be one job specifically for each target table. Features of datastage that were used included and not restricted to merge, join, lookups, transformers, funnel, sort, pivot, database connectors• Designed, implemented, maintained and presented the SID preservation logic. The purpose of this component was to preserve the SID values across the instances and to have a unique target ID for each ID in source system.Environment- Datastage (ETL), PL/SQL, UNIX Shell scripting, Putty, Toad, Oracle 12c, Clearquest, Windows 10 Show less

• 

  Bank of America

  Apr 2019 - now

  Assistant Vice President