Data Engineer
Resume:
SATYAVENI SURAPUREDDY
*************@*******.***
https://www.linkedin.com/in/satyaveni-surapureddy/
Database Administrator Database Developer Data Engineer Data Analyst
6+ years of IT experience passionate, motivated subject matter expert, eager to learn and to give the customers the best experience and fulfilling all their needs by going above and beyond their expectations.
Proficient in Database Environment Oracle PLSQL, SQL Server.
Excellent skills in R programming, Python, Tableau.
Exposure on Azure, JSON, REST API, SharePoint, Unix Shell Scripting, Alteryx, ETL, DWH Concepts, TOAD, JIRA and GIT.
Skills
ORACLE
SQL Server
ETL
TOAD
SQLDeveloper
RMAN
ServiceNow
Azure
R Studio
Python
Tableau
Alteryx
Java
OEM
OFSAA
OBIEE
SSIS & SSMS
JSON
REST API
PL/SQL
SharePoint
Unix Shell Scripting
Control M
Visual Studio
Education:
• Electrical and Electronics Engineering Jawaharlal Technological University 2008 – 2012
Professional Experience:
Praxair Distribution Inc, Ankeny, IA OCT’ 17 - Present
Database Application Developer
Hands on experience on Software design, architecture, web development, front-end design and business analysis.
Migrated JSON data to Azure Event Hub. Experience in moving Data in and out of Microsoft SQL Databases to Azure Blob Storage and Azure Event Hub using python programming.
Good knowledge & hands on experience on Cloud Computing like Azure.
Strong experience in Data warehouse concepts, ETL and hands on experience with SSIS.
Knowledge of Oracle, MS SQL database & RESTful web services (http requests, xml, json).
Been part of a focused development team and had the opportunity to work closely with end users to design new packages, define APIs, interface and extend the framework.
A strong understanding of common web development techniques, e.g. REST API, JSON etc.
Worked with Ecommerce team for the developed plan for new ecommerce site. Managed full project lifecycle: strategy, design, development, testing, and implementation.
Implemented web scraping the description using R. This automation helped projects and reduced lot of manual effort.
Followed and established processes for software development life cycle with an agile approach to delivery software.
Designed development of workflows triggered by events from other systems to automate the process.
Developed databases and necessary to integrate and implement the system as well as accurately documented systems based on analysis results.
Played an important role in code review process as well as provided appropriate suggestions to improve application design, coding, unit and integration testing as well as software quality.
Made efficient use of hardware and software resources as well as developed and reviewed test plans, test data and code to determine whether programming logic created the desired results.
Created user defined python programming code to convert the structured data to required JSON nested format.
Developed metadata schemas, taxonomies, ontologies, and content and context models.
Reviewed user requirements as well as performed analysis, design, implementation, installation and training related.
Implementation of complex solutions with minimal technical debt. Develop solutions that are easy to deploy, maintain, and are bug free.
Participated fully in the development process through the entire software lifecycle.
Designed and developed packages, database objects, tables, stored procedures and views.
Extensive use of SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
Design scripts and develop tools to automate periodic task and improve monitoring of system.
Developed ETL process from Oracle databases to SQL server databases.
Work together with various teams to insure PIM completeness and integrity.
In depth experience in Oracle database architecture, Oracle database development, Oracle database administration, database/SQL performance tuning, Data Warehouse.
Creating templates based on requirements and industry standards by product line.
Translating our current business processes into documented work-flows.
Participated in design and implementation of Product Information Management (PIM) System.
Expert in developing T-SQL (DML, DDL, DCL) statements.
Preparing metrics to track level of enrichment for each product segment.
Creating and Updating and business function that need to be implemented based on business requirements.
Prioritize product segments to be enriched based on business requirements and manage updating, correcting and collecting the data to get them to a completeness level that is required.
Perform responsibilities as directed achieving desired results within expected time frames and with a high degree of quality and professionalism.
Analyze the database performance and performed database performance tuning.
Followed sprints and coded/implemented codes with scrum teams.
Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them.
In depth experience in Oracle database architecture, Oracle database development, Oracle database administration, database/SQL performance tuning, Data Warehouse concepts.
Research and evaluate innovative technology solutions, collaborating with teams to determine feasibility of deployment.
Excellent analytical and problem-solving skills, ability to isolate and resolve problems in timely manner
Provide Day-to-day business database support and management of the production DB.
Worked extensively with service requests and Incident Management using ServiceNow tool for resolution on issues and bugs in day to day activities.
Having very strong background in a disciplined software development life cycle (SDLC) process and has excelling analytical, programming and problem-solving skills.
HCL Technologies, Wellington, New Zealand DEC’ 15 – MAY’ 16
Database Developer
Worked with the ANZ Bank at New Zealand in Banking Domain as a database lead.
Performed day-to-day database activities including software installation, migration, performance tuning, backup/recovery, security, database design, optimization.
Expertise in Client-Server application development using Oracle 12C/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Participated in designing, implementing and maintaining the data for 11g, 12c (SQL, PL/SQL, Stored Procedures).
Participated in the database upgrade from Oracle 11g to Oracle 12c, and provided support for Oracle upgrade, application installation and operation, and database implementation at the Post.
Experience with the new features in SQL SERVER 2012/2016.
Hands on experience on database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, capacity planning, database security, migration and documentation.
Experience in designing, installing & maintaining large size databases and ensuring that the company's Oracle databases runs smoothly.
Applied Agile method to better adapt to the business requirements changes, quickly designed and coded/implemented the following applications with scrum teams.
Strong knowledge of Instance, database and query tuning to improve the performance of the database/application
Establish and maintain sound backup and recovery policies and procedures.
Trouble-shooting various Database related problems such as in using database links, materialize view, SQL*loader, Export, Import, SQL hanging issues, etc.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Hands on experience Unix Shell scripting and Solaris environment.
Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
Upgraded to latest Oracle release enhanced availability and introduced new features for ongoing support of these databases and created scripts to automate the process.
Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them.
Backup schedule from RMAN, export-import using Data Pump.
Hands on experience in OEM 12c for Database Performance Monitoring and Tuning.
Having work experience on Fusion middleware products like WebLogic 11g installations, deployments.
Worked on Patching, Application cloning, patch analysis, backups, RMAN, restorations (tape, disk).
Implement and maintain database security (create and maintain users and roles, assign privileges).
Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
Setup and maintain documentation and standards.
Hands on experience with Oracle database 9i, 10g, 11g, 12C databases Installation, Upgrading, PSU and BUG Fix patching, Managing, Monitoring and troubleshooting and Database Backup and disaster Recovery.
Strong knowledge of Instance, database and query tuning to improve the performance of the database/application.
Performed Oracle Financial Applications OFSAA admin activities which included installations, upgrades and database performance tuning.
Oversee data analysis and database management for Oracle systems including applications upgrades.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Primary support for Oracle databases, and strong experience on UNIX shell scripting.
Experience in implementation of OBIEE on OFSAA i.e., configured and maintained integration of OFSAA with other applications such as OBIEE.
Been part of OFSAA Upgrade project and successfully delivered with in timeline.
Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities.
Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
Establish and maintain sound backup and recovery policies and procedures.
Implement and maintain database security (create and maintain users and roles, assign privileges)
Setup and maintain documentation and standards
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
HCL Technologies, Bangalore, INDIA JAN’ 14 – NOV’15
Database Administrator
Designed a bank application according to business requirements, and implemented robust stored procedures, functions, views, and triggers that employed best practices to meet the required functionalities. Utilized XML for import and export of data.
Analyzed different high availability solutions.
On Call support for 24*7. Worked extensively with Oracle through service requests for resolution on issues and bugs in day to day activities.
Experience in Analyzing Performance, Query Optimization and Creating and Tuning Indexing and writing stored procedures.
Expert in analyzing the execution plan and index management for better Query Optimization.
Experience on databases Installation, Upgrading, PSU and BUG Fix patching, Managing, Monitoring and troubleshooting and Database Backup and Recovery.
Experience in Backing up, restoring the database manually and scheduling the jobs and Maintenance plans.
Experience on Oracle Database Administration in variety of environments like HP-UX, Red Hat Linux, SUN SOLARIS, and Windows.
Having good technical experience on creating scripts for automation.
Provide Day-to-day business database support and management of the production DB.
Worked extensively with Oracle through service requests for resolution on issues and bugs in day to day activities.
Establish and maintain sound backup and recovery policies and procedures using RMAN and performed health checks and proactive monitoring using Enterprise Manager/Grid Control and UNIX shell scripts.
Having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration and documentation and generating reports.
Strong knowledge of Windows/Linux/Solaris operating systems and Unix shell scripting (Automation knowledge of database upgrades/new builds)
Hands on experience with Oracle database 9i, 10g, 11g, 12C databases Installation, Upgrading, PSU and BUG Fix patching, Managing, Monitoring and troubleshooting and Database Backup and Recovery.
Having work experience on Fusion middleware products like WebLogic 11g installations, deployments.
Provide regular and ad-hoc data(base) reporting as required by technical and business requirements.
Patch management, version control, allocating system storage and planning future storage requirements for the database system.
Establish and maintain sound backup and recovery policies and procedures
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Worked on 24 X 7 Production database administration, support.
Hands on experience with Oracle database 10g, 11g, 12C databases Installation, Upgrading, PSU and BUG Fix patching, Managing, Monitoring and troubleshooting and Database Backup and Recovery.
Experience on Database Administration in variety of environments like HP-UX, Red Hat Linux, SUN SOLARIS, and Windows.
HCL Technologies, Chennai, INDIA JUN’ 12 – DEC’13
Graduate Engineer Trainee
Hands on experience on SQL Server and Oracle databases in Windows, Unix and Solaris environment.
Provide regular and ad-hoc database reporting as required by technical and business requirements.
Worked on various ticketing tools like LANDesk etc.
Worked on 24 X 7 Production database administration, support and experience in performing standard database administration tasks, Database Monitoring tasks, Diagnosing Database problems and fixing the problems. A hands-on experience on Microsoft SQL server 2012.
Worked on Incident Management and Service Requests.
Handling Memory and CPU configuration for both Oracle database server and SQL server.
Solid skills and discipline for Change Management practices processes.
Experience in implement and maintain database security (create and maintain users and roles, assign privileges).
Looking into action requests (tickets using LANDesk tool) and resolving issues, providing the root cause, providing the permanent fix and avoiding SLA.
Designs and maintains access and security administration.
Designs, implements and maintains backup and recovery strategies on Database Management Systems.
Worked extensively with Oracle through service requests for resolution on issues and bugs in day to day activities.
Troubleshooting for alert log, trace files and data dictionary views and taking steps to rectify error messages.
Importing and Exporting of database objects, Table spaces and databases.
Worked on Tablespace related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
Installation of Oracle Database Software and Patches.
Creating and Managing Databases, Schemas, Privileges, Roles, Tablespace, Datafiles and Redo log files.
Contact this candidate