Headline

Senior Data Engineer | Business Intelligence

About

Senior IT Professional with expertise in architecting, designing and developing Data/Analytical Platforms (Data Lakes, Data Warehouse/Marts). ​ • Cloud: AWS (Glue, Lambda, Step Functions, IAM, SNS, Cloud Formation, Glue Crawlers, Cloud Watch) • Databases: Teradata, DB2 UDB, Oracle, Netezza, MS SQL Server, Sybase, • Big Data technologies: Hadoop, Spark, Hive, Sqoop, HBase, Yarn, MapReduce, HUDI • Programming: SQL, Python, UNIX Shell Scripting, PL/SQL, Perl, C, C++ • ETL Tools: Informatica Power Center & Big Data Management/DEI (DEV and ADMIN), Power Exchange, SSIS • Control M, Autosys, Airflow • BI Tools: Tableau, Actuate, Cognos and SAP Business Objects, Crystal Reports, SSRS • Operating Systems: Windows, UNIX, Mainframe • Configuration Management Tool: GIT, Serena PVCS, Microsoft Team Foundation Version Control • Mainframe skills: TSO, JCL,PL1, Teradata Unload/load utilities

Location

Costa Mesa

Work experience

Senior Data Engineer at Meta, Oct 2022 - Present · 3 yrs 9 mos, United States

Data and Analytics Technical Lead at Automobile Club of Southern California, Jan 2022 - Dec 2022 · 1 yr, Leading a team of data engineers, building cloud data platform for Insurance. Completed several POCs on GCP and AWS for figuring out best suitable architecture. Built insurance datalake using HUDI on AWS. Created fault tolerant and scalable data ingestion framework using Glue, Orchestrated using Step Functions. Created notification and alert framework using event bridge and SNS. Built CI/CD pipelines using GitHub integration , cloud formation, AWS code pipeline.

Senior Technical Consultant at Automobile Club of Southern California, Mar 2016 - Jan 2022 · 5 yrs 11 mos, - Designed and built data pipelines from end to end for numerous data domains (Insurance, HR, Actuarial, Calls, Payments etc.) - Architected Analytical solutions, Designed Data Models and Created several Report Data Marts and Data Lakes - Created technical roadmaps and prioritized engineering initiatives for a cross-functional team of analysts and engineers - Collaborated across the organization to achieve project goals. Technologies: Hadoop Ecosystem, Spark, SQL, Hive, HDFS, Sqoop, Python, UNIX, Teradata SQL and utilities, REST API integrations, GIT CI/CD, Informatica Suite.

Technical Consultant at Automobile Club of Southern California, Mar 2014 - Feb 2016 · 2 yrs, - Created ELT data pipelines and built EDW and Data Marts to support member retention and marketing efforts - Integrated 5 different quote systems data and built data mart in Teradata. - Managed Informatica environment and On-call Support

Technology Lead at Infosys, Feb 2012 - Mar 2014 · 2 yrs 2 mos, Client - Northwestern Mutual Worked in Sales Reporting, Investment Compensation, Compliance and Accounting teams • Created Informatica ETLs for building Sales Reporting EDW in Dimensional Model in DB2 UDW database. Took part in major product introductions Long Term Care, Sales Reporting Replatform projects • Built complex ETL logic to Cleanse, enrich, validate journal transactions for building Data Integration Hub. It enabled better Financial Reporting and Accounting • Tuned queries, Informatica Sessions to improve performance and meet SLAs. Reduced run times of batch by couple of hours in DI Hub by using Informatica partitioning and tuning Power Center jobs. • Led a team of 6 members in supporting Compliance Data Applications such as Personal Trade Assistant, Anti Money Laundering etc. • Delivered numerous DW solutions to various parts of organization by working closely with business analysts, user community. • Unix scripting for automation and perform housekeeping tasks.

Technology Analyst at Infosys, Jun 2006 - Jun 2012 · 6 yrs 1 mo

Education

Bachelor of Technology (B.Tech.), Electrical, Electronics and Communications Engineering, Jawaharlal Nehru Technological University