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 scripts), and led team in conversion of scripts to PySpark and SparkSQL• 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 • Developed and evangelized best practices for data integration, ingestion, transformation, quality and standards, governance, backup, retention, and security strategies for the organization

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 by business users• 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 business to keep stakeholders up to date• 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 months, reducing migration time from 8 hours to 30 minutes• 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 Oracle enterprise data warehouses, achieving recognition for improvements to process and cycle times of applications that handled $60B+ in annual revenue• 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