Krishna Yerra

- Leading the development of the company’s short and long-term strategy, ensuring their alignment with short-term and long-term objectives - Communicating, on behalf of the company, with shareholders, government entities, and the public - Developing an IT vision and goals for the organization - Developing fresh ideas for the running of the company - Enforcing adherence to legal guidelines and in-house policies to maintain the company’s legality and business ethics - Communicating with the technology team and other departments as collaboration requires - Handling employees’ concerns and performances - Determining business requirements for IT systems - Identifying and eliminating security vulnerabilities with strategic solutions that increase data security - Directing and supporting the implementation of new software and hardware - Overseeing departmental finances, including budgeting and forecasting - Implementing executive policies

I was responsible for: - Preparation of design documents - HLD & LLD - Peer Review & IA - Interaction with Businesses to understand the requirement - Developed a tool to take the backup of the entire data model and store it in a flat file on a daily basis - SQL & Pl/Sql Tuning, application tuning using various tools like OEM, TkProof, and AWR - Set up the Golden Gate replication to provide data to various downstream system - Advanced Oracle 12c Pl/SQL coding - Workload Management (AutoSys) - File Transfer solutions using FTP / MQFTE - Evaluates, understands, and implements detailed business, functional, and non-functional technical requirements (including recovery, security, data volumes, performance, and audit)

I was responsible for - Producing technical specifications in a Fusion Cloud/Middleware environment. - Proven knowledge of HCM; Payroll, Talent etc, and Financials exposure - Working with customers directly including technical architects, functional consultants, and developers - Demonstrated consultancy skills including consulting experience with blue chip companies engaging with Senior Management and Director/CIO level as appropriate for organization size - Data analysis, coupled with the experience of reconciling large, complex data sets. - Mentoring & Peer review of a team of 5 - Prepared and load HCM Data Loader files. - Investigate and resolve HCM data loader import and load errors. - Functional understanding of Core HCM - Person Management, Assignment, Talent Profiles, Workforce structures, Compensation, etc. - Payroll – familiarity with Payroll concepts – Elements, Balances, Payroll Relationships, Calculation cards, etc. - Understanding of payroll fast formula. - Do technical validation before loading the data based on the data object definition.

I was responsible for : - Understand the data and perform data analysis to support building new reports and modifying existing reports - Analyze users’ needs and design as necessary - Perform code promotions and test that reports are operating correctly - Perform Technical Review of requirements, analyze source data, and provide gap analysis - Demonstrate Company’s Core Competencies and values held within - Collaborate, coordinate, and communicate across disciplines and departments - Research, construct, develop, and test complex SQL and PL/SQL scripts for new reports - Coordinate cross-functional projects as assigned and interact with all areas of the organization to achieve timely results - Ensure compliance with HIPAA regulations and requirements - Communicate with end users on reports or environmental issues - Provide weekend and off-hours support, as needed - Use structured coding methodology and “code once use many times” methodology so that the developed code is reusable; - Perform code reviews/walk-throughs and unit testing of code developed by contract or new developers; - Work with team members to develop program units that integrate seamlessly into the overall system. - Lead a team of 4, Using technologies including XML, JSON, SOAP, REST, HTML and CSS is desirable for an APEX-based front end over a period of 6 months.

I was Responsible for -Manage all phases of the SDLC from analysis, design, development, testing, implementation, and maintenance. -Create shell scripts to automate the process of generating the XMLs after successful verification by the business analysts. -Develop a custom interface for executing and managing SSIS packages. Involvement in developing, testing, compiling, debugging, and maintaining the data using oracle, PL/SQL, UNIX, and LINUX. Create test cases and test reports and work with the QA team to validate the data and scenarios. Involvement in debugging various defects relate to the implementation of business logic. Review Linux shell scripts and make necessary changes required for the process. Involvement in extracting data from different data sources like oracle, XML, and spreadsheets. Involvement in the integration of the data with SOA, OFS, and JAVA teams according to the business specifications. Design and program applications and utilities using C++, Perl, and shell scripting for Linux operating systems. Create and maintain indexes, constraints, tables, PL/SQL store procedures & packages and produce queries to answer business questions. Create PL/SQL procedures, functions, and batch scripts, C++ programs for loading flat files, and BCD/Binary files into a database schema. Help the QA team and support team by explaining the developed code and solving prod issues and UAT issues by fixing bugs.

Mastered in Information Technology and Programming

Studied Computer Science - Programming