SUMMARY:

• Over 20 + Years of Experience.
• Workday cloud Developer - architecture, conversion and Integration both Confidential and Financial. About 5 years of Workday integration experience.
• Data warehouse with Workday data, Oracle and Qlik frontend dashboard for Confidential appliction
• Very strong in PL/SQL and Performance tuning with Oracle.
• Expert in Oracle Applications, Architecture and Data Warehouse.
• Proven ability to work creatively and analytically in a problem-solving environment.
• Proven ability to build, manage and foster team-oriented environment.
• Strong leadership, project management and analytical ability.

TECHNICAL SKILLS:

Software: Workday integration and reporting, Workday Studio, Reports - Advance, Trending and Composite, Calculated Fields, EIB, CCB, XSLT, RaaS, SOAP, REST, Workday Confidential and Finance, Core Confidential, Payroll, Compensation, Absence and Time Management, Workday Security, Object Migrator, Connector, ADP Globalview,ADP EV5, ADP Report Writer,Project, Oracle Financial Application R11i and R12, Oracle9i,10g,11g R2 PL/SQL, Stored Procedures, Functions, Triggers, packages, TOAD, Quest, Brio Query, Web Portal, Reports 6i/10g, Forms 4.5/6i/9i/10g,10gDS,Java, J2EE, JavaScript, HTML, UNIX, Shell Scripting, sed, awk, XML,XSLT,WSDL, XML-Spy, BPEL, Brio Query, JDBC, Oracle JDeveloper, Data Warehouse, OLAP, Analytical functions, OBIEE, ETL, OAS, web services, SOAP, Tomcat, JSP, SQL* Loader, External Tables, Materialized Views, Discoverer, SQL*PLUS, Dynamic SQL, GL, PO,AP, AR, Confidential and PA,AOL, UTL FILE, ERWIN,PL/SQL Developer, Workflow, TKPROF, Android Development, Eclipse, cron, BMC, Autosys, SDLC, Purchase Order, RICE, CEMLI, SLA, FAH, P2P(Procure to Payment Cycle), Confidential, Google App Engine, Data store, AppScript, Perl, UNIX Shell,C, C++, Python, Force.com, Ant, Spring, Maven, QLIK, Confidential ; Cassandra,MongoDB; NodeJs

EXPERIENCE:

Confidential, Farmington, CT

Lead Workday Integration Consultant

Responsibilities:

• Designed, developed and implemented Workday Studio integrations and EIBs to feed Oracle Data Warehouse with Workday data to facilitate Global Confidential application with Qlik front-end. Gathered requirements, designed, developed and documented over 20 integrations using Workday reports, EIBs and Workday Studio.
• Converted EIBs to studio integration to overcome Workday EIB limitations
• Updated effective dated custom objects using Workday Studio inbound integration.
• Developed incremental integration using Workday studio without Workday delivered change detection.
• Created ISSG, ISU with all necessary domains, tested and migrated the objects using Object Migrator.
• Developed integration using Worker, Location and Compensation Workday connector, Workday to ADP Globaview connector using PICOF
• Involved in the Workday integration to ADP EV5 for US
• Optimized report and integration to improve the performance
• Worked with stakeholders to update and present status and brainstorm solutions
• Participated in Data Profiling, Data validation, SIT testing and End-to-End testing
• Coordinated projects with Oracle DBA and QLIK team
• Worked with implementation partners and Production support on tenant refresh communications; End to end testing
• Worked with Workday security lead to define roles for Integration Administrator
• Educating /Mentoring Confidential team members about Workday features
• Optimizing security roles for Developers and testers
• Acting as technical SME for Confidential

Confidential, Malvern, PA

Lead Consultant

Responsibilities:

• Responsible for gathering requirements, developing complex reports, configuring bonus and compensation plans. Developed over 500 calculated fields to implement very complex proprietary business logic for compensation. The scope for the reports is compensation, Absence and Time Management, Payroll and Core Confidential . The reports are customized using BIRT in Workday studio.
• Developed sophisticatedWorkday integration to facilitate the review of the payment calculation and amount and finally upload the result to Workday tenant using Workday web service.
• Working with the stakeholders and business leaders to manage system testing and implementation.
• Developed Salary, Bonus and Total Rewards reports, Enabled as web service for studio Integration.
• Developed Studio Integration for interfacing Workday Data to Salesforce Case ceation system.

Confidential, Providence, RI

Lead Developer/Analyst

Responsibilities:

• Responsible for conversion of Workday Confidential and Financial implementation process.
• Designed and developed several Workday web enabled custom reports and used them as web services for developing integration.
• Worked with cloud integration with external vendors for 401 K and Health plans.
• Lead role for designing and developing the ETL interface of Workday Confidential data to Oracle Identity Management.
• Designed and developed Workday reports for supervisory organizations with hierarchy for feed to Grouper.
• Designed and developed XML ETL files from Confidential database to integrate into Workday, using XML and XSLT and web service.
• Responsible for maintenance of Workday Confidential and Financial applications which requires solid knowledge of Saas, SOAP/REST web service, XML,XSLT,XPATH,XQUERY and Java.
• Developed critical fixes for feed to Benefit Strategies, Punch-out vendors and Tax-Treaty. This involved both studio and cloud integrations.
• Designed and developed Oracle procedures for implementing Workday grants and Position Costing allocations for loading into Workday Cloud environment.
• Designed and developed the ETL feed to multiple vendors for BAT keys using Oracle package.
• Lead the design of Asset conversion project and successfully implemented the data conversion into Workday.
• Designed and implemented costing allocation and position org assignment, a critical component of Workday Finance module.
• Designed, developed and implemented the Labor Distribution process with feed from Workday cloud environment. The process was developed as package in Oracle 11g environment packed with Oracle analytics, the output fed into Oracle Data Warehouse. The processing time was improved from couple of hours to less than five minutes.
• Designed and developed Java ETL program to convert the library invoice data for feed to Workday.
• Used Java Profiler (JVM) to tune the performance of the Java program for the Confidential front end.
• Suggested replacement of Java server from OAS to Tomcat for Confidential .

