SUMMARY:

• A result oriented Information Technology Professional with 15+ years of successful Functional and Technical experience as a Consultant (Integration ETL lead, Business Analyst, Test Architect& Workday Techno - Functional Consultant) in industry verticals like Capital Markets, Retail Banking, Healthcare, Pharmaceuticals, Retail sector and Logistics.
• Expertise includes working as a Product implementation support consultant at various customer locations for various vendor products Workday, Business Intelligence and Enterprise Data Warehouse Implementations.
• 3+ years of experience as a Workday Integration Consultant on designing, building and testing Workday Integrations.
• Expertise with Custom Reports, Calculated Fields, EIB’s, Core Connector, PICOF, Packaged Connector(Named integration), Document transformation, Report Design and Workday Studio.
• Extensive Technical and Functional experience in testing Business Intelligence (BI), Decision Support
• Systems (DSS) and Data Warehousing applications
• Exposure to Water Fall (V model), Agile and Iterative methodologies.
• Contributed in Functional spec/Design review meetings to ensure testability of the feature/functionality.
• Knowledge in creating Project plan, Test Plan, Scheduling test cycles and meeting Deliverables.
• Involved in the full Project Life Cycle of variousVendor Products, Data warehousing & Business Intelligence Projects.
• Experienced working in a distributed engineering environment (working and leading a team) Leading capabilities to motivate and energize the team.
• Expertise in EIB Inbound/Outbound integration, Workday Core Connectors, Workday Report Writer and Calculated Fields.
• Designed and developed over 50 integrations ranging from report based custom EIB's to Connectors and Document Transformations in the areas of Workday HCM, Benefits, Payroll including, but not limited to, EDI 834 files, active directory files and total rewards files.
• Good understanding on Workday modules like Core HCM, Benefits, Compensation, Staffing, Payroll interface, Security Groups,and Absence Management.
• Creating Mapping as per the Design, Built and set up inbound and outbound integration using Core Connector, Cloud Connect Third Party Payroll and EIB for both regular workers and contingent workers for pushing and pulling data from workday to various external systems.
• Experience in conducting discovery sessions for workday integration.
• Good understanding of integration includingworkday Architecture and Business Process Framework.
• Hands on experience with various technologies like SOAP, WSDL, XML and XSLT used in building integrations.
• Performed transformation of XML into XSLT for presenting data required for integration Services.
• Design/Architect Workday integrations using Studio, Report Writer, SaaS, EIB, XSLT and Core Connectors.
• Experience in all phases of the Workday integration implementation lifecycle namely - Requirements gathering, Analysis, Design, Development and Testing.
• Developed SQL scripts for Data validation in Various Data Layers (Staging, ODS, Data Mart & BI reports).
• Experienced includes the testing of Client/Server and WEB based applications. Hands on Experience inQA iterations for implementing Oracle CRM on demand and Oracle PeopleSoft products.
• Expertise in ETL (Extraction, Transformation and Loading) testing implemented using different ETL tools (Datastage, Informatica, Ab-Initio and SSIS).
• Experienced in gathering requirements from the end users and working with the technical team to ensure accuracy of the requirements.
• Good understanding of business process especially in the Capital Markets/Investment Banking, Retail and Logistics domains.
• Exposure to Web services, Involved in Load and Functional testing using SOAP UI, involved in executing automated SOAP and POST API tests.
• Prioritized Features and the creation of Iterated Release Plan to deliver Time Boxed, Customer focused functionality while managing risk.
• Arranged the Defect review meetings involving Business team, Development and Release management.

TECHNICAL SKILLS:

Vendor Applications: Workday, Oracle PeopleSoft, Front Arena, IBM MDM, Oracle MDM, Oracle EBS

Reporting/BI Tools: Cognos, Hyperion, Workday Report Designer/BIRT

Testing Tools: HP ALM, Quick Test Pro, Selenium

Operating Systems: Windows NT 4.0, Windows 2000 Server, Unix (Solaris), and Linux 7.1

RDBMS: Oracle 7.x/8.x, MS SQL Server 6.0/7.0, Netezza, DB2 and Teradata

Web Programming: ASP, HTML, DHTML, VBScript, JavaScript, Java, REST,SOAP

XML Editors: XML Spy, Oxygen

PROFESSIONAL EXPERIENCE:

Confidential, New Haven, CT

Workday Analyst (Reporting, Integration and UAT & QA support)

Responsibilities:

