Bapi Ipperla
Alpharetta,GA
Summary
18 Years of IT experience in multiple Leadership and Architect roles in implementing GCP, Azure, Hadoop, Teradata Data lakes, Business Intelligence, visualization and Data Warehousing Projects for large US, UK and APAC based Retailers for their Merchandising, Supply Chain, Digital, Customer, Stores, Contact center, People system, Transportation and Logistics domains.
Strong advocate and proven credentials for Business value additions and productivity improvement. Experienced in delivering multiple Data warehousing and Business Intelligence (BI) applications and decision support systems within budget and schedule. Recognized for ability to analyze complex data, supervise and work well with all levels of individuals and stake holders, perform requirements analysis, design and architect solutions.
Strong leader and problem-solver dedicated to streamlining operations to decrease costs and promote organizational efficiency. Uses independent decision-making skills and sound judgment to positively impact company success.
Overview
17
17
years of professional experience
Work History
Tech Manager, Data Engineering
Macy's
03.2021 - Current
- Enterprise Data and Analytics Initiatives for Supply Chain, Merchandising, Stores, Digital and Marketing teams
- Built the process using Cloud PubSub and DataFlow, resources can be scaled automatically by the system in response to changes in demand with number of messages from vendor systems
- Created Bot Traffic Segmentation Automation process for both History and Incremental data for MCOM, historical data corrections for last two years automated through the ETL process without manual efforts
- Fixed the data gaps identified by re-processing the missing files from Adobe by creating a separate process to extract and consume the files into GCP data lake tables
- Designed and architected Big ticket data into GBQ data lake for Sales adjustments, manifest data that provides business the ability to track supply chain linehaul expenses, MLO archive data, FLO data, RDS transfers, Card, Maersk, BTRC 501 report, RDS provides the ability to business to view/query and analyze the data previously limited to files without any location, product, date dimensions
- Built loyalty, NDER, RPS, Klarna, Credit metrics for Macys, Bloomingdales.
- Metrics for Financial, Digital and Executive Summary pages,
- Deployed pipelines to replace previous manual processes
- As part of Forecasting and replenishment modernization, BlueYonder integration is implemented with more than 40 interfaces in multiple phases
Data Engineering Manager, Data and Analytics Team
Infosys
08.2014 - 03.2021
- Company Overview: Client - Walmart
- Responsible for Managing Data and Analytics portfolio for Infosys with a revenue ~ 6 Mn USD for Walmart client account
- Produce request for proposal (RFP) responses and statement of work (SOW) while managing price, budget, and staffing needs
- Responsible for building Cloud Data lake solutions on GCP and Azure for Walmart Merchandising store and HR people systems LOBs
- Working on large and critical initiative of OMNI which is bringing ecom/dotcom and store data together which can be catered to applications like Pricing
- Responsible for building Acceleration and Data Visualization for Pricing and Replenishment applications using tools like Tableau, Alteryx, Looker, PowerBI and Druid
- Responsible for delivering multiple technology modernization initiatives for legacy Data platforms like DataStage upgrade enterprise wide
- Responsible for Vendor- Client relationship management
- Managing cross functional teams spread across geographies
- Challenging the teams on productivity improvement, Business value adds and latest technologies usage
- Responsible for building GCP BQ Data elements for Data Science requirements in Merch area
- Responsible for associate 360 platform for US HR people system LOB
- Implemented agile model of delivery for data solutions involving Data lakes and building visualizations platforms
- Responsible for implementing Business driven Data quality and regular data quality checks
- Managed BI tools platform administration team
- Client - Walmart
- Evaluated project requirements to identify and mitigate risks.
Technology Lead and Technology Analyst
Infosys
12.2009 - 07.2014
- Company Overview: Client - Walmart
- Led efforts in achieving yearly $6M in business value add (BVA) with one time investment of $1.2M for a Transportation and Logistics BI project for Walmart
- Formulated data model through evaluation of external data sources for Transportation and logistics BI solution for major US retailer Walmart
- Managed dimensional modeling, data migration, data cleansing, and extract, transform, and load (ETL) processes
- Used parallel jobs and multiple node configuration files in developing highly scalable processing infrastructure
- Built enterprise artifacts to support BI and data analytics including fact tables, transaction, periodic, accumulating, and snapshot; dimension tables and time variance approaches
- Involved in Data Model augmentations by following normalization (1NF, 2NF, 3NF)/ De normalization techniques for optimum performance in relational and dimensional database environments
- Created a successful implementation plan, project plan for migrating ~ 2900 DataStage jobs which are heavily reliant on cross platform jobs
- Provided multiple options for project operation, planned for agile deployment for quick turnaround to market
- Led the migration of training data from existing multiple legacy systems, such as SQL server, Informix, Excel source to Central learning domain as well as phased out all legacy training applications
- Performed unit, functional, system and integration, regression, UAT, and performance testing to successfully implement the project
- Responsible for establishing release management processes for GRS DataStage using tools like SVN, Github, Anthillpro and atomic
- Client - Walmart
Senior Software Engineer
Virtusa
07.2008 - 12.2009
- Company Overview: Client - CITI
- Developed DataStage ETL jobs for building a Datawarehouse on Customer service requested which catered to the reporting needs for middle management for a leading US Banking customer
- Developed Business Objects Universes, Webi and Deski reports to enable management stake holders Decision making for a leading US Banking customer
- Directed various features, which included query stripping, input controls, sub query, scope of analysis, and drill functionality
- Developed the data warehouse repository using DataStage Manager by importing the source and target database schemas
Education
Bachelor of Engineering -
Adhiyamaan College of Engineering
TN, India06-2004
Skills
- Design & Data Architecture
- Data Modeling
- Cloud & ETL Technologies - GCP
- Cloud Infrastructure (GCP & Azure)
- Data Exploration & Warehousing
- ETL Design and Architecture
- Python programming & Unix shell scripting
- Data Visualization (Tableau, Power BI)
- Data Stage, Informatica, Alteryx
- Reporting & Data Prep tools: Business Objects, Tableau, PowerBI
- Databases & Languages: DB2, Teradata, Oracle, SQL server, Informix
- Project Management & Strategic Planning
- Client Services and Relations
- Team Management & Budget Management
Technicalsummary
GCP, Azure, Data Stage, Informatica, Alteryx, Business Objects, Tableau, PowerBI, Alteryx, CPLEX, SPSS, DB2, Teradata, Oracle, SQL server, Informix, Unix shell scripting, Jenkins, GIT, SVN, AHP, Atomic, Jira, Confluence, Kanban
Professional Development
Scrum Alliance certified CSM, CSPO, Microsoft certified DP-200 Azure Data Solution, Certified IBM DataStage 8.5, Project Management – Information Technology
Awards and Recognition
Served as 'International Advisory Committee' at IEEE international conference on Augmented Reality, Intelligent systems and Industrial automation (ARIIA - 2024)
Contributed as 'Key Note Speaker' on AI & ML at t IEEE international conference on Augmented Reality, Intelligent systems and Industrial automation (ARIIA - 2024)
Member Of IEEE
Judge, Globee® Awards for Leadership 2024
2022 Digital and Technology Award, Macy’s Technology Inc: Recognized for leading the
successful launch of Macy’s online marketplace, exceeding holiday sales by +47%, and introducing 500+
new brands.
Recipient Spot Bonus Award, Commit to Win at Macy's Technology, for resilience, leadership, and drive for results in the Mck pricing analytics insourcing work. It was a huge undertaking for both EDA and the pricing team, with many complexities and expedited delivery timeline. Done a great job leading the data engineering work and collaborating with multiple functions in delivering the insourcing analytics which enables $1.2M savings annually.
Timeline
Tech Manager, Data Engineering
Macy's
03.2021 - Current
Data Engineering Manager, Data and Analytics Team
Infosys
08.2014 - 03.2021
Technology Lead and Technology Analyst
Infosys
12.2009 - 07.2014
Senior Software Engineer
Virtusa
07.2008 - 12.2009
Bachelor of Engineering -
Adhiyamaan College of Engineering
Similar Profiles
Celine GussinCeline Gussin
Asset Protection Officer at Macy'sAsset Protection Officer at Macy's
Victoria VinesVictoria Vines
Retail Customer Service Associate at Macy'sRetail Customer Service Associate at Macy's
Pratibha SinghPratibha Singh
SENIOR CUSTOMER SERVICE SPECIALIST at Macy'sSENIOR CUSTOMER SERVICE SPECIALIST at Macy's