Data Engineer Cloud

ASHISH TRIVEDI CLOUD DATA ENGINEER

**************@*******.*** Linkedin 443-***-****

Professional Summary

With over 14 years of comprehensive experience in ETL processes, business requirements analysis, applica=on design, development, implementa=on, and data warehousing, I leverage my analy=cal skills and management exper=se to drive organiza=onal success. My proven track record includes overseeing full project life cycles and specializing in Data Warehouses, Data Integra=on, and Data Engineering. Professional Experience

Cloud Data Engineer Sallie Mae Sterling, VA Sep/22 – Present

• Led the successful migra=on of 1,400 workflows from Informa=ca on-premises to Informa=ca Cloud. This migra=on op=mized data flow, eliminated on-premises dependency, and reduced licensing costs, aligning with Sallie Mae’s cloud migra=on vision.

• Iden=fied and addressed gaps in the ‘dialer’ module responsible for processing payer accounts, effec=vely mi=ga=ng compliance risks and enhancing opera=onal efficiency.

• Designed and developed a framework to automate the charge-off loan sales process, reducing manual effort and turnaround =me by 50%.

• Developed dynamic views in Snowflake to efficiently flaTen complex JSON files with dynamic nodes, significantly reducing manual interven=on and reinforcing data quality standards, saving 8 hours per week and improving overall system reliability. Environment: Informa=ca IDMC, PowerCenter10.5, Snowflake, Python, Unix, AWS (S3, Step func=ons, Lambda). Dev Lead Hexaware Inc/Parexel Boston, MA Jun /20 – Sep/22

• Led a team of five engineers in conver=ng clinical data from Oracle tables and u=lizing Informa=ca B2B Data Exchange (DX) to deliver files to Parexel vendors, successfully reducing turnaround =me by 4 hours per week.

• Developed a GUI tool using Python to streamline clinical study iden=fica=on across 1,000+ XML files, reducing 50 man-hours per quarter per vendor.

• Enhanced mapping performance through par==oning strategies, reducing run=me by 1 hour per cycle. Created reusable mapplets, leading to a 20% reduc=on in the number of Informa=ca mappings. Environment: Informatica 10.5/10.2, Informatica B2B Data Exchange (DX), Oracle, TortoiseSVN, Python. Sr. InformaIca Developer Mphasis/ J.P Morgan Chase Columbus, OH Sep /19 – June/20

• Spearheaded a cri=cal project to migrate data from PeopleSoe to Oracle tables, culmina=ng in the successful integra=on into Snowflake. This effort was pivotal in advancing the organiza=on’s transi=on to a cloud-based data warehouse solu=on.

• Enhanced ETL performance, reducing report processing =me by 12 hours per week, and automated workflows using Autosys, improving efficiency by 20%.

Environment: Informa=ca 10.4/10.2, Oracle, Snowflake, Autosys, Jules, Bitbucket, Unix. Lead ETL Developer Swank Tek Inc/ State Dept. of Maryland (DLLR) BalImore, MD Sep/17 – Sep/19

• Developed and executed strategic plans to modernize the unemployment insurance system by transi=oning from a legacy mainframe to a Data Warehouse, significantly reducing dependency on outdated technology.

• Built ETL transforma=ons to convert data from VSAM (Mainframe) to target systems, achieving a 25% gain in efficiency. Automated workflows with audit balancing jobs, reducing produc=on failures by 45%. Environment: Informa=ca 10.2, Microsoe SQL Server (2017), Informa=ca Power Exchange. ETL Developer Syntel Inc/ American Express Phoenix, AZ Mar/15 – Sep/17

• Engineered complex Informa=ca mappings for American Express’s rewards and rebate porjolio, implemen=ng Slowly Changing Dimension

(SCD) Types 2 and 3. This op=miza=on reduced report genera=on =me by 15%. Addi=onally, implemented reusable transforma=ons and mapplets, streamlining processes and reducing the total number of mappings by 30%.

• Analyzed source data using Informa=ca IDQ profiling tools before ETL design, reducing mapping development =me by 8 hours. Automated produc=on jobs with UNIX Shell scrip=ng and Informa=ca command, saving 10 hours of manual effort per week. Environment: Informa=ca 10.1, IDQ, Oracle, DB2, Netezza, Control-M, MicroStrategy, UNIX. Sr. Systems Engineer Infosys Ltd India/Phoenix, AZ Jul/10 – Mar/15

• Developed UNIX shell scripts to automate Informatica workflows, reducing manual effort by 40% and eliminating human error.

• Worked closely with business teams and SMEs to gather requirements and translate them into technical specifications for ETL design and development.

• Performed root cause analysis, monitored application performance, and regularly reviewed business-critical functions to enhance overall system performance.

Environment: Informa=ca 10.1, IDQ, Oracle, DB2, Netezza, Control-M, MicroStrategy, UNIX. Educa5on

B. Tech (InformaBon Technology), UTU, Dehradun, India (First Division with Honors).

Contact this candidate