• Participated in the discovery sessions with client and vendors.
• Developed several reports (Simple, Advanced and Matrix reports).
• Portfolio Summary (Fund & Budget balance reports)
• Portfolio Commitment reports
• Portfolio payee trend for Gifts, Grants & Yale designated reports.
• Portfolio detailed transaction reports
• Created Reports Groups for different Portfolio packages.
• Created custom reports using Workday Report Designer (BIRT) using features like rich text formatting, headers and footers, page breaks, and exact placement of labels, data, spaces, margins and formatting the report design using various properties, expressions, report items and data sets.
• Developed several Outbound and Inbound integrations types (EIB, Core connector, Hybrid, Web Service & Studio) as part of workday financials implementations (Accounts Payable, Account Receivables, General Ledger, COA, Purchase orders) implementation at Yale:
• Supplier address
• Country of Activity
• Grant Award lines
• Donor contribution
• Per Diem files
• Master supplier list
• Currency rates
• Yale Patient refund
• Financial transactions reconciliation
• Sciquest vendor supplier interface
• P2P Lookups
• Journal Entry imports
• AP invoice & Image imports
• Payment confirmations
• Active Directory integration
• Supporting Year end payroll processing
• WD to Kronos (time keeping) feed
• Performance enhancement of existing workday reports with support from Workday resources
• Identified the reason for lag/slowness in reports by collaboration with Workday on Test tenants.
• Performance tuned the reports by collaborating with Workday (reducing prompts, breaking reports into parts i.e. multiple reports, deleting repeated prompts).
• Test the system Threshold before it kicks into Single thread mode, Instance of reports queuing for long before they are processed.
• Tested several integrations and supporting Workday system pre-and post-live implementation
• Modifying existing integrations to pick the full population.
• Created new integration to pull the new hires information using Core Connector Worker and Document Transformation.
• Moved integrations from Development to sandbox, sandbox to Production using Workday solution.
• Used delivered ETV/XTT functions from a Custom XSLT file to transform the content into a CSV file format.
• UAT and SIT testing support on bulk hire via EIB’s (Developed Inbound EIB for Hire process).
• Training cross functional teams on creating data in Workday.
• Developed Java/Selenium scripts to alert the Prod Support team on Workday Maintenance window, Single Sign-on down & alerting the workday System health status dashboard.

Environment: Workday versions 26-30, HCM Business, Benefits (Aetna, CIGNA, EyeMed) Finance, EIB, Custom Reports, Document Transformation, Workday Web Services, Oxygen, Workday Studio, XML, XSLT, XPath, Cloud Connectors, BIRT, Workday Studio, Agile SDLC.

Confidential, Plano, TX

Integration Consultant

Responsibilities:

• Participated in the discovery sessions with client and vendors, helped identify clientneeds, and worked towards proposing a phased approach to the project, working with a team of multi-discipline experts for integration
• Helped develop a detailed work breakdown structure of the tasks and involved in detailed planning of the timelines and milestones
• Hands-on involvement with Analysis, Setup and Configuration of Workday HCM, working closely with implementation partners
• Facilitated integration design sessions and configuration decisions based on best practices and an understanding the customer’s unique requirements for all stages of the project
• Developedintegrationsusing web service SOAP, WSDL, XML, XSLT, XPATH on theWorkdaycloud platform such as Payrollintegration, ADP inbound/outbound and Active Directory inbound
• Worked closely with SMEs and Solutions Architects to discover and formulate the scope of requirements for integration and Reports
• Designed and developed custom ACH integration using Workday Studio to send the payment data of employees from Workday to Chase bank in NACHA format
• Designed and developed Payroll integrations for ADP Periodic/Monthly and Annual tax files
• Designed and developed ADP integrations for reporting the historical data of withholding orders from Workday
• Designed and developed integration with different banks to bring in corporate card holders, transactions and outbound remittance for account settlements
• Designed and developed Benefit integrations for BCBS, Aetna, Zenefits andAon Hewitt
• Created 50+ Simple and Advance reports in Payroll, Benefits, Staffing and Compensation
• Worked closely with implementation partners in helping build and deliver many Workday integration leveraging iLoad, Outbound/ Inbound EIB's and the Cloud Connect platform
• Responsible for developing the reporting strategy for the HCM domain. Advised the business users on the use of leveraging the Workday standard delivered reports
• Created several complex custom reports, using Workday reporting functionality and calculated fields on all modules, including Compensation, Benefits, Core HR, and Payroll
• Developed Integrations to convert the .xml end result of PICOF (Payroll Integration Configuration) to the desired output format
• Developed/tested user defined Workday EIB's to enable processing of large-volume transactions
• Assisted in development of new reports for ongoing customer needs and conversion of PeopleSoft reports to Workday reports during migration
• Setup Email notifications as part of Business Process configurations
• Supported the organization in Maintaining and modifying existing Workday integration by building custom EIB's and CCB integration as needed
• Worked directly with users to research, troubleshoot, and resolve integration issues in a timely manner
• Collaborated with Development, QA and other Technical Analysts to research identify and validate issue resolutions

