Subrata Mondal

ad2dug@r.postjobfree.com

571-***-****

SKILLS SUMMARY:

ERP: PeopleSoft FSCM Version 9.2/8.9/8.8/8.1 RM version 8.8, HCM version 9.10.01.100 and CRM, Oracle Fusion

People Tools: 8.56

Business analyst and System analyst

Development Tools: Application Designer, Configuration Manager, Data Mover, AE, Application package & classes, CI, SQR, Crystal, IB, XMLP aka BI, Cube Manager, Integrations (MuleSoft and Azure), Vertex for Tax on Peoplesoft and Kimble for Contracts, Eskers for Billing file transfers, Oracle Fusion, Cloud technology (Azure and AWS), Python and R

Operating Systems: OS/390, Aegis, UNIX, Windows, OS/2

Languages: Micro focus /Visual COBOL, C, Basic, Cold Fusion, JavaScript, HTML, PowerBuilder, Sybase, Java 7, People code, Lotus scripts, Linux scripts, JSON (JavaScript object notation), Python R and Perl

RDBMS: IBM Db2, Sybase, SQL Server 2016, Teradata, Oracle

Hardware: HPUX, IBM RS6000, PDP-11, IBM Compatible PC, IBM 3090(MVS)

EDUCATION:

Indian Institutes of Technology

Master of Technology

PROFESSIONAL EXPERIENCE:

SORS Technology Inc Technology Consultant Mar 22 – ongoing

Aggregating,combining,cleaning and transforming data for my clients

Data cleaning and Data visualization based upon College board scores and SOL(Standard of learning scores )- available public data from schools to put up and come up with statistical ranking within counties – This is an ongoing project as requirement keep changing from time to time. Python, R, SSRS and

Design and create training content for training and webinar use for an Inhouse client

Write technical documents and training collateral to support training projects, Job aids, using virtualframeworks.com to think creatively, reframing questions/ideas/solutions abd bringing on possible solutions and strategies.

Proven ability to analyze and interpret results with some complexity

Develop queries, dashboards and reports Using Microsoft SQL server and Oracle databases

Programming in Python and R using Sql server database. Experience using Bloomberg data on Exchange rates and transformations. Python Code and libraries reengineering along with Visualization with R and python programs

Use modeling and trend analysis to analyze data.

Implementation of Peoplesoft HR/FSCM/CRM/EPM along with SQL server 2014.

Collaborate with team members and participate in team projects and initiatives. Requirement analysis from clients and transforming them to use case diagrams or user stories and documentation for developer for behavior and functionality so that developers can write code accordingly . Job aids for functional specification documentation and technical specifications as well. Managed a team of 3 developers. Strong understanding of software development methodologies .

Utilize effective written and verbal communication to document and present findings

Technical presentation skills & onCall Responsibilities to support major incident outages.

Project Management techniques using PERT-CPM and GNATT charts and creating the DOD architectural framework designs

USITC Sr Systems Analyst Dec 2022 – Apr 2023

Systems engineering – Designing/Documenting/Database architect/Proof of concept/Testing the application/Reengineering AWS cloud for the Govt. designing and building a Data centric ecosystem so that the client can bring in changes swiftly without disturbing servers, clients, software and very minimum effort on data users. Created a central hub for data processing and computational perspective(Enterprise data lakes). Created Frames which are linked datasets for EDL . Design and documentation was all along the way with Revisions.

Preparing DOD framework Model diagrams ( AV, OV, SV, TV) for the applications for the federal client and documentation there off along with relevant documentations. Preparing Job aids, training guides and presentations for clients. Preparing minutes of the meeting, reports, briefings, presentations for the management reviews.

Designing/Proof of concept/Writing code in Python for Okta implementation with integration with login.gov for Federal client

Define and documenting the features requirements, user stories and documenting each and every action and story till it is done. Good knowledge with API technical specs or documentation to refer to the user story. Used Saggerhub open API tool . Testing them and discussing and fine tuning the results with the team.

Create/review architecture and solution design artifacts for federal clients . Enforce architectural standards, implement engineering code reviews, continuous integrations and proper documentation for the user community.

