Sangeetha

916-***-****

SangeethaJDharani @gmail.com

Professional Summary

Total 6+ years of experience in Application Software development using webMethods, Workday, Oracle 10g/11g as Workday Techno Functional Analyst, Integrations Consultant, Quality Analyst, and Business Analyst.

Experience creating Workday Integrations, EIB, Core Connectors, Document Transformations and Custom Reports.

Experience in configuring WD enhancements and changes requested by client.

Experience in creating reports, design documents and map documents for WD Implementation.

Experience in testing WD features during the Yearly upgrades and supporting new features.

Experience in handling WD support tickets of priority p0-p3 and efficiently resolving them on time.

Extensively worked on webMethods run time components namely Integration Server, Broker, and Trading Networks, Workflow and e-Standards module

Worked on various webMethods Adapters such as JDBC adapter, DB Adapter

Experience in creating and consuming Webservices using webMethods Integration Server and webMethods Designer/Developer.

Experience in Object Oriented Analysis (OOA) and Object Oriented Design (OOD) using UML and designer tools like Rational Rose, Rational Unified Process

Experience in designing UML diagrams (Class, Sequence and Collaboration diagrams using UML).

Experience in creating, validating and parsing XML documents.

SQL and PL/SQL programming experience including stored procedures, functions, triggers, indexes and exception handling. Created database objects like tables, views, sequences, indexes using Oracle tools like SQL*Plus, SQL Developer, Toad.

Strong working knowledge of Loading Data using SQL* Loader and PL/SQL.

Strong understanding and implementation of quality processes and key process areas.

Knowledge in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).

Created mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, Unconnected lookup transformations.

Have knowledge about reporting tools like Crystal Reports, IBM Cognos, Oracle Reports.

Assisted QA team in preparing unit test cases, conduct unit testing, assembly testing, system integration testing and providing support to business acceptance testing and post implementation support.

Have knowledge about fast paced AGILE environment.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Strong interpersonal and communication skills in dealing with team, client and customers.

Extensive experience in Unified Modeling Language (UML), Rational Unified Process (RUP), Waterfall model.

Participated in requirements Analysis reviews, Business reviews and working sessions to understand the requirements and system design.

Extensive experience with Rational Rose, Requisite Pro, Rational Clear Case and MS Visio.

Experience in negotiating with clients from diverse backgrounds and industries.

Exposure to Healthcare domain.

Experience in development of documents such as Functional Specification Document (FSD) Requirement Specifications (SRS), Business Rules, Business Requirement Document (BRD), and Functional Requirement Document (FRD).

Experience in Data Analysis, Data Flow Models and Data Warehousing Concepts.

Extensive experience using tools such as Rational Requisite Pro, Rational Clear Quest, MS Project, MS Visio, Rational Rose, Crystal reports.

Knowledge of HIPAA standards, Six Sigma, EDI (Electronic data interchange).

Good knowledge of Health Insurance Plans (Medicare Part A, B, C and D), managed care concepts (Medicaid and Medicare) and experienced in determining the membership eligibility, billing experience within life and disability in health plans.

Experience in writing System test plans, defining test cases, developing and maintaining test scripts.

Developed and maintained databases in SQL/PL-SQl, Oracle and MS Access.

Technical Skills

Languages & Technologies

Oracle SQL, PL/SQL, C,C++, HTML, Javascript, XML, XSLT, WSDL

Operating Systems

Unix,Windows 8/7/XP/NT/Vista

Databases

Oracle 11g/10g/9i/8i, SQL Server 2005/2008 MS Access

Integration Tools

webMethods IS/TN 7.x/8.x/9.x, webMethods Designer/Developer,Broker,MWS, Informatica Power Center 9.1/9.01/8.6.1

Reporting Tools

IBM Cognos, Crystal Reports, Visual Studio 2012, Erwin Data Modeler,

Cloud Technologies

Workday HCM, Integration EIB, Cloud Connectors, Workday Studio, Reports

Other Tools & Utilities

SQL Developer,SQL* Plus, TOAD, SQL Loader, HP Quality Center,

Education

Masters in Computer Applications

Professional Experience:

Retail Firm 06/2015 – present

Workday Techno Functional Consultant

Support cross functional areas for Compensation, Benefits, HCM, Recruitment, Time, Employment, and Payroll.

Maintaining data integrity and communicate with 3rd party vendors for business process issues.

Responsible for maintaining Central Desktop internal ticketing system, configuring and upgrading it.

Responsible for testing integrations, functional testing for each upgrade and testing file delivery between vendors.

Responsible for configuring integrations i.e. updating, business process/workflow, security, etc. as required by business requirements.

Working on Finance and Student Employment modules implementation gathering requirements and doing analysis.

