Health Care Etl Developer

Venkata Ramana Sathivada

Austin, *****, USA (Open to Relocate) 806-***-**** ****************@*****.*** https://www.linkedin.com/in/svenkataramana/ Professional Experience:

Overall, 6.6 years of IT experience in Production Analysis, Design, Development, Testing and Implementation of business application systems for Banking, Health care, and Retail Domains. Efficiently worked has a Informatica Developer, Tester and L1 /L2/L3 Support Activity. Worked extensively with slowly changing dimensions (SCD Type I, SCD TYPE 2).

Strong Data Warehousing ETL experience of using Informatica IICS, 10.2 and 10.4 PowerCenter Client tools Repository manager, Mapping Designer, Workflow-Manager/Monitor. Responsible for Business Analysis and Requirements collection.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions. Experience in using Automation Scheduling tools like Autosys, Control-M. Experience:

(3) Designation: IT Analyst TATA Consultancy Services Pvt.Ltd (TCS) Hyderabad, Telangana, India Project-3: STAR2(Sales Tracking and Reporting) Client: PepsiCo Domain: Retail Duration: Jan 2019 – Jul 2022 Role: Informatica IICS, PowerCenter ETL Developer and Production Analyst. Responsibilities:

• Parsed high-level design specification to simple ETL coding and mapping standards. Designed and implemented data warehouse architecture and source-to-target mappings. Developed mappings to load into staging tables and then to Dimensions and Facts.

• Worked with SCD Type 1 & 2 transformations for data accuracy. Automated ETL jobs and managed production deployments.

• Designed and maintained mapping documents to track data flow and ensure consistency. Involved in Performance tuning at source, target, mappings, sessions, and system levels.

• Led ETL validation and testing efforts to ensure data accuracy and system stability.

(2) Designation: System Engineer TATA Consultancy Services Pvt.Ltd (TCS) Hyderabad, Telangana, India Project-2: Data Exchange Client: Anthem Domain: Health Care Duration: March 2018 – Dec 2018 Role: Informatica IICS, PowerCenter ETL Developer and Production Analyst. Responsibilities:

• Created and optimized ETL processes using Informatica PowerCenter. Constantly interacted with business users to discuss requirements. Developed mappings for data integration and transformation from various sources.

• I have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.

• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

• Developed and optimized stored procedures for high-performance data processing. Tuned the Informatica mappings for optimal load performance.

(1) Designation: Assistant System Engineer TATA Consultancy Services Pvt.Ltd (TCS) Hyderabad, Telangana, India Project-1: Information Management Technology (IMT) Production Support and Maintenance L3 Client: Charles Schwab contract with Infosys Ltd. Domain: Banking Duration: Feb 2016 – Feb 2018 Role: ETL Production Analyst.

Responsibilities:

• Provided ETL production support for critical financial applications 24/7. As a support person Maintaining availability of the application through monitoring of the systems and applications by performing proper health checks before business hours starts. Optimized system performance and assisted in release management.

• Developed automation scripts to reduce manual intervention and improve efficiency.

• Provided impact analysis and recommendations for infrastructure upgrades and patches. Technical Skills:

ETL Tools: - Informatica IICS, PowerCenter ETL Tool 10.2/10.4. Operating Systems: - Unix, Windows

Database: - Oracle 11g, SQL Server, Snowflake, Teradata. Database GUI Tools: - SQL Developer

Programming Languages: - UNIX shell scripting, SQL, PLSQL. Scheduling Tool: - Autosys, Control-M

User Access Tools: - Service-now, ITSME, Identity Management Tool (IDM Tool). Education:

Texas Tech University, Lubbock, Texas, USA Master of Science in Computer and Information Science Aug 2022 – May 2024 GPA: 3.46 Andhra Loyola College, Vijayawada, AP, INDIA Bachelor of Computer Science Jun 2012 – May 2015 GPA: 3.48 Certifications:

• Data Warehouse Engineer Professional Certificate IBM Databases and SQL for Data Science with Python IBM Achievements:

• Team under my guidance has outperformed and received the “Delivery Excellence Award”.

• Received a “Certificate of Appreciation” for resolving the critical issue present in application over a decade.

• Estimated and drafted a proposal of Application Migration project and assisted the team to complete it within the deadlines.

• Technically evaluated 30 candidates out of which 10 applicants are hired in recruitment drive.

Contact this candidate