Senior ETL/Data Engineer (Python, Azure, GCP)

RAMAN SANCHULA

E-Mail:*****.********@*****.*** Cell: 408-***-****

(Authorized to work for any employer with US Citizenship) ETL/Data Specialist

Experienced ETL/Data engineer with strong focus on Python, SQL, Azure & GCP cloud. I have successfully developed and maintained high-performed backend systems. My expertise in Azure, GCP, SQL and CI/CD tools ensures efficient and reliable data delivery. With a Dual Master’s degree in Computer Science and Mathematics and a track record of innovative algorithm implementation resulting in improved data outcomes. I am passionate about driving advancements in data deliverables. I am excited to contribute my skills and experience to your mission of solving real data problems. Technical Skills:

ETL TOOLS: Databrix, PostgreSQL, Informatic, SQL Server SSIS, SSRS,. Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, Informix,Oracle.

Data Modeling Tools: Erwin.

Languages: Python, T-SQL, C/C++, Java, PERL, java script, XML, HTML, VB scripts, Informix 4GL / DBA Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer. Cloud Platforms: Azure Cloud, GCP

Other:Agile Methodology

Education:

Masters Degree in Computer applications (MCA), JNTU, Hyderabad, AP - 1992 Masters Degree in Mathematics (M. Sc) from Nagarjuna University, Guntur, AP - 1989

(With a University 3rd Rank)

Certifications:

Informix Certified Database Specialist.

Informix Certified Systems Administrator.

Professional Experience:

Kaiser Permanente., Pleasanton, CA Jan. ‘19 – Dec. ‘25 ETL /Data Consultant

Working on Insight driven Mobile application implementation of Operations Watch List (OWL app). OWL app used by most of the Staff in hospitals across the Kaiser Permanente Hospitals. This app will give required information about the Current Hospital Census, Discharges, Bed information, Restraints, Telemetry & Pressure Injury etc., As a senior member in Agile team responsible for Dataflow from Health connect system to mobile app. Involved in a Data Engineering tool to read the XML/Json file and store the refined data in Azure/GCP platform. From there using API’s will read the data and display it on the mobile app. With other agile team members involved in design development unit testing and integrated testing. Interacted with the SME to gather the requirements and implemented in the testing. Worked with SMEs for the user acceptance testing. Also worked in the Ethics and compliance team of Kaiser Permanente to migrate the data of LVAR (List validation and Reporting) Data from Lexis Nexis system using Alteryx and Informatica to SQL Server. LVAR consists of the data related to Patients which are not eligible for certain services due to the compliant issues. Was involved in extracting data from Lexis nexis system using Export facility then parsing the XML files using the Alteryx and then do the transformations and creating files for Informatica. Then loaded the data to SQL server database using Informatica. Was involved in Design, Development and Testing the Data flow. RAMAN SANCHULA

E-Mail:*****.********@*****.*** Cell: 408-***-****

(Authorized to work for any employer with US Citizenship) Responsibilities:

● As a technical lead worked with team members in planning execution of the projects.

● Part of this project got trained in Big Data implementation & Data Engineering tool, Alteryx including me and my team members.

● Involved in implementation of Number of insights

● Worked on Implementing as per the design and technical documentation.

● Worked on testing data for correctness by automating the data validation by using Python.

● Worked with the user’s team to get the approval for the Insights / reports. Environment: Azure/Gcp Cloud, Big Data, DE Tool, Tableau, Oracle,SQL Server, Data Bricks, Postgres SQL, informatica (10.5), Alteryx, Python

8k Miles Media, Pleasanton, CA May. ’17 – Dec. ‘18 Member of Senior Management

8K Miles is one of the leaders in providing a wide range of expertise ranging from Enterprise Cloud Transformation, Big Data Analytics, Identity Access started the media business. I worked as a senior team member analyzing the data on how best we can use data for various divisions in the Media business and improve the business.

Kaiser Permanente., Pleasanton, CA May. ‘15 – Apr. ‘17 Big Data / ETL Consultant

Worked on multiple projects which includes R10 Projects which includes replacing Legacy source system with CDW (Claim Data warehouse) As a technical lead for a team of 7 staff for development unit testing and integrated testing with offshore and onshore model. Interacted with the End users and collected the requirements and implemented in the testing. Worked with End users for the user acceptance testing. Also worked on KP customers master / transactions data to transfer from traditional legacy data to the Big Data platform.

Responsibilities:

● As a technical lead worked with team members in planning execution of the project.

● Part of this project got trained in Big Data implementation including me and my team members.

● Prepared the design and Technical documentation for Customer Master and transaction data migration.

● Worked on Implementing as per the design and Technical documentation.

● Worked on testing data for correctness

● Worked with the user’s team to get the approval for the reports. Environment: Big Data, Oracle.

Bwise Inc ., New York, NY Aug. ‘14 – Apr. ‘15

SAP BO / ETL Consultant

This project is about Bwise Inc.,’s proprietary software implementation, Customization and developing reports using Business objects.

Gulfstream Aerospace, Savannah, GA Mar. ‘14 – Jul. ‘14 SAP BI/BO Consultant

This project is about implementing Integrated Business Process which will have information about Component View, Inspection Results: General Data, MRP Information, Material Stocks/Movements, Material View, RAMAN SANCHULA

E-Mail:*****.********@*****.*** Cell: 408-***-****

