Vishali Senivarapu

Primarily worked as the Technical Lead for the Data Migration Team, supporting data conversion activities to migrate the enterprise HR platform from Oracle EBS to Oracle HCM. Also, I provided technical support and data mapping support to the DCHRMS Warehouse team.

Worked as the Process Improvement Lead for the Interfaces team, where I provided feedback on process gaps, streamlined the process, developed processes, and planned sprints to make them efficient and help the team function better to meet their sprint deliverables.

Major Responsibilities:

• Facilitated/participated in daily internal scrum, integrated scrum meetings, Scrum of Scrums, Tech Matrix, and other related meetings to represent the Data Conversion Team to update on team activities, risks, and actions taken to mitigate any risk.
• Transitioned to Scrum lead, along with technical lead responsibilities, while backfilling a Scrum lead position.
• Lead the team members to the successful completion of Sprint goals, and meet program deliverables.
• Consistently coordinated with the team about the upcoming work, scheduled activities, and any changes to the schedule to ensure we are meeting the commitments in a timely manner.
• Consistently provided support and feedback to the team members to make sure they are meeting their commitments.
• Worked actively with team members on removing any impediments, and addressed the issues brought to my attention.
• Coordinated with the other teams to ensure that cross-team impacts are addressed in a timely and mutually agreeable manner.
• Coordinated with the Integration team and the RM team on data load schedules and planning to support program deliverables, like mock data loads, SIT data loads, IOC planning, etc.
• Coordinated with other teams, such as HR Configuration, Interfaces, reports, the testing team, and BAs, to address any questions and provide the required information related to mapping or data rules.
• Worked in a timely and mutually agreeable manner to address issues or find a path forward.
• Presented to the government customer on data load-out briefs, data reports, performance improvements, and risks and mitigation plans.
• Provided technical and process improvement guidance to the team.
• Led the team in cross-training on responsibilities and ensuring that the processes are in place to perform smooth data migrations and post-analysis.

• Worked primarily as a software developer for supporting the data conversion from DCPDS to DCHRMS.
• Participated in daily internal scrum meetings and integrated scrum meetings.
• Created ETL procedures for converting data from DCPDS to DCHRMS.
• Provide the HCM Data Loader template for multiple assignment loads and salary element loads.
• Create ad-hoc BI Publisher reports to support data conversion activities.

Project: imagineOne

ERP and HCM Oracle Cloud Implementation.

Role: HCM Technical Lead

Responsibilities:

• Reviewed the current state of BPM changes and provided guidance, solutions on downstream impacts, and action plans to address the issues.
• Lead the HR, benefits, and payroll data conversion efforts. Worked with consultants and the Rice IT team in creating and implementing the process.
• Lead the activities of data analysis, cleaning, transformations, and validation activities with HR, Benefits, and Payroll functional SMEs.
• Reviewed the current state of HR, Benefits, and Payroll integrations, created an inventory, and worked with the Integration team on planning process design, requirements gathering, and implementation process.
• Facilitated the kickoff, requirements, and design sessions with vendors, camps departments, for HR, benefits, and payroll business integration.
• Lead the technical requirements and validation activities for HR, benefits, and payroll functional SMEs and consultants.
• Provided business process change and reporting change requirements to the Data Analytics team.

ES Banner Projects:

Role: Sr. Systems Analyst

I worked as the primary contact for HR IT support and worked on integration, reporting, and data management projects. Below are some of the major project involvements:

• Lead HR/PR vendor integration projects, activities involved in analyzing requirements documents, working with vendors on technical requirements, creating integrations, and working with the Rice IT team on automating the integration. Some of the recent projects include EMS systems, COIR Ospary, RecCenter, Rice Works, etc.
• Lead the employee implementation of SSO to Esther. Workers with the HR office, Help Desk, and internal OIT teams on project planning and application enhancements are needed.
• Lead the HR data migration warehouse project and created datasets for VPAA, OIR, IPEDS reporting, and faculty datasets reporting.
• Provided data analysis, action plan, data analysis, and data updates for position restructuring for the HR team.
• Lead the HR, PR, and Finance Report redesign as part of the Banner 9 upgrade, and migrate the Banner baseline reports to Edgar/Argos.
• Worked on Banner Security enhancements as part of the Banner 9 upgrade. Leads Edgar's custom security process and made process improvements and enhancements as per changing security requirements.
• Created Edgar apps and reports for faculty information data, and other HR/PR applications to fill the Banner gaps.
• I analyzed the Banner IAM process and enhanced it for better performance and log tracking. Works with IAM on the Faculty/Staff IT access process.
• Analyzed Banner Fixed Assets custom process, and provided enhancements and reports for automation and efficient processing.

