Vamsi K. Pulusu

• Coordinate with Business users to understand the business needs, metrics, and reports.
• Created and maintained technical specs based on functional specs.
• Responsible for providing daily support of data movement processes by using analytical skills to determine the cause and resolution of any data and software 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

• Involved in functional and technical meetings and was responsible for creating ETL Source (SQL, Oracle, and Others) for Target maps (Data Warehouse)
• Coordinate with Business users to understand the business needs, metrics, and reports.
• Created and maintained technical specs based on functional specs
• Responsible for providing daily support of data movement processes by using analytical skills to determine the cause and resolution of any 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: AmeriHealth Caritas

• 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

Client: Gap Inc

• Created target (STT) mappings.
• Designed and developed parallel jobs to extract data, clean, transform, and load the target tables using the DataStage Designer.
• 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.

Client: TIAA-CREF

• 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.

Client: Vanguard

• Involved in designing and developing a data warehouse environment
• Translate 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
• Identify source systems, their connectivity, related tables, and fields and ensure data is suitable for mapping.

• 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
• Complete all tasks on or ahead of schedule

• Designed a Web-Based Medical Application for Mobiles using the SQL Server 2008 R2 and Java Server Pages (JSP) as part of the master’s Project
• The application allowed users to interact with medical practitioners, administrators, and bill payments
• Secure transmission enabled lab reports and medical prescriptions to be shared using the application
• The application enabled faster response and ease of access to users
• Active participation in the design of a website for on-campus Bike Rental
• Developed functional and non-functional requirements document, system design document, database design (using Oracle Database 10g), and website aesthetics
• Prepared presentations to communicate with the project team, clients, and end-users