Agile technology and Scrum master for the team Communicating with the teams with lead on status and timely follow up and reminder on email calendars. Project life cycle and implementation of GNATT charts on Projects along with assisting the Project Manager with PERT and CPM techniques and reporting status of the project in daily meetings and client meetings and timely completion.

Analyze business requirements from clients and end users and simplifying them with use case diagrams to developers/testers/ PM and displaying demo of features as and when developed.

Very Good working knowledge with SQL server and Oracle databases and database administrator with Sql server 2014 . & Oracle databases including sybase and Peoplesoft database. Peoplesoft database resides over a RDMS database.

Create, edit, and organize technical and organizational information and turn it into compelling and useful content for internal audiences.

Worked with the CMMI team to get the Level certification by trying to understand the process, brainstorm with the user group and developer group to fine tune processes and implementations.

Develop business process and research, better sync and automate if need be with the acceptance of stake holders . Including development of training programs with clients

Fidelity Peoplesoft Consultant July 2021 – Mar 22

Supporting/Developing/Maintenance/Testing and Functionally testing for a big five Bank – (Peoplesoft 9.2 and Tools 8.57 with Oracle Db). Preparing Job aids for users to track, log/make changes and individual steps for regular day to day work for users. Testing of applications through Peoplesoft test framework- Testing is always verified by business rules and flow as per the business rules

Production support, improve processes in Peoplesoft, recommend software upgrades/updates, design and implement quick fixes along with approval from the stake holders, security fixes in Production and Job aids or training document preparations

Helping client and users groups on how to format files and load files, user issues, business rules. Thats also incudes Peoplesoft supported ExceltoCI.

Production support for users and fixing bugs with raising tickets using Service Now and Jira

Developing reports with SQL tools on Oracle and SQL server. Interacting with users on Data anomalies and matches, Crystal reports, XML publisher. Supporting the cloud team to move/functionality through AWS cloud.

Data anomalies, data duplication, data overload issues rectified when importing data from different systems – Rectification with SQL data, Python/R in test system and projecting them to users and putting in tickets to get the same rectified in Production.

Developing queries, Functions, stored procedures, hierarchical, recursive,OLAP sql queries in database to view reports that are runnable by users.

Functional assistance to users with with Peoplesoft FSCM, HR and CRM

Perl scripts/Unix scripts and power shell scripts for windows for moving files and processing .

Blackboard Inc. Feb 2017- Mar 2020

Application Specialist( Peoplesoft admin and Developer)

Supporting/Development/Maintenance and security with Critical systems that rely on support for 24/7. Which includes regulating user created tickets using Service now, assigning it to team members and getting it into resolution and closing the tickets based on user acceptance.

Developing queries, reports from Database as needed for users using hierarchial, recursive, aggregate, analytic functions within sql.

Using Python to verify data quality issues and anomalies to fix and reporting tools to visualize data.

Migrating Data from Peoplesoft to Oracle Fusion(SAAS) on AP GL modules and from Sales force to Peoplesoft on contract modules by home grown methods. It is a cheap alternative for high cost consultants – which includes mapping, verifying data and exporting on windows environment.

Peoplesoft HR support on Payroll which includes configurations and day to day support.

AWS on applications and data being moved to Cloud.

Managed Multiple Project and managing the development life cycle from gathering requirements, functional design, Technical design, QA Testing and UAT and rolling it into production in the following projects Customization of Time and Expense module, Migration of Peopletools 8.52 to 8.56, Vertex upgrade from Version 7 to 9, Bloomberg feed incorporation for daily rates and syncing the data with Oracle Fusion

The Modules are AP, GL, AR and Billing, Contracts, Projects, Purchasing,Sourcing, Purchase orders, Procurement, Inventory, Travel and Expenses, Customized modules in HR and CRM Concur integration with T&E on Peoplesoft and custom modules

Maintaining and supporting Eskers AR module billing.

