Prasanna R Email and Phone Number

• Perform in-depth data analysis providing competitive bench marker reports, consumer journey studies and reports quantifying • Collaborated with Analytics, Engineering, Client Insights teams to identify and resolve data quality issues, scope out client requirements and convert that to technical specs. • proposals, conducted feasibility analysis and showcased data capabilities to potential clients. • Led a team of analysts and designed surveys to analyze trends, establish feedback loops for seamless communication with end users.Technical/Business Program engagement resource on project involving migration of Legacy systems processing Master data onto Reltio platforms.Also driving requirements for AWS Data Lake focusing primarily on data storage and analytics solution that offers more agility and flexibility than traditional data management systems.Collaborating with product owners, developers, scrum masters, project managers to elicit, analyze, prioritize and scope business requirements. Closely worked with global teams to ensure the efficacious production release of new products.Leading UAT to ensure project requirements are met prior to going live.Supporting defect triage process by validating defect severity and ensured customer issues are resolved Creating a data-driven culture and to enable fact-based decision making to identify and capture incremental top-line growth opportunities and improving operational efficiencies.

. Responsibilities: Developed and tested ETL pipelines using Informatica, validated data migration, ensured data quality, tracked and resolved defects.. Achievements: Successfully migrated data from SQL Server to Salesforce, ensured data consistency between source and target systems.

I worked for multiple major clients through GSPANN as mentioned below as an ETL consultant. Rodan and Fields (SanRoman,US) - Mar 2019 - Mar 2020Macys (San Francisco, US) - Mar 2018 - Mar 2019Kohls (Milpitas,US) - Feb 2017 - Mar 2018Macys - Jul 2016 - Feb 2017Lam Research (Fremont, US) - Mar 2016 - Jul 2016Macys - Nov 2013 - Jul 2016Work closely with the Business, Solution Architect, Data Modeler, Data Mapper, and Business Analysts to understand business requirements, providing expert knowledge and solutions on Data Warehousing, ensuring delivery of business needs in a timely cost-effective manner• Evaluate the data collection, data staging, data movement, analytics delivery, data quality and archiving strategies with the base of Stories/requirements provided in Version-one• Effectively designed and developed ETL jobs using datastage tool, which loads data into DB2 and Vertica Databases. These jobs load data into Dimensions and Facts which has SCD type-2 dimensional loads. The source data is extracted from the MST/DB2 and then sent to the vertica Database for future reporting purposes.• Identify opportunities to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity.• Extensive experience in testing the data loaded through ETL tool IBM Infosphere/Websphere DataStage, Ascential DataStage to files like CSV’s and TAB files.• Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.• Prepared the testcases which included different functional and technical scenarios.

• Actively worked in all phases of the SDLC starting from requirements, design (LLD), development and unit testing, integration testing of all Datastage applications.• Interaction with client for analysis of Organization data, ETL requirement gathering & data Consolidation. • Work extensively in designing and developing datastage jobs and sequencers in Datastage V8.5 parallel edition.• Worked in onsite-offshore environment, assigned technical tasks, monitored the process flow, conducted status meetings and making sure to meet the business needs.• Used different Partitioning methods in parallel job (Auto, Round-Robin, Hash, and Entire) to improve the performance and to get the accurate results according to the business requirements• Take higher responsibilities to lead the team and deliver the good quality of code.• Worked in Data stage 8.0 PX job enhancements based on the new Requirements from Business.• Extensively worked in Performance tuning of Datastage jobs that runs long while monitoring the flow.

• Analyzed and understood the WIBI process, collaborating with the SAP Team for data.• Designed and developed ETL processes in Datastage 7.5.2 PX, utilizing stages like Sequential file and Lookup Stage.• Developed mappings to load data warehouse and Data Mart, achieving efficient performance tuning.• Created sequences to streamline project workflows.

Louis Vuitton via Valtech• Analysis and design of ETL - processes.• Created Data Stage server jobs to load data from oracle and ODBC, sequential files, flat files etc.• Used the Data Stage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into the target• Created job sequences and schedules for automation.• Used DataStage tool to transform the data to multiple stages, and prepared documentation.• Used Data Stage Manager for importing metadata from repository, new job categories.• Customized Datastage applications, Managed Data Stage Jobs and Job Sequences• Analysis and Creation of Control-M specifications from Test Director.• Creation and Execution of Drafts in Control - M.Environment: Data Stage7.5, Oracle 9i, Control – M