(Authorized to work for any employer with US Citizenship) Notifications, Notifications - Tasks, Pegging View, Planned Order, Purchase Order Item, Purchase Requisition, Reservations, Work Center View, Involved in installing and enhancing of Inventory Management (MM), Production Planning (PP), Quality management (QM) on BW and building corresponding Universes in Business objects and creating reports.

Cisco Systems, San Jose, CA Jun. ‘13 – Feb, ‘14

Consultant

This project is about automating the installation of the application process of network data collection and developing network analytics reports using Informix and Scripting. Intel Corporation, Santa Clara, CA Apr. ‘12 – Jun, ‘13 SAP BW/BI Technical Lead

This project IMC (Intel Mobile Communication) Day 2 is about integrating the Supply Chain Management (SCM) Data of Infineon to Intel. The project involves developing the data flow from SAP SCM, ECC -> SAP BI -> Teradata EDW (via Ab Initio) - > Capacity workbook (Excel Macro based). All the reporting happens in SAP BI and MacroStratagy (on EDW) and Business Objects. The data related to Planning Book, Production Planning, Quotas, Transportation Lane, and Resource Capacity Utilization of APO modules are extracted from the ECC system and stored in SAP BI system. Then further the data is transferred to EDW by using infospokes. The data in EDW is used for generating the reports like PRF report, Conversions Report, PRF vs Prior RTF Planned Volume Ins reports by using MicroStrategy and Business Objects.

SAAMA Technologies:

KLA-Tencor, Milpitas, CA Nov. ‘11 – Apr. ‘12

SAP BW/BI Consultant

This project LTD (Long Tool Down) is about building BI system which can be used to generate reports about how long a Tool is down and how to improve the availability of Tools. The data from the CRM system, DHL data from flat files loaded to BI system. This project also includes the Manager feedback entered into the CRM system which will be extracted through BI system through the virtual provider and further Building the Universe in Business objects to develop the reports in Business objects. IBM Global Services:

AIG Chartis, Parsippany, NJ Apr. ‘11 – Oct. ‘11

SAP BW/BI Consultant

This project is about building Shadow GL Module for AIG Charities BI system Implementation. Insurance-related accounting records such as direct and reinsurance premium, claims, commissions, claims recoverable will be loaded daily into the cube from the FSCD system. To satisfy business report requirements on receivables and FSL Sub Ledger postings, we need to combine receivable cubes with FSL GL cube using a Multi provider. Custom Cube will be used to store the FSL Sub Ledger data. The data will be extracted from the DFKKOPK table using a custom extractor. Essential data will be loaded into the cube with the same data granularity as the source table. Premium claim and cash data will be segregated and loaded into corresponding cubes with only selected fields from the table based on reporting requirements.

RAMAN SANCHULA

E-Mail:*****.********@*****.*** Cell: 408-***-****

(Authorized to work for any employer with US Citizenship) Southern California Edison (SCE), Rosemead, CA Jan. ‘10 – Mar ‘11 SAP BW/BI Consultant

This project is about implementing SD module data on BW and building corresponding Universes in Business objects and creating reports like Billing report, Shipping reports, Delivery reports. Worked on implementing the extraction of SD data through standard Business content and developing Multi-provider and further Building the Universe in Business objects to develop the reports in Business objects. City of Santa Clara, Santa Clara, CA Dec.'06 - Dec.’09 Informix / SQL Server DBA

As a Database Administrator Responsible for Planning, designing, developing and managing various Databases at City of Santa Clara.

Shutterfly Inc. Redwood city, CA Oct.'04 - Nov. ‘06 Database Administrator

As a Database Administrator Responsible for Planning, designing, developing and managing various Databases at Shutterfly Inc.

Rainmaker Systems Inc, Scotts Valley, CA Dec.'01 - Oct.’04 Data Analyst and Administrator

As a Data Analyst & Database Administrator Responsible for Planning, designing, developing and managing various Databases in Rainmaker Systems. Worked on ETL process using informatica. Egreetings Network, Santa Clara, CA Apr.'99 - Nov.'01 Database Administrator

As a DBA dedicated to stream lining of Informix/Oracle/SQL Server Databases at Egreetings Network. DHL Airways, Redwood City, California, USA Jul.'98 -Mar.'99 Database Administrator (Consultant)

As Informix DBA involved in managing production systems and support for the Development team in various projects. Also involved in Creation of ODS (Operational Data Store). ODS is Datawarehouse to support reporting needs.

Perrot Systems, Minniapolis, MN, USA Dec.'97 -Jun.'98 Database Administrator (Consultant)

As Informix DBA involved in managing production systems and support for the Development team in various projects at Valuerx.

Diversified Collection Services Inc, San Leandro, California, USA Aug.'95 - Nov.'97 System Analyst and Database Administrator

As a system Analyst involved in validating various processes in developing Student loan collection systems. Also involved in designing various databases for the Student loan collection system and maintaining Development, QA and production Informix Databases.

Far East Computers Pte, Ltd, Singapore Jan.'94 - Jun.'95 Software Engineer

Involved in supporting various projects managed by Far East Computers. which includes the following. Vehicle Inspection system, Singapore IRS reporting, Reporting for Standard Chartered Bank Indotronix India Pvt. Ltd, Hyderabad, India Jan.'92 - Oct.'93 Software Engineer

Joined as a fresh graduate as interned and involved in learning Informix 4GL and reporting. Later involved in developing and maintaining various modules of Hotel Management systems including Room allocation, table reservation and food costing.

Contact this candidate