Development on People tools, Fields/records/pages/components/Menus/CI(Component Interfaces), App engines, SQL, Application packages . Processing of Daily files (bank files) – Verifying databases are properly refreshed on windows ( sql server 2008/2016) and Bug fixing via Service Now tickets that user creates and bringing them to resolution and improving the process with changes in code or integration as needed

Security analysis on new employees/control security through permissions and roles for Blackboard on CRM/HRMS and FSCM applications. Meeting with internal and external security groups for Validation, reports and audit compliance both with Auditors and Federal teams

Testing applications that are being developed and in developmenet for features expressed in client for HRMS/FSCM/CRM – using standard business rules and/or Peoplesoft Test Framework

Month end/Quarter end/Year end support for Peoplesoft application and Database backup patches and fixes as needed. Development in Perl, Python and R as needed SQL server 2016 -- DBA and Peoplesoft administrator for HR/CRM and FSCM. Integration of Customers, address both async and sync from Sales force to Peoplesoft

Housing and Urban Development November 2014-January 2017

Peoplesoft Consultant(Admin and Developer – Held Public Trust )

Migrating applications from Peoplesoft Ver 8.8 to Ver 9.2 to Tools 8.52. Upgrade Project. Revenue Management is a standalone application. FSCM (AP, GL, AR Billing) and custom codes for HUD (Housing)

Developer for SQR/Crystal/BI, nVision, Peoplecode (Peoplesoft application ) and minor bug fixes.

Security admin for Peoplesoft Prod systems.

Month end/Quarter end/Year end support for Peoplesoft application and support for every 90 day password changes in all the system and integrating system

Involved in new code changes – Requirement analysis, Design both functional and technical and approval there off for the HUDCAP system with Integrations

Resolve ticket from users on a daily and timely basis and reporting the statistics to my managers on a daily basis

Capital One October 2014-November 2014

Peoplesoft Support analyst(Development)

Short project – This is modifying code on a page to have an attachment feature introduced on a custom Contract page. Without disturbing the existing functionality in the pages. The clients

wanted the documents to be saved on the server and easy retrieval with display of the document son the web browsers. JavaScript code was introduced for validity of online fields data entry

Development/modification of field, Record, changes to the component and accessing the server and adding security role to that. Development of Queries and reports and storing it in Sharepoint

Supporting People soft Payroll and migration to Workday

FINRA/Wisetek Providers April 2014-September 2014

Peoplesoft Admin and Support analyst

Development/Supporting and Maintenance of Peoplesoft system Ver 9.1 FSCM

Modules: Procurement. AP and GL

Writing new SQR codes and application engine Peoplecode and going through the phases of the development to rolling it into Production

Developing OLAP queries using Cube Manager

Addressing tickets and resolving them tickets as per Managers priorities

Vtechsolutions March 2014-April 2014

Consultant

Short project – This project for the State Dept – DGS (General services ) for both HR and Finance on SQL server 2008

Delivering reports and developing a new application engine for their custom application which is internal to the system. Development was done for adding new fields, records, pages, component for their internal repairs in state govt building and the cost of contractors on the project and then its cause and effect on similar projects

Module: Time and Expenses and Projects

Multinational Client at MI, GE HRMS July 2013-March 2014

Consultant

Development/Supporting and Maintenance of Peoplesoft system Ver 9.1 HCM

Modules: HR Job pages and Custom integrations, Pay calc, Time and Labor(T&L), Pay confirmation and Jobs modules

Extensive testing on QA servers/UAT servers by users and the support server which is 1 day old of Production

Writing new SQR codes and application engine Peoplecode and going through the phases of the development to rolling it into Production

Addressing tickets and resolving them tickets as per Managers priorities

IBM / OST Inc July 2007-June 2013

Consultant for Federal client

Development/Supporting and Maintenance of Peoplesoft system Ver 9.1/9.0 FSCM and Revenue Management

Modules: Revenue Management

Converting all main frame applications to Peoplesoft for Federal client.

New Development of all new features that exist in IBM main frames with the client.

Conversions of data using application engine and unix scripts for messaging of data.

Reporting tools like Crsytal, BI Reporting, developing queries.

Contact this candidate