Lakshmi Narayan Email & Phone Number

Chicago, IL, US

• Led a 12-person geographically distributed data engineering team in design and development of a highly scalable POS supply chain big data solution for Fortune 50 retailers using MapR Hadoop
• Designed Data Lake pipeline that ingested over 900 TB of data from 15 external sources that was used to support predictive modeling, machine learning, targeted marketing, and inventory logistics
• Collaborated directly with clients to understand business data requirements, owned resulting end-to-end solution (data cleansing, transformation, and ingestion into Hadoop Data Lake using HIVE SQL and UNIX/Python.
• Migrated multi-terabyte datasets from on-premise cluster to Snowflake on AWS
• Created Hadoop data model for raw, curated, intermediate, and reporting layers and influenced leadership to move from fair to capacity scheduler, improving job run time by 22%
• Tuned 25+ long-running critical HIVE queries, orchestrating a 60% reduction in execution time

Dublin 2, IE

• Deployed Hortonworks Hadoop analytics solution on Google Cloud Platform, including provisioning, managing, monitoring, and securing a 150-node cluster using Kerberos and Ranger
• Led a geographically distributed delivery team in bringing commercial policy data from Oracle database and external data sources into Hadoop Data Lake
• Ingested and transformed multi-terabyte external third-party data from credit bureau into Hadoop Data Lake and integrated with internal data to create nearshore analytic data stores for self-serve reports and analytics.
• Engineered complex HIVE SQL queries and transformations using ROWID pairs to pull records from Oracle database, achieving client recognition for 90% improvement in ingestion performance

• Client: Northern Trust Bank, Chicago, IL
• Directed a 20-person matrixed onshore/offshore team from multiple vendors on a Basel II compliance initiative mandated by the Federal Reserve, proactively resolving operational roadblocks and partnering with the.
• Managed loss given default (LGD) project from end-to-end, including short- and long-term prioritization, action plans, resource allocation, and hiring
• Owned creation of logical and physical data models (ER and dimension) using SAP PowerDesigner and data integration using IBM DataStage
• Created a proof-of-concept Hadoop cluster on AWS by ingesting internal (Oracle Data Warehouse) and third-party data which was transformed using HIVE SQL and UNIX shell scripts

• Client: Allstate Insurance, Chicago, IL
• Transformed and re-architected 40 mission-critical policy databases from DB2/400 to Oracle 11.2 using an Ab Initio ETL solution, and earned critical acclaim after turning around a multi-year failed project within five.
• Owned Ab Initio ETL solution and data migration including designing, building, testing, implementing, and maintaining operations based on requirements gathered from business users
• Developed Ab Initio graphs and UNIX shell scripts to transform and migrate data

• Client: Walgreens, Deerfield IL
• Led a multi-vendor team of 15 onshore & offshore resources in delivery of an Ab Initio ETL solution for pharmacy accounts receivables and medical billing projects by loading multi-terabytes of transformed data into.
• Fabricated high level ETL mapping and design document based on functional and technical requirements gathered through extensive collaboration with business users
• Optimized performance of SQL queries used by mission-critical online applications by 60%, freeing availability of system resources for other projects
• Improved performance of pharmacy accounts receivables Ab Initio batch process by 70%, maximizing application online availability that saved over $5M per month for the client

• Client: United Airlines, Elk Grove Village IL
• Led 9-person team in creation of sales data mart in enterprise data warehouse using Ab Initio on DB2, including data integration strategy with 10+ global booking and ticketing systems
• Owned global implementation of a web-based application used by international sales managers to track performance relative to goals
• Contributed to ER and dimension logical and physical data modeling and generated documentation (i.e. metadata, source to target mapping) using Erwin to track sales effectiveness