Confidential, Hartford, CT

Technical Lead and Supervisor

Responsibilities:

• Strong hands on experience in Oracle financial applications.
• Plan the Project, lead the technical design and lead a group of four developers in the development of W2-1099 modules which involves loading the Vendor data into staging tables, validating the data and developing Oracle forms 9i/10g to make the data available to auditors. The project was implemented in record time and below budget.
• Responsible for coordinating the status of the project with management.
• The implementation involved auditing the users that used the application.
• Met with the Director of IT security on the design of the auditing process and implemented the solution.
• Lead a group of three developers in the development of Amnesty application to support the Amnesty 2009 process.
• The process involves design of database tables, coordinating with the project office and the Database support Unit. The project involves development of application with Oracle forms 9i/10g.
• The application supported multiple users. The implementation involved auditing the users that used the application.
• Supervised the developers with the maintenance of Returns Processing modules. The annual project involves implementing the form changes with the new legislation, rollover of the forms and various rate changes.
• Lead an initiative to streamline the process so that the program approved forms are timely submitted, so that the SIR(work order) can be written and the development can be started sooner and deadline can be met. Simplified the process so that development, testing and implementation is smooth.
• Advised the SMEs and oversight office on providing the approved forms and on the SIR creation process.
• Implemented the conversion of existing Oracle 9i forms to 11g database with Developer Suite 10g. Lead the project to implement a new tax type across all the modules in the application.
• Learning to develop Android/iPhone application using Eclipse and Java.
• Trained in R12 Oracle Apps functional GL, AP, PA module with hands on laboratory assignment including complete set up for GL, AP and AR and SLA and FAH.
• Created entities, ledger, COA, Value sets, ledger entries, PO, Expense report, supplier, banks.
• Performed GL setup, AP setup and AR setup, Forms Customization.

Confidential, New Haven, CT

Senior Developer

Responsibilities:

• Managed an Oracle Financials Project supervising and mentoring three developers and three functional people.
• The project involved modules from Confidential /AP/PO/GL/PA. The project was successfully implemented in record time under budget.
• The project involved extensive use of PL/SQL packages and stored procedures.
• The forms were customized using custom.pll and zoom feature.
• As part of the Chart of accounts (COA) conversion, was responsible for upgrading entire RIF application. The COA was modified from PSOO to PTAEO (Project Task Award expense org). The testing was coordinated with the functional lead.
• Was responsible for setting up the security of the users of the FMT Budgeting System. Used Windows Active Directory to control the user permission.
• Responsible for installation and upgrade of the server software on the server. Lead meeting with the Functional users and Data Warehouse group for projects to gather specifications and translate them to the technical specification.
• Used PL/SQL packages to write the ETL packages and used DBMS JOB/Unix Cron scripts to schedule the jobs.
• Responsible for development and maintenance of Survey based web application (ESS). The project used oracle forms, reports, and extensive PL/SQL packages, stored procedures and triggers. The user interface was web based developed using mod pl sql.
• Responsible for the development and enhancement of Oracle Financial Application, FMT Budgeting System, Student Scheduling, Accounts Receivables and YNH Billing applications.
• These applications were developed using Oracle 9i and upgraded to 10g.
• Used Oracle Forms, reports, packages, triggers and procedures and PL/SQL web services as part of these applications.
• Worked with Oracle Financial Application GL module. Member of team developing custom application and integrated with Oracle application.
• Have customized several application module forms and helped in the functional testing and implementation.
• Have developed Web services using JDeveloper and consumed web services from financial application.
• Used SQL*Loader and External tables for loading of the files to Oracle database.
• Developed Reports and registered them as concurrent programs.
• Responsible for design, development and maintenance of RIF application.
• This application was developed in Forms 6i as a custom Oracle application and was integrated with Oracle Financial Application.
• Developed Java module to integrate a 3rd party treasury application with the Oracle GL module.
• Wrote PL/SQL packages for creating value sets
• As a system administrator, created and assigned responsibilities to the GL users developed sweep programs to move Accounts Payable(AP) Data to the Journal staging area and finally post it to the General Ledger(GL).
• Used Oracle Self-service framework to develop application for commitments.

Confidential, Hartford, CT

System Analyst

Responsibilities:

• Developed complex forms, UNIX shell scripts, SQL*Loader and PL/SQL for
• Marketing and Executive Information System.
• Involved in Reengineering of the Policy Issuance System. Performed Data Modeling using ERwin and developed Table maintenance of forms.
• Performed Analysis, Design and Development of the Premium Based Processing
• System for Reimbursement of Loss as Premium.
• Development was done on UNIX, PL/SQL, Pro*Cobol and Forms 4.5