Company -UNFI working on System and Enterprise (SAE) Data and Reporting Project: 1- Move one distribution Data(Richburg) center into Redshift Production. • Worked with the offshore team to Monitor Lamda and other production functions. • Work with off and on-shore teams to streamline the data pipeline and plan to integrate customers' order data into the production System. • Manage a team of 6 members for managing Scrum Board and Jira Stories

• Designed data flow architect from Teradata to Snowflake, and created a strategy to move data to snowflake,• Designed and Developed ETL code Using the IBM DATASTAGE tool for data migration from Teradata to Snowflake.• Partnered with Business leadership and stakeholder to identify and deliver targeted POS LOG and EOD data that support strategic development and tactical execution and evaluations.• Developed test scripts for data validation in both Teradata and Snowflake environments. • Troubleshoot existing EOD job process in the DATA stage to identify data differences between Snowflake and Teradata.• Use various methodologies to load data from sources to target databases such as JSON files and Data stage jobs.• Worked with snowflake Stream and task utility to capture frequent data and add into snowflake to update prod data as part of CI/CD.

Working at AT&T Inc on Data Migration Project. AT&T spinning off Teradata and move to Snowflake database.• Design and Developing ETL code for data migration from Teradata to Snowflake• Design and Developing test scripts for data validation in both Teradata and Snowflake environments.• Work on Product and Employee Hierarchy and clean duplicate data.• Working with offshore team in code reviews and identifies bad sections early in the process and recodes ETL for high performance.• Optimizing and enhance existing ETL and stored procedures.

Sr. database and data analytical developer at Verizon Well versed in data integration and migrationAt Verizon, I worked on the Snowflake database and Teradata to extract data and used the Knime tool for cleansing data, and created various workflow in Knime for migration data to thought spot.Used Google Analytics data for Verizon cloud product offered by Verizon to analyze customer reviews to enhance product performance.• Designing, developing, and testing of the ETL strategy to populate the data from various source systems such as Flat files, Teradata, Snowflake, SQL SERVER feeds and using KNIME Workflow Tool and populate into ThoughtSpot.• Developed ETL processes to Extract data from Teradata and load data to Sqlserver database via nightly process.• Developed PL/SQL Packages to extract data from Snowflake database and load to KNIME WORKFLOW for data cleaning and merge other flat file to load data in ThoughtSpot.• Developed Various KINME Workflows for data clean and churn and schedule to upload data frequently on ThoughtSpot.• Developed few python scripts for user’s activity and study the trend user’s usage of various Verizon cloud products. along with status of subscriber’s activation and deactivations.• Calculated cloud revenue and prepaid revenue for all the Verizon Cloud products and created Pinboard in ThoughtSpot.• Integrated Google Analytics with KNIME to extract analysis customers data.

analysis and cleaning data along with giving insight data quality. Integrated Oracle data and migrate to SQL Server with third-party tools like EnAct CRM and Spotfire using Custom ETL packages.• EnAct CRM commercial lending product to verify the sales and validate sales for the commercial team. Integrated EnAct CRM with bank data via custom ETL.extract pull from Oracle databases and push into SQL server with schedule nightly jobs. Modified packages and reuses as a ref package to ease database performance.• Evaluated and presented an analysis of two data analytical tool Tableau and Spotfire for the data management team and Seniors managers for how these tools are effective to drill down to transactional level data for making smart decisions and singlehanded implement Spotfire.• Integrated continuous process improvement conversion of the manual integration process to fully Systematic process.• Worked and lead online banking team and create a various interface for team to do ease of business such as credit/ debit card transaction and reissue of cards,• Proficient in Sql and pl/sql and created various one-off branch wise customer list queries in using Sql and packages for marketing team like active and passive customers, the status of various promotions for new money.• Created various Spotfire Dashboards for management team which helps them to make a decision making, Dashboard like Generation wise account holders, online activity with bank and numbers of the user who used credit or debit cards.• Extensively worked in Oracle SQL, PL/SQL tuning in Data warehouse applications using various tools such as AWR, STATSPACK, Explain Plan. • Extensively worked on Data integration between various sources of data using custom pl/sql scripts and ODI for data mapping such as Sqlserver data, TREEV data and excel data to pull all data which create monthly tables along with various information into Data Warehouse tables.

Teach lead managing up to $150K in projects, managed one offshore team developer, and two outsourced developers. Migrated existing financial into R12 and performed user testing for the customized code.- Implemented analytical tool Tableau and Longview- Worked on Complete aspect of technical and functional Supply chain Module's Order to cash Procure to Pay Oracle Incentive Compansation Manufacturing (Discrete and Process)

Implemented, configured, and implemented EBS-TAX (R12) Module for Argentina, Netherlands, and Canada. Gathered information for configuration, setup tax module, and defined withholding, tax, supplier applicability code, created and updated supplier in Oracle payable. Designed custom specification template for change control management • Configured banks for vendor in cash management and mapped with suppliers setup in AP. • Implemented reconciliation activity between financial Rel 12 and legacy system MFGPRO. • Developed new custom code for payable invoice and payment reports reconciliations.

Played key role in go-live project called the Business System Rollout go-live project live in Oracle. Introduced and customized Oracle application forms for segregation of duties using form personalization and avoid Custom.pll.• Gathered requirements and coded for inventory transaction interface for moving inventory from one sub-inventory within the same inventory organization to another sub-inventory.• Customized Oracle application forms for segregation of duties using form personalization.• Constructed Oracle Discoverer 10g and created reports and ad-hoc queries for user in all Oracle modules. • Wrote sales and order backlog interface and created dynamic discoverer reports.• Troubleshot and supported depot repair, BOM, WIP and inventory modules interface.• Developed and created project plan per project management methodology to implement BI Publisher formally XML Publisher v 5.6.3. • Designed project plan for Original Equipment Manufacturing (OEM) database and data architecture for Oracle database and data conversion from MySQL database. Integrated with Oracle EBS as a separate Oracle Module.