Client: US Environmental Protection Agency May’ 09 – April 2013

• Emissions Collection and Monitoring Plan System (ECMPS). U.S. EPA, CAMD (2009-2013). Oracle database developer for the development and deployment of ECMPS quarterly release, a critical component of the information system supporting the EPA's air emissions trading programs. ECMPS facilitates the submission, management, and use of hourly emissions data, monitoring plan information, and quality assurance test data for these programs. The technical architecture for ECMPS includes an Oracle 11g database at the EPA, an MS SQL Server database for the industry submission tool, web services utilizing XML schemas, and a .NET middleware server.
• Data and Maps Website Design and Development. U.S. EPA, CAMD (2009-2013). Database developer for the development and deployment of the Data and Maps website. The site incorporates substantial warehousing technologies to allow users real-time access to significant volumes of inventory, emissions, allowances, and compliance data.
• Source Management System (SMS) and CAMD Business System (CBS) Support. U.S. EPA, CAMD (2009-Present). Provides database support for the SMS and CBS development teams. SMS is a web-based application that is the core system for CAMD's reengineering efforts. It contains facility inventory, unit characteristic data, program applicability information, agency assignments, industry contacts, industry representatives, and owner and operator data. SMS is written in ColdFusion and uses an Oracle relational database.
• CAMD System Administrator (CSA). U.S. EPA, CAMD (2009-Present). Database developer for CSA, a software application used primarily by system administrators of SMS, CBS, Data and Maps, and other CAMD applications, such as ECMPS. CSA contains functionality that is too data-intensive for a web interface, or that is necessary to limit to a small group of users. CSA functions include report generation, database maintenance and synchronization, and the generation of emails to groups of relevant industry and agency personnel.

Responsibilities:

• Created database design and technical documentation for database objects and workflow for reengineering or implementing additional modules to ECMPS, SMS, CBS, CSA, and Data & MAPS applications.
• Performed weekly Oracle database migrations from development databases to the staging database during the development cycle.
• Created developers guideline document for database development and configuration management.
• Supported NCC/CAMD APPS database queue in Request Tracker for production support tickets.
• Analyze application-related production issues, create scripts for immediate fixes, and suggest possible application modifications for long-term fixes.
• Implemented autonomous transaction for application process logging.
• Used Oracle Migration Workbench to migrate the MySQL database to the Oracle Database.
• Extensively used DBMS_PROFILER for PL/SQL performance tuning.
• Extensively used the Explain Plan for analyzing the SQL execution plan and tuning.
• Implemented indexes and table partitions to boost the database performance.
• Used SchemaSpy for creating documentation, database design, and ER diagrams.
• Used Microsoft Visio for creating application specifications and workflow diagrams.

Client: Telcordia Technologies

Responsibilities:

• Involved in the analysis of the Oracle Forms 2.3 and the Pro*C code used for the current design, I developed a brief document.
• Interacting with the user regarding the changes and developments required in the forms.
• Involved in analyzing the data and the business logic for the ordering of the product in DOCS.
• Created requirements documents and worked with the offshore team and development.
• Lead the offshore development activities.
• Led and facilitated the process validation and testing activities.
• Created and applied the PL/SQL libraries to the applications.
• Used dynamic SQL for DML operations in the database procedures.
• Written complex SQL, hierarchical queries for reports using joins, sub-queries, decode, case, etc.
• Used aggregate functions like ROLLUP, CUBE, etc., in queries for gross values.
• Created and altered the database objects, such as collections, tables, synonyms, indexes, procedures, functions, etc.
• Involved in the unit testing of the form developed.

Client: Amerigroup Corporation

Oracle Developer

Responsibilities:

• Developed PL/SQL code, Designing and Deployment of Daily Census Reports.
• Developed functions and procedures for extracting data from different tables using joins, and inserting them into a table.
• Developed SQL queries (subqueries and join conditions), PL/SQL programming to extract data from a large database.
• Developed and tested database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes, and Collections. .
• Developed reports for Microsoft Reporting Services using Visual Studio, testing, and deploying them.
• Created object types in PL/SQL.
• Created DTS packages to load data into the tables.
• Developed cursors for flagging records.
• Written documentation for the PL/SQL code developed.