| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLESKILLS 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 9.1, Oracle Fusion along with SalesforcePeople Tools: 8.56Business analyst and System analystDevelopment 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 ROperating Systems: OS/390, Aegis, UNIX, Windows, OS/2Languages: 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 PerlRDBMS: IBM Db2, Sybase, SQL Server 2016, Teradata, OracleHardware: HPUX, IBM RS6000, PDP-11, IBM Compatible PC, IBM 3090(MVS)Statisrtical application: R, Teaching Statistics and Calculus for High school studentsReporting Tools : BI Publisher, Power BIEDUCATION:Indian Institutes of TechnologyBachelors and Master of Technology, Mech Engg, IndiaPROFESSIONAL EXPERIENCE:SORS Technology Inc People-soft consultant for Anthology/Blackboard Mar 22 ongoingMaintaining, 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.1Aggregating,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, RDesign and create training content for training and webinar use for an Inhouse clientWrite 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 neededDevelop queries, dashboards, and reports Using Microsoft SQL server and Oracle databasesProgramming 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.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 findingsTechnical presentation skills & on Call Responsibilities to support major incident outages.Project Management techniques using PERT-COM and GNAT charts and creating the DOD architectural framework designsMigration 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.USITC (Public Trust - P7) Sr Systems Analyst /Systems Admin Dec 2022 Apr 2023Systems 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 clientDefine 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 applicationsVery 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 clientsFidelity Systems Consultant and Sys Admin July 2021 Mar 2022Supporting/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 rulesMaster 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 instancesProduction 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 preparationsHelping 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 databaseUsing 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 identifiedDeveloping 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 CRMPerl scripts/Unix scripts and power shell scripts for windows for moving files and processing .Blackboard Inc. Feb 2017- Mar 2020Application 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 databasePeoplesoft Modules : Time and Expense, Supply Chain ( Purchasing and Inventory), AP, AR, Contracts, Billing, AMUsing 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 FusionThe 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 modulesMaintaining 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 neededSecurity 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 teamsTesting 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 PeoplesoftHousing and Urban Development November 2014-January 2017Peoplesoft 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 systemInvolved in new code changes Requirement analysis, Design both functional and technical and approval there off for the HUDCAP system with IntegrationsResolve ticket from users on a daily and timely basis and reporting the statistics to my managers on a daily basisVerifying Data on Mainframes and Integration testing with Data from Mainframes to PeoplesoftCapital One October 2014-November 2014Peoplesoft 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 entryDevelopment/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 SharepointSupporting People soft Payroll and migration to WorkdayFINRA/Wisetek Providers April 2014-September 2014Peoplesoft Admin and Support analystDevelopment/Supporting and Maintenance of Peoplesoft system Ver 9.1 FSCMModules: Procurement. AP and GLWriting new SQR codes and application engine Peoplecode and going through the phases of the development to rolling it into ProductionDeveloping OLAP queries using Cube ManagerAddressing tickets and resolving them tickets as per Managers prioritiesVtechsolutions March 2014-April 2014ConsultantShort project This project for the State Dept DGS (General services ) for both HR and Finance on SQL server 2008Delivering 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 projectsModule: Time and Expenses and ProjectsMultinational Client at MI, GE HRMS July 2013-March 2014ConsultantDevelopment/Supporting and Maintenance of Peoplesoft system Ver 9.1 HCMModules: HR Job pages and Custom integrations, Pay calc, Time and Labor(T&L), Pay confirmation and Jobs modulesExtensive testing on QA servers/UAT servers by users and the support server which is 1 day old of ProductionWriting new SQR codes and application engine Peoplecode and going through the phases of the development to rolling it into ProductionAddressing tickets and resolving them tickets as per Managers prioritiesIBM / OST Inc July 2007-June 2013Consultant for Federal clientDevelopment/Supporting and Maintenance of Peoplesoft system Ver 9.1/9.0 FSCM and Revenue ManagementModules: Revenue ManagementConverting 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. |