Performs thorough problem analysis, including problem re-creation, resulting in resolution of product-related problem. Troubleshoots systems and integration issues by identifying root cause (e.g. data, technical, network, etc.). Oversees required fix so that problems are not repeated. Develops and automates ad-hoc reports in various systems based on user requirements to eliminate manual report writing.

Liaison between vendors and/or IT and HR end users to identify requirements and make minor changes to processes and or systems, as well as break/fix. Follow up to ensure completion.

Develops, reviews, and updates system documentation in the event of upgrades (WD 23, 24, 25) or new implementation and responsible for accuracy of the content.

Create dashboards and report templates by using Workday tools.

Leverages business data to translate situational analysis into simple and actionable tasks.

Resolving end-user issues in a Tier III workspace.

Serves as the go-to person and subject matter expert (SME) for Operations, HR reporting and data needs. Performs other duties as assigned.

Higher Ed 05/2013 – 5/2014

Role: Workday Support Analyst

Configured Outbound/Inbound Integration with different application interfaces according to the requirements. Managing Data conversions, HR and Compensation related Custom Reports, Security Management, Business Process configuration.

Consulting with clients on a variety of data integrity issues to identify/resolve all issues that could impact project scope and/or timeframe

Supported Existing Integrations and built new integrations based on the client requirements.

Managed Custom Reports, Security Management, Business Process configurations and configuring the application according to customer requirements and developing system interface.

Configured Workday system to meet each client's unique business requirements. Also developed test scripts for other outside systems that interface with Workday.

Built Cloud Connect Integration to output data from workday into external systems through EIB and Cloud connect.

Helped team in functional configuration and technical integration of the Workday application and updates

Worked on Workday conversion processes and tools like iload, EIB

Integrated Workday with external vendor software and across multiple third parties and clients.

Developed testing strategies and verification scenarios along with project Scope and Requirements documents

Health Service Provider 03/2011 – 04/2013

Role: Data and Quality Analyst

Participated in setting up testing environment.

Reviewed Business requirement Documents and functional requirements.

Involved in preparing Test Cases based on business requirements.

Authored and executed Test cases for Claims and Customer Service Workflow manually.

Creating and testing 834 transactions for 5010 and 4010 and mapped the changes according to ICD 9 and ICD 10.

Involved in preparing the Test Scenarios for Membership creation and Health Care Claim Payment/Advice.

Involved in creating the test data for testing EPS system.

Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice.

Written multiple Test Cases (System, Integration) for multiple transactions include 837I, 837P, 835, (both inbound and outbound) transactions.

Processed EDI 834 with various scenarios and validate the related tables from database using SQL query.

Conducted Black Box Testing on the application and validated the dataflow in the application.

Queried the Oracle database for Proper validation of new membership and membership renewal loads in producer portals and web portal applications.

Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.

Reviewed the Use Case Requirement, Functional Design Documents and Technical Specification documents.

Performed Functional and GUI testing on Facets.

Performed Backend Testing extensively by writing validation queries on Oracle database.

Validated member’s demographic, plan and product details against the norms of the Facet Application.

Interacted with Batch processing team to resolve the issues related to failure of batch jobs in loading 834 files into Facets.

Analyzed and tested data on memberships and claims manually and written queries on DB database for validating data.

Created and mined test data for different test scenarios required for various phases of testing like, unit testing, Regression testing, and UAT testing.

Generated PL/SQL scripts for data manipulation and validation and created tables, views, stored procedures, triggers, queries in the application using SQL Developer.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Major Financial Service Provider 01/2009 – 02/2011

Role: Business Analyst

GE Capital had its own Employee Scheduling system which would roster the employees according to the staffing requirement and the employee’s availability. Also the working hours of the employees and their login, logoff time were maintained using this system.

Responsibilities:

Played active role in Project Planning, Project Design, Gathering Requirements, Analyzing and Writing Requirements.

Create documents such as feasibility reports, Risk Assessment and support project managers in creating Cost Benefit Analysis Report, Impact Assessment.

Involvements with all key stakeholders, contributors, business, operations and technical resources that must participate in a project and ensured that contributory are motivated to complete assigned tasks.

Developed Data Flow, Work Flow, Process Flow and Entity relationship diagram, and analyzed them.

Conducted Impact Assessment, Risk Assessment by interacting with downstream team

Gathered business requirements by driving user-group meetings and working with various global, cross-functional and virtual teams.

Worked on broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools.

Recorded retention stored in Knowledge Link. Ad Hoc reporting, Admin for MS Project 2003, Excel dbase and pivot tables, Clarity and MS Project Server Admin duties.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML

Involved in all phases of software development life cycle

Used Rational Rose to model the process using UML to create behavioral and structural diagrams.

Developed detailed Developer specification to reflect technical details of the business requirements

Performed data analysis by using SQL queries.

Prepared UAT Materials UAT Test Cases to include various steps involved for UAT and to have proper coverage of requirements

Contact this candidate