Vamsi Krishna Patrudu Andhavarapu

• Developed and maintained robust Core Datawarehouse and Credit Reporting applications, aligning with business goals and stakeholder demands
• Enhanced cross-functional communication, accurately scoping development timelines by eliciting business unit requirements
• Led integration initiatives, evaluating and adapting to regulatory shifts and product modifications within the banking and financial sectors
• Crafted detailed IT documentation to facilitate efficient maintenance and bolster system dependability.

Client: Farmers Insurance US & Swedbank AB

• Specialized in meticulous requirement gathering and adept at synchronizing offshore team efforts to ensure flawless project delivery
• Skilled in dissecting business needs and formulating detailed functional specifications
• Achieved significant improvements in DB2 query efficiency by optimizing and upholding superior coding practices
• Utilized Informatica PowerCenter 9.6.1 to streamline ETL workflows, enhancing data warehousing efficiency
• Crafted bespoke UNIX Shell Scripts to meet unique project demands
• Maintained thorough documentation to bolster client interactions and provide robust post-implementation support.

Client: Barclays Bank SA

• Crafted extensive End-to-End (E2E) documentation for the Data Archival Project, encompassing Critical Design Documents (CDD), Detailed Level Design (DLD), and Implementation Plans (IP)
• Led data growth analysis and optimized workflow processes in the Data Warehouse, targeting and refining high-volume tables
• Innovated strategic integration solutions for RainStor using Informatica workflows, bolstering data consolidation
• Engineered complex Informatica mappings to streamline data ingestion from various sources, improving data integration
• Implemented performance tuning strategies to enhance efficiency of targets, sources, mappings, and sessions.

Client: Farmers Insurance US

• Developed high-performance ETL processes using Informatica, aligning with business needs for flawless data integration and transformation
• Authored detailed Low-Level Documentation and Unit Test Cases, rigorously documenting test evidence to uphold quality standards
• Performed in-depth analysis of data sources and destinations, implementing business rules for precise data transformation and mapping
• Orchestrated and maintained Informatica sessions, workflows, and parameter files leveraging advanced features of Informatica Designer and Workflow Manager
• Oversaw job scheduling and monitoring via Autosys to guarantee punctual and correct data processing operations.