Environment: Workday 25& 26, PeopleSoft9.1,XML, XSLT, WSDL, SOAP, XML editors (Oxygen, XML Spy) Web Services, EIB, Workday Studio, HCM Business Process, Payroll, Benefits, HR management, Compensation, Workday Reports, Calculated fields.

Confidential, Plano, TX

Integration Consultant

Responsibilities:

• Analyzed client's Core HCM business needs through client discovery sessions
• Initiated discovery sessions with client and HCM functional consultants, created the design and mapping documents
• Day to day support ofWorkdayHCM and reporting issues
• Convert and map data elements from/to Workday data sources
• Created newintegrationto pull the new hires information using Core Connector Worker and Document Transformation that uses connectorintegrationsXML Output as its data source input
• Designed and developed a custom new hire inbound integration from Kenexa system into workday
• Designed and developed an outbound integration to send existing, new and changed job requisitions to external vendor applicant tracking systems
• Designed and developed a set ofintegrationsto integrateWorkdayHR with recruiting system
• Created and used various Calculated Fields Function types(Ex: Evaluate Expression, Extract Multi-Instance, Extract Single Instance, various Lookup functions) in Reports, business processes and integrations
• Created Simple and Advance reports in HCM, developed and maintain complex reports
• Migrate integrations between tenants via iLoad
• Designed and built both inbound and outbound Enterprise Interface Builders (EIB) for pushing and pulling data from the legacy PeopleSoft and Oracle EBS systems
• Tested theintegrationson all theWorkdaytenant prototypes. PerformedIntegrationtesting of in scope inbound and outbound (30+integrations)
• Responsible for design, development and execution of End-to-End ofintegrationstesting
• Knowledge of Domain, Role and User based security for different functional areas
• Supported Users in data preparation (using iLoad) and testing during testing phase

Environment: Workday 25, XML, XSLT, WSDL, XML editors (Oxygen, XML Spy),SOAP, Web Services, iLoad, EIB, Core HCM business process, Workday Reports, Calculated fields, BIRT, PeopleSoft and Oracle EBS.

Confidential, Chicago, IL

Integration BA/UAT Lead

Responsibilities:

• Participated in discovery sessions from the super users to understand the core business processes/customizations of PeopleSoft 9.1 HRO System.
• Delivered the master test strategy/plans for Workday HRO Project.
• Delivered the test strategy/plans for System testing and Integration testing.
• Designed & Reviewed the Test scenarios and Test Scripts as per business requirements and customizations.
• Planning the testing resources to each testing cycle and guided them to understand the business process to help in Test Case Design, Test Execution and Defect tracking.
• Developed and maintain the traceability matrix to have complete test coverage for all the business requirements.
• Involved in test execution of major business processes like Recruiting, Onboarding, Position Management, and Hiring process, Compensation, Absence & Leaves in Workday for both Publishing and Media companies.
• Involved in Integration test execution between Workday and other systems like Recruiting, EVerify, Kronos, Benefits and Payroll integrations with vendors.
• Responsible for complete Payroll testing and involved in test execution of Payroll System testing, Payroll integrations and Payroll Parallel testing phases.
• Executed all the inbound and outbound Packaged and EIB integrations and validated the data on the outbound files to the vendors.
• Extensively worked and coordinated all integrations for Media side and communicated with 3rd party vendors to complete the integrations testing.
• Validated Workday outbound data files to feed the data in to other applications.
• Validated inbound and outbound files (CCM Integrations) processed through ETL process to feed the data to downstream applications.
• Prepared daily status reports, weekly status reports, test summary reports, defect tracker reports and communicated to Project manager.
• Used HP ALM for Test Management.
• Generating the different kinds of reports from ALM like number of defects assigned to development team, opened, closed, Re-tests differed, priority etc. and communicating to the project manager.

Environment: PeopleSoft 9.1 and Workday 24, HR, HP ALM, Oracle 11g, SQL Developer.

Confidential, Marlborough, MA

Project Lead (ETL Dev& QA)

Responsibilities:

