Suraj Deval Email & Phone Number

Columbus, Ohio Metropolitan Area

• Implemented web service protocols (SOAP, REST, GraphQL) and integration patterns with proficiency in OpenApi, JSON/YAML• Strong DevOps capabilities, adept in orchestrating CI/CD workflows utilizing Git, Jenkins, ensuring robust software delivery.• Spearheaded technical evaluations and overhauls of ETL platforms to streamline customer integrations and data reporting services.• Implemented OpenAI API prompts and script integrations for cross-team AI• Leveraged Artificial intelligence to automate the creation of record types within the PLC product. Used AI to analyze an incoming PDF file, transforms it into a structured data format, and passes the results to a robotic process automation (RPA) bot to create the record form within the PLC product.• ETLWorks implementation converting all the 500 customers from Snaplogic to ETLWorks.

Columbus, Ohio, United States

Implemented successful data requests in and out of financial applications like Bloomberg, FactSet, Findur etc. Led all aspects of redesign, support and maintenance of Nationwide Financial Application built in Teradata which was converted to oracle cloud that manages long term retirement products for both business and Individuals.Scheduled Unix/Perl scripts for periodic execution Autosys Job scheduler. Proactively identified bugs and fixed perl scripts to avoid job processing failures.Created Perl modules and framework for efficiently retrieving time series data from multiple data sources.Converted Perl modules into Python modules . Created Python scripts for jobs execution - transferring files and etc

Newyork

In an effort to maximize efficiency, lower cost and improve the overall experience with the City, the Department of Finance (DOF) is undertaking a transformative initiative, known as the Citywide Payments Services & Standards (CPSS) Program.The Citywide Services & Standards Data Repository is where all current receivables will be consolidated in a way that makes it easy for them to be passed to one or more third-party service provider(s) and for the payment information to be returned to the proper City systems for reconciliation purposes. From a City Agency System point of view, this project will require the integration of the agency system with the CPSS, in order for the agency to be able to send receivables to the CPSS and for the agency to receive payments through the CPSS against those receivables, as well as against retail payments. • Worked on Agile methodology• Designed complex mapping for the property tax system consisting of sensitive credit card data .• Users used to check their account balance via NYCServ, NYCe-File which the file being generated through informatica .• Developed rules and reusable mapplets to use in different mappings . • Migrated all the informatica code from 9.6.1 to 10.2.0 .• Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.• Implemented SCD1, SCD2, SCD3 type maps to capture new changes and to maintain the historic data.• Worked on developing FTP shell scripts to move the files and manipulate them . • Worked on few python shell scripting to migrate from perl scripting. • Worked with the functional team on gathering the data and worked closely with the business team to analyse the data and plan for the design . • Worked on Developing ,Documenting enterprise policies , standards and procedures in Data Governance for data quality .

New York, New York

Tapestry business units creates offers to help sell products, reduce inventory of goods, or to help promote a new product line. These offers allow for discounts and special deals when the product is purchased via various selling channels that include the Point of Sale in stores and e-commerce platforms. In order to support the different offers that the Tapestry business units create, the SAP Promotion module has been configured. One type of offer includes the creation of discounts at the subclass, class, or department level which is handle via the Promotion Discount interface. Also, The interface requirement is to provide Micros POS systems Article Assortment Data and Pricing from SAP S4HANA system, Article Assortment data and Pricing is required at the Micros POS system to sell the product.• Worked in Agile methodology• Designed mappings as per the company standards, Unit testing, debug and provide the test cases for the code developed. • Designed and developed mapping using various complex transformations like XMLParser , XML generator transformations• Worked on complex XML structures with at least minimum of 25 nodes. • Used Idocs for the implementation of SAP interfaces for transferring the data through informatica . • Experience designing and developing dashboard applications with full Reporting and Analytics functionality• Used complex XML sources and targets for extracting and loading data into flat files. • Worked with the functional team modifying the XML’s, XSD structures. • Used Netezza Database for loading and extracting data. • Using transaction WESOUT in SAP Retail, An application log indicates the status of the outbound message processing• Automated workflows through Unix shell scripts using Tidal • Unix Shell scripts for triggering the jobs.• Performance tuning has been done to improve the runtime of the jobs for a better performance.

Warren, New Jersey

In this project we have developed various applications for Verizon Point of Sales where the Verizon store employees could use them for different criteria like the traffic, sales and many more metrics. Used Kronos application for scheduling. Was involved in various projects and used power center to transform the data from various data sources. As part of this project we also migrated the data from SQL server to Oracle. The data would be fed into oracle from Teradata via Informatica ETL. Various applications were used by representatives and customer to view the overages, average calls, promotions, plans information pertain to an account. The Migration project we accomplished was to move the legacy application from SQL Server stack to Verizon Standard Oracle stack. • Designs and codes from specifications, analyzes, evaluates, tests, debugs, documents, and implements moderately complex software applications• Designed and developed mapping using various transformations like XML , XML generator, Expression, Lookup, Aggregator, Router transformations• Designed and developed mapping using various transformations like Web Service, Http transformations for calling web services through Informatica . • Experience designing and developing dashboard applications with full Reporting and Analytics functionality

Kalamazoo, Michigan

In this project we mainly used Informatica to loop through the folders which searches for a file in a specific format picks it up and it process it. We generate the flat files into Informatica, It will be scheduled to retrieve a file in this expected format which would apply logic as defined in the MD-50 Functional requirements document, processing each file by uploading on the Power center. Informatica will generate output in the target ODS. After each file is processed successfully, it is archived into the /archives folder. If file is not processed successfully (because of any compatibility errors, missing columns, data types conversion errors, etc) the file will be moved to the /errors folder.

Irvine, California

The project mainly involves in designing, Developing and maintaining the data in the data warehouse and delivering the data to the various departments in the Web Team according the client requirements. The ETL process mainly involves extracting the data from Netezza, Flat files, SQL server and mainframes with the target data warehouse as Netezza and SQL Server according to the client requirements.• Subject Matter Expert for conversion and data mapping to Netezza• Used HR Data knowledge, heavily participated in data conversion to Oracle Data Warehouse • Installed and configured Informatica Power Exchange CDC and for Oracle on UNIX platform.• Designed and developed mapping using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations. • Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.• Used Mapping Variables, Mapping Parameters in the Informatica Mappings to filter the daily data from the source systems.• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes

Masters, Computer Science, A

Activities and Societies: Vice President of ISA -(2012-2013)This was an independent research under my Prof.Lillien , This is a consequence.

Bachelor'S Degree, Information Technology, A