| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateASHISH TRIVEDI CLOUD DATA ENGINEEREMAIL AVAILABLE Linkedin PHONE NUMBER AVAILABLEProfessional SummaryWith 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 ExperienceCloud Data Engineer Sallie Mae Sterling, VA Sep/22 Present Led the successful migra=on of 1,400 workows from Informa=ca on-premises to Informa=ca Cloud. This migra=on op=mized data ow, eliminated on-premises dependency, and reduced licensing costs, aligning with Sallie Maes cloud migra=on vision. Iden=ed and addressed gaps in the dialer module responsible for processing payer accounts, eec=vely mi=ga=ng compliance risks and enhancing opera=onal eciency. Designed and developed a framework to automate the charge-o loan sales process, reducing manual eort and turnaround =me by 50%. Developed dynamic views in Snowake to eciently aTen complex JSON les with dynamic nodes, signicantly 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, Snowake, Python, Unix, AWS (S3, Step func=ons, Lambda). Dev Lead Hexaware Inc/Parexel Boston, MA Jun /20 Sep/22 Led a team of ve engineers in conver=ng clinical data from Oracle tables and u=lizing Informa=ca B2B Data Exchange (DX) to deliver les to Parexel vendors, successfully reducing turnaround =me by 4 hours per week. Developed a GUI tool using Python to streamline clinical study iden=ca=on across 1,000+ XML les, 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 Snowake. This eort was pivotal in advancing the organiza=ons transi=on to a cloud-based data warehouse solu=on. Enhanced ETL performance, reducing report processing =me by 12 hours per week, and automated workows using Autosys, improving eciency by 20%.Environment: Informa=ca 10.4/10.2, Oracle, Snowake, 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, signicantly reducing dependency on outdated technology. Built ETL transforma=ons to convert data from VSAM (Mainframe) to target systems, achieving a 25% gain in eciency. Automated workows 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 Expresss 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 proling 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 eort 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. Educa5onB. Tech (InformaBon Technology), UTU, Dehradun, India (First Division with Honors). |