• Produced Testing Status reports and representing QA team in the Project Status Meetings.Generated defect reports and defect metrics to be sent to the stake holders.
• Developed SQL scripts for Data validation in Various Data Layers (Staging, ODS & Data Mart).
• Delivered Functional testing inputs of the AMS reports developed using Cognos BI tool.
• Achieved Proof of Concept on 3rd party vendor Data Warehouse Test automation tools like iCEDQ, Query, integration testing between different modules in a Data warehouse and Source feeds/interfaces.
• Analyzed Merchandise Source Systems like POS (Point of Sale), Buying, MDM Oracle SiteHub and MDM. Examined and challenged the Source to Target Mappings and Design documents and recommending changes.
• Cooperated with EDW Cross Functional teams and involved in implementing on Process Improvement.
• Actively managed team of testers (Offshore and Onsite) by providing guidance on Test Scenarios, Test cases, Test. Suggesting and helping in Automating of Data compare SQL tests using UNIX scripts. Monitored QA team on Developing SQL queries for data validations that have Complex Join conditions (Left Outer joins, Inner Joins). Prioritized the test cases, Created and managed the defects in ALM Quality Center and track them till closure.
• Collaborated with EDW Cross Functional teams and involved in implementing on Process Improvement. Initiatives and identifying top 5 improvement opportunities
• Source Data Governance.
• EDW Functional/Business requirements.
• Handling of Batch Cycle Errors & Defining Performance Parameters.
• EQA Testing Strategy- Focus on Integration between EDW Subject areas.
• Issues on Applying direct SQL patches instead of Standard supportable ETL jobs.
• Worked with BA’s for requirements gathering, business analysis and designing of Enterprise wide DataMart’s.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business logic and captured the deleted records from the source systems.
• Implemented initial and incremental data loads based on SCDs Type1 and Type2.
• Worked closely with the EDW project team members and stakeholders for EDW Stabilization.
• Involved in Source data analysis and cleansing to improve the quality of TJX data sourced for EDW.
• Worked on Change Data Capture process to replicate transactional data from IBM DB2 database to EDW Netezza database.
• Involved in Datastage version upgrade activities for export and import of all the ETL jobs, setting up the environmental variables, testing jobs, modifying the scheduled batch jobs.

Confidential, RTP, NC

Integration Analyst

Responsibilities:

• Developed new Message Flows, ESQL Statements, Message sets, Pub/Sub applications and flows using custom XSD/XSLT transformations to transform into XML.
• Implemented Web services message flow using SOAP nodes in IBM Integration Bus.
• Developed message flows for content based routing of messages.
• Processed XML messages with exceptions and performed Message transformations, translation, validation for incoming messages, XML File lookups, database inserts, https posts and java calls to backend systems.
• Troubleshooting and debugging routing and data conversion issues. Actively Involved Business in decision-making process ensuring quality Deliverables.
• Developed test cases for Common flows and tested those test cases in UT (Unit Testing), ST (System Testing) and IT (Integration Testing).
• Successfully build Integration and system test plans. Supported UAT which has business users testing the app for the Inbound. Wrote test steps in detail for the business users to facilitate their testing.
• Led the batch testing activities for QA Team, getting in sync with the release team on Control M scheduling activities, verify the Data loads that are scheduled as per the hierarchy and dependency of the Objects.
• Formulated Traceability matrix between functional requirements and test cases to ensure proper coverage. Used SOAP UI to generate Request XML messages to be sent (WSDL) to OOD Interface for Web UI testing.
• Developed Informatica Mappings for QA from scratch based off the Mapping Documents for certain key scenarios.
• Developed SQL Scripts to compare Data Loads between Source and Target data bases. Created test data for ETL jobs using Oracle CRM frontend.

Environment: Oracle CRM EBS,IBM Integration Bus 9.0.0.1, IBM MQSeries 7.5, ESQL, Oracle 10g, RFH Util, SOAP UI 5.0.0, Tortoise SVN Repository.

Confidential, Burlington, NC

Lead Business Analyst-ERP

Responsibilities:

• Reviewed and hands on the existing business scenarios, customizations in 8.8 QA environments.
• Attended for all Fit Gap analysis (keep/drop) meetings with users to go through the changes with respect to 8.8 and 9.1 and document the agreed changes.
• Reviewed all existing 8.8 test scenario's /cases, prepared final Business Requirements and Test scenario's/customizations list to test for 9.1version.
• Delivered the test plans for each individual module.
• Designed the Test scripts for new changes in 9.1 and some cases we have modified or used directly 8.8 scenarios.
• Involved in testing the scenarios and customizations of Vendor management, Item management, Requisitioning, Creation of purchase order, Dispatch to Vendors, PO acknowledgement Receipt of goods, Return to vendors and services functionalities in PO.
• Involved in testing the scenarios and customizations of Invoice Stabilization processes, Managing Vouchers (Voucher Entry and Approval) Voucher Build, Matching and Post, Tax Processing, Withholding and Interface subsystems functionalities in AP.
• Involved in testing the scenarios and customizations of Creating Journals, Journal Editing, Approval workflow, posting process, Allocations, Interfaces and end to end transactions (journal entries) from other modules to GL.

Environment: PeopleSoft 9.1, PO, AP, GL, Inventory, Projects, Cash Management, Assets, People Tools 8.51, Oracle 11g, HP Quality Center 10,Rational Clear Quest.

Confidential, Boston, MA

Sr. Business Analyst

Responsibilities:

• Created& documented test data (loans, borrows and securities) in the DML, SMAC and GSMAC mainframe applications. Performed various functions like settling, cancelation, approving of different stocks in DML, SMAC and GSMAC mainframe applications for regression testing.
• Successfully run UNIX scripts to copy and move data files across directories.Developed a process to compare data in source CSV files with data in oracle tables.
• Reconstructed Portfolio Positions for regression testing due to Basel II Credit and Risk changes.Supported the new client boarding process in PREPROD and PROD which was done manually using SQL Insert and Update Scripts.
• Conducted Integration testing of the Global One system with different upstream and downstream applications.

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Demonstrated Functional & Technical knowledge to the Program Technical managers team in a “UAT Smack Down” presentation.
• Determined whether test failures, if they were due to environmental issues or functional issues. Kept track of “real” failures and ensure they are accounted for on the development schedule (assigned back to a programmer or in the SWAT team queue).
• Accountable for overall testing of the Front Arena application during monthly releases and enhancements. Closely working with Front Office (Portfolio managers, Traders) and Middle office (Operations) teams by troubleshooting the issues encountered by them while using the Front Arena.
• Actively involved in Excel Based regressions testing that were maintained in spreadsheets involving high profile OTC trades. (Portfolio Swaps).
• Tested new CR’s and New Functionality: Implementing Inflation Swaps. Implemented 130/30 Strategy.
• Interacted with operations and business users during user acceptance testing and facilitating the IT/technical support required during UAT. Created release notes for the monthly production releases.
• Defined regression test coverage, executing the regression tests and keep the QA environment running.

Confidential, Framingham, MA

Business Systems Analyst

Responsibilities:

• Produced industry standard test documentation (Test Plan, Test Build report and Test cases) for all the components involved in System/Functional testing and Integration testing.
• Ensured the LOS DW infrastructure and software launched into production is tested to the degree to which the sponsor/customer is willing to accept risk.
• Directed periodic status meeting to ensure quality and testing effort.Led a DRB (Defect Review Board) to review defects and assign the priority.
• Aggressively involved in validating the data from OLAP source system on regular basis by loading to Teradata which involved executing the Ab-initio graphs, checking error log files and reporting the cause of rejected records.
• Accountable for the effective development and implementation of testing processes to ensure that all information systems products and services meet minimum organization standards and end-user requirements.

Confidential, Scottsdale, AZ

Integration Business Analyst

Responsibilities:

• Formed industry standard documentation (Use cases, Test Plan, Test Build report and Test cases) for all the Components involved in Functional& Integration testing for DHL Proview Application. Identified and reported on key QA testing metrics to track progress and accuracy of testing efforts.
• Well-defined the defect tracking processes to ensure defects are logged in a clear way and are escalated to the concerned team for optimum defect turnaround time. Competently finished Database Migration testing (Oracle9i to Oracle10G).
• Documented the mapping requirements between DHL ship and other interfacing applications.
• Involved in reverse engineering and documenting interfacing requirements of Legacy DHL applications.
• Positively managed Test Director (MQC) to enter the test cases, created test sets and maintained the defect reports also handled the complete schedule of UAT with business users.
• Delivered test plan and test cases based on the business and system specifications. Organized traceability matrix for test cases by mapping them to business and system requirements. Success fully worked with the users in the UAT.
• Tested the Decryption and File validations from Source Host Mainframe systems. Web (GUI) testing to ensure the accuracy of the Tracking information. Simulate all the checkpoints that would happen for a DHL shipment and verify the same on the DHL Ship (GUI).

Environment: Oracle 9i & 10G, Informix, DB2, Mercury Test Director, Java, UNIX.