Vamsi Pulusu

• Led a team of 15 engineers across 7 concurrent projects, ensuring on-time delivery
• Improved over all dashboards load time by 30% for legacy dashboards.
• Migrated over 600TB of on-prem data to Google could environment.
• Delivered multiple KPI's and dashboards to support external customer to be compliant with requirements.
• Coordinated with business users to understand business needs, metrics, and reports.
• Created and maintained technical design docs based on functional requirements.
• Extracted data from various sources (databases, APIs) using appropriate techniques.
• Provided daily support of data movement processes, using analytical skills to determine the cause and resolution of data and software issues.
• Worked with the Data Science team to gather requirements for various data mining projects.
• Cleansed, transformed, and validated raw data to ensure accuracy and consistency, handling missing values and outliers.
• Developed and maintained data pipelines to automate data ingestion and processing.
• Performed data validation and quality checks to ensure data integrity.
• Presented analysis results and recommendations to stakeholders, influencing business decisions.
• Collaborated with cross-functional teams (e.g., marketing, sales, product) to understand business needs and provide data-driven solutions.
• Documented analysis processes, methods, and findings thoroughly.
• Evaluated team performance to identify training and development needs.
• Facilitated regular team meetings to enhance communication and alignment.
• Developed project plans to guide teams through successful execution.
• Implemented coding standards to improve code quality and maintainability.
• Presented project updates to leadership to ensure transparency and alignment.
• Collaborated with product managers to define technical requirements and develop innovative solutions for complex problems.
• Implemented LLM based metrics reporting system for stake holders.
• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
• Tested and deployed scalable and highly available software products.
• Created proofs of concept for innovative new solutions.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Compiled, cleaned and manipulated data for proper handling.
• Analyzed large datasets to identify trends and patterns in customer behaviors.

• Involved in functional and technical meetings and was responsible for creating ETL Source (SQL, Oracle, and Others) for Target maps (Data Warehouse)
• Coordinated with business users to understand the business needs, metrics, and reports
• Created and maintained technical specs based on functional specs
• Provided daily support of data movement processes, using analytical skills to determine the cause and resolution of data and software issues
• Responsible for tracking and logging all support issues to significantly reduce the time needed for support issues
• Worked with the Data Science team to gather requirements for various data mining projects
• Cleansed and transformed raw data to ensure accuracy and consistency, handling missing values and outliers
• Developed and maintained data pipelines to automate data ingestion and processing
• Extracted data from various sources (databases, APIs) using appropriate techniques
• Performed data validation and quality checks to ensure data integrity
• Presented analysis results and recommendations to stakeholders, influencing business decisions
• Collaborated with cross-functional teams (e.g., marketing, sales, product) to understand business needs and provide data-driven solutions
• Documented analysis processes, methods, and findings thoroughly
• Client: Ford Motor Company
• Guided architectural decisions by driving technical excellence and long-term system scalability.
• Coordinated project milestones using Agile methodologies and Jira, improving project transparency and accountability.
• Coordinated with other engineers to evaluate and improve software and hardware interfaces.
• Tested methodology with writing and execution of test plans, debugging and testing scripts and tools.

• Involved in technical leadership in the analysis, decision-making, design, and support phases of implementing computer applications and network hardware and infrastructure, operating systems, databases, and enterprise-wide business applications
• Involved in development phase meetings for Business Analysis and Requirements Gathering
• Managed the Metadata associated with the ETL processes used to populate the data warehouse
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any failed steps, and providing immediate and long-term problem resolution
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations
• Implemented automation within ETL processes to reduce manual tasks and improve efficiency.
• Reduced maintenance costs by creating reusable components within ETL pipelines.
• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.

Client: Gap Inc, Pleasanton - CA

• Created target (STT) mappings, which are essential for understanding the data flow and ensuring accurate transformation of data.
• Designed and developed parallel jobs to extract data, clean, transform, and load the target tables using the DataStage Designer, a crucial tool for managing complex data integration tasks.
• Created, optimized, reviewed, and executed Oracle SQL test queries to validate transformation rules used in source-to-target mappings/source views and to verify data in target tables.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting failed steps, and providing immediate and long-term problem resolution.
• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.

• Created source table definitions in the DataStage Repository by studying the data sources
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data
• Tuned DataStage transformations and jobs to enhance their performance
• Wrote PL/SQL statements in Oracle for extracting and writing data
• Enhanced the job properties for performance tuning
• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Involved in designing and developing a data warehouse environment
• Translated business processes into DataStage Jobs to build data marts
• Worked with sources like Oracle, SQL Server, Excel, and Flat files
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the Data Marts
• Identified source systems, their connectivity, related tables, and fields and ensured data is suitable for mapping
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.

• Excelled in finding, documenting, and reporting bugs, errors, interoperability flaws, and other issues within proprietary software applications developed for Ajel Technologies's global user base
• Demonstrated organized, detail-oriented, and thorough approach to all assignments while adhering to compressed timelines
• Completed all tasks on or ahead of schedule
• Managed project kick-off meetings to align team goals with objectives.