Business Analyst Oracle Fusion
Resume:
Subrata Mondal
*************@*****.***
SKILLS SUMMARY:
Maths: CalculusI,II and III, Linear Algebra,Statistics, Physics
ERP: PeopleSoft FSCM Version 9.2/8.9/8.8/8.1 RM version 8.8, HCM version 9.10.01.100 and CRM 9.1, Oracle Fusion along with Salesforce
Business analyst and System analyst
Use Case Methodology using Microsoft Visio,
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, TSO, JCL, CICS, 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, Toad
Hardware: HPUX, IBM RS6000, PDP-11, IBM Compatible PC, IBM 3090(MVS)
Statisrtical application: R, Teaching Statistics, University Physics and Calculus ( single and Multivariable) for High school students
Reporting Tools : BI Publisher, Power BI
EDUCATION:
Indian Institutes of Technology, Masters in Mech Engg, (Machine Tool Technology), Kharagpur, India
PROFESSIONAL EXPERIENCE:
SORS Technology Inc Consultant for Anthology/Blackboard Mar 22 – ongoing
Performing SWOT(Strength/Weakness/Opportunities and Threat analysis ), Upfront(new projects) and continuous discovery( for ongoing) and putting them in a Visio diagrams with Psuedo codes. Risk analysis and Impact analysis from the service now ticketing system databases. Waterfall methodology for requirement gathering, design, implementation, testing, implementation and Maintainence for the full life cycle of the project. Daily stand up with Agile /Kanban board.
ERP peoplesoft modules working upon is Account payables, Account receivables, General Ledger, Inventory management, Asset Management, P2P, Banking, Projects, Billing and contracts and Cost management. The sales force integration is from Orders into contracts.
Maintaining, attending service Now tickets, SQL server Database administration, New people soft development for 9.2 Tools 8.56 FSCM and CRM for my people soft installed client and migration to D365. Usage of People tools, SQR, BI Publisher, nVision, Peoplesoft Testing framework, Security applications through Peoplesoft delivered and also bolt on customization as required . Peoplesoft administration along with Development in FSCM 9.2 and CRM 9.1.Migration of Peoplesoft module to Microsoft Dynamics and Systems Integration testing, Integration testing and UAT with all integrations with Peoplesoft and other applications (Oracle Fusion, Sales Force, Feeds from Banks, Bloomberg for Exchange rates, Concur for expenses and Travel) Testing the functionalities, develop the test cases with developers and stakeholders, Maintaining the list of defects in UAT and Integration testing and bringing them to a closure with agile meetings within the team on a regular basis.
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
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 complexity. Reviewing, Preparing, analyzing, consolidating and reevaluating reports for clients as needed
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.
Peoplesoft Development and support HR/FSCM/CRM along with SQL server 2014. Specifically on Asset management. Integration of Data between CRM, Salesforce and Peoplesoft financials, using the contracts' module.
Data steward for Peoplesoft CRM and Peoplesoft Financials for Data incoming from Salesforce. Integrating data into Peoplesoft GL through database ad applications. Implement and schedule schedulers on windows/Linux or third party schedulers.
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 & on Call Responsibilities to support major incident outages.
Project Management techniques using PERT-CPM and GANTT charts using Smartsheets and creating the DOD architectural framework designs. Application of Project Management techniques and developing large projects. Discussing CPM and schedules and marking key points or Milestones when and where is to be achieved. Analyze and calculate manually variances. Calculation and prediction of floats and mathematically implement ( beta – a risk factor)
Application of Calulus I, II and II, Matrix algebra, Stochastic /Lambda calculus and Physics in applications.
USITC (Public Trust - P7) Sr Systems Analyst /Systems Admin Dec 2022 – Apr 2023
Systems engineering – Designing/Documenting/Database architect/Proof of concept/Integration testing/ 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. Testing of applications
Superior working knowledge with SQL server and Oracle databases and database administrator with Sql server 2014 . & Oracle databases including sybase and Peoplesoft database. Writing Stored procedsures, functions, Triggers, Materialized views, SQL queries . Loading Data from flat files and placing them in schemas.
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 Systems Consultant and Sys Admin July 2021 – Mar 2022
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
Master data is available on Mainframes, use of TSO, cobol programs, Generation Data sets and execution of specific JCL to get the desired output.. Integration testing in different instances
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.
Fine tuning SQL queries using Index creation, and explain plan with Oracle plans, Performance tuning. Writing stored procedures, triggers, functions for better performance and fewer server calls. Using SQL loader to load flat or comma de-limited files for loading onto oracle. Loading Excel files using connecting strings to load data onto tables. Importing and exporting files from Oracle database
Using Unix scheduler to schedule jobs in the background and writing bash scripts on the Linux machines to automate.
Production support for users and fixing bugs with raising tickets using Service Now and Jira Monitor databases -, job failures and fix them as it is identified
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 systems 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. Preparing GL statistical accounts, Forecasting techniques using linear, quadratic, cubic regression techniques for VP opeartions, Variance report generations.
Performance tuning with Index creation, Stored procedures, triggers using SQL on the SQL server database
Peoplesoft Modules : Time and Expense, Supply Chain ( Purchasing and Inventory), AP, AR, Contracts, Billing, AM
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. Integration testing and QA and UAT on application and feeds. Mainfarme data verification and tesing and data preparations.
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 System/System AdminConsultant(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
Verifying Data on Mainframes and Integration testing with Data from Mainframes to Peoplesoft
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 . Writing SQL queries to verify data, Data Loading from Excel sheets, Stored Procedures, Triggers, Views, and objects in Oracle Db
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